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)
{
}
}
