protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
ApplicationResult objResult = new ApplicationResult();
StudentFeesTemplateTBL objStudentFeeTemplate = new StudentFeesTemplateTBL();
objResult = objStudentFeeTemplate.StudentFeeTemplate_FeesNameWise("1", "1", "A", "14-15", 0);
if (objResult != null)
{
for (int i = 0; i < objResult.resultDT.Columns.Count; i++)
{
BoundField boundfield = new BoundField();
boundfield.DataField = objResult.resultDT.Columns[i].ColumnName.ToString();
boundfield.HeaderText = objResult.resultDT.Columns[i].ColumnName.ToString();
//boundfield.SortExpression = objResult.resultDT.Columns[i].ColumnName.ToString();
gvStudentFees.Columns.Add(boundfield);
if (i == 0)
{
boundfield.Visible = false;
}
}
gvStudentFees.Visible = true;
gvStudentFees.DataSource = objResult.resultDT;
gvStudentFees.DataBind();
}
}
catch (Exception ex)
{
}
}
}
public static string LoadFeesWithAmount(int intClassMID, int intDivisionTID, string strAcademicYear, int intSchoolMID)
{
try
{
#region Bind LoadFeesWithAmount
StudentFeesTemplateTBL objStudentFeesTemplateBL = new StudentFeesTemplateTBL();
ApplicationResult objResults = new ApplicationResult();
objResults = objStudentFeesTemplateBL.StudentFeeTemplate_Select_FeesName_With_Amount(intClassMID, intDivisionTID, strAcademicYear, intSchoolMID);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
}
}
string res = "";
res = DataSetToJSON(objResults.resultDT);
return(res);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
private DataTable FetchFeesNameWithAmount(int intClassMID, int intDivisionTID, string strAcademicYear, int intSchoolMID)
{
StudentFeesTemplateTBL objStudentTemplateBl = new StudentFeesTemplateTBL();
ApplicationResult objResults = new ApplicationResult();
objResults = objStudentTemplateBl.StudentFeeTemplate_Select_FeesName_With_Amount(intClassMID, intDivisionTID, strAcademicYear, intSchoolMID);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0)
{
}
return(objResults.resultDT);
}
public DataTable Select_ClassTemlate_FeeCategory()
{
StudentFeesTemplateTBL objStudentFeesTemplateTBL = new StudentFeesTemplateTBL();
//ClassWiseFeesTemplateTBL objClassTemplateBL = new ClassWiseFeesTemplateTBL();
if (hfSearchID.Value.ToString() == "")
{
hfSearchID.Value = "0";
}
ApplicationResult objResultsSelectT = new ApplicationResult();
objResultsSelectT = objStudentFeesTemplateTBL.StudentFeeTemplate_Select_ClassWiseStudentTemplate(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(hfCLassMID.Value), Convert.ToInt32(hfDivisionTID.Value), ddlAcademicYear.SelectedValue, 1, Convert.ToInt32(hfSearchID.Value));
if (objResultsSelectT != null)
{
}
return(objResultsSelectT.resultDT);
}
protected void gvStudentFees_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ApplicationResult objResult = new ApplicationResult();
StudentFeesTemplateTBL objStudentFeeTemplate = new StudentFeesTemplateTBL();
objResult = objStudentFeeTemplate.StudentFeeTemplate_FeesNameWise("1", "1", "A", "14-15", 0);
int intcCount = objResult.resultDT.Columns.Count;
for (int j = 2; j < intcCount; j++)
{
CheckBox chk = new CheckBox();
chk.ID = "chk_" + j;
//chk.Text = (e.Row.DataItem as DataRowView).Row["chk"].ToString();
e.Row.Cells[j].Controls.Add(chk);
}
}
if (e.Row.RowType == DataControlRowType.Header)
{
ApplicationResult objResult = new ApplicationResult();
StudentFeesTemplateTBL objStudentFeeTemplate = new StudentFeesTemplateTBL();
objResult = objStudentFeeTemplate.StudentFeeTemplate_FeesNameWise("1", "1", "A", "14-15", 0);
int intcCount = objResult.resultDT.Columns.Count;
for (int j = 2; j < intcCount; j++)
{
TemplateField tfield = new TemplateField();
CheckBox chk = new CheckBox();
chk.ID = "chkHeader_" + j;
chk.Text = objResult.resultDT.Columns[j].ColumnName.ToString();
e.Row.Cells[j].Controls.Add(chk);
tfield = new TemplateField();
// tfield.HeaderText = objResult.resultDT.Columns[j].ColumnName.ToString();
gvStudentFees.Columns.Add(tfield);
}
}
}
catch (Exception ex)
{
}
}
protected void btnViewAssignFee_Click(object sender, EventArgs e)
{
try
{
hfTab.Value = "1";
Set_ButtonDropDown();
gvStudentFees.Visible = false;
gvAssignFees.Visible = true;
gvAssignFees.AutoGenerateColumns = false;
ApplicationResult objResults = new ApplicationResult();
StudentFeesTemplateTBL objStudentTemplateBL = new StudentFeesTemplateTBL();
objResults = objStudentTemplateBL.StudentFeeTemplate_FeesNameWise(Session[ApplicationSession.SCHOOLID].ToString(), ViewState["ClassMID"].ToString(), ViewState["DivisionName"].ToString(), ddlAcademicYear.SelectedItem.ToString(), 0);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
for (int i = 0; i < objResults.resultDT.Columns.Count; i++)
{
BoundField boundfield = new BoundField();
boundfield.DataField = objResults.resultDT.Columns[i].ColumnName.ToString();
boundfield.HeaderText = objResults.resultDT.Columns[i].ColumnName.ToString();
// boundfield.SortExpression = dtStudentList.Columns[i].ColumnName.ToString();
gvAssignFees.Columns.Add(boundfield);
}
gvAssignFees.Visible = true;
gvAssignFees.DataSource = objResults.resultDT;
gvAssignFees.DataBind();
}
}
}
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
{
// 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 btnSave_Click(object sender, EventArgs e)
{
try
{
StudentFeesTemplateTBL objStudentFeesTemplateBL = new StudentFeesTemplateTBL();
StudentFeesTemplateTBO objStudentFeesTemplateBO = new StudentFeesTemplateTBO();
ApplicationResult objResults = new ApplicationResult();
DatabaseTransaction.OpenConnectionTransation();
foreach (GridViewRow row in gvStudentFees.Rows)
{
if (((CheckBox)row.FindControl("chkChild")).Checked)
{
string FeesNameWithAmount = ddlFeesCategoryName.SelectedItem.Text;
char[] delimiterChars = { '/' };
string[] words = FeesNameWithAmount.Split(delimiterChars);
objStudentFeesTemplateBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objStudentFeesTemplateBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objStudentFeesTemplateBO.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objStudentFeesTemplateBO.DivisionTID = Convert.ToInt32(ViewState["DivisionName"].ToString());
objStudentFeesTemplateBO.StudentMID = Convert.ToInt32(row.Cells[0].Text);
objStudentFeesTemplateBO.AcademicYear = ddlAcademicYear.SelectedItem.Text;
objStudentFeesTemplateBO.FeesCategoryMID = Convert.ToInt32(ddlFeesCategoryName.SelectedValue);
objStudentFeesTemplateBO.FeesAmount = Convert.ToDouble(words[1]);
objStudentFeesTemplateBO.IsLate = 0;
objStudentFeesTemplateBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objStudentFeesTemplateBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
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));
#region RollBack Transaction Starts
if (((CheckBox)row.FindControl("chkChild")).Checked)
{
if (Dt.Rows.Count > 0)
{
}
else
{
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]), 0);
if (dt.Rows.Count > 0)
{
ViewState["ClassTemplateTID"] = Convert.ToInt32(dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_CLASSWISEFEESTEMPLATETID].ToString());
}
objStudentFeesTemplateBO.ClassWiseFeesTemplateTID = Convert.ToInt32(ViewState["ClassTemplateTID"].ToString());
objResults = objStudentFeesTemplateBL.StudentFeesTemplateT_Insert(objStudentFeesTemplateBO);
if (objResults != null)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Amount Successfully Saved.');</script>");
}
}
}
}
else
{
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());
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='javascript'>alert('This Fee Category is Not Update/Delete.');</script>");
}
else
{
objResults = objStudentFeesTemplateBL.StudentFeesTemplateT_Delete(Convert.ToInt32(Convert.ToInt32(Dt.Rows[0][StudentFeesTemplateTBO.STUDENTFEESTEMPLATET_STUDENTFEESTEMPLATETID].ToString())), 0);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('This Fee Category is Update/Delete Successfully.');</script>");
}
}
}
}
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "Clear();", true);
DatabaseTransaction.CommitTransation();
#endregion
ViewState["ClassMID"] = 0;
ViewState["DivisionName"] = 0;
ViewState["AcademicYear"] = "";
ViewState["FeesCategoryMID"] = "";
hfAcademicYear.Value = "0";
hfCLassMID.Value = "0";
hfDivisionTID.Value = "0";
gvStudentFees.Visible = false;
//ClearAll();
//Response.Redirect("StudentTemplate.aspx",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>");
}
}
public void BindGridView()
{
try
{
ApplicationResult objResult = new ApplicationResult();
StudentFeesTemplateTBL objGridFeesBL = new StudentFeesTemplateTBL();
var a = ddlDivision.SelectedItem;
var b = ddlDivision.SelectedValue;
objResult = objGridFeesBL.StudentFeesTemplateT_SelectAll_For_ClassTemplate(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(Request.Form[ddlClass.UniqueID]), Convert.ToInt32(Request.Form[ddlDivision.UniqueID]), ddlAcademicYear.SelectedValue.ToString());
if (objResult != null)
{
gvFees.Visible = true;
gvFees.DataSource = objResult.resultDT;
gvFees.DataBind();
if (objResult.resultDT.Rows.Count > 0)
{
//((CheckBox)gvFees.HeaderRow.FindControl("chkHeader")).Enabled = true;
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('No Record Found.');</script>");
gvFees.Visible = false;
}
foreach (GridViewRow row in gvFees.Rows)
{
ViewState["FeesCategoryMID"] = Convert.ToInt32(row.Cells[0].Text);
DataTable Dt = Select_ClassTemlate_FeeCategory();
//if (Dt.Rows.Count > 0)
//{
// ViewState["ClassTemplateTID"] = Convert.ToInt32(Dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_CLASSWISEFEESTEMPLATETID].ToString());
// //((CheckBox)row.FindControl("chkChild")).Checked = true;
// //((CheckBox)gvFees.HeaderRow.FindControl("chkHeader")).Enabled = false;
// btnSave.Enabled = true;
// // btnSave.BackColor = Color.#3b5998;
// btnSave.Attributes.Add("bgcolor", "#3b5998");
// ((TextBox)row.FindControl("txtFeesAmount")).Text = Dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_FEESAMOUNT].ToString();
// 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]), 0);
// if (dtFeeCollection.Rows.Count > 0)
// {
// //ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='This Fee Category is Not Update/Delete.');</script>");
// //foreach (GridViewRow rowData in gvFees.Rows)
// //{
// //((CheckBox)row.FindControl("chkChild")).Enabled = false;
// ((TextBox)row.FindControl("txtFeesAmount")).Enabled = false;
// //}
// btnSave.Enabled = true;
// btnSave.Attributes.Add("bgcolor", "#3b5998");
// // ((CheckBox)row.FindControl("chkHeader")).Visible = false;
// }
//}
}
}
objResult = objGridFeesBL.StudentFeesTemplateT_Select(Convert.ToInt32(hfSearchID.Value), ddlAcademicYear.SelectedValue);
if (objResult != null)
{
if (objResult.resutlDS.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < objResult.resutlDS.Tables[0].Rows.Count; i++)
{
var Id = objResult.resutlDS.Tables[0].Rows[i]["FeesCategoryMID"].ToString();
var Amount = objResult.resutlDS.Tables[0].Rows[i]["FeesAmount"].ToString();
foreach (GridViewRow row in gvFees.Rows)
{
if (row.Cells[0].Text == Id)
{
((CheckBox)row.FindControl("chkChild")).Checked = true;
Convert.ToDouble(((TextBox)row.FindControl("txtFeesAmount")).Text = Amount);
}
}
}
for (int i = 0; i < objResult.resutlDS.Tables[1].Rows.Count; i++)
{
var Id = objResult.resutlDS.Tables[1].Rows[i]["FeesCategoryMID"].ToString();
foreach (GridViewRow row in gvFees.Rows)
{
if (row.Cells[0].Text == Id)
{
((CheckBox)row.FindControl("chkChild")).Enabled = false;
}
}
}
}
}
btnSave.Visible = true;
//btnCancel.Visible = true;
}
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>");
}
}
