} //end function public StudentMatricSubject StudentMatricSubjectSelectByID(int intStudentSubjectID) { try { string sp_name = "StudentMatricSubjectSelectByID"; comStudentMatricSubject.Parameters.AddWithValue("StudentSubjectID", intStudentSubjectID); ConnectAndExecute(sp_name); //no parameter will send to stored procedure if (dsStudentMatricSubject.Tables[0].Rows.Count == 1) { DataRow drStudentMatricSubject = dsStudentMatricSubject.Tables[0].Rows[0]; StudentMatricSubject objStudentMatricSubject = new StudentMatricSubject(); objStudentMatricSubject.StudentSubjectID = Convert.ToInt64(drStudentMatricSubject["StudentSubjectID"]); objStudentMatricSubject.StudentID = Convert.ToInt64(drStudentMatricSubject["StudentID"]); objStudentMatricSubject.SubjectID = Convert.ToInt64(drStudentMatricSubject["SubjectID"]); objStudentMatricSubject.Remarks = Convert.ToString(drStudentMatricSubject["Remarks"]); objStudentMatricSubject.AddedByID = Convert.ToInt64(drStudentMatricSubject["AddedByID"]); objStudentMatricSubject.AddedDateTime = Convert.ToDateTime(drStudentMatricSubject["AddedDateTime"]); objStudentMatricSubject.LastUpdateID = Convert.ToInt64(drStudentMatricSubject["LastUpdateID"]); objStudentMatricSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentMatricSubject["LastUpdateDateTime"]); return(objStudentMatricSubject); } return(null); } catch (Exception ex) { SetError(ex.Message); return(null); } //end try } //end function
/////////////////////////////////////////////////////////////////////////////////////////// //Private Methods/////////////////////////////////////////////////////////////////////////// //DB to Model// private void GenerateModelList() { StudentMatricSubjectList.Clear(); foreach (DataRow drStudentMatricSubject in dsStudentMatricSubject.Tables[0].Rows) { StudentMatricSubject objStudentMatricSubject = new StudentMatricSubject(); objStudentMatricSubject.StudentSubjectID = Convert.ToInt64(drStudentMatricSubject["StudentSubjectID"]); objStudentMatricSubject.StudentID = Convert.ToInt64(drStudentMatricSubject["StudentID"]); objStudentMatricSubject.SubjectID = Convert.ToInt64(drStudentMatricSubject["SubjectID"]); objStudentMatricSubject.Remarks = Convert.ToString(drStudentMatricSubject["Remarks"]); objStudentMatricSubject.AddedByID = Convert.ToInt64(drStudentMatricSubject["AddedByID"]); objStudentMatricSubject.AddedDateTime = Convert.ToDateTime(drStudentMatricSubject["AddedDateTime"]); objStudentMatricSubject.LastUpdateID = Convert.ToInt64(drStudentMatricSubject["LastUpdateID"]); objStudentMatricSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentMatricSubject["LastUpdateDateTime"]); StudentMatricSubjectList.Add(objStudentMatricSubject); } }
private void StudentMatricSubjectInsertUpdate(Int64 student_Id = 0) { StudentMatricSubject studentMatricSubject = new StudentMatricSubject(); ArrayList matricSubjectList = chkStudentMatricSelectedSubject.GetSelectedItems(); foreach (StudentSubject studentSubject in matricSubjectList) { studentMatricSubject = new StudentMatricSubject(); studentMatricSubject.StudentSubjectID = 0; studentMatricSubject.StudentID = student_Id; studentMatricSubject.SubjectID = studentSubject.SubjectID; studentMatricSubject.Remarks = txtMatricStudentRemark.Text; studentMatricSubject.AddedByID = Convert.ToInt64(this.Tag); studentMatricSubject.AddedDateTime = System.DateTime.Now; studentMatricSubject.LastUpdateID = Convert.ToInt64(this.Tag); studentMatricSubject.LastUpdateDateTime = System.DateTime.Now; Int64 id = StudentMatricSubjectController.InsertUpdateStudentMatricSubject(studentMatricSubject); } }
public static Int64 InsertUpdateStudentMatricSubject(StudentMatricSubject objIUStudentMatricSubject) { Int64 new_id = objIUStudentMatricSubject.InsertUpdateStudentMatricSubject(); return(new_id); }