public static void SaveCoordinators(ExhibitionCoordinatorMaster Obj_Coordinator_Save)//save coordinator method. { try { using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { db.ExhibitionCoordinatorMasters.Add(Obj_Coordinator_Save); db.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void SaveClasses(ClassMaster Class_Save)//save class method. { try { using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { db.ClassMasters.Add(Class_Save); db.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void SaveStudents(StudentMaster Obj_Student_Save)//save method. { try { using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { db.StudentMasters.Add(Obj_Student_Save); db.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static List <ClassMaster> GetClassDetails(string value)//get class detail method code { try { List <ClassMaster> Obj_Class_Detail = null; using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { Obj_Class_Detail = (from c in db.ClassMasters where c.ID.ToString() == value select c).ToList(); } return(Obj_Class_Detail ); } catch (Exception ex) { throw ex; } }
public static int UpdateCoordinator(ExhibitionCoordinatorMaster Obj_Coordinator_Update)//update method { try { using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { ExhibitionCoordinatorMaster c = db.ExhibitionCoordinatorMasters.SingleOrDefault(x => x.ID == Obj_Coordinator_Update.ID);//Lambda expression c.Name = Obj_Coordinator_Update.Name; db.SaveChanges(); return(Obj_Coordinator_Update.ID); } } catch (Exception ex) { throw ex; } }
public static List <ExhibitionCoordinatorMaster> GetCoordinatorDetails(string value) { try { List <ExhibitionCoordinatorMaster> Obj_Coordinator_Detail = null; using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { Obj_Coordinator_Detail = (from c in db.ExhibitionCoordinatorMasters where c.ID.ToString() == value select c).ToList(); } return(Obj_Coordinator_Detail ); } catch (Exception ex) { throw ex; } }
public static List <StudentMaster> GetStudentDetails(string value)//get student detail method { try { List <StudentMaster> Obj_Student_Detail = null; using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { Obj_Student_Detail = (from c in db.StudentMasters where c.ID.ToString() == value select c).ToList(); } return(Obj_Student_Detail ); } catch (Exception ex) { throw ex; } }
public static void DeleteClass(string Obj_Class_Delete)//delete class method { try { using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { ClassMaster c = db.ClassMasters.SingleOrDefault(x => x.ID.ToString().Trim() == Obj_Class_Delete.Trim());//Lambda expression if (c != null) { db.ClassMasters.Remove(c); db.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static int UpdateClass(ClassMaster Obj_Class_Update)//updte class method { try { using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { ClassMaster c = db.ClassMasters.SingleOrDefault(x => x.ID == Obj_Class_Update.ID);//Lambda expression c.ClassName = Obj_Class_Update.ClassName; c.NumberOfStudents = Obj_Class_Update.NumberOfStudents; c.Section = Obj_Class_Update.Section; db.SaveChanges(); return(Obj_Class_Update.ID); } } catch (Exception ex) { throw ex; } }
public static int UpdateStudent(StudentMaster Obj_Student_Update)//update method { try { using (SchoolExhibitionEntities db = new SchoolExhibitionEntities()) { //Lambda expression StudentMaster c = db.StudentMasters.SingleOrDefault(x => x.ID == Obj_Student_Update.ID); c.StudentName = Obj_Student_Update.StudentName; c.ExhibitionCoordinatorMasterID = Obj_Student_Update.ExhibitionCoordinatorMasterID; c.ClassMasterID = Obj_Student_Update.ClassMasterID; db.SaveChanges(); return(Obj_Student_Update.ID); } } catch (Exception ex) { throw ex; } }