public string AddAutoAlarm(int CustomerID, string LowBattAlarmCodeMinor, string LowBattAlarmCodeMajor, string LowBattEnabledMeters, string NoCommAlarmCode, string NoCommEnabledMeters) { try { LowBattAlarmCodeMinor = LowBattAlarmCodeMinor.Substring(0, LowBattAlarmCodeMinor.IndexOf('(')); LowBattAlarmCodeMajor = LowBattAlarmCodeMajor.Substring(0, LowBattAlarmCodeMajor.IndexOf('(')); NoCommAlarmCode = NoCommAlarmCode.Substring(0, NoCommAlarmCode.IndexOf('(')); var text = "Databus.AutoAlarm.LowBatt.AlarmCodeMinor." + CustomerID; var ripcust = PemsEntities.RipnetProperties.FirstOrDefault(c => c.KeyText.Contains(text)); if (ripcust != null) { return("0"); } RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "Databus.AutoAlarm.LowBatt.AlarmCodeMinor." + CustomerID; DuncanProp.ValueText = PemsEntities.EventCodes.FirstOrDefault(e => e.EventDescVerbose == LowBattAlarmCodeMinor).EventCode1.ToString(); PemsEntities.RipnetProperties.Add(DuncanProp); PemsEntities.SaveChanges(); RipnetProperty DuncanProp1 = new RipnetProperty(); DuncanProp1.KeyText = "Databus.AutoAlarm.LowBatt.AlarmCodeMajor." + CustomerID; DuncanProp1.ValueText = PemsEntities.EventCodes.FirstOrDefault(e => e.EventDescVerbose == LowBattAlarmCodeMajor).EventCode1.ToString(); PemsEntities.RipnetProperties.Add(DuncanProp1); PemsEntities.SaveChanges(); RipnetProperty DuncanProp2 = new RipnetProperty(); DuncanProp2.KeyText = "Databus.AutoAlarm.LowBatt.EnabledMeters." + CustomerID; DuncanProp2.ValueText = LowBattEnabledMeters; PemsEntities.RipnetProperties.Add(DuncanProp2); PemsEntities.SaveChanges(); RipnetProperty DuncanProp3 = new RipnetProperty(); DuncanProp3.KeyText = "Databus.AutoAlarm.NoComm.AlarmCode." + CustomerID; DuncanProp3.ValueText = PemsEntities.EventCodes.FirstOrDefault(e => e.EventDescVerbose == NoCommAlarmCode).EventCode1.ToString(); PemsEntities.RipnetProperties.Add(DuncanProp3); PemsEntities.SaveChanges(); RipnetProperty DuncanProp4 = new RipnetProperty(); DuncanProp4.KeyText = "Databus.AutoAlarm.NoComm.EnabledMeters." + CustomerID; DuncanProp4.ValueText = NoCommEnabledMeters; PemsEntities.RipnetProperties.Add(DuncanProp4); PemsEntities.SaveChanges(); return("1"); } catch (Exception ex) { return("-1"); } }
/// <summary> ///Description:This method will save the data from addnewvendor.cshtml into PayByCellVendor table as well as RipnetProperty table ///Modified:Prita() /// </summary> /// <param name="VID"></param> /// <param name="VName"></param> /// <param name="CustID"></param> /// <param name="DuncanGriddata"></param> /// <param name="CustGriddata"></param> public void SaveVendorDetails(int VID, string VName, int CustID, DuncanPropertyModel[] DuncanGriddata, CustomerPropertyModel[] CustGriddata) { using (PEMEntities context = new PEMEntities()) { PayByCellVendor paybycell = new PayByCellVendor(); paybycell.VendorID = VID; paybycell.VendorName = VName; paybycell.CustomerID = (CustID); paybycell.CreatedBy = CustID; paybycell.CreatedOn = System.DateTime.Now; paybycell.DEPRECATE = true; context.PayByCellVendors.Add(paybycell); context.SaveChanges(); foreach (var item in DuncanGriddata) { if (item.KeyText != null) { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "paybycell.dp." + CustID + "." + VID + "." + item.KeyText; DuncanProp.ValueText = item.ValueText; context.RipnetProperties.Add(DuncanProp); context.SaveChanges(); } } foreach (var item2 in CustGriddata) { if (item2.KeyText != null) { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "paybycell.cp." + CustID + "." + VID + "." + item2.KeyText; DuncanProp.ValueText = item2.ValueText; context.RipnetProperties.Add(DuncanProp); context.SaveChanges(); } } } }
public void AddAdminLevelAutoAlarm(string LowBattPollInterval, string LowBattAlarmClearVolt, string LowBattCritLowBattVolt, string LowBattLowBattVolt, string LowBattSampleSinceHrs, string LowBattSsmVoltDiagType, string NoCommPollTime) { try { var ripprop = PemsEntities.RipnetProperties.FirstOrDefault(c => c.KeyText.Contains("Databus.AutoAlarm.EventSource")); if (ripprop != null) { ripprop.ValueText = "0"; //indicates meter PemsEntities.SaveChanges(); } else { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "Databus.AutoAlarm.EventSource"; DuncanProp.ValueText = "0"; //indicates meter PemsEntities.RipnetProperties.Add(DuncanProp); PemsEntities.SaveChanges(); } ripprop = PemsEntities.RipnetProperties.FirstOrDefault(c => c.KeyText.Contains("Databus.AutoAlarm.LowBatt.PollInterval")); if (ripprop != null) { ripprop.ValueText = LowBattPollInterval; //indicates meter PemsEntities.SaveChanges(); } else { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "Databus.AutoAlarm.LowBatt.PollInterval"; DuncanProp.ValueText = LowBattPollInterval; PemsEntities.RipnetProperties.Add(DuncanProp); PemsEntities.SaveChanges(); } ripprop = PemsEntities.RipnetProperties.FirstOrDefault(c => c.KeyText.Contains("Databus.AutoAlarm.LowBatt.AlarmClearVolt")); if (ripprop != null) { ripprop.ValueText = LowBattAlarmClearVolt; PemsEntities.SaveChanges(); } else { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "Databus.AutoAlarm.LowBatt.AlarmClearVolt"; DuncanProp.ValueText = LowBattAlarmClearVolt; PemsEntities.RipnetProperties.Add(DuncanProp); PemsEntities.SaveChanges(); } ripprop = PemsEntities.RipnetProperties.FirstOrDefault(c => c.KeyText.Contains("Databus.AutoAlarm.LowBatt.CritLowBattVolt")); if (ripprop != null) { ripprop.ValueText = LowBattCritLowBattVolt; PemsEntities.SaveChanges(); } else { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "Databus.AutoAlarm.LowBatt.CritLowBattVolt"; DuncanProp.ValueText = LowBattCritLowBattVolt; PemsEntities.RipnetProperties.Add(DuncanProp); PemsEntities.SaveChanges(); } ripprop = PemsEntities.RipnetProperties.FirstOrDefault(c => c.KeyText.Contains("Databus.AutoAlarm.LowBatt.LowBattVolt")); if (ripprop != null) { ripprop.ValueText = LowBattLowBattVolt; PemsEntities.SaveChanges(); } else { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "Databus.AutoAlarm.LowBatt.LowBattVolt"; DuncanProp.ValueText = LowBattLowBattVolt; PemsEntities.RipnetProperties.Add(DuncanProp); PemsEntities.SaveChanges(); } ripprop = PemsEntities.RipnetProperties.FirstOrDefault(c => c.KeyText.Contains("Databus.AutoAlarm.LowBatt.SampleSinceHrs")); if (ripprop != null) { ripprop.ValueText = LowBattSampleSinceHrs; PemsEntities.SaveChanges(); } else { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "Databus.AutoAlarm.LowBatt.SampleSinceHrs"; DuncanProp.ValueText = LowBattSampleSinceHrs; PemsEntities.RipnetProperties.Add(DuncanProp); PemsEntities.SaveChanges(); } ripprop = PemsEntities.RipnetProperties.FirstOrDefault(c => c.KeyText.Contains("Databus.AutoAlarm.LowBatt.SsmVoltDiagType")); if (ripprop != null) { ripprop.ValueText = LowBattSsmVoltDiagType; PemsEntities.SaveChanges(); } else { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "Databus.AutoAlarm.LowBatt.SsmVoltDiagType"; DuncanProp.ValueText = PemsEntities.MeterDiagnosticTypes.FirstOrDefault(e => e.DiagnosticDesc == LowBattSsmVoltDiagType).ID.ToString(); PemsEntities.RipnetProperties.Add(DuncanProp); PemsEntities.SaveChanges(); } ripprop = PemsEntities.RipnetProperties.FirstOrDefault(c => c.KeyText.Contains("Databus.AutoAlarm.NoComm.PollTime")); if (ripprop != null) { ripprop.ValueText = NoCommPollTime; PemsEntities.SaveChanges(); } else { RipnetProperty DuncanProp = new RipnetProperty(); DuncanProp.KeyText = "Databus.AutoAlarm.NoComm.PollTime"; DuncanProp.ValueText = NoCommPollTime; PemsEntities.RipnetProperties.Add(DuncanProp); PemsEntities.SaveChanges(); } } catch (Exception ex) { } }