private bool Delete()
{
bool boRetValue = false;
string stIDs = "";
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
if (chkList != null)
{
if (chkList.Checked == true)
{
stIDs += chkList.Value + ",";
boRetValue = true;
}
}
}
if (boRetValue)
{
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
clsUnitMatrix.Delete(stIDs.Substring(0, stIDs.Length - 1));
clsUnitMatrix.CommitAndDispose();
}
return(boRetValue);
}
private void LoadOptions()
{
lblMatrixID.Text = Common.Decrypt((string)Request.QueryString["matrixid"], Session.SessionID);
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"], Session.SessionID);
ProductUnitsMatrix clsUnit = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
cboUnit.Items.Add(new ListItem(clsDetails.BaseUnitName, clsDetails.BaseUnitID.ToString()));
cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsDetails.BaseUnitID.ToString()));
txtProductPrice.Text = clsDetails.Price.ToString("#,##0.#0");
txtPurchasePrice.Text = clsDetails.PurchasePrice.ToString("#,##0.#0");
txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0");
clsProduct.CommitAndDispose();
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"], Session.SessionID);
lblMatrixID.Text = Common.Decrypt(Request.QueryString["id"], Session.SessionID);
ProductVariations clsProductVariation = new ProductVariations();
lstItem.DataSource = clsProductVariation.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
lstItem.DataBind();
clsProductVariation.CommitAndDispose();
ProductUnitsMatrix clsProductUnitsMatrix = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsProductUnitsMatrix.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsProductUnitsMatrix.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
cboUnit.Items.Add(new ListItem(clsDetails.BaseUnitName, clsDetails.BaseUnitID.ToString()));
clsProduct.CommitAndDispose();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
lblProductSubGroupID.Text = clsDetails.ProductSubGroupID.ToString();
string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(lblProductID.Text, Session.SessionID);
lnkVariations.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Variations/Default.aspx" + stParam;
}
private void LoadOptions()
{
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"], Session.SessionID);
ProductVariations clsProductVariation = new ProductVariations();
lstItem.DataSource = clsProductVariation.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
lstItem.DataBind();
clsProductVariation.CommitAndDispose();
ProductUnitsMatrix clsUnit = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsProductDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
lblProductSubGroupID.Text = clsProductDetails.ProductSubGroupID.ToString();
cboUnit.Items.Add(new ListItem(clsProductDetails.BaseUnitName, clsProductDetails.BaseUnitID.ToString()));
cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsProductDetails.BaseUnitID.ToString()));
txtProductPrice.Text = clsProductDetails.Price.ToString("#,##0.#0");
txtPrice1.Text = clsProductDetails.Price1.ToString("#,##0.#0");
txtPrice2.Text = clsProductDetails.Price2.ToString("#,##0.#0");
txtPrice3.Text = clsProductDetails.Price3.ToString("#,##0.#0");
txtPrice4.Text = clsProductDetails.Price4.ToString("#,##0.#0");
txtPrice5.Text = clsProductDetails.Price5.ToString("#,##0.#0");
txtWSPrice.Text = clsProductDetails.WSPrice.ToString("#,##0.#0");
txtPurchasePrice.Text = clsProductDetails.PurchasePrice.ToString("#,##0.#0");
decimal decMargin = clsProductDetails.Price - clsProductDetails.PurchasePrice;
try { decMargin = decMargin / clsProductDetails.PurchasePrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtMargin.Text = decMargin.ToString("#,##0.##0");
decMargin = clsProductDetails.WSPrice - clsProductDetails.PurchasePrice;
try { decMargin = decMargin / clsProductDetails.PurchasePrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtWSPriceMarkUp.Text = decMargin.ToString("#,##0.##0");
chkIncludeInSubtotalDiscount.Checked = clsProductDetails.IncludeInSubtotalDiscount;
txtVAT.Text = clsProductDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsProductDetails.EVAT.ToString("#,##0.#0");
clsProduct.CommitAndDispose();
string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(lblProductID.Text, Session.SessionID);
lnkVariations.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Variations/Default.aspx" + stParam;
}
private void LoadList()
{
try
{
string SortField = "a.MatrixID";
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);
}
ProductUnitsMatrix clsProductUnitsMatrix = new ProductUnitsMatrix();
PageData.DataSource = clsProductUnitsMatrix.ListAsDataTable(Convert.ToInt64(lblProductID.Text), SortField, sortoption).DefaultView;
clsProductUnitsMatrix.CommitAndDispose();
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;
}
catch { }
}
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);
}
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);
}
private void SaveRecord()
{
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsDetails = new ProductUnitsMatrixDetails();
clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.BaseUnitID = Convert.ToInt16(lblBaseUnitID.Text);
clsDetails.BaseUnitValue = Convert.ToDecimal(txtBaseUnitValue.Text);
clsDetails.BottomUnitID = Convert.ToInt16(cboBottomUnit.SelectedItem.Value);
clsDetails.BottomUnitValue = Convert.ToDecimal(txtBottomUnitValue.Text);
clsUnitMatrix.Update(clsDetails);
clsUnitMatrix.CommitAndDispose();
}
private void LoadRecord()
{
long iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsDetails = clsUnitMatrix.Details(iID);
lblBaseUnitID.Text = clsDetails.BaseUnitID.ToString();
txtBaseUnit.Text = Convert.ToString(clsDetails.BaseUnitName);
txtBaseUnitValue.Text = clsDetails.BaseUnitValue.ToString();
// cboBottomUnit.Items.RemoveAt( cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(lblBaseUnitID.Text)));
cboBottomUnit.SelectedIndex = cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(clsDetails.BottomUnitID.ToString()));
txtBottomUnitValue.Text = clsDetails.BottomUnitValue.ToString();
clsUnitMatrix.CommitAndDispose();
}
private void LoadOptions()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
lblMatrixID.Text = iID.ToString();
Int64 prodID = Convert.ToInt64(Common.Decrypt(Request.QueryString["prodid"], Session.SessionID));
lblProductID.Text = prodID.ToString();
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
cboBottomUnit.DataTextField = "UnitName";
cboBottomUnit.DataValueField = "UnitID";
cboBottomUnit.DataSource = clsUnitMatrix.AvailableUnitsForProduct(prodID).DefaultView;
cboBottomUnit.DataBind();
cboBottomUnit.SelectedIndex = cboBottomUnit.Items.Count - 1;
clsUnitMatrix.CommitAndDispose();
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"], Session.SessionID);
lblPackageID.Text = Common.Decrypt(Request.QueryString["id"], Session.SessionID);
ProductUnitsMatrix clsUnit = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(Convert.ToInt64(lblProductID.Text), "MatrixID", SortOption.Ascending).DefaultView;
cboUnit.DataBind();
Products clsProduct = new Products(clsUnit.Connection, clsUnit.Transaction);
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
clsUnit.CommitAndDispose();
cboUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitName, clsDetails.BaseUnitID.ToString()));
cboUnit.SelectedIndex = 0;
}
private void LoadOptions()
{
lblMatrixID.Text = Common.Decrypt((string)Request.QueryString["matrixid"], Session.SessionID);
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"], Session.SessionID);
lblPackageID.Text = Common.Decrypt(Request.QueryString["id"], Session.SessionID);
ProductUnitsMatrix clsUnit = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
cboUnit.Items.Add(new ListItem(clsDetails.BaseUnitName, clsDetails.BaseUnitID.ToString()));
clsProduct.CommitAndDispose();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
}
private void LoadOptions()
{
Int64 prodid = Convert.ToInt64(Common.Decrypt(Request.QueryString["prodid"].ToString(), Session.SessionID));
lblProductID.Text = Convert.ToString(prodid);
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(prodid);
if (clsUnitDetails.BottomUnitName == null)
{
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
clsDetails = clsProduct.Details(prodid);
clsProduct.CommitAndDispose();
txtBaseUnit.Text = clsDetails.BaseUnitName;
lblBaseUnitID.Text = Convert.ToString(clsDetails.BaseUnitID);
}
else
{
txtBaseUnit.Text = clsUnitDetails.BottomUnitName;
lblBaseUnitID.Text = Convert.ToString(clsUnitDetails.BottomUnitID);
}
cboBottomUnit.DataTextField = "UnitName";
cboBottomUnit.DataValueField = "UnitID";
cboBottomUnit.DataSource = clsUnitMatrix.AvailableUnitsForProduct(prodid).DefaultView;
cboBottomUnit.DataBind();
if (cboBottomUnit.Items.Contains(new ListItem(txtBaseUnit.Text, lblBaseUnitID.Text)))
{
cboBottomUnit.Items.RemoveAt(cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(lblBaseUnitID.Text)));
}
cboBottomUnit.SelectedIndex = cboBottomUnit.Items.Count - 1;
clsUnitMatrix.CommitAndDispose();
}
private void SaveRecord()
{
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsDetails = new ProductUnitsMatrixDetails();
clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.BaseUnitID = Convert.ToInt16(lblBaseUnitID.Text);
clsDetails.BaseUnitValue = Convert.ToDecimal(txtBaseUnitValue.Text);
clsDetails.BottomUnitID = Convert.ToInt16(cboBottomUnit.SelectedItem.Value);
clsDetails.BottomUnitValue = Convert.ToDecimal(txtBottomUnitValue.Text);
clsUnitMatrix.Update(clsDetails);
clsUnitMatrix.CommitAndDispose();
}
private void LoadOptions()
{
lblMatrixID.Text = Common.Decrypt((string)Request.QueryString["matrixid"],Session.SessionID);
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"],Session.SessionID);
lblPackageID.Text = Common.Decrypt(Request.QueryString["id"],Session.SessionID);
ProductUnitsMatrix clsUnit = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
cboUnit.Items.Add(new ListItem(clsDetails.BaseUnitName, clsDetails.BaseUnitID.ToString()));
clsProduct.CommitAndDispose();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
}
private bool Delete()
{
bool boRetValue = false;
string stIDs = "";
foreach(DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList");
if (chkList!=null)
{
if (chkList.Checked == true)
{
stIDs += chkList.Value + ",";
boRetValue = true;
}
}
}
if (boRetValue)
{
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
clsUnitMatrix.Delete(stIDs.Substring(0,stIDs.Length-1));
clsUnitMatrix.CommitAndDispose();
}
return boRetValue;
}
private void LoadList()
{
try
{
string SortField = "a.MatrixID";
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); }
ProductUnitsMatrix clsProductUnitsMatrix = new ProductUnitsMatrix();
PageData.DataSource = clsProductUnitsMatrix.ListAsDataTable(Convert.ToInt64(lblProductID.Text), SortField, sortoption).DefaultView;
clsProductUnitsMatrix.CommitAndDispose();
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;
}
catch { }
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"],Session.SessionID);
lblPackageID.Text = Common.Decrypt(Request.QueryString["id"],Session.SessionID);
ProductUnitsMatrix clsUnit = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(Convert.ToInt64(lblProductID.Text),"MatrixID",SortOption.Ascending).DefaultView;
cboUnit.DataBind();
Products clsProduct = new Products(clsUnit.Connection, clsUnit.Transaction);
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
clsUnit.CommitAndDispose();
cboUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitName, clsDetails.BaseUnitID.ToString()));
cboUnit.SelectedIndex = 0;
}
private void LoadOptions()
{
Int64 prodid = Convert.ToInt64(Common.Decrypt(Request.QueryString["prodid"].ToString(),Session.SessionID));
lblProductID.Text = Convert.ToString(prodid);
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(prodid);
if (clsUnitDetails.BottomUnitName == null)
{
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
clsDetails = clsProduct.Details(prodid);
clsProduct.CommitAndDispose();
txtBaseUnit.Text = clsDetails.BaseUnitName;
lblBaseUnitID.Text = Convert.ToString(clsDetails.BaseUnitID);
}
else
{
txtBaseUnit.Text = clsUnitDetails.BottomUnitName;
lblBaseUnitID.Text = Convert.ToString(clsUnitDetails.BottomUnitID);
}
cboBottomUnit.DataTextField = "UnitName";
cboBottomUnit.DataValueField = "UnitID";
cboBottomUnit.DataSource = clsUnitMatrix.AvailableUnitsForProduct(prodid).DefaultView;
cboBottomUnit.DataBind();
if (cboBottomUnit.Items.Contains( new ListItem(txtBaseUnit.Text, lblBaseUnitID.Text)))
{
cboBottomUnit.Items.RemoveAt( cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(lblBaseUnitID.Text)));
}
cboBottomUnit.SelectedIndex = cboBottomUnit.Items.Count - 1;
clsUnitMatrix.CommitAndDispose();
}
private void LoadRecord()
{
long iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"],Session.SessionID));
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsDetails = clsUnitMatrix.Details(iID);
lblBaseUnitID.Text = clsDetails.BaseUnitID.ToString();
txtBaseUnit.Text = Convert.ToString(clsDetails.BaseUnitName);
txtBaseUnitValue.Text = clsDetails.BaseUnitValue.ToString();
// cboBottomUnit.Items.RemoveAt( cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(lblBaseUnitID.Text)));
cboBottomUnit.SelectedIndex = cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(clsDetails.BottomUnitID.ToString()));
txtBottomUnitValue.Text = clsDetails.BottomUnitValue.ToString();
clsUnitMatrix.CommitAndDispose();
}
private void LoadOptions()
{
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"],Session.SessionID);
ProductVariations clsProductVariation = new ProductVariations();
lstItem.DataSource = clsProductVariation.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
lstItem.DataBind();
clsProductVariation.CommitAndDispose();
ProductUnitsMatrix clsUnit = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsProductDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
lblProductSubGroupID.Text = clsProductDetails.ProductSubGroupID.ToString();
cboUnit.Items.Add(new ListItem(clsProductDetails.BaseUnitName, clsProductDetails.BaseUnitID.ToString()));
cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsProductDetails.BaseUnitID.ToString()));
txtProductPrice.Text = clsProductDetails.Price.ToString("#,##0.#0");
txtPrice1.Text = clsProductDetails.Price1.ToString("#,##0.#0");
txtPrice2.Text = clsProductDetails.Price2.ToString("#,##0.#0");
txtPrice3.Text = clsProductDetails.Price3.ToString("#,##0.#0");
txtPrice4.Text = clsProductDetails.Price4.ToString("#,##0.#0");
txtPrice5.Text = clsProductDetails.Price5.ToString("#,##0.#0");
txtWSPrice.Text = clsProductDetails.WSPrice.ToString("#,##0.#0");
txtPurchasePrice.Text = clsProductDetails.PurchasePrice.ToString("#,##0.#0");
decimal decMargin = clsProductDetails.Price - clsProductDetails.PurchasePrice;
try { decMargin = decMargin / clsProductDetails.PurchasePrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtMargin.Text = decMargin.ToString("#,##0.##0");
decMargin = clsProductDetails.WSPrice - clsProductDetails.PurchasePrice;
try { decMargin = decMargin / clsProductDetails.PurchasePrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtWSPriceMarkUp.Text = decMargin.ToString("#,##0.##0");
chkIncludeInSubtotalDiscount.Checked = clsProductDetails.IncludeInSubtotalDiscount;
txtVAT.Text = clsProductDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsProductDetails.EVAT.ToString("#,##0.#0");
clsProduct.CommitAndDispose();
string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(lblProductID.Text, Session.SessionID);
lnkVariations.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Variations/Default.aspx" + stParam;
}
private void LoadOptions()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
lblMatrixID.Text = iID.ToString();
Int64 prodID = Convert.ToInt64(Common.Decrypt(Request.QueryString["prodid"],Session.SessionID));
lblProductID.Text = prodID.ToString();
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
cboBottomUnit.DataTextField = "UnitName";
cboBottomUnit.DataValueField = "UnitID";
cboBottomUnit.DataSource = clsUnitMatrix.AvailableUnitsForProduct(prodID).DefaultView;
cboBottomUnit.DataBind();
cboBottomUnit.SelectedIndex = cboBottomUnit.Items.Count - 1;
clsUnitMatrix.CommitAndDispose();
}
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;
}
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);
}
private void LoadOptions()
{
lblMatrixID.Text = Common.Decrypt((string)Request.QueryString["matrixid"],Session.SessionID);
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"],Session.SessionID);
ProductUnitsMatrix clsUnit = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
cboUnit.Items.Add(new ListItem(clsDetails.BaseUnitName, clsDetails.BaseUnitID.ToString()));
cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsDetails.BaseUnitID.ToString()));
txtProductPrice.Text = clsDetails.Price.ToString("#,##0.#0");
txtPurchasePrice.Text = clsDetails.PurchasePrice.ToString("#,##0.#0");
txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0");
clsProduct.CommitAndDispose();
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"],Session.SessionID);
lblMatrixID.Text = Common.Decrypt(Request.QueryString["id"],Session.SessionID);
ProductVariations clsProductVariation = new ProductVariations();
lstItem.DataSource = clsProductVariation.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
lstItem.DataBind();
clsProductVariation.CommitAndDispose();
ProductUnitsMatrix clsProductUnitsMatrix = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsProductUnitsMatrix.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsProductUnitsMatrix.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
cboUnit.Items.Add(new ListItem(clsDetails.BaseUnitName, clsDetails.BaseUnitID.ToString()));
clsProduct.CommitAndDispose();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
lblProductSubGroupID.Text = clsDetails.ProductSubGroupID.ToString();
string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(lblProductID.Text, Session.SessionID);
lnkVariations.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Variations/Default.aspx" + stParam;
}