public List <Estatus> Estatus(DateTime fecha1, DateTime fecha2) { fecha1 = Convert.ToDateTime(fecha1.ToShortDateString()); fecha2 = Convert.ToDateTime(fecha2.ToShortDateString()); fecha1 = Convert.ToDateTime(fecha1); fecha2 = Convert.ToDateTime(fecha2); List <Estatus> lista = new List <Estatus>(); using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = " select*from Modifica"; using (PgSqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read() == true) { DateTime fechaRegistro = dr.GetDateTime("fecha"); if ((fechaRegistro >= fecha1) && (fechaRegistro <= fecha2)) { lista.Add(new Estatus(dr.GetDecimal("modificaciones"), dr.GetString("tipo"), dr.GetDateTime("fecha"))); } } dr.Close(); } } return(lista); }
public decimal getNumero() { decimal total = 0; using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "select *from Numero"; using (PgSqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read() == true) { total = (dr.GetDecimal("numero")); } } } return(total); }
public decimal VerTotal() { decimal total = 0; using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "select *from Caja WHERE id=1;"; //SELECT *FROM productos WHERE codigo = '123456' using (PgSqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read() == true) { total = (dr.GetDecimal("total")); } } } return(total); }
public List <Estatus> Estatus() { List <Estatus> lista = new List <Estatus>(); using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = " select*from Modifica"; using (PgSqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read() == true) { lista.Add(new Estatus(dr.GetDecimal("modificaciones"), dr.GetString("tipo"), dr.GetDateTime("fecha"))); } dr.Close(); } } return(lista); }
public bool Existencia(int id) { bool ex = false; using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "select *from inventario WHERE id=" + id + ""; //SELECT *FROM productos WHERE codigo = '123456' using (PgSqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read() == true) { if ((dr.GetDecimal("existencias") >= 1)) { ex = true; } } } } return(ex); }
public bool GetDecimal(string query, string field, out decimal value) { bool found = false; value = 0; using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = query; using (PgSqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read() == true) { value = dr.GetDecimal(field); found = true; } dr.Close(); } } return(found); }
public Producto ObtenerProductoNombre(string Nombre) { Producto pro = new Producto(); using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = " select *FROM productos WHERE descripcion='" + Nombre + "'"; ///select *FROM ventas WHERE fecha_venta= '2015/12/12' using (PgSqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read() == true) { pro = new Producto(dr.GetInt32("id"), dr.GetString("codigo"), dr.GetString("descripcion"), dr.GetDecimal("precio")); } dr.Close(); } return(pro); } }
public List <Ventas> ObtenerListaVENTASDelDía() { List <Ventas> listpro = new List <Ventas>(); DateTime fechaActual = DateTime.Today; using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = " SELECT * FROM ventas ORDER BY id"; ///select *FROM ventas WHERE fecha_venta= '2015/12/12' using (PgSqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read() == true) { DateTime fechaDeVenta = dr.GetDateTime("fecha_venta"); if (fechaDeVenta == fechaActual) { listpro.Add(new Ventas(dr.GetInt32("id_productos"), dr.GetInt32("cantidad"), dr.GetDecimal("precio_de_venta"), dr.GetDateTime("fecha_venta"))); } } dr.Close(); } } return(listpro); }
public Producto ObtenerProductoPorCodigo_barras(string CodigoDeBarra) { Producto pro = new Producto(); using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = " SELECT * FROM productos WHERE codigo = '" + CodigoDeBarra + "'"; //SELECT *FROM productos WHERE codigo = '123456' using (PgSqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read() == true) { pro = (new Producto(dr.GetInt32("id"), dr.GetString("codigo"), dr.GetString("descripcion"), dr.GetDecimal("precio"))); } } } return(pro); }
public List <Producto> ObtenerTodosLosProductos() { List <Producto> pro = new List <Producto>(); using (PgSqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = " SELECT * FROM productos"; //SELECT *FROM productos WHERE codigo = '123456' using (PgSqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read() == true) { pro.Add(new Producto(dr.GetInt32("id"), dr.GetString("codigo"), dr.GetString("descripcion"), dr.GetDecimal("precio"))); } } } return(pro); }