public ActionResult RFIDDetails(tbl_rfidDetails model) { weighingcontrolSystemEntities _db = new weighingcontrolSystemEntities(); if (model.pkid > 0) { _db.Entry(model).State = System.Data.EntityState.Modified; _db.SaveChanges(); ViewBag.alert = "RFID details modified...."; ModelState.Clear(); return(View()); } else { var data = _db.tbl_rfidDetails.Where(x => x.RFIDNUMBER == model.RFIDNUMBER).ToList(); if (data.Count() == 0) { _db.tbl_rfidDetails.Add(model); _db.SaveChanges(); ViewBag.alert = "RFID details saved...."; } else { ViewBag.alert = "RFID Already Exist Please Change RFID Number...."; } ModelState.Clear(); return(View()); } }
public ActionResult DbConfiguration(tbl_RemoteConnection model) { string connectionstring = "Data Source=" + model.serverName + ";Initial Catalog=" + model.dataBaseName + ";User ID=" + model.userName + ";Password="******";"; weighingcontrolSystemEntities _db = new weighingcontrolSystemEntities(); if (model.pkid > 0) { try { using (SqlConnection con = new SqlConnection(connectionstring)) { con.Open(); _db.Entry(model).State = System.Data.EntityState.Modified; _db.SaveChanges(); con.Close(); } ViewBag.alert = "Connection Modified ...."; ModelState.Clear(); return(View()); } catch (Exception ex) { Commonfunction.LogError(ex, HttpContext.Server.MapPath("~/ErrorLog.txt")); ViewBag.alert = ex.Message; return(View()); } } else { try { using (SqlConnection con = new SqlConnection(connectionstring)) { con.Open(); con.Close(); _db.tbl_RemoteConnection.Add(model); _db.SaveChanges(); ViewBag.alert = "Connection Saved ...."; ModelState.Clear(); return(View()); } } catch (Exception ex) { Commonfunction.LogError(ex, HttpContext.Server.MapPath("~/ErrorLog.txt")); ViewBag.alert = ex.Message; return(View()); } } return(View()); }
public ActionResult operatormapping(tbl_operatorMapping model) { weighingcontrolSystemEntities _db = new weighingcontrolSystemEntities(); ViewBag.operatorList = new SelectList(_db.tbl_operatorDetails.ToList(), "pkid", "OperatorName"); ViewBag.shift = new SelectList(_db.tbl_operatorshift.ToList(), "pkid", "shiftname"); ViewBag.truck = new SelectList(_db.tbl_TruckDetails.ToList(), "pkid", "truckNo"); //ViewBag.shifId = _db.tbl_operatorshift.Where(x => x.shiftstsrtTime <= System.DateTime.Now.TimeOfDay && x.shiftEndTime <= System.DateTime.Now.TimeOfDay).FirstOrDefault().pkid; ViewBag.operatorRFIDLsit = new SelectList(_db.tbl_rfidDetails.ToList(), "pkid", "RFIDNUMBER"); //var truck = _db.tbl_truckMapping.Where(n => n.truckRFID == model.operatorFKID).Count(); // model.operatorFKID = _db.tbl_rfidDetails.Where(x => x.pkid == model.rfiDfkId).FirstOrDefault().RFIDNUMBER; int count = _db.tbl_operatorMapping.Where(x => x.shift_fkid == model.shift_fkid && x.operator_fkId == model.operator_fkId && x.workingdate == model.workingdate).Count(); if (_db.tbl_operatorMapping.Where(x => x.shift_fkid == model.shift_fkid && x.operator_fkId == model.operator_fkId && x.workingdate == model.workingdate && x.rfiDfkId == model.rfiDfkId).Count() == 0) { if (_db.tbl_truckMapping.Where(n => n.truckRFID == model.operatorFKID).Count() == 0) { if (model.pkid > 0) { _db.Entry(model).State = System.Data.EntityState.Modified; _db.SaveChanges(); ModelState.Clear(); ViewBag.alert = "Operator Modified....."; return(View()); } else { _db.tbl_operatorMapping.Add(model); _db.SaveChanges(); ModelState.Clear(); ViewBag.alert = "Operator saved..... "; return(View()); } } else { ViewBag.alert = "Invalid Operator RFID "; return(View()); } } else { ViewBag.alert = "Operator already exist for this shift "; return(View()); } }
public ActionResult truckMapping(tbl_truckMapping model) { weighingcontrolSystemEntities _db = new weighingcontrolSystemEntities(); ViewBag.trucklist = new SelectList(_db.tbl_TruckDetails.ToList(), "pkid", "truckNo"); ViewBag.RFIDList = new SelectList(_db.tbl_rfidDetails.ToList(), "pkid", "RFIDNUMBER"); model.truckNo = _db.tbl_TruckDetails.Where(x => x.pkid == model.truckFKId).FirstOrDefault().truckNo; model.truckRFID = _db.tbl_rfidDetails.Where(x => x.pkid == model.rfif_fkId).FirstOrDefault().RFIDNUMBER; if (model.pkid > 0) { var truckDTL = _db.tbl_truckMapping.Where(x => x.truckRFID == model.truckRFID).ToList(); if (truckDTL.Count() == 0) { _db.Entry(model).State = System.Data.EntityState.Modified; _db.SaveChanges(); ViewBag.alert = "Mapping Modified......"; ModelState.Clear(); return(View()); } else { ViewBag.alert = "RFID Already Mapped With Another Truck......"; return(View()); } } else { var truckDTL = _db.tbl_truckMapping.Where(x => x.truckRFID == model.truckRFID).ToList(); if (truckDTL.Count() == 0) { _db.tbl_truckMapping.Add(model); _db.SaveChanges(); ViewBag.alert = "Mapping saved......"; ModelState.Clear(); return(View()); } else { ViewBag.alert = "RFID Already Mapped With Another Truck....."; return(View()); } } }
public ActionResult operatorMaapingWithContactor(tbl_operatorMapiingWithContactor model) { weighingcontrolSystemEntities _db = new weighingcontrolSystemEntities(); ViewBag.contarctor = new SelectList(_db.tbl_contractor.ToList(), "pkid", "contratorName"); ViewBag.operatorlist = new SelectList(_db.tbl_operatorDetails.ToList(), "pkid", "OperatorName"); if (model.pkid > 0) { if (_db.tbl_operatorMapiingWithContactor.Where(x => x.operatorid == model.operatorid && x.contactorId == model.contactorId).Count() == 0) { model.operatorname = _db.tbl_operatorDetails.Where(x => x.pkid == model.operatorid).FirstOrDefault().OperatorName; model.contactorName = _db.tbl_contractor.Where(x => x.pkid == model.contactorId).FirstOrDefault().contratorName; _db.Entry(model).State = System.Data.EntityState.Modified; _db.SaveChanges(); ViewBag.alert = "Operator mapping modified..."; return(View()); } else { ViewBag.alert = "Operator mapped already exist......"; } } else { if (_db.tbl_operatorMapiingWithContactor.Where(x => x.operatorid == model.operatorid && x.contactorId == model.contactorId).Count() == 0) { model.operatorname = _db.tbl_operatorDetails.Where(x => x.pkid == model.operatorid).FirstOrDefault().OperatorName; model.contactorName = _db.tbl_contractor.Where(x => x.pkid == model.contactorId).FirstOrDefault().contratorName; model.cdate = System.DateTime.Now.Date; _db.tbl_operatorMapiingWithContactor.Add(model); _db.SaveChanges(); } else { ViewBag.alert = "Operator mapped already exist......"; } } return(View()); }
public ActionResult operatorDtails(tbl_operatorDetails model) { weighingcontrolSystemEntities _db = new weighingcontrolSystemEntities(); if (model.pkid > 0) { _db.Entry(model).State = System.Data.EntityState.Modified; _db.SaveChanges(); ViewBag.alert = "Operator details modified.."; ModelState.Clear(); return(View()); } else { _db.tbl_operatorDetails.Add(model); _db.SaveChanges(); ViewBag.alert = "Operator details saved.."; ModelState.Clear(); return(View()); } }
public ActionResult Contractor(tbl_contractor model) { weighingcontrolSystemEntities _db = new weighingcontrolSystemEntities(); if (model.pkid > 0) { _db.Entry(model).State = System.Data.EntityState.Modified; _db.SaveChanges(); ViewBag.alert = "Contractor Modified...."; ModelState.Clear(); return(View()); } else { _db.tbl_contractor.Add(model); _db.SaveChanges(); ViewBag.alert = "Contractor Modified...."; ModelState.Clear(); return(View()); } }
public void start() { weighingcontrolSystemEntities _db = new weighingcontrolSystemEntities(); foreach (var server in _db.tbl_RemoteConnection.ToList()) { #region string connectionstring = "Data Source=" + server.serverName + ";Initial Catalog=" + server.dataBaseName + ";User ID=" + server.userName + ";Password="******";"; //string connectionString=_db.tbl_accessConnection.FirstOrDefault().accessconnection; SqlConnection con = new SqlConnection(connectionstring); //OleDbConnection con= new OleDbConnection(connectionstring); SqlCommand cmd; string date1 = ""; #region if (date1 != "") { long idint = 0; try { idint = (long)_db.tbl_storemachineData.Max(x => x.machinePkid); } catch { idint = 0; } if (date1 == "") { cmd = new SqlCommand("select * from tbl_WeighingMachineFill", con); } else { DateTime dt = DateTime.Now.Date; string datestring = dt.ToString("MM-dd-yyyy"); cmd = new SqlCommand("select * from tbl_WeighingMachineFill where CAST(cdateTime as date)='" + datestring + "' ", con); } try { con.Open(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; DataSet ds = new DataSet(); sda.Fill(ds); con.Close(); using (var ctx = new weighingcontrolSystemEntities()) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { var data = ds.Tables[0].Rows[i][1]; tbl_storemachineData smd = new tbl_storemachineData(); smd.ScaleId = ds.Tables[0].Rows[i][1].ToString().Trim(); smd.truckRFIDIN = ds.Tables[0].Rows[i][2].ToString().Trim(); smd.truckRFIDOUT = ds.Tables[0].Rows[i][3].ToString().Trim(); smd.operatorRFID = ds.Tables[0].Rows[i][4].ToString().Trim(); TimeSpan time1 = TimeSpan.Parse(DateTime.Now.TimeOfDay.ToString()); TimeSpan time2 = TimeSpan.Parse(DateTime.Now.TimeOfDay.ToString()); if (_db.tbl_operatorshift.Where(x => x.shiftstsrtTime <= time1 && x.shiftEndTime >= time2).Count() > 0) { smd.shiftTime = _db.tbl_operatorshift.Where(x => x.shiftstsrtTime <= time1 && x.shiftEndTime >= time2).FirstOrDefault().pkid; } smd.material = ds.Tables[0].Rows[i][5].ToString().Trim(); smd.grossWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][6].ToString().Trim()); smd.dateTimeMachine = Convert.ToDateTime(ds.Tables[0].Rows[i][7].ToString().Trim()); smd.machinePkid = Convert.ToInt32(ds.Tables[0].Rows[i][0].ToString().Trim()); // rfid MappedOrNot if (_db.tbl_truckMapping.Where(x => x.truckRFID == smd.truckRFIDIN || x.truckRFID == smd.truckRFIDOUT).Count() == 1) { // Truck In and unque Record save into database othe wise skip if (smd.truckRFIDIN != "" && _db.tbl_storemachineData.Where(x => x.truckRFIDIN == smd.truckRFIDIN && x.ScaleId == smd.ScaleId && x.dateTimeMachine == smd.dateTimeMachine).Count() == 0) { smd.status = "IN"; smd.netWeight = 0; smd.fairWeight = smd.grossWeight; _db.tbl_storemachineData.Add(smd); _db.SaveChanges(); } else { if (smd.truckRFIDOUT != "" && _db.tbl_storemachineData.Where(x => x.truckRFIDOUT == smd.truckRFIDOUT && x.ScaleId == smd.ScaleId && x.dateTimeMachine == smd.dateTimeMachine).Count() == 0) { if (_db.tbl_storemachineData.Where(x => x.truckRFIDIN == smd.truckRFIDOUT).Count() > 0) { long maxId = _db.tbl_storemachineData.Where(x => x.truckRFIDIN == smd.truckRFIDOUT).Max(x => x.pkid); decimal maxVal = (decimal)_db.tbl_storemachineData.Where(x => x.pkid == maxId).FirstOrDefault().grossWeight; if (maxVal != 0) { smd.status = "OUT"; smd.netWeight = smd.grossWeight - maxVal; smd.fairWeight = maxVal; } } else { smd.status = "OUT"; smd.netWeight = smd.grossWeight; smd.fairWeight = smd.grossWeight; smd.outGrossWeight = smd.grossWeight; smd.outNetWeight = smd.grossWeight; smd.outPkid = smd.machinePkid; smd.netWeight = 0; } if (smd.truckRFIDOUT != "" && smd.truckRFIDOUT != null && smd.status == "OUT") { try { long maxId = _db.tbl_storemachineData.Where(x => x.truckRFIDIN == smd.truckRFIDOUT && x.outPkid == null).Max(x => x.pkid); if (maxId > 0) { var updateData = _db.tbl_storemachineData.Where(x => x.pkid == maxId).FirstOrDefault(); updateData.outPkid = Convert.ToInt32(ds.Tables[0].Rows[i][0].ToString().Trim()); updateData.material = ds.Tables[0].Rows[i][5].ToString().Trim(); updateData.outGrossWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][6].ToString().Trim()); updateData.outTime = Convert.ToDateTime(ds.Tables[0].Rows[i][7].ToString().Trim()); updateData.outLocation = smd.ScaleId; TimeSpan Outtime1 = TimeSpan.Parse(ds.Tables[0].Rows[i][7].ToString().Trim()); if (_db.tbl_operatorshift.Where(x => x.shiftstsrtTime <= Outtime1 && x.shiftEndTime >= Outtime1).Count() > 0) { updateData.outShift = _db.tbl_operatorshift.Where(x => x.shiftstsrtTime <= Outtime1 && x.shiftEndTime >= Outtime1).FirstOrDefault().pkid; } else { updateData.outShift = 0; } _db.Entry(updateData).State = EntityState.Modified; _db.SaveChanges(); } else { _db.tbl_storemachineData.Add(smd); _db.SaveChanges(); } } catch { } } } } } } } } catch (Exception ex) { //itechDll.Commonfunction.LogError(ex, @"~/Errorlog.txt"); Commonfunction.LogError(ex, Path.Combine("~/ErrorLog.txt")); } #endregion } else { long idint = 0; try { idint = (long)_db.tbl_storemachineData.Max(x => x.machinePkid); } catch { idint = 0; } cmd = new SqlCommand("select * from tbl_WeighingMachineFill where pkid>=" + idint + " ", con); try { con.Open(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; DataSet ds = new DataSet(); sda.Fill(ds); con.Close(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { var data = ds.Tables[0].Rows[i][1]; tbl_storemachineData smd = new tbl_storemachineData(); smd.ScaleId = ds.Tables[0].Rows[i][1].ToString().Trim(); smd.truckRFIDIN = ds.Tables[0].Rows[i][2].ToString().Trim(); smd.truckRFIDOUT = ds.Tables[0].Rows[i][3].ToString().Trim(); smd.operatorRFID = ds.Tables[0].Rows[i][4].ToString().Trim(); // shift Time TimeSpan time1 = TimeSpan.Parse(DateTime.Now.TimeOfDay.ToString()); TimeSpan time2 = TimeSpan.Parse(DateTime.Now.TimeOfDay.ToString()); if (_db.tbl_operatorshift.Where(x => x.shiftstsrtTime <= time1 && x.shiftEndTime >= time2).Count() > 0) { smd.shiftTime = _db.tbl_operatorshift.Where(x => x.shiftstsrtTime <= time1 && x.shiftEndTime >= time2).FirstOrDefault().pkid; } smd.material = ds.Tables[0].Rows[i][5].ToString().Trim(); smd.grossWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][6].ToString().Trim()); smd.dateTimeMachine = Convert.ToDateTime(ds.Tables[0].Rows[i][7].ToString().Trim()); smd.machinePkid = Convert.ToInt32(ds.Tables[0].Rows[i][0].ToString().Trim()); // rfid MappedOrNot if (_db.tbl_truckMapping.Where(x => x.truckRFID == smd.truckRFIDIN || x.truckRFID == smd.truckRFIDOUT).Count() == 1) { // Truck In and unque Record save into database othe wise skip if (smd.truckRFIDIN != "" && _db.tbl_storemachineData.Where(x => x.truckRFIDIN == smd.truckRFIDIN && x.ScaleId == smd.ScaleId && x.dateTimeMachine == smd.dateTimeMachine).Count() == 0) { smd.status = "IN"; smd.netWeight = 0; smd.fairWeight = smd.grossWeight; _db.tbl_storemachineData.Add(smd); _db.SaveChanges(); } else { if (smd.truckRFIDOUT != "" && _db.tbl_storemachineData.Where(x => x.truckRFIDOUT == smd.truckRFIDOUT && x.ScaleId == smd.ScaleId && x.dateTimeMachine == smd.dateTimeMachine).Count() == 0) { if (_db.tbl_storemachineData.Where(x => x.truckRFIDIN == smd.truckRFIDOUT && x.outPkid == null).Count() > 0) { long maxId = _db.tbl_storemachineData.Where(x => x.truckRFIDIN == smd.truckRFIDOUT).Max(x => x.pkid); decimal maxVal = (decimal)_db.tbl_storemachineData.Where(x => x.pkid == maxId).FirstOrDefault().grossWeight; if (maxVal != 0) { smd.status = "OUT"; smd.netWeight = smd.grossWeight - maxVal; smd.fairWeight = maxVal; } } else { smd.status = "OUT"; smd.netWeight = smd.grossWeight; smd.fairWeight = smd.grossWeight; smd.outGrossWeight = smd.grossWeight; smd.outNetWeight = smd.grossWeight; smd.outPkid = smd.machinePkid; smd.netWeight = 0; } if (smd.truckRFIDOUT != "" && smd.truckRFIDOUT != null && smd.status == "OUT") { try { long maxId = 0; try { maxId = _db.tbl_storemachineData.Where(x => x.truckRFIDIN == smd.truckRFIDOUT).Max(x => x.pkid); } catch { } if (maxId > 0) { var updateData = _db.tbl_storemachineData.Where(x => x.pkid == maxId).FirstOrDefault(); // masterid = Convert.ToInt32(ds.Tables[0].Rows[i][0]); updateData.outPkid = Convert.ToInt32(ds.Tables[0].Rows[i][0].ToString().Trim()); updateData.material = ds.Tables[0].Rows[i][5].ToString().Trim(); //updateData.truckRFIDIN = ds.Tables[0].Rows[i][2].ToString().Trim(); try { updateData.outGrossWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][6].ToString().Trim()); } catch { //cmd.CommandText = "SELECT top 1 TgrossWeight FROM [TBForce].[dbo].[tbl_WeighingMachineFill] WHERE pkid < (" + masterid + ") and RFID1 = " + updateData.truckRFIDIN + "ORDER BY pkid DESC"; //cmd.CommandType = CommandType.Text; //cmd.Connection = con; //con.Open(); //returnValue = cmd.ExecuteScalar(); //con.Close(); //smd.grossWeight = Convert.ToDecimal(returnValue); } updateData.outTime = Convert.ToDateTime(ds.Tables[0].Rows[i][7].ToString().Trim()); updateData.outLocation = smd.ScaleId; TimeSpan Outtime1 = TimeSpan.Parse(ds.Tables[0].Rows[i][7].ToString().Trim()); if (_db.tbl_operatorshift.Where(x => x.shiftstsrtTime <= Outtime1 && x.shiftEndTime >= Outtime1).Count() > 0) { updateData.outShift = _db.tbl_operatorshift.Where(x => x.shiftstsrtTime <= Outtime1 && x.shiftEndTime >= Outtime1).FirstOrDefault().pkid; } else { updateData.outShift = 0; } _db.Entry(updateData).State = EntityState.Modified; _db.SaveChanges(); } else { _db.tbl_storemachineData.Add(smd); _db.SaveChanges(); } } catch { } } } else { } } } else { if (smd.grossWeight > 50) { smd.truckRFIDOUT = "0088"; smd.status = "OUT"; smd.netWeight = smd.grossWeight; smd.fairWeight = smd.grossWeight; smd.outGrossWeight = smd.grossWeight; smd.outNetWeight = smd.grossWeight; smd.outPkid = smd.machinePkid; _db.tbl_storemachineData.Add(smd); _db.SaveChanges(); } else { smd.truckRFIDIN = "0088"; smd.status = "IN"; smd.netWeight = 0; smd.fairWeight = smd.grossWeight; _db.tbl_storemachineData.Add(smd); _db.SaveChanges(); } } } } catch (Exception ex) { //Commonfunction.LogError(ex, Path.Combine("~/ErrorLog.txt")); } } } #endregion }