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));
}
}
