public static List <Venta> GetVentaListForSearch(string whereSql)
{
if (string.IsNullOrEmpty(whereSql))
{
whereSql = "1 = 1";
}
List <Venta> theList = new List <Venta>();
Venta theUser = null;
VentaTableAdapter theAdapter = new VentaTableAdapter();
try
{
VentaDS.VentaDataTable table = theAdapter.GetVentaForSearch(whereSql);
if (table != null && table.Rows.Count > 0)
{
foreach (VentaDS.VentaRow row in table.Rows)
{
theUser = FillVentaRecord(row);
theList.Add(theUser);
}
}
}
catch (Exception q)
{
log.Error("el error ocurrio mientras obtenia la lista de las venta de la base de datos", q);
return(null);
}
return(theList);
}
public static Venta GetVentaById(int ventaID)
{
VentaTableAdapter localAdapter = new VentaTableAdapter();
if (ventaID <= 0)
{
return(null);
}
Venta theUser = null;
try
{
VentaDS.VentaDataTable table = localAdapter.GetVentaById(ventaID);
if (table != null && table.Rows.Count > 0)
{
VentaDS.VentaRow row = table[0];
theUser = FillVentaRecord(row);
}
}
catch (Exception q)
{
log.Error("An error was ocurred while geting venta data", q);
return(null);
}
return(theUser);
}
