public ActionResult DownloadAttachment(int id)
{
OvmDbContext context = new OvmDbContext();
SickTimeOff sto = context.SickTimeOffs.Find(id);
string attachmentPath = sto.AttachmentPath;
return(File(attachmentPath, System.Net.Mime.MediaTypeNames.Application.Octet,
Path.GetFileName(attachmentPath)));
}
public ActionResult ApproveSick(int id)
{
OvmDbContext context = new OvmDbContext();
SickTimeOff sto = context.SickTimeOffs.Find(id);
sto.IsApproved = true;
context.SaveChanges();
context.Dispose();
return(RedirectToAction("AllRequests"));
}
public ActionResult DeleteSick(int id)
{
OvmDbContext context = new OvmDbContext();
SickTimeOff sto = context.SickTimeOffs.Find(id);
StorageService.DeleteFile(sto.AttachmentPath);
context.SickTimeOffs.Remove(sto);
context.SaveChanges();
context.Dispose();
return(RedirectToAction("Index"));
}
public ActionResult DetailsSick(int id)
{
OvmDbContext context = new OvmDbContext();
SickTimeOff sto = context.SickTimeOffs.Find(id);
SickTimeOffsDetailsVM model = new SickTimeOffsDetailsVM
{
Id = sto.Id,
From = sto.From,
To = sto.To,
IsApproved = sto.IsApproved,
LastChangedOn = sto.CreatedOn,
};
context.Dispose();
return(View(model));
}
public ActionResult EditSick(int?id)
{
SickTimeOffsEditVM model = new SickTimeOffsEditVM();
OvmDbContext context = new OvmDbContext();
if (id != null)
{
SickTimeOff pto = context.SickTimeOffs.Find(id.Value);
model.To = pto.To;
model.From = pto.From;
model.Id = pto.Id;
model.AttachmentPath = pto.AttachmentPath;
}
context.Dispose();
return(View(model));
}
public ActionResult EditSick(SickTimeOffsEditVM model)
{
OvmDbContext context = new OvmDbContext();
SickTimeOff sto = new SickTimeOff
{
Id = model.Id,
CreatedOn = DateTime.Now,
RequestorId = AuthenticationManager.LoggedUser.Id,
From = model.From,
To = model.To,
AttachmentPath = model.Attachment == null
? model.AttachmentPath
: StorageService.SaveFile(model.Attachment)
};
context.SickTimeOffs.AddOrUpdate(pt => pt.Id, sto);
context.SaveChanges();
context.Dispose();
return(RedirectToAction("Index"));
}
