} //end function public StudentAssignedSubject StudentAssignedSubjectSelectByID(int intStudentSubjectID) { try { string sp_name = "StudentAssignedSubjectSelectByID"; comStudentAssignedSubject.Parameters.AddWithValue("StudentSubjectID", intStudentSubjectID); ConnectAndExecute(sp_name); //no parameter will send to stored procedure if (dsStudentAssignedSubject.Tables[0].Rows.Count == 1) { DataRow drStudentAssignedSubject = dsStudentAssignedSubject.Tables[0].Rows[0]; StudentAssignedSubject objStudentAssignedSubject = new StudentAssignedSubject(); objStudentAssignedSubject.StudentSubjectID = Convert.ToInt64(drStudentAssignedSubject["StudentSubjectID"]); objStudentAssignedSubject.StudentID = Convert.ToInt64(drStudentAssignedSubject["StudentID"]); objStudentAssignedSubject.SubjectID = Convert.ToInt64(drStudentAssignedSubject["SubjectID"]); objStudentAssignedSubject.Remarks = Convert.ToString(drStudentAssignedSubject["Remarks"]); objStudentAssignedSubject.AddedByID = Convert.ToInt64(drStudentAssignedSubject["AddedByID"]); objStudentAssignedSubject.AddedDateTime = Convert.ToDateTime(drStudentAssignedSubject["AddedDateTime"]); objStudentAssignedSubject.LastUpdateID = Convert.ToInt64(drStudentAssignedSubject["LastUpdateID"]); objStudentAssignedSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentAssignedSubject["LastUpdateDateTime"]); return(objStudentAssignedSubject); } return(null); } catch (Exception ex) { SetError(ex.Message); return(null); } //end try } //end function
/////////////////////////////////////////////////////////////////////////////////////////// //Private Methods/////////////////////////////////////////////////////////////////////////// //DB to Model// private void GenerateModelList() { StudentAssignedSubjectList.Clear(); foreach (DataRow drStudentAssignedSubject in dsStudentAssignedSubject.Tables[0].Rows) { StudentAssignedSubject objStudentAssignedSubject = new StudentAssignedSubject(); objStudentAssignedSubject.StudentSubjectID = Convert.ToInt64(drStudentAssignedSubject["StudentSubjectID"]); objStudentAssignedSubject.StudentID = Convert.ToInt64(drStudentAssignedSubject["StudentID"]); objStudentAssignedSubject.SubjectID = Convert.ToInt64(drStudentAssignedSubject["SubjectID"]); objStudentAssignedSubject.Remarks = Convert.ToString(drStudentAssignedSubject["Remarks"]); objStudentAssignedSubject.AddedByID = Convert.ToInt64(drStudentAssignedSubject["AddedByID"]); objStudentAssignedSubject.AddedDateTime = Convert.ToDateTime(drStudentAssignedSubject["AddedDateTime"]); objStudentAssignedSubject.LastUpdateID = Convert.ToInt64(drStudentAssignedSubject["LastUpdateID"]); objStudentAssignedSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentAssignedSubject["LastUpdateDateTime"]); StudentAssignedSubjectList.Add(objStudentAssignedSubject); } }
private void StudentAssingedSubjectInsertUpdate(Int64 student_Id = 0) { StudentAssignedSubject studentAssignedSubject = new StudentAssignedSubject(); ArrayList subjectList = chkAdmissionSubject.GetSelectedItems(); foreach (StudentSubject studentSubject in subjectList) { studentAssignedSubject = new StudentAssignedSubject(); studentAssignedSubject.StudentSubjectID = 0; studentAssignedSubject.SubjectID = studentSubject.SubjectID; studentAssignedSubject.StudentID = student_Id; studentAssignedSubject.Remarks = txtAdmissionInfoRemarks.Text; studentAssignedSubject.AddedByID = Convert.ToInt32(this.Tag); studentAssignedSubject.AddedDateTime = System.DateTime.Now; studentAssignedSubject.LastUpdateID = Convert.ToInt32(this.Tag); studentAssignedSubject.LastUpdateDateTime = System.DateTime.Now; StudentAssignedSubjectController.InsertUpdateStudentAssignedSubject(studentAssignedSubject); } }
public static Int64 InsertUpdateStudentAssignedSubject(StudentAssignedSubject objIUStudentAssignedSubject) { Int64 new_id = objIUStudentAssignedSubject.InsertUpdateStudentAssignedSubject(); return(new_id); }