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