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