public static int UpdateStudent(Student Obj_Student_Update) { try { using (EducationalInstituteEntities db = new EducationalInstituteEntities()) { //Lambda expression Student c = db.Students.SingleOrDefault(x => x.ID == Obj_Student_Update.ID); c.Name = Obj_Student_Update.Name; c.FatherName = Obj_Student_Update.FatherName; c.Address = Obj_Student_Update.Address; c.Email = Obj_Student_Update.Email; c.Mobile = Obj_Student_Update.Mobile; c.DOB = Obj_Student_Update.DOB; c.CourseID = Obj_Student_Update.CourseID; c.TeacherID = Obj_Student_Update.TeacherID; db.SaveChanges(); return(Obj_Student_Update.ID); } } catch (Exception ex) { throw ex; } }
public static void SaveTeachers(Teacher Obj_Teacher_Save)//This is Add method. { try { using (EducationalInstituteEntities db = new EducationalInstituteEntities()) { db.Teachers.Add(Obj_Teacher_Save); db.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void SaveCourses(Course Obj_Course_Save)//This is Add method. { try { using (EducationalInstituteEntities db = new EducationalInstituteEntities()) { db.Courses.Add(Obj_Course_Save); db.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void SaveStudents(Student Obj_Student_Save)//This is Add method. { try { using (EducationalInstituteEntities db = new EducationalInstituteEntities()) { db.Students.Add(Obj_Student_Save); db.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static List <Teacher> GetTeacherDetails(string selectedValue) { try { List <Teacher> Obj_Teacher_Detail = null; using (EducationalInstituteEntities db = new EducationalInstituteEntities()) { Obj_Teacher_Detail = (from c in db.Teachers where c.ID.ToString() == selectedValue select c).ToList(); } return(Obj_Teacher_Detail ); } catch (Exception ex) { throw ex; } }
public static int UpdateCourse(Course Obj_Course_Update) { try { using (EducationalInstituteEntities db = new EducationalInstituteEntities()) { //Lambda expression Course c = db.Courses.SingleOrDefault(x => x.ID == Obj_Course_Update.ID); c.CourseName = Obj_Course_Update.CourseName; db.SaveChanges(); return(Obj_Course_Update.ID); } } catch (Exception ex) { throw ex; } }
public static void DeleteTeacher(string Obj_Teacher_Delete) { try { using (EducationalInstituteEntities db = new EducationalInstituteEntities()) { //Lambda expression Teacher c = db.Teachers.SingleOrDefault(x => x.ID.ToString().Trim() == Obj_Teacher_Delete.Trim()); if (c != null) { db.Teachers.Remove(c); db.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static int UpdateTeacher(Teacher Obj_Teacher_Update) { try { using (EducationalInstituteEntities db = new EducationalInstituteEntities()) { //Lambda expression Teacher c = db.Teachers.SingleOrDefault(x => x.ID == Obj_Teacher_Update.ID); c.Name = Obj_Teacher_Update.Name; c.FatherName = Obj_Teacher_Update.FatherName; c.Address = Obj_Teacher_Update.Address; c.Email = Obj_Teacher_Update.Email; c.Mobile = Obj_Teacher_Update.Mobile; db.SaveChanges(); return(Obj_Teacher_Update.ID); } } catch (Exception ex) { throw ex; } }