//Show trainee account
public ActionResult TraineeAccount()
{
QLDaiHocEntities1 db = new QLDaiHocEntities1();
List <User_Account> acc1 = db.User_Account.Where(a => a.Position == "trainee").ToList();
return(View(acc1));
}
// View Topic
public ActionResult TopicMana()
{
QLDaiHocEntities1 db = new QLDaiHocEntities1();
List <Topic> topic = db.Topic.ToList();
return(View(topic));
}
public ActionResult EditCategory(string id)
{
QLDaiHocEntities1 db = new QLDaiHocEntities1();
var cate = db.Category_Course.FirstOrDefault(x => x.CategoryID == id);
return(View(cate));
}
//CRUD View Course
public ActionResult CourseMana()
{
QLDaiHocEntities1 db = new QLDaiHocEntities1();
List <Course> course = db.Course.ToList();
return(View(course));
}
// GET: StaffPage
public ActionResult StaffMana()
{
QLDaiHocEntities1 db = new QLDaiHocEntities1();
List <Category_Course> course = db.Category_Course.ToList();
return(View(course));
}
public ActionResult EditAccount(string id)
{
QLDaiHocEntities1 db = new QLDaiHocEntities1();
var acc = db.User_Account.FirstOrDefault(x => x.UserID == id);
return(View(acc));
}
public ActionResult EditPro(string id)
{
QLDaiHocEntities1 db = new QLDaiHocEntities1();
var pro = db.Profile_User.FirstOrDefault(x => x.UserID == id);
return(View(pro));
}
// GET: Admin
public ActionResult Staff()
{
QLDaiHocEntities1 db = new QLDaiHocEntities1();
var acc = db.User_Account.Where(a => a.Position == "trainer" | a.Position == "staff");
List <User_Account> staff = acc.ToList();
return(View(staff));
}
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(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 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();
}
//CRUD View category
public ActionResult AddCourse()
{
Course us = new Course();
using (QLDaiHocEntities1 db = new QLDaiHocEntities1())
{
us.IdCollection2 = db.User_Account.Where(a => a.Position == "trainee").ToList();
us.cateCollection = db.Category_Course.ToList();
}
return(View(us));
}
//Add / edit / delete
public ActionResult AddPro()
{
Profile_User us = new Profile_User();
using (QLDaiHocEntities1 db = new QLDaiHocEntities1())
{
us.IdCollection = db.User_Account.Where(a => a.Position == "trainer" | a.Position == "trainer").ToList();
}
return(View(us));
}
///CRUD View Topic
public ActionResult AddTopic()
{
Topic to = new Topic();
using (QLDaiHocEntities1 db = new QLDaiHocEntities1())
{
to.IdCollection3 = db.User_Account.Where(a => a.Position == "trainer").ToList();
to.coCollection = db.Course.ToList();
}
return(View(to));
}
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 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 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 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 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 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"));
}
//check value exits
public JsonResult CheckValue(string check)
{
System.Threading.Thread.Sleep(200);
QLDaiHocEntities1 db = new QLDaiHocEntities1();
var searchID = db.User_Account.Where(x => x.UserID == check).SingleOrDefault();
if (searchID != null)
{
return(Json(1));
}
else
{
return(Json(0));
}
}
public JsonResult CheckName(string username)
{
System.Threading.Thread.Sleep(500);
QLDaiHocEntities1 db = new QLDaiHocEntities1();
var searchName = db.User_Account.Where(x => x.UserName == username).SingleOrDefault();
if (searchName != null)
{
return(Json(1));
}
else
{
return(Json(0));
}
}
public JsonResult CheckPhone(string phone)
{
System.Threading.Thread.Sleep(500);
QLDaiHocEntities1 db = new QLDaiHocEntities1();
var searchPhone = db.Profile_User.Where(x => x.Phone == phone).SingleOrDefault();
if (searchPhone != null)
{
return(Json(1));
}
else
{
return(Json(0));
}
}
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 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 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());
}
//CRUD View Profile trainer
//View
public ActionResult ProTrainer()
{
QLDaiHocEntities1 db = new QLDaiHocEntities1();
List <Profile_User> pro = db.Profile_User.ToList();
List <User_Account> us = db.User_Account.ToList();
var ma = from b in us
join c in pro
on b.UserID equals c.UserID
where b.Position == "trainer" && b.Position == "trainee"
select new Profile_User()
{
UserID = c.UserID,
Full_Name = c.Full_Name,
Address = c.Address,
Phone = c.Phone,
DateOfBirth = c.DateOfBirth,
};
return(View(ma));
}
public ActionResult Login(User_Account lg)
{
if (ModelState.IsValid)
{
using (QLDaiHocEntities1 ue = new QLDaiHocEntities1())
{
var log = ue.User_Account.Where(a => a.UserName.Equals(lg.UserName) && a.Password.Equals(lg.Password)).FirstOrDefault();
if (log != null)
{
Session["username"] = log.UserName;
if (log.Position == "admin")
{
return(RedirectToAction("UserHome", "Home"));
}
if (log.Position == "staff")
{
return(RedirectToAction("TraineeAccount", "StaffPage"));
}
if (log.Position == "trainer")
{
Session["id"] = ue.Profile_User.Where(a => a.UserID.Equals(log.UserID));
return(RedirectToAction("ProfileTrainer", "Trainer"));
}
//if (log.Position == "trainee")
//{
// return RedirectToAction("StaffMana", "StaffPage");
//}
}
else
{
Response.Write("<script>alert('sai mat khau')</script>");
}
}
}
return(View());
}
