public Response UpdateMainAttachment(int id, byte[] file)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.Document.Include("DocumentAttachment").Where(o => o.Id == id).FirstOrDefault();
if (doc != null)
{
doc.MainAttachmentBinary = file;
doc.FileSize = Util.ConvertBytesToMegabytes(file.Length).ToString("N5") + " mb";
ctx.SaveChanges();
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response GetOrganizationById(int id)
{
Response resp = new Response();
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var obj = ctx.Organization.Where(o => o.Id == id).FirstOrDefault();
if (obj != null)
{
resp.ResponseObject = obj;
}
resp.Status = true;
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return resp;
}
public Response GetOrganizationById(int id)
{
Response response = new Response();
response.ApiName = "service/GetOrganizationById";
try
{
using (DGAMilDocEntities context = new DGAMilDocEntities())
{
var obj = context.Organization.Where(abc => abc.Id == id).FirstOrDefault();
response.ResultData = obj;
response.Status = true;
response.Message = "Success";
}
}
catch (Exception ex)
{
response.Status = false;
response.Message = ex.Message;
}
return(response);
}
public Response CancelSaveDocument(int id)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.Document.Where(o => o.Id == id).FirstOrDefault();
if (doc != null)
{
foreach (var attachment in doc.DocumentAttachment)
{
attachment.State = "บันทึก";
}
foreach (var reference in doc.DocumentReference)
{
reference.State = "บันทึก";
}
ctx.SaveChanges();
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response UpdateDocumentStatus(int id, string processId, string status)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.Document.Where(o => o.Id == id).FirstOrDefault();
if (doc != null)
{
doc.ProcessId = processId;
doc.Status = status;
DocumentProcess docProcess = new DocumentProcess()
{
CreatedDate = DateTime.Now,
DocumentId = doc.Id,
ProcessId = processId,
Status = status
};
ctx.DocumentProcess.Add(docProcess);
ctx.SaveChanges();
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return resp;
}
public Response UpdateDocumentAttachment(int id, List<byte[]> files)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.Document.Include("DocumentAttachment").Where(o => o.Id == id).FirstOrDefault();
if (doc != null)
{
int i = 0;
foreach (var attach in doc.DocumentAttachment)
{
attach.AttachmentBinary = files[i];
attach.FileSize = Util.ConvertBytesToMegabytes(files[i].Length).ToString("N5") + " mb";
attach.State = "บันทึก";
attach.Type = "1";
i++;
}
ctx.SaveChanges();
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response GetDocumentInListByOrganizationId(int organizationId)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.DocumentIn.Where(o => o.ReceiverOrganizationId == organizationId).Select(x => new
{
Id = x.Id,
x.BookId,
Date = x.Date,
Subject = x.Subject,
Status = x.Status,
Receive = x.Organization1.Name,
x.AcceptId
}).OrderByDescending(o => o.Id).ToList();
if (doc != null)
{
resp.ResponseObject = doc;
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response IsAcceptIdDuplicate(string acceptId)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.DocumentIn.Where(o => o.AcceptId == acceptId).FirstOrDefault();
if (doc != null)
{
//doc.Organization = ctx.Organization.Where(o => o.Id == doc.SenderOrganizationId).FirstOrDefault();
//doc.Organization1 = ctx.Organization.Where(o => o.Id == doc.ReceiverOrganizationId).FirstOrDefault();
resp.Description = "ลงรับหนังสือซ้า";
resp.Status = false;
}
else
{
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response Login(string username, string password)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var user = ctx.User
.Include("Organization")
.Where(o => o.Username == username && o.Password == password)
.FirstOrDefault();
user.Expire = DateTime.Now.AddDays(1);
ctx.SaveChanges();
user.Password = null;
user.Organization.User = null;
if (user != null)
{
resp.ResponseObject = user;
resp.Status = true;
}
else
{
resp.Status = false;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return(resp);
}
public Response GetDocumentWithChild(int id)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.Document
.Include("DocumentAttachment")
.Include("DocumentReference")
.Include("Organization")
.Include("Organization1").Where(o => o.Id == id).FirstOrDefault();
if (doc != null)
{
resp.ResponseObject = doc;
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response UpdateDocumentInAcceptId(int id, string acceptId)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var obj = ctx.DocumentIn.Where(o => o.Id == id).FirstOrDefault();
if (obj != null)
{
obj.AcceptId = acceptId;
ctx.SaveChanges();
resp.ResponseObject = obj.Id;
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return resp;
}
public Response AddDocumentIn(DocumentIn docIn)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.DocumentIn.Where(o => o.ProcessId == docIn.ProcessId).FirstOrDefault();
if (doc != null)
{
resp.ResponseObject = doc;
}
else
{
if (docIn.DocumentReference != null)
{
foreach (var item in docIn.DocumentReference)
{
item.State = "บันทึก";
item.Type = 2;
}
};
ctx.DocumentIn.Add(docIn);
DocumentProcess docProcess = new DocumentProcess()
{
CreatedDate = DateTime.Now,
DocumentInId = docIn.Id,
ProcessId = docIn.ProcessId,
Status = "รับหนังสือรอส่งหนังสือตอบรับ"
};
ctx.DocumentProcess.Add(docProcess);
ctx.SaveChanges();
resp.ResponseObject = docIn;
}
resp.Status = true;
//resp.Description = "1";
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return resp;
}
public Response UpdateDocumentReject(Document doc, string acceptDept)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var obj = ctx.Document.Where(o => o.No == doc.No
&& o.Date == doc.Date
&& o.Subject == doc.Subject
&& o.Organization1.Code == acceptDept).FirstOrDefault();
if (obj != null)
{
if (obj.Status == "ปฏิเสธการรับหนังสือ")
{
resp.Status = true;
resp.ResponseObject = 0;
}
else
{
DocumentProcess docProcess = new DocumentProcess()
{
CreatedDate = DateTime.Now,
DocumentId = obj.Id,
ProcessId = doc.ProcessId,
Status = "ปฏิเสธการรับหนังสือ"
};
ctx.DocumentProcess.Add(docProcess);
obj.Status = "ปฏิเสธการรับหนังสือ";
obj.ProcessId = doc.ProcessId;
ctx.SaveChanges();
resp.ResponseObject = obj.Id;
resp.Status = true;
}
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return resp;
}
public Response GetDocumentIn(int id)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.DocumentIn
.Include("DocumentAttachment")
.Include("DocumentReference")
.Include("Organization")
.Include("Organization1").Where(o => o.Id == id).FirstOrDefault();
if (doc != null)
{
doc.MainAttachmentBinary = null;
foreach (var attachment in doc.DocumentAttachment)
{
attachment.Document = null;
attachment.DocumentIn = null;
attachment.AttachmentBinary = null;
}
foreach (var reference in doc.DocumentReference)
{
reference.Document = null;
reference.DocumentIn = null;
}
//doc.Organization = ctx.Organization.Where(o => o.Id == doc.SenderOrganizationId).FirstOrDefault();
//doc.Organization1 = ctx.Organization.Where(o => o.Id == doc.ReceiverOrganizationId).FirstOrDefault();
doc.Organization.DocumentIn = null;
doc.Organization.Document1 = null;
doc.Organization.DocumentIn1 = null;
doc.Organization.Document = null;
doc.Organization1.DocumentIn = null;
doc.Organization1.Document1 = null;
doc.Organization1.DocumentIn1 = null;
doc.Organization1.Document = null;
resp.ResponseObject = doc;
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response AddDocument(Document doc)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
if (doc.DocumentReference != null)
{
foreach (var item in doc.DocumentReference)
{
item.State = "บันทึก";
}
};
if (ctx.Document.Any(o => o.No == doc.No && o.SenderOrganizationId == doc.SenderOrganizationId && o.ReceiverOrganizationId == doc.ReceiverOrganizationId))
{
resp.Status = false;
resp.Description = "เลขที่หนังสือซ้ำ";
}
else
{
doc.CreatedDate = DateTime.Now;
ctx.Document.Add(doc);
ctx.SaveChanges();
resp.Status = true;
doc.DocumentAttachment = null;
doc.DocumentReference = null;
resp.ResponseObject = doc;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return resp;
}
public Response UpdateDocumentAttachment(int id, List<string> fileName, List<byte[]> files)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
foreach (var file in fileName.Where(o => !o.Contains("mainFile")))
{
var i = 0;
DocumentAttachment att = new DocumentAttachment()
{
DocumentId = id,
AttachmentName = file,
AttachmentBinary = files[i],
MimeCode = Util.ConvertContentType(System.IO.Path.GetExtension(file)),
State = "บันทึก",
Type = "1",
FileSize = Util.ConvertBytesToMegabytes(files[i].Length).ToString("N5") + " mb",
};
ctx.DocumentAttachment.Add(att);
i++;
}
ctx.SaveChanges();
resp.Status = true;
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return resp;
}
public Response GetOtherAttachmentById(int id)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var att = ctx.DocumentAttachment.Where(o => o.Id == id).FirstOrDefault();
if (att != null)
{
resp.ResponseObject = att;
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return resp;
}
public Response DeleteDocument(int id)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var doc = ctx.Document.Where(o => o.Id == id).FirstOrDefault();
if (doc != null)
{
ctx.Document.Remove(doc);
ctx.SaveChanges();
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response DeleteReferenceBook(int id)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var reference = ctx.DocumentReference.Where(o => o.Id == id).FirstOrDefault();
if (reference != null)
{
reference.State = "รอลบ";
ctx.SaveChanges();
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response AddListOrganization(List<Organization> organizaions)
{
Response resp = new Response();
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
ctx.Organization.AddRange(organizaions);
ctx.SaveChanges();
resp.Status = true;
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response GetOrganizationList()
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var organizations = ctx.Organization.OrderByDescending(o => o.Name).ToList();
if (organizations != null)
{
resp.ResponseObject = organizations;
resp.Status = true;
}
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
resp.Exception = ex.ToString();
}
return resp;
}
public Response UpdateDocument(Document doc)
{
try
{
using (DGAMilDocEntities ctx = new DGAMilDocEntities())
{
var document = ctx.Document.Include("DocumentReference").Where(o => o.Id == doc.Id).FirstOrDefault();
if (document != null)
{
document.No = doc.No;
document.From = doc.From;
document.Type = doc.Type;
document.Date = doc.Date;
document.Subject = doc.Subject;
document.Speed = doc.Speed;
document.Secret = doc.Secret;
document.Description = doc.Description;
document.MainAttachmentName = doc.MainAttachmentName;
document.MimeCode = doc.MimeCode;
document.SenderPosition = doc.SenderPosition;
document.SenderName = doc.SenderName;
document.SenderSurname = doc.SenderSurname;
document.ReceiverPosition = doc.ReceiverPosition;
document.ReceiverName = doc.ReceiverName;
document.ReceiverSurname = doc.ReceiverSurname;
document.ReceiverOrganizationId = doc.ReceiverOrganizationId;
}
if (doc.DocumentReference != null)
{
var newRef = doc.DocumentReference.Where(o => o.State == "เพิ่ม").ToList();
foreach (var refer in newRef)
{
refer.State = "บันทึก";
document.DocumentReference.Add(refer);
}
var deleteRef = doc.DocumentReference.Where(o => o.State == "รอลบ").ToList();
foreach (var refer in deleteRef)
{
var obj = ctx.DocumentReference.Where(o => o.Id == refer.Id).FirstOrDefault();
if (obj != null)
{
ctx.DocumentReference.Remove(obj);
}
}
}
var attList = ctx.DocumentAttachment.Where(o => o.DocumentId == document.Id).ToList();
foreach (var att in attList)
{
if (att.State == "รอลบ")
{
ctx.DocumentAttachment.Remove(att);
}
}
ctx.SaveChanges();
resp.Status = true;
document.DocumentReference = null;
document.DocumentAttachment = null;
resp.ResponseObject = document;
document.MainAttachmentBinary = null;
}
}
catch (Exception ex)
{
resp.Status = false;
resp.Description = ex.Message;
}
return resp;
}
