//Get all register ids stored in memory
private List<SingleRegister_AllTransactions> getRegistersFromMemory()
{
List<SingleRegister_AllTransactions> result =
new List<SingleRegister_AllTransactions>();
string query = "SELECT * FROM CashRegister";
MySqlDataReader queryOutcome =
_singletonConnection.queryResult(query);
//If there is a connection
if (queryOutcome != null)
{
//If bundle info is found
while (queryOutcome.Read())
{
string Registername = "Register " + result.Count;
SingleRegister_AllTransactions Register =
new SingleRegister_AllTransactions(
queryOutcome[0].ToString(), Registername, "register");
result.Add(Register);
}
}
else
{
}
return result;
}
//Function adds a certain id for a register and return the its index no.
public int addRegister(string id)
{
_singletonConnection.insertToDB(string.Format(
("INSERT INTO CashRegister (registerId) VALUES ('{0}')"), id));
string Registername = "Register " + getRegisterTransactionCount();
SingleRegister_AllTransactions Register =
new SingleRegister_AllTransactions(id, Registername, "register");
AllRegister_AllTransactions.Add(Register);
//update register list
return AllRegister_AllTransactions.Count - 1;
}
