private Int32 SaveRecord() { ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(); ProductUnitsMatrixDetails clsDetails = new ProductUnitsMatrixDetails(); clsDetails.ProductID = Convert.ToInt64(lblProductID.Text); clsDetails.BaseUnitID = Convert.ToInt32(lblBaseUnitID.Text); clsDetails.BaseUnitValue = Convert.ToDecimal(txtBaseUnitValue.Text); clsDetails.BottomUnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value); clsDetails.BottomUnitValue = Convert.ToDecimal(txtBottomUnitValue.Text); int id = clsUnitMatrix.Insert(clsDetails); ProductPackageDetails clsProductPackageDetails = new ProductPackageDetails(); ProductPackage clsProductPackage = new ProductPackage(clsUnitMatrix.Connection, clsUnitMatrix.Transaction); clsProductPackageDetails = clsProductPackage.DetailsByProductIDAndUnitID(Convert.ToInt64(lblProductID.Text), Convert.ToInt32(cboBottomUnit.SelectedItem.Value)); if (clsProductPackageDetails.PackageID == 0) { Products clsProduct = new Products(clsUnitMatrix.Connection, clsUnitMatrix.Transaction); ProductDetails clsProductDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text)); Terminal clsTerminal = new Terminal(clsUnitMatrix.Connection, clsUnitMatrix.Transaction); TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString()); clsProductPackageDetails.ProductID = Convert.ToInt64(lblProductID.Text); clsProductPackageDetails.UnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value); clsProductPackageDetails.Price = clsProductDetails.Price * Convert.ToDecimal(txtBaseUnitValue.Text); clsProductPackageDetails.WSPrice = clsProductDetails.WSPrice * Convert.ToDecimal(txtBaseUnitValue.Text); clsProductPackageDetails.PurchasePrice = clsProductDetails.PurchasePrice * Convert.ToDecimal(txtBaseUnitValue.Text); clsProductPackageDetails.Quantity = 1; clsProductPackageDetails.VAT = clsTerminalDetails.VAT; clsProductPackageDetails.EVAT = clsTerminalDetails.EVAT; clsProductPackageDetails.LocalTax = clsTerminalDetails.LocalTax; if (!string.IsNullOrEmpty(clsProductDetails.BarCode1)) clsProductPackageDetails.BarCode1 = clsProductDetails.BarCode1 + clsProductPackageDetails.UnitID.ToString() + clsProductPackageDetails.Quantity.ToString(); if (!string.IsNullOrEmpty(clsProductDetails.BarCode2)) clsProductPackageDetails.BarCode2 = clsProductDetails.BarCode2 + clsProductPackageDetails.UnitID.ToString() + clsProductPackageDetails.Quantity.ToString(); if (!string.IsNullOrEmpty(clsProductDetails.BarCode3)) clsProductPackageDetails.BarCode3 = clsProductDetails.BarCode3 + clsProductPackageDetails.UnitID.ToString() + clsProductPackageDetails.Quantity.ToString(); clsProductPackage.Insert(clsProductPackageDetails); } clsUnitMatrix.CommitAndDispose(); return id; }
private bool SaveRecord() { long lngUID = long.Parse(Session["UID"].ToString()); DateTime dteChangeDate = DateTime.Now; ProductPackage clsProductPackage = new ProductPackage(); ProductPackageDetails clsDetails = new ProductPackageDetails(); clsDetails.PackageID = Convert.ToInt64(lblPackageID.Text); clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text); clsDetails.ProductID = Convert.ToInt64(lblProductID.Text); clsDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value); clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text); clsDetails.Price1 = Convert.ToDecimal(txtPrice1.Text); clsDetails.Price2 = Convert.ToDecimal(txtPrice2.Text); clsDetails.Price3 = Convert.ToDecimal(txtPrice3.Text); clsDetails.Price4 = Convert.ToDecimal(txtPrice4.Text); clsDetails.Price5 = Convert.ToDecimal(txtPrice5.Text); clsDetails.WSPrice = Convert.ToDecimal(txtWSPrice.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); clsDetails.BarCode1 = txtBarCode1.Text; clsDetails.BarCode2 = txtBarCode2.Text; clsDetails.BarCode3 = txtBarCode3.Text; clsProductPackage.Update(clsDetails, lngUID, dteChangeDate, "Product Package Update."); clsProductPackage.CommitAndDispose(); return true; }
private bool SaveRecord() { ProductPackageDetails clsDetails = new ProductPackageDetails(); clsDetails.ProductID = Convert.ToInt64(lblProductID.Text); clsDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value); clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text); clsDetails.Price1 = Convert.ToDecimal(txtPrice1.Text); clsDetails.Price2 = Convert.ToDecimal(txtPrice2.Text); clsDetails.Price3 = Convert.ToDecimal(txtPrice3.Text); clsDetails.Price4 = Convert.ToDecimal(txtPrice4.Text); clsDetails.Price5 = Convert.ToDecimal(txtPrice5.Text); clsDetails.WSPrice = Convert.ToDecimal(txtWSPrice.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); clsDetails.BarCode1 = txtBarCode1.Text; clsDetails.BarCode2 = txtBarCode2.Text; clsDetails.BarCode3 = txtBarCode3.Text; ProductPackage clsProductPackage = new ProductPackage(); clsProductPackage.Insert(clsDetails); clsProductPackage.CommitAndDispose(); return true; }
public Int32 Save(ProductPackageDetails Details) { try { string SQL = "CALL procSaveProductPackage(@PackageID, @ProductID, @MatrixID, @UnitID, " + "@Price, @Price1, @Price2, @Price3, @Price4, @Price5, @PurchasePrice," + "@Quantity, @VAT, @EVAT, @LocalTax, @WSPrice, @Barcode1, " + "@Barcode2, @Barcode3, @BarCode4, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("PackageID", Details.PackageID); cmd.Parameters.AddWithValue("ProductID", Details.ProductID); cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("UnitID", Details.UnitID); cmd.Parameters.AddWithValue("Price", Details.Price); cmd.Parameters.AddWithValue("Price1", Details.Price1); cmd.Parameters.AddWithValue("Price2", Details.Price2); cmd.Parameters.AddWithValue("Price3", Details.Price3); cmd.Parameters.AddWithValue("Price4", Details.Price4); cmd.Parameters.AddWithValue("Price5", Details.Price5); cmd.Parameters.AddWithValue("PurchasePrice", Details.PurchasePrice); cmd.Parameters.AddWithValue("Quantity", Details.Quantity); cmd.Parameters.AddWithValue("VAT", Details.VAT); cmd.Parameters.AddWithValue("EVAT", Details.EVAT); cmd.Parameters.AddWithValue("LocalTax", Details.LocalTax); cmd.Parameters.AddWithValue("WSPrice", Details.WSPrice); cmd.Parameters.AddWithValue("BarCode1", Details.BarCode1); cmd.Parameters.AddWithValue("BarCode2", Details.BarCode2); cmd.Parameters.AddWithValue("BarCode3", Details.BarCode3); cmd.Parameters.AddWithValue("BarCode4", Details.BarCode4); 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); return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
//private ProductPackageDetails setDetails(MySqlDataReader myReader) //{ // ProductPackageDetails clsDetails = new ProductPackageDetails(); ; // while (myReader.Read()) // { // clsDetails.PackageID = Convert.ToInt64(myReader[ProductPackageColumnNames.PackageID].ToString()); // clsDetails.ProductID = Convert.ToInt64(myReader[ProductPackageColumnNames.ProductID].ToString()); // clsDetails.UnitID = Convert.ToInt32(myReader[ProductPackageColumnNames.UnitID].ToString()); // clsDetails.UnitCode = "" + myReader[ProductPackageColumnNames.UnitCode].ToString(); // clsDetails.UnitName = "" + myReader[ProductPackageColumnNames.UnitName].ToString(); // clsDetails.Price = Convert.ToDecimal(myReader[ProductPackageColumnNames.Price].ToString()); // clsDetails.Price1 = Convert.ToDecimal(myReader[ProductPackageColumnNames.Price1].ToString()); // clsDetails.Price2 = Convert.ToDecimal(myReader[ProductPackageColumnNames.Price2].ToString()); // clsDetails.Price3 = Convert.ToDecimal(myReader[ProductPackageColumnNames.Price3].ToString()); // clsDetails.Price4 = Convert.ToDecimal(myReader[ProductPackageColumnNames.Price4].ToString()); // clsDetails.Price5 = Convert.ToDecimal(myReader[ProductPackageColumnNames.Price5].ToString()); // clsDetails.Quantity = Convert.ToDecimal(myReader[ProductPackageColumnNames.Quantity].ToString()); // clsDetails.VAT = Convert.ToDecimal(myReader[ProductPackageColumnNames.VAT].ToString()); // clsDetails.EVAT = Convert.ToDecimal(myReader[ProductPackageColumnNames.EVAT].ToString()); // clsDetails.LocalTax = Convert.ToDecimal(myReader[ProductPackageColumnNames.LocalTax].ToString()); // clsDetails.BarCode1 = "" + myReader[ProductPackageColumnNames.BarCode1].ToString(); // clsDetails.BarCode2 = "" + myReader[ProductPackageColumnNames.BarCode2].ToString(); // clsDetails.BarCode3 = "" + myReader[ProductPackageColumnNames.BarCode3].ToString(); // } // myReader.Close(); // return clsDetails; //} private ProductPackageDetails setDetails(System.Data.DataTable dt) { ProductPackageDetails clsDetails = new ProductPackageDetails(); ; foreach(System.Data.DataRow dr in dt.Rows) { clsDetails.PackageID = Convert.ToInt64(dr[ProductPackageColumnNames.PackageID].ToString()); clsDetails.ProductID = Convert.ToInt64(dr[ProductPackageColumnNames.ProductID].ToString()); clsDetails.MatrixID = Convert.ToInt64(dr[ProductPackageColumnNames.MatrixID].ToString()); clsDetails.UnitID = Convert.ToInt32(dr[ProductPackageColumnNames.UnitID].ToString()); clsDetails.UnitCode = "" + dr[ProductPackageColumnNames.UnitCode].ToString(); clsDetails.UnitName = "" + dr[ProductPackageColumnNames.UnitName].ToString(); clsDetails.PurchasePrice = Convert.ToDecimal(dr[ProductPackageColumnNames.PurchasePrice].ToString()); clsDetails.Price = Convert.ToDecimal(dr[ProductPackageColumnNames.Price].ToString()); clsDetails.Price1 = Convert.ToDecimal(dr[ProductPackageColumnNames.Price1].ToString()); clsDetails.Price2 = Convert.ToDecimal(dr[ProductPackageColumnNames.Price2].ToString()); clsDetails.Price3 = Convert.ToDecimal(dr[ProductPackageColumnNames.Price3].ToString()); clsDetails.Price4 = Convert.ToDecimal(dr[ProductPackageColumnNames.Price4].ToString()); clsDetails.Price5 = Convert.ToDecimal(dr[ProductPackageColumnNames.Price5].ToString()); clsDetails.WSPrice = Convert.ToDecimal(dr[ProductPackageColumnNames.WSPrice].ToString()); clsDetails.Quantity = Convert.ToDecimal(dr[ProductPackageColumnNames.Quantity].ToString()); clsDetails.VAT = Convert.ToDecimal(dr[ProductPackageColumnNames.VAT].ToString()); clsDetails.EVAT = Convert.ToDecimal(dr[ProductPackageColumnNames.EVAT].ToString()); clsDetails.LocalTax = Convert.ToDecimal(dr[ProductPackageColumnNames.LocalTax].ToString()); clsDetails.BarCode1 = "" + dr[ProductPackageColumnNames.BarCode1].ToString(); clsDetails.BarCode2 = "" + dr[ProductPackageColumnNames.BarCode2].ToString(); clsDetails.BarCode3 = "" + dr[ProductPackageColumnNames.BarCode3].ToString(); } return clsDetails; }
private void Save(ProductPackageDetails Details, long pvtUID, DateTime pvtChangeDate, string pvtHistoryRemarks) { try { string SQL = "CALL procProductPackageSave(@PackageID, @ProductID, @MatrixID, @UnitID, @PurchasePrice, " + "@Price, @Price1, @Price2, @Price3, @Price4, @Price5, " + "@WSPrice, @Quantity, @VAT, @EVAT, @LocalTax, @BarCode1, @BarCode2, @BarCode3);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@PackageID", Details.PackageID); cmd.Parameters.AddWithValue("@ProductID", Details.ProductID); cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("@UnitID", Details.UnitID); cmd.Parameters.AddWithValue("@PurchasePrice", Details.PurchasePrice); cmd.Parameters.AddWithValue("@Price", Details.Price); cmd.Parameters.AddWithValue("@Price1", Details.Price1); cmd.Parameters.AddWithValue("@Price2", Details.Price2); cmd.Parameters.AddWithValue("@Price3", Details.Price3); cmd.Parameters.AddWithValue("@Price4", Details.Price4); cmd.Parameters.AddWithValue("@Price5", Details.Price5); cmd.Parameters.AddWithValue("@WSPrice", Details.WSPrice); cmd.Parameters.AddWithValue("@Quantity", Details.Quantity); cmd.Parameters.AddWithValue("@VAT", Details.VAT); cmd.Parameters.AddWithValue("@EVAT", Details.EVAT); cmd.Parameters.AddWithValue("@LocalTax", Details.LocalTax); cmd.Parameters.AddWithValue("@BarCode1", Details.BarCode1); cmd.Parameters.AddWithValue("@BarCode2", Details.BarCode2); cmd.Parameters.AddWithValue("@BarCode3", Details.BarCode3); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void UpdateByProductIDUnitIDAndQuantity(ProductPackageDetails Details, long pvtUID, DateTime pvtChangeDate, string pvtHistoryRemarks) { try { string SQL = "SELECT PackageID FROM tblProductPackage " + "WHERE MatrixID = @MatrixID " + "AND ProductID = @ProductID " + "AND UnitID = @UnitID " + "AND Quantity = @Quantity;"; 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("@UnitID", Details.UnitID); cmd.Parameters.AddWithValue("@Quantity", Details.Quantity); System.Data.DataTable dt = new System.Data.DataTable("tblProductPackage"); base.MySqlDataAdapterFill(cmd, dt); foreach(System.Data.DataRow dr in dt.Rows) { Details.PackageID = Int64.Parse(dr["PackageID"].ToString()); } Update(Details, pvtUID, pvtChangeDate, pvtHistoryRemarks); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Insert(ProductPackageDetails Details) { try { Save(Details, 1, DateTime.Now, ""); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(ProductPackageDetails Details, long pvtUID, DateTime pvtChangeDate, string pvtHistoryRemarks) { try { // Update ProductPackagePriceHistory first to get the history ProductPackagePriceHistoryDetails clsProductPackagePriceHistoryDetails = new ProductPackagePriceHistoryDetails(); clsProductPackagePriceHistoryDetails.UID = pvtUID; clsProductPackagePriceHistoryDetails.PackageID = Details.PackageID; clsProductPackagePriceHistoryDetails.ChangeDate = pvtChangeDate; clsProductPackagePriceHistoryDetails.PurchasePrice = Details.PurchasePrice; clsProductPackagePriceHistoryDetails.Price = Details.Price; clsProductPackagePriceHistoryDetails.Price1 = Details.Price1; clsProductPackagePriceHistoryDetails.Price2 = Details.Price2; clsProductPackagePriceHistoryDetails.Price3 = Details.Price3; clsProductPackagePriceHistoryDetails.Price4 = Details.Price4; clsProductPackagePriceHistoryDetails.Price5 = Details.Price5; clsProductPackagePriceHistoryDetails.VAT = Details.VAT; clsProductPackagePriceHistoryDetails.EVAT = Details.EVAT; clsProductPackagePriceHistoryDetails.LocalTax = Details.LocalTax; clsProductPackagePriceHistoryDetails.Remarks = pvtHistoryRemarks; ProductPackagePriceHistory clsProductPackagePriceHistory = new ProductPackagePriceHistory(base.Connection, base.Transaction); clsProductPackagePriceHistory.Insert(clsProductPackagePriceHistoryDetails); Save(Details, pvtUID, pvtChangeDate, pvtHistoryRemarks); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void SaveRecord() { long lngUID = long.Parse(Session["UID"].ToString()); DateTime dteChangeDate = DateTime.Now; ProductPackage clsProductPackage = new ProductPackage(); clsProductPackage.GetConnection(); bool boIsFirstRecord = true; ProductPackageDetails clsProductPackageDetails; foreach (DataListItem e in lstProductPackages.Items) { if (boIsFirstRecord == true) { TextBox txtCommision = (TextBox)e.FindControl("txtCommision"); Products clsProduct = new Products(clsProductPackage.Connection, clsProductPackage.Transaction); clsProduct.UpdateCommision(long.Parse(cboProductCode.SelectedValue), Convert.ToDecimal(txtCommision.Text)); boIsFirstRecord = false; } HtmlInputCheckBox chkProductPackageID = (HtmlInputCheckBox)e.FindControl("chkProductPackageID"); TextBox txtBarCode1 = (TextBox)e.FindControl("txtBarCode1"); TextBox txtBarCode2 = (TextBox)e.FindControl("txtBarCode2"); TextBox txtBarCode3 = (TextBox)e.FindControl("txtBarCode3"); Label lblUnitName = (Label)e.FindControl("lblUnitName"); TextBox txtQuantity = (TextBox)e.FindControl("txtQuantity"); TextBox txtPurchasePrice = (TextBox)e.FindControl("txtPurchasePrice"); TextBox txtSellingPrice = (TextBox)e.FindControl("txtSellingPrice"); TextBox txtPrice1 = (TextBox)e.FindControl("txtPrice1"); TextBox txtPrice2 = (TextBox)e.FindControl("txtPrice2"); TextBox txtPrice3 = (TextBox)e.FindControl("txtPrice3"); TextBox txtPrice4 = (TextBox)e.FindControl("txtPrice4"); TextBox txtPrice5 = (TextBox)e.FindControl("txtPrice5"); TextBox txtWSPrice = (TextBox)e.FindControl("txtWSPrice"); Label lblVAT = (Label)e.FindControl("lblVAT"); Label lblEVAT = (Label)e.FindControl("lblEVAT"); Label lblLocalTax = (Label)e.FindControl("lblLocalTax"); clsProductPackageDetails = new ProductPackageDetails(); clsProductPackageDetails.PackageID = Convert.ToInt64(chkProductPackageID.Value); clsProductPackageDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedValue); clsProductPackageDetails.UnitID = Convert.ToInt32(lblUnitName.ToolTip); clsProductPackageDetails.Price = Convert.ToDecimal(txtSellingPrice.Text); clsProductPackageDetails.Price1 = Convert.ToDecimal(txtPrice1.Text); clsProductPackageDetails.Price2 = Convert.ToDecimal(txtPrice2.Text); clsProductPackageDetails.Price3 = Convert.ToDecimal(txtPrice3.Text); clsProductPackageDetails.Price4 = Convert.ToDecimal(txtPrice4.Text); clsProductPackageDetails.Price5 = Convert.ToDecimal(txtPrice5.Text); clsProductPackageDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text); clsProductPackageDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text); clsProductPackageDetails.Quantity = Convert.ToDecimal(txtQuantity.Text); clsProductPackageDetails.VAT = Convert.ToDecimal(lblVAT.Text); clsProductPackageDetails.EVAT = Convert.ToDecimal(lblEVAT.Text); clsProductPackageDetails.LocalTax = Convert.ToDecimal(lblLocalTax.Text); clsProductPackageDetails.BarCode1 = txtBarCode1.Text; clsProductPackageDetails.BarCode2 = txtBarCode2.Text; clsProductPackageDetails.BarCode3 = txtBarCode3.Text; clsProductPackage.Update(clsProductPackageDetails, lngUID, dteChangeDate, "Change price adjustment."); } clsProductPackage.CommitAndDispose(); }
/// <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 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 void Update(ProductDetails Details) { try { if (IsExist(Details.ProductID, Details.BarCode, Details.BarCode2, Details.BarCode3)) { throw new Exception("This product already exist, please check the barcode."); } MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "UPDATE tblProducts SET " + "ProductCode = @ProductCode, " + "ProductDesc = @ProductDesc, " + "ProductSubGroupID = @ProductSubGroupID, " + "BaseUnitID = @BaseUnitID, " + "PercentageCommision = @PercentageCommision, " + "IncludeInSubtotalDiscount = @IncludeInSubtotalDiscount, " + "MinThreshold = @MinThreshold, " + "MaxThreshold = @MaxThreshold, " + "SupplierID = @SupplierID, " + "IsItemSold = @IsItemSold, " + "WillPrintProductComposition = @WillPrintProductComposition, " + "RID = @RID, " + "SequenceNo = @SequenceNo " + "WHERE ProductID = @ProductID;"; cmd.Parameters.AddWithValue("ProductCode", Details.ProductCode); cmd.Parameters.AddWithValue("ProductDesc", Details.ProductDesc); cmd.Parameters.AddWithValue("ProductSubGroupID", Details.ProductSubGroupID); cmd.Parameters.AddWithValue("BaseUnitID", Details.BaseUnitID); cmd.Parameters.AddWithValue("PercentageCommision", Details.PercentageCommision); 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("IsItemSold", Details.IsItemSold); cmd.Parameters.AddWithValue("WillPrintProductComposition", Details.WillPrintProductComposition); cmd.Parameters.AddWithValue("RID", Details.RID); cmd.Parameters.AddWithValue("SequenceNo", Details.SequenceNo); cmd.Parameters.AddWithValue("ProductID", Details.ProductID); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); if (Details.Quantity > 0) { SQL = "UPDATE tblProducts SET Active = 1 WHERE ProductID = @ProductID AND Active = 0;"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("ProductID", Details.ProductID); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); } ProductPackageDetails clsDetails = new ProductPackageDetails(); clsDetails.ProductID = Details.ProductID; clsDetails.Quantity = 1; clsDetails.Price = Details.Price; 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.VAT = Details.VAT; clsDetails.EVAT = Details.EVAT; clsDetails.LocalTax = Details.LocalTax; clsDetails.UnitID = Details.BaseUnitID; clsDetails.UnitCode = Details.BaseUnitCode; clsDetails.UnitName = Details.BaseUnitName; clsDetails.BarCode1 = Details.BarCode; clsDetails.BarCode2 = Details.BarCode2; clsDetails.BarCode3 = Details.BarCode3; ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction); clsProductPackage.UpdateByProductIDUnitIDAndQuantity(clsDetails, Details.UpdatedBy, Details.UpdatedOn, "Edit product module."); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(ProductDetails Details) { try { if (IsExist(Details.ProductID, Details.BarCode, Details.BarCode2, Details.BarCode3)) { throw new EntryPointNotFoundException("This product already exist, please check the barcode."); } string SQL = "INSERT INTO tblProducts (" + "ProductCode, " + "ProductDesc, " + "ProductSubGroupID, " + "BaseUnitID, " + "DateCreated, " + "PercentageCommision, " + "IncludeInSubtotalDiscount, " + "MinThreshold, " + "MaxThreshold, " + "SupplierID, " + "IsItemSold, " + "WillPrintProductComposition"+ ") VALUES (" + "@ProductCode, " + "@ProductDesc, " + "@ProductSubGroupID, " + "@BaseUnitID, " + "@DateCreated," + "@PercentageCommision, " + "@IncludeInSubtotalDiscount, " + "@MinThreshold, " + "@MaxThreshold, " + "@SupplierID, " + "@IsItemSold, " + "@WillPrintProductComposition);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductCode = new MySqlParameter("@ProductCode",MySqlDbType.String); prmProductCode.Value = Details.ProductCode; cmd.Parameters.Add(prmProductCode); MySqlParameter prmProductDesc = new MySqlParameter("@ProductDesc",MySqlDbType.String); prmProductDesc.Value = Details.ProductDesc; cmd.Parameters.Add(prmProductDesc); MySqlParameter prmProductSubGroupID = new MySqlParameter("@ProductSubGroupID",MySqlDbType.Int64); prmProductSubGroupID.Value = Details.ProductSubGroupID; cmd.Parameters.Add(prmProductSubGroupID); MySqlParameter prmBaseUnitID = new MySqlParameter("@BaseUnitID",MySqlDbType.String); prmBaseUnitID.Value = Details.BaseUnitID; cmd.Parameters.Add(prmBaseUnitID); MySqlParameter prmDateCreated = new MySqlParameter("@DateCreated",MySqlDbType.DateTime); prmDateCreated.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmDateCreated); MySqlParameter prmPercentageCommision = new MySqlParameter("@PercentageCommision",MySqlDbType.Decimal); prmPercentageCommision.Value = Details.PercentageCommision; cmd.Parameters.Add(prmPercentageCommision); MySqlParameter prmIncludeInSubtotalDiscount = new MySqlParameter("@IncludeInSubtotalDiscount",MySqlDbType.Int16); prmIncludeInSubtotalDiscount.Value = Details.IncludeInSubtotalDiscount; cmd.Parameters.Add(prmIncludeInSubtotalDiscount); MySqlParameter prmMinThreshold = new MySqlParameter("@MinThreshold",MySqlDbType.Decimal); prmMinThreshold.Value = Details.MinThreshold; cmd.Parameters.Add(prmMinThreshold); MySqlParameter prmMaxThreshold = new MySqlParameter("@MaxThreshold",MySqlDbType.Decimal); prmMaxThreshold.Value = Details.MaxThreshold; cmd.Parameters.Add(prmMaxThreshold); MySqlParameter prmSupplierID = new MySqlParameter("@SupplierID",MySqlDbType.Int64); prmSupplierID.Value = Details.SupplierID; cmd.Parameters.Add(prmSupplierID); MySqlParameter prmIsItemSold = new MySqlParameter("@IsItemSold",MySqlDbType.Int16); prmIsItemSold.Value = Convert.ToInt16(Details.IsItemSold); cmd.Parameters.Add(prmIsItemSold); MySqlParameter prmWillPrintProductComposition = new MySqlParameter("@WillPrintProductComposition",MySqlDbType.Int16); prmWillPrintProductComposition.Value = Convert.ToInt16(Details.WillPrintProductComposition); cmd.Parameters.Add(prmWillPrintProductComposition); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); 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()); } ProductPackageDetails clsProductPackageDetails = new ProductPackageDetails(); clsProductPackageDetails.ProductID = iID; clsProductPackageDetails.BarCode1 = Details.BarCode; clsProductPackageDetails.BarCode2 = Details.BarCode2; clsProductPackageDetails.BarCode3 = Details.BarCode3; clsProductPackageDetails.UnitID = Details.BaseUnitID; clsProductPackageDetails.Price = Details.Price; clsProductPackageDetails.Price1 = Details.Price1; clsProductPackageDetails.Price2 = Details.Price2; clsProductPackageDetails.Price3 = Details.Price3; clsProductPackageDetails.Price4 = Details.Price4; clsProductPackageDetails.Price5 = Details.Price5; 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); // Oct 28, 2011 : Lemu // Added to cater branch inventory //BranchInventory clsBranchInventory = new BranchInventory(base.Connection, base.Transaction); //clsBranchInventory.CreateToAllBranches(iID); //base.ExecuteNonQuery(cmd); return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }