//Get:User Classfication for update private void Get_UserClassificationForUpdate() { if (Request.QueryString["Id"] != null) { try { divoptions.Style.Add("display", "block"); txtUserType.Enabled = false; int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); UserClassification Uc = repo.GetUserClassification_by_Id(id); if (Uc != null) { txtUserType.Text = Uc.UserType; ddlConfiguaration.SelectedValue = ddlConfiguaration.Items.FindByValue(Uc.Configuration.Value == true ? "1" : "0").Value; ddlDatabaseOperation.SelectedValue = ddlDatabaseOperation.Items.FindByValue(Uc.DatabaseOperation.Value == true ? "1" : "0").Value; ddlGateEntry.SelectedValue = ddlGateEntry.Items.FindByValue(Uc.GateEntry.Value == true ? "1" : "0").Value; ddlMasterFileDeletion.SelectedValue = ddlMasterFileDeletion.Items.FindByValue(Uc.MasterFileUpdation.Value == true ? "1" : "0").Value; ddlMasterRecordDeletion.SelectedValue = ddlMasterRecordDeletion.Items.FindByValue(Uc.MasterRecordDeletion.Value == true ? "1" : "0").Value; ddlPasswordPolicy.SelectedValue = ddlPasswordPolicy.Items.FindByValue(Uc.PasswordPolicy.Value == true ? "1" : "0").Value; ddlPasswordReset.SelectedValue = ddlPasswordReset.Items.FindByValue(Uc.PasswordReset.Value == true ? "1" : "0").Value; ddlPendingRecordDeletion.SelectedValue = ddlPendingRecordDeletion.Items.FindByValue(Uc.PendingRecordDeletion.Value == true ? "1" : "0").Value; ddlRFIDIssue.SelectedValue = ddlRFIDIssue.Items.FindByValue(Uc.RFIDIssue.Value == true ? "1" : "0").Value; ddlTransactionDeletion.SelectedValue = ddlTransactionDeletion.Items.FindByValue(Uc.TransactionDeletion.Value == true ? "1" : "0").Value; ddlUserCreation.SelectedValue = ddlUserCreation.Items.FindByValue(Uc.UserCreation.Value == true ? "1" : "0").Value; ddlWeighment.SelectedValue = ddlWeighment.Items.FindByValue(Uc.Weighment.Value == true ? "1" : "0").Value; } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true); } } }
internal UserClassification GetUserAuthorization(int id) { UserClassification um = (from a in db.UserMasters join b in db.UserClassifications on a.UserType equals b.Id where a.Id == id select b).FirstOrDefault(); return(um); }
//Add:New UserClassification public bool Add_UserClassification(UserClassification user) { bool status = false; if (user != null) { db.UserClassifications.InsertOnSubmit(user); db.SubmitChanges(); status = true; } return(status); }
//Delete:UserClassification by Id public bool Delete_UserClassification(int id) { bool status = false; UserClassification uc = db.UserClassifications.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); if (uc != null) { uc.IsDeleted = true; db.SubmitChanges(); status = true; } return(status); }
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); } }
//Get:Update User Classification private void Update_UserClassification() { if (!string.IsNullOrEmpty(Request.QueryString["Id"])) { try { int Id = Convert.ToInt32(Request.QueryString["Id"].ToString()); //UserClassification Uc = repo.GetUserClassification_by_Id(Id); UserClassification Uc = db.UserClassifications.FirstOrDefault(x => x.Id == Id && x.IsDeleted == false); if (Uc != null) { UserClassification _data = repo.Get_ActiveUserClassificationList().Where(x => x.UserType == txtUserType.Text && x.IsDeleted == false && x.Id != Id).FirstOrDefault(); if (_data != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same usertype exist.please try again.');", true); } else { Uc.UserType = txtUserType.Text; Uc.Configuration = ddlConfiguaration.SelectedItem.Value == "0" ? false : true; Uc.DatabaseOperation = ddlDatabaseOperation.SelectedItem.Value == "0" ? false : true; Uc.GateEntry = ddlGateEntry.SelectedItem.Value == "0" ? false : true; Uc.MasterFileUpdation = ddlMasterFileDeletion.SelectedItem.Value == "0" ? false : true; Uc.MasterRecordDeletion = ddlMasterRecordDeletion.SelectedItem.Value == "0" ? false : true; Uc.PasswordPolicy = ddlPasswordPolicy.SelectedItem.Value == "0" ? false : true; Uc.PasswordReset = ddlPasswordReset.SelectedItem.Value == "0" ? false : true; Uc.PendingRecordDeletion = ddlPendingRecordDeletion.SelectedItem.Value == "0" ? false : true; Uc.RFIDIssue = ddlRFIDIssue.SelectedItem.Value == "0" ? false : true; Uc.TransactionDeletion = ddlTransactionDeletion.SelectedItem.Value == "0" ? false : true; Uc.UserCreation = ddlUserCreation.SelectedItem.Value == "0" ? false : true; Uc.Weighment = ddlWeighment.SelectedItem.Value == "0" ? false : true; db.SubmitChanges(); ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.success('User Classification 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); } } }
//:Add New UserType in UserClassification private void Add_UserClassification() { if (Request.QueryString["Id"] == null) { try { UserClassification Uc = repo.GetUserClassification_by_UserType(txtUserType.Text.Trim()); if (Uc != null) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.error('Same User type exist. Please try again later.');", true); } else { Uc = new UserClassification(); Uc.UserType = txtUserType.Text.Trim(); Uc.Configuration = ddlConfiguaration.SelectedItem.Value == "0" ? false : true; Uc.DatabaseOperation = ddlDatabaseOperation.SelectedItem.Value == "0" ? false : true; Uc.GateEntry = ddlGateEntry.SelectedItem.Value == "0" ? false : true; Uc.MasterFileUpdation = ddlMasterFileDeletion.SelectedItem.Value == "0" ? false : true; Uc.MasterRecordDeletion = ddlMasterRecordDeletion.SelectedItem.Value == "0" ? false : true; Uc.PasswordPolicy = ddlPasswordPolicy.SelectedItem.Value == "0" ? false : true; Uc.PasswordReset = ddlPasswordReset.SelectedItem.Value == "0" ? false : true; Uc.PendingRecordDeletion = ddlPendingRecordDeletion.SelectedItem.Value == "0" ? false : true; Uc.RFIDIssue = ddlRFIDIssue.SelectedItem.Value == "0" ? false : true; Uc.TransactionDeletion = ddlTransactionDeletion.SelectedItem.Value == "0" ? false : true; Uc.UserCreation = ddlUserCreation.SelectedItem.Value == "0" ? false : true; Uc.Weighment = ddlWeighment.SelectedItem.Value == "0" ? false : true; Uc.IsDeleted = false; if (repo.Add_UserClassification(Uc)) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.success('User Classification added successfully.');", true); HtmlMeta meta = new HtmlMeta { HttpEquiv = "Refresh", Content = "1;url=AddEdit.aspx" }; this.Page.Controls.Add(meta); } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true); } } }
//Get:Previous Record from user classification protected void Previous_Record_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); UserClassification next = null; try { next = repo.Get_ActiveUserClassificationList().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); } }
//Save 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) { string _UserType = dr["User Type"].ToString(); bool _MasterFileUpdation = dr["Master File Updation"].ToString() == "Enable" ? true : false; bool _MasterRecordDeletion = dr["Master Record Deletion"].ToString() == "Enable" ? true : false; bool _PendingRecordDeletion = dr["Pending Record Deletion"].ToString() == "Enable" ? true : false; bool _TransactionDeletion = dr["Transaction Deletion"].ToString() == "Enable" ? true : false; bool _Configuration = dr["Configuration"].ToString() == "Enable" ? true : false; bool _PasswordPolicy = dr["Password Policy"].ToString() == "Enable" ? true : false; bool _PasswordReset = dr["Password Reset"].ToString() == "Enable" ? true : false; bool _UserCreation = dr["User Creation"].ToString() == "Enable" ? true : false; bool _GateEntry = dr["Gate Entry"].ToString() == "Enable" ? true : false; bool _RFIDIssue = dr["RFID Issue"].ToString() == "Enable" ? true : false; bool _Weighment = dr["Weighment"].ToString() == "Enable" ? true : false; bool _DatabaseOperation = dr["Database Operation"].ToString() == "Enable" ? true : false; var _Uc = db.UserClassifications.Where(x => x.UserType == _UserType && x.IsDeleted == false).FirstOrDefault(); if (_UserType.Length <= 25) { if (_Uc != null) { int id = db.UserClassifications.FirstOrDefault(x => x.UserType == _UserType && x.IsDeleted == false).Id; UserClassification _User = db.UserClassifications.FirstOrDefault(x => x.UserType == _UserType && x.IsDeleted == false && x.Id != id); if (_User != null) { _failed++; } else { _Uc.UserType = _UserType; _Uc.MasterFileUpdation = _MasterFileUpdation; _Uc.MasterRecordDeletion = _MasterRecordDeletion; _Uc.PendingRecordDeletion = _PendingRecordDeletion; _Uc.TransactionDeletion = _TransactionDeletion; _Uc.Configuration = _Configuration; _Uc.PasswordPolicy = _PasswordPolicy; _Uc.PasswordReset = _PasswordReset; _Uc.UserCreation = _UserCreation; _Uc.GateEntry = _GateEntry; _Uc.RFIDIssue = _RFIDIssue; _Uc.Weighment = _Weighment; _Uc.DatabaseOperation = _DatabaseOperation; db.SubmitChanges(); _update++; } } else { if (!string.IsNullOrEmpty(_UserType)) { var data = db.UserClassifications.FirstOrDefault(x => x.UserType == _UserType && x.IsDeleted == false); if (data != null) { _failed++; } else { UserClassification uc = new UserClassification(); uc.UserType = _UserType; uc.MasterFileUpdation = _MasterFileUpdation; uc.MasterRecordDeletion = _MasterRecordDeletion; uc.PendingRecordDeletion = _PendingRecordDeletion; uc.Configuration = _Configuration; uc.PasswordPolicy = _PasswordPolicy; uc.PasswordReset = _PasswordReset; uc.RFIDIssue = _RFIDIssue; uc.UserCreation = _UserCreation; uc.TransactionDeletion = _TransactionDeletion; uc.Weighment = _Weighment; uc.DatabaseOperation = _DatabaseOperation; uc.GateEntry = _GateEntry; uc.IsDeleted = false; db.UserClassifications.InsertOnSubmit(uc); db.SubmitChanges(); _success++; } } else { _failed++; } } } } result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + ""; } return(result); }
//Get:User Classification By Id public UserClassification GetUserClassification_by_Id(int id) { UserClassification uc = db.UserClassifications.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); return(uc); }
//Get:User Classification By UserType public UserClassification GetUserClassification_by_UserType(string type) { UserClassification uc = db.UserClassifications.FirstOrDefault(x => x.UserType == type && x.IsDeleted == false); return(uc); }