public ActionResult GetJobRequestFileAttachement(Guid id) { JobRequestAttachments obj = db.JobRequestAttachments.Find(id); if (obj.DocFile != null) { return(File(obj.DocFile, obj.FileType)); } else { ImageFile faoimagefile = db.ImageFile.Single(f => f.ImageFileKey == 1); return(File(faoimagefile.FileContent, faoimagefile.FileType)); } }
public DataReturn SaveAttachmentInRequest(JobRequestAttachmentMain model) { DataReturn obj = new DataReturn(); try { JobRequestAttachments fj = db.JobRequestAttachments.SingleOrDefault(m => m.RequestKey == model.RequestObj.RequestKey && m.DocumentTypeKey == model.DocumentTypeKey); if (fj == null) { } else { db.JobRequestAttachments.Remove(fj); db.SaveChanges(); db = new RCSdbEntities(); } JobRequestAttachments invoice = new JobRequestAttachments(); invoice.PKey = Guid.NewGuid(); invoice.RequestKey = (Guid)model.RequestObj.RequestKey; invoice.DocumentTypeKey = model.DocumentTypeKey; invoice.DocFile = model.fileObj.DocFile; invoice.Filename = model.fileObj.Filename; invoice.FileType = model.fileObj.FileType; db.JobRequestAttachments.Add(invoice); db.SaveChanges(); obj.flag = 1; obj.mess = "Data has been updated successfully."; } catch (Exception ex) { obj.mess = ex.ToString(); obj.flag = 0; } obj.key = model.RequestObj.RequestKey; return(obj); }