public tblMachineWorkingParameter getLoggedInUserWeigh() { string machineId = Session["WBID"].ToString(); tblMachineWorkingParameter mwparameter = _transactionRepo.getMachineWorkingParameters(machineId); return(mwparameter); }
public string Get_Machines_ByMachineId(int id) { tblMachineWorkingParameter _mat = _machinerepo.Get_MachinebyId(id); string jsonstrin = new JavaScriptSerializer().Serialize(_mat); return(jsonstrin); }
//Update:MachineWorkingParameter Record protected void UpdateMachine() { if (Request.QueryString["Id"] != null) { try { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); tblMachineWorkingParameter data = _workrepo.GetMachineWorkingParameters_List().FirstOrDefault(x => x.PlantCode == ddlPlantCode.SelectedValue && x.MachineId == ddlMachineName.SelectedValue && x.IsDeleted == false && x.Id != id); tblMachineWorkingParameter data2 = _workrepo.GetMachineWorkingParameters_List().FirstOrDefault(x => x.IPPort == txtIPPort.Text && x.PlantCode == ddlPlantCode.SelectedValue && x.Id != id && x.IsDeleted == false); if (data != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Machine Configuration Exist! Please try again');", true); } else if (data2 != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same IP Port Already Exist! Please Try Again');", true); } else { tblMachineWorkingParameter machine = db.tblMachineWorkingParameters.Where(x => x.Id == id && x.IsDeleted == false).FirstOrDefault(); if (machine != null) { machine.IPPort = txtIPPort.Text; machine.IsDeleted = false; machine.MachineId = ddlMachineName.SelectedValue; machine.ModeOfComs = txtModeofComs.SelectedValue; // txtModeofComs.Text; machine.PlantCode = ddlPlantCode.SelectedValue; machine.PortNo = txtPortNo.Text; machine.StabilityNos = txtStabilityNos.Text; machine.StabilityRange = txtStabilityRange.Text; machine.StoredTare = Convert.ToInt32(ddlstoredtare.SelectedValue); machine.TareCheck = Convert.ToInt32(ddltarecheck.SelectedValue); machine.TransactionNoPrefix = txtTransactionPrefix.Text; machine.ZeroInterlock = Convert.ToInt32(ddlzerointerlock.SelectedValue); machine.ZeroInterlockRange = txtZeroInterlockRange.Text; machine.TareScheme = ddlTareToleranceType.Text; if (!string.IsNullOrEmpty(txtWtValue.Text)) { machine.TareWeightValue = Convert.ToInt32(txtWtValue.Text); } db.SubmitChanges(); ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Record Updated Successfully')", true); HtmlMeta meta = new HtmlMeta { HttpEquiv = "Refresh", Content = "1;url=AddEdit.aspx?id=" + id }; this.Page.Controls.Add(meta); } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true); } } }
public string CheckStoredtareWt() { tblMachineWorkingParameter _tstoreenabled = db.tblMachineWorkingParameters.Where(x => x.Id == 1).FirstOrDefault(); //.Where(x => x.PlantCode == Session["PlantID"].ToString() && x.MachineId == Session["WBID"].ToString()).FirstOrDefault(); string myJsonString = (new JavaScriptSerializer()).Serialize(_tstoreenabled.StoredTare.ToString()); return(myJsonString); }
//Add:New MachineWorkingParameter public bool Add_WorkingParameter(tblMachineWorkingParameter model) { bool status = false; if (model != null) { db.tblMachineWorkingParameters.InsertOnSubmit(model); db.SubmitChanges(); status = true; } return(status); }
public tblMachineWorkingParameter getLoggedInUserWeigh() { string machineId = string.Empty; try { machineId = Session["WBID"].ToString(); } catch { Response.Redirect("~/Login.aspx"); } tblMachineWorkingParameter mwparameter = _transactionRepo.getMachineWorkingParameters(machineId); return(mwparameter); }
//Delete:MachineWorkingParameter public bool Delete_WorkingParameter(int id) { bool status = false; tblMachineWorkingParameter machine = db.tblMachineWorkingParameters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); if (machine != null) { machine.IsDeleted = true; db.SubmitChanges(); status = true; } return(status); }
//Get:Previous Record from machine working parameter protected void Previous_Record_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); tblMachineWorkingParameter next = null; try { next = _workrepo.GetMachineWorkingParameters_List().Where(x => x.Id < id && x.IsDeleted == false).OrderByDescending(i => i.Id).FirstOrDefault(); } catch { } if (next != null) { Response.Redirect("AddEdit.aspx?id=" + next.Id.ToString()); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('No more records founds.')", true); } }
internal tblMachineWorkingParameter getMachineWorkingParameters(string machineId) { tblMachineWorkingParameter tbl = db.tblMachineWorkingParameters.FirstOrDefault(x => x.MachineId == machineId); return(tbl); }
public string GetWeightFromTCPIP_SS() { string output = "No weight"; // for inicator ip address and port no string strIndicatorIPAddress = string.Empty; string strIndicatorPortNo = string.Empty; tblMachineWorkingParameter tbl = getLoggedInUserWeigh(); try { strIndicatorPortNo = tbl.PortNo; strIndicatorIPAddress = tbl.IPPort; } catch { } s3 = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp); IPAddress hostadd = IPAddress.Parse(strIndicatorIPAddress); IPEndPoint EPhost = new IPEndPoint(hostadd, Convert.ToInt32(strIndicatorPortNo)); string weight = ""; s3.ReceiveTimeout = 500; try { s3.Connect(EPhost); if (s3.Connected) { try { Byte[] sbyte1 = new Byte[] { 0x5 }; s3.Send(sbyte1); System.Threading.Thread.Sleep(500); } catch { } Byte[] receive = new Byte[37]; int ret = s3.Receive(receive, receive.Length, 0); if (ret > 0) { string tmp = null; tmp = System.Text.Encoding.ASCII.GetString(receive); if (tmp.Length > 0) { weight = tmp.Substring(tmp.IndexOf("") + "".Length, 7).Trim(); } } s3.Disconnect(true); } } catch (Exception e1) { return(output); } return(weight); }
//Save:Excel file data to the server public string SaveDataToServer(DataSet ds) { string result = string.Empty; using (DataClasses1DataContext db = new DataClasses1DataContext()) { string connection = ConfigurationManager.ConnectionStrings["AveryDBConnectionString"].ConnectionString; DataTable dt = ds.Tables[0]; int _failed = 0; int _success = 0; int _update = 0; foreach (DataRow dr in dt.Rows) { try { string _PlantCode = dr["Plant Code"].ToString(); string _MachineId = dr["Machine Id"].ToString(); string _IPPort = dr["IP Port"].ToString(); string _PortNo = dr["Port No"].ToString(); string _ModeOfComs = dr["Mode Of Coms"].ToString(); string _StabilityNos = dr["Stability Nos"].ToString(); string _StabilityRange = dr["Stability Range"].ToString(); int _ZeroInterlock = Convert.ToInt32(dr["Zero Interlock"]); string _ZeroInterlockRange = dr["Zero Interlock Range"].ToString(); string _TransactionNoPrefix = dr["Transaction No Prefix"].ToString(); int _TareCheck = Convert.ToInt32(dr["Tare Check"]); int _StoredTare = Convert.ToInt32(dr["Stored Tare"]); var data = db.tblMachineWorkingParameters.Where(x => x.PlantCode == _PlantCode && x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault(); if (data != null) { if (string.IsNullOrEmpty(_IPPort) && string.IsNullOrEmpty(_PortNo) && string.IsNullOrEmpty(_ModeOfComs)) { _failed++; } else { data.PlantCode = _PlantCode; data.MachineId = _MachineId; data.IPPort = _IPPort; data.PortNo = _PortNo; data.StabilityNos = _StabilityNos; data.StabilityRange = _StabilityRange; data.TransactionNoPrefix = _TransactionNoPrefix; data.ZeroInterlock = _ZeroInterlock; data.ZeroInterlockRange = _ZeroInterlockRange; data.ModeOfComs = _ModeOfComs; data.TareCheck = _TareCheck; data.StoredTare = _StoredTare; db.SubmitChanges(); _update++; } } else { if (!string.IsNullOrEmpty(_PlantCode) && !string.IsNullOrEmpty(_MachineId) && !string.IsNullOrEmpty(_ModeOfComs) && !string.IsNullOrEmpty(_IPPort) && !string.IsNullOrEmpty(_PortNo)) { PlantMaster _plantmaster = db.PlantMasters.Where(x => x.PlantCode == _PlantCode && x.IsDeleted == false).FirstOrDefault(); WeightMachineMaster _machinemaster = db.WeightMachineMasters.Where(x => x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault(); if (_plantmaster != null && _machinemaster != null) { tblMachineWorkingParameter _machineparameter = db.tblMachineWorkingParameters.Where(x => x.PlantCode == _PlantCode && x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault(); if (_machineparameter != null) { _failed++; } else { tblMachineWorkingParameter t = new tblMachineWorkingParameter(); t.PlantCode = _PlantCode; t.MachineId = _MachineId; t.IPPort = _IPPort; t.PortNo = _PortNo; t.StabilityNos = _StabilityNos; t.StabilityRange = _StabilityRange; t.TransactionNoPrefix = _TransactionNoPrefix; t.ZeroInterlock = _ZeroInterlock; t.ZeroInterlockRange = _ZeroInterlockRange; t.TareCheck = _TareCheck; t.StoredTare = _StoredTare; t.ModeOfComs = _ModeOfComs; db.tblMachineWorkingParameters.InsertOnSubmit(t); db.SubmitChanges(); _success++; } } else { _failed++; } } else { _failed++; } } } catch { _failed++; } } result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + ""; } return(result); }
//Get:Machine By Id internal tblMachineWorkingParameter Get_MachinebyId(int id) { tblMachineWorkingParameter obj = db.tblMachineWorkingParameters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); return(obj); }
//Get:MachineWorkingParameter By Id public tblMachineWorkingParameter Get_WorkingParameterById(int id) { tblMachineWorkingParameter machine = db.tblMachineWorkingParameters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); return(machine); }