/// <summary> /// Create a Customer /// </summary> public void Create() { if (Id == 0) { try { Database db = new Database("setCustomer"); db.Bind("firstname", Firstname); db.Bind("lastname", Lastname); db.Bind("phone", Phone); db.Bind("email", Email); Dictionary<string, object> data = db.GetProcedure(); if(data.Count == 1) { customerId = (int)data["id"]; } else if(data.Count > 1) { customerId = (int)data["id"]; Firstname = (string)data["firstname"]; Lastname = (string)data["lastname"]; telephone = (string)data["phone"]; Email = (string)data["email"]; } } catch (Exception exc) { Log.Record(exc); } } }
public void Create() { try { // Create item Database db = new Database("setItem"); db.Bind("name", Name); db.Bind("stock", 0); Dictionary<string, object> data = db.GetProcedure(); itemId = (int)data["id"]; // Adding item properties if(machines.Count > 0) { // Generate Multi Insert query string query = null; foreach (KeyValuePair<int,int> item in machines) { if(query != null) { query += String.Format(",({0},{1},{2})", Id, item.Key, item.Value); } else { query += String.Format("INSERT INTO [itemProp] ([itemId],[machineId],[amount]) VALUES({0},{1},{2})", Id, item.Key, item.Value); } } // Insert data new Database(query).Execute(); } } catch (Exception exc) { Log.Record(exc); } }
private void Load() { Database db = new Database("getItemProp"); db.Bind("id", itemId); List<Dictionary<string,object>> datalist = db.FetchProcedure(); if(datalist != null) { foreach (Dictionary<string,object> item in datalist) { int id = (int)item["machineId"]; int num = (int)item["amount"]; machines.Add(id, num); } } }
public void Remove() { if(Id != 0) { Database db = new Database("removeOrder"); db.Bind("id", Id); db.Procedure(); } }
public void Sync() { try { if (Id == 0) { Database db = new Database("addOrder"); db.Bind("customer", customerId); db.Bind("order", OrderDate); db.Bind("expect", ExpectDate); Dictionary<string, object> data = db.GetProcedure(); if (data != null) { orderId = (int)data["id"]; } } else { orderlines = OrderLine.GetOrderLine(Id); } } catch (Exception exc) { Log.Record(exc); } }
public static List<Order> GetOrders(int id) { Database db = new Database("getOrder"); db.Bind("id", id); List<Dictionary<string, object>> data = db.FetchProcedure(); if (data != null) { List<Order> orders = new List<Order> { }; foreach (Dictionary<string, object> item in data) { int oid = (int)item["id"]; int cid = (int)item["customerId"]; DateTime oDate = (DateTime)item["orderDate"]; DateTime eDate = (DateTime)item["expectDate"]; DateTime? dDate = item["deliverDate"] as DateTime?; orders.Add(new Order(oid, cid, oDate, eDate, dDate)); } return orders; } else { return null; } }
public void Add() { if(Id == 0 && Firstname != null && Lastname != null && Username != null) { try { Database db = new Database("setEmployee"); db.Bind("user", Username); db.Bind("firstname", Firstname); db.Bind("lastname", Lastname); Dictionary<string, object> data = db.GetProcedure(); employeeId = (int)data["id"]; userName = (string)data["user"]; Firstname = (string)data["firstname"]; Lastname = (string)data["lastname"]; } catch (Exception exc) { Log.Record(exc); } } }
public static List<OrderLine> GetOrderLine(int order) { try { Database db = new Database("getOrderLine"); db.Bind("id", order); List<Dictionary<string,object>> datalist = db.FetchProcedure(); if(datalist != null) { List<OrderLine> items = new List<OrderLine> { }; foreach(Dictionary<string, object> item in datalist) { int oid = (int)item["orderId"]; int iid = (int)item["itemId"]; int num = (int)item["quantity"]; items.Add(new OrderLine(oid, iid, num, true)); } return items; } else { return null; } } catch(Exception exc) { Log.Record(exc); return null; } }
public void Sync() { try { // Synchronize data Database db = new Database("addItems"); db.Bind("order", OrderId); db.Bind("item", ItemId); db.Bind("num", Quantity); db.Procedure(); } catch (Exception exc) { Log.Record(exc); } }
/// <summary> /// Remove OrderLine from database /// </summary> public void Remove() { try { Database db = new Database("removeOrderLine"); db.Bind("order", OrderId); db.Bind("item", ItemId); db.Procedure(); } catch (Exception exc) { Log.Record(exc); } }