public ActionResult AddPlant(Plant plant)
{
try
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.AddPlant("INSERT", Session["UserID"].ToString(), plant.PlantID, plant.PlantName, plant.Address, plant.ContactNo, plant.FaxNo, plant.Website, plant.PlantDetails, Convert.ToInt32(plant.NumberOfArea), Session["UserRole"].ToString());
if (i > 0)
{
return(RedirectToAction("PlantIndex"));
}
var list = new System.Collections.Generic.List <Object> {
"1',2"
};
}
return(RedirectToAction("PlantIndex"));
}
else
{
ModelState.AddModelError("", "Fill all fields correctly !");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("PlantIndex"));
}
public ActionResult EditPoint(Point point)
{
try
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.AddPoint("UPDATE", Session["UserID"].ToString(), Session["SelectedNodeID"].ToString(), point.PointName, point.PointDetails, point.NoOfSensors, Session["UserRole"].ToString(), point.ParentID);
if (i > 0)
{
return(RedirectToAction("PlantIndex"));
}
}
return(RedirectToAction("PlantIndex"));
}
else
{
ModelState.AddModelError("", "Your data is not changed successfully! Please try again.");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("PlantIndex"));
}
public ActionResult Register(UserRegister register)
{
if (ModelState.IsValid)
{
try
{
using (SmartMonitoringEntities dbcontext = new SmartMonitoringEntities())
{
int i = dbcontext.AddUser(register.FirstName, register.LastName, register.MiddleName, register.UserName, register.Password, register.UserRole, register.PhoneNo, register.FaxNo, register.CompanyName, register.Designation, register.Department, register.EmailID, false);
dbcontext.SaveChanges();
if (i > 0)
{
WebSecurity.CreateUserAndAccount(register.UserName, register.Password);
WebSecurity.Login(register.UserName, register.Password);
}
}
return(RedirectToAction("Login", "User"));
}
catch (Exception ex)
{
throw ex;
}
}
else
{
}
return(View(register));
}
public ActionResult EditTrain(Train train)
{
try
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.AddTrain("UPDATE", Session["UserID"].ToString(), Session["SelectedNodeID"].ToString(), train.TrainName, train.NumberOfMachines, train.DriveUnitName, train.IntermediateUnitName, train.DrivenUnitName, Session["UserRole"].ToString(), train.ParentID);
if (i > 0)
{
return(RedirectToAction("PlantIndex"));
}
}
return(RedirectToAction("PlantIndex"));
}
else
{
ModelState.AddModelError("", "Your data is not changed successfully! Please try again.");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("PlantIndex"));
}
public ActionResult EditMachine(Machine machine)
{
try
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.AddMachine("UPDATE", Session["UserID"].ToString(), Session["SelectedNodeID"].ToString(), machine.MachineName, machine.MachineDetails, machine.RPMDriven, machine.PulseRevolution, machine.machineImage, Session["UserRole"].ToString(), machine.ParentID);
if (i > 0)
{
return(RedirectToAction("PlantIndex"));
}
}
return(RedirectToAction("PlantIndex"));
}
else
{
ModelState.AddModelError("", "Your data is not changed successfully! Please try again.");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("PlantIndex"));
}
public ActionResult EditArea(Area area)
{
try
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.AddArea("UPDATE", Session["UserID"].ToString(), Session["SelectedNodeID"].ToString(), area.AreaName, area.AreaDetail, area.NumberOfTrains, Session["UserRole"].ToString(), area.ParentID);
if (i > 0)
{
return(RedirectToAction("PlantIndex"));
}
}
return(RedirectToAction("PlantIndex"));
}
else
{
ModelState.AddModelError("", "Your data is not changed successfully! Please try again.");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("PlantIndex"));
}
public ActionResult AddTrain(Train train, FormCollection form)
{
try
{
if (ModelState.IsValid)
{
string paranetid = form["parentid"];
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.AddTrain("INSERT", Session["UserID"].ToString(), train.TrainID, train.TrainName, train.NumberOfMachines, train.DriveUnitName, train.IntermediateUnitName, train.DrivenUnitName, Session["UserRole"].ToString(), paranetid);
if (i > 0)
{
return(RedirectToAction("PlantIndex"));
}
var list = new System.Collections.Generic.List <Object> {
"1',2"
};
}
return(RedirectToAction("PlantIndex"));
}
else
{
ModelState.AddModelError("", "Fill all fields correctly !");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("PlantIndex"));
}
public ActionResult EditPlant(Plant plant)
{
try
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.UpdatePlant(Session["UserID"].ToString(), Session["SelectedNodeID"].ToString(), plant.PlantName, plant.Address, plant.ContactNo, plant.FaxNo, plant.Website, plant.PlantDetails, Convert.ToInt32(plant.NumberOfArea), Session["UserRole"].ToString());
if (i > 0)
{
return(RedirectToAction("PlantIndex"));
}
}
return(RedirectToAction("PlantIndex"));
}
else
{
ModelState.AddModelError("", "Your data is not changed successfully! Please try again.");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("PlantIndex"));
}
public JsonResult CreateTreeView()
{
List <TreeViewModel> TreeList = new List <TreeViewModel>();
try
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var plantData = context.GetAllPlantDetail(Session["UserID"].ToString()).ToList();
ViewBag.NodeCount = plantData.Count;
foreach (var node in plantData)
{
TreeList.Add(new TreeViewModel
{
id = node.NodeID,
text = node.NodeText,
parent = node.ParentID
});
}
}
}
catch (Exception e)
{
throw e;
}
return(Json(TreeList, "True", JsonRequestBehavior.AllowGet));
//return new JsonResult { Data = new { TreeList }, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public ActionResult AddMachine(Machine machine, FormCollection form)
{
try
{
if (ModelState.IsValid)
{
string parentid = form["parentid"];
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.AddMachine("INSERT", Session["UserID"].ToString(), machine.MachineID, machine.MachineName, machine.MachineDetails, machine.RPMDriven, machine.PulseRevolution, machine.machineImage, Session["UserRole"].ToString(), parentid);
if (i > 0)
{
return(RedirectToAction("PlantIndex"));
}
var list = new System.Collections.Generic.List <Object> {
"1',2"
};
}
return(RedirectToAction("PlantIndex"));
}
else
{
ModelState.AddModelError("", "Fill all fields correctly !");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("PlantIndex"));
}
public ActionResult AddPoint(Point point, FormCollection form)
{
try
{
if (ModelState.IsValid)
{
string parentid = form["parentid"];
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.AddPoint("INSERT", Session["UserID"].ToString(), point.PointID, point.PointName, point.PointDetails, point.NoOfSensors, Session["UserRole"].ToString(), parentid);
if (i > 0)
{
return(RedirectToAction("PlantIndex"));
}
var list = new System.Collections.Generic.List <Object> {
"1',2"
};
}
return(RedirectToAction("PlantIndex"));
}
else
{
ModelState.AddModelError("", "Fill all fields correctly !");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("PlantIndex"));
}
public ActionResult updateUserProfile(UserRegister user)
{
try
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var userDetail = context.getUserDetail(Convert.ToString(Session["UserID"]));
{
int i = context.updateUserProfile(Session["UserID"].ToString(), user.FirstName, user.LastName, user.MiddleName, user.UserRole, user.PhoneNo, user.FaxNo, user.CompanyName, user.Designation, user.Department, user.EmailID, user.UserStatus);
if (i > 0)
{
return(RedirectToAction("UserProfile"));
}
}
}
return(RedirectToAction("UserProfile"));
}
else
{
ModelState.AddModelError("", "Your data is not changed successfully! Please try again.");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("UserProfile"));
}
public ActionResult Login(UserLogin login)
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities dbcontext = new SmartMonitoringEntities())
{
ObjectParameter objParam = new ObjectParameter("UserStatus", typeof(Boolean));
var loginInfo = dbcontext.CheckUserForLogin(login.LoginID, login.Password, objParam).ToList();
if (loginInfo.Count > 0)
{
foreach (var item in loginInfo)
{
Session["LoginID"] = Convert.ToString(item.LoginID);
Session["UserName"] = Convert.ToString(item.FirstName);
Session["UserRole"] = Convert.ToString(item.UserRole);
Session["UserStatus"] = Convert.ToBoolean(item.UserStatus);
Session["UserID"] = item.UserID;
WebSecurity.Login(item.LoginID, login.Password, persistCookie: login.RememberMe);
bool sts = WebSecurity.IsAuthenticated;
}
return(RedirectToAction("PlantIndex", "Plant"));
}
else
{
ModelState.AddModelError("Your account has not been activate yet. Please contact sdrvice provider !", "UnAuthorizedUser");
}
}
}
else
{
ModelState.AddModelError("Please enter correct loginID or Password !", "Validation");
}
return(View(login));
}
public ActionResult UserProfile()
{
UserRegister user = new UserRegister();
try
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var userDetail = context.getUserDetail(Convert.ToString(Session["UserID"]));
foreach (var item in userDetail)
{
user.FirstName = item.FirstName;
user.MiddleName = item.MiddleName;
user.LastName = item.Lastname;
user.PhoneNo = item.PhoneNo;
user.FaxNo = item.FaxNo;
user.CompanyName = item.Companyname;
user.Designation = item.Designation;
user.Department = item.Department;
user.EmailID = item.EmailID;
user.UserStatus = item.UserStatus;
}
return(View(user));
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <RecordedData> GetRecordDataForPoint(string NodeID)
{
List <RecordedData> RecordedData = new List <RecordedData>();
List <RecordedData> sensorList = new List <RecordedData>();
TempData["SensorsCount"] = 0;
try
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var AllrecordedData = context.GetRecordedTimeByPointID(NodeID).ToList();
sensorList.Add(new RecordedData
{
SensorName1 = AllrecordedData[0].OverallSensor1,
SensorName2 = AllrecordedData[0].OverallSensor2,
SensorName3 = AllrecordedData[0].OverallSensor3,
SensorName4 = AllrecordedData[0].OverallSensor4,
SensorName5 = AllrecordedData[0].OverallSensor5,
SensorName6 = AllrecordedData[0].OverallSensor6,
SensorName7 = AllrecordedData[0].OverallSensor7,
SensorName8 = AllrecordedData[0].OverallSensor8
});
ViewBag.SensorList = sensorList;
foreach (var records in AllrecordedData)
{
int recordid = records.RecordID;
DateTime recordtime = records.RecordedTime;
var OverallData = context.GetOverallByRecordID(recordid, NodeID).ToList();
TempData["SensorsCount"] = OverallData.Count;
foreach (var overall in OverallData)
{
RecordedData.Add(new RecordedData
{
TimeStamp = recordtime,
ParentID = overall.ParentID,
SensorID = overall.SensorID,
OverAllValue = overall.Overallvalue
});
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(RecordedData);
}
public ActionResult ResetPassword(ResetPasswordViewModel model)
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
int i = context.ResetCurrentPassword(model.UserID, model.CurrentPassword, model.NewPassword);
if (i > 0)
{
WebSecurity.ChangePassword(Session["UserName"].ToString(), model.CurrentPassword.ToString(), model.NewPassword.ToString());
}
else
{
}
return(View());
}
}
return(View());
}
public ActionResult PlantDetail1(Plant plant, FormCollection form)
{
try
{
if (ModelState.IsValid)
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
}
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Fill all fields correctly !");
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("Index"));
}
public List <RecordedData> GetSensorDetailForPoint(string NodeID)
{
List <RecordedData> sensorData = new List <RecordedData>();
try
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var AllSensors = context.GetAllSensorsByPointIDNew(NodeID).ToList();
string[] SensorList = new string[AllSensors.Count];
int str = 0;
foreach (var sensors in AllSensors)
{
SensorList[str] = sensors.SensorName;
var RecordedData = context.GetRecordedDataBuSensorID(sensors.SensorID).ToList();
float[] OverAllList = new float[RecordedData.Count];
int rtr = 0;
foreach (var data in RecordedData)
{
//OverAllList[rtr] = (float)data.OverallValue;
//sensorData.Add(new RecordedData
//{
// SensorID = data.SensorID,
// // TimeStamp = Convert.ToString(data.RecordTime),
// OverAllValue = (float)data.OverallValue,
// OverAllUnit = data.OverallDataUnit
//});
//rtr++;
}
str++;
}
}
}
catch { }
return(sensorData);
}
public int GetAlarmForNode(double recordData, string SensorID, int alarmID)
{
int i = 0;
double HighValue, LowValue;
try
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var Alarmdata = context.GetAlarmData(Convert.ToInt32(alarmID)).ToList();
foreach (var alarm in Alarmdata)
{
LowValue = Convert.ToDouble(alarm.AlarmValue_Low);
HighValue = Convert.ToDouble(alarm.AlarmValue_High);
if (recordData > HighValue)
{
i = 2;
}
else if (recordData > LowValue)
{
i = 1;
}
else
{
i = 0;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(i);
}
public ArrayList GetAreasForPlant(string NodeType, string NodeID)
{
ArrayList areas = new ArrayList();
ArrayList TrainList = new ArrayList();
int i = 0;
int Counter = 0;
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var AllArea = context.GetAreaByPlantID(NodeID).ToList();
string[] areaID = new string[AllArea.Count];
string[] areaName = new string[AllArea.Count];
int[] AlarmFlag = new int[AllArea.Count()];
foreach (var area in AllArea)
{
string Areaid = area.AreaID;
var AllSensors = context.GetAllSensorsByAreaID(Areaid).ToList();
int token = 0;
foreach (var sensors in AllSensors)
{
var RecordedDataforAreas = context.GetSensorAvgOverallValueForArea(sensors.SensorID).ToList();
float avgValue = 0;
int alarmID = 0, ctr = 0;
foreach (var value1 in RecordedDataforAreas)
{
avgValue += (float)(value1.OverallValue);
alarmID = (int)(value1.AlarmID);
ctr++;
}
avgValue = avgValue / RecordedDataforAreas.Count;
i = GetAlarmForNode(Convert.ToDouble(avgValue), sensors.SensorID, alarmID);
if (i == 2)
{
token = 2;
break;
}
else if (i == 1)
{
token = 1;
}
}
if (token == 2)
{
areaID[Counter] = area.AreaID;
areaName[Counter] = area.AreaName;
AlarmFlag[Counter] = token;
Counter++;
}
else if (token == 1)
{
areaID[Counter] = area.AreaID;
areaName[Counter] = area.AreaName;
AlarmFlag[Counter] = token;
Counter++;
}
else if (token == 0)
{
areaID[Counter] = area.AreaID;
areaName[Counter] = area.AreaName;
AlarmFlag[Counter] = token;
Counter++;
}
}
areas.Add(areaID);
areas.Add(areaName);
areas.Add(AlarmFlag);
}
return(areas);
}
public ArrayList GetMachinesForTrain(string NodeType, string NodeID)
{
ArrayList machines = new ArrayList();
int i = 0;
int Counter = 0;
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var AllMachines = context.GetMachineByTrainID(NodeID).ToList();
string[] machineID = new string[AllMachines.Count];
string[] machineName = new string[AllMachines.Count];
int[] AlarmFlag = new int[AllMachines.Count()];
foreach (var machine in AllMachines)
{
string Machineid = machine.MachineID;
var AllSensors = context.GetAllSensorsByMachineID(Machineid).ToList();
int token = 0;
foreach (var sensors in AllSensors)
{
var RecordedDataforMachines = context.GetSensorAvgOverallValueForMachine(sensors.SensorID).ToList();
float avgValue = 0;
int alarmID = 0;
foreach (var machineVal in RecordedDataforMachines)
{
avgValue += (float)(machineVal.OverallValue);
alarmID = (int)(machineVal.AlarmID);
}
avgValue = avgValue / RecordedDataforMachines.Count;
i = GetAlarmForNode(Convert.ToDouble(avgValue), sensors.SensorID, alarmID);
if (i == 2)
{
token = 2;
break;
}
else if (i == 1)
{
token = 1;
}
}
if (token == 2)
{
machineID[Counter] = machine.MachineID;
machineName[Counter] = machine.MachineName;
AlarmFlag[Counter] = token;
Counter++;
}
else if (token == 1)
{
machineID[Counter] = machine.MachineID;
machineName[Counter] = machine.MachineName;
AlarmFlag[Counter] = token;
Counter++;
}
else if (token == 0)
{
machineID[Counter] = machine.MachineID;
machineName[Counter] = machine.MachineName;
AlarmFlag[Counter] = token;
Counter++;
}
}
machines.Add(machineID);
machines.Add(machineName);
machines.Add(AlarmFlag);
}
return(machines);
}
public ActionResult PlantDetail(string nodeid)
{
Plant plant = new Plant();
try
{
int row;
int a = getIndexofNumber(nodeid);
string NodeNumber = nodeid.Substring(a, nodeid.Length - a);
row = Convert.ToInt32(NodeNumber);
string NodeType = nodeid.Substring(0, a);
switch (NodeType)
{
case "Plant":
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var plantRecord = context.GetPlant(nodeid).ToList();
if (plantRecord.Count() > 0)
{
foreach (var plantitem in plantRecord)
{
plant.PlantID = plantitem.PlantID;
plant.PlantName = plantitem.PlantName;
plant.Address = plantitem.Address;
plant.ContactNo = plantitem.ContactNo;
plant.FaxNo = plantitem.FaxNo;
plant.Website = plantitem.Website;
plant.PlantDetails = plantitem.PlantDetails;
plant.NumberOfArea = plantitem.NoOfArea;
Session["SelectedNodeID"] = plantitem.PlantID;
}
return(PartialView("_PlantDetail", plant));
}
else
{
TempData["NodeAvailability"] = "There is no any 'Plant' for display ! Please click on 'Add New Plant' button for create new 'Plant'.";
return(PartialView("_PlantDetail", plant));
}
}
}
case "Area":
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
Area area = new Area();
var areaRecord = context.GetArea(nodeid).ToList();
if (areaRecord.Count() > 0)
{
foreach (var areaitem in areaRecord)
{
area.AreaID = areaitem.AreaID;
area.AreaName = areaitem.AreaName;
area.AreaDetail = areaitem.AreaDetail;
area.NumberOfTrains = areaitem.NumberOfTrains;
Session["SelectedNodeID"] = areaitem.AreaID;
}
return(PartialView("_AreaDetail", area));
}
else
{
TempData["NodeAvailability"] = "There is no any 'Plant' for display ! Please click on 'Add New Plant' button for create new 'Plant'.";
return(PartialView("_AreaDetail", area));
}
}
}
case "Train":
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
Train train = new Train();
var trainRecord = context.GetTrain(nodeid).ToList();
if (trainRecord.Count() > 0)
{
foreach (var trainitem in trainRecord)
{
train.TrainID = trainitem.TrainID;
train.TrainName = trainitem.TrainName;
train.NumberOfMachines = trainitem.NumberOfMachines;
train.DriveUnitName = trainitem.DriveUnitName;
train.DrivenUnitName = trainitem.DrivenUnitName;
train.IntermediateUnitName = trainitem.IntermediateUnitName;
Session["SelectedNodeID"] = trainitem.TrainID;
}
return(PartialView("_TrainDetail", train));
}
else
{
TempData["NodeAvailability"] = "There is no any 'Train' for display ! Please click on 'Add New Plant' button for create new 'Plant'.";
return(PartialView("_TrainDetail", train));
}
}
}
case "Machine":
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
Machine machine = new Machine();
var machineRecord = context.GetMachine(nodeid).ToList();
if (machineRecord.Count() > 0)
{
foreach (var machineitem in machineRecord)
{
machine.MachineID = machineitem.MachineID;
machine.MachineName = machineitem.MachineName;
machine.MachineDetails = machineitem.MachineDetails;
machine.RPMDriven = Convert.ToInt32(machineitem.RPMDriven);
machine.PulseRevolution = Convert.ToInt32(machineitem.PulseRevolution);
Session["SelectedNodeID"] = machineitem.MachineID;
}
return(PartialView("_MachineDetail", machine));
}
else
{
TempData["NodeAvailability"] = "There is no any 'Plant' for display ! Please click on 'Add New Plant' button for create new 'Plant'.";
return(PartialView("_MachineDetail", machine));
}
}
}
case "Point":
{
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
Point point = new Point();
var pointRecord = context.GetPoint(nodeid).ToList();
if (pointRecord.Count() > 0)
{
foreach (var pointitem in pointRecord)
{
point.PointID = pointitem.PointID;
point.PointName = pointitem.PointName;
point.PointDetails = pointitem.PointDetails;
point.NoOfSensors = pointitem.NoOfSensors;
Session["SelectedNodeID"] = pointitem.PointID;
}
return(PartialView("_PointDetails", point));
}
else
{
TempData["NodeAvailability"] = "There is no any 'Plant' for display ! Please click on 'Add New Plant' button for create new 'Plant'.";
return(PartialView("_PointDetails", point));
}
}
}
default:
{
return(PartialView("_PlantDetail", plant));
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public ArrayList GetTrainForArea(string NodeType, string NodeID)
{
ArrayList trains = new ArrayList();
int i = 0;
int Counter = 0;
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var AllTrains = context.GetTrainByAreaID(NodeID).ToList();
if (AllTrains.Count > 0)
{
string[] trainID = new string[AllTrains.Count];
string[] trainName = new string[AllTrains.Count];
int[] AlarmFlag = new int[AllTrains.Count()];
foreach (var train in AllTrains)
{
string Trainid = train.TrainID;
var AllSensors = context.GetAllSensorsByTrainID(Trainid).ToList();
int token = 0;
foreach (var sensors in AllSensors)
{
var RecordedDataforTrains = context.GetSensorAvgOverallValueForTrain(sensors.SensorID).ToList();
float avgValue = 0;
int alarmID = 0;
foreach (var trainsVal in RecordedDataforTrains)
{
avgValue += (float)(trainsVal.OverallValue);
alarmID = (int)(trainsVal.AlarmID);
}
avgValue = avgValue / RecordedDataforTrains.Count;
i = GetAlarmForNode(Convert.ToDouble(avgValue), sensors.SensorID, alarmID);
if (i == 2)
{
token = 2;
break;
}
else if (i == 1)
{
token = 1;
}
}
if (token == 2)
{
trainID[Counter] = train.TrainID;
trainName[Counter] = train.TrainName;
AlarmFlag[Counter] = token;
Counter++;
}
else if (token == 1)
{
trainID[Counter] = train.TrainID;
trainName[Counter] = train.TrainName;
AlarmFlag[Counter] = token;
Counter++;
}
else if (token == 0)
{
trainID[Counter] = train.TrainID;
trainName[Counter] = train.TrainName;
AlarmFlag[Counter] = token;
Counter++;
}
}
trains.Add(trainID);
trains.Add(trainName);
trains.Add(AlarmFlag);
}
}
return(trains);
}
public ArrayList GetPointsForMachine(string NodeType, string NodeID)
{
ArrayList points = new ArrayList();
int i = 0;
int Counter = 0;
using (SmartMonitoringEntities context = new SmartMonitoringEntities())
{
var AllPoints = context.GetPointByMachineID(NodeID).ToList();
string[] pointID = new string[AllPoints.Count];
string[] pointName = new string[AllPoints.Count];
int[] AlarmFlag = new int[AllPoints.Count()];
foreach (var point in AllPoints)
{
string Pointid = point.PointID;
var AllSensors = context.GetAllSensorsByPointID(Pointid).ToList();
int token = 0;
foreach (var sensors in AllSensors)
{
var RecordedDataforPoints = context.GetSensorAvgOverallValueForPoint(sensors.SensorID).ToList();
float avgValue = 0;
int alarmID = 0;
foreach (var pointVal in RecordedDataforPoints)
{
avgValue += (float)(pointVal.OverallValue);
alarmID = (int)(pointVal.AlarmID);
}
avgValue = avgValue / RecordedDataforPoints.Count;
i = GetAlarmForNode(Convert.ToDouble(avgValue), sensors.SensorID, alarmID);
if (i == 2)
{
token = 2;
break;
}
else if (i == 1)
{
token = 1;
}
}
if (token == 2)
{
pointID[Counter] = point.PointID;
pointName[Counter] = point.PointName;
AlarmFlag[Counter] = token;
Counter++;
}
else if (token == 1)
{
pointID[Counter] = point.PointID;
pointName[Counter] = point.PointName;
AlarmFlag[Counter] = token;
Counter++;
}
else if (token == 0)
{
pointID[Counter] = point.PointID;
pointName[Counter] = point.PointName;
AlarmFlag[Counter] = token;
Counter++;
}
}
points.Add(pointID);
points.Add(pointName);
points.Add(AlarmFlag);
}
return(points);
}
