private List <Ecom_Producto> ReadDatReader(string Statement) { List <Ecom_Producto> List = null; MySqlDataReader Data = null; try { Ecom_Tools.ValidDBobject(Data_DBConnection_); Data = Data_DBConnection_.DoQuery(Statement); List = new List <Ecom_Producto>(); if (Data.HasRows) { while (Data.Read()) { List.Add(new Ecom_Producto { Id = Data.IsDBNull(0) ? 0 : (int)Data.GetUInt32(0), Clave = Data.IsDBNull(1) ? "" : Data.GetString(1), Descripcion = Data.IsDBNull(2) ? "" : Data.GetString(2), PrecioCotizacion = Data.IsDBNull(3) ? 0 : Data.GetDouble(3), PrecioCompra = Data.IsDBNull(4) ? 0 : Data.GetDouble(4), PrecioVenta = Data.IsDBNull(5) ? 0 : Data.GetDouble(5), FechaCotizacion = Data.IsDBNull(6) ? DateTime.Now : Data.GetDateTime(6), FechaCompra = Data.IsDBNull(7) ? DateTime.Now : Data.GetDateTime(7), FechaVenta = Data.IsDBNull(8) ? DateTime.Now : Data.GetDateTime(8), Estatus = Data.IsDBNull(9) ? 0 : Data.GetInt32(9), Pedido = Data.IsDBNull(10) ? 0 : Data.GetInt32(10), TipoProducto = Data.IsDBNull(11) ? 0 : Data.GetInt32(11), Cliente = Data.IsDBNull(12) ? 0 : Data.GetInt32(12), }); } Data.Close(); List.ForEach(item => { item.Ecom_ProductoTipo_ = new Ecom_ProductoTipo(Data_DBConnection_); item.Ecom_ProductoTipo_.Get(item.TipoProducto); }); } else { Data_DBConnection_.Message = "Sin registros"; } return(List); } catch (Ecom_Exception ex) { throw ex; } finally { if (Data != null) { Data.Close(); } } }
private List <Ecom_Inversiones> ReadDatReader(string Statement) { List <Ecom_Inversiones> List = null; MySqlDataReader Data = null; try { Ecom_Tools.ValidDBobject(Data_DBConnection_); Data = Data_DBConnection_.DoQuery(Statement); List = new List <Ecom_Inversiones>(); if (Data.HasRows) { while (Data.Read()) { List.Add(new Ecom_Inversiones { Id = Data.IsDBNull(0) ? 0 : (int)Data.GetUInt32(0), TotalInversion = Data.IsDBNull(1) ? 0 : Data.GetDouble(1), Descripcion = Data.IsDBNull(2) ? "" : Data.GetString(2), FechaInversion = Data.IsDBNull(3) ? DateTime.Now : Data.GetDateTime(3), Inversionista = Data.IsDBNull(4) ? 0 : Data.GetInt32(4), Pedido = Data.IsDBNull(5) ? 0 : Data.GetInt32(5), TotalRecuperado = Data.IsDBNull(6) ? 0 : Data.GetDouble(6), FechaRecuperado = Data.IsDBNull(7) ? DateTime.Now : Data.GetDateTime(7), Estatus = Data.IsDBNull(8) ? 0: Data.GetInt32(8), }); } Data.Close(); List.ForEach(item => { item.Ecom_Inversionista_ = new Ecom_Inversionista(Data_DBConnection_); item.Ecom_Inversionista_.Get(item.Inversionista); }); } else { Data_DBConnection_.Message = "Sin registros"; } return(List); } catch (Ecom_Exception ex) { throw ex; } finally { if (Data != null) { Data.Close(); } } }
private List <Ecom_Pedido> ReadDatReader(string Statement) { List <Ecom_Pedido> List = null; MySqlDataReader Data = null; try { Ecom_Tools.ValidDBobject(Data_DBConnection_); Data = Data_DBConnection_.DoQuery(Statement); List = new List <Ecom_Pedido>(); if (Data.HasRows) { while (Data.Read()) { List.Add(new Ecom_Pedido { Id = Data.IsDBNull(0) ? 0 : (int)Data.GetUInt32(0), Total = Data.IsDBNull(1) ? 0 : Data.GetDouble(1), FechaCompra = Data.IsDBNull(2) ? DateTime.Now : Data.GetDateTime(2), Estatus = Data.IsDBNull(3) ? 0 : Data.GetInt32(3), Proveedor = Data.IsDBNull(4) ? 0 : Data.GetInt32(4), }); } Data.Close(); List.ForEach(item => { item.Ecom_Proveedor_ = new Ecom_Proveedor(Data_DBConnection_); item.Ecom_Proveedor_.Get(item.Proveedor); }); } else { Data_DBConnection_.Message = "Sin registros"; } return(List); } catch (Ecom_Exception ex) { throw ex; } finally { if (Data != null) { Data.Close(); } } }
private List <Ecom_PedidoAjuste> ReadDatReader(string Statement) { List <Ecom_PedidoAjuste> List = null; MySqlDataReader Data = null; try { Ecom_Tools.ValidDBobject(Data_DBConnection_); Data = Data_DBConnection_.DoQuery(Statement); List = new List <Ecom_PedidoAjuste>(); if (Data.HasRows) { while (Data.Read()) { List.Add(new Ecom_PedidoAjuste { Id = Data.IsDBNull(0) ? 0 : (int)Data.GetUInt32(0), Total = Data.IsDBNull(1) ? 0 : Data.GetDouble(1), Tipo = Data.IsDBNull(2) ? 0 : Data.GetInt32(2), Pedido = Data.IsDBNull(3) ? 0 : Data.GetInt32(3), Descripcion = Data.IsDBNull(4) ? "" : Data.GetString(4) }); } Data.Close(); } else { Data_DBConnection_.Message = "Sin registros"; } return(List); } catch (Ecom_Exception ex) { throw ex; } finally { if (Data != null) { Data.Close(); } } }
private List <Ecom_Proveedor> ReadDatReader(string Statement) { List <Ecom_Proveedor> List = null; MySqlDataReader Data = null; try { Ecom_Tools.ValidDBobject(Data_DBConnection_); Data = Data_DBConnection_.DoQuery(Statement); List = new List <Ecom_Proveedor>(); if (Data.HasRows) { while (Data.Read()) { List.Add(new Ecom_Proveedor { Id = Data.IsDBNull(0) ? 0 : (int)Data.GetUInt32(0), Nombre = Data.IsDBNull(1) ? "" : Data.GetString(1), Telefono = Data.IsDBNull(2) ? "" : Data.GetString(2), Direccion = Data.IsDBNull(3) ? "" : Data.GetString(3), }); } Data.Close(); } else { Data_DBConnection_.Message = "Sin registros"; } return(List); } catch (Ecom_Exception ex) { throw ex; } finally { if (Data != null) { Data.Close(); } } }
private List <Ecom_Abono> ReadDatReader(string Statement) { List <Ecom_Abono> List = null; MySqlDataReader Data = null; try { Ecom_Tools.ValidDBobject(Data_DBConnection_); Data = Data_DBConnection_.DoQuery(Statement); List = new List <Ecom_Abono>(); if (Data.HasRows) { while (Data.Read()) { List.Add(new Ecom_Abono { Id = Data.IsDBNull(0) ? 0 : (int)Data.GetUInt32(0), Total = Data.IsDBNull(1) ? 0 : Data.GetDouble(1), Fecha = Data.IsDBNull(2) ? DateTime.Now : Data.GetDateTime(2), Cliente = Data.IsDBNull(3) ?0 : Data.GetInt32(3), }); } Data.Close(); } else { Data_DBConnection_.Message = "Sin registros"; } return(List); } catch (Ecom_Exception ex) { throw ex; } finally { if (Data != null) { Data.Close(); } } }