public string calculation()
{
int totalPaid = 0;
string gradeId = "";
DsPSMS.ST_STUDENT_CASHDataTable stuCashDt = new DsPSMS.ST_STUDENT_CASHDataTable();
DsPSMS.ST_GRADE_MSTDataTable grdDt = new DsPSMS.ST_GRADE_MSTDataTable();
DsPSMS.ST_STUDENT_CASHRow stuCashDr = new DsPSMS.ST_STUDENT_CASHDataTable().NewST_STUDENT_CASHRow();
DsPSMS.ST_GRADE_MSTRow grdDr = new DsPSMS.ST_GRADE_MSTDataTable().NewST_GRADE_MSTRow();
// select GRADE_ID and CASH_AMOUNT
grdDr.GRADE_ID = CoboGrade.SelectedItem.Text;
grdDt = grdSubService.selectGradeByID(grdDr, out msg);
//get cash data and calculate paid amount
stuCashDr.STUDENT_ID = TxtStudID.Text;
stuCashDr.EDU_YEAR = CoboYear.Text;
stuCashDt = stuCashService.getCashData(stuCashDr, out msg);
for (int i = 0; i < stuCashDt.Rows.Count; i++)
{
totalPaid += Convert.ToInt32(stuCashDt[i].AMOUNT);
}
gradeId = grdDt[0].GRADE_ID;
// gradeId = CoboGrade.Text;
LabMonVal.Text = "10 months";
LabKyatVal.Text = grdDt[0].MONTHLY_FEE;
LabPaidVal.Text = Convert.ToString(totalPaid);
LabRemainVal.Text = Convert.ToString((10 * Convert.ToInt32(LabKyatVal.Text)) - totalPaid);
return(gradeId);
}
protected void Page_Load(object sender, EventArgs e)
{
this.UnobtrusiveValidationMode = System.Web.UI.UnobtrusiveValidationMode.None;
//imgSchool.ImageUrl = "~/Images/school.png";
stdInfo.ImageUrl = "~/Images/student.png";
attendanceInfo.ImageUrl = "~/Images/attendance.jpg";
examInfo.ImageUrl = "~/Images/exam.png";
teacherInfo.ImageUrl = "~/Images/teacher.png";
system.ImageUrl = "~/Images/system.jpg";
logoImage.ImageUrl = "~/Images/logo1.png";
DsPSMS.ST_GRADE_MSTDataTable grdDt = new DsPSMS.ST_GRADE_MSTDataTable();
DsPSMS.ST_STUDENT_DATARow stDr = new DsPSMS.ST_STUDENT_DATADataTable().NewST_STUDENT_DATARow();
DsPSMS.ST_GRADE_MSTRow grdDr = new DsPSMS.ST_GRADE_MSTDataTable().NewST_GRADE_MSTRow();
if (Session["USER_ID"] != null)
{
userId = (string)(Session["USER_ID"] ?? " ");
}
if (Session["EDU_YEAR"] != null)
{
CoboYear.Text = (string)(Session["EDU_YEAR"] ?? " ");
stDr.EDU_YEAR = CoboYear.Text;
Session.Remove("EDU_YEAR");
}
if (Session["STUDENT_ID"] != null)
{
TxtStudID.Text = (string)(Session["STUDENT_ID"] ?? " ");
stDr.STUDENT_ID = TxtStudID.Text;
stDr = stuService.getStuName(stDr, out msg);
TxtStuName.Text = stDr.STUDENT_NAME;
grdDr.GRADE_ID = stDr.GRADE_ID;
grdDt = grdSubService.selectGradeByID(grdDr, out msg);
CoboGrade.SelectedItem.Text = stDr.GRADE_ID;
CoboSelect_Change(sender, e);
Session.Remove("STUDENT_ID");
}
if (Session["CASH_DATE"] != null)
{
cashDate.Text = (string)(Session["CASH_DATE"] ?? " ");
Session.Remove("CASH_DATE");
}
// binding grade to combo box
grdDt = grdSubService.getAllGradeData(out msg);
if (grdDt != null && grdDt.Rows.Count != 0)
{
CoboGrade.DataSource = null;
CoboGrade.DataSource = grdDt;
CoboGrade.DataTextField = "GRADE_NAME";
CoboGrade.DataValueField = "GRADE_ID";
CoboGrade.DataBind();
}
}
