} //end function public StudentAddmissionInfo StudentAddmissionInfoSelectByID(int intStudentAddmissionID) { try { string sp_name = "StudentAddmissionInfoSelectByID"; comStudentAddmissionInfo.Parameters.AddWithValue("StudentAddmissionID", intStudentAddmissionID); ConnectAndExecute(sp_name); //no parameter will send to stored procedure if (dsStudentAddmissionInfo.Tables[0].Rows.Count == 1) { DataRow drStudentAddmissionInfo = dsStudentAddmissionInfo.Tables[0].Rows[0]; StudentAddmissionInfo objStudentAddmissionInfo = new StudentAddmissionInfo(); objStudentAddmissionInfo.StudentAddmissionID = Convert.ToInt64(drStudentAddmissionInfo["StudentAddmissionID"]); objStudentAddmissionInfo.StudentID = Convert.ToInt64(drStudentAddmissionInfo["StudentID"]); objStudentAddmissionInfo.StudentRollNo = Convert.ToString(drStudentAddmissionInfo["StudentRollNo"]); objStudentAddmissionInfo.AdmissionProgram = Convert.ToInt64(drStudentAddmissionInfo["AdmissionProgram"]); objStudentAddmissionInfo.AddmissionDegree = Convert.ToInt64(drStudentAddmissionInfo["AddmissionDegree"]); objStudentAddmissionInfo.EducationSystem = Convert.ToString(drStudentAddmissionInfo["EducationSystem"]); objStudentAddmissionInfo.StudentSessionID = Convert.ToInt64(drStudentAddmissionInfo["StudentSessionID"]); objStudentAddmissionInfo.IsEnabled = Convert.ToBoolean(drStudentAddmissionInfo["IsEnabled"]); objStudentAddmissionInfo.StudentSection = Convert.ToInt64(drStudentAddmissionInfo["StudentSection"]); objStudentAddmissionInfo.AddByID = Convert.ToInt64(drStudentAddmissionInfo["AddByID"]); objStudentAddmissionInfo.AddByDateTime = Convert.ToDateTime(drStudentAddmissionInfo["AddByDateTime"]); objStudentAddmissionInfo.LastUpdateID = Convert.ToInt64(drStudentAddmissionInfo["LastUpdateID"]); objStudentAddmissionInfo.LastUpdateDateTime = Convert.ToDateTime(drStudentAddmissionInfo["LastUpdateDateTime"]); return(objStudentAddmissionInfo); } return(null); } catch (Exception ex) { SetError(ex.Message); return(null); } //end try } //end function
private void StudentAdmissionInfoInsertUpdate(Int64 student_Id = 0) { StudentAddmissionInfo studentAddmissionInfo = new StudentAddmissionInfo(); studentAddmissionInfo.StudentAddmissionID = 0; studentAddmissionInfo.StudentID = student_Id; studentAddmissionInfo.StudentRollNo = txtStudentRollNumber.Text; studentAddmissionInfo.AdmissionProgram = Convert.ToInt64(cmbStudentAdmissionProgram.SelectedValue); studentAddmissionInfo.AddmissionDegree = Convert.ToInt64(cmbStudentAdmissionDegree.SelectedValue); studentAddmissionInfo.EducationSystem = cmbEducationSystem.Text; studentAddmissionInfo.StudentSessionID = Convert.ToInt64(cmbStudentSession.SelectedValue); studentAddmissionInfo.IsEnabled = true; studentAddmissionInfo.StudentSection = Convert.ToInt64(cmbStudentSection.SelectedValue); studentAddmissionInfo.AddByID = Convert.ToInt64(this.Tag); studentAddmissionInfo.AddByDateTime = System.DateTime.Now; studentAddmissionInfo.LastUpdateID = Convert.ToInt64(this.Tag); studentAddmissionInfo.LastUpdateDateTime = System.DateTime.Now; StudentAddmissionInfoController.InsertUpdateStudentAddmissionInfo(studentAddmissionInfo); }
/////////////////////////////////////////////////////////////////////////////////////////// //Private Methods/////////////////////////////////////////////////////////////////////////// //DB to Model// private void GenerateModelList() { StudentAddmissionInfoList.Clear(); foreach (DataRow drStudentAddmissionInfo in dsStudentAddmissionInfo.Tables[0].Rows) { StudentAddmissionInfo objStudentAddmissionInfo = new StudentAddmissionInfo(); objStudentAddmissionInfo.StudentAddmissionID = Convert.ToInt64(drStudentAddmissionInfo["StudentAddmissionID"]); objStudentAddmissionInfo.StudentID = Convert.ToInt64(drStudentAddmissionInfo["StudentID"]); objStudentAddmissionInfo.StudentRollNo = Convert.ToString(drStudentAddmissionInfo["StudentRollNo"]); objStudentAddmissionInfo.AdmissionProgram = Convert.ToInt64(drStudentAddmissionInfo["AdmissionProgram"]); objStudentAddmissionInfo.AddmissionDegree = Convert.ToInt64(drStudentAddmissionInfo["AddmissionDegree"]); objStudentAddmissionInfo.EducationSystem = Convert.ToString(drStudentAddmissionInfo["EducationSystem"]); objStudentAddmissionInfo.StudentSessionID = Convert.ToInt64(drStudentAddmissionInfo["StudentSessionID"]); objStudentAddmissionInfo.IsEnabled = Convert.ToBoolean(drStudentAddmissionInfo["IsEnabled"]); objStudentAddmissionInfo.StudentSection = Convert.ToInt64(drStudentAddmissionInfo["StudentSection"]); objStudentAddmissionInfo.AddByID = Convert.ToInt64(drStudentAddmissionInfo["AddByID"]); objStudentAddmissionInfo.AddByDateTime = Convert.ToDateTime(drStudentAddmissionInfo["AddByDateTime"]); objStudentAddmissionInfo.LastUpdateID = Convert.ToInt64(drStudentAddmissionInfo["LastUpdateID"]); objStudentAddmissionInfo.LastUpdateDateTime = Convert.ToDateTime(drStudentAddmissionInfo["LastUpdateDateTime"]); StudentAddmissionInfoList.Add(objStudentAddmissionInfo); } }
public static Int64 InsertUpdateStudentAddmissionInfo(StudentAddmissionInfo objIUStudentAddmissionInfo) { Int64 new_id = objIUStudentAddmissionInfo.InsertUpdateStudentAddmissionInfo(); return(new_id); }