protected void btnSave_Click(object sender, EventArgs e)
{
TblMonthlyFee obj = new TblMonthlyFee();
obj.BranchID = Convert.ToInt32(Session["BranchID"]);
obj.Amount = Convert.ToInt32(txtAmountRecieve.Text);
obj.Ceid = Convert.ToInt32(hdnCEID.Value);
obj.DateX = txtDate.SelectedDate;
obj.FeeType = ddlFeeType.Text;
obj.SchFeeID = 1;
obj.ClgFeeID = 0;
obj.Save();
TblSchoolHostelLedger t = new TblSchoolHostelLedger();
if (helper.ExecutePlainQuery("select * from tbl_SchoolHostelLedger where CEID=" + obj.Ceid + " and LedgerType='School'").Rows.Count == 0)
{
t.IsNew = true;
t.Ceid = obj.Ceid;
t.LedgerType = "School";
t.Save();
}
t = new TblSchoolHostelLedger(TblSchoolHostelLedger.Columns.Ceid, obj.Ceid);
t.IsNew = false;
if (ddlFeeType.Text == "Admission Fee")
{
t.AdmissionFee = Convert.ToInt32(txtAmountRecieve.Text);
}
else if (ddlFeeType.Text == "Re-Admission Fee")
{
t.ReAdmissionFee = obj.Amount.ToString();
}
else if (ddlFeeType.Text == "Monthly Fee")
{
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 4)
{
t.Apr = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 5)
{
t.May = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 6)
{
t.June = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 7)
{
t.July = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 8)
{
t.August = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 9)
{
t.September = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 10)
{
t.October = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 11)
{
t.November = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 12)
{
t.December = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 1)
{
t.January = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 2)
{
t.Fabruary = obj.Amount.ToString();
}
if (Convert.ToDateTime(txtDate.SelectedDate).Month == 3)
{
t.March = obj.Amount.ToString();
}
}
t.Save();
loadPrvFees();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)sender;
DataTable dt = helper.ExecutePlainQuery("select * from tbl_Monthlyfee where FeeID=" + btn.CommandArgument);
TblSchoolHostelLedger t = new TblSchoolHostelLedger(TblSchoolHostelLedger.Columns.Ceid, dt.Rows[0]["CEID"]);
t.IsNew = false;
if (Convert.ToString(dt.Rows[0]["FeeType"]) == "Admission Fee")
{
t.AdmissionFee = null;
}
else if (Convert.ToString(dt.Rows[0]["FeeType"]) == "Re-Admission Fee")
{
t.ReAdmissionFee = null;
}
else if (Convert.ToString(dt.Rows[0]["FeeType"]) == "Monthly Fee")
{
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 4)
{
t.Apr = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 5)
{
t.May = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 6)
{
t.June = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 7)
{
t.July = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 8)
{
t.August = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 9)
{
t.September = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 10)
{
t.October = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 11)
{
t.November = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 12)
{
t.December = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 1)
{
t.January = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 2)
{
t.Fabruary = null;
}
if (Convert.ToDateTime(dt.Rows[0]["Date"]).Month == 3)
{
t.March = null;
}
}
t.Save();
TblMonthlyFee.Delete(btn.CommandArgument);
loadPrvFees();
}