public ActionResult SearchbyId(string Username)
{
using (Training_20Feb_MumbaiEntity db = new Training_20Feb_MumbaiEntity())
{
return(View(db.Student_174852.Where(x => x.Username == Username).ToList()));
}
}
public ActionResult Search(string Description)
{
using (Training_20Feb_MumbaiEntity db = new Training_20Feb_MumbaiEntity())
{
return(View(db.Homework_174852.Where(x => x.Description == Description).ToList()));
}
}
public ActionResult Login(Teachers_174852 user)
{
using (Training_20Feb_MumbaiEntity db = new Training_20Feb_MumbaiEntity())
{
var usr = db.Teachers_174852.Where(u => u.Username == user.Username && u.Password == user.Password).FirstOrDefault();
if (usr != null)
{
Session["TeacherId"] = usr.TeacherId.ToString();
Session["Username"] = usr.Username.ToString();
Session["Admin"] = usr.IsAdmin.ToLower();
if (usr != null && usr.IsAdmin.ToLower() == "true")
{
return(RedirectToAction("Index", "Admi1"));
}
else if (usr != null && usr.IsAdmin.ToLower() == "false")
{
return(RedirectToAction("Index"));
}
else
{
Session.Clear();
ModelState.AddModelError("", "Username or Password is wrong.");
}
}
else
{
ModelState.AddModelError("", "Username or Password is wrong.");
}
}
return(View());
}
public ActionResult SearchbyId(string CourseName)
{
using (Training_20Feb_MumbaiEntity db = new Training_20Feb_MumbaiEntity())
{
return(View(db.Courses_174852.Where(x => x.CourseName == CourseName || CourseName == null).ToList()));
}
}
// GET: Student
public ActionResult Index()
{
if (Session["StudentId"] != null)
{
using (Training_20Feb_MumbaiEntity db = new Training_20Feb_MumbaiEntity())
{
return(View(db.Student_174852.ToList()));
}
}
else
{
return(RedirectToAction("Login"));
}
}
public ActionResult SearchC(string CourseName)
{
if (Session["TeacherId"] != null)
{
using (Training_20Feb_MumbaiEntity db = new Training_20Feb_MumbaiEntity())
{
return(View(db.Courses_174852.Where(x => x.CourseName == CourseName).ToList()));
}
}
else
{
return(RedirectToAction("Login", "Admin"));
}
}
public ActionResult Login(Student_174852 user)
{
using (Training_20Feb_MumbaiEntity db = new Training_20Feb_MumbaiEntity())
{
var usr = db.Student_174852.Where(u => u.Username == user.Username && u.Password == user.Password).FirstOrDefault();
if (usr != null)
{
Session["StudentId"] = usr.StudentId.ToString();
Session["Username"] = usr.Username.ToString();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Username or Password is wrong.");
}
}
return(View());
}
public ActionResult Register(Student_174852 stud)
{
if (stud == null)
{
ViewBag.Message = "Please Enter Data";
}
if (ModelState.IsValid)
{
using (Training_20Feb_MumbaiEntity db = new Training_20Feb_MumbaiEntity())
{
db.Student_174852.Add(stud);
db.SaveChanges();
ViewBag.Message = "Successfully Registered.";
}
ModelState.Clear();
ViewBag.Message = stud.FName + " " + stud.LName + "successfully registered";
}
return(View());
}
public ActionResult Register(Teachers_174852 teach)
{
if (ModelState.IsValid)
{
try
{
Training_20Feb_MumbaiEntity db = new Training_20Feb_MumbaiEntity();
db.Teachers_174852.Add(teach);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = teach.FirstName + " " + teach.LastName + "successfully registered";
return(RedirectToAction("Login"));
}
catch (Exception ex)
{
return(View(teach));
}
}
return(View());
}
