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