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);
}
