private void Category3Button_Click(object sender, EventArgs e)
{
//get item qty
CCategoryButton tempCategory3Button = (CCategoryButton)sender;
RMSGlobal.m_sellinginvalue = tempCategory3Button.SellingQuantityorWeight; //Used to identify the product whether sold in quantity or weight
int tempCategory3ID = tempCategory3Button.CategoryID;
if (m_bItemDescriptionClicked)
{
string tempItemDescription = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCategory3ID)[0]["description"].ToString();
if (!tempItemDescription.Equals(""))
{
CMessageBox tempMessageBox = new CMessageBox("Item Description", tempItemDescription);
tempMessageBox.ShowDialog();
}
else
{
CMessageBox tempMessageBox = new CMessageBox("Item Description", "No information available.");
tempMessageBox.ShowDialog();
}
m_bItemDescriptionClicked = false;
return;
}
int tempFoodType = int.Parse(Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCategory3ID)[0].GetParentRow(Program.initDataSet.Relations["category2_to_category3"])["cat2_type"].ToString());
DataGridView tempDataGridView = new DataGridView();
if (tempFoodType == 0)
{
tempDataGridView = g_BeverageDataGridView;
}
else
{
tempDataGridView = g_FoodDataGridView;
}
DataRow[] tempDataRowArray = Program.initDataSet.Tables["Category4"].Select("cat3_id = " + tempCategory3ID.ToString());
category4ButtonList.Clear();
COrderInfoDAO aOrderInfoDao = new COrderInfoDAO();
COrderInfo aCOrderInfo = aOrderInfoDao.GetOrderInfoByOrderID(orderID);
if (tempDataRowArray.Length != 0)
{
foreach (DataRow tempDataRow in tempDataRowArray)
{
if (Int32.Parse(tempDataRow["status"].ToString()) == 0)
{
continue;
}
CCategoryButton tempCategoryButton = new CCategoryButton();
tempCategoryButton.CategoryID = int.Parse(tempDataRow["cat4_id"].ToString());
tempCategoryButton.CategoryOrder = int.Parse(tempDataRow["cat4_order"].ToString());
tempCategoryButton.CategoryLevel = 4;
tempCategoryButton.Text = tempDataRow["cat4_name"].ToString();
tempCategoryButton.BackColor = tempCategory3Button.BackColor;
category4ButtonList.Add(tempCategoryButton);
}
keyboardForm.Hide();
CCategory4Form tempCategory4Form = new CCategory4Form(tempCategory3ID, category4ButtonList, tempCategory3Button.Text);
tempCategory4Form.ShowDialog();
CCategoryButton tempCategory4Button = CCategory4Form.m_cbResult;
m_iSavedOrderedQty = CCategory4Form.ItemQTY;
if (tempCategory4Button == null)
{
return;
}
else //insert into table and datagridview
{
DataRow[] temp2DataRowArray = Program.initDataSet.Tables["Category4"].Select("cat4_id = " + tempCategory4Button.CategoryID.ToString());
if (temp2DataRowArray.Length != 0)
{
//category4 + categpry3
string ItemName = temp2DataRowArray[0]["cat4_name"].ToString() + " " + tempCategory3Button.Text;
string tableTypePrice = string.Empty;
if (m_iType == m_cCommonConstants.TableType)
{
tableTypePrice = temp2DataRowArray[0]["table_price"].ToString();
}
else if (m_iType == m_cCommonConstants.TakeAwayType)
{
tableTypePrice = temp2DataRowArray[0]["tw_price"].ToString();
}
int tempSearchResult = FindExistingItem(tempDataGridView, ItemName);
// vat_included
double vatRate = 0;
bool vat_included = false;
double vatAmountRate = 0;
try
{
vatRate = Convert.ToDouble(temp2DataRowArray[0]["vat_Rate"].ToString());
vat_included = Convert.ToBoolean(temp2DataRowArray[0]["vat_included"].ToString());
if (vat_included)
{
vatAmountRate = (Double.Parse(tableTypePrice) * vatRate) / 100;
// tableTypePrice = (Double.Parse(tableTypePrice) - vatAmountRate).ToString();
tableTypePrice = Convert.ToDouble(tableTypePrice).ToString();
}
else
{
vatAmountRate = 0.00;
}
}
catch (Exception ex) { }
COrderManager tempOrderManager = new COrderManager();
COrderDetails tempOrderDetails = new COrderDetails();
if (tempSearchResult != -1)
{
int tempRowIndex = tempSearchResult;
int qty = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString()) + m_iSavedOrderedQty;
tempDataGridView.Rows[tempRowIndex].Cells[1].Value = qty;
tempDataGridView.Rows[tempRowIndex].Cells[3].Value = ((double)(Double.Parse(tableTypePrice) * qty)).ToString("F02");
//update Order_details table
tempOrderDetails.OrderID = orderID;
tempOrderDetails.OrderDetailsID = Int64.Parse(tempDataGridView.Rows[tempRowIndex].Cells[7].Value.ToString());
tempOrderDetails.ProductID = tempCategory4Button.CategoryID;
tempOrderDetails.CategoryLevel = tempCategory4Button.CategoryLevel;
tempOrderDetails.OrderQuantity = qty;
tempOrderDetails.UnitPrice = Convert.ToDouble(tableTypePrice);
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(tableTypePrice);
tempOrderDetails.OrderFoodType = tempFoodType == 1 ? ("Food") : ("Nonfood");
tempOrderDetails.OnlineItemSequenceNumber = Int64.Parse(tempDataGridView.Rows[tempRowIndex].Cells[6].Value.ToString());
tempOrderDetails.PrintedQuantity = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[8].Value.ToString());
if (aCOrderInfo.VatComplementory) vatRate =vatAmountRate= 0;
if (vat_included)
{
// tempOrderDetails.VatTotal = tempOrderDetails.OrderAmount * vatAmountRate;
tempOrderDetails.VatTotal = qty * vatAmountRate;
tempDataGridView.Rows[tempRowIndex].Cells[2].Value = qty * vatAmountRate;
}
else
{
tempOrderDetails.VatTotal = tempOrderDetails.OrderAmount * (vatRate / 100);
}
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
}
else
{
tempOrderManager.UpdateOnlineOrderDetails(tempOrderDetails);//for online orders
}
}
else
{
//Insert into Order_details table
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = tempCategory4Button.CategoryID;
tempOrderDetails.CategoryLevel = tempCategory4Button.CategoryLevel;
tempOrderDetails.OrderQuantity = m_iSavedOrderedQty;
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(tableTypePrice);
tempOrderDetails.OrderFoodType = tempFoodType == 1 ? ("Food") : ("Nonfood");
tempOrderDetails.ItemOrderTime = DateTime.Now.Ticks;
tempOrderDetails.UnitPrice = Convert.ToDouble(tableTypePrice);
// tempOrderDetails.Product_Name = temp2DataRowArray[0]["cat3_name"].ToString();
if (aCOrderInfo.VatComplementory) vatRate = 0;
if (vat_included)
{
tempOrderDetails.VatTotal = 0;
tempOrderDetails.VatTotal = tempOrderDetails.OrderAmount * (vatRate / 100);
// tempOrderDetails.VatTotal = tempOrderDetails.OrderAmount * vatAmountRate;
}
else
{
tempOrderDetails.VatTotal = tempOrderDetails.OrderAmount * (vatRate / 100);
}
tempOrderDetails.Amount_with_vat = tempOrderDetails.OrderAmount + tempOrderDetails.VatTotal;
string category1ID = this.GetCategory1ID(tempOrderDetails.ProductID, tempOrderDetails.CategoryLevel);
//Int32 cat1Order = this.GetCategory1OrderNumber(Convert.ToInt32(category1ID)); // Change by Mithu
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
tempOrderDetails = (COrderDetails)tempOrderManager.InsertOrderDetails(tempOrderDetails).Data;
string[] tempDataGridViewRow = new string[]
{ ItemName,
m_iSavedOrderedQty.ToString(),
((double)tempOrderDetails.VatTotal).ToString("F02"),
((double)(Double.Parse(tableTypePrice)*m_iSavedOrderedQty)).ToString("F02"),
tempCategory4Button.CategoryID.ToString(),
"4",
temp2DataRowArray[0]["cat4_rank"].ToString(),
tempOrderDetails.OrderDetailsID.ToString(),
"0",
tempOrderDetails.UnitPrice.ToString("F2")
};
tempDataGridView.Rows.Add(tempDataGridViewRow);
}
else //For online orders
{
tempOrderDetails.ItemName = ItemName;
tempOrderDetails = (COrderDetails)tempOrderManager.InsertOnlineOrderDetails(tempOrderDetails).Data;
string[] tempDataGridViewRow = new string[]
{ ItemName,
m_iSavedOrderedQty.ToString(),
((double)tempOrderDetails.VatTotal).ToString("F02"),
((double)(Double.Parse(tableTypePrice)*m_iSavedOrderedQty)).ToString("F02"),
tempCategory4Button.CategoryID.ToString(),
"4",
tempOrderDetails.OnlineItemSequenceNumber.ToString(),
tempOrderDetails.OrderDetailsID.ToString(),"0",
tempOrderDetails.UnitPrice.ToString("F2")
};
tempDataGridView.Rows.Add(tempDataGridViewRow);
}
}
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper()) //If local orders are considered
{
this.ConvertRank();
}
tempDataGridView.Sort(tempDataGridView.Columns[5], ListSortDirection.Ascending);
tempDataGridView.Update();
TotalAmountCalculation();
}
}
}
else //There is no category4
{
keyboardForm.Hide();
try
{
CCalculatorForm tempCalculatorForm = new CCalculatorForm("Order Quantity", "Item Quantity");
tempCalculatorForm.ShowDialog();
if (CCalculatorForm.inputResult.Equals("Cancel"))
return;
string str = CCalculatorForm.inputResult;
str = (str == "") ? "1" : str;
if (Int32.Parse(str) == 0)
{
CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!");
tempMessageBox.ShowDialog();
return;
}
int tempOrderedQty = Int32.Parse(str);
m_iSavedOrderedQty = tempOrderedQty;
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
DataGridViewRow tempDataGridViewRow = new DataGridViewRow();
tempDataGridViewRow.CreateCells(tempDataGridView);
DataRow[] temp2DataRowArray = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCategory3Button.CategoryID.ToString());
if (temp2DataRowArray.Length != 0)
{
string tableTypePrice = string.Empty;
if (m_iType == m_cCommonConstants.TableType)
{
tableTypePrice = temp2DataRowArray[0]["table_price"].ToString();
}
else if (m_iType == m_cCommonConstants.TakeAwayType)
{
tableTypePrice = temp2DataRowArray[0]["tw_price"].ToString();
}
// vat_included
double vatRate = 0;
bool vat_included = false;
double vatAmountRate = 0;
try
{
vatRate = Convert.ToDouble(temp2DataRowArray[0]["vat_Rate"].ToString());
vat_included = Convert.ToBoolean(temp2DataRowArray[0]["vat_included"].ToString());
if (vat_included)
{
vatAmountRate = (Double.Parse(tableTypePrice) * vatRate) / 100;
// tableTypePrice = (Double.Parse(tableTypePrice) - vatAmountRate).ToString();
tableTypePrice = Convert.ToDouble(tableTypePrice).ToString();
}
else
{
vatAmountRate = 0.00;
}
}
catch (Exception ex) { }
COrderManager tempOrderManager = new COrderManager();
COrderDetails tempOrderDetails = new COrderDetails();
int tempResult = FindExistingItem(tempDataGridView, temp2DataRowArray[0]["cat3_name"].ToString());
if (tempResult != -1)
{
//update Order_details table
int tempRowIndex = tempResult;
int qty = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString()) + m_iSavedOrderedQty;
tempDataGridView.Rows[tempRowIndex].Cells[1].Value = qty;
tempDataGridView.Rows[tempRowIndex].Cells[3].Value = ((double)(Double.Parse(tableTypePrice) * qty)).ToString("F02");
tempOrderDetails.OrderDetailsID = Int64.Parse(tempDataGridView.Rows[tempRowIndex].Cells[7].Value.ToString());
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = tempCategory3Button.CategoryID;
tempOrderDetails.CategoryLevel = tempCategory3Button.CategoryLevel;
tempOrderDetails.UnitPrice = Convert.ToDouble(tableTypePrice);
tempOrderDetails.OrderQuantity = qty;
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(tableTypePrice);
tempOrderDetails.OrderFoodType = tempFoodType == 1 ? ("Food") : ("Nonfood");
tempOrderDetails.OnlineItemSequenceNumber = Convert.ToInt64("0" + tempDataGridView.Rows[tempRowIndex].Cells[6].Value.ToString());
tempOrderDetails.PrintedQuantity = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[8].Value.ToString());
if (aCOrderInfo.VatComplementory) vatAmountRate = 0;
if (vat_included)
{
tempOrderDetails.VatTotal = qty * vatAmountRate;
tempDataGridView.Rows[tempRowIndex].Cells[2].Value = tempOrderDetails.VatTotal;
}
else
{
tempOrderDetails.VatTotal = 0.00;
}
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
}
else
{
tempOrderManager.UpdateOnlineOrderDetails(tempOrderDetails);
}
}
else
{
//Insert into Order_details table
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = tempCategory3Button.CategoryID;
tempOrderDetails.CategoryLevel = tempCategory3Button.CategoryLevel;
tempOrderDetails.UnitPrice = Convert.ToDouble(tableTypePrice);
tempOrderDetails.OrderQuantity = m_iSavedOrderedQty;
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(tableTypePrice);
tempOrderDetails.OrderFoodType = tempFoodType == 1 ? ("Food") : ("Nonfood");
tempOrderDetails.ItemOrderTime = DateTime.Now.Ticks;
tempOrderDetails.Product_Name = temp2DataRowArray[0]["cat3_name"].ToString();
tempOrderDetails.UOM = temp2DataRowArray[0]["uom"].ToString();
tempOrderDetails.Product_Type = temp2DataRowArray[0]["productType"].ToString();
if (aCOrderInfo.VatComplementory) vatRate = vatAmountRate = 0;
try
{
if (vat_included)
{
tempOrderDetails.VatTotal = 0;
tempOrderDetails.VatTotal = tempOrderDetails.OrderAmount * (vatRate / 100);
// tempOrderDetails.VatTotal = tempOrderDetails.OrderAmount * vatAmountRate;
}
else
{
tempOrderDetails.VatTotal = tempOrderDetails.OrderAmount * (vatRate / 100);
}
}
catch { }
try
{
tempOrderDetails.Amount_with_vat = tempOrderDetails.OrderAmount + tempOrderDetails.VatTotal;
}
catch { }
string category1ID = this.GetCategory1ID(tempOrderDetails.ProductID, tempOrderDetails.CategoryLevel);
Int32 cat1Order = this.GetCategory1OrderNumber(Convert.ToInt32(category1ID));
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
tempOrderDetails = (COrderDetails)tempOrderManager.InsertOrderDetails(tempOrderDetails).Data;
string[] temp2DataGridViewRow = new string[]
{ temp2DataRowArray[0]["cat3_name"].ToString(),
m_iSavedOrderedQty.ToString(),
tempOrderDetails.VatTotal.ToString("F2"),
((double)(Double.Parse(tableTypePrice)*m_iSavedOrderedQty)).ToString("F02"),
tempCategory3Button.CategoryID.ToString(),
"3",
temp2DataRowArray[0]["cat3_rank"].ToString(),
tempOrderDetails.OrderDetailsID.ToString(),"0",
tempOrderDetails.UnitPrice.ToString("F2")
};
tempDataGridView.Rows.Add(temp2DataGridViewRow);
}
else
{
tempOrderDetails.ItemName = temp2DataRowArray[0]["cat3_name"].ToString();
tempOrderDetails = (COrderDetails)tempOrderManager.InsertOnlineOrderDetails(tempOrderDetails).Data;
string[] temp2DataGridViewRow = new string[]
{temp2DataRowArray[0]["cat3_name"].ToString(),
m_iSavedOrderedQty.ToString(),
tempOrderDetails.VatTotal.ToString(),
((double)(Double.Parse(tableTypePrice)*m_iSavedOrderedQty)).ToString("F02"),
tempCategory3Button.CategoryID.ToString(),
"3",
tempOrderDetails.OnlineItemSequenceNumber.ToString(),//For online order sequence number is category rank.
tempOrderDetails.OrderDetailsID.ToString(),"0", //0 For first time.
tempOrderDetails.UnitPrice.ToString("F2")
};
tempDataGridView.Rows.Add(temp2DataGridViewRow);
}
}
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
this.ConvertRank();
}
tempDataGridView.Sort(tempDataGridView.Columns[5], ListSortDirection.Ascending);
try
{
tempDataGridView.Update();
}
catch { }
TotalAmountCalculation();
}
}
g_FoodDataGridView.ClearSelection();
g_BeverageDataGridView.ClearSelection();
m_iSavedOrderedQty = 1;
keyboardForm.Hide();
this.SetPrintedItemBackColor();
}
private void g_SpecialButton_Click(object sender, EventArgs e)
{
try
{
if (m_iDataGridViewCurrentRowIndex == -1)
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Please select ordered food or beverage.");
tempMessageBox.ShowDialog();
return;
}
CSpecialModifyForm tempKeyBoardForm = new CSpecialModifyForm();
tempKeyBoardForm.ShowDialog();
string sResult = CSpecialModifyForm.Content;
if (sResult.Equals("") || sResult.Equals("Cancel"))
{
return;
}
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper()) //For local order
{
COrderManager tempOrderManager = new COrderManager();
COrderDetails tempOrderDetails = (COrderDetails)tempOrderManager.OrderDetailsByOrderDetailID(Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[6].Value.ToString())).Data;
if (tempOrderDetails.OrderRemarks.Equals(""))
{
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[0].Value
= m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[0].Value.ToString() + " (" + sResult + ")";
}
else if (tempOrderDetails.CategoryLevel == 0)
{
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[0].Value
= m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[0].Value.ToString() + sResult;
}
else
{
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[0].Value
= m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[0].Value.ToString().Substring(0, m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells["Item"].Value.ToString().LastIndexOf('(')) + " (" + sResult + ")";
}
tempOrderDetails.OrderRemarks = sResult;
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
}
else
{
COrderManager tempOrderManager = new COrderManager();
COrderDetails tempOrderDetails = new COrderDetails();
if (sResult.Length > 0)
{
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[0].Value
= m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[0].Value.ToString() + " (" + sResult + ")";
}
tempOrderDetails.OnlineItemSequenceNumber = Convert.ToInt64(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[5].Value);
tempOrderDetails.OrderRemarks = sResult;
tempOrderManager.UpdateOnlineItemSpecial(tempOrderDetails);
this.LoadOrderDetails();
}
m_dDataGridView.Update();
m_iDataGridViewCurrentRowIndex = -1;
m_dDataGridView.ClearSelection();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//private void btnPLU_Click(object sender, EventArgs e)
//{
// int priceTakeType;
// Int32 productPLU = 0;
// int returnVal = 0;
// Int32 productQuantity = 0;
// COrderManager objOrderManager = new COrderManager();
// if (m_iType == m_cCommonConstants.TableType)
// {
// priceTakeType = 1;
// }
// else if (m_iType == m_cCommonConstants.TakeAwayType)
// {
// priceTakeType = 2;
// }
// else
// {
// priceTakeType = 3;
// }
// CCalculatorForm tableNumberForm = new CCalculatorForm("Product PLU Information", "PLU of the Product");
// tableNumberForm.ShowDialog();
// if (CCalculatorForm.inputResult.Equals("Cancel"))
// return;
// if (CCalculatorForm.inputResult.Equals("") || Int32.Parse(CCalculatorForm.inputResult) == 0)
// {
// CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!");
// tempMessageBox.ShowDialog();
// return;
// }
// productPLU = Convert.ToInt32("0" + CCalculatorForm.inputResult);
// CResult objProductName = objOrderManager.GetProductByProductPLU(productPLU);
// if (Convert.ToString(objProductName.Data) == "NO")
// {
// CMessageBox tempMessageBox = new CMessageBox("Error", "Invalid PLU.Please enter valid PLU");
// tempMessageBox.ShowDialog();
// return;
// }
// ProductQuantityForm quantityForm = new ProductQuantityForm(Convert.ToString(objProductName.Data));
// quantityForm.ShowDialog();
// if (ProductQuantityForm.m_productQuantity.Equals("Cancel"))
// {
// return;
// }
// if (ProductQuantityForm.m_productQuantity.Equals("") || Int32.Parse(ProductQuantityForm.m_productQuantity) == 0)
// {
// CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!");
// tempMessageBox.ShowDialog();
// return;
// }
// productQuantity = Convert.ToInt32("0" + ProductQuantityForm.m_productQuantity);
// CResult oResult = objOrderManager.GetPluDataByProductPLU(productPLU, priceTakeType, orderID, productQuantity);
// if (oResult.IsSuccess && oResult.Data != null)
// {
// returnVal = int.Parse(oResult.Data.ToString());
// //for vat includr option
// String queryStr = SqlQueries.GetQuery(Query.LastPLUOrderDetails);
// CDalConfig oTempDal = ConfigManager.GetConfig<CDalConfig>();
// String tempConnStr = oTempDal.ConnectionString;
// // Create a new data adapter based on the specified query.
// SqlDataAdapter dataAdapter = new SqlDataAdapter(queryStr, tempConnStr);
// // Populate a new data table and bind it to the BindingSource.
// DataTable table = new DataTable();
// //table.Locale = System.Globalization.CultureInfo.InvariantCulture;
// dataAdapter.Fill(table);
// int CategoryID = Convert.ToInt32(table.Rows[0]["product_id"].ToString());
// Double amount = Convert.ToDouble(table.Rows[0]["amount"].ToString());
// int catLavel=Convert.ToInt32(table.Rows[0]["cat_level"].ToString());
// //vat in cat Three
// double vatRate = 0;
// bool vat_included = false;
// double vatAmountRate = 0;
// if(catLavel==3)
// {
// DataRow[] temp2DataRowArray = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + CategoryID.ToString());
// vatRate = 0;
// vat_included = false;
// vatAmountRate = 0;
// try
// {
// vatRate = Convert.ToDouble(temp2DataRowArray[0]["vat_Rate"].ToString());
// vat_included = Convert.ToBoolean(temp2DataRowArray[0]["vat_included"].ToString());
// if (vat_included)
// {
// vatAmountRate = (amount * vatRate) / 100;
// // tableTypePrice = (Double.Parse(tableTypePrice) - vatAmountRate).ToString();
// // tableTypePrice = Convert.ToDouble(tableTypePrice).ToString();
// }
// else
// {
// vatAmountRate = 0.00;
// }
// }
// catch (Exception ex) { }
// }
// if(catLavel==4)
// {
// DataRow[] temp3DataRowArray = Program.initDataSet.Tables["Category4"].Select("cat4_id = " + CategoryID);
// vatRate = 0;
// vat_included = false;
// vatAmountRate = 0;
// try
// {
// vatRate = Convert.ToDouble(temp3DataRowArray[0]["vat_Rate"].ToString());
// vat_included = Convert.ToBoolean(temp3DataRowArray[0]["vat_included"].ToString());
// if (vat_included)
// {
// vatAmountRate = (amount * vatRate) / 100;
// // tableTypePrice = (Double.Parse(tableTypePrice) - vatAmountRate).ToString();
// // tableTypePrice = Convert.ToDouble(tableTypePrice).ToString();
// }
// else
// {
// vatAmountRate = 0.00;
// }
// }
// catch (Exception ex) { }
// }
// //string tableTypePrice = string.Empty;
// //if (m_iType == m_cCommonConstants.TableType)
// //{
// // tableTypePrice = temp2DataRowArray[0]["table_price"].ToString();
// //}
// //else if (m_iType == m_cCommonConstants.TakeAwayType)
// //{
// // tableTypePrice = temp2DataRowArray[0]["tw_price"].ToString();
// //}
// COrderManager tempOrderManager = new COrderManager();
// COrderDetails tempOrderDetails = new COrderDetails();
// if (returnVal == 1)
// {
// //update Order_details table
// //int tempRowIndex = tempResult;
// //int qty = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString()) + m_iSavedOrderedQty;
// //tempDataGridView.Rows[tempRowIndex].Cells[1].Value = qty;
// //tempDataGridView.Rows[tempRowIndex].Cells[2].Value = ((double)(Double.Parse(tableTypePrice) * qty)).ToString("F02");
// tempOrderDetails.OrderDetailsID = Convert.ToInt32(table.Rows[0]["order_detail_id"].ToString());
// tempOrderDetails.OrderID =Convert.ToInt32(table.Rows[0]["order_id"].ToString());
// tempOrderDetails.ProductID =Convert.ToInt32( table.Rows[0]["product_id"].ToString());
// tempOrderDetails.CategoryLevel = Convert.ToInt32(table.Rows[0]["cat_level"].ToString());
// tempOrderDetails.UnitPrice = 0.00;
// tempOrderDetails.OrderQuantity = Convert.ToInt32(table.Rows[0]["quantity"].ToString());
// tempOrderDetails.OrderAmount = Convert.ToDouble(table.Rows[0]["amount"].ToString());
// tempOrderDetails.OrderFoodType = table.Rows[0]["food_type"].ToString();
// // tempOrderDetails.OnlineItemSequenceNumber = Convert.ToInt64("0" + tempDataGridView.Rows[tempRowIndex].Cells[5].Value.ToString());
// // tempOrderDetails.PrintedQuantity = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[7].Value.ToString());
// if (vat_included)
// {
// tempOrderDetails.VatTotal = vatAmountRate;
// }
// else
// {
// tempOrderDetails.VatTotal = 0.00;
// }
// //if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
// //{
// // tempOrderManager.UpdateOrderDetails(tempOrderDetails);
// //}
// //else
// //{
// // tempOrderManager.UpdateOnlineOrderDetails(tempOrderDetails);
// //}
// try
// {
// tempOrderManager.UpdateOrderDetails(tempOrderDetails);
// }
// catch { }
// }
// //tempOrderDetails.VatTotal = vatAmountRate;
// //tempOrderDetails.OrderDetailsID =Convert.ToInt32(table.Rows[0]["order_detail_id"].ToString());
// //try
// //{
// //tempOrderManager.UpdateOrderDetails(tempOrderDetails);
// //}
// //catch { }
// }
// if (returnVal == 0)
// {
// MessageBox.Show("Please enter valid plu product", RMSGlobal.MessageBoxTitle,
// MessageBoxButtons.OK, MessageBoxIcon.Information);
// }
// else
// {
// COrderDetailsDAO orderDetailsDao = new COrderDetailsDAO();
// orderDetailsDao.UpdateOrderDetailsPricebyPLUProductTablePrice(productPLU, orderID, priceTakeType);
// }
// this.LoadOrderDetails();
// btnPLU_Click(sender, e);
//}
private void btnPLU_Click(object sender, EventArgs e)
{
int priceTakeType;
Int32 productPLU = 0;
int returnVal = 0;
Int32 productQuantity = 0;
COrderManager objOrderManager = new COrderManager();
if (m_iType == m_cCommonConstants.TableType)
{
priceTakeType = 1;
}
else if (m_iType == m_cCommonConstants.TakeAwayType)
{
priceTakeType = 2;
}
else
{
priceTakeType = 3;
}
CCalculatorForm tableNumberForm = new CCalculatorForm("Product PLU Information", "PLU of the Product");
tableNumberForm.ShowDialog();
if (CCalculatorForm.inputResult.Equals("Cancel"))
return;
if (CCalculatorForm.inputResult.Equals("") || Int32.Parse(CCalculatorForm.inputResult) == 0)
{
CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!");
tempMessageBox.ShowDialog();
return;
}
productPLU = Convert.ToInt32("0" + CCalculatorForm.inputResult);
// Add for find updating order_detail
int id = productPLU;
long order = orderID;
COrderDetailsDAO aDao = new COrderDetailsDAO();
List<COrderDetails> aList = aDao.OrderDetailsGetAll();
// CResult objProductName = objOrderManager.GetProductByProductPLU(productPLU, priceTakeType);
CResult objProductName = objOrderManager.GetProductByProductPLU(productPLU);
var check = (from orderdetail in aList
where (orderdetail.OrderID == orderID && orderdetail.ProductID == objProductName.Productid)
select orderdetail);
if (Convert.ToString(objProductName.Data) == "NO")
{
CMessageBox tempMessageBox = new CMessageBox("Error", "Invalid PLU.Please enter valid PLU");
tempMessageBox.ShowDialog();
return;
}
ProductQuantityForm quantityForm = new ProductQuantityForm(Convert.ToString(objProductName.Data));
quantityForm.ShowDialog();
if (ProductQuantityForm.m_productQuantity.Equals("Cancel"))
{
return;
}
if (ProductQuantityForm.m_productQuantity.Equals("") || Int32.Parse(ProductQuantityForm.m_productQuantity) == 0)
{
CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!");
tempMessageBox.ShowDialog();
return;
}
productQuantity = Convert.ToInt32("0" + ProductQuantityForm.m_productQuantity);
// Add for updating order_detail when orderwith same product
if (check.Count() == 1)
{
COrderDetails aOrderDetails = new COrderDetails();
aOrderDetails = check.Single();
//double vat = aOrderDetails.Amount_with_vat - aOrderDetails.OrderAmount;
//vat = (vat * 100) / aOrderDetails.OrderAmount;
productQuantity += aOrderDetails.OrderQuantity;
aOrderDetails.OrderQuantity = productQuantity;
aOrderDetails.OrderAmount = aOrderDetails.UnitPrice * productQuantity;
aOrderDetails.PrintedQuantity = aOrderDetails.PrintedQuantity;
aOrderDetails.VatTotal = (objProductName.VateRate * aOrderDetails.OrderAmount) / 100.0;
aOrderDetails.Amount_with_vat = aOrderDetails.OrderAmount + aOrderDetails.VatTotal;
COrderDetailsDAO aCOrderDetailsDao = new COrderDetailsDAO();
aCOrderDetailsDao.OrderDetailsUpdate(aOrderDetails);
//COrderDetailsDAO orderDetailsDao = new COrderDetailsDAO();
//orderDetailsDao.UpdateOrderDetailsPricebyPLUProductTablePrice(productPLU, orderID, priceTakeType);
}
if (check.Count() == 0)
{
CResult oResult = objOrderManager.GetPluDataByProductPLU(productPLU, priceTakeType, orderID,
productQuantity);
if (oResult.IsSuccess && oResult.Data != null)
{
returnVal = int.Parse(oResult.Data.ToString());
//for vat includr option
String queryStr = SqlQueries.GetQuery(Query.LastPLUOrderDetails);
CDalConfig oTempDal = ConfigManager.GetConfig<CDalConfig>();
String tempConnStr = oTempDal.ConnectionString;
// Create a new data adapter based on the specified query.
SqlDataAdapter dataAdapter = new SqlDataAdapter(queryStr, tempConnStr);
// Populate a new data table and bind it to the BindingSource.
DataTable table = new DataTable();
//table.Locale = System.Globalization.CultureInfo.InvariantCulture;
dataAdapter.Fill(table);
int CategoryID = Convert.ToInt32(table.Rows[0]["product_id"].ToString());
Double amount = Convert.ToDouble(table.Rows[0]["amount"].ToString());
int catLavel = Convert.ToInt32(table.Rows[0]["cat_level"].ToString());
//vat in cat Three
double vatRate = 0;
bool vat_included = false;
double vatAmountRate = 0;
if (catLavel == 3)
{
DataRow[] temp2DataRowArray =
Program.initDataSet.Tables["Category3"].Select("cat3_id = " + CategoryID.ToString());
vatRate = 0;
vat_included = false;
vatAmountRate = 0;
try
{
vatRate = Convert.ToDouble(temp2DataRowArray[0]["vat_Rate"].ToString());
vat_included = Convert.ToBoolean(temp2DataRowArray[0]["vat_included"].ToString());
if (vat_included)
{
vatAmountRate = (amount * vatRate) / 100;
// tableTypePrice = (Double.Parse(tableTypePrice) - vatAmountRate).ToString();
// tableTypePrice = Convert.ToDouble(tableTypePrice).ToString();
}
else
{
vatAmountRate = 0.00;
}
}
catch (Exception ex)
{
}
}
if (catLavel == 4)
{
DataRow[] temp3DataRowArray =
Program.initDataSet.Tables["Category4"].Select("cat4_id = " + CategoryID);
vatRate = 0;
vat_included = false;
vatAmountRate = 0;
try
{
vatRate = Convert.ToDouble(temp3DataRowArray[0]["vat_Rate"].ToString());
vat_included = Convert.ToBoolean(temp3DataRowArray[0]["vat_included"].ToString());
if (vat_included)
{
vatAmountRate = (amount * vatRate) / 100;
// tableTypePrice = (Double.Parse(tableTypePrice) - vatAmountRate).ToString();
// tableTypePrice = Convert.ToDouble(tableTypePrice).ToString();
}
else
{
vatAmountRate = 0.00;
}
}
catch (Exception ex)
{
}
}
//string tableTypePrice = string.Empty;
//if (m_iType == m_cCommonConstants.TableType)
//{
// tableTypePrice = temp2DataRowArray[0]["table_price"].ToString();
//}
//else if (m_iType == m_cCommonConstants.TakeAwayType)
//{
// tableTypePrice = temp2DataRowArray[0]["tw_price"].ToString();
//}
COrderManager tempOrderManager = new COrderManager();
COrderDetails tempOrderDetails = new COrderDetails();
if (returnVal == 1)
{
//update Order_details table
//int tempRowIndex = tempResult;
//int qty = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString()) + m_iSavedOrderedQty;
//tempDataGridView.Rows[tempRowIndex].Cells[1].Value = qty;
//tempDataGridView.Rows[tempRowIndex].Cells[2].Value = ((double)(Double.Parse(tableTypePrice) * qty)).ToString("F02");
tempOrderDetails.OrderDetailsID = Convert.ToInt32(table.Rows[0]["order_detail_id"].ToString());
tempOrderDetails.OrderID = Convert.ToInt32(table.Rows[0]["order_id"].ToString());
tempOrderDetails.ProductID = Convert.ToInt32(table.Rows[0]["product_id"].ToString());
tempOrderDetails.CategoryLevel = Convert.ToInt32(table.Rows[0]["cat_level"].ToString());
tempOrderDetails.UnitPrice = 0.00;
tempOrderDetails.OrderQuantity = Convert.ToInt32(table.Rows[0]["quantity"].ToString());
tempOrderDetails.OrderAmount = Convert.ToDouble(table.Rows[0]["amount"].ToString());
tempOrderDetails.OrderFoodType = table.Rows[0]["food_type"].ToString();
// tempOrderDetails.OnlineItemSequenceNumber = Convert.ToInt64("0" + tempDataGridView.Rows[tempRowIndex].Cells[5].Value.ToString());
// tempOrderDetails.PrintedQuantity = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[7].Value.ToString());
if (vat_included)
{
tempOrderDetails.VatTotal = vatAmountRate;
}
else
{
tempOrderDetails.VatTotal = 0.00;
}
//if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
//{
// tempOrderManager.UpdateOrderDetails(tempOrderDetails);
//}
//else
//{
// tempOrderManager.UpdateOnlineOrderDetails(tempOrderDetails);
//}
try
{
tempOrderDetails.Amount_with_vat = tempOrderDetails.OrderAmount + tempOrderDetails.VatTotal;
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
}
catch
{
}
}
//tempOrderDetails.VatTotal = vatAmountRate;
//tempOrderDetails.OrderDetailsID =Convert.ToInt32(table.Rows[0]["order_detail_id"].ToString());
//try
//{
//tempOrderManager.UpdateOrderDetails(tempOrderDetails);
//}
//catch { }
}
if (returnVal == 0)
{
MessageBox.Show("Please enter valid plu product", RMSGlobal.MessageBoxTitle,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
COrderDetailsDAO orderDetailsDao = new COrderDetailsDAO();
orderDetailsDao.UpdateOrderDetailsPricebyPLUProductTablePrice(productPLU, orderID, priceTakeType);
}
}
this.LoadOrderDetails();
btnPLU_Click(sender, e);
}
private void g_RemoveButton_Click(object sender, EventArgs e)
{
try
{
if (m_iDataGridViewCurrentRowIndex == -1)
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Please select ordered food or beverage.");
tempMessageBox.ShowDialog();
return;
}
if (m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[0].Value.ToString().Equals(""))
{
return;
}
int totalQuantity = Convert.ToInt32(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[1].Value.ToString());
// int printedQuantity = Convert.ToInt32(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[7].Value.ToString());
int printedQuantity = Convert.ToInt32(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[8].Value.ToString());
//If printed items are equal to total quantity or greater
if (totalQuantity <= printedQuantity)
{
CMessageBox tempMessageBox = new CMessageBox("Printed", "Current item(s) has already been sent to kitchen.");
tempMessageBox.ShowDialog();
return;
}
COrderManager tempOrderManager1 = new COrderManager();
CResult oResult1 = tempOrderManager1.OrderDetailsByOrderDetailID(Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[7].Value.ToString()));
COrderDetails aDetails = new COrderDetails();
if (oResult1.IsSuccess && oResult1.Data != null)
{
aDetails = (COrderDetails)oResult1.Data;
}
if (aDetails.GuestPrintQuantity >= totalQuantity)
{
CMessageBox tempMessageBox = new CMessageBox("Printed", " All ready Guest Bill Printed so that impossible of item decrease");
tempMessageBox.ShowDialog();
return;
}
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".ToUpper().Replace(" ", "")) //If the order is not online order
{
COrderManager tempOrderManager = new COrderManager();
//int qty = Int32.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[1].Value.ToString());
////Double amount = Double.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value.ToString());
////For Vat and Unit vat
//Double itemTotalVat = Double.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value.ToString());
//Double unitVat = itemTotalVat / qty;
//itemTotalVat = itemTotalVat - unitVat;
//Double amount = Double.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[3].Value.ToString());
//Double unitPrice = amount / qty;
int qty = Int32.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[1].Value.ToString());
//Double amount = Double.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value.ToString());
//For Vat and Unit vat
Double itemTotalVat = Double.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value.ToString());
Double unitVat = itemTotalVat / qty;
// itemTotalVat = itemTotalVat - unitVat;
Double amount = Double.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[3].Value.ToString());
Double unitPrice = amount / qty;
if (qty == 1)
{
tempOrderManager.DeleteOrderDetails(Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[7].Value.ToString()));
m_dDataGridView.Rows.RemoveAt(m_iDataGridViewCurrentRowIndex);
}
else
{
qty = qty - 1;
if (qty < 1)
{
qty = 0;
}
COrderDetails tempOrderDetails = new COrderDetails();
// CResult oResult = tempOrderManager.OrderDetailsByOrderDetailID(Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[6].Value.ToString()));
CResult oResult = tempOrderManager.OrderDetailsByOrderDetailID(Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[7].Value.ToString()));
if (oResult.IsSuccess && oResult.Data != null)
{
tempOrderDetails = (COrderDetails)oResult.Data;
}
//tempOrderDetails.OrderQuantity = qty;
//tempOrderDetails.OrderAmount = qty * unitPrice;
//tempOrderDetails.PrintedQuantity = tempOrderDetails.PrintedQuantity - 1;
//Add by deb
tempOrderDetails.OrderQuantity = qty;
tempOrderDetails.OrderAmount = qty * unitPrice;
tempOrderDetails.VatTotal = unitVat * qty;
if (tempOrderDetails.PrintedQuantity <= 0)
{
tempOrderDetails.PrintedQuantity = 0;
}
//tempOrderDetails.OrderDetailsID = Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[6].Value.ToString());
tempOrderDetails.Amount_with_vat = tempOrderDetails.OrderAmount + tempOrderDetails.VatTotal;
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[1].Value = qty;
//m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[7].Value = tempOrderDetails.PrintedQuantity;
// m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value = ((double)(qty * unitPrice)).ToString("F02");
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[8].Value = tempOrderDetails.PrintedQuantity;
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[3].Value = ((double)(qty * unitPrice)).ToString("F02");
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value = ((double)(unitVat * qty)).ToString("F02");
}
}
else //Proceed for online order
{
if (this.TotalItems() < 2)
{
MessageBox.Show("You can not remove all the items from online", RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
COrderManager tempOrderManager = new COrderManager();
int qty = Int32.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[1].Value.ToString());
Double amount = Double.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value.ToString());
Double unitPrice = amount / qty;
if (qty == 1)
{
tempOrderManager.DeleteOnlineOrderDetails(Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[5].Value.ToString())); //Taking the order sequence number.Here named category ranking
m_dDataGridView.Rows.RemoveAt(m_iDataGridViewCurrentRowIndex);
}
else
{
qty = qty - 1;
if (qty < 1)
{
qty = 0;
}
COrderDetails tempOrderDetails = new COrderDetails();
tempOrderDetails.OrderQuantity = qty;
tempOrderDetails.OrderAmount = qty * unitPrice;
tempOrderDetails.OnlineItemSequenceNumber = Convert.ToInt64("0" + m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[5].Value);
tempOrderDetails.OrderDetailsID = Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[6].Value.ToString());
tempOrderManager.UpdateOnlineOrderDetails(tempOrderDetails);
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[1].Value = qty;
///For printed items
int printedItems = Convert.ToInt32(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[7].Value) - 1;
if (printedItems < 1)
{
printedItems = 0;
}
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[7].Value = printedItems;
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value = ((double)(qty * unitPrice)).ToString("F02");
}
}
m_dDataGridView.Update();
TotalAmountCalculation();
m_dDataGridView.ClearSelection();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.SetPrintedItemBackColor(); //set the back color
}
private void g_MiscButton_Click(object sender, EventArgs e)
{
try
{
CKeyBoardForm tempKeyBoardForm = new CKeyBoardForm("Misc Item", "Enter Item Name or Description", true);
tempKeyBoardForm.ShowDialog();
if (CKeyBoardForm.Content.Equals("Cancel"))
return;
if (CKeyBoardForm.Content.Equals(""))
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Item Name cannot be Empty");
tempMessageBox.ShowDialog();
return;
}
CPriceCalculatorForm tempCalculatorForm = new CPriceCalculatorForm("Misc Item", "Enter Price");
tempCalculatorForm.ShowDialog();
if (CPriceCalculatorForm.inputResult.Equals("Cancel"))
return;
if (CPriceCalculatorForm.inputResult.Equals("0.000"))
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Price cannot be zero.");
tempMessageBox.ShowDialog();
return;
}
double price = Double.Parse(CPriceCalculatorForm.inputResult);
//change by mithu
CPriceCalculatorForm tempCalculatorForm1 = new CPriceCalculatorForm("Misc Item", "Enter vat");
tempCalculatorForm1.ShowDialog();
if (CPriceCalculatorForm.inputResult.Equals("Cancel"))
return;
if (CPriceCalculatorForm.inputResult.Equals("0.000"))
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Vat cannot be zero.");
tempMessageBox.ShowDialog();
return;
}
double addmisvat=Double.Parse(CPriceCalculatorForm.inputResult);
try
{
CCalculatorForm tempQtyCalculatorForm = new CCalculatorForm("Order Quantity", "Item Quantity");
tempQtyCalculatorForm.ShowDialog();
if (CCalculatorForm.inputResult.Equals("Cancel"))
return;
string str = CCalculatorForm.inputResult;
str = (str == "") ? "1" : str;
if (Int32.Parse(str) == 0)
{
CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!");
tempMessageBox.ShowDialog();
return;
}
int tempOrderedQty = Int32.Parse(str);
m_iSavedOrderedQty = tempOrderedQty;
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
COrderManager tempOrderManager = new COrderManager();
COrderDetails tempOrderDetails = new COrderDetails();
DataGridView tempDataGridView = null;
if (CKeyBoardForm.m_foodType == true) //If miscelleneous item is food
{
tempDataGridView = g_FoodDataGridView;
}
else
{
tempDataGridView = g_BeverageDataGridView;
}
int tempResult = FindExistingItem(tempDataGridView, CKeyBoardForm.Content);
if (tempResult != -1)
{
//update Order_details table
int tempRowIndex = tempResult;
tempDataGridView.Rows[tempRowIndex].Cells[1].Value = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString()) + m_iSavedOrderedQty;
tempOrderDetails.OrderDetailsID = Int64.Parse(tempDataGridView.Rows[tempRowIndex].Cells[7].Value.ToString());
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = 0;
tempOrderDetails.CategoryLevel = 0;
tempOrderDetails.OrderRemarks = CKeyBoardForm.Content;
tempOrderDetails.Product_Name = CKeyBoardForm.Content;
tempOrderDetails.OrderQuantity = Int32.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString());
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity*price;
tempOrderDetails.VatTotal = (addmisvat*tempOrderDetails.OrderAmount)/100.0;
tempOrderDetails.Amount_with_vat = tempOrderDetails.OrderAmount + tempOrderDetails.VatTotal;
tempOrderDetails.OrderFoodType = "Food";
tempOrderDetails.ItemOrderTime = DateTime.Now.Ticks;
tempDataGridView.Rows[tempRowIndex].Cells[2].Value = tempOrderDetails.VatTotal.ToString("F02");
tempDataGridView.Rows[tempRowIndex].Cells[3].Value = tempOrderDetails.OrderAmount.ToString("F02");
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
}
else
{
//Insert into Order_details table
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = 0;
tempOrderDetails.CategoryLevel = 0;
tempOrderDetails.OrderRemarks = CKeyBoardForm.Content;
tempOrderDetails.Product_Name = CKeyBoardForm.Content;
tempOrderDetails.OrderQuantity = m_iSavedOrderedQty;
tempOrderDetails.ItemOrderTime = DateTime.Now.Ticks;
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity*price;
tempOrderDetails.VatTotal = (addmisvat * tempOrderDetails.OrderAmount) / 100.0;
tempOrderDetails.Amount_with_vat = tempOrderDetails.OrderAmount + tempOrderDetails.VatTotal;
if (CKeyBoardForm.m_foodType == true)
{
tempOrderDetails.OrderFoodType = "Food";
}
else
{
tempOrderDetails.OrderFoodType = "Nonfood";
}
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
tempOrderDetails = (COrderDetails)tempOrderManager.InsertOrderDetails(tempOrderDetails).Data;
string[] tempDataGridViewRow = new string[]
{ CKeyBoardForm.Content,
m_iSavedOrderedQty.ToString(),
tempOrderDetails.VatTotal.ToString("F02"),
tempOrderDetails.OrderAmount.ToString("F02"),
"0",
"0",
Int64.MaxValue-1+"",
tempOrderDetails.OrderDetailsID.ToString(),"0" //0 for printed item quantity
};
tempDataGridView.Rows.Add(tempDataGridViewRow);
}
else
{
tempOrderDetails.ItemName = CKeyBoardForm.Content;
tempOrderDetails = (COrderDetails)tempOrderManager.InsertOnlineOrderDetails(tempOrderDetails).Data;
string[] tempDataGridViewRow = new string[]
{ CKeyBoardForm.Content,
m_iSavedOrderedQty.ToString(),
tempOrderDetails.VatTotal.ToString("F02"),
tempOrderDetails.OrderAmount.ToString("F02"),
"0",
"0",
tempOrderDetails.OnlineItemSequenceNumber.ToString(),
tempOrderDetails.OrderDetailsID.ToString(),"0" //0 for printed item quantity
};
tempDataGridView.Rows.Add(tempDataGridViewRow);
}
}
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper()) //Rank is applicable only for local order only
{
this.ConvertRank();
}
tempDataGridView.Sort(tempDataGridView.Columns[5], ListSortDirection.Ascending);
tempDataGridView.Update();
TotalAmountCalculation();
m_iSavedOrderedQty = 1;
g_FoodDataGridView.ClearSelection();
g_BeverageDataGridView.ClearSelection();
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
private void Category3Button_Click(object sender, EventArgs e)
{
try
{
CCategoryButton tempCategory3Button = (CCategoryButton)sender;
int tempCategory3ID = tempCategory3Button.CategoryID;
if (m_bItemDescriptionClicked)
{
string tempItemDescription = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCategory3ID)[0]["description"].ToString();
CMessageBox tempMessageBox = new CMessageBox("Item Description", tempItemDescription);
tempMessageBox.ShowDialog();
m_bItemDescriptionClicked = false;
return;
}
int tempFoodType = int.Parse(Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCategory3ID)[0].GetParentRow(Program.initDataSet.Relations["category2_to_category3"])["cat2_type"].ToString());
DataGridView tempDataGridView = new DataGridView();
tempDataGridView = g_FoodDataGridView;
DataRow[] tempDataRowArray = Program.initDataSet.Tables["Category4"].Select("cat3_id = " + tempCategory3ID.ToString());
category4ButtonList.Clear();
if (tempDataRowArray.Length != 0)
{
foreach (DataRow tempDataRow in tempDataRowArray)
{
CCategoryButton tempCategoryButton = new CCategoryButton();
tempCategoryButton.CategoryID = int.Parse(tempDataRow["cat4_id"].ToString());
tempCategoryButton.CategoryOrder = int.Parse(tempDataRow["cat4_order"].ToString());
tempCategoryButton.CategoryLevel = 4;
tempCategoryButton.Text = tempDataRow["cat4_name"].ToString();
tempCategoryButton.BackColor = tempCategory3Button.BackColor;
category4ButtonList.Add(tempCategoryButton);
}
CCategory4Form tempCategory4Form = new CCategory4Form(tempCategory3ID, category4ButtonList, tempCategory3Button.Text);
tempCategory4Form.ShowDialog();
CCategoryButton tempCategory4Button = CCategory4Form.m_cbResult;
if (tempCategory4Button == null)
return;
else //insert into table and datagridview
{
NewOrder();
DataRow[] temp2DataRowArray = Program.initDataSet.Tables["Category4"].Select("cat4_id = " + tempCategory4Button.CategoryID.ToString());
if (temp2DataRowArray.Length != 0)
{
//category4 + categpry3
string ItemName = temp2DataRowArray[0]["cat4_name"].ToString() + " " + tempCategory3Button.Text;
string tableTypePrice = string.Empty;
tableTypePrice = temp2DataRowArray[0]["bar_price"].ToString();
int tempSearchResult = DataGridViewSearch(tempDataGridView, ItemName);
COrderManager tempOrderManager = new COrderManager();
COrderDetails tempOrderDetails = new COrderDetails();
if (tempSearchResult != -1)
{
int tempRowIndex = tempSearchResult;
int qty = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString()) + m_iSavedOrderedQty;
tempDataGridView.Rows[tempRowIndex].Cells[1].Value = qty;
tempDataGridView.Rows[tempRowIndex].Cells[2].Value = ((double)(Double.Parse(tableTypePrice) * qty)).ToString("F02");
//update Order_details table
tempOrderDetails.OrderID = orderID;
tempOrderDetails.OrderDetailsID = Int64.Parse(tempDataGridView.Rows[tempRowIndex].Cells[6].Value.ToString());
tempOrderDetails.ProductID = tempCategory4Button.CategoryID;
tempOrderDetails.CategoryLevel = tempCategory4Button.CategoryLevel;
tempOrderDetails.OrderQuantity = qty;
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(tableTypePrice);
tempOrderDetails.OrderFoodType = tempFoodType == 1 ? ("Food") : ("Nonfood");
tempOrderDetails.ItemOrderTime = DateTime.Now.Ticks;
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
}
else
{
//Insert into Order_details table
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = tempCategory4Button.CategoryID;
tempOrderDetails.CategoryLevel = tempCategory4Button.CategoryLevel;
tempOrderDetails.OrderQuantity = m_iSavedOrderedQty;
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(tableTypePrice);
tempOrderDetails.ItemOrderTime = DateTime.Now.Ticks;
tempOrderDetails.OrderFoodType = tempFoodType == 1 ? ("Food") : ("Nonfood");
CResult oResult = tempOrderManager.InsertOrderDetails(tempOrderDetails);
if (oResult.IsSuccess && oResult.Data != null)
{
tempOrderDetails = (COrderDetails)oResult.Data;
}
string[] tempDataGridViewRow = new string[]
{ ItemName,
m_iSavedOrderedQty.ToString(),
((double)(Double.Parse(tableTypePrice)*m_iSavedOrderedQty)).ToString("F02"),
tempCategory4Button.CategoryID.ToString(),
"4",
temp2DataRowArray[0]["cat4_rank"].ToString(),
tempOrderDetails.OrderDetailsID.ToString()
};
tempDataGridView.Rows.Add(tempDataGridViewRow);
}
ConvertRank();
tempDataGridView.Sort(tempDataGridView.Columns[5], ListSortDirection.Ascending);
tempDataGridView.Update();
TotalAmountCalculation();
}
}
}
else //There is no category4
{
NewOrder();
DataGridViewRow tempDataGridViewRow = new DataGridViewRow();
tempDataGridViewRow.CreateCells(tempDataGridView);
DataRow[] temp2DataRowArray = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCategory3Button.CategoryID.ToString());
if (temp2DataRowArray.Length != 0)
{
string tableTypePrice = string.Empty;
tableTypePrice = temp2DataRowArray[0]["bar_price"].ToString();
COrderManager tempOrderManager = new COrderManager();
COrderDetails tempOrderDetails = new COrderDetails();
int tempResult = DataGridViewSearch(tempDataGridView, temp2DataRowArray[0]["cat3_name"].ToString());
if (tempResult != -1)
{
//update Order_details table
int tempRowIndex = tempResult;
int qty=int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString()) + m_iSavedOrderedQty;
tempDataGridView.Rows[tempRowIndex].Cells[1].Value = qty;
tempDataGridView.Rows[tempRowIndex].Cells[2].Value = ((double)(Double.Parse(tableTypePrice) * qty)).ToString("F02");
tempOrderDetails.OrderDetailsID = Int64.Parse(tempDataGridView.Rows[tempRowIndex].Cells[6].Value.ToString());
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = tempCategory3Button.CategoryID;
tempOrderDetails.CategoryLevel = tempCategory3Button.CategoryLevel;
tempOrderDetails.OrderQuantity = qty;
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(tableTypePrice);
tempOrderDetails.OrderFoodType = tempFoodType == 1 ? ("Food") : ("Nonfood");
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
}
else
{
//Insert into Order_details table
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = tempCategory3Button.CategoryID;
tempOrderDetails.CategoryLevel = tempCategory3Button.CategoryLevel;
tempOrderDetails.OrderQuantity = m_iSavedOrderedQty;
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(tableTypePrice);
tempOrderDetails.OrderFoodType = tempFoodType == 1 ? ("Food") : ("Nonfood");
tempOrderDetails.ItemOrderTime = DateTime.Now.Ticks;
CResult oResult = tempOrderManager.InsertOrderDetails(tempOrderDetails);
if (oResult.IsSuccess && oResult.Data != null)
{
tempOrderDetails = (COrderDetails)oResult.Data;
}
string[] temp2DataGridViewRow = new string[]
{ temp2DataRowArray[0]["cat3_name"].ToString(),
m_iSavedOrderedQty.ToString(),
((double)(Double.Parse(tableTypePrice)*m_iSavedOrderedQty)).ToString("F02"),
tempCategory3Button.CategoryID.ToString(),
"3",
temp2DataRowArray[0]["cat3_rank"].ToString(),
tempOrderDetails.OrderDetailsID.ToString()
};
tempDataGridView.Rows.Add(temp2DataGridViewRow);
}
ConvertRank();
tempDataGridView.Sort(tempDataGridView.Columns[5], ListSortDirection.Ascending);
tempDataGridView.Update();
TotalAmountCalculation();
}
}
m_iSavedOrderedQty = 1;
g_FoodDataGridView.ClearSelection();
}
catch (Exception exp)
{
throw exp;
}
}
private void g_RemoveButton_Click(object sender, EventArgs e)
{
try
{
if (m_iDataGridViewCurrentRowIndex == -1)
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Please select ordered food or beverage.");
tempMessageBox.ShowDialog();
return;
}
COrderManager tempOrderManager = new COrderManager();
int qty = Int32.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[1].Value.ToString());
Double amount = Double.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value.ToString());
Double unitPrice = amount / qty;
if (qty == 1)
{
tempOrderManager.DeleteOrderDetails(Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[6].Value.ToString()));
m_dDataGridView.Rows.RemoveAt(m_iDataGridViewCurrentRowIndex);
}
else
{
qty = qty - 1;
COrderDetails tempOrderDetails = new COrderDetails();
CResult oResult = tempOrderManager.OrderDetailsByOrderDetailID(Int64.Parse(m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[6].Value.ToString()));
if (oResult.IsSuccess && oResult.Data != null)
{
tempOrderDetails = (COrderDetails)oResult.Data;
}
tempOrderDetails.OrderQuantity = qty;
tempOrderDetails.OrderAmount = qty * unitPrice;
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[1].Value = qty;
m_dDataGridView.Rows[m_iDataGridViewCurrentRowIndex].Cells[2].Value = ((double)(qty * unitPrice)).ToString("F02");
}
m_dDataGridView.Update();
TotalAmountCalculation();
m_dDataGridView.ClearSelection();
}
catch (Exception eee)
{
}
}
private void g_MiscButton_Click(object sender, EventArgs e)
{
try
{
CKeyBoardForm tempKeyBoardForm = new CKeyBoardForm("Misc Item", "Enter Item Name or Description");
tempKeyBoardForm.ShowDialog();
if (CKeyBoardForm.Content.Equals("Cancel"))
return;
if (CKeyBoardForm.Content.Equals(""))
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Item Name cannot be Empty");
tempMessageBox.ShowDialog();
return;
}
CPriceCalculatorForm tempCalculatorForm = new CPriceCalculatorForm("Misc Item", "Enter Price");
tempCalculatorForm.ShowDialog();
if (CPriceCalculatorForm.inputResult.Equals("Cancel"))
return;
if (CPriceCalculatorForm.inputResult.Equals("0.000"))
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Price cannot be zero.");
tempMessageBox.ShowDialog();
return;
}
NewOrder();
COrderManager tempOrderManager = new COrderManager();
COrderDetails tempOrderDetails = new COrderDetails();
DataGridView tempDataGridView = g_FoodDataGridView;
int tempResult = DataGridViewSearch(tempDataGridView, CKeyBoardForm.Content);
if (tempResult != -1)
{
//update Order_details table
int tempRowIndex = tempResult;
tempDataGridView.Rows[tempRowIndex].Cells[1].Value = int.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString()) + m_iSavedOrderedQty;
tempOrderDetails.OrderDetailsID = Int64.Parse(tempDataGridView.Rows[tempRowIndex].Cells[6].Value.ToString());
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = 0;
tempOrderDetails.CategoryLevel = 0;
tempOrderDetails.OrderRemarks = CKeyBoardForm.Content;
tempOrderDetails.OrderQuantity = Int32.Parse(tempDataGridView.Rows[tempRowIndex].Cells[1].Value.ToString());
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(CPriceCalculatorForm.inputResult);
tempOrderDetails.OrderFoodType = "Nonfood";
tempOrderManager.UpdateOrderDetails(tempOrderDetails);
}
else
{
//Insert into Order_details table
tempOrderDetails.OrderID = orderID;
tempOrderDetails.ProductID = 0;
tempOrderDetails.CategoryLevel = 0;
tempOrderDetails.OrderRemarks = CKeyBoardForm.Content;
tempOrderDetails.OrderQuantity = m_iSavedOrderedQty;
tempOrderDetails.OrderAmount = tempOrderDetails.OrderQuantity * Double.Parse(CPriceCalculatorForm.inputResult);
tempOrderDetails.OrderFoodType = "Nonfood";
tempOrderDetails = (COrderDetails)tempOrderManager.InsertOrderDetails(tempOrderDetails).Data;
string[] tempDataGridViewRow = new string[]
{ CKeyBoardForm.Content,
m_iSavedOrderedQty.ToString(),
CPriceCalculatorForm.inputResult,
"0",
"0",
(Int64.MaxValue-1)+"",
tempOrderDetails.OrderDetailsID.ToString()
};
tempDataGridView.Rows.Add(tempDataGridViewRow);
}
ConvertRank();
tempDataGridView.Sort(tempDataGridView.Columns[5], ListSortDirection.Ascending);
tempDataGridView.Update();
TotalAmountCalculation();
m_iSavedOrderedQty = 1;
g_FoodDataGridView.ClearSelection();
}
catch (Exception eee)
{
}
}
