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