IEnumerable <Employee> GetAllEmployee() { using (MvcProject_Raihan01Entities db = new MvcProject_Raihan01Entities()) { return(db.Employees.ToList <Employee>()); } }
public ActionResult AddOrEdit(Employee emp) { try { if (emp.ImageUpload != null) { string fileName = Path.GetFileNameWithoutExtension(emp.ImageUpload.FileName); string extension = Path.GetExtension(emp.ImageUpload.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; emp.ImagePath = "~/AppFiles/Images/" + fileName; emp.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName)); } using (MvcProject_Raihan01Entities db = new MvcProject_Raihan01Entities()) { if (emp.EmployeeID == 0) { db.Employees.Add(emp); db.SaveChanges(); } else { db.Entry(emp).State = EntityState.Modified; db.SaveChanges(); } } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetData() { using (MvcProject_Raihan01Entities db = new MvcProject_Raihan01Entities()) { List <Auther> authertList = db.Authers.ToList <Auther>(); return(Json(new { data = authertList }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { using (MvcProject_Raihan01Entities db = new MvcProject_Raihan01Entities()) { Auther emp = db.Authers.Where(x => x.AutherID == id).FirstOrDefault <Auther>(); db.Authers.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully", JsonRequestBehavior.AllowGet })); } }
public ActionResult AddOrEdit(int id = 0) { Employee emp = new Employee(); if (id != 0) { using (MvcProject_Raihan01Entities db = new MvcProject_Raihan01Entities()) { emp = db.Employees.Where(x => x.EmployeeID == id).FirstOrDefault <Employee>(); } } return(View(emp)); }
public ActionResult StoreOrEdit(int id = 0) { if (id == 0) { return(View(new Auther())); } else { using (MvcProject_Raihan01Entities db = new MvcProject_Raihan01Entities()) { return(View(db.Authers.Where(x => x.AutherID == id).FirstOrDefault <Auther>())); } } }
public ActionResult Delete(int id) { try { using (MvcProject_Raihan01Entities db = new MvcProject_Raihan01Entities()) { Employee emp = db.Employees.Where(x => x.EmployeeID == id).FirstOrDefault <Employee>(); db.Employees.Remove(emp); db.SaveChanges(); } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public EmployeeInformaionController() { _context = new MvcProject_Raihan01Entities(); }