protected void Page_Load(object sender, System.EventArgs e)
{
const string defaultHeading = "Master Files";
string stHeading = defaultHeading;
const string defaultTitle = "Product Variation Combinations";
SiteTitle.Title = defaultTitle;
const SearchCategoryID defaultSearchIndex = SearchCategoryID.ProductVariationsMatrix;
SearchCategoryID SearchIndex = defaultSearchIndex;
HorizontalNavBar.PageNavigatorid = HorizontalNavID.MasterFiles;
if (Request.QueryString["task"]!=null)
{
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
long prodid = Convert.ToInt64(Common.Decrypt(Request.QueryString["prodid"].ToString(), Session.SessionID));
clsDetails = clsProduct.Details(prodid);
clsProduct.CommitAndDispose();
string productCode = " for : " + clsDetails.ProductCode;
string task = Common.Decrypt(Request.QueryString["task"].ToString(),Session.SessionID);
switch(task)
{
case "add":
stHeading = "Create New Product Variation Combination";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlInsert.Visible = true;
break;
case "edit":
stHeading = "Modify Product Variation Combination";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlUpdate.Visible = true;
break;
case "det":
stHeading = "Product Variation Details";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlDetails.Visible = true;
break;
case "list":
stHeading = "Product Variation Combinations List ";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlList.Visible = true;
break;
default:
break;
}
LargeHeading.Text = stHeading + productCode;
RightBodySectionSearch.SearchIDSelectedItem = SearchIndex;
}
}
private void SetDataSourceProducts(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
string ProductGroupName = string.Empty;
if (cboGroup.SelectedItem.Value != Constants.ZERO_STRING) ProductGroupName = cboGroup.SelectedItem.Text;
string SubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING) SubGroupName = cboSubGroup.SelectedItem.Text;
Products clsProduct = new Products();
System.Data.DataTable dtProductInventoryReport = clsProduct.InventoryReport(ProductGroupName, SubGroupName, txtProductCodeSearch.Text);
//ProductVariationsMatrix clsMatrix = new ProductVariationsMatrix(clsProduct.Connection, clsProduct.Transaction);
//System.Data.DataTable dtMatrixInventoryReport = clsMatrix.InventoryReport(ProductGroupName, SubGroupName, txtProductCodeSearch.Text);
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dtProductInventoryReport.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
if (cboProductCode.SelectedItem.Value != Constants.ZERO_STRING)
{
Products clsProduct = new Products();
ProductDetails clsProductDetails = clsProduct.Details(long.Parse(cboProductCode.SelectedItem.Value));
clsProduct.CommitAndDispose();
txtRedeemRewardPoints.Text = clsProductDetails.RewardPoints.ToString("#,##0.#0");
txtNewRewardPoints.Text = Convert.ToInt32(Convert.ToDecimal(txtCurrentRewardPoints.Text) - Convert.ToDecimal(txtRedeemRewardPoints.Text)).ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
private bool CopyPOSToActual()
{
bool boRetValue = false;
Products clsProduct = new Products();
boRetValue = clsProduct.CopyPOSToActualByProductGroup(int.Parse(cboBranch.SelectedItem.Value), long.Parse(cboProductGroup.SelectedItem.Value));
clsProduct.CommitAndDispose();
boRetValue = true;
return boRetValue;
}
protected void lstItem_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList");
HtmlInputCheckBox chkMatrixID = (HtmlInputCheckBox)e.Item.FindControl("chkMatrixID");
string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
switch(e.CommandName)
{
case "imgProductTag":
{
ImageButton imgProductTag = (ImageButton)e.Item.FindControl("imgProductTag");
Products clsProduct = new Products();
if (imgProductTag.ToolTip == "Tag this product as INACTIVE.")
{
clsProduct.TagInactive(long.Parse(chkList.Value));
imgProductTag.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/prodtaginact.gif";
imgProductTag.ToolTip = "Tag this product as ACTIVE.";
}
else
{
clsProduct.TagActive(long.Parse(chkList.Value));
imgProductTag.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/prodtagact.gif";
imgProductTag.ToolTip = "Tag this product as INACTIVE.";
}
clsProduct.CommitAndDispose();
}
break;
case "imgSaveActualQuantity":
{
TextBox txtActualQuantity = (TextBox)e.Item.FindControl("txtActualQuantity");
try { decimal.Parse(txtActualQuantity.Text); }
catch
{
string stScript = "<Script>";
stScript += "window.alert('Please enter a VALID actual quantity.')";
stScript += "</Script>";
Response.Write(stScript);
break;
}
ProductInventories clsProductInventories = new ProductInventories();
clsProductInventories.UpdateActualQuantity(int.Parse(cboBranch.SelectedItem.Value), long.Parse(chkList.Value), long.Parse(chkMatrixID.Value), decimal.Parse(txtActualQuantity.Text));
clsProductInventories.CommitAndDispose();
}
break;
}
}
private void SaveRecord()
{
DebitMemoItemDetails clsDetails = new DebitMemoItemDetails();
Products clsProducts = new Products();
ProductDetails clsProductDetails = clsProducts.Details1(Constants.BRANCH_ID_MAIN, Convert.ToInt64(cboProductCode.SelectedItem.Value));
Terminal clsTerminal = new Terminal(clsProducts.Connection, clsProducts.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
clsProducts.CommitAndDispose();
clsDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text);
clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
clsDetails.ProductCode = clsProductDetails.ProductCode;
clsDetails.BarCode = clsProductDetails.BarCode;
clsDetails.Description = clsProductDetails.ProductDesc;
clsDetails.ProductUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.ProductUnitCode = cboProductUnit.SelectedItem.Text;
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.PrevUnitCost = Convert.ToDecimal(txtPrevPrice.Text);
clsDetails.UnitCost = Convert.ToDecimal(txtPrice.Text);
clsDetails.Discount = getItemTotalDiscount();
clsDetails.DiscountApplied = Convert.ToDecimal(txtDiscount.Text);
if (clsDetails.DiscountApplied == 0)
{
if (chkInPercent.Checked == true)
clsDetails.DiscountType = DiscountTypes.Percentage;
else
clsDetails.DiscountType = DiscountTypes.FixedValue;
}
else
{
clsDetails.DiscountType = DiscountTypes.NotApplicable;
}
clsDetails.IsVatable = chkIsTaxable.Checked;
clsDetails.Amount = ComputeItemAmount();
if (clsDetails.IsVatable)
{
clsDetails.VatableAmount = clsDetails.Amount;
clsDetails.EVatableAmount = clsDetails.Amount;
clsDetails.LocalTax = clsDetails.Amount;
if (clsTerminalDetails.IsVATInclusive == false)
{
if (clsDetails.VatableAmount < clsDetails.Discount) clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount < clsDetails.Discount) clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax < clsDetails.Discount) clsDetails.LocalTax = 0;
}
else
{
if (clsDetails.VatableAmount >= clsDetails.Discount) clsDetails.VatableAmount = (clsDetails.VatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount >= clsDetails.Discount) clsDetails.EVatableAmount = (clsDetails.EVatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax >= clsDetails.Discount) clsDetails.LocalTax = (clsDetails.LocalTax) / (1 + (clsTerminalDetails.LocalTax / 100)); else clsDetails.LocalTax = 0;
}
clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100);
clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100);
clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100);
}
else
{
clsDetails.VAT = 0;
clsDetails.VatableAmount = 0;
clsDetails.EVAT = 0;
clsDetails.EVatableAmount = 0;
clsDetails.LocalTax = 0;
}
clsDetails.isVATInclusive = clsTerminalDetails.IsVATInclusive;
clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (clsDetails.VariationMatrixID != 0)
clsDetails.MatrixDescription = cboVariation.SelectedItem.Text;
clsDetails.ProductGroup = clsProductDetails.ProductGroupCode;
clsDetails.ProductSubGroup = clsProductDetails.ProductSubGroupCode;
clsDetails.Remarks = txtRemarks.Text;
DebitMemoItems clsDebitMemoItems = new DebitMemoItems();
if (lblDebitMemoItemID.Text != "0")
{
clsDetails.DebitMemoItemID = Convert.ToInt64(lblDebitMemoItemID.Text);
clsDebitMemoItems.Update(clsDetails);
}
else
clsDebitMemoItems.Insert(clsDetails);
DebitMemoDetails clsDebitMemoDetails = new DebitMemoDetails();
clsDebitMemoDetails.DebitMemoID = clsDetails.DebitMemoID;
clsDebitMemoDetails.DiscountApplied = Convert.ToDecimal(txtPODebitMemoDiscountApplied.Text);
clsDebitMemoDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscountType.SelectedItem.Value);
clsDebitMemoDetails.Discount2Applied = Convert.ToDecimal(txtPODebitMemoDiscount2Applied.Text);
clsDebitMemoDetails.Discount2Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount2Type.SelectedItem.Value);
clsDebitMemoDetails.Discount3Applied = Convert.ToDecimal(txtPODebitMemoDiscount3Applied.Text);
clsDebitMemoDetails.Discount3Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount3Type.SelectedItem.Value);
DebitMemos clsDebitMemos = new DebitMemos(clsDebitMemoItems.Connection, clsDebitMemoItems.Transaction);
clsDebitMemos.UpdateDiscount(clsDetails.DebitMemoID, clsDebitMemoDetails.DiscountApplied, clsDebitMemoDetails.DiscountType, clsDebitMemoDetails.Discount2Applied, clsDebitMemoDetails.Discount2Type, clsDebitMemoDetails.Discount3Applied, clsDebitMemoDetails.Discount3Type);
clsDebitMemoDetails = clsDebitMemos.Details(clsDetails.DebitMemoID);
clsDebitMemoItems.CommitAndDispose();
UpdateFooter(clsDebitMemoDetails);
}
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 LoadRecord()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"],Session.SessionID));
Products clsProduct = new Products();
ProductDetails clsDetails = clsProduct.Details(iID);
Contacts clsContact = new Contacts(clsProduct.Connection, clsProduct.Transaction);
ContactDetails clsContactDetails = clsContact.Details(clsDetails.SupplierID);
clsProduct.CommitAndDispose();
lblProductID.Text = clsDetails.ProductID.ToString();
lblQuantity.Text = clsDetails.Quantity.ToString("#,##0.#0");
lblUnitCode.Text = clsDetails.BaseUnitCode;
lblProductCode.Text = clsDetails.ProductCode;
lblBarcode.Text = clsDetails.BarCode;
lblProductDesc.Text = clsDetails.ProductDesc;
lblProductGroup.Text = clsDetails.ProductGroupCode + "/" + clsDetails.ProductGroupName;
lblProductSubGroup.Text = clsDetails.ProductSubGroupCode + "/" + clsDetails.ProductSubGroupName;
lblSupplierCode.Text = clsContactDetails.ContactCode.ToString();
string stParam = "?task=" + Common.Encrypt("details",Session.SessionID) + "&id=" + Common.Encrypt(clsDetails.SupplierID.ToString(),Session.SessionID);
lblSupplierCode.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Contact/Default.aspx" + stParam;
lblSupplierContact.Text = clsContactDetails.BusinessName;
lblSupplierTelephoneNo.Text = clsContactDetails.TelephoneNo;
cboChartOfAccountPurchase.SelectedIndex = cboChartOfAccountPurchase.Items.IndexOf(cboChartOfAccountPurchase.Items.FindByValue(clsDetails.ChartOfAccountIDPurchase.ToString()));
cboChartOfAccountSold.SelectedIndex = cboChartOfAccountSold.Items.IndexOf(cboChartOfAccountSold.Items.FindByValue(clsDetails.ChartOfAccountIDSold.ToString()));
cboChartOfAccountInventory.SelectedIndex = cboChartOfAccountInventory.Items.IndexOf(cboChartOfAccountInventory.Items.FindByValue(clsDetails.ChartOfAccountIDInventory.ToString()));
cboChartOfAccountIDTaxPurchase.SelectedIndex = cboChartOfAccountIDTaxPurchase.Items.IndexOf(cboChartOfAccountIDTaxPurchase.Items.FindByValue(clsDetails.ChartOfAccountIDTaxPurchase.ToString()));
cboChartOfAccountIDTaxSold.SelectedIndex = cboChartOfAccountIDTaxSold.Items.IndexOf(cboChartOfAccountIDTaxSold.Items.FindByValue(clsDetails.ChartOfAccountIDTaxSold.ToString()));
}
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();
}
protected void imgProductQuickAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(txtProductCode.Text))
{
ProductDetails clsDetails = new ProductDetails();
clsDetails.ProductCode = txtProductCode.Text;
clsDetails.BarCode = txtProductCode.Text;
clsDetails.ProductDesc = txtProductCode.Text;
clsDetails.ProductGroupID = ProductGroup.DEFAULT_GROUP_ID;
clsDetails.ProductSubGroupID = ProductSubGroup.DEFAULT_SUB_GROUP_ID;
clsDetails.BaseUnitID = Data.Unit.DEFAULT_UNIT_ID;
clsDetails.Price = 0;
clsDetails.PurchasePrice = 0;
clsDetails.IncludeInSubtotalDiscount = true;
clsDetails.VAT = Constants.DEFAULTS_VAT;
clsDetails.EVAT = 0;
clsDetails.LocalTax = 0;
clsDetails.Quantity = 0;
clsDetails.MinThreshold = 0;
clsDetails.MaxThreshold = 0;
clsDetails.SupplierID = Contacts.DEFAULT_SUPPLIER_ID;
clsDetails.IsItemSold = true;
clsDetails.WillPrintProductComposition = false;
Products clsProduct = new Products();
long id = clsProduct.Insert(clsDetails);
clsDetails.ProductID = id;
long lngUID = long.Parse(Session["UID"].ToString());
InvAdjustmentDetails clsInvAdjustmentDetails = new InvAdjustmentDetails();
clsInvAdjustmentDetails.UID = lngUID;
clsInvAdjustmentDetails.InvAdjustmentDate = DateTime.Now;
clsInvAdjustmentDetails.ProductID = id;
clsInvAdjustmentDetails.ProductCode = clsDetails.ProductCode;
clsInvAdjustmentDetails.Description = clsDetails.ProductDesc;
clsInvAdjustmentDetails.VariationMatrixID = 0;
clsInvAdjustmentDetails.MatrixDescription = null;
clsInvAdjustmentDetails.UnitID = clsDetails.BaseUnitID;
clsInvAdjustmentDetails.UnitCode = cboProductUnit.SelectedItem.Text;
clsInvAdjustmentDetails.QuantityBefore = 0;
clsInvAdjustmentDetails.QuantityNow = clsDetails.Quantity;
clsInvAdjustmentDetails.MinThresholdBefore = 0;
clsInvAdjustmentDetails.MinThresholdNow = clsDetails.MinThreshold;
clsInvAdjustmentDetails.MaxThresholdBefore = 0;
clsInvAdjustmentDetails.MaxThresholdNow = clsDetails.MaxThreshold;
clsInvAdjustmentDetails.Remarks = "newly added. beginning balance.";
InvAdjustment clsInvAdjustment = new InvAdjustment(clsProduct.Connection, clsProduct.Transaction);
clsInvAdjustment.Insert(clsInvAdjustmentDetails);
clsProduct.InheritSubGroupVariations(clsDetails.ProductSubGroupID, clsDetails.ProductID);
clsProduct.CommitAndDispose();
cmdProductCode_Click(null, null);
}
}
catch { }
}
private void LoadRecord()
{
long ProductID = Int64.Parse(lblProductID.Text);
long MatrixID = Int64.Parse(lblMatrixID.Text);
Products clsProducts = new Products();
ProductDetails clsDetails = clsProducts.Details(ProductID: ProductID, MatrixID: MatrixID);
clsProducts.CommitAndDispose();
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");
chkIncludeInSubtotalDiscount.Checked = clsDetails.IncludeInSubtotalDiscount;
txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0");
txtQuantity.Text = clsDetails.Quantity.ToString("#,##0.#0");
txtMinThreshold.Text = clsDetails.MinThreshold.ToString("#,##0.#0");
txtMaxThreshold.Text = clsDetails.MaxThreshold.ToString("#,##0.#0");
}
private void UpdateQuantityByRID()
{
long lngProductID = 0;
try {
lngProductID = long.Parse(cboProductCode.SelectedValue);
if (lngProductID != 0)
{
Products clsProduct = new Products();
txtQuantity.Text = clsProduct.getReorderQtyByRID(lngProductID, Convert.ToDateTime(txtIDCStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtIDCEndDate.Text + " 23:59:59")).ToString("#,##0.##0");
clsProduct.CommitAndDispose();
ComputeItemAmount();
}
}
catch { }
}
private void SetParameters (ReportDocument Report)
{
ParameterFieldDefinition paramField;
ParameterValues currentValues;
ParameterDiscreteValue discreteParam;
paramField = Report.DataDefinition.ParameterFields["CompanyName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = CompanyDetails.CompanyName;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PrintedBy"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = Session["Name"].ToString();
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
DateTime StartTransactionDate = DateTime.MinValue;
try
{ StartTransactionDate = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch { }
paramField = Report.DataDefinition.ParameterFields["StartTransactionDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = StartTransactionDate;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
DateTime EndTransactionDate = DateTime.MinValue;
try
{ EndTransactionDate = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch { }
paramField = Report.DataDefinition.ParameterFields["EndTransactionDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = EndTransactionDate;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
switch (cboReportType.SelectedValue)
{
case ReportTypes.ProductHistoryMovement:
#region Product History Movement
Products clsProduct = new Products();
long lngMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
lngMatrixID = lngMatrixID == -1 ? 0 : lngMatrixID;
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(cboProductCode.SelectedItem.Value), lngMatrixID, Constants.BRANCH_ID_MAIN);
clsProduct.CommitAndDispose();
paramField = Report.DataDefinition.ParameterFields["ProductCode"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsDetails.ProductCode;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["Description"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsDetails.ProductDesc;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["Quantity"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsDetails.Quantity.ToString("#,###.#0");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["UnitCode"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsDetails.BaseUnitCode;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["ConvertedQuantity"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsDetails.ConvertedQuantity;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
break;
#endregion
case ReportTypes.ProductHistoryMostSaleable:
case ReportTypes.ProductHistoryLeastSaleable:
paramField = Report.DataDefinition.ParameterFields["GroupItems"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = chkGroupItems.Checked;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
break;
case ReportTypes.ProductsInDemoReport:
break;
}
}
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 LoadItemData()
{
try
{
string strSearchKey = Constants.MaskProductSearch + txtSearch.Text;
Products clsProduct = new Products();
// System.Data.DataTable dt = clsProduct.ListAsDataTable(mclsTerminalDetails.BranchID, clsSearchKeys: new ProductDetails(), mboShowInActiveProducts ? ProductListFilterType.ShowInactiveOnly : ProductListFilterType.ShowActiveOnly, Limit: 100,
System.Data.DataTable dt = clsProduct.ListAsDataTableFE(mclsTerminalDetails.BranchID, strSearchKey, mboShowInActiveProducts ? ProductListFilterType.ShowActiveAndInactive : ProductListFilterType.ShowActiveOnly, 100, mboShowItemMoreThanZeroQty);
clsProduct.CommitAndDispose();
this.dgStyle.MappingName = dt.TableName;
dgItems.DataSource = dt;
dgItems.Select(0);
dgItems.CurrentRowIndex=0;
ShowProductTotalQuantity();
}
catch (IndexOutOfRangeException) { lblProductCode.Visible = false; lblProductQuantity.Visible = false; }
catch (Exception ex)
{
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
protected void cboVariation_SelectedIndexChanged(object sender, System.EventArgs e)
{
long MatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (MatrixID != 0)
{
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
Products clsProducts = new Products();
ProductDetails clsDetails = clsProducts.Details(ProductID: ProductID, MatrixID: MatrixID);
clsProducts.CommitAndDispose();
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();
}
}
private void SaveRecord()
{
SOItemDetails clsDetails = new SOItemDetails();
Products clsProducts = new Products();
ProductDetails clsProductDetails = clsProducts.Details1(Constants.BRANCH_ID_MAIN, Convert.ToInt64(cboProductCode.SelectedItem.Value));
Terminal clsTerminal = new Terminal(clsProducts.Connection, clsProducts.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
clsProducts.CommitAndDispose();
clsDetails.SOID = Convert.ToInt64(lblSOID.Text);
clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
clsDetails.ProductCode = clsProductDetails.ProductCode;
clsDetails.BarCode = clsProductDetails.BarCode;
clsDetails.Description = clsProductDetails.ProductDesc;
clsDetails.ProductUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.ProductUnitCode = cboProductUnit.SelectedItem.Text;
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.UnitCost = Convert.ToDecimal(txtPrice.Text);
clsDetails.Discount = getItemTotalDiscount();
clsDetails.DiscountApplied = Convert.ToDecimal(txtDiscount.Text);
if (clsDetails.DiscountApplied == 0)
{
if (chkInPercent.Checked == true)
clsDetails.DiscountType = DiscountTypes.Percentage;
else
clsDetails.DiscountType = DiscountTypes.FixedValue;
}
else
{
clsDetails.DiscountType = DiscountTypes.NotApplicable;
}
clsDetails.IsVatable = chkIsTaxable.Checked;
clsDetails.Amount = ComputeItemAmount();
if (clsDetails.IsVatable)
{
clsDetails.VatableAmount = clsDetails.Amount;
clsDetails.EVatableAmount = clsDetails.Amount;
clsDetails.LocalTax = clsDetails.Amount;
if (clsTerminalDetails.IsVATInclusive == false)
{
if (clsDetails.VatableAmount < clsDetails.Discount) clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount < clsDetails.Discount) clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax < clsDetails.Discount) clsDetails.LocalTax = 0;
}
else
{
if (clsDetails.VatableAmount >= clsDetails.Discount) clsDetails.VatableAmount = (clsDetails.VatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount >= clsDetails.Discount) clsDetails.EVatableAmount = (clsDetails.EVatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax >= clsDetails.Discount) clsDetails.LocalTax = (clsDetails.LocalTax) / (1 + (clsTerminalDetails.LocalTax / 100)); else clsDetails.LocalTax = 0;
}
clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100);
clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100);
clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100);
//if (!clsTerminalDetails.IsVATInclusive) clsDetails.Amount += (clsDetails.VAT + clsDetails.LocalTax);
//if (!clsTerminalDetails.EnableEVAT) clsDetails.Amount += clsDetails.EVAT;
}
else
{
clsDetails.VAT = 0;
clsDetails.VatableAmount = 0;
clsDetails.EVAT = 0;
clsDetails.EVatableAmount = 0;
clsDetails.LocalTax = 0;
}
clsDetails.isVATInclusive = clsTerminalDetails.IsVATInclusive;
clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (clsDetails.VariationMatrixID != 0)
clsDetails.MatrixDescription = cboVariation.SelectedItem.Text;
clsDetails.ProductGroup = clsProductDetails.ProductGroupCode;
clsDetails.ProductSubGroup = clsProductDetails.ProductSubGroupCode;
clsDetails.Remarks = txtRemarks.Text;
// Added Jul 1, 2010 4:20PM : for suggested selling information
clsDetails.SellingPrice = decimal.Parse(txtSellingPrice.Text);
clsDetails.SellingVAT = decimal.Parse(txtVAT.Text);
clsDetails.SellingEVAT = decimal.Parse(txtEVAT.Text);
clsDetails.SellingLocalTax = decimal.Parse(txtLocalTax.Text);
SOItem clsSOItem = new SOItem();
if (lblSOItemID.Text != "0")
{
clsDetails.SOItemID = Convert.ToInt64(lblSOItemID.Text);
clsSOItem.Update(clsDetails);
}
else
clsSOItem.Insert(clsDetails);
SODetails clsSODetails = new SODetails();
clsSODetails.SOID = clsDetails.SOID;
clsSODetails.DiscountApplied = Convert.ToDecimal(txtSODiscountApplied.Text);
clsSODetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboSODiscountType.SelectedItem.Value);
SO clsSO = new SO(clsSOItem.Connection, clsSOItem.Transaction);
clsSO.UpdateDiscount(clsDetails.SOID, clsSODetails.DiscountApplied, clsSODetails.DiscountType);
clsSODetails = clsSO.Details(clsDetails.SOID);
clsSOItem.CommitAndDispose();
UpdateFooter(clsSODetails);
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
if (cboProductCode.SelectedItem.Value != Constants.ZERO_STRING)
{
Products clsProduct = new Products();
ProductDetails clsProductDetails = clsProduct.Details(long.Parse(cboProductCode.SelectedItem.Value));
clsProduct.CommitAndDispose();
txtVAT.Text = clsProductDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsProductDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsProductDetails.LocalTax.ToString("#,##0.#0");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void SaveRecord()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
int iChartOfAccountIDPurchase = Convert.ToInt32(cboChartOfAccountPurchase.SelectedItem.Value);
int iChartOfAccountIDSold = Convert.ToInt32(cboChartOfAccountSold.SelectedItem.Value);
int iChartOfAccountIDInventory = Convert.ToInt32(cboChartOfAccountInventory.SelectedItem.Value);
int iChartOfAccountIDTaxPurchase = Convert.ToInt32(cboChartOfAccountIDTaxPurchase.SelectedItem.Value);
int iChartOfAccountIDTaxSold = Convert.ToInt32(cboChartOfAccountIDTaxSold.SelectedItem.Value);
Products clsProduct = new Products();
clsProduct.UpdateFinancialInformation(iID, iChartOfAccountIDPurchase, iChartOfAccountIDSold, iChartOfAccountIDInventory, iChartOfAccountIDTaxPurchase, iChartOfAccountIDTaxSold);
clsProduct.CommitAndDispose();
}
private void SaveRecord()
{
long lngProductGroupID = long.Parse(cboProductGroup.SelectedItem.Value);
long lngProductSubGroupID = long.Parse(cboProductSubGroup.SelectedItem.Value);
long lngProductID = long.Parse(cboProductCode.SelectedItem.Value);
decimal decVAT = 0; decimal decEVAT = 0; decimal decLocalTax = 0;
string javaScript;
try
{ decVAT = decimal.Parse(txtVAT.Text); }
catch
{
javaScript = "window.alert('Please enter a valid VAT.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
try
{ decEVAT = decimal.Parse(txtEVAT.Text); }
catch
{
javaScript = "window.alert('Please enter a valid EVAT.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
try
{ decLocalTax = decimal.Parse(txtLocalTax.Text); }
catch
{
javaScript = "window.alert('Please enter a valid LocalTax.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
Products clsProduct = new Products();
clsProduct.ChangeTax(lngProductGroupID, lngProductSubGroupID, lngProductID, decVAT, decEVAT, decLocalTax, Convert.ToString(Session["Name"]));
clsProduct.CommitAndDispose();
txtVAT.Text = decVAT.ToString("#,##0.#0");
txtEVAT.Text = decEVAT.ToString("#,##0.#0");
txtLocalTax.Text = decLocalTax.ToString("#,##0.#0");
javaScript = "window.alert('Taxes has been updated.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
}
protected void cboVariation_SelectedIndexChanged(object sender, System.EventArgs e)
{
long MatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (MatrixID != 0)
{
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
Products clsProducts = new Products();
ProductDetails clsDetails = clsProducts.Details(ProductID: ProductID, MatrixID: MatrixID);
clsProducts.CommitAndDispose();
txtPrevPrice.Text = clsDetails.PurchasePrice.ToString("####0.#0");
txtPrice.Text = clsDetails.PurchasePrice.ToString("####0.#0");
if (clsDetails.VAT > 0)
chkIsTaxable.Checked = true;
else
chkIsTaxable.Checked = false;
ComputeItemAmount();
}
}
private void SaveRecord()
{
long lngProductGroupID = long.Parse(cboProductGroup.SelectedItem.Value);
long lngProductSubGroupID = long.Parse(cboProductSubGroup.SelectedItem.Value);
long lngProductID = long.Parse(cboProductCode.SelectedItem.Value);
decimal decRewardPoints = 0;
string javaScript;
try
{ decRewardPoints = decimal.Parse(txtRewardPoints.Text); }
catch
{
javaScript = "window.alert('Please enter a valid Reward Points.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
Products clsProduct = new Products();
clsProduct.UpdateRewardPoints(lngProductGroupID, lngProductSubGroupID, lngProductID, decRewardPoints);
clsProduct.CommitAndDispose();
javaScript = "window.alert('Reward Points has been updated.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
}
protected void cboProductSubGroup_SelectedIndexChanged(object sender, System.EventArgs e)
{
DataClass clsDataClass = new DataClass();
Products clsProduct = new Products();
cboProducts.DataTextField = "ProductCode";
cboProducts.DataValueField = "ProductID";
cboProducts.DataSource = clsProduct.ProductIDandCodeDataTable(ProductListFilterType.ShowActiveAndInactive, txtProductCode.Text.Trim(), 0, Convert.ToInt64(cboProductGroup.SelectedItem.Value), string.Empty, Convert.ToInt64(cboSubGroup.SelectedItem.Value));
cboProducts.DataBind();
cboProducts.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
if (cboProducts.Items.Count > 1 && txtProductCode.Text.Trim() != string.Empty) cboProducts.SelectedIndex = 1; else cboProducts.SelectedIndex = 0;
clsProduct.CommitAndDispose();
cboProducts_SelectedIndexChanged(null, System.EventArgs.Empty);
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
Products clsProduct = new Products();
int intProductBaseUnitID = 0;
decimal decCommision = 0;
try {
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(cboProductCode.SelectedValue));
intProductBaseUnitID = clsDetails.BaseUnitID; decCommision = clsDetails.PercentageCommision;
txtRewardPoints.Text = clsDetails.RewardPoints.ToString("#,##0");
}
catch { }
txtProductCode.ToolTip = intProductBaseUnitID.ToString();
lblProductID.ToolTip = decCommision.ToString();
clsProduct.CommitAndDispose();
}
private bool ZeroOutActualQuantity()
{
bool boRetValue = false;
Products clsProduct = new Products();
boRetValue = clsProduct.ZeroOutActualQuantityByProductGroup(int.Parse(cboBranch.SelectedItem.Value), long.Parse(cboProductGroup.SelectedItem.Value));
clsProduct.CommitAndDispose();
boRetValue = true;
return boRetValue;
}
protected void lstItem_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
Common Common = new Common();
HtmlInputCheckBox chkList = (HtmlInputCheckBox) e.Item.FindControl("chkList");
HyperLink lnkProductCode = (HyperLink)e.Item.FindControl("lnkProductCode");
string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(chkList.Value,Session.SessionID);
switch(e.CommandName)
{
case "imgProductTag":
{
ImageButton imgProductTag = (ImageButton) e.Item.FindControl("imgProductTag");
Products clsProduct = new Products();
if (imgProductTag.ToolTip == "Tag this product as INACTIVE.")
clsProduct.TagInactive(long.Parse(chkList.Value));
else
clsProduct.TagActive(long.Parse(chkList.Value));
clsProduct.CommitAndDispose();
LoadList();
}
break;
case "cmdSaveVariationClick":
{
DropDownList cboVariationType = (DropDownList)e.Item.FindControl("cboVariationType");
SaveVariation(long.Parse(chkList.Value), int.Parse(cboVariationType.SelectedItem.Value), cboVariationType.SelectedItem.Text);
ProductVariations clsVariation = new ProductVariations();
cboVariationType.DataTextField = "VariationType";
cboVariationType.DataValueField = "VariationID";
cboVariationType.DataSource = clsVariation.AvailableVariationsDataTable(long.Parse(chkList.Value), "VariationType", SortOption.Ascending).DefaultView;
cboVariationType.DataBind();
cboVariationType.SelectedIndex = cboVariationType.Items.Count - 1;
clsVariation.CommitAndDispose();
}
break;
case "imgSaveVariationClick":
{
DropDownList cboVariationType = (DropDownList)e.Item.FindControl("cboVariationType");
SaveVariation(long.Parse(chkList.Value), int.Parse(cboVariationType.SelectedItem.Value), cboVariationType.SelectedItem.Text);
ProductVariations clsVariation = new ProductVariations();
cboVariationType.DataTextField = "VariationType";
cboVariationType.DataValueField = "VariationID";
cboVariationType.DataSource = clsVariation.AvailableVariationsDataTable(long.Parse(chkList.Value), "VariationType", SortOption.Ascending).DefaultView;
cboVariationType.DataBind();
cboVariationType.SelectedIndex = cboVariationType.Items.Count - 1;
clsVariation.CommitAndDispose();
}
break;
case "imgVariationsClick":
stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Variations/Default.aspx" + stParam);
break;
case "imgVariationsMatrixClick":
stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx" + stParam);
break;
case "imgUnitsMatrixClick":
stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_UnitsMatrix/Default.aspx" + stParam);
break;
case "imgVariationsAddClick":
stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Variations/Default.aspx" + stParam);
break;
case "imgVariationsMatrixAddClick":
stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx" + stParam);
break;
case "imgUnitsMatrixAddClick":
stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_UnitsMatrix/Default.aspx" + stParam);
break;
case "imgPackageMatrixAddClick":
stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Package/Default.aspx" + stParam);
break;
case "imgInventoryAdjustmentClick":
stParam = "?task=" + Common.Encrypt("invadjustment", Session.SessionID) +
"&productcode=" + Common.Encrypt(Server.UrlEncode(lnkProductCode.Text), Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/Inventory/Default.aspx" + stParam);
break;
case "imgProductHistoryClick":
stParam = "?task=" + Common.Encrypt("producthistory", Session.SessionID) +
"&productcode=" + Common.Encrypt(Server.UrlEncode(lnkProductCode.Text), Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/Reports/Default.aspx" + stParam);
break;
case "imgProductPriceHistoryClick":
stParam = "?task=" + Common.Encrypt("pricehistory", Session.SessionID) +
"&productcode=" + Common.Encrypt(Server.UrlEncode(lnkProductCode.Text), Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/Reports/Default.aspx" + stParam);
break;
case "imgChangePriceClick":
stParam = "?task=" + Common.Encrypt("changeprice", Session.SessionID) +
"&productcode=" + Common.Encrypt(Server.UrlEncode(lnkProductCode.Text), Session.SessionID);
Response.Redirect("Default.aspx" + stParam);
break;
case "imgFinanceClick":
stParam = "?task=" + Common.Encrypt("finance", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/Default.aspx" + stParam);
break;
case "imgEditNowClick":
stParam = "?task=" + Common.Encrypt("edit", Session.SessionID) + "&id=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect("Default.aspx" + stParam);
break;
}
}
private void LockUnlockForSelling(string UnLock = "")
{
bool isLock = false;
if (UnLock == "Unlock")
{
isLock = false;
}
else if (cmdLockUnlockProduct.ToolTip == "unlock")
{
isLock = true;
}
Products clsProducts = new Products();
clsProducts.LockUnlockForSellingByProductGroup(int.Parse(cboBranch.SelectedItem.Value), long.Parse(cboProductGroup.SelectedItem.Value), isLock);
clsProducts.CommitAndDispose();
if (!isLock)
{
cmdLockUnlockProduct.Text = "Lock Product Group [<label class='ms-error'>Note:</label>Products under this group are <u>CURRENTLY ALLOWED</u> for Selling]";
cmdLockUnlockProduct.ToolTip = "unlock";
}
else
{
cmdLockUnlockProduct.Text = "UnLock Product Group [<label class='ms-error'>Note:</label>Products under this group are <u>CURRENTLY NOT ALLOWED</u> for Selling]";
cmdLockUnlockProduct.ToolTip = "lock";
}
}
private void LoadList()
{
string SortField = "ProductDesc";
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); }
ProductListFilterType clsProductListFilterType = ProductListFilterType.ShowActiveOnly;
if (rdoShowInactiveOnly.Checked == true) clsProductListFilterType = ProductListFilterType.ShowInactiveOnly;
if (rdoShowActiveOnly.Checked == true) clsProductListFilterType = ProductListFilterType.ShowActiveOnly;
if (rdoShowAll.Checked == true) clsProductListFilterType = ProductListFilterType.ShowActiveAndInactive;
int intLimit = 0;
try { intLimit = int.Parse(txtLimit.Text); }
catch { }
string SearchKey = string.Empty;
if (Request.QueryString["Search"] != null)
{ SearchKey = Server.UrlDecode(Common.Decrypt((string)Request.QueryString["search"], Session.SessionID)); }
else if (Session["Search"] != null)
{ SearchKey = Server.UrlDecode(Common.Decrypt(Session["Search"].ToString(), Session.SessionID)); }
try { Session.Remove("Search"); } catch { }
if (SearchKey == null) { SearchKey = string.Empty; }
else if (SearchKey != string.Empty) { Session.Add("Search", Common.Encrypt(SearchKey, Session.SessionID)); }
Data.ProductDetails clsSearchKeys = new Data.ProductDetails();
clsSearchKeys.BarCode = SearchKey;
clsSearchKeys.BarCode2 = SearchKey;
clsSearchKeys.BarCode3 = SearchKey;
clsSearchKeys.ProductCode = SearchKey;
ProductAddOnFilters clsProductAddOnFilters = new ProductAddOnFilters();
clsProductAddOnFilters.BarcodeFrom = txtBarcodeFrom.Text;
clsProductAddOnFilters.BarcodeTo = txtBarcodeTo.Text;
clsProductAddOnFilters.ProductCodeFrom = txtProductCodeFrom.Text;
clsProductAddOnFilters.ProductCodeTo = txtProductCodeTo.Text;
clsProductAddOnFilters.ProductSubGroupNameFrom = txtProductSubGroupNameFrom.Text;
clsProductAddOnFilters.ProductSubGroupNameTo = txtProductSubGroupNameTo.Text;
clsProductAddOnFilters.ProductGroupNameFrom = txtProductGroupnameFrom.Text;
clsProductAddOnFilters.ProductGroupNameTo = txtProductGroupNameTo.Text;
clsProductAddOnFilters.SupplierNameFrom = txtSupplierNameFrom.Text;
clsProductAddOnFilters.SupplierNameTo = txtSupplierNameTo.Text;
Products clsProduct = new Products();
System.Data.DataTable dt = clsProduct.ListAsDataTable(clsSearchKeys: clsSearchKeys, ProductAddOnFilters: clsProductAddOnFilters, clsProductListFilterType: clsProductListFilterType, limit: 100, SortField: SortField, SortOrder: SortOption.Ascending);
clsProduct.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;
}
private void LoadItemData()
{
try
{
string strGroupCode = string.Empty;
ListView.SelectedListViewItemCollection items = this.lstGroup.SelectedItems;
foreach (ListViewItem item in items)
{ strGroupCode = item.SubItems[0].Name; break; }
if (strGroupCode != string.Empty)
{
Products clsProduct = new Products();
System.Data.DataTable dt;
if (mboShowInActiveProducts == false)
{ dt = clsProduct.SearchSaleableDataTableByGroup(strGroupCode, string.Empty, "ProductCode", SortOption.Ascending, 0, mboShowItemMoreThanZeroQty); }
else
{ dt = clsProduct.SearchDataTableActiveInactive(ProductListFilterType.ShowInactiveOnly, strGroupCode, "ProductCode", SortOption.Ascending, 0, mboShowItemMoreThanZeroQty); }
clsProduct.CommitAndDispose();
lstItems.Items.Clear(); int iImgCtr = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (mboIsPriceInq)
lstItems.Items.Add(dr["Barcode"].ToString(), "[" + dr["Price"].ToString() + "]" + Environment.NewLine + dr["ProductCode"].ToString(), iImgCtr);
else
lstItems.Items.Add(dr["Barcode"].ToString(), dr["ProductCode"].ToString(), iImgCtr);
if (iImgCtr == 7) iImgCtr = 0; else iImgCtr++;
}
try { lstItems.Items[0].Selected = true; }
catch { }
}
}
catch (IndexOutOfRangeException){}
catch (Exception ex)
{
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
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)
{
Products clsProduct = new Products();
clsProduct.Delete( stIDs.Substring(0,stIDs.Length-1), Convert.ToString(Session["Name"]));
clsProduct.CommitAndDispose();
Security.AuditTrailDetails clsAuditDetails = new Security.AuditTrailDetails();
clsAuditDetails.ActivityDate = DateTime.Now;
clsAuditDetails.User = Convert.ToString(Session["Name"]);
clsAuditDetails.IPAddress = Request.UserHostAddress;
clsAuditDetails.Activity = "Products";
clsAuditDetails.Remarks = "Delete Product(s). IDs:'" + stIDs + "'";
Security.AuditTrail clsAuditTrail = new Security.AuditTrail();
clsAuditTrail.Insert(clsAuditDetails);
clsAuditTrail.CommitAndDispose();
}
return boRetValue;
}