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