public void Destroy(CoursesViewModel db) { var entity = new Courses_Table(); entity.CoursesID = db.CoursesID; entities.Courses_Table.Attach(entity); entities.Courses_Table.Remove(entity); entities.SaveChanges(); }
public void Create(CoursesViewModel db) { var entity = new Courses_Table(); entity.CoursesNumber = db.CoursesNumber; entity.CoursesStartDate = (DateTime)db.CoursesStartDate.Date; entity.CoursesEndDate = (DateTime)db.CoursesEndDate.Date; entity.CoursesSummary = HttpUtility.HtmlDecode(db.CoursesSummary); entity.UserID = db.UserID; entities.Courses_Table.Add(entity); entities.SaveChanges(); db.CoursesID = entity.CoursesID; }
public void Update(CoursesViewModel db) { var entity = new Courses_Table(); entity.CoursesID = db.CoursesID; entity.CoursesNumber = db.CoursesNumber; entity.CoursesStartDate = (DateTime)db.CoursesStartDate.Date; entity.CoursesEndDate = (DateTime)db.CoursesEndDate.Date; entity.UserID = db.UserID; entities.Courses_Table.Attach(entity); entities.Entry(entity).State = EntityState.Modified; entities.SaveChanges(); }
public void Create(CoursesViewModel db) { var entity = new Courses_Table(); entity.CoursesName = db.CoursesName; entity.CoursesStartDate = (DateTime)db.CoursesStartDate.Date; entity.CoursesEndDate = (DateTime)db.CoursesEndDate.Date; entity.TotalBeneficiaries = db.TotalBeneficiaries; entity.TrainingHours = db.TrainingHours; entity.TotalSessions = db.TotalSessions; entity.Males = db.Males; entity.Females = db.Females; entity.UserID = db.UserID; entity.TargetGroupID = db.TargetGroupID; entity.ProjectID = db.ProjectID; entities.Courses_Table.Add(entity); entities.SaveChanges(); db.CoursesID = entity.CoursesID; }