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