public ActionResult Login(string User, string Pass)
{
try
{
using (challengeContext db = new challengeContext())
{
var oUser = (from d in db.Users
where d.Email_User == User.Trim() && d.Pass == Pass.Trim()
select d).FirstOrDefault();
if (oUser == null)
{
ViewBag.Error = "User or pass incorrects";
return(View());
}
Session["User"] = oUser;
}
return(RedirectToAction("Index", "Home"));
}
catch (Exception ex)
{
ViewBag.Error = ex.Message;
return(View());
}
}
public ActionResult Edit_Subject(Subject s)
{
if (!ModelState.IsValid)
{
return(View());
}
try
{
using (var db = new challengeContext())
{
Subject subj = db.Subjects.Find(s.Id_Subject);
subj.Name_Subject = s.Name_Subject;
subj.DNI_Teacher = s.DNI_Teacher;
subj.Schedule_From = s.Schedule_From;
subj.Schedule_To = s.Schedule_To;
subj.Quota = s.Quota;
db.SaveChanges();
return(RedirectToAction("Index_Subject"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error when the Subject is input", ex);
return(View());
}
}
public ActionResult List_Teacher()
{
using (var db = new challengeContext())
{
return(PartialView(db.Teachers.ToList()));
}
}
public ActionResult Create_Subject()
{
List <Models.Teacher_List> lst = null;
using (Models.challengeContext db = new challengeContext())
{
lst =
(from d in db.Teachers
select new Teacher_List
{
dNI = d.DNI,
name = d.Name + " " + d.Surname
}).ToList();
}
List <SelectListItem> ites = lst.ConvertAll(d =>
{
return(new SelectListItem()
{
Text = d.name.ToString(),
Value = d.dNI.ToString(),
Selected = false
});
});
ViewBag.ites = ites;
return(View());
}
public ActionResult Details_Teacher(int id)
{
using (var db = new challengeContext())
{
Teacher teach = db.Teachers.Where(a => a.DNI == id).FirstOrDefault();
return(View(teach));
}
}
public ActionResult Edit_Subject(int id)
{
using (var db = new challengeContext())
{
Subject sub = db.Subjects.Where(a => a.Id_Subject == id).FirstOrDefault();
return(View(sub));
}
}
public ActionResult Delete_Teacher(int id)
{
using (var db = new challengeContext())
{
Teacher teach = db.Teachers.Where(a => a.DNI == id).FirstOrDefault();
db.Teachers.Remove(teach);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Delete_Subject(int id)
{
using (var db = new challengeContext())
{
Subject sub = db.Subjects.Where(a => a.Id_Subject == id).FirstOrDefault();
db.Subjects.Remove(sub);
db.SaveChanges();
return(RedirectToAction("Index_Subject"));
}
}
public ActionResult Details_InsSubject(int id)
{
using (var db = new challengeContext())
{
Subject subj = db.Subjects.Where(a => a.Id_Subject == id).FirstOrDefault();
var teach = subj.DNI_Teacher;
var tea = db.Teachers.Where(b => b.DNI == teach).Select(t => t.Surname).FirstOrDefault();
var tea0 = db.Teachers.Where(b => b.DNI == teach).Select(t => t.Name).FirstOrDefault();
ViewBag.Teache = tea0 + " " + tea;
return(View(subj));
}
}
public ActionResult Edit_Teacher(Teacher T)
{
try
{
using (var db = new challengeContext())
{
Teacher teach = db.Teachers.Find(T.DNI);
teach.Name = T.Name;
teach.Surname = T.Surname;
teach.Status = T.Status;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error when the Teacher is input", ex);
return(View());
}
}
public ActionResult Create_Teacher(Teacher T)
{
if (!ModelState.IsValid)
{
return(View());
}
try
{
using (challengeContext db = new challengeContext())
{
db.Teachers.Add(T);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error when the Teacher is input", ex);
return(View());
}
}
public ActionResult Create_Inscription(Inscription I)
{
if (!ModelState.IsValid)
{
return(View());
}
try
{
using (challengeContext db = new challengeContext())
{
db.Inscriptions.Add(I);
var id = I.Id_Subject;
Subject sub = db.Subjects.Where(a => a.Id_Subject == id).FirstOrDefault();
sub.Quota = sub.Quota - 1;
db.SaveChanges();
return(RedirectToAction("Index_Inscriptions"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error when the Teacher is input", ex);
return(View());
}
}
public UserChallengeRepository(challengeContext context) : base(context)
{
}
public ActionResult Index_Inscriptions()
{
challengeContext db = new challengeContext();
return(View(db.Subjects.ToList()));
}
public ActionResult Index()
{
challengeContext db = new challengeContext();
return(View(db.Teachers.ToList()));
}
public SubcategoryRepository(challengeContext context) : base(context)
{
}
