public void GeneratePLUReport(Int32 BranchID, string TerminalNo, bool isPerGroup, string CashierName) { try { System.Data.DataTable dtPLUReport = this.PLUReport(BranchID, TerminalNo, CashierName, isPerGroup); Data.PLUReport clsPLUReport = new Data.PLUReport(base.Connection, base.Transaction); clsPLUReport.Delete(BranchID, TerminalNo); PLUReportDetails clsPLUReportDetails; ProductComposition clsProductComposition = new ProductComposition(base.Connection, base.Transaction); foreach(System.Data.DataRow dr in dtPLUReport.Rows) { long lProductID = Convert.ToInt64(dr["ProductID"]); string stProductCode = dr["ProductCode"].ToString(); string stProductGroup = dr["ProductGroup"].ToString(); decimal decQuantity = Convert.ToDecimal(dr["Quantity"]); decimal decAmount = Convert.ToDecimal(dr["Amount"]); bool boOrderSlipPrinter1 = bool.Parse(dr["OrderSlipPrinter1"].ToString()); bool boOrderSlipPrinter2 = bool.Parse(dr["OrderSlipPrinter2"].ToString()); bool boOrderSlipPrinter3 = bool.Parse(dr["OrderSlipPrinter3"].ToString()); bool boOrderSlipPrinter4 = bool.Parse(dr["OrderSlipPrinter4"].ToString()); bool boOrderSlipPrinter5 = bool.Parse(dr["OrderSlipPrinter5"].ToString()); // 07Apr2015 : Add this so that those products without OrderSlipPrinter will be defaulted to OrderSlipPrinter1 if (!boOrderSlipPrinter1 && !boOrderSlipPrinter2 && !boOrderSlipPrinter3 && !boOrderSlipPrinter4 && !boOrderSlipPrinter5) boOrderSlipPrinter1 = true; clsPLUReportDetails = new PLUReportDetails(); clsPLUReportDetails.BranchDetails = new BranchDetails { BranchID = BranchID }; clsPLUReportDetails.TerminalNo = TerminalNo; clsPLUReportDetails.ProductID = lProductID; clsPLUReportDetails.ProductCode = stProductCode; clsPLUReportDetails.ProductGroup = stProductGroup; clsPLUReportDetails.Quantity = decQuantity; clsPLUReportDetails.Amount = decAmount; if (boOrderSlipPrinter1) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter1; clsPLUReport.Insert(clsPLUReportDetails); } if (boOrderSlipPrinter2) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter2; clsPLUReport.Insert(clsPLUReportDetails); } if (boOrderSlipPrinter3) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter3; clsPLUReport.Insert(clsPLUReportDetails); } if (boOrderSlipPrinter4) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter4; clsPLUReport.Insert(clsPLUReportDetails); } if (boOrderSlipPrinter5) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter5; clsPLUReport.Insert(clsPLUReportDetails); } // generate if per item if (!isPerGroup) clsProductComposition.GeneratePLUReport(BranchID, TerminalNo, lProductID, stProductCode, decQuantity); } } catch (Exception ex) { throw base.ThrowException(ex); } }
private void LoadItems() { DataClass clsDataClass = new DataClass(); ProductComposition clsProductComposition = new ProductComposition(); lstItem.DataSource = clsProductComposition.ListAsDataTable(Convert.ToInt64(lblProductID.Text), "CompositionID",SortOption.Ascending).DefaultView; lstItem.DataBind(); clsProductComposition.CommitAndDispose(); }
private bool DeleteItems() { bool boRetValue = false; string stIDs = ""; foreach(DataListItem item in lstItem.Items) { HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList"); if (chkList!=null) { if (chkList.Checked == true) { stIDs += chkList.Value + ","; boRetValue = true; } } } if (boRetValue) { ProductComposition clsProductComposition = new ProductComposition(); clsProductComposition.Delete( stIDs.Substring(0,stIDs.Length-1)); clsProductComposition.CommitAndDispose(); } return boRetValue; }
private void UpdateItem() { if (isChkListSingle() == true) { string stID = GetFirstID(); if (stID!=null) { ProductComposition clsProductComposition = new ProductComposition(); ProductCompositionDetails clsDetails = clsProductComposition.Details(Convert.ToInt64(stID)); clsProductComposition.CommitAndDispose(); cboProductCode.Items.Clear(); cboVariation.Items.Clear(); cboProductUnit.Items.Clear(); cboProductCode.Items.Add(new ListItem(clsDetails.ProductCode, clsDetails.ProductID.ToString())); cboProductCode.SelectedIndex = 0; if (clsDetails.VariationMatrixID == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0")); } else { cboVariation.Items.Add(new ListItem(clsDetails.MatrixDescription, clsDetails.VariationMatrixID.ToString())); } cboVariation.SelectedIndex = 0; cboProductUnit.Items.Add(new ListItem(clsDetails.UnitCode, clsDetails.UnitID.ToString())); cboProductUnit.SelectedIndex = 0; txtQuantity.Text = clsDetails.Quantity.ToString("###0.#0"); lblCompositionID.Text = stID; } } else { string stScript = "<Script>"; stScript += "window.alert('Cannot update more than one record. Please select at least one record to update.')"; stScript += "</Script>"; Response.Write(stScript); } }
private void SaveRecord() { ProductCompositionDetails clsDetails = new ProductCompositionDetails(); clsDetails.MainProductID = Convert.ToInt64(lblProductID.Text); clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value); clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text); clsDetails.UnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value); ProductComposition clsProductComposition = new ProductComposition(); if (lblCompositionID.Text != "0") { clsDetails.CompositionID = Convert.ToInt64(lblCompositionID.Text); clsProductComposition.Update(clsDetails); } else clsProductComposition.Insert(clsDetails); clsProductComposition.CommitAndDispose(); }