/// <summary>
/// REALIZAR OPERACIONES DE MANTENIMIENTO
/// </summary>
/// <param name="oBe"></param>
public void Set_SVPR_OVEN(BESVTC_OVEN oBe)
{
try
{
oDa.Set_SVPR_OVEN(oBe);
Dispose(false);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
/// <summary>
/// OBTENER EL RESULTADO DE CUALQUIER CONSULTA
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public List<BESVTC_OVEN> Get_SVPR_OVEN_BUSC(BESVTC_OVEN oBe)
{
try
{
using (IDataReader oDr = oDa.Get_SVPR_OVEN_BUSC(oBe))
{
List<BESVTC_OVEN> oList = new List<BESVTC_OVEN>();
IList iList = oList;
((IList)iList).LoadFromReader<BESVTC_OVEN>(oDr);
Dispose(false);
return (oList);
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
/// <summary>
/// REALIZAR OPERACIONES DE MANTENIMIENTO PARA LA VENTA
/// </summary>
/// <param name="oBe"></param>
public void Set_SVPR_OVEN(BESVTC_OVEN oBe)
{
if (ocn.State == ConnectionState.Closed) ocn.Open();
using (var obts = ocn.BeginTransaction())
{
try
{
using (var ocmd = odb.GetStoredProcCommand("SVPR_OVEN",
oBe.COD_OVEN,
oBe.COD_COTI,
oBe.COD_SUCU,
oBe.COD_SOCI_NEGO,
oBe.ALF_NOMB,
oBe.FEC_REGI,
oBe.FEC_DOCU,
oBe.FEC_PAGO,
oBe.ALF_DIRE,
oBe.ALF_CONT,
oBe.NUM_DESC,
oBe.ALF_OBSE,
oBe.NUM_SUBT,
oBe.NUM_IGVV,
oBe.NUM_ISCC,
oBe.NUM_TOTA,
oBe.ALF_TOTA,
oBe.COD_MONE,
oBe.COD_USUA_CREA,
oBe.COD_USUA_MODI,
oBe.NUM_ACCI))
{
ocmd.CommandTimeout = 2000;
odb.ExecuteNonQuery(ocmd, obts);
oBe.COD_OVEN = Convert.ToInt32(odb.GetParameterValue(ocmd, "@COD_OVEN"));
DbCommand cmdo;
oBe.LST_OVEN.ForEach(item =>
{
cmdo = odb.GetStoredProcCommand("SVPR_OVEN_DETA",
oBe.COD_OVEN,
item.COD_ARTI,
item.ALF_ARTI,
item.NUM_PREC_UNIT,
item.NUM_PORC_DESC,
item.NUM_DESC,
item.NUM_CANT,
item.NUM_STOC_REAL,
item.NUM_STOC_VIRT,
item.NUM_IMPO,
oBe.COD_USUA_CREA,
oBe.COD_USUA_MODI,
1);
cmdo.CommandTimeout = 2000;
odb.ExecuteNonQuery(cmdo, obts);
});
oBe.LST_OVEN_GROU.ForEach(item =>
{
cmdo = odb.GetStoredProcCommand("SVPR_OVEN_GROU",
item.COD_OVEN_GROU,
oBe.COD_OVEN,
item.ALF_NOMB,
item.NUM_CANT,
oBe.COD_USUA_CREA,
oBe.COD_USUA_MODI,
1);
cmdo.CommandTimeout = 2000;
odb.ExecuteNonQuery(cmdo, obts);
});
oBe.LST_OVEN_ARTI_GROU.ForEach(item =>
{
cmdo = odb.GetStoredProcCommand("SVPR_OVEN_GROU_DETA",
item.COD_OVEN_GROU,
oBe.COD_OVEN,
item.COD_ARTI,
item.ALF_ARTI,
item.NUM_PREC_UNIT,
item.NUM_PORC_DESC,
item.NUM_DESC,
item.NUM_CANT,
item.NUM_IMPO,
oBe.COD_USUA_CREA,
oBe.COD_USUA_MODI,
1);
cmdo.CommandTimeout = 2000;
odb.ExecuteNonQuery(cmdo, obts);
});
obts.Commit();
}
}
catch (Exception ex)
{
obts.Rollback();
throw new ArgumentException(ex.Message);
}
finally
{
ocn.Close();
}
}
}
public IDataReader Get_SVPR_OVEN_BUSC(BESVTC_OVEN oBe)
{
try
{
if (ocn.State == ConnectionState.Closed) ocn.Open();
var ocmd = odb.GetStoredProcCommand("SVPR_OVEN_BUSC",
oBe.ALF_NUME_IDENT,
oBe.FEC_DESD,
oBe.FEC_HAST,
oBe.NUM_ACCI
);
ocmd.CommandTimeout = 2000;
var odr = odb.ExecuteReader(ocmd);
Dispose(false);
return (odr);
}
finally
{
ocn.Close();
}
}
