} //end function public StudentIntermediateRecord StudentIntermediateRecordSelectByID(int intIntermediateStudentID) { try { string sp_name = "StudentIntermediateRecordSelectByID"; comStudentIntermediateRecord.Parameters.AddWithValue("IntermediateStudentID", intIntermediateStudentID); ConnectAndExecute(sp_name); //no parameter will send to stored procedure if (dsStudentIntermediateRecord.Tables[0].Rows.Count == 1) { DataRow drStudentIntermediateRecord = dsStudentIntermediateRecord.Tables[0].Rows[0]; StudentIntermediateRecord objStudentIntermediateRecord = new StudentIntermediateRecord(); objStudentIntermediateRecord.IntermediateStudentID = Convert.ToInt64(drStudentIntermediateRecord["IntermediateStudentID"]); objStudentIntermediateRecord.StudentID = Convert.ToInt64(drStudentIntermediateRecord["StudentID"]); objStudentIntermediateRecord.BoardInstitute = Convert.ToString(drStudentIntermediateRecord["BoardInstitute"]); objStudentIntermediateRecord.SchoolCollege = Convert.ToString(drStudentIntermediateRecord["SchoolCollege"]); objStudentIntermediateRecord.MajorDAE = Convert.ToInt64(drStudentIntermediateRecord["MajorDAE"]); objStudentIntermediateRecord.TotalMarks = Convert.ToInt32(drStudentIntermediateRecord["TotalMarks"]); objStudentIntermediateRecord.ObtainedMarks = Convert.ToInt32(drStudentIntermediateRecord["ObtainedMarks"]); objStudentIntermediateRecord.YearPassed = Convert.ToInt32(drStudentIntermediateRecord["YearPassed"]); objStudentIntermediateRecord.AddByID = Convert.ToInt64(drStudentIntermediateRecord["AddByID"]); objStudentIntermediateRecord.AddDateTime = Convert.ToDateTime(drStudentIntermediateRecord["AddDateTime"]); objStudentIntermediateRecord.LastUpdateID = Convert.ToInt64(drStudentIntermediateRecord["LastUpdateID"]); objStudentIntermediateRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentIntermediateRecord["LastUpdateDateTime"]); return(objStudentIntermediateRecord); } return(null); } catch (Exception ex) { SetError(ex.Message); return(null); } //end try } //end function
private void StudentInterMediateRecordInsertUpdate(Int64 student_Id = 0) { StudentIntermediateRecord studentIntermediateRecord = new StudentIntermediateRecord(); studentIntermediateRecord.IntermediateStudentID = 0; studentIntermediateRecord.StudentID = student_Id; studentIntermediateRecord.BoardInstitute = txtInterBoardIntitute.Text; studentIntermediateRecord.SchoolCollege = txtInterSchoolCollege.Text; studentIntermediateRecord.MajorDAE = Convert.ToInt64(cmbInterStudentDEAMajor.SelectedValue); studentIntermediateRecord.TotalMarks = Convert.ToInt32(txtInInterTotalMarks.Text); studentIntermediateRecord.ObtainedMarks = Convert.ToInt32(txtInInterObtainedMarks.Text); studentIntermediateRecord.YearPassed = Convert.ToInt32(txtInInterPercantage.Text); studentIntermediateRecord.AddByID = Convert.ToInt64(this.Tag); studentIntermediateRecord.AddDateTime = System.DateTime.Now; studentIntermediateRecord.LastUpdateID = Convert.ToInt64(this.Tag); studentIntermediateRecord.LastUpdateDateTime = System.DateTime.Now; StudentIntermediateRecordController.InsertUpdateStudentIntermediateRecord(studentIntermediateRecord); }
/////////////////////////////////////////////////////////////////////////////////////////// //Private Methods/////////////////////////////////////////////////////////////////////////// //DB to Model// private void GenerateModelList() { StudentIntermediateRecordList.Clear(); foreach (DataRow drStudentIntermediateRecord in dsStudentIntermediateRecord.Tables[0].Rows) { StudentIntermediateRecord objStudentIntermediateRecord = new StudentIntermediateRecord(); objStudentIntermediateRecord.IntermediateStudentID = Convert.ToInt64(drStudentIntermediateRecord["IntermediateStudentID"]); objStudentIntermediateRecord.StudentID = Convert.ToInt64(drStudentIntermediateRecord["StudentID"]); objStudentIntermediateRecord.BoardInstitute = Convert.ToString(drStudentIntermediateRecord["BoardInstitute"]); objStudentIntermediateRecord.SchoolCollege = Convert.ToString(drStudentIntermediateRecord["SchoolCollege"]); objStudentIntermediateRecord.MajorDAE = Convert.ToInt64(drStudentIntermediateRecord["MajorDAE"]); objStudentIntermediateRecord.TotalMarks = Convert.ToInt32(drStudentIntermediateRecord["TotalMarks"]); objStudentIntermediateRecord.ObtainedMarks = Convert.ToInt32(drStudentIntermediateRecord["ObtainedMarks"]); objStudentIntermediateRecord.YearPassed = Convert.ToInt32(drStudentIntermediateRecord["YearPassed"]); objStudentIntermediateRecord.AddByID = Convert.ToInt64(drStudentIntermediateRecord["AddByID"]); objStudentIntermediateRecord.AddDateTime = Convert.ToDateTime(drStudentIntermediateRecord["AddDateTime"]); objStudentIntermediateRecord.LastUpdateID = Convert.ToInt64(drStudentIntermediateRecord["LastUpdateID"]); objStudentIntermediateRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentIntermediateRecord["LastUpdateDateTime"]); StudentIntermediateRecordList.Add(objStudentIntermediateRecord); } }
public static Int64 InsertUpdateStudentIntermediateRecord(StudentIntermediateRecord objIUStudentIntermediateRecord) { Int64 new_id = objIUStudentIntermediateRecord.InsertUpdateStudentIntermediateRecord(); return(new_id); }