public static bool ReloadCashbox(Cashbox cashbox) { string query = "SELECT box_name, balance, date_of_close, base FROM cashbox WHERE cashbox_id = " + cashbox.ID; query += " LIMIT 1"; if (HacerConsulta(query)) { reader.Read(); cashbox.BoxName = reader.GetString("box_name"); cashbox.Balance = reader.GetDecimal("balance"); cashbox.FechaDeCierre = reader.IsDBNull(2) ? (DateTime?)null : reader.GetDateTime("date_of_close"); cashbox.BaseDeCaja = reader.IsDBNull(3) ? (decimal?)null : reader.GetDecimal("base"); return(true); } return(false); }
public static List <Cashbox> ReadAllCashbox(int userId) { List <Cashbox> result = new List <Cashbox>(); string query = "SELECT * FROM cashbox WHERE user_id = " + userId; if (HacerConsulta(query)) { while (reader.Read()) { int id = reader.GetInt32("cashbox_id"); string name = reader.GetString("box_name"); decimal balance = reader.GetDecimal("balance"); DateTime?fechaDeCorte = reader.IsDBNull(4) ? (DateTime?)null : reader.GetDateTime(4); decimal? baseDeCaja = reader.IsDBNull(5) ? (decimal?)null : reader.GetDecimal(5); Cashbox cBox = new Cashbox(id, name, balance, fechaDeCorte, baseDeCaja); result.Add(cBox); } } return(result); }