//Get Method
public ActionResult EditSensorDataLink(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"].ToString().ToUpper();
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
using (i_facility_unimechEntities db = new i_facility_unimechEntities())
{
configurationtblsensordatalink tblmc = db.configurationtblsensordatalinks.Find(id);
if (tblmc == null)
{
return(HttpNotFound());
}
ViewBag.FrequencyUnit = new SelectList(db.tblunits.Where(m => m.IsDeleted == 0), "U_id", "Unit", tblmc.LogFreqUnitID).ToList();
ViewBag.Unit = new SelectList(db.tblunits.Where(m => m.IsDeleted == 0), "U_id", "Unit", tblmc.LogFreqUnitID).ToList();
ViewBag.Axis = new SelectList(db.tbl_axisdet.Where(m => m.IsDeleted == 0), "AxisDetID", "AxisID", tblmc.AxisID).ToList();
SensorDataLink sd = new SensorDataLink();
sd.sensordatalink = tblmc;
return(View(sd));
}
}
public ActionResult EditSensorDataLink(SensorDataLink tblmc)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"].ToString().ToUpper();
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
int UserID = Convert.ToInt32(Session["UserID"]);
string parameterName = tblmc.sensordatalink.ParameterName.ToString();
var parameterid = tblmc.sensordatalink.ParameterTypeID;
using (i_facility_unimechEntities db = new i_facility_unimechEntities())
{
var doesThissensorExist = db.configurationtblsensordatalinks.Where(m => m.IsDeleted == 0 && m.ParameterName == parameterName && m.ParameterDesc == tblmc.sensordatalink.ParameterDesc && m.LSL == tblmc.sensordatalink.LSL && m.LogFrequency == tblmc.sensordatalink.LogFrequency && m.IsAxis == tblmc.sensordatalink.IsAxis && m.IsSensor == tblmc.sensordatalink.IsSensor && m.USL == tblmc.sensordatalink.USL && m.LogFrequency == tblmc.sensordatalink.LogFrequency && m.ParameterTypeID != parameterid && m.Element == tblmc.sensordatalink.Element && m.SubElement == tblmc.sensordatalink.SubElement && m.Deterioration == tblmc.sensordatalink.Deterioration).ToList();
if (doesThissensorExist.Count == 0)
{
var sensor = db.configurationtblsensordatalinks.Find(tblmc.sensordatalink.ParameterTypeID);
sensor.ParameterName = tblmc.sensordatalink.ParameterName;
sensor.ParameterDesc = tblmc.sensordatalink.ParameterDesc;
sensor.IsCycle = tblmc.sensordatalink.IsCycle;
sensor.LSL = tblmc.sensordatalink.LSL;
sensor.USL = tblmc.sensordatalink.USL;
sensor.IsAxis = tblmc.sensordatalink.IsAxis;
sensor.IsSensor = tblmc.sensordatalink.IsSensor;
sensor.LogFrequency = tblmc.sensordatalink.LogFrequency;
sensor.LogFreqUnitID = tblmc.sensordatalink.LogFreqUnitID;
sensor.AxisID = tblmc.sensordatalink.AxisID;
sensor.Element = tblmc.sensordatalink.Element;
sensor.SubElement = tblmc.sensordatalink.SubElement;
sensor.Deterioration = tblmc.sensordatalink.Deterioration;
sensor.ModifiedBy = ViewBag.roleid;
sensor.ModifiedOn = DateTime.Now;
db.Entry(sensor).State = EntityState.Modified;
db.SaveChanges();
TempData["toaster_success"] = "Data Updated successfully";
return(RedirectToAction("Index"));
}
else
{
TempData["toaster_warning"] = "This Record Already Exists";
return(View(tblmc));
}
}
}
// GET: SensorDataLink
public ActionResult Index()
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"].ToString().ToUpper();
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
using (i_facility_unimechEntities db = new i_facility_unimechEntities())
{
SensorDataLink pa = new SensorDataLink();
configurationtblsensordatalink mp = new configurationtblsensordatalink();
pa.sensordatalink = mp;
pa.sensordataList = db.configurationtblsensordatalinks.Where(m => m.IsDeleted == 0).ToList();
return(View(pa));
}
}
