//Retrieves all student details
// GET: Student
public ActionResult Index()
{
StudentDBHandle dbHandle = new StudentDBHandle();
ModelState.Clear();
return(View(dbHandle.GetStudent()));
}
public IHttpActionResult Index()
{
StudentDBHandle dbhandle = new StudentDBHandle();
var students = dbhandle.GetStudent();
return(Ok(students));
}
// UPDATE (load base view)
// GET: /Student/Edit/5
public ActionResult Edit(int id)
{
ViewBag.Title = "Edit Student detail";
StudentDBHandle dbhandle = new StudentDBHandle();
return(View(dbhandle.ReadStudent().Find(smodel => smodel.Id == id)));
}
// GET: Student
public ActionResult Index(string search, string option)
{
StudentDBHandle dbhandle = new StudentDBHandle();
ModelState.Clear();
List <StudentModel> ll = new List <StudentModel>();
ll = dbhandle.GetStudent();
if (option == "Name")
{
List <StudentModel> ss = ll.Where(x => x.Name == search).ToList();
return(View(ss));
}
else if (option == "City")
{
return(View(ll.Where(x => x.City == search).ToList()));
}
else if (option == "Address")
{
return(View(ll.Where(x => x.Address == search).ToList()));
}
else
{
return(View(ll));
}
}
public ActionResult Create(StudentModel smodel)
{
try
{
//if (ModelState.IsValid)
//{
StudentDBHandle sdb = new StudentDBHandle();
if (smodel.Id > 0)
{
sdb.UpdateDetails(smodel);
return(RedirectToAction("Index"));
//if (sdb.UpdateDetails(smodel))
//{
// ViewBag.Message = "Student Details Updated Successfully";
// ModelState.Clear();
//}
}
else
{
if (sdb.AddStudent(smodel))
{
// ViewBag.Message = "Student Details Added Successfully";
return(RedirectToAction("Index"));
// ModelState.Clear();
}
}
//}
return(View());
}
catch
{
return(View());
}
}
// READ ALL
// GET: /Student/
public ActionResult Index()
{
ViewBag.Title = "Create <new Student> | edit | view detail | delete <Student>";
StudentDBHandle dbhandle = new StudentDBHandle();
ModelState.Clear();
return(View(dbhandle.ReadStudent()));
}
// 3. ************* EDIT STUDENT DETAILS ******************
// GET: Student/Edit/5
public ActionResult Edit(int id)
{
StudentDBHandle sdb = new StudentDBHandle();
var dd = sdb.GetStudent().Find(smodel => smodel.Id == id);
return(View());
// return View(sdb.GetStudent().Find(smodel => smodel.Id == id));
}
public JsonResult GetStudents()
{
// simulate delay
Thread.Sleep(1500);
StudentDBHandle dbhandle = new StudentDBHandle();
ModelState.Clear();
return(Json(dbhandle.GetStudent(), JsonRequestBehavior.AllowGet));
}
// GET: Student/Details/5
public ActionResult Details(int id)
{
StudentDBHandle dbhandle = new StudentDBHandle();
Student student = dbhandle.GetStudentDetails(id);
ViewBag.Title = student.FirstName + " " + student.LastName;
ModelState.Clear();
return(View(dbhandle.GetStudentClassDetails(id)));
}
// 2. *************ADD NEW STUDENT ******************
// GET: Student/Create
public ActionResult Create(int?id)
{
StudentDBHandle sdb = new StudentDBHandle();
var dd = sdb.GetStudent().Find(smodel => smodel.Id == id);
//dd.IsMovie = (dd.IsMovie == false) ? false : dd.IsMovie;
//dd.IsCricket = (dd.IsCricket == false) ? false : dd.IsCricket;
var genList = sdb.GenList().ToList();
ViewBag.GenList = new SelectList(genList, "Id", "Name");
return(View(dd));
// return View(sdb.GetStudent().Find(smodel => smodel.Id == id));
}
public ActionResult Edit(int id, Student student)
{
try
{
StudentDBHandle dbhandle = new StudentDBHandle();
dbhandle.UpdateDetails(student);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// POST: Student/Edit/5
// [HttpPost]
public ActionResult Eite(StudentModel smodel)
{
try
{
StudentDBHandle sdb = new StudentDBHandle();
sdb.UpdateDetails(smodel);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, StudentModel student)
{
try
{
// TODO: Add update logic here
StudentDBHandle dBHandle = new StudentDBHandle();
dBHandle.UpdateDetails(student);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Profile()
{
if (Session["Student"] == null)
{
return(RedirectToAction("login", "Home", new { area = "" }));
}
StudentDBHandle sadb = new StudentDBHandle();
int userid = Convert.ToInt32((Session["Student"]));
var sab = db.Students.Find(userid);
Session["imgPath"] = sab.ImagePath;
tbl_StudentValidation sa = sadb.GetProfileData(userid);
return(View(sa));
}
// 4. ************* DELETE STUDENT DETAILS ******************
// GET: Student/Delete/5
public ActionResult Delete(int id)
{
try
{
StudentDBHandle dBHandle = new StudentDBHandle();
if (dBHandle.DeleteStudents(id))
{
ViewBag.AlertMsg = "Estudiante eliminado exitosamente";
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// 4. ************* DELETE STUDENT DETAILS ******************
// GET: Student/Delete/5
public ActionResult Delete(int id)
{
try
{
StudentDBHandle sdb = new StudentDBHandle();
if (sdb.DeleteStudent(id))
{
ViewBag.AlertMsg = "Student Deleted Successfully";
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public IHttpActionResult Delete(int id)
{
try
{
StudentDBHandle sdb = new StudentDBHandle();
if (sdb.DeleteStudent(id))
{
return(Ok("Student Record Deleted Successfully"));
}
return(NotFound());
}
catch
{
return(BadRequest());
}
}
// GET: Student/Delete/5
public ActionResult Delete(int id)
{
try
{
// TODO: Add delete logic here
StudentDBHandle dBHandle = new StudentDBHandle();
if (dBHandle.DeleteStudent(id))
{
ViewBag.AlertMsg = "STUDENT REMOVE SUCCESSFULLY.";
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public IHttpActionResult Edit([FromUri] int id, [FromBody] StudentModel smodel)
{
try
{
StudentDBHandle sdb = new StudentDBHandle();
smodel.Id = id;
if (sdb.UpdateDetails(smodel))
{
return(Ok("Student Details Updated Successfully"));
}
return(NotFound());
}
catch
{
return(BadRequest());
}
}
public ActionResult ProfileSetting()
{
if (Session["Student"] == null)
{
return(RedirectToAction("Login", "Account", new { area = "" }));
}
StudentDBHandle sadb = new StudentDBHandle();
int userid = Convert.ToInt32((Session["Student"]));
var sab = db.Students.Find(userid);
Session["imgPath"] = sab.ImagePath;
Session["DateCreated"] = sab.RegisterationDate;
Session["Address"] = sab.Address;
tbl_StudentValidation sa = sadb.GetProfileData(userid);
return(View(sa));
}
public IHttpActionResult Create(StudentModel smodel)
{
try
{
if (ModelState.IsValid)
{
StudentDBHandle sdb = new StudentDBHandle();
if (sdb.AddStudent(smodel))
{
return(Ok("Student Details Added Successfully"));
}
}
return(BadRequest(ModelState));
}
catch
{
return(InternalServerError());
}
}
public ActionResult Create(StudentModel smodel)
{
try
{
if (ModelState.IsValid)
{
StudentDBHandle sdb = new StudentDBHandle();
if (sdb.AddStudent(smodel))
{
ViewBag.Message = "Student Details Added Successfully";
ModelState.Clear();
}
}
return(View());
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, StudentModel smodel)
{
try
{
if (ModelState.IsValid)
{
StudentDBHandle dbhandle = new StudentDBHandle();
if (dbhandle.UpdateStudent(smodel))
{
ViewBag.Message = "Student details updated Successfully";
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(StudentModel oStudentModel)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
StudentDBHandle oStudent = new StudentDBHandle();
if (oStudent.AddStudent(oStudentModel))
{
ViewBag.Message = "Estudiante agregado exitosamente";
ModelState.Clear();
}
}
return(View());
}
catch
{
return(View());
}
}
public ActionResult Create(Student student)
{
try
{
if (ModelState.IsValid)
{
StudentDBHandle dbhandle = new StudentDBHandle();
if (dbhandle.AddStudent(student))
{
ViewBag.Message = "Student Added Successfully";
ModelState.Clear();
}
}
return(View());
}
catch (Exception e)
{
ViewBag.Message = e.ToString();
return(View());
}
}
public ActionResult Delete(int id, StudentModel smodel)
{
try
{
//* No ModelState.IsValid check is required (returns false)
//if (ModelState.IsValid)
//{
StudentDBHandle dbhandle = new StudentDBHandle();
if (dbhandle.DeletStudent(smodel))
{
ViewBag.Message = "Student detail is deleted successfully";
}
//}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(StudentModel smodel)
{
try
{
if (ModelState.IsValid)
{
StudentDBHandle dbhandle = new StudentDBHandle();
if (dbhandle.CreateStudent(smodel))
{
ViewBag.Message = "Student detail created successfully.";
ModelState.Clear();
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(StudentModel student)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
StudentDBHandle dBHandle = new StudentDBHandle();
if (dBHandle.AddStudent(student))
{
ViewBag.Message = "STUDENT DETAILS ADDED SUCCESSFULLY.";
ModelState.Clear();
}
}
return(View());
}
catch
{
return(View());
}
}
public ActionResult Enrollment()
{
if (Session["school"] == null)
{
return(RedirectToAction("Login", "Account", new { area = "" }));
}
//ViewBag.CourseId = new SelectList(db.Courses, "courseId", "Code");
//ViewBag.StudentList = db.Students.ToList();
int schoolid = Convert.ToInt32(Session["school"]);
int RoleID = 2;
StudentDBHandle gc = new StudentDBHandle();
List <tbl_StudentValidation> list = gc.GetSchoolStudent(schoolid);
ViewData["student_name"] = new SelectList(list, "RegNo", "RegNo");
CourseDBHandle gc1 = new CourseDBHandle();
List <tbl_OnlineTestValidation> courselist = gc1.GetSchoolCourse(schoolid, RoleID);
ViewData["course_name"] = new SelectList(courselist, "courseId", "courseName");
return(View());
}
// 1. *************RETRIEVE ALL STUDENT DETAILS ******************
// GET: Student
public ActionResult Index(string SortOrder, string SortBy)
{
ViewBag.SortOrder = SortOrder;
StudentDBHandle dbhandle = new StudentDBHandle();
var dd = dbhandle.GetStudent().ToList();
switch (SortBy)
{
case "Name":
{
switch (SortOrder)
{
case "Asc":
{
dd = dd.OrderBy(x => x.Name).ToList();
break;
}
case "Desc":
{
dd = dd.OrderByDescending(x => x.Name).ToList();
break;
}
default:
{
dd = dd.OrderBy(x => x.Name).ToList();
break;
}
}
break;
}
case "City":
{
switch (SortOrder)
{
case "Asc":
{
dd = dd.OrderBy(x => x.City).ToList();
break;
}
case "Desc":
{
dd = dd.OrderByDescending(x => x.City).ToList();
break;
}
default:
{
dd = dd.OrderBy(x => x.City).ToList();
break;
}
}
break;
}
case "DOB":
{
switch (SortOrder)
{
case "Asc":
{
dd = dd.OrderBy(x => x.DOB).ToList();
break;
}
case "Desc":
{
dd = dd.OrderByDescending(x => x.DOB).ToList();
break;
}
default:
{
dd = dd.OrderBy(x => x.DOB).ToList();
break;
}
}
break;
}
default:
{
dd = dd.OrderBy(x => x.Name).ToList();
break;
}
}
ModelState.Clear();
return(View(dd));
}
