} //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); }