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