public void CreateServer(string firstname, string lastname, int age, char sex)
{
MenuDbManager db = new MenuDbManager(DBManager.defaultDbLocation);
db.Connect();
db.InsertServer(firstname, lastname, age, sex);
db.Close();
serverList.Add(new Server(firstname, lastname, age, sex));
}
public void CreateMenuItem(string itemName, string type, double price, double cost)
{
MenuDbManager db = new MenuDbManager(DBManager.defaultDbLocation);
db.Connect();
db.InsertMenu(itemName, type, price, cost);
db.Close();
this.itemList = new List <MenuItem>();
LoadMenuItems();
}
public void CreateOrder(int serverId, DateTime?saleDate, string mealType, List <KeyValuePair <int, int> > itemId_Amount)
{
MenuDbManager db = new MenuDbManager(DBManager.defaultDbLocation);
db.Connect();
OleDbDataReader reader = db.Execute("select max(GROUP_ID) from [Order]");
bool hasValues = reader.Read() && !reader.IsDBNull(0);
//if Order table is empty, id = 0, else = max + 1
int groupId = hasValues ? Convert.ToInt16(reader[0]) + 1 : 0;
db.InsertOrder(groupId, serverId, saleDate.ToString(), mealType);
foreach (var k in itemId_Amount)
{
db.InsertOrderItem(groupId, k.Key, k.Value);
}
db.Close();
this.orderList = new List <Order>();
LoadOrders();
}
public void LoadMenuItems()
{
MenuDbManager db = new MenuDbManager(DBManager.defaultDbLocation);
db.Connect();
dataTable = db.GetTable(MenuDbManager.Table.MENU);
foreach (DataRow row in dataTable.Rows)
{
MenuItem item = new MenuItem();
item.id = Convert.ToInt16(row["ID"]);
item.itemName = row["ITEM_NAME"].ToString();
item.type = row["TYPE"].ToString();
item.price = Convert.ToDouble(row["PRICE"]);
item.cost = Convert.ToDouble(row["COST"]);
itemList.Add(item);
}
db.Close();
}
public void LoadServers()
{
MenuDbManager db = new MenuDbManager(DBManager.defaultDbLocation);
db.Connect();
dataTable = db.GetTable(MenuDbManager.Table.SERVER);
// Load all Servers into Session Variable
foreach (DataRow r in dataTable.Rows)
{
Server server = new Server();
server.id = Convert.ToInt16(r["ID"]);
server.firstname = r["FIRST_NAME"].ToString();
server.lastname = r["LAST_NAME"].ToString();
server.age = Convert.ToInt16(r["AGE"]);
server.sex = Convert.ToChar(r["SEX"]);
serverList.Add(server);
}
db.Close();
}
public void LoadOrders()
{
String dbLocation = HostingEnvironment.MapPath(System.IO.Path.Combine("~/App_Data/", Constants.DB_NAME));
MenuDbManager db = new MenuDbManager(DBManager.defaultDbLocation);
db.Connect();
orderDataTable = db.GetTable(MenuDbManager.Table.ORDERS);
// Load all MenuItems into Session Variable
foreach (DataRow row in orderDataTable.Rows)
{
Order order = new Order();
order.groupId = Convert.ToInt16(row["GROUP_ID"]);
order.serverId = Convert.ToInt16(row["SERVER_ID"]);
order.mealType = row["MEAL_TYPE"].ToString();
orderList.Add(order);
}
List <OrderItem> orderItems = new List <OrderItem>();
orderItemDataTable = db.GetTable(MenuDbManager.Table.ORDER_ITEM);
foreach (DataRow row in orderItemDataTable.Rows)
{
OrderItem item = new OrderItem();
item.groupId = Convert.ToInt16(row["GROUP_ID"]);
item.itemId = Convert.ToInt16(row["ITEM_ID"]);
item.amount = Convert.ToInt16(row["AMOUNT"]);
orderItems.Add(item);
}
foreach (Order o in this.orderList)
{
var results = orderItems.FindAll(i => i.groupId == o.groupId);
o.orderItems = results;
}
db.Close();
}