private COrderDiscount ReaderToOrderDiscount(IDataReader inReader) { COrderDiscount tempOrderDiscount = new COrderDiscount(); if (inReader["order_id"] != null) tempOrderDiscount.OrderID = Int64.Parse(inReader["order_id"].ToString()); if (inReader["discount"] != null) tempOrderDiscount.Discount = Double.Parse(inReader["discount"].ToString()); return tempOrderDiscount; }
public CResult UpdateOrderDiscount(COrderDiscount inOrderDiscount) { try { m_oResult = Database.Instance.OrderInfo.UpdateOrderDiscount(inOrderDiscount); m_oResult.Message = "Data Updated Successfully"; } catch (Exception ex) { System.Console.WriteLine("Exception occuer at UpdateOrderDiscount() : " + ex.Message); m_oResult.IsException = true; m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE; //m_oResult.SetParams(ex.Message); m_oResult.Message = ex.Message; Logger.Write("Exception : " + ex + " in UpdateOrderDiscount()", LogLevel.Error, "COrderManager"); } return m_oResult; }
/// <summary> /// Total amount in the gridview of the selected order /// </summary> private void TotalAmountCalculation() { try { Decimal MainFoodTotal = 0;//@Salim Only for Main Item with out additional service charge or discount Decimal vatTotal = 0; Decimal tempTotal = 0; for (int foodCounter = 0; foodCounter < g_FoodDataGridView.Rows.Count; foodCounter++) { if (g_FoodDataGridView[3, foodCounter].Value != null && !g_FoodDataGridView[2, foodCounter].Value.ToString().Equals("")) { tempTotal += Decimal.Parse(g_FoodDataGridView[3, foodCounter].Value.ToString()); vatTotal += Decimal.Parse(g_FoodDataGridView[2, foodCounter].Value.ToString()); } } for (int beverageCounter = 0; beverageCounter < g_BeverageDataGridView.Rows.Count; beverageCounter++) { if (g_BeverageDataGridView[3, beverageCounter].Value != null && !g_BeverageDataGridView[2, beverageCounter].Value.ToString().Equals("")) { tempTotal += Decimal.Parse(g_BeverageDataGridView[3, beverageCounter].Value.ToString()); try { vatTotal += Decimal.Parse(g_BeverageDataGridView[2, beverageCounter].Value.ToString()); } catch { } } } MainFoodTotal = tempTotal; Decimal discountAmount = 0; decimal membershipDiscountAmount = 0; if (m_sDiscountType.Equals("Fixed")) { discountAmount = m_dDiscountAmount; } else if (m_sDiscountType.Equals("Percent")) { discountAmount = MainFoodTotal * m_dDiscountAmount / 100; // HOW CAN THIS BE CALCULATED IN SUCH WAY } COrderManager tempOrderManager = new COrderManager(); COrderDiscount tempOrderDiscount = new COrderDiscount(); CResult oResult = tempOrderManager.OrderDiscountGetByOrderID(orderID); double itemDiscount = 0; if (oResult.IsSuccess && oResult.Data != null) { tempOrderDiscount = (COrderDiscount)oResult.Data; itemDiscount = tempOrderDiscount.TotalItemDiscount; if (membership != null && membership.id > 0) { tempOrderDiscount.clientID = membership.customerID; tempOrderDiscount.membershipCardID = membership.mebershipCardID; tempOrderDiscount.membershipID = membership.id; tempOrderDiscount.membershipPoint = membership.point; tempOrderDiscount.membershipDiscountRate = membership.discountPercentRate; if (tempOrderDiscount.membershipDiscountRate > 0) { tempOrderDiscount.membershipTotalPoint = 0; tempOrderDiscount.membershipDiscountAmount = float.Parse(tempTotal.ToString()) * tempOrderDiscount.membershipDiscountRate / 100; } else { tempOrderDiscount.membershipTotalPoint = float.Parse(tempTotal.ToString()) * tempOrderDiscount.membershipTotalPoint / 100; tempOrderDiscount.membershipDiscountAmount = 0; } } else if (tempOrderDiscount.membershipID > 0 && tempOrderDiscount.membershipDiscountRate > 0) { tempOrderDiscount.membershipTotalPoint = 0; tempOrderDiscount.membershipDiscountAmount = float.Parse(tempTotal.ToString()) * tempOrderDiscount.membershipDiscountRate / 100; } //update tempOrderDiscount.Discount = Convert.ToDouble(discountAmount); discountAmount = (decimal)tempOrderDiscount.Discount; tempOrderManager.UpdateOrderDiscount(tempOrderDiscount); lblMembershipDiscountValue.Text = tempOrderDiscount.membershipDiscountAmount.ToString("F2"); membershipDiscountAmount = decimal.Parse(tempOrderDiscount.membershipDiscountAmount.ToString()); } else { //insert tempOrderDiscount.OrderID = orderID; tempOrderDiscount.Discount = Convert.ToDouble(discountAmount); discountAmount = (decimal)tempOrderDiscount.Discount; if (membership != null && membership.id > 0) { tempOrderDiscount.clientID = membership.customerID; tempOrderDiscount.membershipCardID = membership.mebershipCardID; tempOrderDiscount.membershipID = membership.id; tempOrderDiscount.membershipPoint = membership.point; tempOrderDiscount.membershipDiscountRate = membership.discountPercentRate; if (tempOrderDiscount.membershipDiscountRate > 0) { tempOrderDiscount.membershipTotalPoint = 0; tempOrderDiscount.membershipDiscountAmount = float.Parse(tempTotal.ToString()) * tempOrderDiscount.membershipDiscountRate / 100; lblMembershipDiscountValue.Text = tempOrderDiscount.membershipDiscountAmount.ToString("F2"); } else { tempOrderDiscount.membershipTotalPoint = float.Parse(tempTotal.ToString()) * tempOrderDiscount.membershipTotalPoint / 100; tempOrderDiscount.membershipDiscountAmount = 0; } } tempOrderManager.InsertOrderDiscount(tempOrderDiscount); lblMembershipDiscountValue.Text = tempOrderDiscount.membershipDiscountAmount.ToString("F2"); membershipDiscountAmount = decimal.Parse(tempOrderDiscount.membershipDiscountAmount.ToString()); } #region "Service Charge" ServiceCharge tempOrderCharge = new ServiceCharge(); CResult cResult = tempOrderManager.OrderServiceChargeGetByOrderID(orderID); double chargeAmount = 0.000; if (m_chargeType.Equals("Fixed")) { if (cResult.IsSuccess && cResult.Data != null) { tempOrderCharge = (ServiceCharge) cResult.Data; chargeAmount = tempOrderCharge.ServiceChargeAmount; } } else if (m_chargeType.Equals("Percent")) { // chargeAmount = tempTotal * m_chargeAmount / 100; chargeAmount = Convert.ToDouble(MainFoodTotal) * m_chargeAmount / 100; } if (cResult.IsSuccess && cResult.Data != null) { tempOrderCharge = (ServiceCharge)cResult.Data; //update tempOrderCharge.ServiceChargeAmount = Convert.ToDouble(chargeAmount); tempOrderManager.UpdateOrderServiceCharge(tempOrderCharge); } else { // UpdateServiceCharge(); //insert // tempOrderCharge.OrderID = orderID; // tempOrderCharge.ServiceChargeAmount = Convert.ToDouble(chargeAmount); // tempOrderManager.InsertOrderServiceCharge(tempOrderCharge); } g_serviceCharge.Text = chargeAmount.ToString("F02"); #endregion g_SubtotalLabel.Text = MainFoodTotal.ToString("F02"); tempTotal = MainFoodTotal - discountAmount; decimal d = decimal.Round(decimal.Parse(discountAmount.ToString()), 2); g_DiscountLabel.Text = discountAmount.ToString("F02"); tempTotal = tempTotal + decimal.Parse(g_serviceCharge.Text); // lblVat.Text = (tempTotal * Convert.ToDecimal(vat / 100)).ToString("F02"); // lblVat.Text = (MainFoodTotal * Convert.ToDecimal(vat / 100)).ToString("F02"); lblVat.Text=vatTotal.ToString(); tempTotal = MainFoodTotal + decimal.Parse(g_serviceCharge.Text) + decimal.Parse(lblVat.Text) - decimal.Parse(g_DiscountLabel.Text)-membershipDiscountAmount-(decimal) itemDiscount; g_AmountLabel.Text = tempTotal.ToString("F02"); TableValueStatusLabel.Text = " Total Value £" + tempTotal.ToString("F02"); totalItemWiseDiscountlabel.Text = itemDiscount.ToString("F02"); try { // UpdateServiceCharge(); } catch (Exception) { throw; } } catch (Exception exp) { Console.Write(exp.Message); } }
public CResult UpdateOrderDiscount(COrderDiscount inOrderDiscount) { CResult oResult = new CResult(); try { this.OpenConnection(); string sSql = string.Format(SqlQueries.GetQuery(Query.OrderDiscountUpdate), inOrderDiscount.Discount, inOrderDiscount.OrderID); this.ExecuteNonQuery(sSql); oResult.IsSuccess = true; } catch (Exception ex) { Logger.Write("Exception : " + ex + " in UpdateOrderDiscount()", LogLevel.Error, "Database"); // throw new Exception("Exception occure at InsertOrderSeatTime()", ex); oResult.IsException = true; } finally { this.CloseConnection(); } return oResult; }
private void functionalButton1_Click_2(object sender, EventArgs e) { CResult aCResult = new CResult(); CUserInfoDAO aUserInfoDao = new CUserInfoDAO(); CUserInfo aUserInfo = new CUserInfo(); aUserInfo.UserID = RMSGlobal.m_iLoginUserID; aCResult = aUserInfoDao.GetUser(aUserInfo); aUserInfo = (CUserInfo)aCResult.Data; if (aUserInfo.Type != 0) { MessageBox.Show("You are not correct person to give Item Complementory Opportunity"); return; } CDiscountForm tempDiscountForm = new CDiscountForm(); tempDiscountForm.ShowDialog(); if (CDiscountForm.discountType.Equals("Cancel")) return; double discountAmount = Convert.ToDouble(CDiscountForm.discountAmount); string discountType = CDiscountForm.discountType; COrderDetailsDAO aOrderInfoDao = new COrderDetailsDAO(); foreach (DataGridViewRow row in g_FoodDataGridView.Rows) { if (Convert.ToBoolean(row.Cells["complementoryfood"].Value) == true) { COrderDetails aCOrderDetails = new COrderDetails(); aCOrderDetails.OrderDetailsID = Convert.ToInt64(row.Cells["Order_details_id"].Value); aCOrderDetails = aOrderInfoDao.OrderDetailsGetByOrderDetailID(aCOrderDetails.OrderDetailsID); double totalAmount = aCOrderDetails.UnitPrice*aCOrderDetails.OrderQuantity; double discount=0; if (discountType == "Fixed") { discount = discountAmount; } else { discount = (totalAmount*discountAmount)/100.0; } aCOrderDetails.DiscountAmount = discount; string result = aOrderInfoDao.UpdateItemWiseDiscountForItem(aCOrderDetails); } } foreach (DataGridViewRow row in g_BeverageDataGridView.Rows) { if (Convert.ToBoolean(row.Cells["complementorynonfood"].Value) == true) { COrderDetails aCOrderDetails = new COrderDetails(); aCOrderDetails.OrderDetailsID = Convert.ToInt64(row.Cells["dataGridViewTextBoxColumn5"].Value); aCOrderDetails = aOrderInfoDao.OrderDetailsGetByOrderDetailID(aCOrderDetails.OrderDetailsID); double totalAmount = aCOrderDetails.UnitPrice * aCOrderDetails.OrderQuantity; double discount = 0; if (discountType == "Fixed") { discount = discountAmount; } else { discount = (totalAmount * discountAmount) / 100.0; } aCOrderDetails.DiscountAmount = discount; string result = aOrderInfoDao.UpdateItemWiseDiscountForItem(aCOrderDetails); } } CResult oResult1 = aOrderInfoDao.OrderDetailsGetByOrderID(orderID); List<COrderDetails> aOrderDetailses = oResult1.Data as List<COrderDetails>; double totalItemDiscount = 0; if (aOrderDetailses != null) { totalItemDiscount = aOrderDetailses.Sum(a => a.DiscountAmount); } COrderManager tempOrderManager = new COrderManager(); COrderDiscount tempOrderDiscount = new COrderDiscount(); CResult oResult = tempOrderManager.OrderDiscountGetByOrderID(orderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDiscount = (COrderDiscount)oResult.Data; tempOrderDiscount.TotalItemDiscount = totalItemDiscount; tempOrderManager.UpdateOrderDiscount(tempOrderDiscount); } else { //insert tempOrderDiscount.OrderID = orderID; tempOrderDiscount.TotalItemDiscount = totalItemDiscount; tempOrderManager.InsertOrderDiscount(tempOrderDiscount); } LoadOrderDetails(); }
/// <summary> /// This function loads the items details information. /// </summary> private void LoadOrderDetails() { g_FoodDataGridView.Rows.Clear(); g_BeverageDataGridView.Rows.Clear(); FillRMSDataGridView(); g_FoodDataGridView.ClearSelection(); g_BeverageDataGridView.ClearSelection(); if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper()) { COrderManager tempOrderManager = new COrderManager(); List<COrderDetails> tempOrderDetailsList = new List<COrderDetails>(); CResult oResult = tempOrderManager.OrderDetailsByOrderID(orderID); if (oResult.IsSuccess && oResult.Data != null) tempOrderDetailsList = (List<COrderDetails>)oResult.Data; for (int itemIndex = 0; itemIndex < tempOrderDetailsList.Count; itemIndex++) { Int64 tempProductID = tempOrderDetailsList[itemIndex].ProductID; int tempCategoryLevel = tempOrderDetailsList[itemIndex].CategoryLevel; string tempProductName = ""; if (tempCategoryLevel == 3) { DataRow[] tempDataRowArr = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempProductID); if (tempDataRowArr.Length > 0) //Added by Baruri .This was a bug previously when no row found. { tempProductName = tempDataRowArr[0]["cat3_name"].ToString(); } } else if (tempCategoryLevel == 4) { DataRow[] tempDataRowArr = Program.initDataSet.Tables["Category4"].Select("cat4_id = " + tempProductID); int tempCat3_id = 0; if (tempDataRowArr.Length > 0) { tempCat3_id = Convert.ToInt32("0" + tempDataRowArr[0]["cat3_id"]); } tempProductName = Program.initDataSet.Tables["Category4"].Select("cat4_id = " + tempProductID)[0]["cat4_name"].ToString(); tempDataRowArr = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCat3_id); if (tempDataRowArr.Length > 0)//If rows found { tempProductName += " " + tempDataRowArr[0]["cat3_name"].ToString(); } } else if (tempCategoryLevel == 0) { tempProductName = tempOrderDetailsList[itemIndex].OrderRemarks; } int tempFoodType = 1; if (tempCategoryLevel == 3) { tempFoodType = int.Parse(Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempProductID)[0].GetParentRow(Program.initDataSet.Relations["category2_to_category3"])["cat2_type"].ToString()); } else if (tempCategoryLevel == 4) { int tempCat3_id = int.Parse(Program.initDataSet.Tables["Category4"].Select("cat4_id = " + tempProductID)[0].GetParentRow(Program.initDataSet.Relations["category3_to_category4"])["cat3_id"].ToString()); tempFoodType = int.Parse(Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCat3_id)[0].GetParentRow(Program.initDataSet.Relations["category2_to_category3"])["cat2_type"].ToString()); } else { tempFoodType = -1; } DataGridView tempDataGridView = new DataGridView(); if (tempFoodType == 1)//Food Type { tempDataGridView = g_FoodDataGridView; } else if (tempFoodType == 0)//Nonfood Type { tempDataGridView = g_BeverageDataGridView; } else if (tempFoodType == -1) { if (tempOrderDetailsList[itemIndex].OrderFoodType == "Food") { tempDataGridView = g_FoodDataGridView; } else { tempDataGridView = g_BeverageDataGridView; } } //if remarks exists append it... otherwise append nothing... bool sele = false; string appendString = ""; if (tempCategoryLevel != 0) appendString = (tempOrderDetailsList[itemIndex].OrderRemarks.Equals("")) ? ("") : (" (" + tempOrderDetailsList[itemIndex].OrderRemarks + ")"); string[] tempDataGridViewRow = { tempProductName+appendString, tempOrderDetailsList[itemIndex].OrderQuantity.ToString(), ((double)tempOrderDetailsList[itemIndex].VatTotal).ToString("F02"), ((double)tempOrderDetailsList[itemIndex].OrderAmount).ToString("F02"), tempOrderDetailsList[itemIndex].ProductID.ToString(), tempOrderDetailsList[itemIndex].CategoryLevel.ToString(), (Int64.MaxValue-1)+"",//max rank tempOrderDetailsList[itemIndex].OrderDetailsID.ToString(), tempOrderDetailsList[itemIndex].PrintedQuantity.ToString(), tempOrderDetailsList[itemIndex].UnitPrice.ToString("F2"), }; //not misc item... rank is specified if (tempCategoryLevel != 0) { try { tempDataGridViewRow[6] = Program.initDataSet.Tables["Category" + tempCategoryLevel].Select("cat" + tempCategoryLevel + "_id = " + tempProductID)[0]["cat" + tempCategoryLevel + "_rank"].ToString(); } catch { } } try { tempDataGridView.Rows.Add(tempDataGridViewRow); } catch (Exception ex) { // MessageBox.Show(ex.ToString()); } ConvertRank(); if (tempDataGridView.Columns["Order_details_id"] !=null) tempDataGridView.Sort(tempDataGridView.Columns["Order_details_id"], ListSortDirection.Descending); if (tempDataGridView.Columns["dataGridViewTextBoxColumn5"] != null) tempDataGridView.Sort(tempDataGridView.Columns["dataGridViewTextBoxColumn5"], ListSortDirection.Descending); //this.FillCategory1OrderNumber();//New //tempDataGridView.Sort(tempDataGridView.Columns[5], ListSortDirection.Ascending); tempDataGridView.Update(); } //get discount COrderDiscount tempOrderDiscount = new COrderDiscount(); oResult = tempOrderManager.OrderDiscountGetByOrderID(orderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDiscount = (COrderDiscount)oResult.Data; m_dDiscountAmount = Convert.ToDecimal(tempOrderDiscount.Discount.ToString("F02")); } } else { //Loading the online orders information //g_FoodDataGridView.RowCount = 0; COrderManager tempOrderManager = new COrderManager(); string remarks = ""; string itemName = ""; List<COrderDetails> tempOrderDetailsList = new List<COrderDetails>(); CResult oResult = tempOrderManager.GetOnlineOrderDetailsByOrderID(orderID); if (oResult.IsSuccess && oResult.Data != null) tempOrderDetailsList = (List<COrderDetails>)oResult.Data; for (int counter = 0; counter < tempOrderDetailsList.Count; counter++) { remarks = tempOrderDetailsList[counter].OrderRemarks.ToString(); itemName = tempOrderDetailsList[counter].ItemName.ToString(); if (remarks.Length > 0) { itemName = itemName + "(" + remarks + ")"; } string[] tempDataGridViewRow = { itemName, tempOrderDetailsList[counter].OrderQuantity.ToString(), tempOrderDetailsList[counter].OrderAmount.ToString("F02"), tempOrderDetailsList[counter].CategoryID.ToString(), tempOrderDetailsList[counter].CategoryLevel.ToString(), tempOrderDetailsList[counter].Rank.ToString(), tempOrderDetailsList[counter].OrderDetailsID.ToString(), tempOrderDetailsList[counter].PrintedQuantity.ToString(), tempOrderDetailsList[counter].UnitPrice.ToString("F2"), }; if (tempOrderDetailsList[counter].OrderFoodType.Replace(" ", "").ToUpper() == "Food".Replace(" ", "").ToUpper()) { g_FoodDataGridView.Rows.Add(tempDataGridViewRow); g_FoodDataGridView.Sort(g_FoodDataGridView.Columns[5], ListSortDirection.Ascending); } else { g_BeverageDataGridView.Rows.Add(tempDataGridViewRow); //If drinks g_BeverageDataGridView.Sort(g_BeverageDataGridView.Columns[5], ListSortDirection.Ascending); } } //get discount COrderDiscount tempOrderDiscount = new COrderDiscount(); oResult = tempOrderManager.OrderDiscountGetByOrderID(orderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDiscount = (COrderDiscount)oResult.Data; m_dDiscountAmount = Convert.ToDecimal(tempOrderDiscount.Discount.ToString("F02")); } } this.TotalAmountCalculation(); g_FoodDataGridView.ClearSelection(); g_BeverageDataGridView.ClearSelection(); try { this.SetPrintedItemBackColor(); //set the back color } catch { } }
private void TotalAmountCalculation() { try { Double tempTotal = new Double(); tempTotal = 0.0; for (int rowCounter = 0; rowCounter < g_FoodDataGridView.Rows.Count; rowCounter++) { if (g_FoodDataGridView[2, rowCounter].Value != null && !g_FoodDataGridView[2, rowCounter].Value.ToString().Equals("")) { tempTotal += Double.Parse(g_FoodDataGridView[2, rowCounter].Value.ToString()); } } Double discountAmount = 0.000; if (m_sDiscountType.Equals("Fixed")) { discountAmount = m_dDiscountAmount; } else if (m_sDiscountType.Equals("Percent")) { discountAmount = tempTotal * m_dDiscountAmount / 100; } COrderManager tempOrderManager = new COrderManager(); COrderDiscount tempOrderDiscount = new COrderDiscount(); CResult oResult = tempOrderManager.OrderDiscountGetByOrderID(orderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDiscount = (COrderDiscount)oResult.Data; //update tempOrderDiscount.Discount = discountAmount; tempOrderManager.UpdateOrderDiscount(tempOrderDiscount); } else { //insert tempOrderDiscount.OrderID = orderID; tempOrderDiscount.Discount = discountAmount; tempOrderManager.InsertOrderDiscount(tempOrderDiscount); } tempTotal = tempTotal - discountAmount; g_DiscountLabel.Text = discountAmount.ToString("F02"); g_BalanceLabel.Text = tempTotal.ToString("F02"); numericInputButton13.Text = "�"+tempTotal.ToString("F02"); TableValueStatusLabel.Text = " Total Value �" + tempTotal.ToString("F02")+" "; TableValueStatusLabel.Visible = true; } catch (Exception exp) { throw exp; } }
private void FillNonFoods() { g_FoodDataGridView.RowCount = 0; COrderManager tempOrderManager = new COrderManager(); List<COrderDetails> tempOrderDetailsList = new List<COrderDetails>(); CResult oResult = tempOrderManager.OrderDetailsByOrderID(orderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDetailsList = (List<COrderDetails>)oResult.Data; } for (int detailsCounter = 0; detailsCounter < tempOrderDetailsList.Count; detailsCounter++) { Int64 tempProductID = tempOrderDetailsList[detailsCounter].ProductID; int tempCategoryLevel = tempOrderDetailsList[detailsCounter].CategoryLevel; string tempProductName = ""; if (tempCategoryLevel == 3) { DataRow[] tempDataRowArr = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempProductID); tempProductName = tempDataRowArr[0]["cat3_name"].ToString(); } else if (tempCategoryLevel == 4) { //Latest name is at first int tempCat3_id = int.Parse(Program.initDataSet.Tables["Category4"].Select("cat4_id = " + tempProductID)[0].GetParentRow(Program.initDataSet.Relations["category3_to_category4"])["cat3_id"].ToString()); tempProductName += Program.initDataSet.Tables["Category4"].Select("cat4_id = " + tempProductID)[0]["cat4_name"].ToString(); tempProductName += " " + Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCat3_id)[0]["cat3_name"].ToString(); } else if (tempCategoryLevel == 0) tempProductName = tempOrderDetailsList[detailsCounter].OrderRemarks; int tempFoodType = 0; DataGridView tempDataGridView = new DataGridView(); tempDataGridView = g_FoodDataGridView; string[] tempDataGridViewRow = { tempProductName, tempOrderDetailsList[detailsCounter].OrderQuantity.ToString(), ((double)tempOrderDetailsList[detailsCounter].OrderAmount).ToString("F02"), tempOrderDetailsList[detailsCounter].ProductID.ToString(), tempOrderDetailsList[detailsCounter].CategoryLevel.ToString(), (Int64.MaxValue-1)+"",//max rank tempOrderDetailsList[detailsCounter].OrderDetailsID.ToString() }; //not misc item... rank is specified if (tempCategoryLevel != 0) tempDataGridViewRow[5] = Program.initDataSet.Tables["Category" + tempCategoryLevel].Select("cat" + tempCategoryLevel + "_id = " + tempProductID)[0]["cat" + tempCategoryLevel + "_rank"].ToString(); tempDataGridView.Rows.Add(tempDataGridViewRow); ConvertRank(); tempDataGridView.Sort(tempDataGridView.Columns[5], ListSortDirection.Ascending); tempDataGridView.Update(); g_FoodDataGridView.ClearSelection(); } //get discount COrderDiscount tempOrderDiscount = new COrderDiscount(); oResult = tempOrderManager.OrderDiscountGetByOrderID(orderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDiscount = (COrderDiscount)oResult.Data; m_dDiscountAmount = tempOrderDiscount.Discount; } if (category2ButtonList.Count > CATEGORY2PANEL_CAPACITY) g_NextButton.Enabled = true; else g_NextButton.Enabled = false; g_PreviousButton.Enabled = false; TotalAmountCalculation(); LoadStatusBar(); }
private void UpdateCalculation(int paymentMethodIndex) { try { Double tempTotalPaid = 0.0; Debug.WriteLine("UpdateCalc 1"); tempTotalPaid += Double.Parse(g_CashLabel.Text.Substring(Program.currency.Length)) + Double.Parse(g_EFTLabel.Text.Substring(Program.currency.Length)) + Double.Parse(g_ChequeLabel.Text.Substring(Program.currency.Length)) + Double.Parse(g_AccountLabel.Text.Substring(Program.currency.Length)) + Double.Parse(complementorylabel.Text.Substring(Program.currency.Length)); Debug.WriteLine("UpdateCalc 2"); Double tempBillTotal = m_dTotalAmount + Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)); Debug.WriteLine("UpdateCalc 3"); Double tempDifference = tempBillTotal - tempTotalPaid; Debug.WriteLine("UpdateCalc 4"); if (tempDifference > 0) { m_dBalance = tempDifference; g_BalaceLabel.Text = String.Format("Balance Due {0}" + m_dBalance.ToString("F02"), Program.currency); Debug.WriteLine("UpdateCalc 5"); } else { if (CurrentPaymentMethod.Equals("Cash")) { if (m_isAddServiceCharge == false) { g_CashLabel.Text = Program.currency + m_dBalance.ToString("F02"); } } else if (CurrentPaymentMethod.Equals("EFT")) { if (m_isAddServiceCharge == false) { g_EFTLabel.Text = Program.currency + m_dBalance.ToString("F02"); } } else if (CurrentPaymentMethod.Equals("Due")) { if (m_isAddServiceCharge == false) { g_ChequeLabel.Text = Program.currency + m_dBalance.ToString("F02"); } } else if (CurrentPaymentMethod.Equals("Voucher")) { if (m_isAddServiceCharge == false) { g_VoucherLabel.Text = Program.currency + m_dBalance.ToString("F02"); } } else if (CurrentPaymentMethod.Equals("Account")) { if (m_isAddServiceCharge == false) { g_AccountLabel.Text = Program.currency + m_dBalance.ToString("F02"); } } else if (CurrentPaymentMethod.Equals("Discount")) { g_DiscountLabel.Text = Program.currency + m_dBalance.ToString("F02"); } else if (CurrentPaymentMethod.Equals("Deposit")) { g_DepositUsedLabel.Text = Program.currency + m_dBalance.ToString("F02"); } else if (CurrentPaymentMethod.Equals("Complementory")) { if (m_isAddServiceCharge == false) { complementorylabel.Text = Program.currency + m_dBalance.ToString("F02"); } } Debug.WriteLine("UpdateCalc 6"); m_dBalance = -tempDifference; g_BalaceLabel.Text = "Pay Back " + Program.currency + (m_dBalance-tipsamount).ToString("F02"); Debug.WriteLine("UpdateCalc 7"); CPaymentManager tempPaymentManager = new CPaymentManager(); /***********************/ /********New Print******/ /***********************/ if (isCheatManuallyhandled()) { DialogResult dresult = MessageBox.Show("Make It Open?", "Message", MessageBoxButtons.YesNo); if (dresult == DialogResult.Yes) { makeOpen = true; } if (dresult == DialogResult.No) { makeOpen = false; } } DataSet tempDataSet = new DataSet(); tempDataSet.ReadXml("Config/Print_Config.xml"); if (tempDataSet.Tables[0].Rows[0]["PrintPaymentBill"].ToString().ToLower().Equals("true")) { Debug.WriteLine("UpdateCalc 17"); PrintPaymentBill(paymentMethodIndex);//Payment method index .Cash=1,EFT=2,Cheque=3 } COrderManager temmpOrderManager = new COrderManager(); COrderDiscount tempOrderDiscount = new COrderDiscount(); CResult ooResult = temmpOrderManager.OrderDiscountGetByOrderID(m_iOrderID); double itemDiscount = 0; if (ooResult.IsSuccess && ooResult.Data != null) { tempOrderDiscount = (COrderDiscount) ooResult.Data; itemDiscount = tempOrderDiscount.TotalItemDiscount; } //Check whether payment data exists if (m_cPayment == null) { Debug.WriteLine("UpdateCalc 8"); ///insert into payment table CPayment tempPayment = new CPayment(); tempPayment.OrderID = m_iOrderID; //get pc id from pc ip CPcInfoManager tempPcInfoManager = new CPcInfoManager(); IPHostEntry ipEntry = System.Net.Dns.GetHostByName(Dns.GetHostName()); CPcInfo tempPcInfo = (CPcInfo)tempPcInfoManager.PcInfoByPcIP(ipEntry.AddressList[0].ToString()).Data; tempPayment.PcID = tempPcInfo.PcID; Debug.WriteLine("UpdateCalc 9"); tempPayment.TotalAmount = m_dTotalAmount; tempPayment.CashAmount = Double.Parse(g_CashLabel.Text.Substring(Program.currency.Length)); tempPayment.EFTAmount = Double.Parse(g_EFTLabel.Text.Substring(Program.currency.Length)); tempPayment.ChequeAmount = Double.Parse(g_ChequeLabel.Text.Substring(Program.currency.Length)); tempPayment.ServiceAmount = m_serviceCharge_cash + m_serviceCharge_voucher + m_serviceCharge_eft + m_serviceCharge_cheque + m_serviceCharge_accounts - tipsamount; //Double.Parse(g_ServiceChargeLabel.Text.Substring(Program.currency.Length)); tempPayment.VoucherAmount = Double.Parse(complementorylabel.Text.Substring(Program.currency.Length)); tempPayment.Discount = Double.Parse(g_DiscountLabel.Text.Substring(Program.currency.Length)); tempPayment.AccountPay = Double.Parse(g_AccountLabel.Text.Substring(Program.currency.Length)); tempPayment.DepositID = m_oDeposit.DepositID; tempPayment.DepositAmount = Double.Parse(g_DepositUsedLabel.Text.Substring(Program.currency.Length)); tempPayment.PaymentTime = System.DateTime.Now; tempPayment.ServiceChargeCash = m_serviceCharge_cash; tempPayment.ServiceChargeCheque = m_serviceCharge_cheque; tempPayment.ServiceChargeEft = m_serviceCharge_eft; tempPayment.ServiceChargeVoucher = m_serviceCharge_voucher; tempPayment.ServiceChargeAcc = m_serviceCharge_accounts; tempPayment.DueMessage = dueMessage; tempPayment.ComplementoryMessage = complementoryMessage; double totalCost = GetTotalCost(m_iOrderID); tempPayment.TotalCost = totalCost; tempPayment.TipsAmount = tipsamount; tempPayment.VatImposed = Program.vat.ToString(); tempPayment.membershipDiscount = (double)membershipdiscount; tempPayment.ItemDiscount = itemDiscount; //tempPayment.VatImposed = Program.vat.ToString(); tempPayment.GuestBill = gusetBillStr; COrderWaiterDao orderWaiterDao = new COrderWaiterDao(); // Change by Mithu COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(m_iOrderID); // Change by Mithu try { tempPayment.Waiter = orderWaiter.WaiterName; } catch (Exception) { } if (makeOpen) tempPayment.Vat_stat = true; else tempPayment.Vat_stat = false; tempPayment.PaymentPerson = RMSGlobal.LoginUserName; DataSet tempStockDataSet = new DataSet(); tempStockDataSet.ReadXml("Config/StockSetting.xml"); bool isAllowedToOrder = Convert.ToBoolean(tempStockDataSet.Tables[0].Rows[0]["AllowedtoOrder"].ToString()); if (!isAllowedToOrder) { COrderDetailsDAO aDao = new COrderDetailsDAO(); List<COrderDetails> aList = new List<COrderDetails>(); double cost = 0.0; try { aList = aDao.OrderDetailsGetAll(); var check = from list in aList where list.OrderID == tempPayment.OrderID select list; SaleReportDAO aSaleReportDao = new SaleReportDAO(); aSaleReportDao.InsertOrUpdateSaleRawmaterialsReport(check); } catch { } } CResult oResult = tempPaymentManager.InsertPayment(tempPayment); if (oResult.IsSuccess && oResult.Data != null) { tempPayment = (CPayment)oResult.Data; m_cPayment = tempPayment; Debug.WriteLine("UpdateCalc 10"); } } else { Debug.WriteLine("UpdateCalc 11"); //update payment table CPayment tempPayment = new CPayment(); tempPayment.PaymentID = m_cPayment.PaymentID; tempPayment.OrderID = m_iOrderID; tempPayment.TotalAmount = m_dTotalAmount; tempPayment.CashAmount = Double.Parse(g_CashLabel.Text.Substring(Program.currency.Length)); tempPayment.EFTAmount = Double.Parse(g_EFTLabel.Text.Substring(Program.currency.Length)); tempPayment.ChequeAmount = Double.Parse(g_ChequeLabel.Text.Substring(Program.currency.Length)); tempPayment.ServiceAmount = m_serviceCharge_cash + m_serviceCharge_voucher + m_serviceCharge_eft + m_serviceCharge_cheque + m_serviceCharge_accounts - tipsamount; //Double.Parse(g_ServiceChargeLabel.Text.Substring(Program.currency.Length)); tempPayment.VoucherAmount = Double.Parse(complementorylabel.Text.Substring(Program.currency.Length)); tempPayment.Discount = Double.Parse(g_DiscountLabel.Text.Substring(Program.currency.Length)); tempPayment.AccountPay = Double.Parse(g_AccountLabel.Text.Substring(Program.currency.Length)); tempPayment.DepositID = m_oDeposit.DepositID; tempPayment.DepositAmount = Double.Parse(g_DepositUsedLabel.Text.Substring(Program.currency.Length)); tempPayment.PaymentTime = System.DateTime.Now; tempPayment.ServiceChargeCash = m_serviceCharge_cash; tempPayment.ServiceChargeCheque = m_serviceCharge_cheque; tempPayment.ServiceChargeEft = m_serviceCharge_eft; tempPayment.ServiceChargeVoucher = m_serviceCharge_voucher; tempPayment.ServiceChargeAcc = m_serviceCharge_accounts; tempPayment.VatImposed = Program.vat.ToString(); tempPayment.TipsAmount = tipsamount; tempPayment.GuestBill = gusetBillStr; tempPayment.membershipDiscount = (double)membershipdiscount; tempPayment.ItemDiscount = itemDiscount; //tempPayment.DueMessage = dueMessage; //tempPayment.ComplementoryMessage = complementoryMessage; if (isCheatManuallyhandled()) { DialogResult dresult = MessageBox.Show("Make It Open?", "Message", MessageBoxButtons.YesNo); if (dresult == DialogResult.Yes) { makeOpen = true; } if (dresult == DialogResult.No) { makeOpen = false; } } if (makeOpen) tempPayment.Vat_stat = true; else tempPayment.Vat_stat = false; tempPayment.PaymentPerson = RMSGlobal.LoginUserName; tempPaymentManager.UpdatePayment(tempPayment); m_cPayment = tempPayment; Debug.WriteLine("UpdateCalc 12"); } //Update Deposit CDepositManager tempDepositManager = new CDepositManager(); tempDepositManager.UpdateDeposit(m_oDeposit); //opening cash drawer try { CPrintMethods tempPrintMethods = new CPrintMethods(); tempPrintMethods.OpenDrawer(); #region "Tracking Area" CCommonConstants m_oCommonConstants; //Drawer Opening log DateTime dtPayment = DateTime.Now; dtPayment = new DateTime(dtPayment.Year, dtPayment.Month, dtPayment.Day, dtPayment.Hour, dtPayment.Minute, dtPayment.Second); Int64 dateTime = dtPayment.Ticks; m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>(); CUserInfo objUserInfo = m_oCommonConstants.UserInfo; tempPaymentManager.SaveDrawerLogs(RMSGlobal.Terminal_Id, objUserInfo.UserName, dateTime); #endregion Debug.WriteLine("UpdateCalc 18"); } catch (Exception eee) { Debug.WriteLine("UpdateCalc 19"); Debug.WriteLine(eee.ToString()); } ///Print Payment Bill /// /* DataSet tempDataSet = new DataSet(); tempDataSet.ReadXml("Config/Print_Config.xml"); if (tempDataSet.Tables[0].Rows[0]["PrintPaymentBill"].ToString().ToLower().Equals("true")) { Debug.WriteLine("UpdateCalc 17"); PrintPaymentBill(paymentMethodIndex);//Payment method index .Cash=1,EFT=2,Cheque=3 } */ COrderManager tempOrderManager = new COrderManager(); COrderInfo tempOrderInfo = null; if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper()) //If local orders are processed { tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(m_iOrderID).Data; tempOrderManager.UpdateOrderInfo(tempOrderInfo); Debug.WriteLine("UpdateCalc 13"); tempOrderManager.InsertOrderArchive(tempOrderInfo); Debug.WriteLine("UpdateCalc 14"); tempOrderManager.InsertOrderDetailsArchive(tempOrderInfo); Debug.WriteLine("UpdateCalc 15"); } else //If online orders are processed { tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(m_iOrderID).Data; tempOrderManager.InsertOnlineOrderArchive(tempOrderInfo); Debug.WriteLine("Online orders archiving"); } tempOrderManager.DeleteTableInfo(tempOrderInfo.TableNumber, m_sTableType); Debug.WriteLine("UpdateCalc 16"); //insert voucher tempOrderManager.InsertOrderVoucher(m_oOrderVoucher); ///back to main screen /// CFormManager.Forms.Pop(); Form tempForm = CFormManager.Forms.Pop(); tempForm.Show(); this.Close(); } g_BalaceLabel.ForeColor = Color.Red; } catch (Exception eee) { //MessageBox.Show(eee.ToString()); Debug.WriteLine("UpdateCalc catch"); Debug.WriteLine(eee.ToString()); } }
private void PrintPaymentBill(int paymentMethodIndex) { bool isPrintA5GuestBill = false; if (isPrintA5GuestBill) { PrintA5GuestBillReport(2); } else { int paperSize = 37; StringPrintFormater strPrintFormatter = new StringPrintFormater(37); COrderWaiterDao orderWaiterDao = new COrderWaiterDao(); // Change by Mithu COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(m_iOrderID); // Change by Mithu m_itemCost = 0.0; CPrintMethodsEXT tempPrintMethods = new CPrintMethodsEXT(); Hashtable htOrderedItems = new Hashtable(); SortedList slOrderedItems = new SortedList(); //string serialHeader = "IBACS RMS"; string serialHeader = ""; //string serialFooter = "Please Come Again"; string serialFooter = ""; string serialBody = ""; serialBody += "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("Bill Payment"); // Change by Mithu COrderManager tempOrderManager = new COrderManager(); COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(m_iOrderID).Data; serialBody += "\r\n\r\n Vat Reg. No: " + Program.vatRegDes; // Change by Mithu serialBody = "\r\nWaiter Name: " + orderWaiter.WaiterName + "\r\n"; serialBody += "\r\n\nOrder ID:" + m_iOrderID.ToString(); //serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); // Change by Mithu if (m_sTableType.Equals("Table")) { serialBody += "\r\n\nTable #" + tempOrderInfo.TableNumber.ToString(); // Change by Mithu serialBody += "\r\n Served by:" + m_OperatorName; // Change by Mithu serialBody += "\r\n\n Cust #" + tempOrderInfo.GuestCount.ToString(); // Change by Mithu //serialBody += "\r\nDate: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt"); // Change by Mithu serialBody += "\r\n" + System.DateTime.Now.ToString("\r\ndd/MM/yy hh:mm tt"); // Change by Mithu } else if (m_sTableType.Equals("TakeAway")) { serialBody += "\r\n\nTake Away" + "Date: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt"); CCustomerManager tempCustomerManager = new CCustomerManager(); CCustomerInfo tempCustomerInfo = (CCustomerInfo)tempCustomerManager.CustomerInfoGetByCustomerID(tempOrderInfo.CustomerID).Data; if (tempCustomerInfo.CustomerName.Length > 0) { serialBody += "\r\nCustomer Name: " + tempCustomerInfo.CustomerName; } if (tempCustomerInfo.CustomerPhone.Length > 0) { serialBody += "\r\nPhone:" + tempCustomerInfo.CustomerPhone; } serialBody += "\r\nType: " + tempOrderInfo.Status; if (tempOrderInfo.Status.Equals("Delivery")) { serialBody += "\r\nAddress:"; serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); if (tempCustomerInfo.FloorAptNumber.Length > 0) { serialBody += "\r\nFloor or Apartment:" + tempCustomerInfo.FloorAptNumber; } if (tempCustomerInfo.BuildingName.Length > 0) { serialBody += "\r\nBuilding Name:" + tempCustomerInfo.BuildingName; } if (tempCustomerInfo.HouseNumber.Length > 0) { serialBody += "\r\nHouse Number:" + tempCustomerInfo.HouseNumber; } string[] street = new string[0]; street = tempCustomerInfo.StreetName.Split('-'); if (street.Length > 1) { if (street[0].ToString().Length > 0) { serialBody += "\r\nStreet:" + street[0].ToString(); } if (street[1].ToString().Length > 0) { serialBody += "\r\n" + street[1].ToString(); } } else if (street.Length > 0 && street.Length < 2) { if (street[0].ToString().Length > 0) { serialBody += "\r\nStreet:" + street[0].ToString(); } } if (tempCustomerInfo.CustomerPostalCode.Length > 0) { serialBody += "\r\nPostal Code:" + tempCustomerInfo.CustomerPostalCode; } if (tempCustomerInfo.CustomerTown.Length > 0) { serialBody += "\r\nTown:" + tempCustomerInfo.CustomerTown; } serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); CDelivery objDelivery = new CDelivery(); objDelivery.DeliveryOrderID = m_iOrderID; CResult objDeliveryInfo = tempOrderManager.GetDeliveryInfo(objDelivery); objDelivery = (CDelivery)objDeliveryInfo.Data; serialBody += "\r\nDelivery Time:" + objDelivery.DeliveryTime; } } else if (m_sTableType.Equals("Tabs")) { serialBody += "\r\n\nBar Service" + " Date: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt"); if (tempOrderInfo.TableNumber != 0) serialBody += "\r\nTab Number: " + tempOrderInfo.TableNumber.ToString(); } serialBody += "\r\n\nOrder Information"; serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); serialBody += "\r\n" + strPrintFormatter.ItemLabeledText("Qty Item", "Price(" + Program.currency + ")"); serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); //serialBody += "\n----------------------------------------"; #region "Local Orders" if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper()) { #region "For Bar service" if (m_dtItemList.Columns.Count == 3) //For bar service { //serialBody += "\r\n----------------------------------------"; serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); for (int rowIndex = 0; rowIndex < m_dtItemList.Rows.Count; rowIndex++) { if (rowIndex == m_iDrinksIndex) // serialBody += "\r\n----------------------------------------"; serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); DataRow tempRow = m_dtItemList.Rows[rowIndex]; serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(tempRow["Qty"].ToString() + " " + tempRow["Item"].ToString(), tempRow["Price"].ToString()); m_itemCost += Convert.ToDouble("0" + tempRow["Price"].ToString()); //New for item cost of the bar service } serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();//Separator after the bar items. } #endregion #region "For foods separator is used " else { string cat2ID = ""; string cat3ID = ""; string cat1ID = ""; Int32 internalCategoryID = 0; Int32 categoryID = 0; string categoryOrder = String.Empty; for (int rowIndex = 0; rowIndex < m_dtItemList.Rows.Count; rowIndex++) { #region "Parent Category" DataRow tempRow = m_dtItemList.Rows[rowIndex]; categoryOrder = String.Empty; if (Convert.ToInt32("0" + tempRow["Catlevel"].ToString()) == 3)//Item from Category 3 { internalCategoryID = Convert.ToInt32("0" + tempRow["Catid"].ToString()); DataRow[] dtRow = dsCategory3.Tables[0].Select("cat3_id = " + internalCategoryID); if (dtRow.Length > 0) { cat2ID = dtRow[0]["cat2_id"].ToString(); DataRow[] dtRowCat2 = dsCategory2.Tables[0].Select("cat2_id = " + cat2ID);//new cat1ID = dtRowCat2[0]["cat1_id"].ToString(); } } else if (Convert.ToInt32("0" + tempRow["Catlevel"].ToString()) == 0)//Item from Category 3 { cat1ID = "0"; cat2ID = "0"; } else { internalCategoryID = Convert.ToInt32("0" + tempRow["Catid"].ToString()); DataRow[] dtRow = dsCategory4.Tables[0].Select("cat4_id = " + internalCategoryID); if (dtRow.Length > 0) { cat3ID = dtRow[0]["cat3_id"].ToString(); } dtRow = dsCategory3.Tables[0].Select("cat3_id = " + cat3ID); if (dtRow.Length > 0) { cat2ID = dtRow[0]["cat2_id"].ToString(); DataRow[] dtRowCat2 = dsCategory2.Tables[0].Select("cat2_id = " + cat2ID);//new cat1ID = dtRowCat2[0]["cat1_id"].ToString(); } } #endregion clsOrderReport objOrderedReport = new clsOrderReport(); objOrderedReport.Quantity = Convert.ToInt32("0" + tempRow["Qty"].ToString()); objOrderedReport.ItemName = tempRow["Item"].ToString(); objOrderedReport.Price = Convert.ToDouble("0" + tempRow["Price"].ToString()); int drinkValue = Convert.ToInt32("0" + tempRow["isdrink"].ToString()); if (drinkValue > 0) { objOrderedReport.DrinkStatus = true; } else { objOrderedReport.DrinkStatus = false; } Int64 rankNumber = Int64.Parse(tempRow["rank"].ToString()); Int32 category1OrderNumber = this.GetCategory1OrderNumber(Convert.ToInt32(cat1ID)); htOrderedItems.Add(category1OrderNumber + "-" + rankNumber + "-" + objOrderedReport.ItemName, objOrderedReport); m_itemCost += Convert.ToDouble("0" + tempRow["Price"].ToString()); } NumericComparer nc = new NumericComparer(); slOrderedItems = new SortedList(htOrderedItems, nc); int keyIndex = 0; string[] valueSplitter = new string[0]; SortedList slDrinkItems = new SortedList(); SortedList slMiscellaneousItems = new SortedList(); PrintUtility printUtility = new PrintUtility(); foreach (clsOrderReport objOrderedItems in slOrderedItems.Values) { objOrderedItems.ItemName = objOrderedItems.ItemName.Replace("''", "'"); objOrderedItems.ItemName = objOrderedItems.ItemName.Replace("'", "''"); string keyValue = slOrderedItems.GetKey(keyIndex).ToString(); valueSplitter = keyValue.Split('-'); if (objOrderedItems.DrinkStatus == true) //To make all drink items consecutively { slDrinkItems.Add(slDrinkItems.Count, objOrderedItems); } else if ((categoryID != Convert.ToInt32("0" + valueSplitter[0].ToString())) && (Convert.ToInt32("0" + valueSplitter[0].ToString()) != 0)) //All the items except drinks. { categoryID = Convert.ToInt32("0" + valueSplitter[0].ToString()); serialBody += "\r\n" + strPrintFormatter.CreateDashedLine() + "\r\n"; //Add the separator. /*serialBody += "\r\n" + objOrderedItems.Quantity.ToString() + " "; serialBody += CPrintMethods.GetFixedString(objOrderedItems.ItemName.ToString(), 29); serialBody += CPrintMethods.RightAlign(objOrderedItems.Price.ToString("F02"), 6);*/ //Blocked by Salim //serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + //objOrderedItems.ItemName.ToString(), objOrderedItems.Price.ToString("F02")); //if (qty_length_with_twospace + objOrderedItems.ItemName.Length + objOrderedItems.Price.ToString().Length <= printlinelength) //{ // serialBody += "\r\n" // + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + objOrderedItems.ItemName.ToString(), // " " + objOrderedItems.Price.ToString("F02")); //} //else //{ // // line 1 // int itemname_firstline_length = printlinelength - 4 - 1 - objOrderedItems.Price.ToString().Length; // string itemname_first_part = objOrderedItems.ItemName.Substring(0, itemname_firstline_length); // string itemname_second_part = objOrderedItems.ItemName.Substring(itemname_firstline_length); // serialBody += "\r\n" // + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + itemname_first_part, // " " + objOrderedItems.Price.ToString("F02")); // // line 2 // serialBody += "\r\n " // + strPrintFormatter.ItemLabeledText(itemname_second_part, // " "); //} serialBody += strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), paperSize - 10, objOrderedItems.Price.ToString("F02"), paperSize - 5), ""); } else if (valueSplitter[0].ToString() == "0") { slMiscellaneousItems.Add(slMiscellaneousItems.Count, objOrderedItems); } else { /* serialBody += "\r\n" + objOrderedItems.Quantity.ToString() + " "; serialBody += CPrintMethods.GetFixedString(objOrderedItems.ItemName.ToString(), 29); serialBody += CPrintMethods.RightAlign(objOrderedItems.Price.ToString("F02"), 6);*/ //Blocked by Salim //serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + //objOrderedItems.ItemName.ToString(), objOrderedItems.Price.ToString("F02")); //if (qty_length_with_twospace + objOrderedItems.ItemName.Length + objOrderedItems.Price.ToString().Length <= printlinelength) //{ // serialBody += "\r\n" // + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + objOrderedItems.ItemName.ToString(), // " " + objOrderedItems.Price.ToString("F02")); //} //else //{ // // line 1 // int itemname_firstline_length = printlinelength - 4 - 1 - objOrderedItems.Price.ToString().Length; // string itemname_first_part = objOrderedItems.ItemName.Substring(0, itemname_firstline_length); // string itemname_second_part = objOrderedItems.ItemName.Substring(itemname_firstline_length); // serialBody += "\r\n" // + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + itemname_first_part, // " " + objOrderedItems.Price.ToString("F02")); // // line 2 // serialBody += "\r\n " // + strPrintFormatter.ItemLabeledText(itemname_second_part, // " "); //} serialBody += strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), paperSize - 10, objOrderedItems.Price.ToString("F02"), paperSize - 5), ""); } keyIndex++; } //Add drinks only if (slMiscellaneousItems.Count > 0) { serialBody += "\r\n" + strPrintFormatter.CenterTextWithDashed("Miscellaneous") + "\r\n"; foreach (clsOrderReport objOrderedItems in slMiscellaneousItems.Values) { objOrderedItems.ItemName = objOrderedItems.ItemName.Replace("''", "'"); objOrderedItems.ItemName = objOrderedItems.ItemName.Replace("'", "''"); /* serialBody += "\r\n" + objOrderedItems.Quantity.ToString() + " "; serialBody += CPrintMethods.GetFixedString(objOrderedItems.ItemName.ToString(), 29); serialBody += CPrintMethods.RightAlign(objOrderedItems.Price.ToString("F02"), 6);*/ //serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + //objOrderedItems.ItemName.ToString(), objOrderedItems.Price.ToString("F02")); //if (qty_length_with_twospace + objOrderedItems.ItemName.Length + objOrderedItems.Price.ToString().Length <= printlinelength) //{ // serialBody += "\r\n" // + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + objOrderedItems.ItemName.ToString(), // " " + objOrderedItems.Price.ToString("F02")); //} //else //{ // // line 1 // int itemname_firstline_length = printlinelength - 4 - 1 - objOrderedItems.Price.ToString().Length; // string itemname_first_part = objOrderedItems.ItemName.Substring(0, itemname_firstline_length); // string itemname_second_part = objOrderedItems.ItemName.Substring(itemname_firstline_length); // serialBody += "\r\n" // + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + itemname_first_part, // " " + objOrderedItems.Price.ToString("F02")); // // line 2 // serialBody += "\r\n " // + strPrintFormatter.ItemLabeledText(itemname_second_part, // " "); //} serialBody += strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), paperSize - 10, objOrderedItems.Price.ToString("F02"), paperSize - 5), ""); } } //Add drinks only if (slDrinkItems.Count > 0) { serialBody += "\r\n" + strPrintFormatter.CenterTextWithDashed("Drinks") + "\r\n"; //Add the separator. foreach (clsOrderReport objOrderedItems in slDrinkItems.Values) { objOrderedItems.ItemName = objOrderedItems.ItemName.Replace("''", "'"); objOrderedItems.ItemName = objOrderedItems.ItemName.Replace("'", "''"); //serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " "+ //objOrderedItems.ItemName.ToString(),objOrderedItems.Price.ToString("F02")); //if (qty_length_with_twospace + objOrderedItems.ItemName.Length + objOrderedItems.Price.ToString().Length <= printlinelength) //{ // serialBody += "\r\n" // + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + objOrderedItems.ItemName.ToString(), // " " + objOrderedItems.Price.ToString("F02")); //} //else //{ // // line 1 // int itemname_firstline_length = printlinelength - 4 - 1 - objOrderedItems.Price.ToString().Length; // string itemname_first_part = objOrderedItems.ItemName.Substring(0, itemname_firstline_length); // string itemname_second_part = objOrderedItems.ItemName.Substring(itemname_firstline_length); // serialBody += "\r\n" // + strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + itemname_first_part, // " " + objOrderedItems.Price.ToString("F02")); // // line 2 // serialBody += "\r\n " // + strPrintFormatter.ItemLabeledText(itemname_second_part, // " "); //} serialBody += strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " + printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), paperSize - 10, objOrderedItems.Price.ToString("F02"), paperSize - 5), ""); } } serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); #endregion } } #endregion #region "Online orders" else { m_itemCost = 0.0; serialBody += "\r\n-----------------------------"; for (int rowIndex = 0; rowIndex < m_dtItemList.Rows.Count; rowIndex++) { DataRow tempRow = m_dtItemList.Rows[rowIndex]; serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(Convert.ToInt32("0" + tempRow["Qty"]).ToString() + " " + tempRow["Item"].ToString(), Convert.ToDouble("0" + tempRow["Price"]).ToString("F02")); m_itemCost += Convert.ToDouble("0" + tempRow["Price"].ToString()); //New for item cost of the bar service } serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); } #endregion Double discountAmount = Double.Parse(g_DiscountLabel.Text.Substring(Program.currency.Length)); Double searviceChargeAmount = Double.Parse(g_ServiceChargeLabel.Text.Substring(Program.currency.Length)); Double billTotal = ((searviceChargeAmount) + m_dTotalAmount); //serialBody += "\r\n Order Total: " + CPrintMethods.RightAlign(billTotal.ToString("F02"), 6); serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Order Amount: ", m_itemCost.ToString("F02")); //New at 03.03.2009 serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); if (discountAmount > 0) { Double totalAmount = m_dTotalAmount; Double discountPercent = 100 * discountAmount / (m_itemCost); serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Discount(" + discountPercent.ToString("F02") + "%): ", Convert.ToDouble(g_DiscountLabel.Text.Substring(Program.currency.Length)).ToString("F02")); } double itemiscount = 0; COrderManager temmpOrderManager = new COrderManager(); COrderDiscount tempOrderDiscount = new COrderDiscount(); CResult oResult = temmpOrderManager.OrderDiscountGetByOrderID(m_iOrderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDiscount = (COrderDiscount) oResult.Data; itemiscount = tempOrderDiscount.TotalItemDiscount; } if (itemiscount > 0) { //Discount is based on the total item cost //tempSerialPrintContent.StringLine = " Discount:(" + discountPercent.ToString("F02") + "%) " +Convert.ToDecimal(g_DiscountLabel.Text).ToString("F02"); serialBody += "\r\n" + strPrintFormatter.SumupLabeledText(" Item Discount: ", itemiscount.ToString("F02")); } serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Membership Discount: ", membershipdiscount.ToString("F02")); #region "Voucher" if (!g_VoucherLabel.Text.Substring(Program.currency.Length).Equals("0.00")) { serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Voucher Discount:", g_VoucherLabel.Text.Substring(Program.currency.Length)); } #endregion if ((m_serviceCharge_accounts + m_serviceCharge_cash + m_serviceCharge_cheque + m_serviceCharge_eft + m_serviceCharge_voucher) > 0) //If service charge is assigned { CResult cResult = tempOrderManager.OrderServiceChargeGetByOrderID(m_iOrderID); ServiceCharge serviceCharge = cResult.Data as ServiceCharge; double subtotalserviceCharg = m_serviceCharge_accounts + m_serviceCharge_cash + m_serviceCharge_cheque + m_serviceCharge_eft + m_serviceCharge_voucher-tipsamount; serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Service Charge(" + serviceCharge.ServicechargeRate.ToString("F02") + "%): ", (subtotalserviceCharg).ToString("F02"));// + CPrintMethods.RightAlign(Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)).ToString("F02"), 6); // Change by Mithu } serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Tips Amount: ", tipsamount.ToString("F02")); double pvat = (billTotal * (vat / 100)) / (1 + (vat / 100)); if (isVatEnabled) //If service charge is assigned { // serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Vat(" + vat + "%): ", pvat.ToString("F02")); serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Vat Total(15%): ", Convert.ToDouble("0" + lblVat.Text.Substring(Program.currency.Length)).ToString("F02")); // Change by Mithu } serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); double totalAmountForAddvance = 0; if ((m_serviceCharge_accounts + m_serviceCharge_cash + m_serviceCharge_cheque + m_serviceCharge_eft + m_serviceCharge_voucher) > 0) { totalAmountForAddvance = (m_dTotalAmount + (m_serviceCharge_accounts + m_serviceCharge_cash + m_serviceCharge_cheque + m_serviceCharge_eft + m_serviceCharge_voucher)); serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Total: ", (m_dTotalAmount + (m_serviceCharge_accounts + m_serviceCharge_cash + m_serviceCharge_cheque + m_serviceCharge_eft + m_serviceCharge_voucher)).ToString("F02")); } else { totalAmountForAddvance = m_dTotalAmount; serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Total:", m_dTotalAmount.ToString("F02")); } serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); serialBody += "\r\nPayment:"; if (!g_InputTextBox.Text.Substring(Program.currency.Length).Equals("0.00")) { if (complementorylabel.Text.Substring(Program.currency.Length).Equals("0.00")) { serialBody += "\r\nReceived :" + "0.00"; } else serialBody += "\r\nReceived :" + g_InputTextBox.Text.Substring(Program.currency.Length); } if (!g_CashLabel.Text.Substring(Program.currency.Length).Equals("0.00")) { serialBody += "\r\nCash:" + g_CashLabel.Text.Substring(Program.currency.Length); } if (!g_EFTLabel.Text.Substring(Program.currency.Length).Equals("0.00")) { serialBody += "\r\nCard - " + EFTOptionForm.seletedEFTCard.CardName + " :" + g_EFTLabel.Text.Substring(Program.currency.Length); } if (!g_ChequeLabel.Text.Substring(Program.currency.Length).Equals("0.00")) { serialBody += "\r\nDue:" + g_ChequeLabel.Text.Substring(Program.currency.Length); } if (!g_VoucherLabel.Text.Substring(Program.currency.Length).Equals("0.00")) { serialBody += "\r\nVoucher:" + g_VoucherLabel.Text.Substring(Program.currency.Length); } if (!g_AccountLabel.Text.Substring(Program.currency.Length).Equals("0.00")) { serialBody += "\r\nAccounts:" + g_AccountLabel.Text.Substring(Program.currency.Length); } if (!complementorylabel.Text.Substring(Program.currency.Length).Equals("0.00")) { serialBody += "\r\nComplementory:" + complementorylabel.Text.Substring(Program.currency.Length); } if (m_isAddServiceCharge == false) { if (Convert.ToDouble("0" + g_BalaceLabel.Text.Substring(9 + Program.currency.Length)) > 0) { serialBody += "\r\nPay Back: " + g_BalaceLabel.Text.Substring(9 + Program.currency.Length) + "\n"; } } if(addvancecAmountCheckBox.Checked) { serialBody += "\r\n" + strPrintFormatter.CenterTextWithDashed("Addvance Payment Information"); serialBody += "\r\nAddvance Amount:" +(Convert.ToDouble("0"+advanceAmountTextBox.Text.Trim())); serialBody += "\r\nPaid Amount:" + (totalAmountForAddvance-(Convert.ToDouble("0" + advanceAmountTextBox.Text.Trim()))); } serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); // serialBody += "\r\nS/N: " + tempOrderInfo.SerialNo.ToString(); if (Program.vatRegDes != "") { serialBody += "\r\nVat Reg. No: " + Program.vatRegDes; // Change by Mithu } // serialBody += "\r\n\r\nDeveloped By: www.ibacs.co.uk"; serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); if(complementoryMessage!=null && complementoryMessage.Length!=0) { serialBody += "\r\n" + strPrintFormatter.CenterTextWithDashed("Complementory Message"); serialBody += "\r\n" + GetMessageFitOnPaper(complementoryMessage); serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); } if (dueMessage!=null && dueMessage.Length != 0) { serialBody += "\r\n" + strPrintFormatter.CenterTextWithDashed("Due Message"); serialBody += "\r\n" + GetMessageFitOnPaper(dueMessage); serialBody += "\r\n" + strPrintFormatter.CreateDashedLine(); } this.WriteString(serialBody); gusetBillStr = serialBody; //tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString()); tempPrintMethods.USBPrint(serialBody, PrintDestiNation.CLIENT, true); } }
public CResult InsertOrderDiscount(COrderDiscount inOrderDiscount) { CResult oResult = new CResult(); try { this.OpenConnection(); string sSql = string.Format(SqlQueries.GetQuery(Query.OrderDiscountInsert), inOrderDiscount.OrderID, inOrderDiscount.Discount, inOrderDiscount.discountPercentRate, inOrderDiscount.membershipID, inOrderDiscount.membershipCardID, inOrderDiscount.clientID, inOrderDiscount.membershipPoint, inOrderDiscount.membershipTotalPoint, inOrderDiscount.membershipDiscountRate, inOrderDiscount.membershipDiscountAmount,inOrderDiscount.TotalItemDiscount); this.ExecuteNonQuery(sSql); oResult.IsSuccess = true; } catch (Exception ex) { Logger.Write("Exception : " + ex + " in InsertOrderDiscount()", LogLevel.Error, "Database"); // throw new Exception("Exception occure at InsertOrderSeatTime()", ex); oResult.IsException = true; } finally { this.CloseConnection(); } return oResult; }
private COrderDiscount ReaderToOrderDiscount(IDataReader inReader) { COrderDiscount tempOrderDiscount = new COrderDiscount(); if (inReader["order_id"] != null) tempOrderDiscount.OrderID = Int64.Parse(inReader["order_id"].ToString()); if (inReader["discount"] != null) tempOrderDiscount.Discount = Double.Parse(inReader["discount"].ToString()); if (inReader["discountPercentRate"] != null) tempOrderDiscount.discountPercentRate = float.Parse(inReader["discountPercentRate"].ToString()); if (inReader["membershipID"] != null) tempOrderDiscount.membershipID = long.Parse(inReader["membershipID"].ToString()); if (inReader["membershipCardID"] != null) tempOrderDiscount.membershipCardID = long.Parse(inReader["membershipCardID"].ToString()); if (inReader["clientID"] != null) tempOrderDiscount.clientID = long.Parse(inReader["clientID"].ToString()); if (inReader["membershipPoint"] != null) tempOrderDiscount.membershipPoint = float.Parse(inReader["membershipPoint"].ToString()); if (inReader["membershipTotalPoint"] != null) tempOrderDiscount.membershipTotalPoint = float.Parse(inReader["membershipTotalPoint"].ToString()); if (inReader["membershipDiscountRate"] != null) tempOrderDiscount.membershipDiscountRate = float.Parse(inReader["membershipDiscountRate"].ToString()); if (inReader["membershipDiscountAmount"] != null) tempOrderDiscount.membershipDiscountAmount = float.Parse(inReader["membershipDiscountAmount"].ToString()); if (inReader["TotalItemDiscount"] != null) tempOrderDiscount.TotalItemDiscount = float.Parse(inReader["TotalItemDiscount"].ToString()); return tempOrderDiscount; }
private void ShowItemsButton_Click(object sender, EventArgs e) { try { ItemDataGridView.Rows.Clear(); Int64 tempOrderID = Int64.Parse(OrderDataGridView.CurrentRow.Cells[4].Value.ToString()); COrderManager tempOrderManager = new COrderManager(); List<COrderDetails> tempOrderDetailsList = new List<COrderDetails>(); CResult oResult = tempOrderManager.OrderDetailsArchiveByOrderID(tempOrderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDetailsList = (List<COrderDetails>)oResult.Data; } for (int itemIndex = 0; itemIndex < tempOrderDetailsList.Count; itemIndex++) { Int64 tempProductID = tempOrderDetailsList[itemIndex].ProductID; int tempCategoryLevel = tempOrderDetailsList[itemIndex].CategoryLevel; string tempProductName = ""; if (tempCategoryLevel == 3) { DataRow[] tempDataRowArr = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempProductID); tempProductName = tempDataRowArr[0]["cat3_name"].ToString(); } else if (tempCategoryLevel == 4) { int tempCat3_id = int.Parse(Program.initDataSet.Tables["Category4"].Select("cat4_id = " + tempProductID)[0].GetParentRow(Program.initDataSet.Relations["category3_to_category4"])["cat3_id"].ToString()); tempProductName = Program.initDataSet.Tables["Category3"].Select("cat3_id = " + tempCat3_id)[0]["cat3_name"].ToString(); tempProductName += " " + Program.initDataSet.Tables["Category4"].Select("cat4_id = " + tempProductID)[0]["cat4_name"].ToString(); } else if (tempCategoryLevel == 0) tempProductName = tempOrderDetailsList[itemIndex].OrderRemarks; //if remarks exists append it... otherwise append nothing... string appendString = ""; if (tempCategoryLevel != 0) appendString = (tempOrderDetailsList[itemIndex].OrderRemarks.Equals("")) ? ("") : (" (" + tempOrderDetailsList[itemIndex].OrderRemarks + ")"); string[] tempDataGridViewRow = { tempProductName+appendString, tempOrderDetailsList[itemIndex].OrderQuantity.ToString(), ((double)tempOrderDetailsList[itemIndex].OrderAmount).ToString("F02"), tempOrderDetailsList[itemIndex].ProductID.ToString(), tempOrderDetailsList[itemIndex].CategoryLevel.ToString(), Int64.MaxValue.ToString(),//max rank tempOrderDetailsList[itemIndex].OrderDetailsID.ToString() }; //not misc item... rank is specified if (tempCategoryLevel != 0) tempDataGridViewRow[5] = Program.initDataSet.Tables["Category" + tempCategoryLevel].Select("cat" + tempCategoryLevel + "_id = " + tempProductID)[0]["cat" + tempCategoryLevel + "_rank"].ToString(); ItemDataGridView.Rows.Add(tempDataGridViewRow); ItemDataGridView.Sort(ItemDataGridView.Columns[5], ListSortDirection.Ascending); ItemDataGridView.Update(); } //get discount g_DiscountLabel.Text = "0.000"; COrderDiscount tempOrderDiscount = new COrderDiscount(); oResult = tempOrderManager.OrderDiscountGetByOrderID(tempOrderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDiscount = (COrderDiscount)oResult.Data; g_DiscountLabel.Text = tempOrderDiscount.Discount.ToString("F02"); } Double tempTotal = 0.0; for (int rowIndex = 0; rowIndex < ItemDataGridView.Rows.Count; rowIndex++) { if (ItemDataGridView[2, rowIndex].Value != null && !ItemDataGridView[2, rowIndex].Value.ToString().Equals("")) { tempTotal += Double.Parse(ItemDataGridView[2, rowIndex].Value.ToString()); } } tempTotal = tempTotal - tempOrderDiscount.Discount; g_AmountLabel.Text = tempTotal.ToString("F02"); FillRMSDataGridView(); } catch (FormatException exp) { MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (OverflowException exp) { MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (InvalidOperationException exp) { MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (ArgumentNullException exp) { MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exp) { MessageBox.Show(exp.Message,RMSGlobal.MessageBoxTitle,MessageBoxButtons.OK,MessageBoxIcon.Error); } }