private void StoreDeliverLog(string DeviceId, int DeviceAlertId, DeviceAlarmType AlertType, AlertDelivery ad) { try { ad.ToAddresses.ForEach(receivers => { Data.StoreData_ExecuteNonQuery(DataBase.Alert, CommandType.StoredProcedure, "A_StoreEmailLog", new SqlParameter[] { new SqlParameter("DeviceAlertId", DeviceAlertId), new SqlParameter("DeviceId", DeviceId), new SqlParameter("AlertType", AlertType), new SqlParameter("Email", receivers.ToAddress), new SqlParameter("EmailSubject", (ad.EmailContent != null) ? ad.EmailContent.Subject: string.Empty), new SqlParameter("EmailPlainText", (ad.EmailContent != null) ? ad.EmailContent.PlainText: string.Empty), new SqlParameter("EmailHtmlContent", (ad.EmailContent != null) ? ad.EmailContent.HtmlContent: string.Empty), new SqlParameter("SmsSubject", (ad.SmsContent != null) ?ad.SmsContent.Subject: string.Empty), new SqlParameter("SmsPlainText", (ad.SmsContent != null) ?ad.SmsContent.PlainText: string.Empty), new SqlParameter("MediumType", Convert.ToInt32(receivers.MediumType)), new SqlParameter("SentStatus", receivers.SentStatus.ToString()), new SqlParameter("ErrorMessage", receivers.ErrorMessage) }); }); } catch (Exception ex) { Console.WriteLine(ex); } }
public ActionResult Delete(int AlertId, DeviceAlarmType alertType) { // Delete Alerts switch (alertType) { case DeviceAlarmType.NormalAlarm: break; case DeviceAlarmType.PowerCutAlarm: break; case DeviceAlarmType.SOSAlarm: break; case DeviceAlarmType.SpeedAlarm: break; case DeviceAlarmType.BreakAlarm: break; case DeviceAlarmType.VibrationAlarm: break; case DeviceAlarmType.FenceAlarm: break; case DeviceAlarmType.MovingAlarm: break; case DeviceAlarmType.AccAlarm: break; case DeviceAlarmType.StopAlarm: break; case DeviceAlarmType.AcAlarm: break; case DeviceAlarmType.FenceOutAlarm: break; case DeviceAlarmType.FenceInAlarm: break; default: break; } return(Speed(0)); }
public List <AlertDetail> GetAvilableAlerts(DeviceAlarmType AlertType) { List <AlertDetail> list = new List <AlertDetail>(); try { List <SqlParameter> dbParams = new List <SqlParameter>(); if (AlertType != DeviceAlarmType.FenceAlarm) { dbParams.Add(new SqlParameter("AlertType", AlertType)); } DataTable alertsDt = Data.GetData(DataBase.Api, System.Data.CommandType.StoredProcedure, "Master_GetAvailableAlerts", dbParams.ToArray()); if (alertsDt != null && alertsDt.Rows.Count > 0) { alertsDt.AsEnumerable().ToList().ForEach(a => { if (AlertType == DeviceAlarmType.FenceAlarm) { DeviceAlarmType DbAlertType = (DeviceAlarmType)Enum.Parse(typeof(DeviceAlarmType), Convert.ToString(a["AlertType"])); if (DbAlertType == DeviceAlarmType.FenceInAlarm || DbAlertType == DeviceAlarmType.FenceOutAlarm) { list.Add(new AlertDetail() { Id = Convert.ToInt32(a["Id"]), Name = Convert.ToString(a["Name"]) }); } else { // Skip other than fence } } else { list.Add(new AlertDetail() { Id = Convert.ToInt32(a["Id"]), Name = Convert.ToString(a["Name"]) }); } }); } } catch (Exception ex) { } return(list); }
public static EmailContent GetEmailTemplateWithValues(DeviceAlarmType deviceAlarmType, object Model) { EmailContent ec = new EmailContent(); try { string FileNameToRead = string.Empty; string AlarmTypeStr = deviceAlarmType.ToString(); string fileContent = string.Empty; if (!EmailSubjectTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Email\" + AlarmTypeStr + @"Subject.txt"); EmailSubjectTemplate.Add(AlarmTypeStr, fileContent); } if (!EmailPlainTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Email\" + AlarmTypeStr + @"Plain.txt"); EmailPlainTemplate.Add(AlarmTypeStr, fileContent); } if (!EmailHtmlTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Email\" + AlarmTypeStr + @"Html.html"); EmailHtmlTemplate.Add(AlarmTypeStr, fileContent); } ec.Subject = EmailSubjectTemplate[AlarmTypeStr]; ec.PlainText = EmailPlainTemplate[AlarmTypeStr]; ec.HtmlContent = EmailHtmlTemplate[AlarmTypeStr]; ec.Subject = Engine.Razor.RunCompile(ec.Subject, AlarmTypeStr + "Subject", null, Model); ec.PlainText = Engine.Razor.RunCompile(ec.PlainText, AlarmTypeStr + "Plain", null, Model); ec.HtmlContent = Engine.Razor.RunCompile(ec.HtmlContent, AlarmTypeStr + "Html", null, Model); } catch (Exception ex) { Console.WriteLine(ex); } return ec; }
public static EmailContent GetEmailTemplateWithValues(DeviceAlarmType deviceAlarmType, object Model) { EmailContent ec = new EmailContent(); try { string FileNameToRead = string.Empty; string AlarmTypeStr = deviceAlarmType.ToString(); string fileContent = string.Empty; if (!EmailSubjectTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Email\" + AlarmTypeStr + @"Subject.txt"); EmailSubjectTemplate.Add(AlarmTypeStr, fileContent); } if (!EmailPlainTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Email\" + AlarmTypeStr + @"Plain.txt"); EmailPlainTemplate.Add(AlarmTypeStr, fileContent); } if (!EmailHtmlTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Email\" + AlarmTypeStr + @"Html.html"); EmailHtmlTemplate.Add(AlarmTypeStr, fileContent); } ec.Subject = EmailSubjectTemplate[AlarmTypeStr]; ec.PlainText = EmailPlainTemplate[AlarmTypeStr]; ec.HtmlContent = EmailHtmlTemplate[AlarmTypeStr]; ec.Subject = Engine.Razor.RunCompile(ec.Subject, AlarmTypeStr + "Subject", null, Model); ec.PlainText = Engine.Razor.RunCompile(ec.PlainText, AlarmTypeStr + "Plain", null, Model); ec.HtmlContent = Engine.Razor.RunCompile(ec.HtmlContent, AlarmTypeStr + "Html", null, Model); } catch (Exception ex) { Console.WriteLine(ex); } return(ec); }
public static SmsContent GetSmsTemplateWithValues(DeviceAlarmType deviceAlarmType, object Model) { SmsContent sc = new SmsContent(); try { string FileNameToRead = string.Empty; string AlarmTypeStr = deviceAlarmType.ToString(); string fileContent = string.Empty; if (!SmsSubjectTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Sms\" + AlarmTypeStr + @"Subject.txt"); SmsSubjectTemplate.Add(AlarmTypeStr, fileContent); } if (!SmsPlainTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Sms\" + AlarmTypeStr + @"Plain.txt"); SmsPlainTemplate.Add(AlarmTypeStr, fileContent); } sc.Subject = SmsSubjectTemplate[AlarmTypeStr]; sc.PlainText = SmsPlainTemplate[AlarmTypeStr]; sc.Subject = Engine.Razor.RunCompile(sc.Subject, AlarmTypeStr + "SmsSubject", null, Model); sc.PlainText = Engine.Razor.RunCompile(sc.PlainText, AlarmTypeStr + "SmsPlain", null, Model); } catch (Exception ex) { Console.WriteLine(ex); } return(sc); }
public List<AlertDetail> GetAvilableAlerts(DeviceAlarmType AlertType) { List<AlertDetail> list = new List<AlertDetail>(); try { List<SqlParameter> dbParams = new List<SqlParameter>(); if (AlertType != DeviceAlarmType.FenceAlarm) { dbParams.Add(new SqlParameter("AlertType", AlertType)); } DataTable alertsDt = Data.GetData(DataBase.Api, System.Data.CommandType.StoredProcedure, "Master_GetAvailableAlerts", dbParams.ToArray()); if (alertsDt != null && alertsDt.Rows.Count > 0) { alertsDt.AsEnumerable().ToList().ForEach(a => { if (AlertType == DeviceAlarmType.FenceAlarm) { DeviceAlarmType DbAlertType = (DeviceAlarmType)Enum.Parse(typeof(DeviceAlarmType), Convert.ToString(a["AlertType"])); if (DbAlertType == DeviceAlarmType.FenceInAlarm || DbAlertType == DeviceAlarmType.FenceOutAlarm) { list.Add(new AlertDetail() { Id = Convert.ToInt32(a["Id"]), Name = Convert.ToString(a["Name"]) }); } else { // Skip other than fence } } else { list.Add(new AlertDetail() { Id = Convert.ToInt32(a["Id"]), Name = Convert.ToString(a["Name"]) }); } }); } } catch (Exception ex) { } return list; }
private void StoreDeliverLog(string DeviceId, int DeviceAlertId, DeviceAlarmType AlertType, AlertDelivery ad) { try { ad.ToAddresses.ForEach(receivers => { Data.StoreData_ExecuteNonQuery(DataBase.Alert, CommandType.StoredProcedure, "A_StoreEmailLog", new SqlParameter[] { new SqlParameter("DeviceAlertId", DeviceAlertId), new SqlParameter("DeviceId", DeviceId), new SqlParameter("AlertType", AlertType), new SqlParameter("Email", receivers.ToAddress), new SqlParameter("EmailSubject", (ad.EmailContent != null) ? ad.EmailContent.Subject: string.Empty), new SqlParameter("EmailPlainText", (ad.EmailContent != null) ? ad.EmailContent.PlainText: string.Empty), new SqlParameter("EmailHtmlContent", (ad.EmailContent != null) ? ad.EmailContent.HtmlContent: string.Empty), new SqlParameter("SmsSubject", (ad.SmsContent!= null) ?ad.SmsContent.Subject: string.Empty), new SqlParameter("SmsPlainText", (ad.SmsContent!= null) ?ad.SmsContent.PlainText: string.Empty), new SqlParameter("MediumType", Convert.ToInt32(receivers.MediumType)), new SqlParameter("SentStatus", receivers.SentStatus.ToString()), new SqlParameter("ErrorMessage", receivers.ErrorMessage) }); }); } catch (Exception ex) { Console.WriteLine(ex); } }
public static SmsContent GetSmsTemplateWithValues(DeviceAlarmType deviceAlarmType, object Model) { SmsContent sc = new SmsContent(); try { string FileNameToRead = string.Empty; string AlarmTypeStr = deviceAlarmType.ToString(); string fileContent = string.Empty; if (!SmsSubjectTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Sms\" + AlarmTypeStr + @"Subject.txt"); SmsSubjectTemplate.Add(AlarmTypeStr, fileContent); } if (!SmsPlainTemplate.ContainsKey(AlarmTypeStr)) { fileContent = string.Empty; fileContent = System.IO.File.ReadAllText(@"Templates\Sms\" + AlarmTypeStr + @"Plain.txt"); SmsPlainTemplate.Add(AlarmTypeStr, fileContent); } sc.Subject = SmsSubjectTemplate[AlarmTypeStr]; sc.PlainText = SmsPlainTemplate[AlarmTypeStr]; sc.Subject = Engine.Razor.RunCompile(sc.Subject, AlarmTypeStr + "SmsSubject", null, Model); sc.PlainText = Engine.Razor.RunCompile(sc.PlainText, AlarmTypeStr + "SmsPlain", null, Model); } catch (Exception ex) { Console.WriteLine(ex); } return sc; }
public ActionResult Delete(int AlertId, DeviceAlarmType alertType) { // Delete Alerts switch (alertType) { case DeviceAlarmType.NormalAlarm: break; case DeviceAlarmType.PowerCutAlarm: break; case DeviceAlarmType.SOSAlarm: break; case DeviceAlarmType.SpeedAlarm: break; case DeviceAlarmType.BreakAlarm: break; case DeviceAlarmType.VibrationAlarm: break; case DeviceAlarmType.FenceAlarm: break; case DeviceAlarmType.MovingAlarm: break; case DeviceAlarmType.AccAlarm: break; case DeviceAlarmType.StopAlarm: break; case DeviceAlarmType.AcAlarm: break; case DeviceAlarmType.FenceOutAlarm: break; case DeviceAlarmType.FenceInAlarm: break; default: break; } return Speed(0); }