private void LoadList() { string stSearchKey = string.Empty; if (Request.QueryString["Search"] != null) { stSearchKey = Server.UrlDecode(Common.Decrypt((string)Request.QueryString["search"], Session.SessionID)); } else if (Session["Search"] != null) { stSearchKey = Server.UrlDecode(Common.Decrypt(Session["Search"].ToString(), Session.SessionID)); } try { Session.Remove("Search"); } catch { } if (stSearchKey == null) { stSearchKey = string.Empty; } else if (stSearchKey != string.Empty) { Session.Add("Search", Common.Encrypt(stSearchKey, Session.SessionID)); } ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); System.Data.DataTable dt = clsProductVariationsMatrix.BaseListAsDataTable(Int64.Parse(lblProductID.Text), MatrixDescription: stSearchKey); clsProductVariationsMatrix.CommitAndDispose(); PageData.DataSource = dt.DefaultView; 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; }
private void lstItem_ItemDataBound(object sender, DataListItemEventArgs e) { if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView dr = (DataRowView) e.Item.DataItem; HtmlInputCheckBox chkList = (HtmlInputCheckBox) e.Item.FindControl("chkList"); chkList.Value = dr["VariationID"].ToString(); Label lblVariationType = (Label) e.Item.FindControl("lblVariationType"); lblVariationType.Text = dr["VariationType"].ToString(); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); TextBox txtDescription = (TextBox) e.Item.FindControl("txtDescription"); txtDescription.Text = clsProductVariationsMatrix.Details(Convert.ToInt32(lblMatrixID.Text), Convert.ToInt32(chkList.Value)).Description; clsProductVariationsMatrix.CommitAndDispose(); } }
private void LoadItemData() { try { DataClass clsData = new DataClass(); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); System.Data.DataTable dt = clsData.DataReaderToDataTable(clsProductVariationsMatrix.Search(mDetails.ProductID, "", "a.Description", SortOption.Ascending, 100, mboShowItemMoreThanZeroQty)); clsProductVariationsMatrix.CommitAndDispose(); lstItems.Items.Clear(); int iImgCtr = 0; foreach (System.Data.DataRow dr in dt.Rows) { if (mboIsPriceInq) lstItems.Items.Add(dr["MatriXID"].ToString(), "[" + dr["Price"].ToString() + "]" + Environment.NewLine + dr["Quantity"].ToString() + " " + dr["UnitCode"].ToString() + " - " + dr["Description"].ToString(), iImgCtr); else lstItems.Items.Add(dr["MatriXID"].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) { if (ex.Message.ToLower() != "index was outside the bounds of the array.") MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error); } }
private void SelectItem() { ListView.SelectedListViewItemCollection items = this.lstItems.SelectedItems; foreach (ListViewItem item in items) { mDetails.VariationsMatrixID = Convert.ToInt64(item.SubItems[0].Name); break; } ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); ProductBaseVariationsMatrixDetails clsDetails = new ProductBaseVariationsMatrixDetails(); // clsProductVariationsMatrix.BaseDetailsByMatrixID(mDetails.VariationsMatrixID); clsProductVariationsMatrix.CommitAndDispose(); if (mDetails.VariationsMatrixID != 0) { mDetails.MatrixDescription = clsDetails.Description; mDetails.ProductUnitID = clsDetails.UnitID; mDetails.ProductUnitCode = clsDetails.UnitCode; mDetails.Price = clsDetails.Price; mDetails.VAT = clsDetails.VAT; mDetails.LocalTax = clsDetails.LocalTax; mDetails.Amount = (mDetails.Quantity * mDetails.Price) - (mDetails.Quantity * mDetails.Discount); mDetails.PurchasePrice = clsDetails.PurchasePrice; mDetails.PurchaseAmount = mDetails.Quantity * mDetails.PurchasePrice; mDetails.IncludeInSubtotalDiscount = clsDetails.IncludeInSubtotalDiscount; } dialog = DialogResult.OK; this.Hide(); }
protected void cboProducts_SelectedIndexChanged(object sender, System.EventArgs e) { long ProductID = Convert.ToInt64(cboProducts.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboProductVariation.DataTextField = "VariationDesc"; cboProductVariation.DataValueField = "MatrixID"; cboProductVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboProductVariation.DataBind(); cboProductVariation.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); cboProductVariation.SelectedIndex = 0; clsProductVariationsMatrix.CommitAndDispose(); }
protected void imgVariationQuickAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e) { try { long.Parse(cboProductCode.SelectedItem.Value); if (txtVariation.Text != null || txtVariation.Text.Trim() != string.Empty || txtVariation.Text.Trim() != "") { Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"]; ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); clsProductVariationsMatrix.InsertBaseVariationEasy(long.Parse(cboProductCode.SelectedItem.Value), txtVariation.Text, clsAccessUserDetails.Name); clsProductVariationsMatrix.CommitAndDispose(); cmdVariationSearch_Click(null, null); } } catch { } }
protected void cmdVariationSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e) { string stSearchKey = txtVariation.Text.ToString(); if (txtVariation.Text == null) stSearchKey = ""; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "Description"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsDataClass.DataReaderToDataTable(clsProductVariationsMatrix.Search(ProductID, stSearchKey, "VariationDesc",SortOption.Ascending)).DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0")); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; clsProductVariationsMatrix.CommitAndDispose(); }
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e) { if (cboProductCode.Items.Count == 0) return; if (cboProductCode.Items.Count == 1 && cboProductCode.SelectedValue == Constants.ZERO_STRING) return; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "MatrixDescription"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0")); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); cboProductUnit.DataTextField = "BottomUnitCode"; cboProductUnit.DataValueField = "BottomUnitID"; cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID,"a.MatrixID",SortOption.Ascending).DefaultView; cboProductUnit.DataBind(); Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); ProductDetails clsDetails = clsProduct.Details(ProductID, MatrixID: Int64.Parse(cboVariation.SelectedItem.Value)); clsProductVariationsMatrix.CommitAndDispose(); cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); txtPrevPrice.Text = clsDetails.PurchasePrice.ToString("#####0.#0"); txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.#0"); if (clsDetails.VAT >0) chkIsTaxable.Checked = true; else chkIsTaxable.Checked = false; ComputeItemAmount(); cboVariation_SelectedIndexChanged(null, null); }
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e) { if (cboProductCode.Items.Count == 0) return; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "MatrixDescription"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0"));} cboVariation.SelectedIndex = cboVariation.Items.Count - 1; ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); cboProductUnit.DataTextField = "BottomUnitCode"; cboProductUnit.DataValueField = "BottomUnitID"; cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView; cboProductUnit.DataBind(); Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); ProductDetails clsDetails = clsProduct.Details(ProductID); clsProductVariationsMatrix.CommitAndDispose(); cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); txtPrice.Text = clsDetails.WSPrice.ToString("#####0.#0"); txtSellingPrice.Text = clsDetails.Price.ToString("#####0.#0"); decimal decMargin = clsDetails.Price - clsDetails.WSPrice; try { decMargin = decMargin / clsDetails.WSPrice; } 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"); if (clsDetails.VAT > 0) chkIsTaxable.Checked = true; else chkIsTaxable.Checked = false; ComputeItemAmount(); cboVariation_SelectedIndexChanged(null, null); //if (ProductID != 0) //{ // lnkVariationAdd.Visible = true; // string stParam = "?task=" + Common.Encrypt("add", Session.SessionID) + // "&prodid=" + Common.Encrypt(ProductID.ToString(), Session.SessionID); // lnkVariationAdd.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx" + stParam; //} //else { lnkVariationAdd.Visible = false; } }
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) { // Aug 1, 2011 : Lemu // Remove the entire code and replaced with the code below to cater InventoryAdjustment and ProductMovement // See _Product/_variationsMatrix/_List.cs.Delete // // ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); // clsProductVariationsMatrix.Delete(stIDs.Substring(0,stIDs.Length-1)); // clsProductVariationsMatrix.SynchronizeQuantity(Convert.ToInt64(lblProductID.Text)); // clsProductVariationsMatrix.CommitAndDispose(); Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"]; ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); clsProductVariationsMatrix.GetConnection(); Products clsProducts = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); long ProductID = Int64.Parse(lblProductID.Text); string[] strIDs = stIDs.Substring(0, stIDs.Length - 1).Split(','); foreach (string ID in strIDs) { long MatrixID = long.Parse(ID); ProductDetails clsDetails = clsProducts.Details(ProductID: ProductID, MatrixID: MatrixID); InvAdjustmentDetails clsInvAdjustmentDetails = new InvAdjustmentDetails(); clsInvAdjustmentDetails.UID = clsAccessUserDetails.UID; clsInvAdjustmentDetails.InvAdjustmentDate = DateTime.Now; clsInvAdjustmentDetails.ProductID = clsDetails.ProductID; clsInvAdjustmentDetails.ProductCode = clsDetails.ProductCode; clsInvAdjustmentDetails.Description = clsDetails.ProductDesc; clsInvAdjustmentDetails.VariationMatrixID = clsDetails.MatrixID; clsInvAdjustmentDetails.MatrixDescription = clsDetails.MatrixDescription; clsInvAdjustmentDetails.UnitID = clsDetails.BaseUnitID; clsInvAdjustmentDetails.UnitCode = clsDetails.BaseUnitCode; clsInvAdjustmentDetails.QuantityBefore = clsDetails.Quantity; clsInvAdjustmentDetails.QuantityNow = 0; clsInvAdjustmentDetails.MinThresholdBefore = clsDetails.MinThreshold; clsInvAdjustmentDetails.MinThresholdNow = 0; clsInvAdjustmentDetails.MaxThresholdBefore = clsDetails.MaxThreshold; clsInvAdjustmentDetails.MaxThresholdNow = 0; clsInvAdjustmentDetails.Remarks = "deleted item."; InvAdjustment clsInvAdjustment = new InvAdjustment(clsProducts.Connection, clsProducts.Transaction); clsInvAdjustment.Insert(clsInvAdjustmentDetails); clsProducts.SubtractQuantity(Constants.BRANCH_ID_MAIN, clsDetails.ProductID, clsDetails.MatrixID, clsDetails.Quantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_PRODUCT_VARIATION_DELETE) + " : " + clsDetails.MatrixDescription, clsInvAdjustmentDetails.InvAdjustmentDate, "SYS-VARDEL" + clsInvAdjustmentDetails.InvAdjustmentDate.ToString("yyyyMMddHHmmss"), clsAccessUserDetails.Name); clsProductVariationsMatrix.Delete(long.Parse(ID)); } clsProductVariationsMatrix.CommitAndDispose(); } return boRetValue; }
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e) { if (cboProductCode.Items.Count == 0) return; if (cboProductCode.Items.Count == 1 && cboProductCode.SelectedValue == Constants.ZERO_STRING) return; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "MatrixDescription"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", Constants.ZERO_STRING)); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); cboProductUnit.DataTextField = "BottomUnitCode"; cboProductUnit.DataValueField = "BottomUnitID"; cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView; cboProductUnit.DataBind(); Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); ProductDetails clsDetails = clsProduct.Details(ProductID); ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); System.Data.DataTable dtProductPurchasePriceHistory = clsProductPurchasePriceHistory.ListAsDataTable(ProductID, DateTime.Now.AddMonths(-6), "PurchasePrice", SortOption.Ascending); clsProductVariationsMatrix.CommitAndDispose(); string strPurchasePriceHistory = string.Empty; foreach (System.Data.DataRow dr in dtProductPurchasePriceHistory.Rows) { DateTime dtePurchaseDate = DateTime.Parse(dr["PurchaseDate"].ToString()); decimal decPurchasePrice = decimal.Parse(dr["PurchasePrice"].ToString()); long lngSupplierID = long.Parse(dr["SupplierID"].ToString()); string strSupplierName = "" + dr["SupplierName"].ToString(); if (lngSupplierID == long.Parse(lblSupplierID.Text)) clsDetails.PurchasePrice = decPurchasePrice; strPurchasePriceHistory += dtePurchaseDate.ToString("ddMMMyyyy HH:mm") + ": " + decPurchasePrice.ToString("#,##0.##0").PadLeft(10) + " " + strSupplierName + "\r\n<br />" + Environment.NewLine; } lblPurchasePriceHistory.Text = "<br />" + strPurchasePriceHistory; cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.##0"); txtSellingPrice.Text = clsDetails.Price.ToString("#####0.##0"); txtOldSellingPrice.Text = clsDetails.Price.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"); if (clsDetails.VAT > 0) chkIsTaxable.Checked = true; else chkIsTaxable.Checked = false; if (cboProductUnit.Items.Count == 0) { cboProductUnit.Items.Add(new ListItem("No Unit", "0")); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; ComputeItemAmount(); cboVariation_SelectedIndexChanged(null, null); lstItemFixCssClass(); }
protected void imgVariationQuickAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e) { try { if (!string.IsNullOrEmpty(txtVariation.Text)) { DateTime dteExpiration = Constants.C_DATE_MIN_VALUE; string LotNo = ""; if (Session[Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE].ToString() == Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE_EXPIRATION_LOTNO) { string javaScript = ""; string[] variation = txtVariation.Text.Split(';'); if (!DateTime.TryParse(variation[0], out dteExpiration)) { javaScript = "window.alert('Please enter a valid expiration date in YYYY-MM-DD format. Variation format must be: EXPIRATION;LOTNO');"; System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updPrint, this.updPrint.GetType(), "openwindow", javaScript, true); return; } if (variation.Length == 1) { javaScript = "window.alert('Please enter a valid LOTNO, it must not be blank. If there is no LOTNO please enter NA.');"; System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updPrint, this.updPrint.GetType(), "openwindow", javaScript, true); return; } LotNo = variation[1]; if (string.IsNullOrEmpty(LotNo)) { javaScript = "window.alert('Please enter a valid LOTNO, it must not be blank. If there is no LOTNO please enter NA.');"; System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updPrint, this.updPrint.GetType(), "openwindow", javaScript, true); return; } } long lngProdductID = long.Parse(cboProductCode.SelectedItem.Value); Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"]; ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); long lngMatrixID = clsProductVariationsMatrix.InsertBaseVariationEasy(long.Parse(cboProductCode.SelectedItem.Value), txtVariation.Text, clsAccessUserDetails.Name); if (Session[Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE].ToString() == Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE_EXPIRATION_LOTNO) { ProductVariationsMatrixDetails clsDetails; clsDetails = new ProductVariationsMatrixDetails(); clsDetails.MatrixID = lngMatrixID; clsDetails.ProductID = lngProdductID; // save the expiration clsDetails.VariationID = long.Parse(CONSTANT_VARIATIONS.EXPIRATION.ToString("d")); clsDetails.Description = dteExpiration.ToString("yyyy-MM-dd"); clsProductVariationsMatrix.SaveVariation(clsDetails); // save the lotno clsDetails.VariationID = long.Parse(CONSTANT_VARIATIONS.LOTNO.ToString("d")); clsDetails.Description = LotNo; clsProductVariationsMatrix.SaveVariation(clsDetails); } clsProductVariationsMatrix.CommitAndDispose(); cmdVariationSearch_Click(null, null); } } catch{} }
private bool SaveRecord() { foreach (DataListItem item in lstItem.Items) { HyperLink lnkVariationType = (HyperLink)item.FindControl("lnkVariationType"); if (lnkVariationType.Text.ToUpper() == CONSTANT_VARIATIONS.EXPIRATION.ToString("G")) { TextBox txtDescription = (TextBox)item.FindControl("txtDescription"); try { DateTime Expiry = DateTime.Parse(txtDescription.Text); } catch { string javaScript = "window.alert('Please enter a valid expiration date in YYYY-MM-DD format.');"; System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true); return false; } } } string stringVariationDesc = null; foreach (DataListItem item in lstItem.Items) { HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList"); TextBox txtDescription = (TextBox)item.FindControl("txtDescription"); stringVariationDesc += txtDescription.Text + "; "; } Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"]; ProductBaseVariationsMatrixDetails clsBaseDetails = new ProductBaseVariationsMatrixDetails(); ProductVariationsMatrixDetails clsDetails; ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); ProductDetails clsProductDetails = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction).Details(Int64.Parse(lblProductID.Text)); clsBaseDetails.ProductID = Convert.ToInt64(lblProductID.Text); clsBaseDetails.BarCode1 = txtBarcode.Text; clsBaseDetails.BarCode2 = txtBarcode2.Text; clsBaseDetails.BarCode3 = txtBarcode3.Text; clsBaseDetails.Description = stringVariationDesc; clsBaseDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value); clsBaseDetails.Price = Convert.ToDecimal(txtProductPrice.Text); clsBaseDetails.Price1 = Convert.ToDecimal(txtPrice1.Text); clsBaseDetails.Price2 = Convert.ToDecimal(txtPrice2.Text); clsBaseDetails.Price3 = Convert.ToDecimal(txtPrice3.Text); clsBaseDetails.Price4 = Convert.ToDecimal(txtPrice4.Text); clsBaseDetails.Price5 = Convert.ToDecimal(txtPrice5.Text); clsBaseDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text); clsBaseDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text); clsBaseDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text); clsBaseDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked; clsBaseDetails.Quantity = Convert.ToDecimal(txtQuantity.Text); clsBaseDetails.VAT = Convert.ToDecimal(txtVAT.Text); clsBaseDetails.EVAT = Convert.ToDecimal(txtEVAT.Text); clsBaseDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text); clsBaseDetails.MinThreshold = Convert.ToDecimal(txtMinThreshold.Text); clsBaseDetails.MaxThreshold = Convert.ToDecimal(txtMaxThreshold.Text); clsBaseDetails.SupplierID = clsProductDetails.SupplierID; clsBaseDetails.CreatedBy = clsAccessUserDetails.Name; clsBaseDetails.MatrixID = clsProductVariationsMatrix.InsertBaseVariation(clsBaseDetails); foreach (DataListItem item in lstItem.Items) { HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList"); TextBox txtDescription = (TextBox) item.FindControl("txtDescription"); clsDetails = new ProductVariationsMatrixDetails(); clsDetails.MatrixID = clsBaseDetails.MatrixID; clsDetails.ProductID = Convert.ToInt64(lblProductID.Text); clsDetails.VariationID = Convert.ToInt32(chkList.Value); clsDetails.Description = txtDescription.Text; clsProductVariationsMatrix.SaveVariation(clsDetails); } clsProductVariationsMatrix.CommitAndDispose(); return true; }
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e) { if (cboProductCode.Items.Count == 0) return; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); if (ProductID == 0) { cboVariation.Items.Clear(); cboVariation.Items.Add(new ListItem("No Variation", "0")); return; } ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "VariationDesc"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0")); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; clsProductVariationsMatrix.CommitAndDispose(); ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(); cboProductUnit.DataTextField = "BottomUnitCode"; cboProductUnit.DataValueField = "BottomUnitID"; cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID,"a.MatrixID",SortOption.Ascending).DefaultView; cboProductUnit.DataBind(); clsUnitMatrix.CommitAndDispose(); Products clsProduct = new Products(); ProductDetails clsDetails = new ProductDetails(); clsDetails = clsProduct.Details(ProductID); clsProduct.CommitAndDispose(); cboProductUnit.Items.Add( new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); cboProductUnit.SelectedIndex = cboProductUnit.Items.Count - 1; cboVariation_SelectedIndexChanged(null, null); }
private void LoadItemData() { ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); try { string searchkey = "" + txtSearch.Text; DataClass clsData = new DataClass(); System.Data.DataTable dt = clsData.DataReaderToDataTable(clsProductVariationsMatrix.Search(mDetails.ProductID,searchkey,"a.Description",SortOption.Ascending, 100, mboShowItemMoreThanZeroQty)); clsProductVariationsMatrix.CommitAndDispose(); //dt.TableName = "tblProductVariationsMatrix"; this.dgStyle.MappingName = dt.TableName; dgItems.DataSource = dt; dgItems.Select(0); dgItems.CurrentRowIndex=0; } catch (Exception ex) { clsProductVariationsMatrix.CommitAndDispose(); if (ex.Message.ToLower() != "index was outside the bounds of the array.") MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error); } }
protected void lstItem_ItemDataBound(object sender, DataListItemEventArgs e) { if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView dr = (DataRowView) e.Item.DataItem; HtmlInputCheckBox chkList = (HtmlInputCheckBox) e.Item.FindControl("chkList"); chkList.Value = dr["VariationID"].ToString(); HyperLink lnkVariationType = (HyperLink)e.Item.FindControl("lnkVariationType"); lnkVariationType.Text = dr["VariationType"].ToString(); //VariationID lnkVariationType.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Variation/Default.aspx?task=" + Common.Encrypt("details", Session.SessionID) + "&id=" + Common.Encrypt(dr["VariationID"].ToString(), Session.SessionID); TextBox txtDescription = (TextBox)e.Item.FindControl("txtDescription"); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); txtDescription.Text = clsProductVariationsMatrix.Details(Convert.ToInt64(lblMatrixID.Text), Convert.ToInt32(chkList.Value)).Description; clsProductVariationsMatrix.CommitAndDispose(); } }