private void SelectItem() { ListView.SelectedListViewItemCollection items = this.lstItems.SelectedItems; foreach (ListViewItem item in items) { mItemDetails.MatrixPackageID = Convert.ToInt64(item.SubItems[0].Name); break; } MatrixPackage clsMatrixPackage = new MatrixPackage(); MatrixPackageDetails clsDetails = clsMatrixPackage.Details(mItemDetails.MatrixPackageID); clsMatrixPackage.CommitAndDispose(); if (mItemDetails.MatrixPackageID != 0) { mItemDetails.ProductUnitID = clsDetails.UnitID; mItemDetails.ProductUnitCode = clsDetails.UnitCode; mItemDetails.Price = clsDetails.Price; mItemDetails.PackageQuantity = clsDetails.Quantity; mItemDetails.VAT = clsDetails.VAT; mItemDetails.LocalTax = clsDetails.LocalTax; mItemDetails.Amount = (mItemDetails.Quantity * mItemDetails.Price) - (mItemDetails.Quantity * mItemDetails.Discount); mItemDetails.PurchasePrice = clsDetails.PurchasePrice; mItemDetails.Amount = mItemDetails.Quantity * mItemDetails.PurchasePrice; } dialog = DialogResult.OK; this.Hide(); }
private bool Delete() { 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) { MatrixPackage clsMatrixPackage = new MatrixPackage(); clsMatrixPackage.Delete(stIDs.Substring(0, stIDs.Length - 1)); clsMatrixPackage.CommitAndDispose(); } return(boRetValue); }
private void LoadRecord() { MatrixPackage clsMatrixPackage = new MatrixPackage(); MatrixPackageDetails clsDetails = clsMatrixPackage.Details(Convert.ToInt64(lblPackageID.Text)); clsMatrixPackage.CommitAndDispose(); cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsDetails.UnitID.ToString())); txtProductPrice.Text = clsDetails.Price.ToString("#,##0.#0"); txtPurchasePrice.Text = clsDetails.PurchasePrice.ToString("#,##0.#0"); decimal decMargin = clsDetails.Price - clsDetails.PurchasePrice; try { decMargin = decMargin / clsDetails.PurchasePrice; } catch { decMargin = 1; } decMargin = decMargin * 100; txtMargin.Text = decMargin.ToString("#,##0.##0"); txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0"); txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0"); txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0"); txtQuantity.Text = clsDetails.Quantity.ToString("#,##0.#0"); if (clsDetails.Quantity == 1) { txtQuantity.Enabled = false; } }
private bool SaveRecord() { MatrixPackageDetails clsDetails = new MatrixPackageDetails(); clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text); clsDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value); clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text); clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text); clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text); clsDetails.VAT = Convert.ToDecimal(txtVAT.Text); clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text); clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text); MatrixPackage clsMatrixPackage = new MatrixPackage(); clsMatrixPackage.Insert(clsDetails); clsMatrixPackage.CommitAndDispose(); return(true); }
private void LoadItemData() { MatrixPackage clsMatrixPackage = new MatrixPackage(); try { DataClass clsData = new DataClass(); System.Data.DataTable dt = clsData.DataReaderToDataTable(clsMatrixPackage.List(mItemDetails.VariationsMatrixID, "a.PackageID", SortOption.Ascending)); clsMatrixPackage.CommitAndDispose(); dt.TableName = "tblMatrixPackage"; dgItems.DataSource = dt; dgItems.Select(0); dgItems.CurrentRowIndex = 0; } catch (Exception ex) { clsMatrixPackage.CommitAndDispose(); MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private bool SaveRecord() { long lngUID = long.Parse(Session["UID"].ToString()); DateTime dteChangeDate = DateTime.Now; MatrixPackage clsMatrixPackage = new MatrixPackage(); MatrixPackageDetails clsDetails = new MatrixPackageDetails(); clsDetails.PackageID = Convert.ToInt64(lblPackageID.Text); clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text); clsDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value); clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text); clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text); clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text); clsDetails.VAT = Convert.ToDecimal(txtVAT.Text); clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text); clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text); clsMatrixPackage.Update(clsDetails, lngUID, dteChangeDate, "Matrix Package update."); clsMatrixPackage.CommitAndDispose(); return(true); }
private void LoadItemData() { try { DataClass clsData = new DataClass(); MatrixPackage clsMatrixPackage = new MatrixPackage(); System.Data.DataTable dt = clsData.DataReaderToDataTable(clsMatrixPackage.List(mItemDetails.VariationsMatrixID, "a.PackageID", SortOption.Ascending)); clsMatrixPackage.CommitAndDispose(); lstItems.Items.Clear(); int iImgCtr = 0; foreach (System.Data.DataRow dr in dt.Rows) { if (mboIsPriceInq) { lstItems.Items.Add(dr["PackageID"].ToString(), "[" + dr["Price"].ToString() + "]" + Environment.NewLine + dr["Quantity"].ToString() + " " + dr["UnitCode"].ToString() + " - " + dr["Description"].ToString(), iImgCtr); } else { lstItems.Items.Add(dr["PackageID"].ToString(), dr["Quantity"].ToString() + " " + dr["UnitCode"].ToString() + " - " + dr["Description"].ToString(), iImgCtr); } if (iImgCtr == 7) { iImgCtr = 0; } else { iImgCtr++; } } try { lstItems.Items[0].Selected = true; } catch { } } catch (Exception ex) { MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadList() { MatrixPackage clsMatrixPackage = new MatrixPackage(); DataClass clsDataClass = new DataClass(); string SortField = "PackageID"; if (Request.QueryString["sortfield"] != null) { SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); } SortOption sortoption = SortOption.Ascending; if (Request.QueryString["sortoption"] != null) { sortoption = (SortOption)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); } if (Request.QueryString["Search"] == null) { PageData.DataSource = clsMatrixPackage.ListAsDataTable(Convert.ToInt64(lblMatrixID.Text), SortField, sortoption).DefaultView; } else { PageData.DataSource = clsDataClass.DataReaderToDataTable(clsMatrixPackage.List(Convert.ToInt64(lblMatrixID.Text), SortField, sortoption)).DefaultView; } clsMatrixPackage.CommitAndDispose(); int iPageSize = Convert.ToInt16(Session["PageSize"]); PageData.AllowPaging = true; PageData.PageSize = iPageSize; try { PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1; lstItem.DataSource = PageData; lstItem.DataBind(); } catch { PageData.CurrentPageIndex = 1; lstItem.DataSource = PageData; lstItem.DataBind(); } cboCurrentPage.Items.Clear(); for (int i = 0; i < PageData.PageCount; i++) { int iValue = i + 1; cboCurrentPage.Items.Add(new ListItem(iValue.ToString(), iValue.ToString())); if (PageData.CurrentPageIndex == i) { cboCurrentPage.Items[i].Selected = true; } else { cboCurrentPage.Items[i].Selected = false; } } lblDataCount.Text = " of " + " " + PageData.PageCount; }