private void LoadData()
{
userAccountMaintBL = new UserAccountMaintBL();
DataSet gridData = userAccountMaintBL.GetData(string.Empty, out errorId);
userAccountMaintBL = null;
if (gridData.Tables.Count != 0 && errorId != 2)
{
dtResponsibilityList = gridData.Tables[0];
dtRoleList = gridData.Tables[1];
dtPaymentRoleList = gridData.Tables[2];
Session["FuzzyUserMaintUserList"] = gridData.Tables[3];
Session["UserAccountResponsibility"] = dtResponsibilityList;
ddlResponsibilityAdd.DataSource = dtResponsibilityList;
ddlResponsibilityAdd.DataTextField = "responsibility_desc";
ddlResponsibilityAdd.DataValueField = "responsibility_code";
ddlResponsibilityAdd.DataBind();
ddlResponsibilityAdd.Items.Insert(0, new ListItem("-"));
Session["UserAccountRole"] = dtRoleList;
ddlroleAdd.DataSource = dtRoleList;
ddlroleAdd.DataTextField = "role_desc";
ddlroleAdd.DataValueField = "role_id";
ddlroleAdd.DataBind();
ddlroleAdd.Items.Insert(0, new ListItem("-"));
Session["UserAccountPaymentRole"] = dtPaymentRoleList;
ddlPaymentRoleAdd.DataSource = dtPaymentRoleList;
ddlPaymentRoleAdd.DataTextField = "role_desc";
ddlPaymentRoleAdd.DataValueField = "role_id";
ddlPaymentRoleAdd.DataBind();
ddlPaymentRoleAdd.Items.Insert(0, new ListItem("-"));
if (gridData.Tables[4].Rows.Count == 0)
{
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.EmptyDataText = "No data found";
gvUserAccount.DataBind();
}
else
{
Session["UserAccountData"] = gridData.Tables[4];
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.DataBind();
}
}
else if (gridData.Tables.Count == 0 && errorId != 2)
{
dtEmpty = new DataTable();
gvUserAccount.DataSource = dtEmpty;
gvUserAccount.EmptyDataText = "No data found";
gvUserAccount.DataBind();
}
else
{
ExceptionHandler("Error in loading grid data.", string.Empty);
}
}
private void UserSelected()
{
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
hdnChangeNotSaved.Value = "N";
hdnGridRowSelectedPrvious.Value = "";
hdnChangeNotSavedAdd.Value = "N";
if (txtUserSearch.Text != string.Empty && (txtUserSearch.Text == "No results found" || hdnUserSearchSelected.Value == "N"))
{
msgView.SetMessage("Please select a valid user from the list", MessageType.Warning, PositionType.Auto);
txtUserSearch.Text = string.Empty;
return;
}
userAccountMaintBL = new UserAccountMaintBL();
DataSet gridData = userAccountMaintBL.GetData(txtUserSearch.Text == string.Empty ? string.Empty : txtUserSearch.Text.Split('-')[1].ToString().Trim(), out errorId);
userAccountMaintBL = null;
if (gridData.Tables.Count != 0 && errorId != 2)
{
dtResponsibilityList = gridData.Tables[0];
dtRoleList = gridData.Tables[1];
dtPaymentRoleList = gridData.Tables[2];
Session["FuzzyUserMaintUserList"] = gridData.Tables[3];
if (gridData.Tables[4].Rows.Count == 0)
{
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.EmptyDataText = "No data found";
gvUserAccount.DataBind();
}
else
{
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.DataBind();
}
}
else if (gridData.Tables.Count == 0 && errorId != 2)
{
dtEmpty = new DataTable();
gvUserAccount.DataSource = dtEmpty;
gvUserAccount.EmptyDataText = "No data found for the selected filter criteria";
gvUserAccount.DataBind();
}
else
{
ExceptionHandler("Error in loading grid data", string.Empty);
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
hdnChangeNotSaved.Value = "N";
hdnGridRowSelectedPrvious.Value = "";
hdnChangeNotSavedAdd.Value = "N";
ClearAddFields();
txtUserSearch.Text = string.Empty;
userAccountMaintBL = new UserAccountMaintBL();
DataSet gridData = userAccountMaintBL.GetData(string.Empty, out errorId);
userAccountMaintBL = null;
if (gridData.Tables.Count != 0 && errorId != 2)
{
dtResponsibilityList = gridData.Tables[0];
dtRoleList = gridData.Tables[1];
dtPaymentRoleList = gridData.Tables[2];
Session["FuzzyUserMaintUserList"] = gridData.Tables[3];
if (gridData.Tables[4].Rows.Count == 0)
{
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.EmptyDataText = "No data found";
gvUserAccount.DataBind();
}
else
{
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.DataBind();
}
}
else if (gridData.Tables.Count == 0 && errorId != 2)
{
dtEmpty = new DataTable();
gvUserAccount.DataSource = dtEmpty;
gvUserAccount.EmptyDataText = "No data found";
gvUserAccount.DataBind();
}
else
{
ExceptionHandler("Error in loading grid data.", string.Empty);
}
}
protected void btnRespUpdate_Click(object sender, EventArgs e)
{
try
{
userAccountMaintBL = new UserAccountMaintBL();
userAccountMaintBL.UpdateRespChanges(Convert.ToInt32(ddlRespToReplace.SelectedValue), Convert.ToInt32(hdnNewResp.Value), Convert.ToString(Session["UserCode"]), out errorId);
userAccountMaintBL = null;
if (errorId != 2)
{
mpeRespUpdate.Hide();
}
else
{
ExceptionHandler("Error in updating responsibility changes", string.Empty);
}
}
catch (Exception ex)
{
ExceptionHandler("Error in updating responsibility changes", ex.Message);
}
}
protected void btnUpdate_Click(object sender, ImageClickEventArgs e)
{
try
{
hdnChangeNotSaved.Value = "N";
hdnGridRowSelectedPrvious.Value = "";
hdnChangeNotSavedAdd.Value = "N";
ImageButton btnUpdate = (ImageButton)sender;
GridViewRow gvr = ((ImageButton)sender).NamingContainer as GridViewRow;
string userAccIdToUpdate = (gvr.FindControl("hdnUserAccId") as HiddenField).Value;
string userCodeToUpdate = (gvr.FindControl("hdnUserCode") as HiddenField).Value;
string respCodeToUpdate = (gvr.FindControl("hdnRespCode") as HiddenField).Value;
string userName = (gvr.FindControl("txtUserName") as TextBox).Text;
string userCode = (gvr.FindControl("txtUserCode") as TextBox).Text;
string userAccId = (gvr.FindControl("txtUserAccId") as TextBox).Text;
string respCode = (gvr.FindControl("ddlResponsibility") as DropDownList).SelectedValue;
string roleId = (gvr.FindControl("ddlrole") as DropDownList).SelectedValue;
string paymentRoleId = (gvr.FindControl("ddlPaymentRole") as DropDownList).SelectedValue;
string isActive = (gvr.FindControl("cbActive") as CheckBox).Checked == true ? "Y" : string.Empty;
userAccountMaintBL = new UserAccountMaintBL();
DataSet gridData = userAccountMaintBL.UpdateUserAccount(userAccIdToUpdate, userCodeToUpdate, respCodeToUpdate, userName, userCode, userAccId, respCode, roleId, paymentRoleId, isActive,
txtUserSearch.Text == string.Empty ? string.Empty : txtUserSearch.Text.Split('-')[1].ToString().Trim(), Convert.ToString(Session["UserCode"]), out errorId);
userAccountMaintBL = null;
if (errorId == 1)
{
msgView.SetMessage("User account alredy exists", MessageType.Warning, PositionType.Auto);
return;
}
if (gridData.Tables.Count != 0 && errorId != 2)
{
dtResponsibilityList = gridData.Tables[0];
dtRoleList = gridData.Tables[1];
dtPaymentRoleList = gridData.Tables[2];
Session["FuzzyUserMaintUserList"] = gridData.Tables[3];
if (gridData.Tables[4].Rows.Count == 0)
{
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.EmptyDataText = "No data found";
gvUserAccount.DataBind();
}
else
{
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.DataBind();
}
if (respCodeToUpdate != respCode)
{
txtNewResp.Text = (gvr.FindControl("ddlResponsibility") as DropDownList).SelectedItem.Text;
hdnNewResp.Value = (gvr.FindControl("ddlResponsibility") as DropDownList).SelectedValue;
ddlRespToReplace.DataSource = dtResponsibilityList;
ddlRespToReplace.DataTextField = "responsibility_desc";
ddlRespToReplace.DataValueField = "responsibility_code";
ddlRespToReplace.DataBind();
ddlRespToReplace.Items.Insert(0, new ListItem("-"));
mpeRespUpdate.Show();
}
ddlResponsibilityAdd.DataSource = dtResponsibilityList;
ddlResponsibilityAdd.DataTextField = "responsibility_desc";
ddlResponsibilityAdd.DataValueField = "responsibility_code";
ddlResponsibilityAdd.DataBind();
ddlResponsibilityAdd.Items.Insert(0, new ListItem("-"));
ddlroleAdd.DataSource = dtRoleList;
ddlroleAdd.DataTextField = "role_desc";
ddlroleAdd.DataValueField = "role_id";
ddlroleAdd.DataBind();
ddlroleAdd.Items.Insert(0, new ListItem("-"));
}
else if (gridData.Tables.Count == 0 && errorId != 2)
{
dtEmpty = new DataTable();
gvUserAccount.DataSource = dtEmpty;
gvUserAccount.EmptyDataText = "No data found";
gvUserAccount.DataBind();
}
else
{
ExceptionHandler("Error in updating user", string.Empty);
}
}
catch (Exception ex)
{
ExceptionHandler("Error in updating user", ex.Message);
}
ClearAddFields();
}
//JIRA-746 CHanges by Ravi on 05/03/2019 -- End
protected void btnAdd_Click(object sender, ImageClickEventArgs e)
{
try
{
hdnChangeNotSaved.Value = "N";
hdnGridRowSelectedPrvious.Value = "";
hdnChangeNotSavedAdd.Value = "N";
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
userAccountMaintBL = new UserAccountMaintBL();
DataSet gridData = userAccountMaintBL.AddUserAccount(txtUserNameAdd.Text.Trim(), txtUserCodeAdd.Text.Trim(), txtUserAccIdAdd.Text.Trim(),
ddlResponsibilityAdd.SelectedValue, ddlroleAdd.SelectedValue, ddlPaymentRoleAdd.SelectedValue, cbActiveAdd.Checked == true ? "Y" : string.Empty,
txtUserSearch.Text == string.Empty ? string.Empty : txtUserSearch.Text.Split('-')[1].ToString().Trim(), Convert.ToString(Session["UserCode"]), out errorId);
userAccountMaintBL = null;
if (errorId == 1)
{
msgView.SetMessage("User account alredy exists", MessageType.Warning, PositionType.Auto);
return;
}
if (gridData.Tables.Count != 0 && errorId != 2)
{
dtResponsibilityList = gridData.Tables[0];
dtRoleList = gridData.Tables[1];
dtPaymentRoleList = gridData.Tables[2];
Session["FuzzyUserMaintUserList"] = gridData.Tables[3];
if (gridData.Tables[4].Rows.Count == 0)
{
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.EmptyDataText = "No data found";
gvUserAccount.DataBind();
}
else
{
gvUserAccount.DataSource = gridData.Tables[4];
gvUserAccount.DataBind();
}
txtNewResp.Text = ddlResponsibilityAdd.SelectedItem.Text;
hdnNewResp.Value = ddlResponsibilityAdd.SelectedValue;
ddlResponsibilityAdd.DataSource = dtResponsibilityList;
ddlResponsibilityAdd.DataTextField = "responsibility_desc";
ddlResponsibilityAdd.DataValueField = "responsibility_code";
ddlResponsibilityAdd.DataBind();
ddlResponsibilityAdd.Items.Insert(0, new ListItem("-"));
ddlroleAdd.DataSource = dtRoleList;
ddlroleAdd.DataTextField = "role_desc";
ddlroleAdd.DataValueField = "role_id";
ddlroleAdd.DataBind();
ddlroleAdd.Items.Insert(0, new ListItem("-"));
ddlRespToReplace.DataSource = dtResponsibilityList;
ddlRespToReplace.DataTextField = "responsibility_desc";
ddlRespToReplace.DataValueField = "responsibility_code";
ddlRespToReplace.DataBind();
ddlRespToReplace.Items.Insert(0, new ListItem("-"));
ClearAddFields();
mpeRespUpdate.Show();
}
else if (gridData.Tables.Count == 0 && errorId != 2)
{
dtEmpty = new DataTable();
gvUserAccount.DataSource = dtEmpty;
gvUserAccount.EmptyDataText = "No data found";
gvUserAccount.DataBind();
ClearAddFields();
}
else
{
ExceptionHandler("Error in adding user", string.Empty);
}
}
catch (Exception ex)
{
ExceptionHandler("Error in adding user", ex.Message);
}
}
