protected void btnDelete_click(object sender, EventArgs e) { try { if (HfUSER_CODE.Value != string.Empty) { string str = USER_MASLogicLayer.DeleteUSER_MASDetailsByID(HfUSER_CODE.Value); if (str.Contains("successfully")) { lblmsg.Text = "Record Deleted Successfully"; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Cannot")) { lblmsg.Text = "Cannot Delete This Record It Used by Other Data"; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "Error:User Not Deleted"; lblmsg.ForeColor = Color.Red; } clear(); FillGrid(); UserRights(); } } catch (Exception) { throw; } }
protected void BtnLogin_click(object sender, EventArgs e) { try { //string en = encrypt(TxtPassword.Text.Trim()); DataTable DtLogin = USER_MASLogicLayer.GetUserMasterAuthentication(TxtUserName.Text.Trim(), encrypt(TxtPassword.Text.Trim())); if (DtLogin.Rows.Count > 0) { lblMsg.Text = string.Empty; ViewState["USERCODE"] = DtLogin.Rows[0]["USERCODE"].ToString(); ViewState["USERNAME"] = DtLogin.Rows[0]["USERNAME"].ToString(); ViewState["USERTYPE"] = DtLogin.Rows[0]["USERTYPE"].ToString(); FillCompany(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel", "ShowModel()", true); } else { lblMsg.Text = "USERNAME OR PASSWORD INCORRECT...!"; lblMsg.ForeColor = Color.Red; } } catch (Exception) { throw; } }
public void FillGrid() { try { DataTable Dt = new DataTable(); Dt = USER_MASLogicLayer.GetAllUSER_MASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); GvUserMas.DataSource = Dt; GvUserMas.DataBind(); } catch (Exception) { throw; } }
public void FillUser() { try { DataTable dt = USER_MASLogicLayer.GetAllUSER_MASDetials_ForDDl(); DdlUser.DataSource = dt; DdlUser.DataValueField = "USERCODE"; DdlUser.DataTextField = "USERNAME"; DdlUser.DataBind(); } catch (Exception) { throw; } }
protected void BtncallUpd_Click(object sender, EventArgs e) { try { if (BtncallUpd.Text == "UPDATE") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true); } else { USER_MASLogicLayer insert = new USER_MASLogicLayer(); // insert.USERCODE = TxtUserCode.Text.Trim().ToUpper(); insert.USERCODE = HfUSER_CODE.Value.Trim(); insert.USERNAME = TxtUserName.Text.Trim(); insert.USERPASS = encrypt(TxtUserPassword.Text.Trim()); insert.USERTYPE = DdlUserType.SelectedValue.Trim().ToUpper(); insert.ACTIVE = DdlUserActive.SelectedValue.Trim().ToUpper(); insert.DEACTIVE_DATE = string.Empty; if (BtncallUpd.Text.Trim().ToUpper() == "SAVE") { string str = USER_MASLogicLayer.InsertUSER_MASDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "User Detail Add Successfully."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "User Code already Exist."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "Error : User Detail Not Save"; lblmsg.ForeColor = Color.Red; } } } } catch (Exception) { throw; } }
public void FillDdlUser() { try { string COMP_CODE = DdlCompany.SelectedValue; DataTable dt = USER_MASLogicLayer.GetAllUserWiseCompanyRights(COMP_CODE); DdlUser.DataSource = dt; DdlUser.DataValueField = "USERCODE"; DdlUser.DataTextField = "USERNAME"; DdlUser.DataBind(); } catch (Exception) { throw; } }
protected void GvUserMas_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Deletea") { clear(); DataTable dt = USER_MASLogicLayer.GetAllIDWiseUSER_MASDetials(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfUSER_CODE.Value = dt.Rows[0]["USERCODE"].ToString(); TxtUserName.Text = dt.Rows[0]["USERNAME"].ToString(); TxtUserPassword.Attributes.Add("value", Decrypt(dt.Rows[0]["USERPASS"].ToString())); DdlUserType.SelectedValue = dt.Rows[0]["USERTYPE"].ToString(); DdlUserActive.SelectedValue = dt.Rows[0]["ACTIVE"].ToString(); //TxtDeActivateDate.Text = dt.Rows[0]["DEACTIVE_DATE"].ToString(); } btnSave.Visible = false; btnDelete.Visible = true; Btncalldel.Visible = true; BtncallUpd.Visible = false; ControllerDisable(); } if (e.CommandName == "Edita") { #region EDIT clear(); DataTable dt = USER_MASLogicLayer.GetAllIDWiseUSER_MASDetials(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfUSER_CODE.Value = dt.Rows[0]["USERCODE"].ToString(); TxtUserName.Text = dt.Rows[0]["USERNAME"].ToString(); //TxtUserPassword.Attributes["value"] = Decrypt(dt.Rows[0]["USERPASS"].ToString()); //TxtUserPassword.Text= Decrypt(dt.Rows[0]["USERPASS"].ToString()); TxtUserPassword.Attributes.Add("value", Decrypt(dt.Rows[0]["USERPASS"].ToString())); DdlUserType.SelectedValue = dt.Rows[0]["USERTYPE"].ToString(); DdlUserActive.SelectedValue = dt.Rows[0]["ACTIVE"].ToString(); //TxtDeActivateDate.Text = dt.Rows[0]["DEACTIVE_DATE"].ToString(); BtncallUpd.Text = "UPDATE"; #endregion } #region CHECK UPDATE RIGHTS if (Session["UPDATE"] != null) { if (Session["UPDATE"].ToString() == "Y") { ControllerEnable(); } else { ControllerDisable(); } } #endregion btnSave.Visible = true; Btncalldel.Visible = false; BtncallUpd.Visible = true; UserRights(); } if (e.CommandName == "Viewa") { clear(); DataTable dt = USER_MASLogicLayer.GetAllIDWiseUSER_MASDetials(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfUSER_CODE.Value = dt.Rows[0]["USERCODE"].ToString(); TxtUserName.Text = dt.Rows[0]["USERNAME"].ToString(); TxtUserPassword.Attributes.Add("value", Decrypt(dt.Rows[0]["USERPASS"].ToString())); DdlUserType.SelectedValue = dt.Rows[0]["USERTYPE"].ToString(); DdlUserActive.SelectedValue = dt.Rows[0]["ACTIVE"].ToString(); //TxtDeActivateDate.Text = dt.Rows[0]["DEACTIVE_DATE"].ToString(); } ControllerDisable(); btnSave.Visible = false; Btncalldel.Visible = false; BtncallUpd.Visible = false; UserRights(); } } catch (Exception) { throw; } }
protected void btnSave_click(object sender, EventArgs e) { try { USER_MASLogicLayer insert = new USER_MASLogicLayer(); // insert.USERCODE = TxtUserCode.Text.Trim().ToUpper(); insert.USERCODE = HfUSER_CODE.Value.Trim(); insert.USERNAME = TxtUserName.Text.Trim(); insert.USERPASS = encrypt(TxtUserPassword.Text.Trim()); insert.USERTYPE = DdlUserType.SelectedValue.Trim().ToUpper(); insert.ACTIVE = DdlUserActive.SelectedValue.Trim().ToUpper(); insert.DEACTIVE_DATE = string.Empty; if (btnSave.Text.Trim().ToUpper() == "SAVE") { string str = USER_MASLogicLayer.InsertUSER_MASDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "User Detail Add Successfully."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "User Code already Exist."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "Error : User Detail Not Save"; lblmsg.ForeColor = Color.Red; } } else { string str = USER_MASLogicLayer.UpdateUSER_MASDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "User Detail Update Successfully."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(); UserRights(); } else if (str.Contains("Already")) { lblmsg.Text = "User Code already Exist."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "Error : User Detail Not Update"; lblmsg.ForeColor = Color.Red; } } } catch (Exception) { throw; } }