IEnumerable <OnlinePortal.Models.Candidate> GetAllStudentsdetails() { using (OnlinePortal.Models.FacultyDBEntities1 db = new OnlinePortal.Models.FacultyDBEntities1()) { return(db.Candidates.ToList <OnlinePortal.Models.Candidate>()); } }
public ActionResult Upload(OnlinePortal.Models.Student employee) { using (OnlinePortal.Models.FacultyDBEntities1 entity = new OnlinePortal.Models.FacultyDBEntities1()) { var candidate = new Candidate() { EmailID = employee.EmailID, FirstName = employee.FirstName, LastName = employee.LastName, Prof_Id = employee.Prof_Id, Resume = SaveToPhysicalLocation(employee.LabFile), CreatedOn = DateTime.Now }; TempData.Add("MyTempData", employee.EmailID); entity.Candidates.Add(candidate); entity.SaveChanges(); if (candidate.Prof_Id != null) { return(RedirectToAction("Students")); } } return(View(employee)); }
public ActionResult Students() { string Email = TempData["MyTempData"].ToString(); OnlinePortal.Models.FacultyDBEntities1 entities = new OnlinePortal.Models.FacultyDBEntities1(); var detail = from students in entities.Candidates where students.EmailID == Email select students; return(View(detail)); }
public ActionResult AddOrEdit(int id = 0) { OnlinePortal.Models.Candidate emp = new OnlinePortal.Models.Candidate(); if (id != 0) { using (OnlinePortal.Models.FacultyDBEntities1 db = new OnlinePortal.Models.FacultyDBEntities1()) { emp = db.Candidates.Where(x => x.ID == id).FirstOrDefault <OnlinePortal.Models.Candidate>(); } } return(View(emp)); }
public ActionResult Delete(int id) { try { using (OnlinePortal.Models.FacultyDBEntities1 db = new OnlinePortal.Models.FacultyDBEntities1()) { OnlinePortal.Models.Candidate emp = db.Candidates.Where(x => x.ID == id).FirstOrDefault <OnlinePortal.Models.Candidate>(); db.Candidates.Remove(emp); db.SaveChanges(); } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllStudentsdetails()), message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetBlogDetailByCategoryID(int Prof_id) { var profId = Convert.ToString(Prof_id); OnlinePortal.Models.FacultyDBEntities1 db = new OnlinePortal.Models.FacultyDBEntities1(); List <OnlinePortal.Models.Candidate> blogs = new List <OnlinePortal.Models.Candidate>(); blogs = db.Candidates.Where(x => x.Prof_Id == profId).ToList(); var blog = (from candidates in db.Candidates where candidates.Prof_Id == profId select new Test { FirstName = candidates.FirstName, LastName = candidates.LastName, EmailID = candidates.EmailID, Resume = candidates.Resume, }).ToList(); return(Json(new { result = blog }, JsonRequestBehavior.AllowGet)); }
public ActionResult AddOrEdit(OnlinePortal.Models.Candidate emp) { try { using (OnlinePortal.Models.FacultyDBEntities1 db = new OnlinePortal.Models.FacultyDBEntities1()) { if (emp.ID == 0) { db.Candidates.Add(emp); db.SaveChanges(); } else { db.Entry(emp).State = EntityState.Modified; db.SaveChanges(); } } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllStudentsdetails()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }