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