private void LoadOptions()
{
ProductGroup clsProductGroup = new ProductGroup();
cboGroup.DataTextField = "ProductGroupName";
cboGroup.DataValueField = "ProductGroupID";
cboGroup.DataSource = clsProductGroup.ListAsDataTable();
cboGroup.DataBind();
cboGroup.Items.Insert(0, new ListItem(Constants.ALL,Constants.ZERO_STRING));
cboGroup.SelectedIndex = 0;
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroup clsSubGroup = new ProductSubGroup(clsProductGroup.Connection, clsProductGroup.Transaction);
cboSubGroup.DataTextField = "ProductSubGroupName";
cboSubGroup.DataValueField = "ProductSubGroupID";
cboSubGroup.DataSource = clsSubGroup.ListAsDataTable(clsProductSubGroupColumns, SortField: "ProductSubGroupName", SortOrder: System.Data.SqlClient.SortOrder.Ascending);
cboSubGroup.DataBind();
cboSubGroup.Items.Insert(0, new ListItem(Constants.ALL,Constants.ZERO_STRING));
cboSubGroup.SelectedIndex = 0;
Contacts clsContact = new Contacts(clsProductGroup.Connection, clsProductGroup.Transaction);
cboSupplier.DataTextField = "ContactName";
cboSupplier.DataValueField = "ContactID";
cboSupplier.DataSource = clsContact.SuppliersAsDataTable(string.Empty, 0, "ContactName", SortOption.Ascending);
cboSupplier.DataBind();
cboSupplier.Items.Add(new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboSupplier.SelectedIndex = cboSupplier.Items.Count - 1;
clsProductGroup.CommitAndDispose();
txtStartTransactionDate.Text = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
txtEndTransactionDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
private void LoadOptions()
{
ProductGroup clsProductGroup = new ProductGroup();
cboGroup.DataTextField = "ProductGroupName";
cboGroup.DataValueField = "ProductGroupID";
cboGroup.DataSource = clsProductGroup.ListAsDataTable();
cboGroup.DataBind();
cboGroup.Items.Insert(0, new ListItem(Constants.ALL,Constants.ZERO_STRING));
cboGroup.SelectedIndex = 0;
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroup clsSubGroup = new ProductSubGroup(clsProductGroup.Connection, clsProductGroup.Transaction);
cboSubGroup.DataTextField = "ProductSubGroupName";
cboSubGroup.DataValueField = "ProductSubGroupID";
cboSubGroup.DataSource = clsSubGroup.ListAsDataTable(clsProductSubGroupColumns, SortField: "ProductSubGroupName", SortOrder: System.Data.SqlClient.SortOrder.Ascending);
cboSubGroup.DataBind();
cboSubGroup.Items.Insert(0, new ListItem(Constants.ALL,Constants.ZERO_STRING));
cboSubGroup.SelectedIndex = 0;
clsProductGroup.CommitAndDispose();
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
if (Visible)
{
Branch clsBranch = new Branch();
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable().DefaultView;
cboBranch.DataBind();
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(cboBranch.Items.FindByValue(Constants.BRANCH_ID_MAIN.ToString()));
mlngItemNo = 0;
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroupDetails clsSearchKey = new ProductSubGroupDetails() { ProductSubGroupName = txtProductSubGroup.Text };
ProductSubGroup clsProductSubGroup = new ProductSubGroup(clsBranch.Connection, clsBranch.Transaction);
cboProductSubGroup.DataTextField = "ProductSubGroupName";
cboProductSubGroup.DataValueField = "ProductSubGroupID";
cboProductSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKey, SortField: "ProductSubGroupName").DefaultView;
cboProductSubGroup.DataBind();
cboProductSubGroup.SelectedIndex = 0;
clsBranch.CommitAndDispose();
txtClosingDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
ManageSecurity();
LoadList();
cmdZeroOutActualQuantity.Attributes.Add("onClick", "return confirm_zeroout_inventory();");
imgZeroOutActualQuantity.Attributes.Add("onClick", "return confirm_zeroout_inventory();");
cmdCopyPOSToActual.Attributes.Add("onClick", "return confirm_copypostoactual_inventory();");
imgCopyPOSToActual.Attributes.Add("onClick", "return confirm_copypostoactual_inventory();");
//cmdCloseInventory.Attributes.Add("onClick", "return confirm_close_inventory();");
//imgCloseInventory.Attributes.Add("onClick", "return confirm_close_inventory();");
}
}
protected void cboProductGroup_SelectedIndexChanged(object sender, System.EventArgs e)
{
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns();
clsProductSubGroupColumns.ProductSubGroupCode = true;
clsProductSubGroupColumns.ProductSubGroupName = true;
ProductSubGroupDetails clsSearchKeys = new ProductSubGroupDetails();
clsSearchKeys.ProductGroupID = long.Parse(cboProductGroup.SelectedItem.Value);
clsSearchKeys.ProductSubGroupCode = txtSubGroupCode.Text;
ProductSubGroup clsSubGroup = new ProductSubGroup();
cboSubGroup.DataTextField = "ProductSubGroupName";
cboSubGroup.DataValueField = "ProductSubGroupID";
cboSubGroup.DataSource = clsSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKeys, 0);
cboSubGroup.DataBind();
cboSubGroup.Items.Insert(0, new ListItem(Constants.ALL,Constants.ZERO_STRING));
if (cboSubGroup.Items.Count > 1 && txtSubGroupCode.Text.Trim() != string.Empty) cboSubGroup.SelectedIndex = 1; else cboSubGroup.SelectedIndex = 0;
clsSubGroup.CommitAndDispose();
cboProductSubGroup_SelectedIndexChanged(null, System.EventArgs.Empty);
}
private void LoadList()
{
string SortField = "SequenceNo ASC, ProductSubGroupCode";
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); }
string SearchKey = string.Empty;
if (Request.QueryString["Search"] != null)
{ SearchKey = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID); }
else if (Session["Search"] != null)
{ SearchKey = 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)); }
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsAll = true };
ProductSubGroupDetails clsSearchKeys = new ProductSubGroupDetails();
clsSearchKeys.ProductGroupDetails = new ProductGroupDetails() { ProductGroupCode = SearchKey, ProductGroupName = SearchKey };
clsSearchKeys.ProductSubGroupCode = SearchKey;
clsSearchKeys.ProductSubGroupName = SearchKey;
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
System.Data.DataTable dt = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKeys, SortField: SortField, SortOrder: (sortoption == SortOption.Ascending ? System.Data.SqlClient.SortOrder.Ascending : System.Data.SqlClient.SortOrder.Descending));
clsProductSubGroup.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;
}
public System.Data.DataTable ListAsDataTable(ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns(), ProductSubGroupDetails clsSearchKey = new ProductSubGroupDetails(), long SequenceNoStart = 0, System.Data.SqlClient.SortOrder SequenceSortOrder = System.Data.SqlClient.SortOrder.Ascending, string SortField = "SequenceNo", System.Data.SqlClient.SortOrder SortOrder = System.Data.SqlClient.SortOrder.Ascending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect(clsProductSubGroupColumns) + "WHERE 1=1 ";
if (SequenceNoStart != 0)
{
if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
SQL += "AND SequenceNo < " + SequenceNoStart.ToString() + " ";
else
SQL += "AND SequenceNo > " + SequenceNoStart.ToString() + " ";
}
if (clsSearchKey.ProductGroupID != 0)
{
SQL += "AND tblProductSubGroup.ProductGroupID = @ProductGroupID ";
cmd.Parameters.AddWithValue("@ProductGroupID", clsSearchKey.ProductGroupID);
}
else if (clsSearchKey.ProductGroupDetails.ProductGroupID != 0)
{
SQL += "AND tblProductSubGroup.ProductGroupID = @ProductGroupID ";
cmd.Parameters.AddWithValue("@ProductGroupID", clsSearchKey.ProductGroupDetails.ProductGroupID);
}
if (clsSearchKey.ProductSubGroupID != 0)
{
SQL += "AND tblProductSubGroup.ProductSubGroupID = @ProductSubGroupID ";
cmd.Parameters.AddWithValue("@ProductSubGroupID", clsSearchKey.ProductSubGroupID);
}
if (!string.IsNullOrEmpty(clsSearchKey.ProductGroupDetails.ProductGroupCode)
&& !string.IsNullOrEmpty(clsSearchKey.ProductGroupDetails.ProductGroupName)
&& !string.IsNullOrEmpty(clsSearchKey.ProductSubGroupCode)
&& !string.IsNullOrEmpty(clsSearchKey.ProductSubGroupName))
{
SQL += "AND (tblProductGroup.ProductGroupCode LIKE @ProductGroupCode OR tblProductGroup.ProductGroupName LIKE @ProductGroupName OR tblProductSubGroup.ProductSubGroupCode LIKE @ProductSubGroupCode OR tblProductSubGroup.ProductSubGroupName LIKE @ProductSubGroupName) ";
cmd.Parameters.AddWithValue("@ProductGroupCode", clsSearchKey.ProductGroupDetails.ProductGroupCode + "%");
cmd.Parameters.AddWithValue("@ProductGroupName", clsSearchKey.ProductGroupDetails.ProductGroupName + "%");
cmd.Parameters.AddWithValue("@ProductSubGroupCode", clsSearchKey.ProductSubGroupCode + "%");
cmd.Parameters.AddWithValue("@ProductSubGroupName", clsSearchKey.ProductSubGroupName + "%");
}
else if (!string.IsNullOrEmpty(clsSearchKey.ProductSubGroupCode) && !string.IsNullOrEmpty(clsSearchKey.ProductSubGroupName))
{
SQL += "AND (tblProductSubGroup.ProductSubGroupCode LIKE @ProductSubGroupCode OR tblProductSubGroup.ProductSubGroupName LIKE @SearchKey) ";
cmd.Parameters.AddWithValue("@ProductSubGroupCode", clsSearchKey.ProductSubGroupCode + "%");
cmd.Parameters.AddWithValue("@ProductSubGroupName", clsSearchKey.ProductSubGroupName + "%");
}
else if (!string.IsNullOrEmpty(clsSearchKey.ProductSubGroupCode))
{
SQL += "AND tblProductSubGroup.ProductSubGroupCode LIKE @ProductSubGroupCode ";
cmd.Parameters.AddWithValue("@ProductSubGroupCode", clsSearchKey.ProductSubGroupCode + "%");
}
else if (!string.IsNullOrEmpty(clsSearchKey.ProductSubGroupCode))
{
SQL += "AND tblProductSubGroup.ProductSubGroupName LIKE @ProductSubGroupName ";
cmd.Parameters.AddWithValue("@ProductSubGroupName", clsSearchKey.ProductSubGroupName + "%");
}
SQL += string.IsNullOrEmpty(SortField) ? "ORDER BY SequenceNo, ProductSubGroupName " : "ORDER BY " + SortField + " ";
SQL += SortOrder == System.Data.SqlClient.SortOrder.Ascending ? "ASC " : "DESC ";
SQL += limit == 0 ? "" : " LIMIT " + limit.ToString();
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private string SQLSelect(ProductSubGroupColumns clsColumns)
{
if (clsColumns.ColumnsAll)
{
object boxed = clsColumns; // needs to unboxed so that the value will be assigned, otherwise it won't work
System.Reflection.FieldInfo[] fi = clsColumns.GetType().GetFields();
foreach (System.Reflection.FieldInfo info1 in fi)
{
info1.SetValue(boxed, true);
}
clsColumns = (ProductSubGroupColumns) boxed; // boxed so that the value will be assigned, otherwise it won't work
}
else if (clsColumns.ColumnsNameID)
{
clsColumns.ProductSubGroupID = true;
clsColumns.ProductSubGroupName = true;
}
else if (clsColumns.ColumnsCodeNameID)
{
clsColumns.ProductSubGroupID = true;
clsColumns.ProductSubGroupCode = true;
clsColumns.ProductSubGroupName = true;
}
string stSQL = "SELECT ";
if (clsColumns.ProductGroupID) stSQL += "tblProductGroup.ProductGroupID, ";
if (clsColumns.ProductGroupCode) stSQL += "tblProductGroup.ProductGroupCode, ";
if (clsColumns.ProductGroupName) stSQL += "tblProductGroup.ProductGroupName, ";
if (clsColumns.ProductSubGroupCode) stSQL += "tblProductSubGroup.ProductSubGroupCode, ";
if (clsColumns.ProductSubGroupName) stSQL += "tblProductSubGroup.ProductSubGroupName, ";
if (clsColumns.BaseUnitID) stSQL += "tblProductSubGroup.BaseUnitID, ";
if (clsColumns.BaseUnitName) stSQL += "tblUnit.UnitName 'BaseUnitName', ";
if (clsColumns.Price) stSQL += "tblProductSubGroup.Price, ";
if (clsColumns.PurchasePrice) stSQL += "tblProductSubGroup.PurchasePrice, ";
if (clsColumns.IncludeInSubtotalDiscount) stSQL += "tblProductSubGroup.IncludeInSubtotalDiscount, ";
if (clsColumns.VAT) stSQL += "tblProductSubGroup.VAT, ";
if (clsColumns.EVAT) stSQL += "tblProductSubGroup.EVAT, ";
if (clsColumns.LocalTax) stSQL += "tblProductSubGroup.LocalTax, ";
if (clsColumns.ChartOfAccountIDPurchase) stSQL += "tblProductSubGroup.ChartOfAccountIDPurchase, ";
if (clsColumns.ChartOfAccountIDSold) stSQL += "tblProductSubGroup.ChartOfAccountIDSold, ";
if (clsColumns.ChartOfAccountIDInventory) stSQL += "tblProductSubGroup.ChartOfAccountIDInventory, ";
if (clsColumns.ChartOfAccountIDTaxPurchase) stSQL += "tblProductSubGroup.ChartOfAccountIDTaxPurchase, ";
if (clsColumns.ChartOfAccountIDTaxSold) stSQL += "tblProductSubGroup.ChartOfAccountIDTaxSold, ";
if (clsColumns.SequenceNo) stSQL += "tblProductSubGroup.SequenceNo, ";
if (clsColumns.SequenceNo) stSQL += "tblProductSubGroup.ImagePath, ";
stSQL += "tblProductSubGroup.ProductSubGroupID ";
stSQL += "FROM tblProductSubGroup ";
if (clsColumns.ProductGroupCode || clsColumns.ProductGroupName)
stSQL += "INNER JOIN tblProductGroup ON tblProductSubGroup.ProductGroupID = tblProductGroup.ProductGroupID ";
if (clsColumns.BaseUnitName)
stSQL += "INNER JOIN tblUnit ON tblProductSubGroup.BaseUnitID = tblUnit.UnitID ";
return stSQL;
}
private void LoadSubGroup()
{
ProductSubGroupDetails clsSearchKeys = new ProductSubGroupDetails();
clsSearchKeys.ProductSubGroupCode = txtProductSubGroup.Text;
clsSearchKeys.ProductGroupID = long.Parse(cboProductGroup.SelectedItem.Value);
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
cboProductSubGroup.DataTextField = "ProductSubGroupName";
cboProductSubGroup.DataValueField = "ProductSubGroupID";
cboProductSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKeys, SortField: "ProductSubGroupName", SortOrder: System.Data.SqlClient.SortOrder.Ascending);
cboProductSubGroup.DataBind();
clsProductSubGroup.CommitAndDispose();
if (cboProductSubGroup.Items.Count == 0) cboProductSubGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboProductSubGroup.SelectedIndex = 0;
}
protected void imgProductSubGroupSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroupDetails clsSearchKey = new ProductSubGroupDetails() { ProductSubGroupName = txtProductSubGroup.Text };
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
cboProductSubGroup.DataTextField = "ProductSubGroupName";
cboProductSubGroup.DataValueField = "ProductSubGroupID";
cboProductSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKey, SortField: "ProductSubGroupName").DefaultView;
cboProductSubGroup.DataBind();
cboProductSubGroup.SelectedIndex = 0;
cboProductSubGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
if (cboProductSubGroup.Items.Count > 1 && txtProductSubGroup.Text.Trim() != string.Empty) cboProductSubGroup.SelectedIndex = 1; else cboProductSubGroup.SelectedIndex = 0;
clsProductSubGroup.CommitAndDispose();
}
private void LoadOptions()
{
txtStartTransactionDate.Text = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
txtEndTransactionDate.Text = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
Contacts clsContact = new Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.SuppliersAsDataTable(Limit: 100).DefaultView;
cboContact.DataBind();
cboContact.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboContact.SelectedIndex = 0;
ProductGroup clsProductGroup = new ProductGroup(clsContact.Connection, clsContact.Transaction);
cboGroup.DataTextField = "ProductGroupName";
cboGroup.DataValueField = "ProductGroupID";
cboGroup.DataSource = clsProductGroup.ListAsDataTable();
cboGroup.DataBind();
cboGroup.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT,Constants.ZERO_STRING));
cboGroup.SelectedIndex = 0;
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroup clsProductSubGroup = new ProductSubGroup(clsContact.Connection, clsContact.Transaction);
cboSubGroup.DataTextField = "ProductSubGroupName";
cboSubGroup.DataValueField = "ProductSubGroupID";
cboSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns);
cboSubGroup.DataBind();
cboSubGroup.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboSubGroup.SelectedIndex = 0;
Data.Inventory clsInventory = new Data.Inventory(clsContact.Connection, clsContact.Transaction);
cboInventoryNo.DataTextField = "ReferenceNo";
cboInventoryNo.DataValueField = "PostingReference";
cboInventoryNo.DataSource = clsInventory.ClosingInventoryReferenceNos(Convert.ToDateTime(txtStartTransactionDate.Text), Convert.ToDateTime(txtEndTransactionDate.Text));
cboInventoryNo.DataBind();
cboInventoryNo.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.PLEASE_SELECT + DateTime.MinValue.ToString("yyyy-MM-dd")));
cboInventoryNo.SelectedIndex = 0;
clsContact.CommitAndDispose();
lblType.Text = ""; lblType.ToolTip = "";
if (Request.QueryString["type"] != null)
{
lblType.Text = Common.Decrypt(Request.QueryString["type"].ToString(), Session.SessionID);
}
if (Request.QueryString["typedet"] != null)
{
lblType.ToolTip = Common.Decrypt(Request.QueryString["typedet"].ToString(), Session.SessionID);
}
lblBranchID.Text = "0";
if (Request.QueryString["branchid"] != null)
{
lblBranchID.Text = Common.Decrypt(Request.QueryString["branchid"].ToString(), Session.SessionID);
}
if (Request.QueryString["refno"] != null)
{
string strRefNo = "refno";
strRefNo = Common.Decrypt(Request.QueryString["refno"].ToString(), Session.SessionID);
cboInventoryNo.SelectedIndex = cboInventoryNo.Items.IndexOf(cboInventoryNo.Items.FindByText(strRefNo));
}
if (Request.QueryString["prdgrpid"] != null)
{
string strPrdGrpID = "prdgrpid";
strPrdGrpID = Common.Decrypt(Request.QueryString["prdgrpid"].ToString(), Session.SessionID);
cboGroup.SelectedIndex = cboGroup.Items.IndexOf(cboGroup.Items.FindByValue(strPrdGrpID));
}
if (Request.QueryString["contactid"] != null)
{
string strContactID = "contactid";
strContactID = Common.Decrypt(Request.QueryString["contactid"].ToString(), Session.SessionID);
cboContact.SelectedIndex = cboContact.Items.IndexOf(cboContact.Items.FindByValue(strContactID));
}
}
protected void cboGroup_SelectedIndexChanged(object sender, EventArgs e)
{
ProductSubGroupDetails clsSearchKeys = new ProductSubGroupDetails();
clsSearchKeys.ProductGroupID = long.Parse(cboGroup.SelectedItem.Value);
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
cboSubGroup.DataTextField = "ProductSubGroupName";
cboSubGroup.DataValueField = "ProductSubGroupID";
cboSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKeys, SortField: "ProductSubGroupName", SortOrder: System.Data.SqlClient.SortOrder.Ascending);
cboSubGroup.DataBind();
if (cboGroup.SelectedItem.Value != Constants.ZERO_STRING)
cboSubGroup.Items.Insert(0, new ListItem(Constants.ALL + " " + cboGroup.SelectedItem.Text, Constants.ZERO_STRING));
else
cboSubGroup.Items.Insert(0, new ListItem(Constants.ALL,Constants.ZERO_STRING));
cboSubGroup.SelectedIndex = 0;
clsProductSubGroup.CommitAndDispose();
}
protected void cboProductGroup_SelectedIndexChanged(object sender, EventArgs e)
{
Int64 intProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
clsProductSubGroup.GetConnection();
ProductGroup clsProductGroup = new ProductGroup(clsProductSubGroup.Connection, clsProductSubGroup.Transaction);
ProductGroupDetails clsDetails;
//System.Data.DataTable dtProductSubGroup;
if (intProductGroupID == 0)
{
clsDetails = clsProductGroup.Details(DataConstants.DEFAULT_PRODUCT_GROUP);
}
else
{
clsDetails = clsProductGroup.Details(intProductGroupID);
}
ProductSubGroupDetails clsSearchKeys = new ProductSubGroupDetails() { ProductGroupID = intProductGroupID };
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroup clsSubGroup = new ProductSubGroup(clsProductGroup.Connection, clsProductGroup.Transaction);
cboProductSubGroup.DataTextField = "ProductSubGroupName";
cboProductSubGroup.DataValueField = "ProductSubGroupID";
cboProductSubGroup.DataSource = clsSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKeys, SortField: "ProductSubGroupName", SortOrder: System.Data.SqlClient.SortOrder.Ascending);
cboProductSubGroup.DataBind();
cboProductSubGroup.Items.Insert(0, new ListItem("Do not Apply to Product Sub Groups", "-1"));
cboProductSubGroup.Items.Insert(1, new ListItem("Apply to all Product Sub Groups", "0"));
cboProductSubGroup.SelectedIndex = cboProductSubGroup.Items.Count - 1;
clsProductSubGroup.CommitAndDispose();
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()
{
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 LoadProductSubGroups(System.Data.SqlClient.SortOrder SequenceSortOrder)
{
try
{
tblLayoutGroup.Controls.Clear();
if (mboLocked) return;
Int64 intSequenceNoStart = 0;
if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
try { intSequenceNoStart = long.Parse(cmdSubGroupLeft.Tag.ToString()); }
catch { }
else
try { intSequenceNoStart = long.Parse(cmdSubGroupRight.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_SUB_GROUP) intSequenceNoStart = 0; //reset to 0 if it's 1
if (intSequenceNoStart == 0) SequenceSortOrder = System.Data.SqlClient.SortOrder.Ascending;
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns();
clsProductSubGroupColumns.ProductSubGroupCode = true;
clsProductSubGroupColumns.SequenceNo = true;
ProductSubGroup clsProductSubGroup = new ProductSubGroup(mConnection, mTransaction);
System.Data.DataTable dtProductSubGroup = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, new ProductSubGroupDetails(), intSequenceNoStart, SequenceSortOrder, "SequenceNo", SequenceSortOrder, SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending ? Constants.C_RESTOPLUS_MAX_SUB_GROUP : Constants.C_RESTOPLUS_MAX_SUB_GROUP + 1);
clsProductSubGroup.CommitAndDispose();
// re-order the products by sequence no
if (dtProductSubGroup.Rows.Count > 0)
{
System.Data.DataView dv = dtProductSubGroup.DefaultView;
dv.Sort = "SequenceNo";
dtProductSubGroup = dv.ToTable();
}
int iRow = 0;
int iCol = 0;
int iCtr = 1;
if (dtProductSubGroup.Rows.Count == 0)
{
cmdSubGroupLeft.Tag = "0".ToString(); // reset the sequenceno to 0 if no record
cmdSubGroupRight.Tag = "0".ToString(); // reset the sequenceno to 0 if no record
}
foreach (System.Data.DataRow dr in dtProductSubGroup.Rows)
{
if (iCtr > Constants.C_RESTOPLUS_MAX_SUB_GROUP) break;
if (iCtr == 1) cmdSubGroupLeft.Tag = dr[Data.ProductSubGroupColumnNames.SequenceNo].ToString();
if (iCtr >= 1 && dtProductSubGroup.Rows.Count > Constants.C_RESTOPLUS_MAX_SUB_GROUP) cmdSubGroupRight.Tag = dr[Data.ProductSubGroupColumnNames.SequenceNo].ToString();
SubGroupButton cmdSubGroup = new SubGroupButton();
cmdSubGroup.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
cmdSubGroup.BackColor = System.Drawing.Color.Red;
cmdSubGroup.Dock = System.Windows.Forms.DockStyle.Fill;
cmdSubGroup.FlatAppearance.BorderColor = System.Drawing.Color.Gold;
cmdSubGroup.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
cmdSubGroup.ForeColor = System.Drawing.SystemColors.ControlText;
cmdSubGroup.GradientBottom = System.Drawing.Color.Red;
cmdSubGroup.GradientTop = System.Drawing.Color.Gold;
cmdSubGroup.ImageAlign = System.Drawing.ContentAlignment.TopCenter;
cmdSubGroup.Location = new System.Drawing.Point(3, 3);
cmdSubGroup.Size = new System.Drawing.Size(110, 82);
cmdSubGroup.TabIndex = iCtr-1;
cmdSubGroup.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
cmdSubGroup.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
cmdSubGroup.UseVisualStyleBackColor = false;
cmdSubGroup.Name = "cmdSubGroup" + iCtr.ToString();
cmdSubGroup.Text = dr[Data.ProductSubGroupColumnNames.ProductSubGroupCode].ToString();
cmdSubGroup.Tag = dr[Data.ProductSubGroupColumnNames.ProductSubGroupID].ToString();
cmdSubGroup.Click += new System.EventHandler(cmdSubGroup_Click);
if (!string.IsNullOrEmpty(dr[Data.ProductSubGroupColumnNames.ImagePath].ToString()))
{
try { cmdSubGroup.Image = new Bitmap(Application.StartupPath + "/images/subgroups/" + dr[Data.ProductSubGroupColumnNames.ImagePath].ToString()); }
catch { }
}
tblLayoutGroup.Controls.Add(cmdSubGroup, iCol, iRow);
iCol++; iCtr++;
}
}
catch { }
}
protected void cboProductGroup_SelectedIndexChanged(object sender, System.EventArgs e)
{
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns() { ColumnsNameID = true };
ProductSubGroupDetails clsSearchKey = new ProductSubGroupDetails() { ProductGroupID = Int64.Parse(cboProductGroup.SelectedItem.Value) } ;
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
cboProductSubGroup.DataTextField = "ProductSubGroupName";
cboProductSubGroup.DataValueField = "ProductSubGroupID";
cboProductSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKey, SortField: "ProductSubGroupName").DefaultView;
cboProductSubGroup.DataBind();
cboProductSubGroup.SelectedIndex = cboProductSubGroup.Items.Count - 1;
clsProductSubGroup.CommitAndDispose();
cboProductSubGroup_SelectedIndexChanged(null, null);
}