public JobRequestAttachmentMain GetJobFileAttachmentObjects(Guid id)
{
JobRequestAttachmentMain obj = new JobRequestAttachmentMain();
try
{
obj.RequestObj = db.JobRequest.Find(id);
var temp = from x in db.JobRequestAttachments
where x.RequestKey == id
select new JobRequestAttachmentsObject
{
PKey = x.PKey,
RequestKey = x.RequestKey,
DocumentTypeKey = x.DocumentTypeKey,
DocFile = x.DocFile,
Filename = x.Filename,
FileType = x.FileType,
DocumentName = x.DocumentType.TName
};
obj.JobRequestAttachmentsList = new List <JobRequestAttachmentsObject>();
obj.JobRequestAttachmentsList = temp.ToList();
}
catch (Exception ex)
{
string fall = ex.ToString();
}
return(obj);
}
public ActionResult Index(HttpPostedFileBase file, JobRequestAttachmentMain model)
{
if (GlobalClass.SystemSession)
{
ViewBag.mess = "";
model.fileObj = new JobRequestAttachmentsObject();
model.fileObj.RequestKey = model.RequestObj.RequestKey;
if (ModelState.IsValid)
{
if (file != null)
{
byte[] data = null;
using (Stream inputStream = file.InputStream)
{
MemoryStream memoryStream = inputStream as MemoryStream;
if (memoryStream == null)
{
memoryStream = new MemoryStream();
inputStream.CopyTo(memoryStream);
}
data = memoryStream.ToArray();
}
model.fileObj.FileType = file.ContentType;
model.fileObj.Filename = file.FileName;
model.fileObj.DocFile = data;
DataReturn dt = setup.SaveAttachmentInRequest(model);
ViewBag.mess = dt.mess;
}
}
model = setup.GetJobFileAttachmentObjects(model.RequestObj.RequestKey);
ViewBag.DocumentTypeKey = new SelectList(db.DocumentType.Where(m => m.DocumentForID == 6 && m.IsDelete == false && m.CompanyKey == GlobalClass.Company.CompanyKey).OrderBy(m => m.TName), "ID", "TName");
return(View(model));
}
else
{
Exception e = new Exception("Sorry, your Session has Expired");
return(View("Error", new HandleErrorInfo(e, "Home", "Logout")));
}
}
// GET: JobRequestFile
public ActionResult Index(Guid id)
{
if (GlobalClass.SystemSession)
{
JobRequestAttachmentMain model = new JobRequestAttachmentMain();
ViewBag.mess = " ";
model = setup.GetJobFileAttachmentObjects(id);
ViewBag.DocumentTypeKey = new SelectList(db.DocumentType.Where(m => m.DocumentForID == 6 && m.IsDelete == false && m.CompanyKey == GlobalClass.Company.CompanyKey).OrderBy(m => m.TName), "ID", "TName");
return(View(model));
}
else
{
Exception e = new Exception("Sorry, your Session has Expired");
return(View("Error", new HandleErrorInfo(e, "Home", "Logout")));
}
}
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);
}
