public async Task <IActionResult> Edit(int id, [Bind("Idfirmas,Nombre,Fecha,Sexo,Libro")] Firmas firmas)
{
if (id != firmas.Idfirmas)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(firmas);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FirmasExists(firmas.Idfirmas))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(firmas));
}
private bool Delete(ref Firmas Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_FIRMSD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintFIRM_Codigo", Item.FIRM_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCUBA_Codigo", Item.CUBA_Codigo, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private Firmas SelectOne(Int16 EMPR_Codigo, Int32 FIRM_Codigo, String CUBA_Codigo)
{
try
{
Firmas item = new Firmas();
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_FIRMSS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintFIRM_Codigo", FIRM_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCUBA_Codigo", CUBA_Codigo, SqlDbType.VarChar, 20, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception)
{ throw; }
}
public BLFirmas(IUnityContainer container)
{
this.ContainerService = container;
Loader = new BusinessEntityLoader <Firmas>();
Firmas Item = new Firmas();
Loader.EntityType = Item.GetType();
}
public async Task <IActionResult> Create([Bind("Idfirmas,Nombre,Fecha,Sexo,Libro, Codigo")] Firmas firmas)
{
if (ModelState.IsValid)
{
firmas.Fecha = DateTime.Now;
firmas.Nombre = (firmas.Nombre).ToUpper();
_context.Add(firmas);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Create)));
}
return(View(firmas));
}
public Boolean SaveFirmas(ref Firmas Item)
{
try
{
if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged)
{
return(BL_Firmas.Save(ref Item));
}
return(true);
}
catch (Exception)
{ throw; }
}
private bool Insert(ref Firmas Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_FIRMSI_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintFIRM_Codigo", Item.FIRM_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCUBA_Codigo", Item.CUBA_Codigo, SqlDbType.VarChar, 20, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchFIRM_Nombre", Item.FIRM_Nombre, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchFIRM_Cargo", Item.FIRM_Cargo, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", Item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
Int16 _EMPR_Codigo;
if (Int16.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@psinEMPR_Codigo"].Value.ToString(), out _EMPR_Codigo))
{
Item.EMPR_Codigo = _EMPR_Codigo;
}
Int32 _FIRM_Codigo;
if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintFIRM_Codigo"].Value.ToString(), out _FIRM_Codigo))
{
Item.FIRM_Codigo = _FIRM_Codigo;
}
if (DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCUBA_Codigo"].Value != DBNull.Value && String.IsNullOrEmpty(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCUBA_Codigo"].Value.ToString()))
{
Item.CUBA_Codigo = DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCUBA_Codigo"].Value.ToString();
}
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
public Boolean Save(ref Firmas Item)
{
try
{
Boolean m_isCorrect = true;
switch (Item.Instance)
{
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added:
m_isCorrect = Insert(ref Item); break;
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified:
m_isCorrect = Update(ref Item); break;
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted:
m_isCorrect = Delete(ref Item); break;
}
return(m_isCorrect);
}
catch (Exception)
{ throw; }
}
private ObservableCollection <Firmas> SelectAll()
{
try
{
ObservableCollection <Firmas> items = new ObservableCollection <Firmas>();
Firmas item = new Firmas();
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_FIRMSS_Todos");
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new Firmas();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
private ObservableCollection <Firmas> SelectAllByFilter(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters)
{
try
{
ObservableCollection <Firmas> items = new ObservableCollection <Firmas>();
Firmas item = new Firmas();
if (!String.IsNullOrEmpty(x_procedure))
{
DataAccessEnterpriseSQL.DAAsignarProcedure(x_procedure);
}
else
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_FIRMSS_TodosByFilters");
}
if (x_filters != null && x_filters.Count > 0)
{
foreach (Infrastructure.Aspect.DataAccess.DataAccessFilterSQL _itemFilter in x_filters)
{
DataAccessEnterpriseSQL.DAAgregarParametro(_itemFilter.FilterName, _itemFilter.FilterValue, _itemFilter.FilterSQLType, _itemFilter.FilterSize);
}
}
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new Firmas();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
