public static bool Create(Student_Course source) { using (KeunhongInstituteDBEntities dbContext = new KeunhongInstituteDBEntities()) { try { Student_Course sc = new Student_Course(); sc.CourseSchedule_ID = source.CourseSchedule_ID; sc.CreatedBy = source.CreatedBy; sc.CreatedDateTime = DateTime.Now; sc.IsActive = true; sc.ModifiedBy = source.ModifiedBy; sc.ModifiedDateTime = DateTime.Now; sc.User_ID = source.User_ID; sc.Grade = source.Grade; dbContext.Student_Course.Add(sc); dbContext.SaveChanges(); } catch (Exception) { return(false); } } return(true); }
public static bool Create(Course_Schedule source) { using (KeunhongInstituteDBEntities dbContext = new KeunhongInstituteDBEntities()) { try { Course_Schedule schedule = new Course_Schedule(); schedule.Course_ID = source.Course_ID; schedule.CreatedBy = source.CreatedBy; schedule.CreatedDateTime = DateTime.Now; schedule.DT_From = source.DT_From; schedule.DT_To = source.DT_To; schedule.IsActive = true; schedule.ModifiedBy = source.ModifiedBy; schedule.ModifiedDateTime = DateTime.Now; schedule.Teacher_ID = source.Teacher_ID; dbContext.Course_Schedule.Add(schedule); dbContext.SaveChanges(); } catch (Exception) { return(false); } } return(true); }
public static bool Create(Course source) { using (KeunhongInstituteDBEntities dbContext = new KeunhongInstituteDBEntities()) { try { Course course = new Course(); course.Course_Code = source.Course_Code; course.Course_Description = source.Course_Description; course.Course_Name = source.Course_Name; course.CreatedBy = source.CreatedBy; course.CreatedDateTime = DateTime.Now; course.Faculty_ID = source.Faculty_ID; course.IsActive = true; course.ModifiedBy = source.ModifiedBy; course.ModifiedDateTime = DateTime.Now; dbContext.Courses.Add(course); dbContext.SaveChanges(); } catch (Exception) { return(false); } } return(true); }
public static User_Role Create(User_Role source) { using (KeunhongInstituteDBEntities dbContext = new KeunhongInstituteDBEntities()) { User_Role ur = new User_Role(); try { ur.CreatedBy = source.CreatedBy; ur.CreatedDateTime = DateTime.Now; ur.IsActive = true; ur.ModifiedBy = source.ModifiedBy; ur.ModifiedDateTime = DateTime.Now; ur.Role_ID = source.Role_ID; ur.User_ID = source.User_ID; dbContext.User_Role.Add(ur); dbContext.SaveChanges(); } catch (Exception) { return(null); } return(ur); } }
public static User Create(User source) { using (KeunhongInstituteDBEntities dbContext = new KeunhongInstituteDBEntities()) { //Create instance of new user and set values from source User user = new User(); try { user.Address = source.Address; user.ContactNumber = source.ContactNumber; user.CreatedBy = source.CreatedBy; user.CreatedDateTime = DateTime.Now; user.DateOfBirth = source.DateOfBirth; user.Email = source.Email; user.FirstName = source.FirstName; user.FullName = source.FullName; user.IsActive = true; user.LastName = source.LastName; user.ModifiedBy = source.ModifiedBy; user.ModifiedDateTime = DateTime.Now; user.Password = source.Password; user.Student_ID = source.Student_ID; //Add the new user to DB and apply change dbContext.Users.Add(user); dbContext.SaveChanges(); } catch (Exception) { return(null); } return(user); } }
public static void Delete(User user) { using (KeunhongInstituteDBEntities dbContext = new KeunhongInstituteDBEntities()) { dbContext.Users.Remove(user); dbContext.SaveChanges(); } }
public static void Update <T>(T target, params Expression <Func <T, object> >[] propertiesToUpdate) where T : class { using (KeunhongInstituteDBEntities dbContext = new KeunhongInstituteDBEntities()) { try { dbContext.Set <T>().Attach(target); //Flag the properties for updating foreach (var p in propertiesToUpdate) { dbContext.Entry(target).Property(p).IsModified = true; } dbContext.Entry(target).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } catch (Exception e) { throw e; } } }
public static Faculty Create(Faculty source) { using (KeunhongInstituteDBEntities dbContext = new KeunhongInstituteDBEntities()) { Faculty faculty = new Faculty(); try { faculty.CreatedBy = source.CreatedBy; faculty.CreatedDateTime = DateTime.Now; faculty.Faculty_Name = source.Faculty_Name; faculty.IsActive = true; faculty.ModifiedBy = source.ModifiedBy; faculty.ModifiedDateTime = DateTime.Now; dbContext.Faculties.Add(faculty); dbContext.SaveChanges(); } catch (Exception) { return(null); } return(faculty); } }