protected void btnSaveFeesGroup_Click(object sender, EventArgs e)
{
try
{
FeesGroupBo objFeesGroupBO = new FeesGroupBo();
FeesGroupBl objFeesGroupBL = new FeesGroupBl();
ApplicationResult objResults = new ApplicationResult();
Controls objControls = new Controls();
objFeesGroupBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objFeesGroupBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objFeesGroupBO.FeeGroupName = txtFeesGroupName.Text.Trim();
objFeesGroupBO.Description = txtDescription.Text.Trim();
if (ViewState["Mode"].ToString() == "Save")
{
objFeesGroupBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objFeesGroupBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResults = objFeesGroupBL.FeesGroup_Insert(objFeesGroupBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Group Created Successfully.');</script>");
BindFeesGroup();
PanelGrid_VisibilityMode(1);
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Group Name already Exists.');</script>");
}
}
else
{
objFeesGroupBO.FeesGroupID = Convert.ToInt32(ViewState["FeesGroupID"].ToString());
objFeesGroupBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objFeesGroupBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResults = objFeesGroupBL.FeesGroup_Update(objFeesGroupBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Fees Group updated successfully.');</script>");
BindFeesGroup();
ClearAll();
ViewState["Mode"] = "Save";
// btnSave.Text = "Save";
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Fees Group Name already Exists.');</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>");
}
}
/// <summary>
/// To Update details of FeesGroup in tbl_FeesGroup_M table
/// Created By : Nafisa, 19-03-2015
/// Modified By :
/// </summary>
/// <param name="objFeesGroupBO"></param>
/// <returns></returns>
public ApplicationResult FeesGroup_Update(FeesGroupBo objFeesGroupBO)
{
try
{
pSqlParameter = new SqlParameter[7];
pSqlParameter[0] = new SqlParameter("@FeesGroupID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objFeesGroupBO.FeesGroupID;
pSqlParameter[1] = new SqlParameter("@FeeGroupName", SqlDbType.VarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objFeesGroupBO.FeeGroupName;
pSqlParameter[2] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objFeesGroupBO.TrustMID;
pSqlParameter[3] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objFeesGroupBO.SchoolMID;
pSqlParameter[4] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objFeesGroupBO.LastModifiedUserID;
pSqlParameter[5] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objFeesGroupBO.LastModifiedDate;
pSqlParameter[6] = new SqlParameter("@Description", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objFeesGroupBO.Description;
sSql = "usp_tbl_FeesGroup_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
{
objFeesGroupBO = null;
}
}
