Handicap- og Ældreboliger

Error executing template "/Designs/bleau-solutionset/Paragraph/ContactNarrow.cshtml"
System.Exception: Cannot instantiate Organization with ID: 849 ---> System.Data.SqlClient.SqlException: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
   --- End of inner exception stack trace ---
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at DisPlay.DW.Models.Organization.ExecuteScalar(String sql)
   at DisPlay.DW.Models.Organization.GetStreet(String streetCode)
   at DisPlay.DW.Models.Organization..ctor(Int32 organizationId)
   at CompiledRazorTemplates.Dynamic.RazorEngine_bb96b203153f4faba43ae1265c9050d7.Execute() in D:\Dynamicweb.Net\www.gladsaxe.dk (DW9.x)\Files\Templates\Designs\bleau-solutionset\Paragraph\ContactNarrow.cshtml:line 126
   --- End of inner exception stack trace ---
   at CompiledRazorTemplates.Dynamic.RazorEngine_bb96b203153f4faba43ae1265c9050d7.Execute() in D:\Dynamicweb.Net\www.gladsaxe.dk (DW9.x)\Files\Templates\Designs\bleau-solutionset\Paragraph\ContactNarrow.cshtml:line 130
   at RazorEngine.Templating.TemplateBase.RazorEngine.Templating.ITemplate.Run(ExecuteContext context, TextWriter reader)
   at RazorEngine.Templating.RazorEngineService.RunCompile(ITemplateKey key, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag)
   at RazorEngine.Templating.RazorEngineServiceExtensions.<>c__DisplayClass16_0.b__0(TextWriter writer)
   at RazorEngine.Templating.RazorEngineServiceExtensions.WithWriter(Action`1 withWriter)
   at Dynamicweb.Rendering.Template.RenderRazorTemplate()


  1	@inherits RazorTemplateBase<RazorTemplateModel<Template>>
  2	
  3	@using System.Text
  4	@using CustomModules.GeneralFunctions
  5	@using DisPlay.DW.Models
  6	@using Dynamicweb.Rendering;
  7	@using Dynamicweb.Frontend;
  8	@using DisPlay.DW.Models;       @* don't delete this line, or you don't have intellisense on some classes!! *@
  9	@using TimeSpan = DisPlay.DW.Models.TimeSpan
 10	
 11	@functions {
 12	    private string GetPhoneNumbers()
 13	    {
 14	        var numbers = new StringBuilder();
 15	        
 16	        foreach (var phoneNumber in GetLoop("Item.OrganizationPhoneNumberList"))
 17	        {
 18	            numbers.Append(PhoneNumber.Format(phoneNumber.GetString("Item.OrganizationPhoneNumberList.PhoneNumber"))).Append("<br />");
 19	        }
 20	
 21	        return numbers.ToString();
 22	    }
 23	
 24	    private string GetContactManagerList()
 25	    {
 26	        return GetPersons(ContactPerson.Type.ManagerPerson, "Item.ContactManagerList", "Ledelse");
 27	    }
 28	
 29	    private string GetContactPersonList()
 30	    {
 31	        return GetPersons(ContactPerson.Type.ContactPerson, "Item.ContactPersonList", "Kontaktperson");
 32	    }
 33	    
 34	    private string GetPersons(ContactPerson.Type contactType, string personListName, string heading)
 35	    {
 36	        var output = new StringBuilder();
 37	        var phoneNumbers = new StringBuilder();
 38	
 39	        foreach (var p in GetLoop(personListName))
 40	        {
 41	            var person = new ContactPerson(contactType, p.GetInteger(personListName + ".Id"));
 42	
 43	            output.Append("<strong>" + person.Title + "</strong><br/>");
 44	            output.Append(person.FirstName).Append(" ").Append(person.LastName).Append("<br />");
 45	            
 46	            if (person.ShowEmail && !string.IsNullOrWhiteSpace(person.Email))
 47	            {
 48	                output.Append("<a href=\"mailto:").Append(person.Email).Append("\">").Append(person.Email).Append("</a>").Append("<br />");
 49	            }
 50	            if (person.ShowWorkPhone && !string.IsNullOrWhiteSpace(person.WorkPhone))
 51	            {
 52	                phoneNumbers.Append(person.WorkPhone).Append("<br />");
 53	            }
 54	            if (person.ShowMobilePhone && !string.IsNullOrWhiteSpace(person.MobilePhone))
 55	            {
 56	                phoneNumbers.Append(person.MobilePhone).Append("<br />");
 57	            }
 58	            if (person.ShowSharedPhone && !string.IsNullOrWhiteSpace(person.SharedPhone))
 59	            {
 60	                phoneNumbers.Append(person.SharedPhone).Append("<br />");
 61	            }
 62	
 63	            var phoneNumberOutput = phoneNumbers.ToString();
 64	
 65	            if (!string.IsNullOrEmpty(phoneNumberOutput))
 66	            {
 67	                output.Append("Telefon: ").Append(phoneNumberOutput).Append("<br/>");
 68	                phoneNumbers.Clear();
 69	            }
 70	        }
 71	
 72	        return output.ToString() == string.Empty ? string.Empty : "<h3>" + heading + "</h3>" + output;
 73	    }
 74	
 75	
 76	    private string GetTimeSpans(IEnumerable<TimeSpan> timeSpans)
 77	    {
 78	        var output = new StringBuilder();
 79	
 80	        foreach (var ts in timeSpans)
 81	        {
 82	            output.Append(System.Web.HttpUtility.UrlDecode(ts.FromDay));
 83	
 84	            if (ts.Closed)
 85	            {                
 86	                output.Append(": Lukket");
 87	            }
 88	            else
 89	            {
 90	                if (!string.IsNullOrEmpty(System.Web.HttpUtility.UrlDecode(ts.ToDay)))
 91	                {
 92	                    output.Append("-" + ts.ToDay);
 93	                }
 94	                
 95	                output.Append(": ");
 96	            
 97	                if(!string.IsNullOrEmpty(ts.FromHour))
 98	                {
 99	                    output.Append(ts.FromHour).Append(".").Append(ts.FromMinutes);
100	                }
101	            
102	                if(!string.IsNullOrEmpty(ts.ToHour))
103	                {
104	                    output.Append("-").Append(ts.ToHour).Append(".").Append(ts.ToMinutes);
105	                }
106	            }
107	            
108	            output.Append("<br/>");
109	        }
110	
111	        return output.ToString();
112	    }
113	}
114	
115	@{
116	    var orgUnitId = GetLoop("Item.Organization").Select(org => org.GetInteger("Item.Organization.Id")).FirstOrDefault();
117	
118	    if (orgUnitId == 0)
119	    {
120	        return;
121	    }
122	
123	    Organization orgUnit = null;
124		try
125		{
126			orgUnit = new Organization(orgUnitId);
127		}
128		catch (Exception ex)
129		{
130			throw new Exception("Cannot instantiate Organization with ID: " + orgUnitId.ToString(), ex);
131		}
132	
133	}
134	
135		<div class="col-xs-12 col-sm-6 col-md-6" style="padding-left:0">
136	              
137	              
138	        <h2>@orgUnit.Name</h2>
139	        <p>
140	            @if (GetBoolean("Item.ShowAddress"))
141	            {
142	                @orgUnit.Street<text>&nbsp;</text>@orgUnit.HouseNumber<br>
143	                @orgUnit.Zip<text>&nbsp;</text>@orgUnit.City<br>
144	            }
145	            @if (GetLoop("Item.OrganizationPhoneNumberList").Count > 0)
146	            {
147	                <text>Telefon: </text> @GetPhoneNumbers()
148	            }
149	            @if (GetBoolean("Item.ShowFaxNumber") && !string.IsNullOrWhiteSpace(orgUnit.Fax))
150	            {
151	                <text>Fax: </text>@PhoneNumber.Format(orgUnit.Fax)<br />
152	            }
153	            @if (GetBoolean("Item.ShowCvrNumber") && !string.IsNullOrWhiteSpace(orgUnit.CvrNumber))
154	            {
155	                <text>CVR-nummer: </text>@orgUnit.CvrNumber<br />
156	            }
157	            @if (GetBoolean("Item.ShowEanNumber") && !string.IsNullOrWhiteSpace(orgUnit.EanNumber))
158	            {
159	                <text>EAN-nummer: </text>@orgUnit.EanNumber<br />
160	            }
161	            @if (GetBoolean("Item.ShowEmail") && !string.IsNullOrWhiteSpace(orgUnit.Email))
162	            {
163	                if (GetGlobalValue("Global:Area.Name") == "kommunen")
164	                {
165	                    <a href="mailto:@orgUnit.Email">@orgUnit.Email</a><br />
166	                }
167	                else
168	                {
169	                    <a href="mailto:@orgUnit.Email" id="subsite">@orgUnit.Email</a><br />
170	                }
171	            }
172	            @if (GetBoolean("Item.ShowSendDigitalEmail") && !string.IsNullOrWhiteSpace(orgUnit.DigitalPostAddress))
173	            {
174	                <a href="@orgUnit.DigitalPostAddress">Send digital post</a><br />
175	            }
176	            @if (GetBoolean("Item.ShowUrlHomePage") && !string.IsNullOrWhiteSpace(orgUnit.HomepageUrl))
177	            {
178	                var url = SearchEngineFriendlyURLs.GetFriendlyUrl("/Default.aspx?ID=" + orgUnit.HomepageUrl);
179	
180	                <a href="@url">
181	                    @(orgUnit.HomepageText == "" ? orgUnit.HomepageUrl : orgUnit.HomepageText)
182	                </a><br />
183	            }
184	            @if (!string.IsNullOrWhiteSpace(orgUnit.Notes) && !string.IsNullOrWhiteSpace(orgUnit.Notes))
185	            {
186	                @orgUnit.Notes
187	            }
188	
189	        </p>
190	
191	          @{
192	              var openingHours = GetTimeSpans(orgUnit.OpeningHours);
193	              var phoneHours = GetTimeSpans(orgUnit.PhoneHours);
194	          }
195	
196	          @if (GetBoolean("Item.ShowOpenHours") && !string.IsNullOrWhiteSpace(openingHours))
197	          {
198	              <h3>Åbningstider</h3>
199	              <p>
200	                  @openingHours 
201	              </p>
202	          }
203	
204			  @if (GetBoolean("Item.ShowExtraText")){
205	              foreach (LoopItem i in GetLoop("Item.Organization")){
206	  
207	  				<h3>@i.GetString("Item.Organization.ExtraFieldHeadline")</h3>
208					<p>@i.GetString("Item.Organization.ExtraFieldText")</p>
209	              }
210	          }
211	
212	
213	          @if (GetBoolean("Item.ShowPhoneHours") && !string.IsNullOrWhiteSpace(phoneHours))
214	          {
215	              <h3>Telefontider</h3>
216	              <p>
217	                  @phoneHours
218	              </p>
219	          }
220	
221	
222				
223	
224	          @GetContactManagerList()
225	
226	          @GetContactPersonList()
227	
228	
229			<br /><br />
230	
231	      </div>