public JobFileClass GetJobFileAttachments(Guid id)
{
JobFileClass obj = new JobFileClass();
try
{
obj.Joblist = new List <JobFileClass>();
var temp = from x in db.JobFile
where x.JobKey == id && x.IsDelete == false
select new JobFileClass
{
FileKey = x.FileKey,
JobKey = x.JobKey,
JobName = x.Job.JobName,
DocumentTypeKey = x.DocumentTypeKey,
AddedBy = x.AddedBy,
AddedOn = x.AddedOn,
Comment = x.Comment,
Title = x.Title,
Remarks = x.Remarks,
IsDelete = x.IsDelete,
DocumentTypeName = x.DocumentType.TName
};
obj.Joblist = temp.OrderByDescending(m => m.AddedOn).ToList();
}
catch (Exception ex)
{
string fall = ex.ToString();
}
return(obj);
}
public DataReturn SaveAttachmentInJobFile(JobFileClass model)
{
DataReturn obj = new DataReturn();
try
{
JobFile fj = db.JobFile.SingleOrDefault(m => m.JobKey == model.JobKey && m.DocumentTypeKey == model.DocumentTypeKey);
if (fj == null)
{
}
else
{
db.JobFile.Remove(fj);
db.SaveChanges();
db = new RCSdbEntities();
}
JobFile invoice = new JobFile();
Job job = db.Job.Find(model.JobKey);
invoice.FileKey = Guid.NewGuid();
invoice.JobKey = (Guid)model.JobKey;
invoice.DocumentTypeKey = model.DocumentTypeKey;
//invoice.AddedBy = GlobalClass.LoginUser.PersonnelKey;
invoice.AddedOn = System.DateTime.Now;
if (string.IsNullOrEmpty(model.Comment))
{
invoice.Comment = "--";
}
else
{
invoice.Comment = model.Comment;
}
invoice.Title = model.Title;
invoice.Remarks = db.DocumentType.Find(model.DocumentTypeKey).TName + " is Added by " + GlobalClass.LoginUser.Cname;
invoice.FileContent = model.FileContent;
invoice.FileType = model.FileType;
invoice.IsDelete = false;
invoice.IsFileNew = true;
db.JobFile.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.JobKey;
return(obj);
}
public ActionResult FilesandAttachments(HttpPostedFileBase file, JobFileClass model)
{
if (GlobalClass.SystemSession)
{
ViewBag.mess = "";
Job job = db.Job.Find(model.JobKey);
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.FileType = file.ContentType;
model.Title = file.FileName;
model.FileContent = data;
DataReturn dt = manage.SaveAttachmentInJobFile(model);
ViewBag.mess = dt.mess;
}
}
model = new JobFileClass();
model = manage.GetJobFileAttachments((Guid)job.JobKey);
model.JobKey = job.JobKey;
model.JobName = job.JobName;
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 ActionResult FilesandAttachments(Guid id)
{
if (GlobalClass.SystemSession)
{
JobFileClass model = new JobFileClass();
Job job = db.Job.Find(id);
model = manage.GetJobFileAttachments(id);
model.JobKey = id;
model.JobName = job.JobName;
ViewBag.mess = " ";
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")));
}
}
