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