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);
}
