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
}
