public string InsertData(int channelnum, string memoryadd, int sid, string sensordesc, int countlow, int counthigh, int sensorlimithigh, int sensorlimitlow, int uid, int sdlid, int modeltype)
{
string res = "";
//var doesThisExist = db.configurationtblsensormasters.Where(m => m.IsDeleted == 0 && m.ChannelNo == channelnum && m.MemoryAddress == memoryadd && m.Sid == sid && m.SensorDesc == sensordesc && m.CountLow == countlow && m.CountHigh == counthigh && m.sensorlimitLow == sensorlimitlow && m.sensorlimitHigh == sensorlimithigh && m.IsAnalog == modeltype).ToList();
//if (doesThisExist.Count == 0)
//{
configurationtblsensormaster tblpc = new configurationtblsensormaster();
tblpc.CreatedBy = 1;
tblpc.CreatedOn = DateTime.Now;
tblpc.IsDeleted = 0;
tblpc.ChannelNo = channelnum;
tblpc.MemoryAddress = Convert.ToInt32(memoryadd);
tblpc.Sid = sid;
tblpc.SensorDesc = sensordesc;
tblpc.Unitid = uid;
tblpc.CountLow = countlow;
tblpc.IsAnalog = modeltype;
tblpc.CountHigh = counthigh;
tblpc.sensorlimitHigh = sensorlimithigh;
tblpc.sensorlimitLow = sensorlimitlow;
tblpc.parametertypeid = sdlid;
db.configurationtblsensormasters.Add(tblpc);
db.SaveChanges();
res = "success";
// }
//else
//{
// TempData["Message"] = "Sensor Name already Exists";
// res = "failure";
// return res;
//}
return(res);
}
public string InsertDatawithio(int channelnum, string memoryadd, int sid, string sensordesc, int modeltype,
decimal scalingfac, int uid, int sdlid)
{
string res = "";
//var doesThisExist = db.configurationtblsensormasters.Where(m => m.IsDeleted == 0 && m.ChannelNo == channelnum && m.MemoryAddress == memoryadd && m.Sid == sid && m.SensorDesc == sensordesc && m.IsAnalog == modeltype && m.scalingFactor == scalingfac && m.Unitid == uid && m.parametertypeid == sdlid).ToList();
//if (doesThisExist.Count == 0)
//{
configurationtblsensormaster tblpc = new configurationtblsensormaster();
tblpc.CreatedBy = 1;
tblpc.CreatedOn = DateTime.Now;
tblpc.IsDeleted = 0;
tblpc.IsAnalog = modeltype;
tblpc.ChannelNo = channelnum;
tblpc.MemoryAddress = Convert.ToInt32(memoryadd);
tblpc.Sid = sid;
tblpc.SensorDesc = sensordesc;
tblpc.scalingFactor = scalingfac;
tblpc.Unitid = uid;
tblpc.parametertypeid = sdlid;
db.configurationtblsensormasters.Add(tblpc);
db.SaveChanges();
res = "success";
// }
//else
// {
// TempData["Message"] = "This Record is already Exists";
// return res;
// }
return(res);
}
public ActionResult EditSensorMaster(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_shaktiEntities1 db = new i_facility_shaktiEntities1())
{
configurationtblsensormaster tblmc = db.configurationtblsensormasters.Find(id);
if (tblmc == null)
{
return(HttpNotFound());
}
ViewBag.Unit = new SelectList(db.tblunits.Where(m => m.IsDeleted == 0), "U_id", "Unit", tblmc.Unitid).ToList();
ViewBag.SensorGroupName = new SelectList(db.configuration_tblsensorgroup.ToList().Where(m => m.IsDeleted == 0), "SID", "SensorGroupName", tblmc.Sid).ToList();
ViewBag.SensorDataLink = new SelectList(db.configurationtblsensordatalinks.Where(m => m.IsDeleted == 0 && m.IsSensor == 1), "ParameterTypeID", "parametername", tblmc.parametertypeid).ToList();
SensorMaster sd = new SensorMaster();
sd.sensormaster = tblmc;
return(View(sd));
}
}
// GET: SensorMaster
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();
SensorMaster pa = new SensorMaster();
configurationtblsensormaster mp = new configurationtblsensormaster();
pa.sensormaster = mp;
pa.sensormasterList = db.configurationtblsensormasters.Where(m => m.IsDeleted == 0).ToList();
return(View(pa));
}
