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