public ActionResult TypeJournalsGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] TypeJournal item)
{
var model = db.TypeJournals;
ViewBag.TypeDraft = item;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.Id == item.Id);
if (modelItem != null)
{
modelItem.Updated = IWSLookUp.GetCurrentDateTime();
this.UpdateModel(modelItem);
db.SubmitChanges();
Session["TypeJournal"] = IWSLookUp.GetTypeJournals();
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("TypeJournalsGridViewPartial", item));
}
public ActionResult TypeJournalsGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] TypeJournal item)
{
var model = db.TypeJournals;
item.CompanyId = (string)Session["CompanyID"];
item.ModelId = (int)IWSLookUp.MetaModelId.TypeJournal;
DateTime dateTime = IWSLookUp.GetCurrentDateTime();
item.Posted = dateTime;
item.Updated = dateTime;
ViewBag.TypeDraft = item;
if (ModelState.IsValid)
{
try
{
item.Posted = dateTime;
item.Updated = dateTime;
model.InsertOnSubmit(item);
db.SubmitChanges();
Session["TypeJournal"] = IWSLookUp.GetTypeJournals();
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("TypeJournalsGridViewPartial", item));
}
public async Task <ActionResult <TypeJournal> > Update([FromBody] TypeJournal _TypeJournal)
{
TypeJournal _TypeJournalq = _TypeJournal;
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_TypeJournalq = await(from c in _context.TypeJournal
.Where(q => q.TypeJournalId == _TypeJournal.TypeJournalId)
select c
).FirstOrDefaultAsync();
_context.Entry(_TypeJournalq).CurrentValues.SetValues((_TypeJournal));
//_context.Bank.Update(_Bankq);
await _context.SaveChangesAsync();
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _TypeJournalq.TypeJournalId,
DocType = "TypeJournal",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_TypeJournalq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Insertar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _TypeJournalq.CreatedUser,
UsuarioModificacion = _TypeJournalq.ModifiedUser,
UsuarioEjecucion = _TypeJournalq.ModifiedUser,
});
await _context.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
// return BadRequest($"Ocurrio un error:{ex.Message}");
}
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_TypeJournalq)));
}
public async Task <IActionResult> GetTypeJournalById(Int64 TypeJournalId)
{
TypeJournal Items = new TypeJournal();
try
{
Items = await _context.TypeJournal.Where(q => q.TypeJournalId == TypeJournalId).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
public async Task <IActionResult> Delete([FromBody] TypeJournal _TypeJournal)
{
TypeJournal _TypeJournalq = new TypeJournal();
try
{
_TypeJournalq = _context.TypeJournal
.Where(x => x.TypeJournalId == (Int64)_TypeJournal.TypeJournalId)
.FirstOrDefault();
_context.TypeJournal.Remove(_TypeJournalq);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_TypeJournalq)));
}
