} //end function public StudentIntermediateSubject StudentIntermediateSubjectSelectByID(int intStudentSubjectID) { try { string sp_name = "StudentIntermediateSubjectSelectByID"; comStudentIntermediateSubject.Parameters.AddWithValue("StudentSubjectID", intStudentSubjectID); ConnectAndExecute(sp_name); //no parameter will send to stored procedure if (dsStudentIntermediateSubject.Tables[0].Rows.Count == 1) { DataRow drStudentIntermediateSubject = dsStudentIntermediateSubject.Tables[0].Rows[0]; StudentIntermediateSubject objStudentIntermediateSubject = new StudentIntermediateSubject(); objStudentIntermediateSubject.StudentSubjectID = Convert.ToInt64(drStudentIntermediateSubject["StudentSubjectID"]); objStudentIntermediateSubject.StudentID = Convert.ToInt64(drStudentIntermediateSubject["StudentID"]); objStudentIntermediateSubject.SubjectID = Convert.ToInt64(drStudentIntermediateSubject["SubjectID"]); objStudentIntermediateSubject.Remarks = Convert.ToString(drStudentIntermediateSubject["Remarks"]); objStudentIntermediateSubject.AddedByID = Convert.ToInt64(drStudentIntermediateSubject["AddedByID"]); objStudentIntermediateSubject.AddedDateTime = Convert.ToDateTime(drStudentIntermediateSubject["AddedDateTime"]); objStudentIntermediateSubject.LastUpdateID = Convert.ToInt64(drStudentIntermediateSubject["LastUpdateID"]); objStudentIntermediateSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentIntermediateSubject["LastUpdateDateTime"]); return(objStudentIntermediateSubject); } return(null); } catch (Exception ex) { SetError(ex.Message); return(null); } //end try } //end function
/////////////////////////////////////////////////////////////////////////////////////////// //Private Methods/////////////////////////////////////////////////////////////////////////// //DB to Model// private void GenerateModelList() { StudentIntermediateSubjectList.Clear(); foreach (DataRow drStudentIntermediateSubject in dsStudentIntermediateSubject.Tables[0].Rows) { StudentIntermediateSubject objStudentIntermediateSubject = new StudentIntermediateSubject(); objStudentIntermediateSubject.StudentSubjectID = Convert.ToInt64(drStudentIntermediateSubject["StudentSubjectID"]); objStudentIntermediateSubject.StudentID = Convert.ToInt64(drStudentIntermediateSubject["StudentID"]); objStudentIntermediateSubject.SubjectID = Convert.ToInt64(drStudentIntermediateSubject["SubjectID"]); objStudentIntermediateSubject.Remarks = Convert.ToString(drStudentIntermediateSubject["Remarks"]); objStudentIntermediateSubject.AddedByID = Convert.ToInt64(drStudentIntermediateSubject["AddedByID"]); objStudentIntermediateSubject.AddedDateTime = Convert.ToDateTime(drStudentIntermediateSubject["AddedDateTime"]); objStudentIntermediateSubject.LastUpdateID = Convert.ToInt64(drStudentIntermediateSubject["LastUpdateID"]); objStudentIntermediateSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentIntermediateSubject["LastUpdateDateTime"]); StudentIntermediateSubjectList.Add(objStudentIntermediateSubject); } }
private void StudentInterMediateSubjectInsertUpdate(Int64 student_Id = 0) { StudentIntermediateSubject studentIntermediateSubject = new StudentIntermediateSubject(); ArrayList studentInterSubjectList = chkInterSelectedSubject.GetSelectedItems(); foreach (StudentSubject studentSubject in studentInterSubjectList) { studentIntermediateSubject = new StudentIntermediateSubject(); studentIntermediateSubject.StudentSubjectID = 0; studentIntermediateSubject.StudentID = student_Id; studentIntermediateSubject.SubjectID = studentSubject.SubjectID; studentIntermediateSubject.Remarks = txtInterStudentRemarks.Text; studentIntermediateSubject.AddedByID = Convert.ToInt64(this.Tag); studentIntermediateSubject.AddedDateTime = System.DateTime.Now; studentIntermediateSubject.LastUpdateID = Convert.ToInt64(this.Tag); studentIntermediateSubject.LastUpdateDateTime = System.DateTime.Now; StudentIntermediateSubjectController.InsertUpdateStudentIntermediateSubject(studentIntermediateSubject); } }
public static Int64 InsertUpdateStudentIntermediateSubject(StudentIntermediateSubject objIUStudentIntermediateSubject) { Int64 new_id = objIUStudentIntermediateSubject.InsertUpdateStudentIntermediateSubject(); return(new_id); }