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); }