//
// GET: /admin/AutoAlarm/
public ActionResult AutoAlarmGeneration()
{
var connStringName = (new SettingsFactory()).GetCustomerConnectionStringName(CurrentCity.Id);
AutoAlarmModel model = (new AutoAlarmFactory(connStringName)).GetAutoAlarmModel();
return(View(model));
}
public AutoAlarmModel GetAutoAlarmModel()
{
AutoAlarmModel model = new AutoAlarmModel();
model.LowBattPollInterval = PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.PollInterval") == null ? "" : PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.PollInterval").ValueText;
model.LowBattAlarmClearVolt = PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.AlarmClearVolt") == null ? "" : PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.AlarmClearVolt").ValueText;
model.LowBattCritLowBattVolt = PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.CritLowBattVolt") == null ? "" : PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.CritLowBattVolt").ValueText;
model.LowBattLowBattVolt = PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.LowBattVolt") == null ? "" : PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.LowBattVolt").ValueText;
model.LowBattSampleSinceHrs = PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.SampleSinceHrs") == null ? "" : PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.SampleSinceHrs").ValueText;
model.LowBattSsmVoltDiagType = PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.SsmVoltDiagType") == null ? "" : PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.LowBatt.SsmVoltDiagType").ValueText;
model.NoCommPollTime = PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.NoComm.PollTime") == null ? "" : PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText == "Databus.AutoAlarm.NoComm.PollTime").ValueText;
GetLowBattSsmVoltDiagTypes(model);
return(model);
}
public ActionResult AutoAlarmDetails(string CustomerID, string LowBattAlarmCodeMinor, string LowBattAlarmCodeMajor, string LowBattEnabledMeters, string NoCommAlarmCode, string NoCommEnabledMeters)
{
var connStringName = (new SettingsFactory()).GetCustomerConnectionStringName(CurrentCity.Id);
AutoAlarmModel model = new AutoAlarmModel();
model.CustomerIDText = CustomerID;
model.LowBattAlarmCodeMinor = LowBattAlarmCodeMinor;
model.LowBattAlarmCodeMinorEvents = (new AutoAlarmFactory(Session[Duncan.PEMS.Utilities.Constants.Security.ConnectionStringSessionVariableName].ToString())).GetLowBattAlarmCodeMinorEventCode(CustomerID, LowBattAlarmCodeMinor);
model.LowBattAlarmCodeMajor = LowBattAlarmCodeMajor;
model.LowBattAlarmCodeMajorEvents = (new AutoAlarmFactory(Session[Duncan.PEMS.Utilities.Constants.Security.ConnectionStringSessionVariableName].ToString())).GetLowBattAlarmCodeMajorEventCode(CustomerID, LowBattAlarmCodeMajor);
model.LowBattEnabledMeters = LowBattEnabledMeters;
model.NoCommAlarmCode = NoCommAlarmCode;
model.NoCommAlarmCodeEvents = (new AutoAlarmFactory(Session[Duncan.PEMS.Utilities.Constants.Security.ConnectionStringSessionVariableName].ToString())).GetNoCommAlarmCodeEventCode(CustomerID, NoCommAlarmCode);
model.NoCommEnabledMeters = NoCommEnabledMeters;
return(View(model));
}
public List <AutoAlarmModel> CustomerIDList()
{
var list = new List <AutoAlarmModel>();
var query = from customers in RbacEntities.CustomerProfiles
where customers.CustomerId > 0
select customers;
foreach (var customer in query)
{
if (customer.CustomerTypeId == (int)CustomerProfileType.Customer)
{
AutoAlarmModel obj = new AutoAlarmModel();
obj.CustomerID = customer.CustomerId;
list.Add(obj);
}
}
return(list);
}
protected void GetLowBattSsmVoltDiagTypes(AutoAlarmModel Model)
{
int value;
int.TryParse(Model.LowBattSsmVoltDiagType, out value);
List <int> types = new List <int> {
9, 10, 11, 12
};
Model.LowBattSsmVoltDiagTypes = (from MDT in PemsEntities.MeterDiagnosticTypes
where types.Contains(MDT.ID)
select new SelectListItemWrapper()
{
Selected = MDT.ID == value,
Text = MDT.DiagnosticDesc,
ValueInt = MDT.ID
}).ToList();
}
public List <AutoAlarmModel> CustomerIDListWithoutRP()
{
var list = new List <AutoAlarmModel>();
var query = from customers in RbacEntities.CustomerProfiles
where customers.CustomerId > 0
select customers;
foreach (var customer in query)
{
if (customer.CustomerTypeId == (int)CustomerProfileType.Customer)
{
var connStringName = (new SettingsFactory()).GetCustomerConnectionStringName(customer.CustomerId);
var text = "Databus.AutoAlarm.LowBatt.AlarmCodeMinor." + customer.CustomerId;
var ripcust = (new PEMEntities(connStringName)).RipnetProperties.FirstOrDefault(c => c.KeyText.Contains(text));
if (ripcust == null)
{
AutoAlarmModel obj = new AutoAlarmModel();
obj.CustomerID = customer.CustomerId;
list.Add(obj);
}
}
}
return(list);
}
public List <AutoAlarmModel> GetAutoAlarmCustomerList()
{
List <AutoAlarmModel> AutoAlarm = new List <AutoAlarmModel>();
int value;
var custlist = (from RP in PemsEntities.RipnetProperties
where RP.KeyText.Contains("Databus.AutoAlarm.LowBatt.AlarmCodeMinor")
select new AutoAlarmModel()
{
CustomerIDText = RP.KeyText
}).ToList();
foreach (var cust in custlist)
{
AutoAlarmModel obj = new AutoAlarmModel();
obj.CustomerIDText = cust.CustomerIDText.Substring(cust.CustomerIDText.LastIndexOf('.') + 1);// cust.CustomerID;
if (PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.LowBatt.AlarmCodeMinor." + obj.CustomerIDText)) == null)
{
obj.LowBattAlarmCodeMinor = "";
}
else
{
int.TryParse(PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.LowBatt.AlarmCodeMinor." + obj.CustomerIDText)).ValueText, out value);
var cust1 = (from e in PemsEntities.EventCodes
where e.EventCode1 == value
select new AutoAlarmModel()
{
CustomerIDText = e.EventDescVerbose + "(" + SqlFunctions.StringConvert((double)e.EventCode1) + ")",
}).FirstOrDefault();
obj.LowBattAlarmCodeMinor = cust1.CustomerIDText;// PemsEntities.EventCodes.FirstOrDefault(e => e.EventCode1 == value).EventDescVerbose;
}
if (PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.LowBatt.AlarmCodeMajor." + obj.CustomerIDText)) == null)
{
obj.LowBattAlarmCodeMajor = "";
}
else
{
int.TryParse(PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.LowBatt.AlarmCodeMajor." + obj.CustomerIDText)).ValueText, out value);
var cust1 = (from e in PemsEntities.EventCodes
where e.EventCode1 == value
select new AutoAlarmModel()
{
CustomerIDText = e.EventDescVerbose + "(" + SqlFunctions.StringConvert((double)e.EventCode1) + ")",
}).FirstOrDefault();
obj.LowBattAlarmCodeMajor = cust1.CustomerIDText;//PemsEntities.EventCodes.FirstOrDefault(e => e.EventCode1 == value).EventDescVerbose;
}
obj.LowBattEnabledMeters = PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.LowBatt.EnabledMeters." + obj.CustomerIDText)) == null ? "" : PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.LowBatt.EnabledMeters." + obj.CustomerIDText)).ValueText;
if (PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.NoComm.AlarmCode." + obj.CustomerIDText)) == null)
{
obj.NoCommAlarmCode = "";
}
else
{
int.TryParse(PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.NoComm.AlarmCode." + obj.CustomerIDText)).ValueText, out value);
var cust1 = (from e in PemsEntities.EventCodes
where e.EventCode1 == value
select new AutoAlarmModel()
{
CustomerIDText = e.EventDescVerbose + "(" + SqlFunctions.StringConvert((double)e.EventCode1) + ")",
}).FirstOrDefault();
obj.NoCommAlarmCode = cust1.CustomerIDText;//PemsEntities.EventCodes.FirstOrDefault(e => e.EventCode1 == value).EventDescVerbose;
}
obj.NoCommEnabledMeters = PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.NoComm.EnabledMeters." + obj.CustomerIDText)) == null ? "" : PemsEntities.RipnetProperties.FirstOrDefault(m => m.KeyText.Contains("Databus.AutoAlarm.NoComm.EnabledMeters." + obj.CustomerIDText)).ValueText;
AutoAlarm.Add(obj);
}
return(AutoAlarm);
}
