} //end function
public StudentMatricRecord StudentMatricRecordSelectByID(int intMatricStudentID)
{
try
{
string sp_name = "StudentMatricRecordSelectByID";
comStudentMatricRecord.Parameters.AddWithValue("MatricStudentID", intMatricStudentID);
ConnectAndExecute(sp_name); //no parameter will send to stored procedure
if (dsStudentMatricRecord.Tables[0].Rows.Count == 1)
{
DataRow drStudentMatricRecord = dsStudentMatricRecord.Tables[0].Rows[0];
StudentMatricRecord objStudentMatricRecord = new StudentMatricRecord();
objStudentMatricRecord.MatricStudentID = Convert.ToInt64(drStudentMatricRecord["MatricStudentID"]);
objStudentMatricRecord.StudentID = Convert.ToInt64(drStudentMatricRecord["StudentID"]);
objStudentMatricRecord.Board = Convert.ToString(drStudentMatricRecord["Board"]);
objStudentMatricRecord.School = Convert.ToString(drStudentMatricRecord["School"]);
objStudentMatricRecord.TotalMarks = Convert.ToInt32(drStudentMatricRecord["TotalMarks"]);
objStudentMatricRecord.ObtainedMarks = Convert.ToInt32(drStudentMatricRecord["ObtainedMarks"]);
objStudentMatricRecord.YearPassed = Convert.ToInt32(drStudentMatricRecord["YearPassed"]);
objStudentMatricRecord.LastUpdateID = Convert.ToInt64(drStudentMatricRecord["LastUpdateID"]);
objStudentMatricRecord.AddByID = Convert.ToInt64(drStudentMatricRecord["AddByID"]);
objStudentMatricRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentMatricRecord["LastUpdateDateTime"]);
objStudentMatricRecord.AddDateTime = Convert.ToDateTime(drStudentMatricRecord["AddDateTime"]);
return(objStudentMatricRecord);
}
return(null);
}
catch (Exception ex)
{
SetError(ex.Message);
return(null);
} //end try
} //end function
private void StudentMatricRecordInserUpdate(Int64 student_Id = 0)
{
StudentMatricRecord studentMatricRecord = new StudentMatricRecord();
studentMatricRecord.MatricStudentID = 0;
studentMatricRecord.StudentID = student_Id;
studentMatricRecord.Board = txtMatricStudentBoardInstitute.Text;
studentMatricRecord.School = txtMatricSchoolInstitute.Text;
studentMatricRecord.TotalMarks = Convert.ToInt32(txtInMatricTotalMarks.Text);
studentMatricRecord.ObtainedMarks = Convert.ToInt32(txtInMatricObtainedMarks.Text);
studentMatricRecord.YearPassed = Convert.ToInt32(txtMatricPassedYear.Text);
studentMatricRecord.AddByID = Convert.ToInt64(this.Tag);
studentMatricRecord.AddDateTime = System.DateTime.Now;
studentMatricRecord.LastUpdateID = Convert.ToInt64(this.Tag);
studentMatricRecord.LastUpdateDateTime = System.DateTime.Now;
StudentMatricRecordController.InsertUpdateStudentMatricRecord(studentMatricRecord);
}
///////////////////////////////////////////////////////////////////////////////////////////
//Private Methods///////////////////////////////////////////////////////////////////////////
//DB to Model//
private void GenerateModelList()
{
StudentMatricRecordList.Clear();
foreach (DataRow drStudentMatricRecord in dsStudentMatricRecord.Tables[0].Rows)
{
StudentMatricRecord objStudentMatricRecord = new StudentMatricRecord();
objStudentMatricRecord.MatricStudentID = Convert.ToInt64(drStudentMatricRecord["MatricStudentID"]);
objStudentMatricRecord.StudentID = Convert.ToInt64(drStudentMatricRecord["StudentID"]);
objStudentMatricRecord.Board = Convert.ToString(drStudentMatricRecord["Board"]);
objStudentMatricRecord.School = Convert.ToString(drStudentMatricRecord["School"]);
objStudentMatricRecord.TotalMarks = Convert.ToInt32(drStudentMatricRecord["TotalMarks"]);
objStudentMatricRecord.ObtainedMarks = Convert.ToInt32(drStudentMatricRecord["ObtainedMarks"]);
objStudentMatricRecord.YearPassed = Convert.ToInt32(drStudentMatricRecord["YearPassed"]);
objStudentMatricRecord.LastUpdateID = Convert.ToInt64(drStudentMatricRecord["LastUpdateID"]);
objStudentMatricRecord.AddByID = Convert.ToInt64(drStudentMatricRecord["AddByID"]);
objStudentMatricRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentMatricRecord["LastUpdateDateTime"]);
objStudentMatricRecord.AddDateTime = Convert.ToDateTime(drStudentMatricRecord["AddDateTime"]);
StudentMatricRecordList.Add(objStudentMatricRecord);
}
}
public static Int64 InsertUpdateStudentMatricRecord(StudentMatricRecord objIUStudentMatricRecord)
{
Int64 new_id = objIUStudentMatricRecord.InsertUpdateStudentMatricRecord();
return(new_id);
}
