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