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 ActionResult DeleteConfirmed(int id)
{
DocumentProcess documentProcess = db.DocumentProcess.Find(id);
db.DocumentProcess.Remove(documentProcess);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "IdDocumentProcess,IdDocumentCheck,IdExpedient,IdState,IdType,Requiered,Active")] DocumentProcess documentProcess)
{
if (ModelState.IsValid)
{
db.Entry(documentProcess).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdDocumentCheck = new SelectList(db.DocumentCheck, "IdDocumentCheck", "IdDocumentCheck", documentProcess.IdDocumentCheck);
ViewBag.IdExpedient = new SelectList(db.Expedient, "IdExpendient", "FileExpendient", documentProcess.IdExpedient);
return(View(documentProcess));
}
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 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;
}
// GET: DocumentProcesses/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DocumentProcess documentProcess = db.DocumentProcess.Find(id);
if (documentProcess == null)
{
return(HttpNotFound());
}
return(View(documentProcess));
}
private void button2_Click(object sender, EventArgs e)
{
btnGuardar.Enabled = false;
_item = DocumentProcess.ReadDocument();
if (_item != null)
{
string moneda = context.Moneda.Find(_item.Moneda).Nombre;
lblBanco.Text = "Banco: " + _item.CodBanco;
lblFecha.Text = "Fecha Transmision: " + _item.Fecha_Transmision.ToString("dd-MM-yyyy");
lblMoneda.Text = "Moneda: " + moneda;
lblRNC.Text = "RNC: " + _item.RNC_Empresa;
var dt = new DataTable();
dt.Columns.Add("Tipo Documento");
dt.Columns.Add("Documento");
dt.Columns.Add("NSS");
dt.Columns.Add("Salario");
dt.Columns.Add("Salario ISR");
dt.Columns.Add("Cuenta Bancaria");
foreach (var i in _item.DetalleImp)
{
DataRow row = dt.NewRow();
switch (i.TDocumento)
{
case "C": row[0] = "Cedula"; break;
case "P": row[0] = "Pasaporte"; break;
case "R": row[0] = "RNC"; break;
default: row[0] = "Caracter Invalido"; break;
}
row[1] = i.Documento;
row[2] = i.NSS;
row[3] = i.Salario;
row[4] = i.SalarioISR;
row[5] = i.NumeroCuenta;
dt.Rows.Add(row);
}
dataGridView1.DataSource = dt;
dataGridView1.Refresh();
btnGuardar.Enabled = true;
}
}
// GET: DocumentProcesses/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DocumentProcess documentProcess = db.DocumentProcess.Find(id);
if (documentProcess == null)
{
return(HttpNotFound());
}
ViewBag.IdDocumentCheck = new SelectList(db.DocumentCheck, "IdDocumentCheck", "IdDocumentCheck", documentProcess.IdDocumentCheck);
ViewBag.IdExpedient = new SelectList(db.Expedient, "IdExpendient", "FileExpendient", documentProcess.IdExpedient);
return(View(documentProcess));
}
private void button1_Click(object sender, EventArgs e)
{
//using (var m = new ISO810P1Entities())
//{
// EncabezadoImp imp = m.EncabezadoImp
// .Include(x => x.DetalleImp)
// .Include(x => x.MonedaEntity)
// .FirstOrDefault(x => x.Id == 1);
// if (imp == null) return;
// DocumentProcess.Print(imp);
//}
_item.Fecha_Transmision = DateTime.Now;
_item.Moneda = selectedModneda;
_item.MesPago = DateTime.Now.Month;
_item.RNC_Empresa = textBox1.Text.Trim();
_item.CodBanco = textBox2.Text.Trim();
DocumentProcess.Print(_item);
}
public Response <int> Create(int DocumentId, int module, List <DocumentProcessCreateModel> list)
{
try
{
using (var unitOfWork = new UnitOfWork())
{
list.OrderBy(d => d.OrderIndex);
//
int id = 1;
var last = unitOfWork.GetRepository <DocumentProcess>().GetAll().OrderByDescending(d => d.Id).FirstOrDefault();
if (last != null)
{
id = last.Id + 1;
}
for (int i = 0; i < list.Count; i++)
{
var item = list[i];
var entity = new DocumentProcess
{
Id = id,
CreatedOnDate = DateTime.Now,
Status = (int)DocumentProcessStatus.NOTSET,
OrderIndex = item.OrderIndex,
RelatedId = item.RelatedId,
TaskType = item.TaskType
};
unitOfWork.GetRepository <DocumentProcess>().Add(entity);
}
//
switch (module)
{
case (int)Module.SEND:
{
var tmp = unitOfWork.GetRepository <SendDocument>().GetById(DocumentId);
if (tmp != null)
{
tmp.DocumentProcessId = id;
}
break;
}
case (int)Module.RECEIVE:
{
var tmp = unitOfWork.GetRepository <ReceivedDocument>().GetById(DocumentId);
if (tmp != null)
{
tmp.DocumentProcessId = id;
}
break;
}
case (int)Module.INTERNAL:
{
var tmp = unitOfWork.GetRepository <InternalDocument>().GetById(DocumentId);
if (tmp != null)
{
tmp.DocumentProcessId = id;
}
break;
}
}
if (unitOfWork.Save() >= 1)
{
return(new Response <int>(1, "", id));
}
return(new Response <int>(0, "", -1));
}
}
catch (Exception ex)
{
return(new Response <int>(-1, ex.ToString(), -1));
}
}
public Response <int> CreateAuto(int DocumentId, int ModuleType)
{
try
{
using (var unitOfWork = new UnitOfWork())
{
//
int id = 1;
var last = unitOfWork.GetRepository <DocumentProcess>().GetAll().OrderByDescending(d => d.Id).FirstOrDefault();
if (last != null)
{
id = last.Id + 1;
}
if (ModuleType == (int)Module.SEND)
{
//Unitf
var entityUnify = new DocumentProcess
{
Id = id,
CreatedOnDate = DateTime.Now,
Status = (int)DocumentProcessStatus.NOTSET,
OrderIndex = 1,
RelatedId = -1,
TaskType = (int)TaskType.UNIFY
};
unitOfWork.GetRepository <DocumentProcess>().Add(entityUnify);
//Confirm
var entityConfirm = new DocumentProcess
{
Id = id,
CreatedOnDate = DateTime.Now,
Status = (int)DocumentProcessStatus.NOTSET,
OrderIndex = 2,
RelatedId = -1,
TaskType = (int)TaskType.CONFIRM
};
unitOfWork.GetRepository <DocumentProcess>().Add(entityConfirm);
//Register
var entityRegister = new DocumentProcess
{
Id = id,
CreatedOnDate = DateTime.Now,
Status = (int)DocumentProcessStatus.NOTSET,
OrderIndex = 3,
RelatedId = -1,
TaskType = (int)TaskType.REGISTER
};
unitOfWork.GetRepository <DocumentProcess>().Add(entityRegister);
}
else if (ModuleType == (int)Module.RECEIVE)
{
//Confirm
var entityConfirm = new DocumentProcess
{
Id = id,
CreatedOnDate = DateTime.Now,
Status = (int)DocumentProcessStatus.NOTSET,
OrderIndex = 1,
RelatedId = -1,
TaskType = (int)TaskType.CONFIRM
};
unitOfWork.GetRepository <DocumentProcess>().Add(entityConfirm);
//Register
var entityRegister = new DocumentProcess
{
Id = id,
CreatedOnDate = DateTime.Now,
Status = (int)DocumentProcessStatus.NOTSET,
OrderIndex = 2,
RelatedId = -1,
TaskType = (int)TaskType.REGISTER
};
unitOfWork.GetRepository <DocumentProcess>().Add(entityRegister);
}
else if (ModuleType == (int)Module.INTERNAL)
{
//Confirm
var entityConfirm = new DocumentProcess
{
Id = id,
CreatedOnDate = DateTime.Now,
Status = (int)DocumentProcessStatus.NOTSET,
OrderIndex = 1,
RelatedId = -1,
TaskType = (int)TaskType.CONFIRM
};
unitOfWork.GetRepository <DocumentProcess>().Add(entityConfirm);
//Perform
var entityPerform = new DocumentProcess
{
Id = id,
CreatedOnDate = DateTime.Now,
Status = (int)DocumentProcessStatus.NOTSET,
OrderIndex = 2,
RelatedId = -1,
TaskType = (int)TaskType.PERFORM
};
unitOfWork.GetRepository <DocumentProcess>().Add(entityPerform);
//Register
var entityRegister = new DocumentProcess
{
Id = id,
CreatedOnDate = DateTime.Now,
Status = (int)DocumentProcessStatus.NOTSET,
OrderIndex = 3,
RelatedId = -1,
TaskType = (int)TaskType.REGISTER
};
unitOfWork.GetRepository <DocumentProcess>().Add(entityRegister);
}
//
switch (ModuleType)
{
case (int)Module.SEND:
{
var tmp = unitOfWork.GetRepository <SendDocument>().GetById(DocumentId);
if (tmp != null)
{
tmp.DocumentProcessId = id;
}
break;
}
case (int)Module.RECEIVE:
{
var tmp = unitOfWork.GetRepository <ReceivedDocument>().GetById(DocumentId);
if (tmp != null)
{
tmp.DocumentProcessId = id;
}
break;
}
case (int)Module.INTERNAL:
{
var tmp = unitOfWork.GetRepository <InternalDocument>().GetById(DocumentId);
if (tmp != null)
{
tmp.DocumentProcessId = id;
}
break;
}
}
if (unitOfWork.Save() >= 1)
{
return(new Response <int>(1, "", id));
}
return(new Response <int>(0, "", -1));
}
}
catch (Exception ex)
{
return(new Response <int>(-1, ex.ToString(), -1));
}
}
