public void BindAccountGroup()
{
AccountGroupBL objAccountGroupBL = new AccountGroupBL();
AccountGroupBO objAccountGroupBO = new AccountGroupBO();
ApplicationResult objResultSelectAll = new ApplicationResult();
objResultSelectAll = objAccountGroupBL.AccountGroup_SelectAll();
if (objResultSelectAll != null)
{
DataTable dtSelectAll = new DataTable();
dtSelectAll = objResultSelectAll.resultDT;
if (dtSelectAll.Rows.Count > 0)
{
gvAccountGroup.DataSource = dtSelectAll;
gvAccountGroup.DataBind();
}
}
}
public void BindAccountSubGroup()
{
AccountGroupBL objAccountGroupBL = new AccountGroupBL();
AccountGroupBO objAccountGroupBO = new AccountGroupBO();
ApplicationResult objResultSelectAll = new ApplicationResult();
objResultSelectAll = objAccountGroupBL.AccountGroup_SelectAll();
if (objResultSelectAll != null)
{
DataTable dtSelectAll = new DataTable();
dtSelectAll = objResultSelectAll.resultDT;
if (dtSelectAll.Rows.Count > 0)
{
objControl.BindDropDown_ListBox(dtSelectAll, ddlSubGroup, "AccountGroupName", "AccountGroupID");
ddlSubGroup.Items.Insert(0, new ListItem("--Select--", ""));
}
}
}
/// <summary>
/// To Update details of AccountGroup in tbl_AccountGroup_M table
/// Created By : Viral, 9/30/2014
/// Modified By :
/// </summary>
/// <param name="objAccountGroupBO"></param>
/// <returns></returns>
public ApplicationResult AccountGroup_Update(AccountGroupBO objAccountGroupBO)
{
try
{
pSqlParameter = new SqlParameter[14];
pSqlParameter[0] = new SqlParameter("@AccountGroupID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objAccountGroupBO.AccountGroupID;
pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objAccountGroupBO.TrustMID;
pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objAccountGroupBO.SchoolMID;
pSqlParameter[3] = new SqlParameter("@AccountGroupName", SqlDbType.NVarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objAccountGroupBO.AccountGroupName;
pSqlParameter[4] = new SqlParameter("@AccountGroupDefaultNature", SqlDbType.NVarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objAccountGroupBO.AccountGroupDefaultNature;
pSqlParameter[5] = new SqlParameter("@GroupNature", SqlDbType.NVarChar);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objAccountGroupBO.GroupNature;
pSqlParameter[6] = new SqlParameter("@SubGroupID", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objAccountGroupBO.SubGroupID;
pSqlParameter[7] = new SqlParameter("@SubGroupOf", SqlDbType.NVarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objAccountGroupBO.SubGroupOf;
pSqlParameter[8] = new SqlParameter("@Description", SqlDbType.NVarChar);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objAccountGroupBO.Description;
pSqlParameter[9] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objAccountGroupBO.IsDeleted;
pSqlParameter[10] = new SqlParameter("@CreatedDate", SqlDbType.NVarChar);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objAccountGroupBO.CreatedDate;
pSqlParameter[11] = new SqlParameter("@CreatedUserID", SqlDbType.Int);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objAccountGroupBO.CreatedUserID;
pSqlParameter[12] = new SqlParameter("@LastModifideDate", SqlDbType.NVarChar);
pSqlParameter[12].Direction = ParameterDirection.Input;
pSqlParameter[12].Value = objAccountGroupBO.LastModifideDate;
pSqlParameter[13] = new SqlParameter("@LastModifideUserID", SqlDbType.Int);
pSqlParameter[13].Direction = ParameterDirection.Input;
pSqlParameter[13].Value = objAccountGroupBO.LastModifideUserID;
sSql = "usp_tbl_AccountGroup_M_Update";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objAccountGroupBO = null;
}
}
protected void gvAccountGroup_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
AccountGroupBL objAccountGroupBL = new AccountGroupBL();
AccountGroupBO objAccountGroupBO = new AccountGroupBO();
ApplicationResult objResultSelect = new ApplicationResult();
ApplicationResult objResultDelete = new ApplicationResult();
ViewState["AccountGroupID"] = e.CommandArgument.ToString();
if (e.CommandName.ToString() == "Edit1")
{
objResultSelect = objAccountGroupBL.AccountGroup_Select(Convert.ToInt32(ViewState["AccountGroupID"].ToString()));
if (objResultSelect != null)
{
DataTable dtResult = objResultSelect.resultDT;
if (dtResult.Rows.Count > 0)
{
BindAccountSubGroup();
txtAccountGroupName.Text = dtResult.Rows[0][AccountGroupBO.ACCOUNTGROUP_ACCOUNTGROUPNAME].ToString();
ddlAccountNature.SelectedValue = dtResult.Rows[0][AccountGroupBO.ACCOUNTGROUP_GROUPNATURE].ToString();
if (dtResult.Rows[0][AccountGroupBO.ACCOUNTGROUP_SUBGROUPID].ToString() != "0")
{
ddlSubGroup.SelectedValue = dtResult.Rows[0][AccountGroupBO.ACCOUNTGROUP_SUBGROUPID].ToString();
}
txtDescription.Text = dtResult.Rows[0][AccountGroupBO.ACCOUNTGROUP_DESCRIPTION].ToString();
PanelVisibility(2);
if (ddlSubGroup.SelectedValue == "")
{
Panel1.Enabled = false;
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('This is a default Group Name, you can't change it.');</script>");
}
else
{
Panel1.Enabled = true;
ViewState["Mode"] = "Edit";
}
}
}
}
else if (e.CommandName.ToString() == "Delete1")
{
objResultDelete = objAccountGroupBL.AccountGroup_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.USERID]), DateTime.UtcNow.AddHours(5.5).ToString());
if (objResultDelete.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>");
PanelVisibility(1);
BindAccountGroup();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You cannot delete this record because it is in used.');</script>");
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
AccountGroupBL objAccountGroupBL = new AccountGroupBL();
AccountGroupBO objAccountGroupBO = new AccountGroupBO();
ApplicationResult objResultValidate = new ApplicationResult();
int intAccountGroupID = 0;
objAccountGroupBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objAccountGroupBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objAccountGroupBO.AccountGroupName = txtAccountGroupName.Text;
int sel = ddlAccountNature.SelectedIndex;
objAccountGroupBO.AccountGroupDefaultNature = strDefaultNature[sel - 1];;
objAccountGroupBO.GroupNature = ddlAccountNature.SelectedValue;
if (ddlSubGroup.SelectedValue != "")
{
objAccountGroupBO.SubGroupID = Convert.ToInt32(ddlSubGroup.SelectedValue);
objAccountGroupBO.SubGroupOf = ddlSubGroup.SelectedItem.ToString();
}
objAccountGroupBO.Description = txtDescription.Text.Trim();
objAccountGroupBO.IsDeleted = 0;
objAccountGroupBO.CreatedDate = System.DateTime.UtcNow.AddHours(5.5).ToString();
objAccountGroupBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objAccountGroupBO.LastModifideDate = System.DateTime.UtcNow.AddHours(5.5).ToString();;
objAccountGroupBO.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
//Code For Validate Department Name
if (ViewState["Mode"].ToString() == "Save")
{
intAccountGroupID = -1;
}
else if (ViewState["Mode"].ToString() == "Edit")
{
intAccountGroupID = Convert.ToInt32(ViewState["AccountGroupID"].ToString());
objAccountGroupBO.AccountGroupID = Convert.ToInt32(ViewState["AccountGroupID"].ToString());
}
//objResultValidate = objAccountGroupBL.AccountGroup_ValidateName(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), txtAccountGroupName.Text, intAccountGroupID);
objResultValidate = objAccountGroupBL.AccountGroup_ValidateName(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), txtAccountGroupName.Text, intAccountGroupID);
if (objResultValidate != null)
{
DataTable dtValidate = new DataTable();
dtValidate = objResultValidate.resultDT;
if (dtValidate.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Account group name already exist.');</script>");
}
else
{
if (ViewState["Mode"].ToString() == "Save")
{
ApplicationResult objResultSave = new ApplicationResult();
objResultSave = objAccountGroupBL.AccountGroup_Insert(objAccountGroupBO);
if (objResultSave.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved successfully.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
ApplicationResult objResultUpdate = new ApplicationResult();
objResultUpdate = objAccountGroupBL.AccountGroup_Update(objAccountGroupBO);
if (objResultUpdate.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>");
}
}
ClearAll();
BindAccountGroup();
PanelVisibility(1);
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
