private void Delete(string id) { QLDaiHocEntities1 db = new QLDaiHocEntities1(); var acc = db.User_Account.FirstOrDefault(x => x.UserID == id); db.User_Account.Remove(acc); db.SaveChanges(); }
private void DeleteProfile(string id) { QLDaiHocEntities1 db = new QLDaiHocEntities1(); var pro = db.Profile_User.FirstOrDefault(x => x.UserID == id); db.Profile_User.Remove(pro); db.SaveChanges(); }
private void Delete_Topic(string id) { QLDaiHocEntities1 db = new QLDaiHocEntities1(); var co = db.Topic.FirstOrDefault(x => x.CourseID == id); db.Topic.Remove(co); db.SaveChanges(); }
private void Delete(string id) { QLDaiHocEntities1 db = new QLDaiHocEntities1(); var cate = db.Category_Course.FirstOrDefault(x => x.CategoryID == id); db.Category_Course.Remove(cate); db.SaveChanges(); }
public ActionResult EditCategory(Category_Course cate) { QLDaiHocEntities1 db = new QLDaiHocEntities1(); Category_Course category = new Category_Course(); category.CategoryID = cate.CategoryID; category.Category_Name = cate.Category_Name; category.Description = cate.Description; db.Entry(category).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("StaffMana", "StaffPage")); }
public ActionResult EditAccount(User_Account acc) { QLDaiHocEntities1 db = new QLDaiHocEntities1(); User_Account us = new User_Account(); us.UserID = acc.UserID; us.UserName = acc.UserName; us.Password = acc.Password; us.Position = acc.Position; db.Entry(us).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Staff", "Admin")); }
public ActionResult AddTopic(Topic topic) { using (QLDaiHocEntities1 db = new QLDaiHocEntities1()) { if (ModelState.IsValid) { db.Topic.Add(topic); db.SaveChanges(); return(RedirectToAction("TopicMana", "StaffPage")); } } return(View()); }
public ActionResult AddCourse(Course course) { using (QLDaiHocEntities1 db = new QLDaiHocEntities1()) { if (ModelState.IsValid) { db.Course.Add(course); db.SaveChanges(); return(RedirectToAction("CourseMana", "StaffPage")); } } return(View()); }
public ActionResult EditTopic(Topic to) { QLDaiHocEntities1 db = new QLDaiHocEntities1(); Topic topic = new Topic(); topic.TopicID = to.TopicID; topic.Topic_Name = to.Topic_Name; topic.Description = to.Description; topic.CourseID = to.CourseID; topic.UserID = to.UserID; db.Entry(topic).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("TopicMana", "StaffPage")); }
public ActionResult EditCourse(Course co) { QLDaiHocEntities1 db = new QLDaiHocEntities1(); Course course = new Course(); course.CourseID = co.CourseID; course.Course_Name = co.Course_Name; course.Description = co.Description; course.CategoryID = co.CategoryID; course.UserID = co.UserID; db.Entry(course).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("CourseMana", "StaffPage")); }
public ActionResult EditPro(Profile_User pro) { QLDaiHocEntities1 db = new QLDaiHocEntities1(); Profile_User prous = new Profile_User(); prous.UserID = pro.UserID; prous.Full_Name = pro.Full_Name; prous.Address = pro.Address; prous.Phone = pro.Phone; prous.DateOfBirth = pro.DateOfBirth; db.Entry(prous).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ProTrainer", "StaffPage")); }
public ActionResult AddAccountTrainee(User_Account acc) { using (QLDaiHocEntities1 db = new QLDaiHocEntities1()) { if (ModelState.IsValid) { db.User_Account.Add(acc); if (acc.Position == "trainee") { db.SaveChanges(); } return(RedirectToAction("TraineeAccount", "StaffPage")); } } return(View()); }
public ActionResult AddPro(Profile_User pro) { using (QLDaiHocEntities1 db = new QLDaiHocEntities1()) { if (ModelState.IsValid) { db.Profile_User.Add(pro); db.SaveChanges(); return(RedirectToAction("ProTrainer", "StaffPage")); } else { return(RedirectToAction("ProTrainer", "StaffPage")); } } }
public ActionResult AddAccount(User_Account acc) { using (QLDaiHocEntities1 db = new QLDaiHocEntities1()) { if (ModelState.IsValid) { db.User_Account.Add(acc); if (acc.Position == "trainer" | acc.Position == "staff") { db.SaveChanges(); } else { return(RedirectToAction("Staff", "Admin")); } return(RedirectToAction("Staff", "Admin")); } } return(View()); }