public string AddOrUpdateOrderBasicInfo(Order order, string newOrderIDForAddOrder)
{
Table <DAL.OrderBasicInfo> orderTable = GetOrderBasicInfoTable();
var matchedRes = (from o in orderTable
where o.orderID == order.OrderID
select o).FirstOrDefault();
string orderID = "";
if (matchedRes == null)
{
DAL.OrderBasicInfo newData = new DAL.OrderBasicInfo();
try
{
newData.orderID = newOrderIDForAddOrder;
newData.dateCreated = order.DateCreated;
newData.priorityNumber = order.PriorityNumber;
newData.totalPayment = order.TotalPayment;
newData.charge = order.ChargedMoney;
newData.orderStatusCode = GetOrderStatusCode(order.Status);
newData.cashierID = ParameterManager.GetCurrentStaff().StaffID;
orderTable.InsertOnSubmit(newData);
orderTable.Context.SubmitChanges();
orderID = newData.orderID;
}
catch (Exception ex)
{
return(ex.Message);
}
}
else
{
try
{
matchedRes.orderStatusCode = GetOrderStatusCode(order.Status);
db.SubmitChanges();
orderID = matchedRes.orderID;
}
catch (Exception ex)
{
return(ex.Message);
}
}
return("");
}
public string AddStockOrder(StockOrder newStockOrder)
{
Table <DAL.StockOrder> stockOrderTable = GetStockOrderTable();
DAL.StockOrder stockOrder = new DAL.StockOrder();
try
{
Random rnd = new Random();
stockOrder.stockOrderID = rnd.Next().ToString(); // Dummy init
stockOrder.charge = 0;
stockOrder.chargedWarehouseManager = ParameterManager.GetCurrentStaff().StaffID;
stockOrder.totalPayment = newStockOrder.TotalPayment;
stockOrder.dateCreated = newStockOrder.DateCreated;
stockOrderTable.InsertOnSubmit(stockOrder);
stockOrderTable.Context.SubmitChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
var matchedRes = (from stock in stockOrderTable
where stock.dateCreated == newStockOrder.DateCreated && stock.totalPayment == newStockOrder.TotalPayment && stock.chargedWarehouseManager == ParameterManager.GetCurrentStaff().StaffID
select stock).FirstOrDefault();
if (matchedRes == null)
{
return("Some error occur while retrieve the stock order ID");
}
string stockOrderID = matchedRes.stockOrderID;
foreach (StockOrderDetails details in newStockOrder.GetStockOrderDetails())
{
string err = AddStockOrderDetails(stockOrderID, details.Quantity, details.Details.Ingredient.Name);
if (err != "")
{
return(err);
}
}
return("");
}
private void DisplayInfoOnScreen()
{
bunifuCustomTextbox_NameOfKeeper.Text = ParameterManager.GetCurrentStaff().FullName;
bunifuCustomTextbox_DateCreated.Text = DateTime.Now.ToString();
}
private void AddRecommendData()
{
bunifuDropdown_Status.Items = manager.GetOrderStatusList().ToArray();
bunifuCustomTextbox_CashierName.Text = ParameterManager.GetCurrentStaff().FullName;
bunifuCustomTextbox_CurentTime.Text = DateTime.Now.ToString();
}