public void getOrderID()
{
try
{
//get the last order ID
OleDbCommand cmd = new OleDbCommand();
OleDbDataAdapter oleda = new OleDbDataAdapter();
DataSet ds = new DataSet();
cmd.Connection = oledbConn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT TOP 1 [OrderID] FROM [Order Details$] ORDER BY [OrderID] DESC";
oleda = new OleDbDataAdapter(cmd);
oleda.Fill(ds);
oleda.Dispose();
string OrderID = ds.Tables[0].Rows[0]["OrderID"].ToString();
int orID = Convert.ToInt32(OrderID) + 1;
//strring up order ID with the 0 padding
CurrentOrderID = orID.ToString().PadLeft(6, '0');
}
catch (Exception OrderIDs)
{
MessageBox.Show(OrderIDs.ToString());
}
}
public void SaleByOrder(Order order)
{
Cost -= GetCost();
Borrow -= GetBorrow();
Count -= SaleCount;
SaleCount = 0;
OrderIDs.Add(order.ID);
}
private int GetBorrowInterest(DateTime date)
{
int borrow = GetBorrow();
Order buyin = ((List <Order>)DBManager.share.GetAllListFromTable(Order.TABLE_NAME, typeof(Order))).Find(x => x.ID == OrderIDs.First());
return((int)(borrow * 0.05 * (new TimeSpan(date.Ticks - buyin.Date.Ticks).TotalDays + 2) / 365));
}
