} //end function
public StudentMasterSubject StudentMasterSubjectSelectByID(int intStudentSubjectID)
{
try
{
string sp_name = "StudentMasterSubjectSelectByID";
comStudentMasterSubject.Parameters.AddWithValue("StudentSubjectID", intStudentSubjectID);
ConnectAndExecute(sp_name); //no parameter will send to stored procedure
if (dsStudentMasterSubject.Tables[0].Rows.Count == 1)
{
DataRow drStudentMasterSubject = dsStudentMasterSubject.Tables[0].Rows[0];
StudentMasterSubject objStudentMasterSubject = new StudentMasterSubject();
objStudentMasterSubject.StudentSubjectID = Convert.ToInt64(drStudentMasterSubject["StudentSubjectID"]);
objStudentMasterSubject.StudentID = Convert.ToInt64(drStudentMasterSubject["StudentID"]);
objStudentMasterSubject.SubjectID = Convert.ToInt64(drStudentMasterSubject["SubjectID"]);
objStudentMasterSubject.Remarks = Convert.ToString(drStudentMasterSubject["Remarks"]);
objStudentMasterSubject.AddedByID = Convert.ToInt64(drStudentMasterSubject["AddedByID"]);
objStudentMasterSubject.AddedDateTime = Convert.ToDateTime(drStudentMasterSubject["AddedDateTime"]);
objStudentMasterSubject.LastUpdateID = Convert.ToInt64(drStudentMasterSubject["LastUpdateID"]);
objStudentMasterSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentMasterSubject["LastUpdateDateTime"]);
return(objStudentMasterSubject);
}
return(null);
}
catch (Exception ex)
{
SetError(ex.Message);
return(null);
} //end try
} //end function
///////////////////////////////////////////////////////////////////////////////////////////
//Private Methods///////////////////////////////////////////////////////////////////////////
//DB to Model//
private void GenerateModelList()
{
StudentMasterSubjectList.Clear();
foreach (DataRow drStudentMasterSubject in dsStudentMasterSubject.Tables[0].Rows)
{
StudentMasterSubject objStudentMasterSubject = new StudentMasterSubject();
objStudentMasterSubject.StudentSubjectID = Convert.ToInt64(drStudentMasterSubject["StudentSubjectID"]);
objStudentMasterSubject.StudentID = Convert.ToInt64(drStudentMasterSubject["StudentID"]);
objStudentMasterSubject.SubjectID = Convert.ToInt64(drStudentMasterSubject["SubjectID"]);
objStudentMasterSubject.Remarks = Convert.ToString(drStudentMasterSubject["Remarks"]);
objStudentMasterSubject.AddedByID = Convert.ToInt64(drStudentMasterSubject["AddedByID"]);
objStudentMasterSubject.AddedDateTime = Convert.ToDateTime(drStudentMasterSubject["AddedDateTime"]);
objStudentMasterSubject.LastUpdateID = Convert.ToInt64(drStudentMasterSubject["LastUpdateID"]);
objStudentMasterSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentMasterSubject["LastUpdateDateTime"]);
StudentMasterSubjectList.Add(objStudentMasterSubject);
}
}
public static Int64 InsertUpdateStudentMasterSubject(StudentMasterSubject objIUStudentMasterSubject)
{
Int64 new_id = objIUStudentMasterSubject.InsertUpdateStudentMasterSubject();
return(new_id);
}
