protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
{
return;
}
if (cboProductCode.Items.Count == 1 && cboProductCode.SelectedValue == Constants.ZERO_STRING)
{
return;
}
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{
cboVariation.Items.Add(new ListItem("No Variation", Constants.ZERO_STRING));
}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
ProductDetails clsDetails = clsProduct.Details(ProductID);
ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
System.Data.DataTable dtProductPurchasePriceHistory = clsProductPurchasePriceHistory.ListAsDataTable(ProductID, DateTime.Now.AddMonths(-6), "PurchasePrice", SortOption.Ascending);
clsProductVariationsMatrix.CommitAndDispose();
cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
txtPurchasePrice.Text = clsDetails.PurchasePrice.ToString("#####0.##0");
if (cboProductUnit.Items.Count == 0)
{
cboProductUnit.Items.Add(new ListItem("No Unit", "0"));
}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ComputeAmount();
cboVariation_SelectedIndexChanged(null, null);
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
{
return;
}
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
if (ProductID == 0)
{
cboVariation.Items.Clear();
cboVariation.Items.Add(new ListItem("No Variation", "0"));
return;
}
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "VariationDesc";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{
cboVariation.Items.Add(new ListItem("No Variation", "0"));
}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
clsProductVariationsMatrix.CommitAndDispose();
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
clsUnitMatrix.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
clsDetails = clsProduct.Details(ProductID);
clsProduct.CommitAndDispose();
cboProductUnit.Items.Add(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.Count - 1;
cboVariation_SelectedIndexChanged(null, null);
}
protected void cboProducts_SelectedIndexChanged(object sender, System.EventArgs e)
{
long ProductID = Convert.ToInt64(cboProducts.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboProductVariation.DataTextField = "VariationDesc";
cboProductVariation.DataValueField = "MatrixID";
cboProductVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboProductVariation.DataBind();
cboProductVariation.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboProductVariation.SelectedIndex = 0;
clsProductVariationsMatrix.CommitAndDispose();
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
{
return;
}
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{
cboVariation.Items.Add(new ListItem("No Variation", "0"));
}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
ProductDetails clsDetails = clsProduct.Details(ProductID);
clsProductVariationsMatrix.CommitAndDispose();
cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
txtPrice.Text = clsDetails.WSPrice.ToString("#####0.#0");
if (clsDetails.VAT > 0)
{
chkIsTaxable.Checked = true;
}
else
{
chkIsTaxable.Checked = false;
}
ComputeItemAmount();
cboVariation_SelectedIndexChanged(null, null);
}
protected void cboProductCode_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (cboProductCode.SelectedItem.Text == "No product")
{
imgProductHistory.Visible = false;
imgProductPriceHistory.Visible = false;
imgInventoryAdjustment.Visible = false;
imgEditNow.Visible = false;
cboVariation.Items.Clear();
cboVariation.Items.Insert(0, new ListItem("No Product", "0"));
cboVariation.SelectedIndex = 0;
}
else
{
imgProductHistory.Visible = true;
imgProductPriceHistory.Visible = true;
imgInventoryAdjustment.Visible = true;
imgEditNow.Visible = true;
txtProductCode.Text = cboProductCode.SelectedItem.Text;
Int64 ProductID = Int64.Parse(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
cboVariation.Items.Insert(0, new ListItem("Main Product", "0"));
cboVariation.Items.Insert(0, new ListItem(Constants.ALL, "-1"));
cboVariation.SelectedIndex = 0;
}
}
catch { }
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
{
return;
}
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{
cboVariation.Items.Add(new ListItem("No Variation", "0"));
}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
ProductDetails clsDetails = clsProduct.Details(ProductID);
clsProductVariationsMatrix.CommitAndDispose();
cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
txtPrice.Text = clsDetails.WSPrice.ToString("#####0.#0");
txtSellingPrice.Text = clsDetails.Price.ToString("#####0.#0");
decimal decMargin = clsDetails.Price - clsDetails.WSPrice;
try { decMargin = decMargin / clsDetails.WSPrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtMargin.Text = decMargin.ToString("#,##0.##0");
txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0");
if (clsDetails.VAT > 0)
{
chkIsTaxable.Checked = true;
}
else
{
chkIsTaxable.Checked = false;
}
ComputeItemAmount();
cboVariation_SelectedIndexChanged(null, null);
//if (ProductID != 0)
//{
// lnkVariationAdd.Visible = true;
// string stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
// "&prodid=" + Common.Encrypt(ProductID.ToString(), Session.SessionID);
// lnkVariationAdd.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx" + stParam;
//}
//else { lnkVariationAdd.Visible = false; }
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
{
return;
}
if (cboProductCode.Items.Count == 1 && cboProductCode.SelectedValue == Constants.ZERO_STRING)
{
return;
}
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{
cboVariation.Items.Add(new ListItem("No Variation", "0"));
}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
ProductDetails clsDetails = clsProduct.Details(ProductID);
ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
System.Data.DataTable dtProductPurchasePriceHistory = clsProductPurchasePriceHistory.ListAsDataTable(ProductID, DateTime.Now.AddMonths(-6), "PurchasePrice", SortOption.Ascending);
clsProductVariationsMatrix.CommitAndDispose();
string strPurchasePriceHistory = string.Empty;
foreach (System.Data.DataRow dr in dtProductPurchasePriceHistory.Rows)
{
DateTime dtePurchaseDate = DateTime.Parse(dr["PurchaseDate"].ToString());
decimal decPurchasePrice = decimal.Parse(dr["PurchasePrice"].ToString());
long lngSupplierID = long.Parse(dr["SupplierID"].ToString());
string strSupplierName = "" + dr["SupplierName"].ToString();
strPurchasePriceHistory += dtePurchaseDate.ToString("ddMMMyyyy HH:mm") + ": " + decPurchasePrice.ToString("#,##0.#0").PadLeft(10) + " " + strSupplierName + "\r\n<br />" + Environment.NewLine;
}
lblPurchasePriceHistory.Text = "<br />" + strPurchasePriceHistory;
cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.#0");
txtSellingPrice.Text = clsDetails.Price.ToString("#####0.#0");
txtOldSellingPrice.Text = clsDetails.Price.ToString("#####0.#0");
decimal decMargin = clsDetails.Price - clsDetails.PurchasePrice;
try { decMargin = decMargin / clsDetails.PurchasePrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtMargin.Text = decMargin.ToString("#,##0.##0");
txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0");
if (clsDetails.VAT > 0)
{
chkIsTaxable.Checked = true;
}
else
{
chkIsTaxable.Checked = false;
}
ComputeItemAmount();
cboVariation_SelectedIndexChanged(null, null);
}
