} //end function
public StudentFeeInfo StudentFeeInfoSelectByID(int intStudentFeeInfoID)
{
try
{
string sp_name = "StudentFeeInfoSelectByID";
comStudentFeeInfo.Parameters.AddWithValue("StudentFeeInfoID", intStudentFeeInfoID);
ConnectAndExecute(sp_name); //no parameter will send to stored procedure
if (dsStudentFeeInfo.Tables[0].Rows.Count == 1)
{
DataRow drStudentFeeInfo = dsStudentFeeInfo.Tables[0].Rows[0];
StudentFeeInfo objStudentFeeInfo = new StudentFeeInfo();
objStudentFeeInfo.StudentFeeInfoID = Convert.ToInt64(drStudentFeeInfo["StudentFeeInfoID"]);
objStudentFeeInfo.StudentID = Convert.ToInt64(drStudentFeeInfo["StudentID"]);
objStudentFeeInfo.TutionFee = Convert.ToString(drStudentFeeInfo["TutionFee"]);
objStudentFeeInfo.AdmissionFee = Convert.ToString(drStudentFeeInfo["AdmissionFee"]);
objStudentFeeInfo.RegistrationFee = Convert.ToString(drStudentFeeInfo["RegistrationFee"]);
objStudentFeeInfo.ExaminationFee = Convert.ToString(drStudentFeeInfo["ExaminationFee"]);
objStudentFeeInfo.Remarks = Convert.ToString(drStudentFeeInfo["Remarks"]);
objStudentFeeInfo.AddedByID = Convert.ToInt64(drStudentFeeInfo["AddedByID"]);
objStudentFeeInfo.AddedDateTime = Convert.ToDateTime(drStudentFeeInfo["AddedDateTime"]);
objStudentFeeInfo.LastUpdateID = Convert.ToInt64(drStudentFeeInfo["LastUpdateID"]);
objStudentFeeInfo.LastUpdateDateTime = Convert.ToDateTime(drStudentFeeInfo["LastUpdateDateTime"]);
return(objStudentFeeInfo);
}
return(null);
}
catch (Exception ex)
{
SetError(ex.Message);
return(null);
} //end try
} //end function
private void StudentFeeRecordInsertUpdate(Int64 student_Id = 0)
{
StudentFeeInfo studentFeeInfo = new StudentFeeInfo();
studentFeeInfo.StudentFeeInfoID = 0;
studentFeeInfo.StudentID = student_id;
studentFeeInfo.TutionFee = txtTutionFee.Text;
studentFeeInfo.AdmissionFee = txtAdmissionFee.Text;
studentFeeInfo.RegistrationFee = txtRegistrationFee.Text;
studentFeeInfo.ExaminationFee = txtEaminationFee.Text;
studentFeeInfo.Remarks = txtRemarksAboutFee.Text;
studentFeeInfo.AddedByID = Convert.ToInt64(this.Tag);
studentFeeInfo.AddedDateTime = System.DateTime.Now;
studentFeeInfo.LastUpdateID = Convert.ToInt64(this.Tag);
studentFeeInfo.LastUpdateDateTime = System.DateTime.Now;
StudentFeeInfoController.InsertUpdateStudentFeeInfo(studentFeeInfo);
}
///////////////////////////////////////////////////////////////////////////////////////////
//Private Methods///////////////////////////////////////////////////////////////////////////
//DB to Model//
private void GenerateModelList()
{
StudentFeeInfoList.Clear();
foreach (DataRow drStudentFeeInfo in dsStudentFeeInfo.Tables[0].Rows)
{
StudentFeeInfo objStudentFeeInfo = new StudentFeeInfo();
objStudentFeeInfo.StudentFeeInfoID = Convert.ToInt64(drStudentFeeInfo["StudentFeeInfoID"]);
objStudentFeeInfo.StudentID = Convert.ToInt64(drStudentFeeInfo["StudentID"]);
objStudentFeeInfo.TutionFee = Convert.ToString(drStudentFeeInfo["TutionFee"]);
objStudentFeeInfo.AdmissionFee = Convert.ToString(drStudentFeeInfo["AdmissionFee"]);
objStudentFeeInfo.RegistrationFee = Convert.ToString(drStudentFeeInfo["RegistrationFee"]);
objStudentFeeInfo.ExaminationFee = Convert.ToString(drStudentFeeInfo["ExaminationFee"]);
objStudentFeeInfo.Remarks = Convert.ToString(drStudentFeeInfo["Remarks"]);
objStudentFeeInfo.AddedByID = Convert.ToInt64(drStudentFeeInfo["AddedByID"]);
objStudentFeeInfo.AddedDateTime = Convert.ToDateTime(drStudentFeeInfo["AddedDateTime"]);
objStudentFeeInfo.LastUpdateID = Convert.ToInt64(drStudentFeeInfo["LastUpdateID"]);
objStudentFeeInfo.LastUpdateDateTime = Convert.ToDateTime(drStudentFeeInfo["LastUpdateDateTime"]);
StudentFeeInfoList.Add(objStudentFeeInfo);
}
}
public static Int64 InsertUpdateStudentFeeInfo(StudentFeeInfo objIUStudentFeeInfo)
{
Int64 new_id = objIUStudentFeeInfo.InsertUpdateStudentFeeInfo();
return(new_id);
}
