public JsonResult CreateData(string HD, string RD) { tblholiday tblholiday = new tblholiday(); DateTime Var = Convert.ToDateTime(HD).Date; var duplicateEntry = db.tblholidays.Where(m => m.IsDeleted == 0 && m.HolidayDate == Var).ToList(); if (duplicateEntry.Count > 0) { TempData["Error"] = "Record already exists"; } else { tblholiday.CreatedBy = 1; tblholiday.CreatedOn = DateTime.Now; tblholiday.IsDeleted = 0; tblholiday.HolidayDate = Convert.ToDateTime(HD).Date; tblholiday.Reason = RD; { db.tblholidays.Add(tblholiday); db.SaveChanges(); } } return(Json(tblholiday.HolidayId, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(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"]; int UserID = Convert.ToInt32(Session["UserId"]); String Username = Session["Username"].ToString(); //Getting all the details of that particular id in PMCheckPoint table configuration_tblpmcheckpoint tblmc = condb.configuration_tblpmcheckpoint.Find(id); using (i_facility_shaktiEntities1 condb = new i_facility_shaktiEntities1()) { //Getting all the details of that particular id in PMCheckList table var data = condb.configuration_tblpmcheckpoint.Where(m => m.pmcpID == id && m.Isdeleted == 0).ToList(); foreach (var row in data) { //deleting the perticular row of that id in tblPMCheckList table row.Isdeleted = 1; condb.SaveChanges(); } //And deleting the row present in tblPMCheckPoint table } tblmc.Isdeleted = 1; condb.SaveChanges(); TempData["toaster_success"] = "Data Deleted successfully"; return(RedirectToAction("Index")); }
public string DeleteOperatorDetails(int id) { ViewBag.Logout = Session["Username"].ToString().ToUpper(); ViewBag.roleid = Session["RoleID"]; String Username = Session["Username"].ToString(); int UserID = Convert.ToInt32(Session["UserID"]); //ViewBag.IsConfigMenu = 0; using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { tblOperatorLoginDetail obj = db.tblOperatorLoginDetails.Find(id); obj.isDeleted = 1; db.Entry(obj).State = EntityState.Modified; db.SaveChanges(); } var mac = db.tblOperatorMachineDetails.Where(m => m.operatorLoginId == id).ToList(); if (mac.Count != 0) { foreach (var ec in mac) { ec.isDeleted = 1; db.SaveChanges(); } } return("Deleted"); }
public ActionResult Delete(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(); int UserID1 = id; int UserID = Convert.ToInt32(Session["UserId"]); tblshiftmethod tblmc = condb.tblshiftmethods.Find(id); var shiftdetailsList = condb.tblshiftdetails.Where(m => m.IsDeleted == 0 && m.ShiftMethodID == id).ToList(); foreach (var shiftdetailsrow in shiftdetailsList) { shiftdetailsrow.IsDeleted = 1; condb.Entry(shiftdetailsrow).State = EntityState.Modified; condb.SaveChanges(); } tblmc.IsDeleted = 1; condb.Entry(tblmc).State = EntityState.Modified; condb.SaveChanges(); TempData["toaster_success"] = "Data Deleted successfully"; return(RedirectToAction("Index")); }
//public string Getdata(int cellid, int machineid) //{ // List<PMSEntry> pmslist = new List<PMSEntry>(); // string res = ""; // var checkpointdata = condb.configuration_tblpmcheckpoint.Where(m => m.Isdeleted == 0 && m.CellID == cellid).ToList(); // var pmsdet = condb.tblpmsdetails.Where(m => m.IsDeleted == 0 && m.IsCompleted == 0 && m.MachineID == machineid).ToList(); // int count = pmsdet.Count; // if (count == 0) // { // foreach (var checkpointdet in checkpointdata) // { // PMSEntry obj = new PMSEntry(); // obj.checkpointid = checkpointdet.pmcpID; // obj.checkpointname = checkpointdet.TypeofCheckpoint; // var checklistdata = condb.configuration_tblpmchecklist.Where(m => m.Isdeleted == 0 && m.pmcpID == checkpointdet.pmcpID).ToList(); // List<pmchecklistdata> pmclist = new List<pmchecklistdata>(); // foreach (var checklistdet in checklistdata) // { // pmchecklistdata obj1 = new pmchecklistdata(); // obj1.checklistname = checklistdet.CheckList; // obj1.Frequency = checklistdet.Frequency; // obj1.Value = checklistdet.Value; // obj1.How = checklistdet.How; // pmclist.Add(obj1); // } // obj.checklistdata = pmclist; // pmslist.Add(obj); // } // res = JsonConvert.SerializeObject(pmslist); // } // else // { // foreach (var checkpointdet in checkpointdata) // { // var histpms = condb.tblhistpms.Where(m => m.Pmcheckpointid == checkpointdet.pmcpID).ToList(); // foreach (var histpmsdet in histpms) // { // if (checkpointdet.pmcpID == histpmsdet.Pmcheckpointid) // { // PMSEntry obj = new PMSEntry(); // obj.checkpointid = histpmsdet.Pmcheckpointid; // var checkpointname = condb.configuration_tblpmcheckpoint.Where(m => m.pmcpID == histpmsdet.Pmcheckpointid).Select(m => m.TypeofCheckpoint).FirstOrDefault(); // obj.checkpointname = checkpointname; // var checklistdata = condb.configuration_tblpmchecklist.Where(m => m.Isdeleted == 0 && m.pmcpID == histpmsdet.Pmcheckpointid).ToList(); // List<pmchecklistdata> pmclist = new List<pmchecklistdata>(); // foreach (var checklistdet in checklistdata) // { // pmchecklistdata obj1 = new pmchecklistdata(); // obj1.checklistname = checklistdet.CheckList; // obj1.Frequency = checklistdet.Frequency; // obj1.Value = checklistdet.Value; // obj1.How = checklistdet.How; // pmclist.Add(obj1); // } // obj.checklistdata = pmclist; // pmslist.Add(obj); // res = JsonConvert.SerializeObject(pmslist); // } // else // { // PMSEntry obj = new PMSEntry(); // obj.checkpointid = checkpointdet.pmcpID; // obj.checkpointname = checkpointdet.TypeofCheckpoint; // var checklistdata = condb.configuration_tblpmchecklist.Where(m => m.Isdeleted == 0 && m.pmcpID == histpmsdet.Pmcheckpointid).ToList(); // List<pmchecklistdata> pmclist = new List<pmchecklistdata>(); // foreach (var checklistdet in checklistdata) // { // pmchecklistdata obj1 = new pmchecklistdata(); // obj1.checklistname = checklistdet.CheckList; // obj1.Frequency = checklistdet.Frequency; // obj1.Value = checklistdet.Value; // obj1.How = checklistdet.How; // pmclist.Add(obj1); // } // obj.checklistdata = pmclist; // pmslist.Add(obj); // res = JsonConvert.SerializeObject(pmslist); // } // } // } // } // return res; //} public string insertdata(int machineid, string Startdate) { string res = ""; var pmsdet = condb.tblpmsdetails.Where(m => m.IsDeleted == 0 && m.IsCompleted == 0 && m.MachineID == machineid && m.PMStartDate == Startdate).ToList(); int count = pmsdet.Count; if (count == 0) { tblpmsdetail obj1 = new tblpmsdetail(); obj1.MachineID = machineid; //obj1.CellID = cellid; obj1.PMEndDate = null; obj1.PMStartDate = Startdate; obj1.IsCompleted = 0; obj1.IsSubmitted = 1; obj1.CreatedOn = System.DateTime.Now; obj1.CreatedBy = 1; obj1.IsDeleted = 0; condb.tblpmsdetails.Add(obj1); condb.SaveChanges(); res = JsonConvert.SerializeObject(obj1.pmsid); } else { } return(res); }
//Update IsDeleted = 1 to mark it as Deleted Role. public ActionResult Delete(int id) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } int UserID1 = Convert.ToInt32(Session["UserID"].ToString()); using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { tblmodule tblModule = db.tblmodules.Find(id); tblModule.IsDeleted = 1; tblModule.ModifiedBy = UserID1; tblModule.ModifiedOn = System.DateTime.Now; db.Entry(tblModule).State = EntityState.Modified; db.SaveChanges(); //Updating in module helper int ID = Convert.ToInt32(tblModule.ModuleId); tblrolemodulelink module = db.tblrolemodulelinks.Where(m => m.ModuleID == ID).FirstOrDefault(); module.IsDeleted = 1; module.ModifiedBy = UserID1; module.ModifiedOn = System.DateTime.Now; db.Entry(module).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } }
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); }
private bool InsertOEEDetails(string CorrectedDate, int MachineID, decimal AvailabilityPercentage, decimal QualityPercentage, decimal PerformancePercentage, decimal OEEPercentage, int TotalPartsCount, decimal OperatingTime, decimal TotalIdleTimeInMin, decimal PerformanceFactor) { bool res = false; var oeedet = db.tbl_OEEDetails.Where(m => m.CorrectedDate == CorrectedDate && m.MachineID == MachineID).FirstOrDefault(); if (oeedet == null) { tbl_OEEDetails oee = new tbl_OEEDetails(); oee.MachineID = MachineID; oee.Availability = AvailabilityPercentage; oee.IsDeleted = 0; oee.OEE = OEEPercentage; oee.Performance = PerformancePercentage; oee.Quality = QualityPercentage; oee.TotalPartsCount = TotalPartsCount; oee.CreatedOn = DateTime.Now; oee.CreatedBy = 1; oee.CorrectedDate = CorrectedDate; oee.OperatingTimeinMin = OperatingTime; oee.TotalIDLETimeinMin = TotalIdleTimeInMin; oee.PerformanceFactor = PerformanceFactor; db.tbl_OEEDetails.Add(oee); db.SaveChanges(); res = true; } return(res); }
//Delete Plant public ActionResult Delete(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(); int UserID1 = id; ViewBag.IsConfigMenu = 0; tblplant tblmc = db.tblplants.Find(id); int plantid = tblmc.PlantID; tblmc.IsDeleted = 1; db.Entry(tblmc).State = EntityState.Modified; db.SaveChanges(); //Delete corresponding shops cells & machines. var shopdata = db.tblshops.Where(m => m.IsDeleted == 0 && m.PlantID == plantid).ToList(); foreach (var shoprow in shopdata) { shoprow.IsDeleted = 1; db.Entry(shoprow).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); int shopid = shoprow.ShopID; var cellsdata = db.tblcells.Where(m => m.IsDeleted == 0 && m.ShopID == shopid).ToList(); foreach (var cellrow in cellsdata) { cellrow.IsDeleted = 1; db.Entry(cellrow).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); int cellid = cellrow.CellID; var machinedata = db.tblmachinedetails.Where(m => m.IsDeleted == 0 && m.CellID == cellid).ToList(); foreach (var machinerow in machinedata) { machinerow.IsDeleted = 1; db.Entry(machinerow).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } } var machinedata1 = db.tblmachinedetails.Where(m => m.IsDeleted == 0 && m.PlantID == id).ToList(); foreach (var machinerow in machinedata1) { machinerow.IsDeleted = 1; db.Entry(machinerow).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); }
//Delete Department public ActionResult DeleteShops(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(); int UserID = Convert.ToInt32(Session["UserID"]); //ViewBag.IsConfigMenu = 0; using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { tblshop shop = db.tblshops.Find(id); shop.IsDeleted = 1; shop.ModifiedBy = UserID; int shopid = shop.ShopID; shop.ModifiedOn = DateTime.Now; db.Entry(shop).State = EntityState.Modified; db.SaveChanges(); } //delete corresponding cells & machines also. var cellsdata = db.tblcells.Where(m => m.IsDeleted == 0 && m.ShopID == id).ToList(); foreach (var cellrow in cellsdata) { cellrow.IsDeleted = 1; db.Entry(cellrow).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); int cellid = cellrow.CellID; var machinedata = db.tblmachinedetails.Where(m => m.IsDeleted == 0 && m.CellID == cellid).ToList(); foreach (var machinerow in machinedata) { machinerow.IsDeleted = 1; db.Entry(machinerow).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } var machinedata1 = db.tblmachinedetails.Where(m => m.IsDeleted == 0 && m.ShopID == id).ToList(); foreach (var machinerow in machinedata1) { machinerow.IsDeleted = 1; db.Entry(machinerow).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("ShopList")); }
public ActionResult Create(tblmailid tmi) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } ViewBag.Logout = Session["Username"]; ViewBag.roleid = Session["RoleID"]; String Username = Session["Username"].ToString(); #region//ActiveLog Code int UserID = Convert.ToInt32(Session["UserId"]); //string CompleteModificationdetail = "New Creation"; //Action = "Create"; // ActiveLogStorage Obj = new ActiveLogStorage(); // Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail); //End #endregion //MailID Details validation string name = tmi.EmployeeName.ToString(); string emailid = tmi.EmailID.ToString(); string contactNo = tmi.EmployeeContactNum.ToString(); var doesTheseExists = db.tblmailids.Where(m => m.IsDeleted == 0 && (m.EmployeeName == name || m.EmailID == emailid || m.EmployeeContactNum == contactNo)).ToList(); if (doesTheseExists.Count() == 0) { tmi.IsDeleted = 0; tmi.CreatedBy = UserID; tmi.CreatedOn = DateTime.Now; db.tblmailids.Add(tmi); db.SaveChanges(); return(RedirectToAction("Index")); } else { Session["Error"] = null; var doesNameExists = db.tblmailids.Where(m => m.IsDeleted == 0 && m.EmployeeName == name).ToList(); if (doesNameExists.Count() > 0) { Session["Error"] += "Duplicate Name. "; } var doesMailIdExists = db.tblmailids.Where(m => m.EmailID == emailid).ToList(); if (doesMailIdExists.Count() > 0) { Session["Error"] += " Duplicate Email ID. "; } var doesCnoExists = db.tblmailids.Where(m => m.IsDeleted == 0 && m.EmployeeContactNum == contactNo).ToList(); if (doesCnoExists.Count() > 0) { Session["Error"] += " Duplicate Contact Number. "; } return(View(tmi)); } }
//[HttpPost] //public ActionResult Create(OperatorModule OPTDet) //{ // if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) // { // return RedirectToAction("Login", "Login", null); // } // ViewBag.Logout = Session["Username"].ToString().ToUpper(); // ViewBag.roleid = Session["RoleID"]; // int UserID = Convert.ToInt32(Session["UserId"]); // string Dept = OPTDet.OPDetails.Dept; // string OperatorName = OPTDet.OPDetails.OperatorName; // int OperatorID = OPTDet.OPDetails.OperatorID; // bool check = ValidationCheckForInsertion(OperatorID); // if (check == true) // { // OPTDet.OPDetails.CreatedOn = DateTime.Now; // OPTDet.OPDetails.CorrectedDate = DateTime.Now.Date; // OPTDet.OPDetails.CreatedBy = UserID; // OPTDet.OPDetails.isDeleted = 0; // db.tbloperatordetails.Add(OPTDet.OPDetails); // db.SaveChanges(); // } // return RedirectToAction("Index"); //} public string CreateOperator(string dept, string operatorId, string operatorName, int OperatorDesc) { string res = ""; int UserID = Convert.ToInt32(Session["UserId"]); bool check = ValidationCheckForInsertion(operatorId); if (check == true) { tbloperatordetail OPTDet = new tbloperatordetail(); OPTDet.CreatedOn = DateTime.Now; OPTDet.CorrectedDate = DateTime.Now.Date; OPTDet.CreatedBy = UserID; OPTDet.isDeleted = 0; OPTDet.Dept = dept; OPTDet.OperatorID = Convert.ToString(operatorId); OPTDet.OperatorName = operatorName; OPTDet.OperatorDesc = OperatorDesc; db.tbloperatordetails.Add(OPTDet); db.SaveChanges(); res = "Success"; } else { res = "failure"; } return(res); }
public string CreateOperatorLogin(OperatorLoginDetails OperatorLogin) { ViewBag.Logout = Session["Username"].ToString().ToUpper(); ViewBag.roleid = Session["RoleID"]; String Username = Session["Username"].ToString(); //shop name validation using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { var operatorCheck = db.tblOperatorLoginDetails.Where(m => m.operatorId == OperatorLogin.operatorId).FirstOrDefault(); if (operatorCheck == null) { string[] machineName = OperatorLogin.machineids.Split(','); tblOperatorLoginDetail obj = new tblOperatorLoginDetail(); obj.operatorUserName = OperatorLogin.operatorUserName; obj.operatorPwd = OperatorLogin.operatorPwd; obj.operatorEmailId = OperatorLogin.operatorEmailId; obj.operatorMobileNo = OperatorLogin.operatorMobileNo; obj.roleId = OperatorLogin.roleId; obj.operatorId = OperatorLogin.operatorId; obj.operatorName = OperatorLogin.operatorName; obj.NumOfMachines = OperatorLogin.NumOfMachines; obj.createdOn = DateTime.Now; obj.isDeleted = 0; db.tblOperatorLoginDetails.Add(obj); db.SaveChanges(); if (machineName != null) { foreach (var i in machineName) { tblOperatorMachineDetail obj1 = new tblOperatorMachineDetail(); var machineId = db.tblmachinedetails.Where(m => m.MachineName == i).Select(m => m.MachineID).FirstOrDefault(); obj1.machineId = machineId; obj1.operatorLoginId = obj.operatorLoginId; obj1.isDeleted = 0; obj1.createdOn = DateTime.Now; db.tblOperatorMachineDetails.Add(obj1); db.SaveChanges(); } } } else { Session["Error"] = "Operator User Name: " + OperatorLogin.operatorUserName + " already exists "; return("Operator Name already exists "); } return("Created"); } }
public string InsertData(string ip, int machineid, int sid, int portno) { string res = ""; //var doesThisdataExist = db.configurationtblmachinesensors.Where(m => m.IsDeleted == 0 && m.Sid == sid && m.MachineId == machineid).ToList(); //if (doesThisdataExist.Count == 0) //{ configurationtblmachinesensor tblpc = new configurationtblmachinesensor(); tblpc.CreatedBy = 1; tblpc.CreatedOn = DateTime.Now; tblpc.IsDeleted = 0; tblpc.IPAddress = ip; tblpc.MachineId = machineid; tblpc.Sid = sid; tblpc.PortNo = portno; db.configurationtblmachinesensors.Add(tblpc); db.SaveChanges(); TempData["toaster_success"] = "Data Saved successfully"; res = "success"; return(res); //} //else //{ // TempData["toaster_error"] = "Sensor Group Name already Exists"; // res = "success"; //} //return Json(tblpc.SdlID, JsonRequestBehavior.AllowGet); }
public ActionResult Create(RolesModel tblrole) { 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(); var DuplicateRole = db.tblroles.Where(m => m.IsDeleted == 0 && m.RoleName == tblrole.Role.RoleName).FirstOrDefault(); if (DuplicateRole == null) { // Update Role data with other required fields. int UserID = Convert.ToInt32(Session["UserId"]); tblrole.Role.CreatedBy = UserID; tblrole.Role.CreatedOn = System.DateTime.Now; tblrole.Role.IsDeleted = 0; using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { db.tblroles.Add(tblrole.Role); db.SaveChanges(); } } else { Session["Error"] = "Duplicate Role : " + tblrole.Role.RoleName; return(View(tblrole)); } return(RedirectToAction("Index")); }
public ActionResult CreateSensorGroup(sensormodel tblp) { 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(); string sensorName = tblp.sensorgroup.SensorGroupName.ToString(); using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { var doesThisExist = db.configuration_tblsensorgroup.Where(m => m.IsDeleted == 0 && m.SensorGroupName == sensorName).ToList(); if (doesThisExist.Count == 0) { tblp.sensorgroup.CreatedBy = ViewBag.roleid; tblp.sensorgroup.CreatedOn = DateTime.Now; tblp.sensorgroup.IsDeleted = 0; db.configuration_tblsensorgroup.Add(tblp.sensorgroup); db.SaveChanges(); TempData["toaster_success"] = "Data Saved successfully"; return(RedirectToAction("IndexSensorGroup")); } else { TempData["toaster_warning"] = "This Record Already Exists"; return(View(tblp)); } } }
public string InsertData(string ParameterName, string ParameterDesc, int IsAxis, int IsSensor, decimal LSL, decimal USL, int LogFrequency, int axisid, int logfreqid, int unit, string element, string subelement, string Deterioration, int IsCycle) { string res = ""; var doesThisPlantExist = db.configurationtblsensordatalinks.Where(m => m.IsDeleted == 0 && m.ParameterName == ParameterName && m.AxisID != axisid).ToList(); if (doesThisPlantExist.Count == 0) { configurationtblsensordatalink tblpc = new configurationtblsensordatalink(); tblpc.CreatedBy = 1; tblpc.CreatedOn = DateTime.Now; tblpc.IsDeleted = 0; tblpc.ParameterName = ParameterName; tblpc.ParameterDesc = ParameterDesc; tblpc.IsCycle = IsCycle; tblpc.IsAxis = IsAxis; tblpc.IsSensor = IsSensor; tblpc.Element = element; tblpc.Unit = unit; tblpc.SubElement = subelement; tblpc.Deterioration = Deterioration; tblpc.LSL = LSL; tblpc.LogFreqUnitID = logfreqid; tblpc.USL = USL; tblpc.LogFrequency = LogFrequency; tblpc.AxisID = axisid; db.configurationtblsensordatalinks.Add(tblpc); db.SaveChanges(); res = "success"; } return(res); }
public JsonResult CreateData(string st, string br, string et) { tblplannedbreak tblplannedbreak = new tblplannedbreak(); tblplannedbreak.CreatedBy = 1; tblplannedbreak.CreatedOn = DateTime.Now; tblplannedbreak.IsDeleted = 0; tblplannedbreak.StartTime = Convert.ToDateTime(st).TimeOfDay; tblplannedbreak.EndTime = Convert.ToDateTime(et).TimeOfDay; tblplannedbreak.BreakReason = br; { db.tblplannedbreaks.Add(tblplannedbreak); db.SaveChanges(); } return(Json(tblplannedbreak.BreakID, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(PlantModel tblp) { 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(); string plantName = tblp.Plant.PlantName.ToString(); using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { var doesThisPlantExist = db.tblplants.Where(m => m.IsDeleted == 0 && m.PlantName == plantName).ToList(); if (doesThisPlantExist.Count == 0) { tblp.Plant.CreatedBy = 1; tblp.Plant.CreatedOn = DateTime.Now; tblp.Plant.IsDeleted = 0; db.tblplants.Add(tblp.Plant); db.SaveChanges(); return(RedirectToAction("Index")); } else { Session["Error"] = "Plant Name" + " " + tblp.Plant.PlantName + " already Exists."; return(View(tblp)); } } }
public string update1(int plant, int shop, int cell, string value, string frequency, int pmcpid, int pmcid, string checklist, string How) { string res = ""; using (i_facility_shaktiEntities1 condb = new i_facility_shaktiEntities1()) { var tblpc = condb.configuration_tblpmchecklist.Find(pmcid); tblpc.Isdeleted = 0; tblpc.PlantID = plant; tblpc.ShopID = shop; tblpc.CellID = cell; tblpc.pmcpID = pmcpid; tblpc.Value = value; tblpc.How = How; tblpc.Frequency = frequency; tblpc.CheckList = checklist; tblpc.ModifiedBy = 1; tblpc.ModifiedOn = DateTime.Now; condb.Entry(tblpc).State = EntityState.Modified; condb.SaveChanges(); res = "Success"; return(res); } }
public ActionResult CreateShops(ShopModel shop) { 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(); //shop name validation using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { string shopname = shop.Shops.ShopName.ToString(); var doesThisShopExists = db.tblshops.Where(m => m.IsDeleted == 0 && m.PlantID == shop.Shops.PlantID && m.ShopName == shopname).ToList(); if (doesThisShopExists.Count == 0) { shop.Shops.CreatedBy = 1; shop.Shops.CreatedOn = DateTime.Now; shop.Shops.IsDeleted = 0; db.tblshops.Add(shop.Shops); db.SaveChanges(); } else { ViewBag.PlantID = new SelectList(db.tblplants.Where(m => m.IsDeleted == 0), "PlantID", "PlantName", shop.Shops.PlantID).ToList(); Session["Error"] = "Shop Name: " + shop.Shops.ShopName + " already exists for this Plant :" + db.tblplants.Where(m => m.PlantID == shop.Shops.PlantID && m.IsDeleted == 0).Select(m => m.PlantDisplayName).FirstOrDefault(); return(View(shop)); } return(RedirectToAction("ShopList")); } }
public string UpdateDat(string UserName, string Password, string DisplayName, int RoleID1, int RoleID2, int userid) { string res = ""; var doesThisExist = condb.tblusers.Where(m => m.IsDeleted == 0 && m.UserName == UserName && m.Password == Password && m.DisplayName == DisplayName && m.UserID != userid && m.PrimaryRole == RoleID1 && m.SecondaryRole == RoleID2).ToList(); if (doesThisExist.Count == 0) { using (i_facility_shaktiEntities1 condb = new i_facility_shaktiEntities1()) { var UserData = condb.tblusers.Find(userid); UserData.UserName = UserName; UserData.Password = Password; UserData.DisplayName = DisplayName; UserData.PrimaryRole = RoleID1; UserData.ModifiedBy = userid; UserData.SecondaryRole = RoleID2; UserData.ModifiedOn = DateTime.Now; condb.Entry(UserData).State = EntityState.Modified; condb.SaveChanges(); res = "Success"; } } return(res); }
public ActionResult EditSensorGroup(sensormodel 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 sensorName = tblmc.sensorgroup.SensorGroupName.ToString(); int sid = tblmc.sensorgroup.SID; using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { var doesThisPlantExist = db.configuration_tblsensorgroup.Where(m => m.IsDeleted == 0 && m.SensorGroupName == sensorName && m.SID != sid).ToList(); if (doesThisPlantExist.Count == 0) { var sensor = db.configuration_tblsensorgroup.Find(tblmc.sensorgroup.SID); sensor.SensorDesc = tblmc.sensorgroup.SensorDesc; sensor.SensorGroupName = sensorName; sensor.ModifiedBy = ViewBag.roleid; sensor.ModifiedOn = DateTime.Now; db.Entry(sensor).State = EntityState.Modified; db.SaveChanges(); TempData["toaster_success"] = "Data Updated successfully"; return(RedirectToAction("IndexSensorGroup")); } else { TempData["toaster_warning"] = "This Record Already Exists"; return(View(tblmc)); } } }
public ActionResult Create(ShiftMethodModel objtblshiftMethod) { 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 var_shiftmethod = objtblshiftMethod.ShiftMethod.ShiftMethodName; using (i_facility_shaktiEntities1 condb = new i_facility_shaktiEntities1()) { var does_shiftmethod_name_Exists = condb.tblshiftmethods.Where(m => m.IsDeleted == 0 && m.ShiftMethodName == var_shiftmethod).ToList(); if (does_shiftmethod_name_Exists.Count == 0) { objtblshiftMethod.ShiftMethod.CreatedBy = UserID; objtblshiftMethod.ShiftMethod.IsDeleted = 0; objtblshiftMethod.ShiftMethod.CreatedOn = DateTime.Now; condb.tblshiftmethods.Add(objtblshiftMethod.ShiftMethod); condb.SaveChanges(); } else { TempData["Error"] = "Shift Method Exists."; return(View(objtblshiftMethod)); } TempData["toaster_success"] = "Data Saved successfully"; return(RedirectToAction("Index")); } }
public ActionResult Delete(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(); int UserID1 = id; int UserID = Convert.ToInt32(Session["UserId"]); using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { var tblpm = db.configuration_tblsensorgroup.Where(m => m.SID == id).FirstOrDefault(); //tblpmchecklist tblpm = db.tblpmchecklists.Find(id); tblpm.IsDeleted = 1; tblpm.ModifiedBy = UserID; tblpm.ModifiedOn = DateTime.Now; db.Entry(tblpm).State = EntityState.Modified; db.SaveChanges(); TempData["toaster_success"] = "Data Deleted successfully"; return(RedirectToAction("IndexSensorGroup")); } }
public ActionResult Create(tbluser tbluser) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } ViewBag.Logout = Session["Username"]; ViewBag.roleid = Session["RoleID"]; int roleid = Convert.ToInt32(Session["RoleID"]); String Username = Session["Username"].ToString(); //ViewBag.PrimaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0), "Role_ID", "RoleDesc"); //ViewBag.SecondaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0), "Role_ID", "RoleDesc"); tbluser.CreatedBy = roleid; tbluser.CreatedOn = System.DateTime.Now; tbluser.IsDeleted = 0; ////ActiveLog Code //int UserID = Convert.ToInt32(Session["UserId"]); //string CompleteModificationdetail = "New Creation"; //Action = "Create"; //ActiveLogStorage Obj = new ActiveLogStorage(); //Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail); ////End var dupUserData = db.tblusers.Where(m => m.IsDeleted == 0 && m.UserName == tbluser.UserName).ToList(); if (dupUserData.Count == 0) { int primaryrole = Convert.ToInt32(tbluser.PrimaryRole); if (primaryrole != 3) { // tbluser.MachineID = ; } db.tblusers.Add(tbluser); db.SaveChanges(); return(RedirectToAction("Index")); } else { Session["Error"] = "User Name Exists."; ViewBag.PrimaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.PrimaryRole); ViewBag.SecondaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.SecondaryRole); ViewBag.MachineID = new SelectList(db.tblmachinedetails.Where(m => m.IsDeleted == 0), "MachineID", "MachineDispName", tbluser.MachineID); return(View(tbluser)); } }
public ActionResult CreateMachine(MachineModel tblmachine, int dept = 0, int Plant = 0, int cell = 0, int Machnecategory = 0) { 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 machinename = tblmachine.Machine.MachineName; var duplicateEntry = db.tblmachinedetails.Where(m => m.IsDeleted == 0 && m.PlantID == Plant && m.ShopID == dept && m.CellID == Machnecategory && m.MachineName == machinename).ToList(); if (duplicateEntry.Count == 0) { tblmachine.Machine.InsertedBy = 1; //Convert.ToInt32(Session["UserId"]); var Datevar = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); tblmachine.Machine.InsertedOn = Datevar.ToString(); tblmachine.Machine.IsDeleted = 0; tblmachine.Machine.ServerTabFlagSync = 0; tblmachine.Machine.ServerTabCheck = 1; tblmachine.Machine.PlantID = Plant; tblmachine.Machine.ShopID = dept; tblmachine.Machine.CellID = cell; //var shopname = db.tblshops.Where(m => m.IsDeleted == 0 && m.ShopID == Shop).Select(m => m.ShopName).FirstOrDefault(); //tblmachine.ShopNo = shopname.ToString(); //if (Cell != 0) //{ // tblmachine.CellID = Cell; //} db.tblmachinedetails.Add(tblmachine.Machine); db.SaveChanges(); } else { Session["Error"] = "Duplicate Machine Name"; ViewBag.plant = new SelectList(db.tblplants.Where(p => p.IsDeleted == 0), "PlantID", "PlantName", tblmachine.Machine.PlantID); ViewBag.dept = new SelectList(db.tblshops.Where(d => d.IsDeleted == 0), "ShopId", "ShopName", tblmachine.Machine.ShopID); ViewBag.MachineCategoryID = new SelectList(db.tblcells.Where(m => m.IsDeleted == 0), "CellID", "CellName", tblmachine.Machine.CellID); return(View(tblmachine)); } return(RedirectToAction("MachineList")); }
//delete machine category public ActionResult DeleteCells(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(); int UserID1 = id; ViewBag.IsConfigMenu = 0; //start Logging // int UserID = Convert.ToInt32(Session["UserId"]); // string CompleteModificationdetail = "Deleted Role"; // Action = "Delete"; // ActiveLogStorage Obj = new ActiveLogStorage(); //Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail); //End using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { tblcell tblmc = db.tblcells.Find(id); int mcahineid = tblmc.CellID; tblmc.IsDeleted = 1; tblmc.ModifiedBy = 1; tblmc.ModifiedOn = DateTime.Now; db.Entry(tblmc).State = EntityState.Modified; db.SaveChanges(); //delete corresponding machines var machinedata = db.tblmachinedetails.Where(m => m.IsDeleted == 0 && m.CellID == mcahineid).ToList(); foreach (var machinerow in machinedata) { machinerow.IsDeleted = 1; db.Entry(machinerow).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("CellsList")); }
public ActionResult Create(TblPMSNotification_Master tee, int hdnSaveNContinue = 0) { 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(); #region//ActiveLog Code int UserID = Convert.ToInt32(Session["UserId"]); //string CompleteModificationdetail = "New Creation"; //Action = "Create"; // ActiveLogStorage Obj = new ActiveLogStorage(); // Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail); //End #endregion //Email validation string Plantidstring = Convert.ToString(tee.PlantID); string Shopidstring = Convert.ToString(tee.ShopID); string Cellidstring = Convert.ToString(tee.CellID); string WorkCenteridstring = Convert.ToString(tee.WorkCenterID); string days = tee.NoOfDaysPrior; string cclist = tee.CcList; string tolist = tee.ToList; string contactlist = tee.SMSContactList; int Frequency = Convert.ToInt32(tee.Frequency); string Unit = tee.Unit; if (hdnSaveNContinue == 0) { tee.CreatedBy = UserID; tee.CreatedOn = DateTime.Now; tee.IsDeleted = 0; db.TblPMSNotification_Master.Add(tee); db.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Edit(ModulesModel tblModule) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } ViewBag.UserName = Session["Username"]; ViewBag.roleid = Session["RoleID"]; String Username = Session["Username"].ToString(); int UserID1 = Convert.ToInt32(Session["UserID"].ToString()); ViewBag.IsEmailEscalation = 0; if (ModelState.IsValid) { using (i_facility_shaktiEntities1 db = new i_facility_shaktiEntities1()) { var DupModule = db.tblmodules.Where(m => m.IsDeleted == 0 && m.Module == tblModule.Modules.Module && m.ModuleId != tblModule.Modules.ModuleId).FirstOrDefault(); if (DupModule == null) { var ModuleData = db.tblmodules.Find(tblModule.Modules.ModuleId); ModuleData.Module = tblModule.Modules.Module; ModuleData.ModuleDesc = tblModule.Modules.ModuleDesc; ModuleData.ModuleDispName = tblModule.Modules.ModuleDispName; ModuleData.ModifiedBy = 1; ModuleData.ModifiedOn = DateTime.Now; db.Entry(ModuleData).State = EntityState.Modified; db.SaveChanges(); ////Updating in module helper not necessary as we are not changing the ModuleID. //int ID = Convert.ToInt32(Session["ID"]); //masterrolemodulehelper module = db.masterrolemodulehelpers.Find(ID); //module.ModuleID = tblModule.ModuleId; //db.Entry(tblModule).State = EntityState.Modified; //db.SaveChanges(); return(RedirectToAction("Index")); } else { Session["Error"] = "Duplicate ModuleName: " + tblModule.Modules.Module; return(View(tblModule)); } } } else { return(View(tblModule)); } }