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