protected void btnSave_Click(object sender, EventArgs e)
{
try
{
int id = 0;
SiteParameterSetting setting = db.SiteParameterSettings.FirstOrDefault();
if (setting == null)
{
setting.AlphaNumericDisplay = Convert.ToInt32(ddlAlphaNumericDisplay.SelectedItem.Value);
setting.AuthorizedForTARE = Convert.ToInt32(ddlAuthorizeforTare.SelectedItem.Value);
setting.AxleWeighting = Convert.ToInt32(ddlAxleWeighting.SelectedItem.Value);
setting.Barriers = Convert.ToInt32(ddlBarriers.SelectedItem.Value);
setting.Cameras = Convert.ToInt32(ddlCamera.SelectedItem.Value);
setting.ConnectivityToCustomer = Convert.ToInt32(ddlConnectivityToCustomers.SelectedItem.Value);
setting.CreateDate = DateTime.Now;
setting.IsGateEntry = Convert.ToInt32(ddlgateEntry.SelectedItem.Value);
setting.NoSpectalCharacterForTruck = Convert.ToInt32(ddlNoSpecialCharacter.SelectedItem.Value);
setting.PASystem = Convert.ToInt32(ddlPASystem.SelectedItem.Value);
setting.RFIDReader = Convert.ToInt32(ddlRFIDReader.SelectedItem.Value);
setting.Sensors = Convert.ToInt32(ddlSendors.SelectedItem.Value);
setting.TMS = Convert.ToInt32(ddlTMS.SelectedItem.Value);
setting.ToleranceCheckforCustQty = Convert.ToInt32(ddlCusTolerance.SelectedItem.Value);
setting.ToleranceCheckforSupQty = Convert.ToInt32(ddlSupTolerance.SelectedItem.Value);
db.SiteParameterSettings.InsertOnSubmit(setting);
db.SubmitChanges();
}
else
{
setting.AlphaNumericDisplay = Convert.ToInt32(ddlAlphaNumericDisplay.SelectedItem.Value);
setting.AuthorizedForTARE = Convert.ToInt32(ddlAuthorizeforTare.SelectedItem.Value);
setting.AxleWeighting = Convert.ToInt32(ddlAxleWeighting.SelectedItem.Value);
setting.Barriers = Convert.ToInt32(ddlBarriers.SelectedItem.Value);
setting.Cameras = Convert.ToInt32(ddlCamera.SelectedItem.Value);
setting.ConnectivityToCustomer = Convert.ToInt32(ddlConnectivityToCustomers.SelectedItem.Value);
setting.CreateDate = DateTime.Now;
setting.IsGateEntry = Convert.ToInt32(ddlgateEntry.SelectedItem.Value);
setting.NoSpectalCharacterForTruck = Convert.ToInt32(ddlNoSpecialCharacter.SelectedItem.Value);
setting.PASystem = Convert.ToInt32(ddlPASystem.SelectedItem.Value);
setting.RFIDReader = Convert.ToInt32(ddlRFIDReader.SelectedItem.Value);
setting.Sensors = Convert.ToInt32(ddlSendors.SelectedItem.Value);
setting.TMS = Convert.ToInt32(ddlTMS.SelectedItem.Value);
setting.ToleranceCheckforCustQty = Convert.ToInt32(ddlCusTolerance.SelectedItem.Value);
setting.ToleranceCheckforSupQty = Convert.ToInt32(ddlSupTolerance.SelectedItem.Value);
db.SubmitChanges();
}
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.success('Settings saved successfully.');", true);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.error('" + ex.Message.ToString() + "');", true);
}
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
string _UserName = UserName.Value;
string _Password = Password.Value;
string _WBID = WBID.Value;
string _PlantID = PlantID.Value;
UserMaster um = umRepo.CheckUserCredentials(_UserName, _Password, _WBID, _PlantID);
SiteParameterSetting setting = db.SiteParameterSettings.FirstOrDefault();
PlantMaster _plantCode = db.PlantMasters.Where(x => x.PlantCode == _PlantID).FirstOrDefault();
if (um != null && um.Id != 0)
{
Session["UserName"] = _UserName;
Session["Password"] = _Password;
Session["WBID"] = _WBID;
Session["UserId"] = um.Id;
Session["PlantID"] = _PlantID;
Session["CompanyCode"] = _plantCode.CompanyCode;
Session["WBFORM"] = "0";
GLOBALVARIABLE();
FormsAuthentication.RedirectFromLoginPage(um.Id.ToString(), true);
UserClassification uc = umRepo.GetUserAuthorization(um.Id);
New_Weighing_Unit(_WBID, _PlantID);
Session["FIRSTWT_RCD"] = "0";
Session["SECONDWT_RCD"] = "0";
if (uc != null)
{
if (uc.GateEntry == true)
{
Response.Redirect("/GateEntryForm");
}
else if (uc.Weighment == false)
{
Session["WBFORM"] = "1";
Response.Redirect("/ManageMasters");
}
else
{
Response.Redirect("/Manual_Weighment");
}
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.error('No User account found. Please try again.');", true);
}
}
private void BindSettingsFromDB()
{
Image5.ImageUrl = "images/Type5/wi_base_normal.png";
SiteParameterSetting setting = db.SiteParameterSettings.FirstOrDefault();
if (setting != null)
{
if (setting.Cameras == 1)
{
Image6.ImageUrl = "images/Type5/wi_view_normal.png";
}
else
{
Image6.ImageUrl = "images/Type5/wi_view_disable.png";
}
if (setting.Sensors == 1)
{
Image7.ImageUrl = "images/Type5/wi_sense_normal.png";
}
else
{
Image7.ImageUrl = "images/Type5/wi_sense_disable.png";
}
if (setting.RFIDReader == 1)
{
Image8.ImageUrl = "images/Type5/wi_tag_normal.png";
}
else
{
Image8.ImageUrl = "images/Type5/wi_tag_disable.png";
}
if (setting.ConnectivityToCustomer == 1)
{
Image9.ImageUrl = "images/Type5/wi_connect_normal.png";
}
else
{
Image9.ImageUrl = "images/Type5/wi_connect_disable.png";
}
}
}
private void BindData()
{
SiteParameterSetting setting = db.SiteParameterSettings.FirstOrDefault();
if (setting != null)
{
ddlAlphaNumericDisplay.SelectedValue = ddlAlphaNumericDisplay.Items.FindByValue(setting.AlphaNumericDisplay.Value.ToString()).Value;
ddlAuthorizeforTare.SelectedValue = ddlAuthorizeforTare.Items.FindByValue(setting.AuthorizedForTARE.Value.ToString()).Value;
ddlAxleWeighting.SelectedValue = ddlAxleWeighting.Items.FindByValue(setting.AxleWeighting.Value.ToString()).Value;
ddlBarriers.SelectedValue = ddlBarriers.Items.FindByValue(setting.Barriers.Value.ToString()).Value;
ddlCamera.SelectedValue = ddlCamera.Items.FindByValue(setting.Cameras.Value.ToString()).Value;
ddlConnectivityToCustomers.SelectedValue = ddlConnectivityToCustomers.Items.FindByValue(setting.ConnectivityToCustomer.Value.ToString()).Value;
ddlgateEntry.SelectedValue = ddlgateEntry.Items.FindByValue(setting.IsGateEntry.Value.ToString()).Value;
ddlNoSpecialCharacter.SelectedValue = ddlNoSpecialCharacter.Items.FindByValue(setting.NoSpectalCharacterForTruck.Value.ToString()).Value;
ddlPASystem.SelectedValue = ddlPASystem.Items.FindByValue(setting.PASystem.Value.ToString()).Value;
ddlRFIDReader.SelectedValue = ddlRFIDReader.Items.FindByValue(setting.RFIDReader.Value.ToString()).Value;
ddlSendors.SelectedValue = ddlSendors.Items.FindByValue(setting.Sensors.Value.ToString()).Value;
ddlTMS.SelectedValue = ddlTMS.Items.FindByValue(setting.TMS.Value.ToString()).Value;
ddlCusTolerance.SelectedValue = ddlCusTolerance.Items.FindByValue(setting.ToleranceCheckforCustQty.Value.ToString()).Value;
ddlSupTolerance.SelectedValue = ddlSupTolerance.Items.FindByValue(setting.ToleranceCheckforSupQty.Value.ToString()).Value;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string varPlantCode = string.Empty;
string varMachineId = string.Empty;
bool varPlantCode_Exist = false;
if (ddlplantCode.SelectedItem.Value == "0")
{
varPlantCode = ddlplantCode.SelectedItem.Value;
varPlantCode = "";
}
else
{
varPlantCode = ddlplantCode.SelectedItem.Value;
}
varMachineId = ddlMachineId.SelectedItem.Value;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AveryDBConnectionString"].ConnectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("select * from SiteParameterSettings where PlantCodeId='" + varPlantCode + "' and WeightMachineId='" + varMachineId + "'", con))
{
using (SqlDataAdapter ds = new SqlDataAdapter(cmd))
{
using (DataTable dtbl = new DataTable())
{
ds.Fill(dtbl);
if (dtbl.Rows.Count > 0)
{
varPlantCode_Exist = true;
}
else
{
varPlantCode_Exist = false;
}
}
}
}
}
try
{
int id = 0;
SiteParameterSetting setting = db.SiteParameterSettings.FirstOrDefault(); // (x => x.PlantCodeId == varPlantCode && x.WeightMachineId == varMachineId);
if (varPlantCode_Exist == false) // setting == null)
{
AddSiteParameters(varPlantCode, varMachineId);
//setting.PlantCodeId = varPlantCode;
//setting.WeightMachineId = varMachineId;
//setting.AlphaNumericDisplay = Convert.ToInt32(ddlAlphaNumericDisplay.SelectedItem.Value);
//setting.AuthorizedForTARE = Convert.ToInt32(ddlAuthorizeforTare.SelectedItem.Value);
//setting.AxleWeighting = Convert.ToInt32(ddlAxleWeighting.SelectedItem.Value);
//setting.Barriers = Convert.ToInt32(ddlBarriers.SelectedItem.Value);
//setting.Cameras = Convert.ToInt32(ddlCamera.SelectedItem.Value);
//setting.ConnectivityToCustomer = Convert.ToInt32(ddlConnectivityToCustomers.SelectedItem.Value);
//setting.CreateDate = DateTime.Now;
//setting.IsGateEntry = Convert.ToInt32(ddlgateEntry.SelectedItem.Value);
//setting.NoSpectalCharacterForTruck = Convert.ToInt32(ddlNoSpecialCharacter.SelectedItem.Value);
//setting.PASystem = Convert.ToInt32(ddlPASystem.SelectedItem.Value);
//setting.RFIDReader = Convert.ToInt32(ddlRFIDReader.SelectedItem.Value);
//setting.Sensors = Convert.ToInt32(ddlSendors.SelectedItem.Value);
//setting.TMS = Convert.ToInt32(ddlTMS.SelectedItem.Value);
//setting.ToleranceCheckforCustQty = Convert.ToInt32(ddlCusTolerance.SelectedItem.Value);
//setting.ToleranceCheckforSupQty = Convert.ToInt32(ddlSupTolerance.SelectedItem.Value);
//db.SiteParameterSettings.InsertOnSubmit(setting);
//db.SubmitChanges();
}
else
{
setting.PlantCodeId = varPlantCode;
setting.WeightMachineId = varMachineId;
setting.AlphaNumericDisplay = Convert.ToInt32(ddlAlphaNumericDisplay.SelectedItem.Value);
setting.AuthorizedForTARE = Convert.ToInt32(ddlAuthorizeforTare.SelectedItem.Value);
setting.AxleWeighting = Convert.ToInt32(ddlAxleWeighting.SelectedItem.Value);
setting.Barriers = Convert.ToInt32(ddlBarriers.SelectedItem.Value);
setting.Cameras = Convert.ToInt32(ddlCamera.SelectedItem.Value);
setting.ConnectivityToCustomer = Convert.ToInt32(ddlConnectivityToCustomers.SelectedItem.Value);
setting.CreateDate = DateTime.Now;
setting.IsGateEntry = Convert.ToInt32(ddlgateEntry.SelectedItem.Value);
setting.NoSpectalCharacterForTruck = Convert.ToInt32(ddlNoSpecialCharacter.SelectedItem.Value);
setting.PASystem = Convert.ToInt32(ddlPASystem.SelectedItem.Value);
setting.RFIDReader = Convert.ToInt32(ddlRFIDReader.SelectedItem.Value);
setting.Sensors = Convert.ToInt32(ddlSendors.SelectedItem.Value);
setting.TMS = Convert.ToInt32(ddlTMS.SelectedItem.Value);
setting.ToleranceCheckforCustQty = Convert.ToInt32(ddlCusTolerance.SelectedItem.Value);
setting.ToleranceCheckforSupQty = Convert.ToInt32(ddlSupTolerance.SelectedItem.Value);
db.SubmitChanges();
}
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.success('Settings saved successfully.');", true);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.error('" + ex.Message.ToString() + "');", true);
}
}
