public DataTable ValidateFeesbyFeesCollection(int intClassTemplateTID, int intClassMId, int intDivisionTID, string strAcademicYear, int intSchoolMID, int intStudentMID) { ApplicationResult objResults = new ApplicationResult(); ClassWiseFeesTemplateTBL objClassTemplateBL = new ClassWiseFeesTemplateTBL(); objResults = objClassTemplateBL.ClassWiseFeesTemplateT_Fee_Collection_M(intClassTemplateTID, intClassMId, intDivisionTID, strAcademicYear, intSchoolMID, intStudentMID); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0) { } return(objResults.resultDT); }
public DataTable Select_ClassTemlate_FeeCategory() { ClassWiseFeesTemplateTBL objClassTemplateBL = new ClassWiseFeesTemplateTBL(); ApplicationResult objResultsSelectT = new ApplicationResult(); objResultsSelectT = objClassTemplateBL.ClassWiseFeesTemplateT_Select_FeesCategory_M(Convert.ToInt32(ViewState["FeesCategoryMID"].ToString()), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), 0); if (objResultsSelectT != null) { } return(objResultsSelectT.resultDT); }
public DataTable Select_ClassTemlate_FeeCategory(int intFeesCategoryMID, int intClassMID, int intDivisionTID, string strAcademicYear, int intSchoolMID, int intStudentMID) { ClassWiseFeesTemplateTBL objClassTemplateBL = new ClassWiseFeesTemplateTBL(); ApplicationResult objResultsSelectT = new ApplicationResult(); objResultsSelectT = objClassTemplateBL.ClassWiseFeesTemplateT_Select_FeesCategory_M(intFeesCategoryMID, intClassMID, intDivisionTID, strAcademicYear, intSchoolMID, intStudentMID); if (objResultsSelectT != null) { } return(objResultsSelectT.resultDT); }
protected void btnSave_Click(object sender, EventArgs e) { try { // divLoading.Visible = true; ClassWiseFeesTemplateTBL objClassTemplateBL = new ClassWiseFeesTemplateTBL(); ClassWiseFeesTemplateTBO objClassTemplateBO = new ClassWiseFeesTemplateTBO(); #region RollBack Transaction Starts DatabaseTransaction.OpenConnectionTransation(); foreach (GridViewRow row in gvFees.Rows) { ViewState["FeesCategoryMID"] = Convert.ToInt32(row.Cells[0].Text); if (((CheckBox)row.FindControl("chkChild")).Checked) { objClassTemplateBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objClassTemplateBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objClassTemplateBO.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString()); objClassTemplateBO.DivisionTID = Convert.ToInt32(ViewState["DivisionName"].ToString()); objClassTemplateBO.FeesAmount = Convert.ToDouble(((TextBox)row.FindControl("txtFeesAmount")).Text); objClassTemplateBO.FeesCategoryMID = Convert.ToInt32(row.Cells[0].Text); objClassTemplateBO.AcademicYear = ddlAcademicYear.SelectedItem.Text; objClassTemplateBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objClassTemplateBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); if (objClassTemplateBO.FeesAmount == 0.0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Please Fill Fees Amount " + row.Cells[0].Text + ".');</script>"); } else { DataTable Dt = Select_ClassTemlate_FeeCategory(); if (((CheckBox)row.FindControl("chkChild")).Checked) { if (Dt.Rows.Count > 0) { ViewState["ClassTemplateTID"] = Convert.ToInt32(Dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_CLASSWISEFEESTEMPLATETID].ToString()); ApplicationResult objResultsInsert = new ApplicationResult(); objClassTemplateBO.ClassWiseFeesTemplateTID = Convert.ToInt32(ViewState["ClassTemplateTID"].ToString()); objResultsInsert = objClassTemplateBL.ClassWiseFeesTemplateT_Update(objClassTemplateBO); if (objResultsInsert != null) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Amount Successfully Saved.');</script>"); } } else { ApplicationResult objResultsInsert = new ApplicationResult(); objResultsInsert = objClassTemplateBL.ClassWiseFeesTemplateT_Insert(objClassTemplateBO); if (objResultsInsert != null) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Amount Successfully Saved.');</script>"); } } } } } else { DataTable Dt = Select_ClassTemlate_FeeCategory(); if (Dt.Rows.Count > 0) { ViewState["ClassTemplateTID"] = Convert.ToInt32(Dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_CLASSWISEFEESTEMPLATETID].ToString()); DataTable dtFeeCollection = ValidateFeesbyFeesCollection(Convert.ToInt32(ViewState["ClassTemplateTID"].ToString()), objClassTemplateBO.ClassMID, Convert.ToInt32(objClassTemplateBO.DivisionTID), objClassTemplateBO.AcademicYear, Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), 0); if (dtFeeCollection.Rows.Count > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='This Fee Category is Not Update/Delete.');</script>"); } else { ApplicationResult objResultsDelete = new ApplicationResult(); objResultsDelete = objClassTemplateBL.ClassWiseFeesTemplateT_Delete(Convert.ToInt32(Dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_CLASSWISEFEESTEMPLATETID].ToString())); if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS) { StudentFeesTemplateTBL objStudentTemplate = new StudentFeesTemplateTBL(); objResultsDelete = objStudentTemplate.StudentFeesTemplateT_Delete_By_ClassWiseTemplateTID(Convert.ToInt32(Dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_CLASSWISEFEESTEMPLATETID].ToString()), 0); if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS) { } } } } } } DatabaseTransaction.CommitTransation(); #endregion ViewState["ClassMID"] = 0; ViewState["DivisionName"] = 0; ViewState["AcademicYear"] = ""; hfCLassMID.Value = "0"; hfDivisionTID.Value = "0"; // ClearAll(); // Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "BindClass();", true); // divLoading.Visible = false; // Response.Redirect("Class_Template.aspx"); } catch (Exception ex) { DatabaseTransaction.RollbackTransation(); 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 btnViewGrid_Click(object sender, EventArgs e) { try { btnSave.Enabled = true; btnSave.Attributes.Add("bgcolor", "#848484"); hfTab.Value = "1"; Set_ButtonDropDown(); gvAssignFees.Visible = false; gvStudentFees.Visible = true; ApplicationResult objResult = new ApplicationResult(); StudentBL objStudentBL = new StudentBL(); ClassWiseFeesTemplateTBL objClassTemplateBL = new ClassWiseFeesTemplateTBL(); objResult = objStudentBL.Student_Select_ClassDivisionWise(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ViewState["AcademicYear"].ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { gvStudentFees.DataSource = objResult.resultDT; gvStudentFees.DataBind(); } else { gvStudentFees.DataSource = null; gvStudentFees.DataBind(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('No Records.');</script>"); } } foreach (GridViewRow row in gvStudentFees.Rows) { objResult = objClassTemplateBL.StudentFeesTemplate_ForValidation(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(row.Cells[0].Text)); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { ((CheckBox)row.FindControl("chkChild")).Enabled = false; ((CheckBox)gvStudentFees.HeaderRow.FindControl("chkHeader")).Enabled = false; } DataTable Dt = Select_ClassTemlate_FeeCategory(Convert.ToInt32(ViewState["FeesCategoryMID"].ToString()), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(row.Cells[0].Text)); if (Dt.Rows.Count > 0) { ViewState["ClassTemplateTID"] = Convert.ToInt32(Dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_CLASSWISEFEESTEMPLATETID].ToString()); ((CheckBox)row.FindControl("chkChild")).Checked = true; DataTable dtFeeCollection = ValidateFeesbyFeesCollection(Convert.ToInt32(ViewState["ClassTemplateTID"].ToString()), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(row.Cells[0].Text)); if (dtFeeCollection.Rows.Count > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='This Fee Category is Not Update/Delete.');</script>"); ((CheckBox)row.FindControl("chkChild")).Enabled = false; ((CheckBox)gvStudentFees.HeaderRow.FindControl("chkHeader")).Enabled = false; } } } } } 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>"); } }