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