private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
ChartOfAccounts clsChartOfAccount = new ChartOfAccounts();
System.Data.DataTable dtList = clsDataClass.DataReaderToDataTable(clsChartOfAccount.List("ChartOfAccountName", SortOption.Ascending));
ProductGroup clsProductGroup = new ProductGroup(clsChartOfAccount.Connection, clsChartOfAccount.Transaction);
System.Data.DataTable dtProductGroup = clsProductGroup.ListAsDataTable(SortField:"ProductGroupName");
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroup clsSubGroup = new ProductSubGroup(clsChartOfAccount.Connection, clsChartOfAccount.Transaction);
System.Data.DataTable dtProductSubGroup = clsSubGroup.ListAsDataTable(clsProductSubGroupColumns, SortField: "ProductSubGroupName", SortOrder: System.Data.SqlClient.SortOrder.Ascending);
Products clsProduct = new Products(clsChartOfAccount.Connection, clsChartOfAccount.Transaction);
System.Data.DataTable dtProduct = clsProduct.ListAsDataTable("ProductID", SortOption.Ascending);
clsChartOfAccount.CommitAndDispose();
cboProductGroup.DataTextField = "ProductGroupName";
cboProductGroup.DataValueField = "ProductGroupID";
cboProductGroup.DataSource = dtProductGroup.DefaultView;
cboProductGroup.DataBind();
cboProductGroup.Items.Add(new ListItem("Apply to all Product Groups", "0"));
cboProductGroup.SelectedIndex = cboProductGroup.Items.Count - 1;
cboProductSubGroup.DataTextField = "ProductSubGroupName";
cboProductSubGroup.DataValueField = "ProductSubGroupID";
cboProductSubGroup.DataSource = dtProductSubGroup.DefaultView;
cboProductSubGroup.DataBind();
cboProductSubGroup.Items.Add(new ListItem("Do not Apply to Product Sub Groups", "-1"));
cboProductSubGroup.Items.Add(new ListItem("Apply to all Product Sub Groups", "0"));
cboProductSubGroup.SelectedIndex = cboProductSubGroup.Items.Count - 1;
cboProduct.DataTextField = "ProductCode";
cboProduct.DataValueField = "ProductID";
cboProduct.DataSource = dtProduct.DefaultView;
cboProduct.DataBind();
cboProduct.Items.Add(new ListItem("Do not Apply to Products", "-1"));
cboProduct.Items.Add(new ListItem("Apply to all Products", "0"));
cboProduct.SelectedIndex = cboProduct.Items.Count - 1;
cboChartOfAccountPurchase.DataTextField = "ChartOfAccountNameComplete";
cboChartOfAccountPurchase.DataValueField = "ChartOfAccountID";
cboChartOfAccountPurchase.DataSource = dtList.DefaultView;
cboChartOfAccountPurchase.DataBind();
cboChartOfAccountPurchase.Items.Add(new ListItem("Not Applicable", "0"));
cboChartOfAccountPurchase.SelectedIndex = cboChartOfAccountPurchase.Items.Count - 1;
cboChartOfAccountSold.DataTextField = "ChartOfAccountNameComplete";
cboChartOfAccountSold.DataValueField = "ChartOfAccountID";
cboChartOfAccountSold.DataSource = dtList.DefaultView;
cboChartOfAccountSold.DataBind();
cboChartOfAccountSold.Items.Add(new ListItem("Not Applicable", "0"));
cboChartOfAccountSold.SelectedIndex = cboChartOfAccountSold.Items.Count - 1;
cboChartOfAccountInventory.DataTextField = "ChartOfAccountNameComplete";
cboChartOfAccountInventory.DataValueField = "ChartOfAccountID";
cboChartOfAccountInventory.DataSource = dtList.DefaultView;
cboChartOfAccountInventory.DataBind();
cboChartOfAccountInventory.Items.Add(new ListItem("Not Applicable", "0"));
cboChartOfAccountInventory.SelectedIndex = cboChartOfAccountInventory.Items.Count - 1;
cboChartOfAccountIDTaxPurchase.DataTextField = "ChartOfAccountNameComplete";
cboChartOfAccountIDTaxPurchase.DataValueField = "ChartOfAccountID";
cboChartOfAccountIDTaxPurchase.DataSource = dtList.DefaultView;
cboChartOfAccountIDTaxPurchase.DataBind();
cboChartOfAccountIDTaxPurchase.Items.Add(new ListItem("Not Applicable", "0"));
cboChartOfAccountIDTaxPurchase.SelectedIndex = cboChartOfAccountIDTaxPurchase.Items.Count - 1;
cboChartOfAccountIDTaxSold.DataTextField = "ChartOfAccountNameComplete";
cboChartOfAccountIDTaxSold.DataValueField = "ChartOfAccountID";
cboChartOfAccountIDTaxSold.DataSource = dtList.DefaultView;
cboChartOfAccountIDTaxSold.DataBind();
cboChartOfAccountIDTaxSold.Items.Add(new ListItem("Not Applicable", "0"));
cboChartOfAccountIDTaxSold.SelectedIndex = cboChartOfAccountIDTaxSold.Items.Count - 1;
}
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 LoadProducts(System.Data.SqlClient.SortOrder SequenceSortOrder)
{
try
{
tblLayoutProducts.Controls.Clear();
if (mboLocked) return;
Int64 intSequenceNoStart = 0;
if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
try { intSequenceNoStart = long.Parse(cmdProductLeft.Tag.ToString()); }
catch { }
else
try { intSequenceNoStart = long.Parse(cmdProductRight.Tag.ToString()); }
catch { }
// Sep 24, 2014 put an override if cmdSubGroupLeft.Tag = 0
// always do an asceding coz its already the end.
if (intSequenceNoStart < Constants.C_RESTOPLUS_MAX_PRODUCTS) intSequenceNoStart = 0; //reset to 0 if it's 1
if (intSequenceNoStart == 0) SequenceSortOrder = System.Data.SqlClient.SortOrder.Ascending;
//if (tblLayoutProducts.Controls.Count <= Constants.C_RESTOPLUS_MAX_PRODUCTS) { intSequenceNoStart -= 1; SequenceSortOrder = System.Data.SqlClient.SortOrder.Ascending; }
ProductColumns clsProductColumns = new ProductColumns();
clsProductColumns.BarCode = true;
clsProductColumns.ProductCode = true;
clsProductColumns.SequenceNo = true;
ProductColumns clsSearchColumns = new ProductColumns();
long lngProductSubGroupID = 0;
try { lngProductSubGroupID = long.Parse(lblItems.Tag.ToString()); }
catch { }
Products clsProduct = new Products(mConnection, mTransaction);
// always put the branchid as zero so that it will show all products
System.Data.DataTable dtProduct = clsProduct.ListAsDataTable(clsProductColumns, 0, ProductListFilterType.ShowActiveOnly, intSequenceNoStart, SequenceSortOrder,
clsSearchColumns, string.Empty, Constants.ZERO, Constants.ZERO, string.Empty, lngProductSubGroupID, string.Empty, SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending ? Constants.C_RESTOPLUS_MAX_PRODUCTS : Constants.C_RESTOPLUS_MAX_PRODUCTS + 1, mclsTerminalDetails.ShowItemMoreThanZeroQty, true, "SequenceNo", SequenceSortOrder == System.Data.SqlClient.SortOrder.Ascending ? SortOption.Ascending : SortOption.Desscending);
//System.Data.DataTable dtProduct = clsProduct.ListAsDataTableFE(Constants.BRANCH_ID_MAIN, string.Empty, ProductListFilterType.ShowActiveOnly, Constants.C_RESTOPLUS_MAX_PRODUCTS + 1, false, "SequenceNo", System.Data.SqlClient.SortOrder.Ascending);
clsProduct.CommitAndDispose();
// re-order the products by sequcen no
if (dtProduct.Rows.Count > 0)
{
System.Data.DataView dv = dtProduct.DefaultView;
dv.Sort = "SequenceNo";
dtProduct = dv.ToTable();
}
int iRow = 0;
int iCol = 0;
int iCtr = 1;
if (dtProduct.Rows.Count == 0)
{
cmdProductLeft.Tag = "0".ToString(); // reset the sequenceno to 0 if no record
cmdProductRight.Tag = "0".ToString(); // reset the sequenceno to 0 if no record
}
foreach (System.Data.DataRow dr in dtProduct.Rows)
{
if (iCtr > Constants.C_RESTOPLUS_MAX_PRODUCTS) break;
if (iCtr == 1) cmdProductLeft.Tag = dr[Data.ProductColumnNames.SequenceNo].ToString();
if (iCtr >= 1 && dtProduct.Rows.Count > Constants.C_RESTOPLUS_MAX_PRODUCTS) cmdProductRight.Tag = dr[Data.ProductColumnNames.SequenceNo].ToString();
//if (iCtr == Constants.C_RESTOPLUS_MAX_PRODUCTS && dtProduct.Rows.Count > Constants.C_RESTOPLUS_MAX_PRODUCTS)
//{
// if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
// try { if (iCtr == 1) cmdProductLeft.Tag = dr[Data.ProductColumnNames.SequenceNo].ToString(); }
// catch { }
// else
// try { cmdProductRight.Tag = dr[Data.ProductColumnNames.SequenceNo].ToString(); }
// catch { }
//}
//else if (dtProduct.Rows.Count > 0 && dtProduct.Rows.Count <= Constants.C_RESTOPLUS_MAX_PRODUCTS)
//{
// if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
// {
// try {
// if (Int32.Parse(cmdProductRight.Tag.ToString()) < Int32.Parse(dr[Data.ProductColumnNames.SequenceNo].ToString()))
// cmdProductRight.Tag = dr[Data.ProductColumnNames.SequenceNo].ToString();
// }
// catch { }
// cmdProductLeft.Tag = "0".ToString();
// }
// else
// {
// try { if (iCtr == 1) cmdProductLeft.Tag = dr[Data.ProductColumnNames.SequenceNo].ToString(); }
// catch { }
// // cmdProductRight.Tag = cmdProductRight.Tag; // do not reset
// }
//}
ProductButton cmdProduct = new ProductButton();
cmdProduct.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
cmdProduct.BackColor = System.Drawing.Color.WhiteSmoke;
cmdProduct.Dock = System.Windows.Forms.DockStyle.Fill;
cmdProduct.FlatAppearance.BorderColor = System.Drawing.Color.Gold;
cmdProduct.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
cmdProduct.ForeColor = System.Drawing.SystemColors.ControlText;
cmdProduct.GradientBottom = System.Drawing.Color.DarkGray;
cmdProduct.GradientTop = System.Drawing.Color.WhiteSmoke;
cmdProduct.ImageAlign = System.Drawing.ContentAlignment.TopCenter;
cmdProduct.Location = new System.Drawing.Point(3, 3);
cmdProduct.Size = new System.Drawing.Size(115, 89);
cmdProduct.TabIndex = iCtr - 1;
cmdProduct.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
cmdProduct.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
cmdProduct.UseVisualStyleBackColor = false;
cmdProduct.Name = "cmdProduct" + iCtr.ToString();
string strProductCode = dr[Data.ProductColumnNames.ProductCode].ToString();
if (strProductCode.Length > 12)
{
//string strTempProductCode = "";
string[] strCodes = strProductCode.Split(' ');
int ixCtr = 0;
foreach (string strCode in strCodes)
{
if (ixCtr == 0)
cmdProduct.Text = strCode;
else
cmdProduct.Text += "\r\n" + strCode;
ixCtr++;
//if ((strTempProductCode.Length + strCode.Length) < 12)
//{
// strTempProductCode += (strTempProductCode.Length == 0) ? strCode : " " + strCode;
//}
//else
//{
// cmdProduct.Text += (cmdProduct.Text.Length == 0) ? strTempProductCode : "\r\n" + strTempProductCode;
// strTempProductCode = strCode;
//}
//if ((strProductCode.LastIndexOf(strCode) + strCode.Length) == strProductCode.Length) //mean this is the last
// cmdProduct.Text += "\r\n" + strTempProductCode;
}
}
else {
cmdProduct.Text = strProductCode;
}
cmdProduct.Tag = dr[Data.ProductColumnNames.BarCode].ToString();
cmdProduct.Click += new System.EventHandler(cmdProduct_Click);
tblLayoutProducts.Controls.Add(cmdProduct, iCol, iRow);
iCol++; iCtr++;
}
}
catch { }
}
