public List <Consumo> ConsumoCuenta(int id) { List <Consumo> consumos = new List <Consumo>(); SqlConnection conn = new SqlConnection( ConfigurationManager .ConnectionStrings["conn"] .ConnectionString); try { SqlCommand cmd = new SqlCommand("OBTENER_CONSUMOS_POR_USUARIO", conn); conn.Open(); cmd.Parameters.AddWithValue("@ID", id); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { Consumo consumodiario = new Consumo(); consumodiario.Fecha = Convert.ToDateTime(sdr["fecha"].ToString()); consumodiario.Cantidad = Convert.ToDouble(sdr["cantidad"].ToString()); consumodiario.IdUsuario = Convert.ToInt32(sdr["idUsuario"].ToString()); consumodiario.Id = Convert.ToInt32(sdr["id"].ToString()); consumodiario.Costototal = Convert.ToDouble(sdr["costototal"].ToString()); consumos.Add(consumodiario); } } catch (Exception e) { } finally { conn.Close(); } return(consumos); }
public bool CrearTicket(Consumo c) { bool retorno = false; SqlConnection conn = new SqlConnection( ConfigurationManager .ConnectionStrings["conn"] .ConnectionString); try { SqlCommand cmd = new SqlCommand("GENERAR_TICKET", conn); conn.Open(); cmd.Parameters.AddWithValue("@FECHA", Convert.ToDateTime(c.Fecha)); cmd.Parameters.AddWithValue("@CANTIDAD", c.Cantidad); cmd.Parameters.AddWithValue("@IDUSUARIO", c.idUsuario); cmd.Parameters.AddWithValue("@COSTO", c.Costototal); cmd.CommandType = System.Data.CommandType.StoredProcedure; int res = cmd.ExecuteNonQuery(); if (res == 1) { retorno = true; } } catch (Exception e) { } finally { conn.Close(); } return(retorno); }