} //end function
public StudentIntermediateRecord StudentIntermediateRecordSelectByID(int intIntermediateStudentID)
{
try
{
string sp_name = "StudentIntermediateRecordSelectByID";
comStudentIntermediateRecord.Parameters.AddWithValue("IntermediateStudentID", intIntermediateStudentID);
ConnectAndExecute(sp_name); //no parameter will send to stored procedure
if (dsStudentIntermediateRecord.Tables[0].Rows.Count == 1)
{
DataRow drStudentIntermediateRecord = dsStudentIntermediateRecord.Tables[0].Rows[0];
StudentIntermediateRecord objStudentIntermediateRecord = new StudentIntermediateRecord();
objStudentIntermediateRecord.IntermediateStudentID = Convert.ToInt64(drStudentIntermediateRecord["IntermediateStudentID"]);
objStudentIntermediateRecord.StudentID = Convert.ToInt64(drStudentIntermediateRecord["StudentID"]);
objStudentIntermediateRecord.BoardInstitute = Convert.ToString(drStudentIntermediateRecord["BoardInstitute"]);
objStudentIntermediateRecord.SchoolCollege = Convert.ToString(drStudentIntermediateRecord["SchoolCollege"]);
objStudentIntermediateRecord.MajorDAE = Convert.ToInt64(drStudentIntermediateRecord["MajorDAE"]);
objStudentIntermediateRecord.TotalMarks = Convert.ToInt32(drStudentIntermediateRecord["TotalMarks"]);
objStudentIntermediateRecord.ObtainedMarks = Convert.ToInt32(drStudentIntermediateRecord["ObtainedMarks"]);
objStudentIntermediateRecord.YearPassed = Convert.ToInt32(drStudentIntermediateRecord["YearPassed"]);
objStudentIntermediateRecord.AddByID = Convert.ToInt64(drStudentIntermediateRecord["AddByID"]);
objStudentIntermediateRecord.AddDateTime = Convert.ToDateTime(drStudentIntermediateRecord["AddDateTime"]);
objStudentIntermediateRecord.LastUpdateID = Convert.ToInt64(drStudentIntermediateRecord["LastUpdateID"]);
objStudentIntermediateRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentIntermediateRecord["LastUpdateDateTime"]);
return(objStudentIntermediateRecord);
}
return(null);
}
catch (Exception ex)
{
SetError(ex.Message);
return(null);
} //end try
} //end function
private void StudentInterMediateRecordInsertUpdate(Int64 student_Id = 0)
{
StudentIntermediateRecord studentIntermediateRecord = new StudentIntermediateRecord();
studentIntermediateRecord.IntermediateStudentID = 0;
studentIntermediateRecord.StudentID = student_Id;
studentIntermediateRecord.BoardInstitute = txtInterBoardIntitute.Text;
studentIntermediateRecord.SchoolCollege = txtInterSchoolCollege.Text;
studentIntermediateRecord.MajorDAE = Convert.ToInt64(cmbInterStudentDEAMajor.SelectedValue);
studentIntermediateRecord.TotalMarks = Convert.ToInt32(txtInInterTotalMarks.Text);
studentIntermediateRecord.ObtainedMarks = Convert.ToInt32(txtInInterObtainedMarks.Text);
studentIntermediateRecord.YearPassed = Convert.ToInt32(txtInInterPercantage.Text);
studentIntermediateRecord.AddByID = Convert.ToInt64(this.Tag);
studentIntermediateRecord.AddDateTime = System.DateTime.Now;
studentIntermediateRecord.LastUpdateID = Convert.ToInt64(this.Tag);
studentIntermediateRecord.LastUpdateDateTime = System.DateTime.Now;
StudentIntermediateRecordController.InsertUpdateStudentIntermediateRecord(studentIntermediateRecord);
}
///////////////////////////////////////////////////////////////////////////////////////////
//Private Methods///////////////////////////////////////////////////////////////////////////
//DB to Model//
private void GenerateModelList()
{
StudentIntermediateRecordList.Clear();
foreach (DataRow drStudentIntermediateRecord in dsStudentIntermediateRecord.Tables[0].Rows)
{
StudentIntermediateRecord objStudentIntermediateRecord = new StudentIntermediateRecord();
objStudentIntermediateRecord.IntermediateStudentID = Convert.ToInt64(drStudentIntermediateRecord["IntermediateStudentID"]);
objStudentIntermediateRecord.StudentID = Convert.ToInt64(drStudentIntermediateRecord["StudentID"]);
objStudentIntermediateRecord.BoardInstitute = Convert.ToString(drStudentIntermediateRecord["BoardInstitute"]);
objStudentIntermediateRecord.SchoolCollege = Convert.ToString(drStudentIntermediateRecord["SchoolCollege"]);
objStudentIntermediateRecord.MajorDAE = Convert.ToInt64(drStudentIntermediateRecord["MajorDAE"]);
objStudentIntermediateRecord.TotalMarks = Convert.ToInt32(drStudentIntermediateRecord["TotalMarks"]);
objStudentIntermediateRecord.ObtainedMarks = Convert.ToInt32(drStudentIntermediateRecord["ObtainedMarks"]);
objStudentIntermediateRecord.YearPassed = Convert.ToInt32(drStudentIntermediateRecord["YearPassed"]);
objStudentIntermediateRecord.AddByID = Convert.ToInt64(drStudentIntermediateRecord["AddByID"]);
objStudentIntermediateRecord.AddDateTime = Convert.ToDateTime(drStudentIntermediateRecord["AddDateTime"]);
objStudentIntermediateRecord.LastUpdateID = Convert.ToInt64(drStudentIntermediateRecord["LastUpdateID"]);
objStudentIntermediateRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentIntermediateRecord["LastUpdateDateTime"]);
StudentIntermediateRecordList.Add(objStudentIntermediateRecord);
}
}
public static Int64 InsertUpdateStudentIntermediateRecord(StudentIntermediateRecord objIUStudentIntermediateRecord)
{
Int64 new_id = objIUStudentIntermediateRecord.InsertUpdateStudentIntermediateRecord();
return(new_id);
}
