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 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 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 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 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; } }