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--", ""));
}
}
}
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>");
}
}
