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