public Int32 Save(ProductBaseVariationsMatrixDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "CALL procSaveProductBaseVariationsMatrix(@MatrixID, @ProductID, @Description, @UnitID, " + "@IncludeInSubtotalDiscount, @MinThreshold, @MaxThreshold, @SupplierID, " + "@RIDMinThreshold, @RIDMaxThreshold, @Deleted, @CreatedOn, @LastModified);"; cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("ProductID", Details.ProductID); cmd.Parameters.AddWithValue("Description", Details.Description); cmd.Parameters.AddWithValue("UnitID", Details.UnitID); cmd.Parameters.AddWithValue("IncludeInSubtotalDiscount", Details.IncludeInSubtotalDiscount); cmd.Parameters.AddWithValue("MinThreshold", Details.MinThreshold); cmd.Parameters.AddWithValue("MaxThreshold", Details.MaxThreshold); cmd.Parameters.AddWithValue("SupplierID", Details.SupplierID); cmd.Parameters.AddWithValue("RIDMinThreshold", Details.RIDMinThreshold); cmd.Parameters.AddWithValue("RIDMaxThreshold", Details.RIDMaxThreshold); cmd.Parameters.AddWithValue("Deleted", Details.Deleted); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); cmd.CommandText = SQL; return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(ProductBaseVariationsMatrixDetails Details) { try { Save(Details); string SQL = "SELECT LAST_INSERT_ID();"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int64.Parse(dr[0].ToString()); } return(iID); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool UpdateVariationDesc(ProductBaseVariationsMatrixDetails Details) { try { string SQL = "UPDATE tblProductBaseVariationsMatrix SET " + "Description = @Description " + "WHERE ProductID = @ProductID AND MatrixID = @MatrixID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@ProductID", Details.ProductID); cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("@Description", Details.Description); base.ExecuteNonQuery(cmd); return(true); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool Update(ProductBaseVariationsMatrixDetails Details) { try { Save(Details); return(true); } catch (Exception ex) { throw base.ThrowException(ex); } }
public ProductBaseVariationsMatrixDetails BaseDetails(Int64 MatrixID, Int64 ProductID) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "SELECT " + "MatrixID, " + "ProductID, " + "description, " + "a.UnitID, " + "b.UnitName, " + "a.IncludeInSubtotalDiscount " + "FROM tblProductBaseVariationsMatrix a INNER JOIN " + "tblUnit b ON a.UnitID = b.UnitID " + "WHERE MatrixID = @MatrixID AND ProductID = @ProductID;"; cmd.Parameters.AddWithValue("@MatrixID", MatrixID); cmd.Parameters.AddWithValue("@ProductID", ProductID); cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); ProductBaseVariationsMatrixDetails Details = new ProductBaseVariationsMatrixDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.MatrixID = Int64.Parse(dr["MatrixID"].ToString()); Details.ProductID = Int64.Parse(dr["ProductID"].ToString()); Details.Description = dr["Description"].ToString(); Details.UnitID = Int32.Parse(dr["UnitID"].ToString()); Details.UnitName = dr["UnitName"].ToString(); Details.IncludeInSubtotalDiscount = bool.Parse(dr["IncludeInSubtotalDiscount"].ToString()); } return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public ProductBaseVariationsMatrixDetails BaseDetails(Int64 MatrixID, Int64 ProductID) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL= "SELECT " + "MatrixID, " + "ProductID, " + "description, " + "a.UnitID, " + "b.UnitName, " + "a.IncludeInSubtotalDiscount " + "FROM tblProductBaseVariationsMatrix a INNER JOIN " + "tblUnit b ON a.UnitID = b.UnitID " + "WHERE MatrixID = @MatrixID AND ProductID = @ProductID;"; cmd.Parameters.AddWithValue("@MatrixID", MatrixID); cmd.Parameters.AddWithValue("@ProductID", ProductID); cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); ProductBaseVariationsMatrixDetails Details = new ProductBaseVariationsMatrixDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.MatrixID = Int64.Parse(dr["MatrixID"].ToString()); Details.ProductID = Int64.Parse(dr["ProductID"].ToString()); Details.Description = dr["Description"].ToString(); Details.UnitID = Int32.Parse(dr["UnitID"].ToString()); Details.UnitName = dr["UnitName"].ToString(); Details.IncludeInSubtotalDiscount = bool.Parse(dr["IncludeInSubtotalDiscount"].ToString()); } return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(ProductBaseVariationsMatrixDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "CALL procSaveProductBaseVariationsMatrix(@MatrixID, @ProductID, @Description, @UnitID, " + "@IncludeInSubtotalDiscount, @MinThreshold, @MaxThreshold, @SupplierID, " + "@RIDMinThreshold, @RIDMaxThreshold, @Deleted, @CreatedOn, @LastModified);"; cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("ProductID", Details.ProductID); cmd.Parameters.AddWithValue("Description", Details.Description); cmd.Parameters.AddWithValue("UnitID", Details.UnitID); cmd.Parameters.AddWithValue("IncludeInSubtotalDiscount", Details.IncludeInSubtotalDiscount); cmd.Parameters.AddWithValue("MinThreshold", Details.MinThreshold); cmd.Parameters.AddWithValue("MaxThreshold", Details.MaxThreshold); cmd.Parameters.AddWithValue("SupplierID", Details.SupplierID); cmd.Parameters.AddWithValue("RIDMinThreshold", Details.RIDMinThreshold); cmd.Parameters.AddWithValue("RIDMaxThreshold", Details.RIDMaxThreshold); cmd.Parameters.AddWithValue("Deleted", Details.Deleted); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); cmd.CommandText = SQL; return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool UpdateVariationDesc(ProductBaseVariationsMatrixDetails Details) { try { string SQL = "UPDATE tblProductBaseVariationsMatrix SET " + "Description = @Description " + "WHERE ProductID = @ProductID AND MatrixID = @MatrixID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@ProductID", Details.ProductID); cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("@Description", Details.Description); base.ExecuteNonQuery(cmd); return true; } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool Update(ProductBaseVariationsMatrixDetails Details) { try { Save(Details); return true; } catch (Exception ex) { throw base.ThrowException(ex); } }
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; }
/// <summary> /// Aug 1, 2011 : Lemu /// Include clsProduct.AddQuantity /// </summary> /// <param name="Details"></param> /// <returns></returns> public Int64 InsertBaseVariation(ProductBaseVariationsMatrixDetails Details) { try { ProductBaseVariationsMatrix clsProductBaseVariationsMatrix = new ProductBaseVariationsMatrix(base.Connection, base.Transaction); clsProductBaseVariationsMatrix.Insert(Details); string SQL = "SELECT LAST_INSERT_ID();"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = Int64.Parse(dt.Rows[0][0].ToString()); // 23May2013 Add n the product package ProductPackageDetails clsProductPackageDetails = new ProductPackageDetails(); clsProductPackageDetails.ProductID = Details.ProductID; clsProductPackageDetails.MatrixID = iID; clsProductPackageDetails.BarCode1 = Details.BarCode1; clsProductPackageDetails.BarCode2 = Details.BarCode2; clsProductPackageDetails.BarCode3 = Details.BarCode3; clsProductPackageDetails.UnitID = Details.UnitID; clsProductPackageDetails.Price = Details.Price; clsProductPackageDetails.WSPrice = Details.WSPrice; clsProductPackageDetails.PurchasePrice = Details.PurchasePrice; clsProductPackageDetails.Quantity = 1; clsProductPackageDetails.VAT = Details.VAT; clsProductPackageDetails.EVAT = Details.EVAT; clsProductPackageDetails.LocalTax = Details.LocalTax; ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction); clsProductPackage.Insert(clsProductPackageDetails); /************************ * 23May2013 Remove handling of inventory here * Inventory should be added in the addquantity / subtractquantity * MatrixPackageDetails clsMatrixPackageDetails = new MatrixPackageDetails(); clsMatrixPackageDetails.MatrixID = iID; clsMatrixPackageDetails.UnitID = Details.UnitID; clsMatrixPackageDetails.Price = Details.Price; clsMatrixPackageDetails.WSPrice = Details.WSPrice; clsMatrixPackageDetails.PurchasePrice = Details.PurchasePrice; clsMatrixPackageDetails.Quantity = 1; clsMatrixPackageDetails.VAT = Details.VAT; clsMatrixPackageDetails.EVAT = Details.EVAT; clsMatrixPackageDetails.LocalTax = Details.LocalTax; MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction); clsMatrixPackage.Insert(clsMatrixPackageDetails); // Oct 28, 2011 : Lemu // Added to cater branch inventory SQL = "CALL procProductBranchInventoryInsert(@lngProductID);"; cmd.Parameters.Clear(); cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@lngProductID", Details.ProductID); base.ExecuteNonQuery(cmd); // Oct 28, 2011 : change to procSyncProductVariationFromQuantityPerItem(lngProductID, intBranchID); // ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction); // decimal Quantity = clsProductUnit.GetBaseUnitValue(Details.ProductID, Details.UnitID, Details.Quantity); // Product clsProduct = new Product(base.Connection, base.Transaction); // clsProduct.AddQuantity(Constants.BRANCH_ID_MAIN, Details.ProductID, iID, Details.Quantity, Product.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_PRODUCT_VARIATION_CREATION), DateTime.Now, "SYS-ADDVAR" + DateTime.Now.ToString("yyyyMMddHHmmss"), Details.CreatedBy); SQL = "CALL procSyncProductVariationFromQuantityPerItemAllBranch(@lngProductID);"; cmd.Parameters.Clear(); cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@lngProductID", Details.ProductID); base.ExecuteNonQuery(cmd); // Added August 2, 2009 to monitor if product still has/have variations Products clsProduct = new Products(base.Connection, base.Transaction); clsProduct.UpdateVariationCount(Details.ProductID); *************************/ return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
public void InheritSubGroupVariationsMatrix(Int64 ProductSubGroupID, Int64 ProductID, ProductDetails prodDetails) { try { ProductBaseVariationsMatrixDetails clsBaseDetails; ProductSubGroupVariationsMatrix clsProductSubGroupVariationsMatrix = new ProductSubGroupVariationsMatrix(base.Connection, base.Transaction); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction); ProductVariationsMatrixDetails clsProductVariationsMatrixDetails = new ProductVariationsMatrixDetails(); MySqlDataReader clsProductSubGroupVariationsMatrixList; MySqlDataReader clsProductSubGroupBaseVariationsMatrixList = clsProductSubGroupVariationsMatrix.BaseList(ProductSubGroupID,"MatrixID",SortOption.Ascending); Int64 SubGroupBaseMatrixID = 0; while (clsProductSubGroupBaseVariationsMatrixList.Read()) { clsBaseDetails = new ProductBaseVariationsMatrixDetails(); clsBaseDetails.ProductID = ProductID; clsBaseDetails.Description = "" + clsProductSubGroupBaseVariationsMatrixList["Description"].ToString(); clsBaseDetails.UnitID = Convert.ToInt32(clsProductSubGroupBaseVariationsMatrixList["UnitID"]); clsBaseDetails.Price = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["Price"]); clsBaseDetails.WSPrice = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["WSPrice"]); clsBaseDetails.PurchasePrice = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["PurchasePrice"]); clsBaseDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(clsProductSubGroupBaseVariationsMatrixList["IncludeInSubtotalDiscount"]); clsBaseDetails.VAT = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["VAT"]); clsBaseDetails.EVAT = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["EVAT"]); clsBaseDetails.LocalTax = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["LocalTax"]); clsBaseDetails.Quantity = 0; clsBaseDetails.MinThreshold = prodDetails.MinThreshold; clsBaseDetails.MaxThreshold = prodDetails.MaxThreshold; clsBaseDetails.MatrixID = clsProductVariationsMatrix.InsertBaseVariation(clsBaseDetails); SubGroupBaseMatrixID = clsProductSubGroupBaseVariationsMatrixList.GetInt64(0); clsProductSubGroupVariationsMatrix = new ProductSubGroupVariationsMatrix(base.Connection, base.Transaction); clsProductSubGroupVariationsMatrixList = clsProductSubGroupVariationsMatrix.List(SubGroupBaseMatrixID); while (clsProductSubGroupVariationsMatrixList.Read()) { clsProductVariationsMatrixDetails = new ProductVariationsMatrixDetails(); clsProductVariationsMatrixDetails.MatrixID = clsBaseDetails.MatrixID; clsProductVariationsMatrixDetails.ProductID = ProductID; clsProductVariationsMatrixDetails.VariationID = Convert.ToInt64(clsProductSubGroupVariationsMatrixList["VariationID"]); clsProductVariationsMatrixDetails.Description = "" + clsProductSubGroupVariationsMatrixList["Description"].ToString(); clsProductVariationsMatrix.SaveVariation(clsProductVariationsMatrixDetails); } clsProductSubGroupVariationsMatrixList.Close(); } clsProductSubGroupBaseVariationsMatrixList.Close(); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool UpdateBaseVariation(ProductBaseVariationsMatrixDetails Details) { try { ProductBaseVariationsMatrix clsProductBaseVariationsMatrix = new ProductBaseVariationsMatrix(base.Connection, base.Transaction); clsProductBaseVariationsMatrix.Update(Details); ProductPackageDetails clsDetails = new ProductPackageDetails(); clsDetails.ProductID = Details.ProductID; clsDetails.MatrixID = Details.MatrixID; clsDetails.UnitID = Details.UnitID; clsDetails.Price = Details.Price; // 02Mar2015 : Added Price1...Price5 clsDetails.Price1 = Details.Price1; clsDetails.Price2 = Details.Price2; clsDetails.Price3 = Details.Price3; clsDetails.Price4 = Details.Price4; clsDetails.Price5 = Details.Price5; clsDetails.WSPrice = Details.WSPrice; clsDetails.PurchasePrice = Details.PurchasePrice; clsDetails.Quantity = 1; clsDetails.VAT = Details.VAT; clsDetails.EVAT = Details.EVAT; clsDetails.LocalTax = Details.LocalTax; // 27May2014: Added barcode details clsDetails.BarCode1 = Details.BarCode1; clsDetails.BarCode2 = Details.BarCode2; clsDetails.BarCode3 = Details.BarCode3; ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction); clsProductPackage.Update(clsDetails, 0, DateTime.Now, "Update base variation"); return true; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 InsertBaseVariationEasy(long pvtProductID, string pvtDescription, string UserName) { try { ProductDetails clsProductDetails = new Products(base.Connection, base.Transaction).Details(pvtProductID); ProductBaseVariationsMatrixDetails clsBaseDetails = new ProductBaseVariationsMatrixDetails(); clsBaseDetails.ProductID = pvtProductID; clsBaseDetails.BarCode1 = ""; clsBaseDetails.BarCode2 = ""; clsBaseDetails.BarCode3 = ""; clsBaseDetails.Description = pvtDescription; clsBaseDetails.UnitID = clsProductDetails.BaseUnitID; clsBaseDetails.Price = clsProductDetails.Price; clsBaseDetails.WSPrice = clsProductDetails.WSPrice; clsBaseDetails.PurchasePrice = clsProductDetails.PurchasePrice; clsBaseDetails.IncludeInSubtotalDiscount = clsProductDetails.IncludeInSubtotalDiscount; clsBaseDetails.Quantity = 1; clsBaseDetails.VAT = clsProductDetails.VAT; clsBaseDetails.EVAT = clsProductDetails.EVAT; clsBaseDetails.LocalTax = clsProductDetails.LocalTax; clsBaseDetails.MinThreshold = clsProductDetails.MinThreshold; clsBaseDetails.MaxThreshold = clsProductDetails.MaxThreshold; clsBaseDetails.CreatedBy = UserName; return InsertBaseVariation(clsBaseDetails); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(ProductBaseVariationsMatrixDetails Details) { try { Save(Details); string SQL = "SELECT LAST_INSERT_ID();"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int64.Parse(dr[0].ToString()); } return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
//public void UpdatePurchasing(long MatrixID, long SupplierID, int UnitID, decimal PurchasePrice) //{ // try // { // string SQL = "UPDATE tblProductBaseVariationsMatrix SET " + // "PurchasePrice = @PurchasePrice, " + // "SupplierID = @SupplierID " + // "WHERE MatrixID = @MatrixID;"; // MySqlCommand cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // cmd.CommandText = SQL; // cmd.Parameters.AddWithValue("@PurchasePrice", PurchasePrice); // cmd.Parameters.AddWithValue("@SupplierID", SupplierID); // cmd.Parameters.AddWithValue("@MatrixID", MatrixID); // //cmd.Parameters.AddWithValue("@ProductID", ProductID); // base.ExecuteNonQuery(cmd); // MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction); // clsMatrixPackage.UpdatePurchasing(MatrixID, UnitID, 1, PurchasePrice); // } // catch (Exception ex) // { // throw base.ThrowException(ex); // } //} //public void UpdateByPackage(Int64 MatrixID, Int32 UnitID, decimal Price, decimal WSPrice, decimal PurchasePrice, decimal VAT, decimal EVAT, decimal LocalTax) //{ // try // { // string SQL = "UPDATE tblProductBaseVariationsMatrix SET " + // "Price = @Price, " + // "WSPrice = @WSPrice, " + // "PurchasePrice = @PurchasePrice, " + // "VAT = @VAT, " + // "EVAT = @EVAT, " + // "LocalTax = @LocalTax " + // "WHERE MatrixID = @MatrixID " + // "AND UnitID = @UnitID "; // MySqlCommand cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // cmd.CommandText = SQL; // MySqlParameter prmPrice = new MySqlParameter("@Price",MySqlDbType.Decimal); // prmPrice.Value = Price; // cmd.Parameters.Add(prmPrice); // cmd.Parameters.AddWithValue("@WSPrice", WSPrice); // MySqlParameter prmPurchasePrice = new MySqlParameter("@PurchasePrice",MySqlDbType.Decimal); // prmPurchasePrice.Value = PurchasePrice; // cmd.Parameters.Add(prmPurchasePrice); // MySqlParameter prmVAT = new MySqlParameter("@VAT",MySqlDbType.Decimal); // prmVAT.Value = VAT; // cmd.Parameters.Add(prmVAT); // MySqlParameter prmEVAT = new MySqlParameter("@EVAT",MySqlDbType.Decimal); // prmEVAT.Value = EVAT; // cmd.Parameters.Add(prmEVAT); // MySqlParameter prmLocalTax = new MySqlParameter("@LocalTax",MySqlDbType.Decimal); // prmLocalTax.Value = LocalTax; // cmd.Parameters.Add(prmLocalTax); // MySqlParameter prmMatrixID = new MySqlParameter("@MatrixID",MySqlDbType.Int64); // prmMatrixID.Value = MatrixID; // cmd.Parameters.Add(prmMatrixID); // MySqlParameter prmUnitID = new MySqlParameter("@UnitID",MySqlDbType.Int32); // prmUnitID.Value = UnitID; // cmd.Parameters.Add(prmUnitID); // base.ExecuteNonQuery(cmd); // } // catch (Exception ex) // { // throw base.ThrowException(ex); // } //} #endregion #region tblProductBaseVariationsMatrix Details private ProductBaseVariationsMatrixDetails getBaseDetails(System.Data.DataTable dt) { ProductBaseVariationsMatrixDetails Details = new ProductBaseVariationsMatrixDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.MatrixID = Int64.Parse(dr["MatrixID"].ToString()); Details.ProductID = Int64.Parse(dr["ProductID"].ToString()); Details.Description = "" + dr["MatrixDescription"].ToString(); Details.UnitID = Int32.Parse(dr["UnitID"].ToString()); Details.UnitCode = "" + dr["UnitCode"].ToString(); Details.UnitName = "" + dr["UnitName"].ToString(); Details.Price = decimal.Parse(dr["Price"].ToString()); Details.WSPrice = decimal.Parse(dr["WSPrice"].ToString()); Details.PurchasePrice = decimal.Parse(dr["PurchasePrice"].ToString()); Details.IncludeInSubtotalDiscount = Boolean.Parse(dr["IncludeInSubtotalDiscount"].ToString()); Details.VAT = decimal.Parse(dr["VAT"].ToString()); Details.EVAT = decimal.Parse(dr["EVAT"].ToString()); Details.LocalTax = decimal.Parse(dr["LocalTax"].ToString()); Details.Quantity = decimal.Parse(dr["Quantity"].ToString()); Details.ActualQuantity = decimal.Parse(dr["ActualQuantity"].ToString()); Details.MinThreshold = decimal.Parse(dr["MinThreshold"].ToString()); Details.MaxThreshold = decimal.Parse(dr["MaxThreshold"].ToString()); Details.RIDMinThreshold = decimal.Parse(dr["RIDMinThreshold"].ToString()); Details.RIDMaxThreshold = decimal.Parse(dr["RIDMaxThreshold"].ToString()); } return Details; }
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(); }
private void LoadList() { string SortField = "prd.Description"; 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); } 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)); } ProductBaseVariationsMatrixDetails clsSearchKeys = new ProductBaseVariationsMatrixDetails(); clsSearchKeys.Description = stSearchKey; ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); System.Data.DataTable dt = clsProductVariationsMatrix.BaseListAsDataTable(Int64.Parse(lblProductID.Text), Int32.Parse(Session["BranchID"].ToString()), MatrixDescription: stSearchKey, SortField: SortField, SortOrder: sortoption); 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; }