public static OrdenCompra SelectById(int id)
{
OrdenCompraDSTableAdapters.tbl_ordenCompraTableAdapter adapter = new OrdenCompraDSTableAdapters.tbl_ordenCompraTableAdapter();
OrdenCompraDS.tbl_ordenCompraDataTable table = adapter.SelectById(id);
if (table.Rows.Count == 0)
{
return(null);
}
return(RowToDto(table[0]));
}
public static OrdenCompra InsertWithReturn(string idEstadoCompra, string idTipoPago,
string idUsuario, string total)
{
OrdenCompraDSTableAdapters.tbl_ordenCompraTableAdapter adapter = new OrdenCompraDSTableAdapters.tbl_ordenCompraTableAdapter();
OrdenCompraDS.tbl_ordenCompraDataTable table = adapter.InsertWithReturn(Convert.ToInt32(idEstadoCompra),
Convert.ToInt32(idTipoPago), Convert.ToInt32(idUsuario), Convert.ToDouble(total), 0, DateTime.Now, TimeSpan.Parse(DateTime.Now.ToString("hh:mm:ss")));
if (table.Rows.Count == 0)
{
return(null);
}
return(RowToDto(table[0]));
}
public static List <OrdenCompra> SelectAll()
{
OrdenCompraDSTableAdapters.tbl_ordenCompraTableAdapter adapter = new OrdenCompraDSTableAdapters.tbl_ordenCompraTableAdapter();
OrdenCompraDS.tbl_ordenCompraDataTable table = adapter.selectNoEliminados();
List <OrdenCompra> listOrdenCompra = new List <OrdenCompra>();
foreach (OrdenCompraDS.tbl_ordenCompraRow row in table)
{
listOrdenCompra.Add(RowToDto(row));
}
return(listOrdenCompra);
}
