public FileResult DownloadFile(int?fileId) { DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3(); Leave_request file = db.Leave_request.ToList().Find(model => model.id == fileId.Value); return(File(file.file_data, file.Content_type, file.file_name)); }
public ActionResult Index(HttpPostedFileBase postedFile, Leave_request leave_Request) { DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3(); if (String.IsNullOrEmpty(leave_Request.emp_id.ToString()) || String.IsNullOrEmpty(leave_Request.emp_name) || String.IsNullOrEmpty(leave_Request.start_date) || String.IsNullOrEmpty(leave_Request.end_date) || String.IsNullOrEmpty(leave_Request.ref_no) || String.IsNullOrEmpty(leave_Request.reason)) { return(View()); } else if (String.IsNullOrEmpty(leave_Request.start_date) || String.IsNullOrEmpty(leave_Request.end_date) || String.IsNullOrEmpty(leave_Request.leave_type)) { //ViewBag.Notification = "start date, end date and leave type are required"; return(View()); } else if (db.Employees.All(x => x.id != leave_Request.emp_id) || db.Employees.All(x => x.Name != leave_Request.emp_name)) { ViewBag.Notification = "This employee name does not exists"; return(View()); } else if (db.Employees.Any(x => x.id != leave_Request.emp_id && x.Name == leave_Request.emp_name) || db.Employees.Any(x => x.id == leave_Request.emp_id && x.Name != leave_Request.emp_name)) { ViewBag.Notification = "This employee name does not match with id"; return(View()); } else { byte[] bytes; using (BinaryReader br = new BinaryReader(postedFile.InputStream)) { bytes = br.ReadBytes(postedFile.ContentLength); } db.Leave_request.Add(new Leave_request { id = leave_Request.id, emp_id = leave_Request.emp_id, emp_name = leave_Request.emp_name, start_date = leave_Request.start_date, end_date = leave_Request.end_date, leave_type = leave_Request.leave_type, reason = leave_Request.reason, ref_no = leave_Request.ref_no, status = "submitted", file_name = Path.GetFileName(postedFile.FileName), Content_type = postedFile.ContentType, file_data = bytes, Active = 1, Comments = "" }); db.SaveChanges(); //ViewBag.Notification1 = "Your leave request has created. Please wait for approval/rejection"; TempData["message"] = "Leave Request has been created successfully!"; return(RedirectToAction("Index", "Leave_Request")); } }
public ActionResult Edit1(Leave_request leave_Request, int id) { try { var user = db.Leave_request.Single(model => model.id == id); user.status = leave_Request.status; user.Comments = leave_Request.Comments; db.SaveChanges(); TempData["message"] = "Leave Request has been commented successfully!"; return(RedirectToAction("Edit1", "Leave_Request")); } catch { ViewBag.Notification = "The record is not updated"; } return(View()); }
public ActionResult Delete(int id, Leave_request leave_Request) { try { using (DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3()) { var user = db.Leave_request.Single(model => model.id == id); user.Active = 0; //db.Task_report.Remove(task_Report); db.SaveChanges(); } TempData["message"] = "Leave Request has been deleted successfully!"; return(RedirectToAction("Delete", "Leave_Request")); } catch { ViewBag.Notification = "The record is not deleted"; return(View()); } }
public ActionResult Edit(Leave_request leave_Request, int id) { try { var user = db.Leave_request.Single(model => model.id == id); user.emp_id = leave_Request.emp_id; user.emp_name = leave_Request.emp_name; user.start_date = leave_Request.start_date; user.end_date = leave_Request.end_date; user.leave_type = leave_Request.leave_type; user.reason = leave_Request.reason; user.ref_no = leave_Request.ref_no; db.SaveChanges(); TempData["message"] = "Leave Request has been updated successfully!"; return(RedirectToAction("Edit", "Leave_Request")); } catch { ViewBag.Notification = "The record is not updated"; } return(View()); }