public async Task <IActionResult> GetGarantiaBancariaById(Int64 Id)
{
GarantiaBancaria Items = new GarantiaBancaria();
try
{
Items = await _context.GarantiaBancaria.Where(q => q.Id == Id).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] GarantiaBancaria _GarantiaBancaria)
{
GarantiaBancaria _GarantiaBancariaq = new GarantiaBancaria();
try
{
_GarantiaBancariaq = _context.GarantiaBancaria
.Where(x => x.Id == (Int64)_GarantiaBancaria.Id)
.FirstOrDefault();
_context.GarantiaBancaria.Remove(_GarantiaBancariaq);
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(_GarantiaBancariaq)));
}
public async Task <ActionResult <GarantiaBancaria> > Update([FromBody] GarantiaBancaria _GarantiaBancaria)
{
GarantiaBancaria _GarantiaBancariaq = _GarantiaBancaria;
try
{
_GarantiaBancariaq = await(from c in _context.GarantiaBancaria
.Where(q => q.Id == _GarantiaBancaria.Id)
select c
).FirstOrDefaultAsync();
_context.Entry(_GarantiaBancariaq).CurrentValues.SetValues((_GarantiaBancaria));
//_context.GarantiaBancaria.Update(_GarantiaBancariaq);
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(_GarantiaBancariaq)));
}
public async Task <ActionResult <GarantiaBancaria> > Insert([FromBody] GarantiaBancaria _GarantiaBancaria)
{
GarantiaBancaria _GarantiaBancariaq = new GarantiaBancaria();
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_GarantiaBancariaq = _GarantiaBancaria;
_context.GarantiaBancaria.Add(_GarantiaBancariaq);
await _context.SaveChangesAsync();
JournalEntryConfiguration _journalentryconfiguration = await(_context.JournalEntryConfiguration
.Where(q => q.TransactionId == 1)
//.Where(q => q.BranchId == _GarantiaBancaria.BranchId)
.Where(q => q.EstadoName == "Activo")
.Include(q => q.JournalEntryConfigurationLine)
).FirstOrDefaultAsync();
BitacoraWrite _writejec = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _GarantiaBancaria.Id,
DocType = "JournalEntryConfiguration",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_journalentryconfiguration, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
ResultadoSerializado = Newtonsoft.Json.JsonConvert.SerializeObject(_journalentryconfiguration, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "InsertGarantiaBancaria",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _GarantiaBancaria.UsuarioCreacion,
UsuarioModificacion = _GarantiaBancaria.UsuarioModificacion,
UsuarioEjecucion = _GarantiaBancaria.UsuarioModificacion,
});
// await _context.SaveChangesAsync();
double sumacreditos = 0, sumadebitos = 0;
if (_journalentryconfiguration != null)
{
//Crear el asiento contable configurado
//.............................///////
JournalEntry _je = new JournalEntry
{
Date = _GarantiaBancariaq.FechaCreacion,
Memo = "Partidad Ingreso de Garantia Bancaria",
DatePosted = _GarantiaBancariaq.FechaCreacion,
ModifiedDate = DateTime.Now,
CreatedDate = DateTime.Now,
ModifiedUser = _GarantiaBancariaq.UsuarioModificacion,
CreatedUser = _GarantiaBancariaq.UsuarioCreacion,
DocumentId = _GarantiaBancariaq.Id,
TypeOfAdjustmentId = 65,
VoucherType = 1,
};
foreach (var item in _journalentryconfiguration.JournalEntryConfigurationLine)
{
_je.JournalEntryLines.Add(new JournalEntryLine
{
AccountId = Convert.ToInt32(item.AccountId),
AccountName = item.AccountName,
Description = item.AccountName,
Credit = item.DebitCredit == "Credito" ? _GarantiaBancariaq.Monto : 0,
Debit = item.DebitCredit == "Debito" ? _GarantiaBancariaq.Monto : 0,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now,
CreatedUser = _GarantiaBancariaq.UsuarioCreacion,
ModifiedUser = _GarantiaBancariaq.UsuarioModificacion,
Memo = "",
});
sumacreditos += item.DebitCredit == "Credito" ? _GarantiaBancariaq.Monto : 0;
sumadebitos += item.DebitCredit == "Debito" ? _GarantiaBancariaq.Monto : 0;
// _context.JournalEntryLine.Add(_je);
}
if (sumacreditos != sumadebitos)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: No coinciden debitos :{sumadebitos} y creditos{sumacreditos}");
return(BadRequest($"Ocurrio un error: No coinciden debitos :{sumadebitos} y creditos{sumacreditos}"));
}
_je.TotalCredit = sumacreditos;
_je.TotalDebit = sumadebitos;
_context.JournalEntry.Add(_je);
await _context.SaveChangesAsync();
}
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _GarantiaBancariaq.Id,
DocType = "GarantiaBancaria",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_GarantiaBancariaq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Insertar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _GarantiaBancariaq.UsuarioCreacion,
UsuarioModificacion = _GarantiaBancariaq.UsuarioModificacion,
UsuarioEjecucion = _GarantiaBancariaq.UsuarioModificacion,
});
await _context.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
}
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_GarantiaBancariaq)));
}
