public static void UpdateCoinBalance(int idCashier, CoinBalanceDTO coinBalance)
{
var dbConnection = SQLiteAccess.CreateConnection();
dbConnection.Open();
UpdateCoinBalance(idCashier, coinBalance, dbConnection);
dbConnection.Close();
dbConnection.Dispose();
}
public static void UpdateCashierBalance(int idCashier, List <CoinBalanceDTO> newCashierCoinBalance)
{
var dbConnection = SQLiteAccess.CreateConnection();
dbConnection.Open();
foreach (CoinBalanceDTO coinBalance in newCashierCoinBalance)
{
UpdateCashierBalance(idCashier, coinBalance, dbConnection);
}
dbConnection.Close();
dbConnection.Dispose();
}
public static CashierDTO GetCashier(int idCashier)
{
CashierDTO cashier = null;
var dbConnection = SQLiteAccess.CreateConnection();
dbConnection.Open();
using (var dbCommand = new System.Data.SQLite.SQLiteCommand(dbConnection))
{
dbCommand.CommandText = @"
SELECT ID_CASHIER, DESCRIPTION
FROM CASHIER
WHERE ID_CASHIER = @ID_CASHIER";
dbCommand.Parameters.AddWithValue("@ID_CASHIER", idCashier);
/*
* IF YOU ARE GETTING AN EXCEPTION HERE IT'S PROBABLY BECAUSE I COULDN'T CONFIGURE THE DATABASE PROPERLY
* IT IS THE FILE "CoinCashierDB.db" IN CoinCashierDAL THAT IS NOT BEING COPYED TO WHERE VISUAL STUDIO RUN THE APPLICATION
* (the "WebSiteCoinCashier\bin" folder)
*/
using (var reader = dbCommand.ExecuteReader())
{
if (reader.Read())
{
cashier = new CashierDTO()
{
idCashier = Convert.ToInt32(reader["ID_CASHIER"]),
description = reader["DESCRIPTION"].ToString()
};
}
}
}
if (cashier != null)
{
cashier.coinBalanceDTOs = CoinBalanceDAL.GetCoinBalance(idCashier, dbConnection);
}
dbConnection.Close();
dbConnection.Dispose();
return(cashier);
}