protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
Session["CheckRefresh"] =
Server.UrlDecode(System.DateTime.Now.ToString());
FeesCategoryBO objFeesBo = new FeesCategoryBO();
ApplicationResult objResults = new ApplicationResult();
FeesCategoryBL objFeesBl = new FeesCategoryBL();
Controls objControls = new Controls();
objFeesBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objFeesBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objFeesBo.FeesName = txtFeesCategoryName.Text;
objFeesBo.FeesType = rblFeeType.SelectedItem.Text;
objFeesBo.OutstandingMonth = Convert.ToInt32(ddlOutstandingMonth.SelectedValue);
objFeesBo.FeeAbbreviation = txtAbbreviation.Text;
objFeesBo.FeeGroupID = Convert.ToInt32(ddlFeeGroup.SelectedValue);
objFeesBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objFeesBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
if (ValidateName() == true)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Fees Category Name " + txtFeesCategoryName.Text + " Already Exists');</script>");
goto Exit;
}
if (ViewState["Mode"].ToString() == "Save")
{
objResults = objFeesBl.FeesCategory_Insert(objFeesBo);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Category Created Successfully.');</script>");
GridDataBind();
PanelGrid_VisibilityMode(1);
}
}
else
{
objFeesBo.FeesCategoryMID = Convert.ToInt32(ViewState["FeesCategoryMID"].ToString());
objResults = objFeesBl.FeesCategory_Update(objFeesBo);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Fee Category updated successfully.');</script>");
GridDataBind();
ClearAll();
//objControls.ClearForm(Master.FindControl("ContentPlaceHolder1"));
ViewState["Mode"] = "Save";
btnSave.Text = "Save";
}
}
Exit :;
}
else
{
}
}
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 FeesCategory in tbl_FeesCategory_M table
/// Created By : NafisaMulla, 2/7/2014
/// Modified By :
/// </summary>
/// <param name="objFeesCategoryBO"></param>
/// <returns></returns>
public ApplicationResult FeesCategory_Update_For_Priority(FeesCategoryBO objFeesCategoryBO)
{
try
{
pSqlParameter = new SqlParameter[12];
pSqlParameter[0] = new SqlParameter("@FeesCategoryMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objFeesCategoryBO.FeesCategoryMID;
pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objFeesCategoryBO.TrustMID;
pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objFeesCategoryBO.SchoolMID;
pSqlParameter[3] = new SqlParameter("@FeesName", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objFeesCategoryBO.FeesName;
pSqlParameter[4] = new SqlParameter("@FeesType", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objFeesCategoryBO.FeesType;
pSqlParameter[5] = new SqlParameter("@OutstandingMonth", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objFeesCategoryBO.OutstandingMonth;
pSqlParameter[6] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objFeesCategoryBO.LastModifiedUserID;
pSqlParameter[7] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objFeesCategoryBO.LastModifiedDate;
pSqlParameter[8] = new SqlParameter("@Isdeleted", SqlDbType.Int);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objFeesCategoryBO.Isdeleted;
pSqlParameter[9] = new SqlParameter("@FeeAbbreviation", SqlDbType.VarChar);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objFeesCategoryBO.FeeAbbreviation;
pSqlParameter[10] = new SqlParameter("@FeeGroupID", SqlDbType.VarChar);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objFeesCategoryBO.FeeGroupID;
pSqlParameter[11] = new SqlParameter("@Priority", SqlDbType.VarChar);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objFeesCategoryBO.Priority;
sSql = "usp_tbl_FeesCategory_M_Update_For_Priority";
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
{
objFeesCategoryBO = null;
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
if (rblToggleView.SelectedItem.Text == "Class")
{
try
{
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBL = new ClassBL();
ClassBO objClassBO = new ClassBO();
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
for (int i = 0; i < gvClass.Rows.Count; i++)
{
TextBox txtSequence = (TextBox)gvClass.Rows[i].FindControl("txtSequence");
if (txtSequence.Text != "")
{
objClassBO.Priority = Convert.ToInt32(txtSequence.Text);
objClassBO.ClassMID = Convert.ToInt32(gvClass.Rows[i].Cells[0].Text);
objClassBO.ClassName = gvClass.Rows[i].Cells[1].Text;
objClassBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objResult = objClassBL.Class_Update_For_Priority(objClassBO);
if (objResult != null)
{
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator...');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Enter the priority.');</script>");
break;
}
}
DatabaseTransaction.CommitTransation();
#endregion
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record Saved Successfully.');</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>");
}
}
else if (rblToggleView.SelectedItem.Text == "Fees Category")
{
try
{
ApplicationResult objResult = new ApplicationResult();
FeesCategoryBL objFeesCategoryBL = new FeesCategoryBL();
FeesCategoryBO objFeesCategoryBO = new FeesCategoryBO();
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
for (int i = 0; i < gvFees.Rows.Count; i++)
{
TextBox txtSequence = (TextBox)gvFees.Rows[i].FindControl("txtSequence1");
if (txtSequence.Text != "")
{
objFeesCategoryBO.Priority = Convert.ToInt32(txtSequence.Text);
objFeesCategoryBO.FeesCategoryMID = Convert.ToInt32(gvFees.Rows[i].Cells[0].Text);
objFeesCategoryBO.FeesName = gvFees.Rows[i].Cells[1].Text;
objResult = objFeesCategoryBL.FeesCategory_Update_For_Priority(objFeesCategoryBO);
if (objResult != null)
{
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator...');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Enter the priority.');</script>");
break;
}
}
DatabaseTransaction.CommitTransation();
#endregion
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record Saved Successfully.');</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>");
}
}
else
{
}
}
