protected void lnkBtnSaveDS_Click(object sender, EventArgs e) { PurchasedProduct objPurchasedProduct = new PurchasedProduct(); objPurchasedProduct.ProductID = Convert.ToInt32(htnProductID.Value); objPurchasedProduct.ProductName = lblProduct.Text; objPurchasedProduct.BarCode = lblBarCode.Text; objPurchasedProduct.BuyingPrice = Convert.ToDecimal(txtBuyingPrice.Text); objPurchasedProduct.Margin = Convert.ToDecimal(txtMargin.Text); objPurchasedProduct.Tax = Convert.ToDecimal(txtTax.Text); objPurchasedProduct.SellingPrice = Convert.ToDecimal(txtSellingPrice.Text); objPurchasedProduct.SizeQty = ""; ProductSize objProductSize; List<Size> lstSizeIDs = (List<Size>)Session["ProductSizeIDs"]; List<ProductSize> lstProductSizes = new List<ProductSize>(); int intTotalQty = 0; decimal dblTotalAmount = Convert.ToDecimal(lblTotalAmount.Text); for (int i = 0; i < lstSizeIDs.Count; i++) { if (!String.IsNullOrEmpty(Request.Form["txtSize_" + lstSizeIDs[i].SizeID.ToString()])) { objProductSize = new ProductSize(); objProductSize.ProductID = objPurchasedProduct.ProductID; objProductSize.SizeID = lstSizeIDs[i].SizeID; objProductSize.Quantity = Convert.ToInt32(Request.Form["txtSize_" + lstSizeIDs[i].SizeID.ToString()].ToString()); lstProductSizes.Add(objProductSize); intTotalQty += objProductSize.Quantity; if (i > 0) objPurchasedProduct.SizeQty += "<br/>"; objPurchasedProduct.SizeQty += lstSizeIDs[i].SizeName + ": " + objProductSize.Quantity; } } if (intTotalQty > 0) { objPurchasedProduct.PurchasedQty = lstProductSizes; if (Session["PurchasedProduct"] != null) gobjProduct = (List<PurchasedProduct>)Session["PurchasedProduct"]; gobjProduct.Add(objPurchasedProduct); Session["PurchasedProduct"] = gobjProduct; // lblMsg.Text = PopulateGrid(); lblTotalQuantity.Text = Convert.ToString(intTotalQty + Convert.ToInt32(lblTotalQuantity.Text)); lblTotalAmount.Text = Math.Round((dblTotalAmount + (intTotalQty * objPurchasedProduct.BuyingPrice)), 2).ToString(); ScriptManager.RegisterStartupScript(this, this.GetType(), "PopulateType", "Populate('2')", true); } else { System.Web.UI.HtmlControls.HtmlGenericControl containerDiv; System.Web.UI.HtmlControls.HtmlGenericControl textBoxDiv; for (int i = 0; i < lstSizeIDs.Count; i++) { for (int j = 0; j < lstProductSizes.Count; j++) { if (lstSizeIDs[i].SizeID == lstProductSizes[j].SizeID) { containerDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("div"); containerDiv.Controls.Add(CreateLabel(lstProductSizes[j].SizeID, lstSizeIDs[i].SizeName)); plhQty.Controls.Add(containerDiv); textBoxDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("div"); textBoxDiv.Controls.Add(CreateTextBox(lstProductSizes[j].SizeID, 0)); plhQty.Controls.Add(textBoxDiv); break; } } } Span3.InnerHtml = "Total Quantity cannot be zero"; ScriptManager.RegisterStartupScript(this, this.GetType(), "AddEditPurchase", "ShowModalDiv('ModalWindow1','dvInnerWindow',0);", true); } }
public void GetPurchaseByID(ref PurchaseRecord vobjPurchaseRecord) { try { object[] mParams = { new SqlParameter("@PurchaseID", SqlDbType.Int) }; mParams[0] = vobjPurchaseRecord.PurchaseID; PurchasedProduct objPurchasedProduct; ProductSize objProductSize = new ProductSize(); List<PurchasedProduct> lstPurchasedProduct = new List<PurchasedProduct>(); List<ProductSize> lstProductSize = new List<ProductSize>(); int intTotalQty = 0; decimal dcmTotalBuyingPrice = 0; using (IDataReader reader = dBase.ExecuteReader("sprocCS_GetProductPurchaseByID", mParams)) { while (reader.Read()) { objPurchasedProduct = new PurchasedProduct(); if (reader["ManufacturerID"] != DBNull.Value) vobjPurchaseRecord.ManufacturerID = Convert.ToInt32(reader["ManufacturerID"]); if (reader["PurchaseDate"] != DBNull.Value) vobjPurchaseRecord.PurchaseDate = Convert.ToDateTime(reader["PurchaseDate"]).ToString("dd/MM/yyyy"); if (reader["ProductID"] != DBNull.Value) objPurchasedProduct.ProductID = Convert.ToInt32(reader["ProductID"]); if (reader["ProductName"] != DBNull.Value) objPurchasedProduct.ProductName = Convert.ToString(reader["ProductName"]); if (reader["BuyingPrice"] != DBNull.Value) objPurchasedProduct.BuyingPrice = Convert.ToDecimal(reader["BuyingPrice"]); if (reader["Tax"] != DBNull.Value) objPurchasedProduct.Tax = Convert.ToDecimal(reader["Tax"]); if (reader["Margin"] != DBNull.Value) objPurchasedProduct.Margin = Convert.ToDecimal(reader["Margin"]); if (reader["SellingPrice"] != DBNull.Value) objPurchasedProduct.SellingPrice = Convert.ToDecimal(reader["SellingPrice"]); if (reader["BarCode"] != DBNull.Value) objPurchasedProduct.BarCode = Convert.ToString(reader["BarCode"]); string[] sizes = Convert.ToString(reader["Sizes"]).Split(','); lstProductSize = new List<ProductSize>(); intTotalQty = 0; for (int i = 0; i < sizes.Length; i++) { objProductSize = new ProductSize(); string[] sizeqty = sizes[i].Split('~'); objProductSize.SizeID = Convert.ToInt32(sizeqty[0]); objProductSize.Quantity = Convert.ToInt32(sizeqty[2]); objProductSize.ProductID = objPurchasedProduct.ProductID; lstProductSize.Add(objProductSize); if (i > 0) objPurchasedProduct.SizeQty += "<br/>"; objPurchasedProduct.SizeQty += sizeqty[1] + ": " + objProductSize.Quantity; intTotalQty += objProductSize.Quantity; } objPurchasedProduct.PurchasedQty = lstProductSize; vobjPurchaseRecord.TotalQty += intTotalQty; vobjPurchaseRecord.TotalBuyingPrice += objPurchasedProduct.BuyingPrice * intTotalQty; lstPurchasedProduct.Add(objPurchasedProduct); } vobjPurchaseRecord.ProductsPurchased = lstPurchasedProduct; } } catch (Exception ex) { Common.LogError("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString()); } }