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); } }