Ejemplo n.º 1
0
        /// <summary>
        /// MVC Model Binder for automatically binding the request parameters for a PagedList sort to an instance of
        /// SortOption
        /// </summary>
        /// <param name="controllerContext"></param>
        /// <param name="bindingContext"></param>
        /// <returns></returns>
        /// <example>public ActionResult Index(int? page, [ModelBinder(typeof(PagedListBinder))] SortOption? sort)</example>
        /// <see cref="SortOption"/>
        public object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
        {
            //Does the request contain the minimum parameters for sortng a PagedList?
            if (!String.IsNullOrEmpty((string)controllerContext.HttpContext.Request.Params["Column"]))
            {
                //Yup -
                SortOption sort = new SortOption();
                sort.Column = controllerContext.HttpContext.Request.Params["Column"];

                if (Enum.IsDefined(typeof(SortOrder), controllerContext.HttpContext.Request.Params["Direction"]))
                {
                    Enum.TryParse<SortOrder>(controllerContext.HttpContext.Request.Params["Direction"], out sort.Direction);
                }
                else
                {
                    sort.Direction = SortOrder.ascending;
                }

                return sort;
            }
            else
            {
                //Nothing to bind to
                return null;
            }
        }
Ejemplo n.º 2
0
 public static IEnumerable<string> Files(string directory, string pattern = "*.*", SearchOption searchOption = SearchOption.TopDirectoryOnly, SortOption sortOption = SortOption.Ascending)
 {
     var q = zDirectory.EnumerateFiles(directory, pattern, searchOption);
     if (sortOption == SortOption.Ascending)
         return q;
     else
         return q.OrderByDescending(file => file);
 }
Ejemplo n.º 3
0
        public System.Data.DataTable ListAsDataTable(int BranchID = 0, long ProductID = 0, long MatrixID =0, string BarCode = "", string ProductCode = "", Int64 ProductGroupID = 0, Int64 ProductSubGroupID = 0, Int64 SupplierID = 0, ProductListFilterType clsProductListFilterType = ProductListFilterType.ShowActiveAndInactive,
                bool isQuantityGreaterThanZERO = false, Int32 Limit = 0, Int32 isSummary = 1, string ExpirationDate = Constants.C_DATE_MIN_VALUE_STRING, Int32 ForReorder = 0, Int32 OverStock = 0, string SortField = "", SortOption SortOrder = SortOption.Ascending, bool ShowOnlyWithInvalidUnitMatrix = false)
        {
            try
            {
                DateTime dteExpiration = Constants.C_DATE_MIN_VALUE;

                DateTime.TryParse(ExpirationDate, out dteExpiration);

                string SQL = "CALL procProductInventorySelect(@BranchID, @ProductID, @MatrixID, @BarCode, @ProductCode, @ProductGroupID, @ProductSubGroupID, @SupplierID, @ShowActiveAndInactive, @isQuantityGreaterThanZERO, @lngLimit, @isSummary, @dteExpiration, @ForReorder, @OverStock, @SortField, @SortOrder)";

                // do an override if Only those with invalid unit matrix
                if (ShowOnlyWithInvalidUnitMatrix)
                    SQL = "CALL procProductInventorySelectWithInvalidUnitMatrix(@BranchID, @ProductID, @MatrixID, @BarCode, @ProductCode, @ProductGroupID, @ProductSubGroupID, @SupplierID, @ShowActiveAndInactive, @isQuantityGreaterThanZERO, @lngLimit, @isSummary, @dteExpiration, @ForReorder, @OverStock, @SortField, @SortOrder)";

                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@BranchID", BranchID);
                cmd.Parameters.AddWithValue("@ProductID", ProductID);
                cmd.Parameters.AddWithValue("@MatrixID", MatrixID);
                cmd.Parameters.AddWithValue("@BarCode", BarCode);
                cmd.Parameters.AddWithValue("@ProductCode", ProductCode);
                cmd.Parameters.AddWithValue("@ProductGroupID", ProductGroupID);
                cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
                cmd.Parameters.AddWithValue("@SupplierID", SupplierID);
                cmd.Parameters.AddWithValue("@ShowActiveAndInactive", clsProductListFilterType.ToString("d"));
                cmd.Parameters.AddWithValue("@isQuantityGreaterThanZERO", isQuantityGreaterThanZERO);
                cmd.Parameters.AddWithValue("@lngLimit", Limit);
                cmd.Parameters.AddWithValue("@isSummary", isSummary);
                cmd.Parameters.AddWithValue("@dteExpiration", dteExpiration.ToString("yyyy-MM-dd"));
                cmd.Parameters.AddWithValue("@ForReorder", ForReorder);
                cmd.Parameters.AddWithValue("@OverStock", OverStock);
                cmd.Parameters.AddWithValue("@SortField", SortField);
                switch (SortOrder)
                {
                    case SortOption.Ascending:
                        cmd.Parameters.AddWithValue("@SortOrder", "ASC");
                        break;
                    case SortOption.Desscending:
                        cmd.Parameters.AddWithValue("@SortOrder", "DESC");
                        break;
                }

                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)
            {

                throw;
            }
        }
Ejemplo n.º 4
0
 protected override void Sort(Tab tab, SortOption options)
 {
     if (options["Default"])
     {
         sortJewls(tab, 11);
     }
     if (options["Dynamic"])
     {
         int numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f);
         sortJewls(tab, numberOfColumns);
     }
 }
        private static object Build(SortOption sortOption)
        {
            if (!sortOption.IgnoreUnmapped)
                return sortOption.Ascending
                    ? (object)sortOption.Name
                    : new JObject(new JProperty(sortOption.Name, "desc"));

            var properties = new List<JProperty> { new JProperty("ignore_unmapped", true) };
            if (!sortOption.Ascending)
                properties.Add(new JProperty("order", "desc"));

            return new JObject(new JProperty(sortOption.Name, new JObject(properties)));
        }
Ejemplo n.º 6
0
    protected override void Sort(Tab tab, SortOption options)
    {
        int numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f);

        if (options["Default"])
        {
            numberOfColumns = 11;
            sortMaps(tab, numberOfColumns);
        }
        if (options["Full"])
        {
            numberOfColumns = 12;
            sortMaps(tab, numberOfColumns);
        }
        if (options["1 Margin"])
        {
            if (numberOfColumns <= 11)
                numberOfColumns = 11;
            sortMaps(tab, numberOfColumns);
        }
        if (options["2 Margin"])
        {
            if (numberOfColumns <= 10)
                numberOfColumns = 10;
            sortMaps(tab, numberOfColumns);
        }
        if (options["3 Margin"])
        {
            if (numberOfColumns <= 9)
                numberOfColumns = 9;
            sortMaps(tab, numberOfColumns);
        }
        if (options["Dynamic"])
        {
            numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f);
            sortMaps(tab, numberOfColumns);
        }
        if (options["Dynamic + 1"])
        {
            numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f) + 1;
            numberOfColumns = Mathf.Clamp(numberOfColumns, 0, 11);
            sortMaps(tab, numberOfColumns);
        }
        if (options["Dynamic + 2"])
        {
            numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f) + 2;
            numberOfColumns = Mathf.Clamp(numberOfColumns, 0, 11);
            sortMaps(tab, numberOfColumns);
        }

    }
Ejemplo n.º 7
0
    protected override void Sort(Tab tab, SortOption options)
    {
        IEnumerable<Item> gems = tab.Items;

        if (options["Sort by color then type"])
        {
            SortEm(
                gems.Where(x => x.GemRequirement == GemRequirement.Str).OrderByDescending(x => x.GemType).ThenBy(x => x.FullItemName).ThenBy(x => x.Level),
                gems.Where(x => x.GemRequirement == GemRequirement.Dex).OrderByDescending(x => x.GemType).ThenBy(x => x.FullItemName).ThenBy(x => x.Level),
                gems.Where(x => x.GemRequirement == GemRequirement.Int).OrderByDescending(x => x.GemType).ThenBy(x => x.FullItemName).ThenBy(x => x.Level)
            );
        }
        else if (options["Sort by type"])
        {
            SortEm(
                gems.Where(x => x.GemType == GemType.Normal).OrderByDescending(x => x.FullItemName).ThenBy(x => x.LevelRequirement),
                gems.Where(x => x.GemType == GemType.Support).OrderByDescending(x => x.FullItemName).ThenBy(x => x.LevelRequirement),
                gems.Where(x => x.GemType == GemType.Aura).OrderByDescending(x => x.FullItemName).ThenBy(x => x.LevelRequirement)
            );
        }
        else if (options["Sort by quality"])
        {
            SortEm(
                gems.Where(x => x.GemRequirement == GemRequirement.Str).OrderByDescending(x => x.Quality).ThenBy(x => x.FullItemName),
                gems.Where(x => x.GemRequirement == GemRequirement.Dex).OrderByDescending(x => x.Quality).ThenBy(x => x.FullItemName),
                gems.Where(x => x.GemRequirement == GemRequirement.Int).OrderByDescending(x => x.Quality).ThenBy(x => x.FullItemName)
            );
        }
        else if (options["Find quality gems"])
        {
            SortEm(
                gems.Where(x => x.Quality == 0).OrderByDescending(x => x.GemRequirement).ThenBy(x => x.GemType).ThenBy(x => x.FullItemName),
                gems.Where(x => x.LevelRequirement > 99999), // No middle
                gems.Where(x => x.Quality > 0).OrderByDescending(x => x.Quality).ThenBy(x => x.FullItemName)
            );
        }
        else if (options["Sort by color then level"])
        {
            SortEm(
                gems.Where(x => x.GemRequirement == GemRequirement.Str).OrderByDescending(x => x.Level).ThenBy(x => x.Quality),
                gems.Where(x => x.GemRequirement == GemRequirement.Dex).OrderByDescending(x => x.GemType).ThenBy(x => x.Quality),
                gems.Where(x => x.GemRequirement == GemRequirement.Int).OrderByDescending(x => x.GemType).ThenBy(x => x.Quality)
            );
        }
        else if (options["Sort by level"])
        {
            SortFromBottom(gems.OrderByDescending(x => x.LevelRequirement));
        }

    }
Ejemplo n.º 8
0
    protected override void Sort(Tab tab, SortOption options)
    {
        int numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f);
        int numberOfItems = tab.Items.Count();

        if (options["Default"])
        {
            numberOfColumns = 12;
        }
        if (options["1 Margin"])
        {
            if (numberOfColumns <= 11)
                numberOfColumns = 11;
        }
        if (options["2 Margin"])
        {
            if (numberOfColumns <= 10)
                numberOfColumns = 10;
        }
        if (options["Dynamic"])
        {
            numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f);
        }

        int x = 11;
        int y = 11;

        int i = 0;
        int lastLevel = 0;
        bool maySkip = true;
        foreach (var item in tab.Items.OrderByDescending(xx => xx.Level).ThenBy(xx => xx.Icon).ThenBy(xx => xx.Quality))
        {
            item.X = x;
            item.Y = y;
            i++;

            x--;
            bool canSkip = (lastLevel != item.Level && (numberOfItems - i) < numberOfColumns * y);
            if (maySkip && lastLevel != item.Level && ((numberOfItems - i) < numberOfColumns * y) == false)
                maySkip = false;

            if (x == 11 - numberOfColumns || canSkip && maySkip)
            {
                x = 11;
                y--;
            }
            lastLevel = item.Level;
        }
    }
Ejemplo n.º 9
0
        public static IEnumerable<TaskModel> GetTasks(SortOption sortOption)
        {
            switch (sortOption)
            {
                case SortOption.Newest:
                    return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderByDescending(t=>t.DateCreated);
                case SortOption.Oldest:
                    return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderBy(t => t.DateCreated);
                case SortOption.TitleAscending:
                    return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderBy(t => t.Task);
                case SortOption.TitleDescending:
                    return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderByDescending(t => t.Task);
            }

            return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderBy(t => t.DateCreated);
        }
Ejemplo n.º 10
0
 public static StatData[] GetCurrentState(SortOption sortOption, int pageNumber, int pageSize)
 {
     var startPosition = pageSize*pageNumber;
     switch (sortOption)
     {
         case SortOption.None:
             return KeywordsDictionary.Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray();
         case SortOption.Keyword:
             return KeywordsDictionary.OrderBy(pair => pair.Key).Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray();
         case SortOption.KeywordDecrease:
             return KeywordsDictionary.OrderByDescending(pair => pair.Key).Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray();
         case SortOption.KeywordCount:
             return KeywordsDictionary.OrderBy(pair => pair.Value).Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray();
         case SortOption.KeywordCountDecrease:
             return KeywordsDictionary.OrderByDescending(pair => pair.Value).Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray();
     }
     return new StatData[0];
 }
Ejemplo n.º 11
0
        public MySqlDataReader List(string SortField, SortOption SortOrder)
        {
            try
            {
                string SQL = SQLSelect() + "WHERE 1=1 ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                    SQL += " ASC";
                else
                    SQL += " DESC";



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;



                return base.ExecuteReader(cmd);
            }
            catch (Exception ex)
            {


                {




                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 12
0
		private MySqlDataReader ListAccessTypes(string SortField, SortOption SortOrder)
		{
			try
			{
				string SQL =	"SELECT		TypeID, TypeName, Remarks " +
								"FROM		sysAccessTypes " + 
								"ORDER BY " + SortField;

				if (SortOrder == SortOption.Ascending)
					SQL += " ASC";
				else
					SQL += " DESC";

				MySqlCommand cmd = new MySqlCommand();
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;
				
				return base.ExecuteReader(cmd);			
			}
			catch (Exception ex)
			{
				throw base.ThrowException(ex);
			}	
		}
Ejemplo n.º 13
0
        public MySqlDataReader Search(CreditMemoItemStatus CreditMemoItemstatus, string SearchKey, string SortField, SortOption SortOrder)
        {
            try
            {
                if (SortField == string.Empty || SortField == null) SortField = "CreditMemoItemID";

                string SQL = SQLSelect() + "WHERE (ProductCode LIKE @SearchKey or BarCode LIKE @SearchKey or Description LIKE @SearchKey " +
                                    "or MatrixDescription LIKE @SearchKey or ProductGroup LIKE @SearchKey or ProductSubGroup LIKE @SearchKey " +
                                    "or Remarks LIKE @SearchKey) " +
                            "ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                    SQL += " ASC";
                else
                    SQL += " DESC";

                

                MySqlCommand cmd = new MySqlCommand();
                
                
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmCreditMemoItemStatus = new MySqlParameter("@ItemStatus",MySqlDbType.Int16);
                prmCreditMemoItemStatus.Value = CreditMemoItemstatus.ToString("d");
                cmd.Parameters.Add(prmCreditMemoItemStatus);

                MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
                prmSearchKey.Value = "%" + SearchKey + "%";
                cmd.Parameters.Add(prmSearchKey);

                MySqlDataReader myReader = base.ExecuteReader(cmd);

                return myReader;
            }
            catch (Exception ex)
            {
                
                
                {
                    
                    
                    
                    
                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 14
0
        public System.Data.DataTable ListAsDataTableSimple(long SequenceNoStart, System.Data.SqlClient.SortOrder SequenceSortOrder, string SortField = "SequenceNo", SortOption SortOrder = SortOption.Ascending)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = SQLSelectSimple() + "WHERE 1=1 ";

                if (SequenceNoStart != 0)
                {
                    if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
                    {
                        SQL += "AND SequenceNo <= " + SequenceNoStart.ToString() + " ";
                    }
                    else
                    {
                        SQL += "AND SequenceNo >= " + SequenceNoStart.ToString() + " ";
                    }
                }

                SQL += "ORDER BY " + SortField + " ";
                SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";

                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);
            }
        }
Ejemplo n.º 15
0
        public System.Data.DataTable ListAsDataTable(long CreditMemoID = 0, string SortField = "CreditMemoItemID", SortOption SortOrder = SortOption.Ascending)
        {
            MySqlCommand cmd = new MySqlCommand();
            string SQL = SQLSelect();

            if (CreditMemoID != 0)
            {
                SQL += "WHERE CreditMemoID = @CreditMemoID ";

                MySqlParameter prmReturnID = new MySqlParameter("@CreditMemoID", MySqlDbType.Int64);
                prmReturnID.Value = CreditMemoID;
                cmd.Parameters.Add(prmReturnID);
            }

            SQL += "ORDER BY " + SortField;
            if (SortOrder == SortOption.Ascending)
                SQL += " ASC";
            else
                SQL += " DESC";

            cmd.CommandType = System.Data.CommandType.Text;
            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;
        }
Ejemplo n.º 16
0
        public static IEnumerable <string> Files(string directory, string pattern = "*.*", SearchOption searchOption = SearchOption.TopDirectoryOnly, SortOption sortOption = SortOption.Ascending)
        {
            var q = zDirectory.EnumerateFiles(directory, pattern, searchOption);

            if (sortOption == SortOption.Ascending)
            {
                return(q);
            }
            else
            {
                return(q.OrderByDescending(file => file));
            }
        }
Ejemplo n.º 17
0
        public MySqlDataReader Search(Int64 GroupID, string SearchKey, string SortField, SortOption SortOrder)
        {
            try
            {
                string SQL = "SELECT MatrixID, " +
                             "GroupID, " +
                             "Description, " +
                             "a.UnitID, " +
                             "UnitName, " +
                             "a.Price, " +
                             "a.PurchasePrice, " +
                             "a.IncludeInSubtotalDiscount, " +
                             "a.VAT, " +
                             "a.EVAT, " +
                             "a.LocalTax " +
                             "FROM tblProductGroupBaseVariationsMatrix a INNER JOIN " +
                             "tblUnit b ON a.UnitID = b.UnitID " +
                             "WHERE GroupID = @GroupID  " +
                             "AND Description LIKE @SearchKey " +
                             "ORDER BY MatrixID, " + SortField;

                if (SortOrder == SortOption.Ascending)
                {
                    SQL += " ASC";
                }
                else
                {
                    SQL += " DESC";
                }



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmGroupID = new MySqlParameter("@GroupID", MySqlDbType.Int64);
                prmGroupID.Value = GroupID;
                cmd.Parameters.Add(prmGroupID);

                MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey", MySqlDbType.String);
                prmSearchKey.Value = "%" + SearchKey + "%";
                cmd.Parameters.Add(prmSearchKey);



                return(base.ExecuteReader(cmd));
            }
            catch (Exception ex)
            {
                {
                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 18
0
        private void LoadList()
        {
            Contacts       clsContact        = new Contacts();
            DataClass      clsDataClass      = new DataClass();
            ContactColumns clsContactColumns = new ContactColumns();

            clsContactColumns.ContactID     = true;
            clsContactColumns.ContactCode   = true;
            clsContactColumns.ContactName   = true;
            clsContactColumns.RewardDetails = true;

            ContactColumns clsSearchColumns = new ContactColumns();

            clsSearchColumns.ContactCode   = true;
            clsSearchColumns.ContactName   = true;
            clsSearchColumns.RewardDetails = true;

            string SortField = "ContactID";

            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        = txtSearch.Text;
            string ContactGroupCode = "";

            ContactGroupCode = cboGroup.SelectedIndex == 0 ? "" : cboGroup.SelectedItem.Text;

            DateTime dteBirthDateFrom       = Constants.C_DATE_MIN_VALUE;
            DateTime dteBirthDateTo         = Constants.C_DATE_MIN_VALUE;
            DateTime dteAnniversaryDateFrom = Constants.C_DATE_MIN_VALUE;
            DateTime dteAnniversaryDateTo   = Constants.C_DATE_MIN_VALUE;

            dteBirthDateFrom       = DateTime.TryParse(txtBirthStartDate.Text, out dteBirthDateFrom) ? dteBirthDateFrom : Constants.C_DATE_MIN_VALUE;
            dteBirthDateTo         = DateTime.TryParse(txtBirthEndDate.Text, out dteBirthDateTo) ? dteBirthDateTo : Constants.C_DATE_MIN_VALUE;
            dteAnniversaryDateFrom = DateTime.TryParse(txtAnnivStartDate.Text, out dteAnniversaryDateFrom) ? dteAnniversaryDateFrom : Constants.C_DATE_MIN_VALUE;
            dteAnniversaryDateTo   = DateTime.TryParse(txtAnnivEndDate.Text, out dteAnniversaryDateTo) ? dteAnniversaryDateTo : Constants.C_DATE_MIN_VALUE;

            //PageData.DataSource = clsContact.Customers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsSearchColumns, SearchKey, 0, false, null, System.Data.SqlClient.SortOrder.Ascending).DefaultView;
            PageData.DataSource = clsContact.ListAsDataTable(ContactGroupCategory.CUSTOMER, ContactCode: SearchKey, ContactName: SearchKey, ContactGroupCode: ContactGroupCode, SortField: SortField, SortOrder: sortoption, BirthDateFrom: dteBirthDateFrom.ToString("yyyy-MM-dd"), BirthDateTo: dteBirthDateTo.ToString("yyyy-MM-dd"), AnniversaryDateFrom: dteAnniversaryDateFrom.ToString("yyyy-MM-dd"), AnniversaryDateTo: dteAnniversaryDateTo.ToString("yyyy-MM-dd"), BirthMonth: cboBirthMonth.SelectedIndex, AnniversaryMonth: cboAnniversaryMonth.SelectedIndex).DefaultView;
            //clsContact.CustomersDataTable(SearchKey, SortField: SortField, SortOrder: sortoption).DefaultView;

            clsContact.CommitAndDispose();

            int iPageSize = Convert.ToInt16(Session["PageSize"]);

            PageData.AllowPaging = true;
            PageData.PageSize    = iPageSize;
            try
            {
                PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
                lstItem.DataSource        = PageData;
                lstItem.DataBind();
            }
            catch
            {
                PageData.CurrentPageIndex = 1;
                lstItem.DataSource        = PageData;
                lstItem.DataBind();
            }

            cboCurrentPage.Items.Clear();
            for (int i = 0; i < PageData.PageCount; i++)
            {
                int iValue = i + 1;
                cboCurrentPage.Items.Add(new ListItem(iValue.ToString(), iValue.ToString()));
                if (PageData.CurrentPageIndex == i)
                {
                    cboCurrentPage.Items[i].Selected = true;
                }
                else
                {
                    cboCurrentPage.Items[i].Selected = false;
                }
            }
            lblDataCount.Text = " of " + " " + PageData.PageCount;
        }
Ejemplo n.º 19
0
 /// <summary>Builds up a String containing each property and value in the class decorated with the AuditAttribute. The String displays the property name, property friendly name and property value.</summary>
 /// <typeparam name="T">Class type.</typeparam>
 /// <param name="instance">The instance.</param>
 /// <param name="includeAllProperties">The include all properties.</param>
 /// <param name="sortOption">The sort option.</param>
 /// <param name="delimiter">The delimiter.</param>
 /// <param name="defaultValue">
 /// If no class properties are decorated with the <see cref="AuditAttribute"/> and the defaultValue is not null or an empty string, then the default value will be returned.
 /// </param>
 /// <returns>A String containing each property name, friendly name and value, separated by the delimiter and sorted by AuditAttribute.AuditSequence and then property name.</returns>
 /// <exception cref="InvalidEnumArgumentException">Thrown when enum value includeAllProperties is not defined.</exception>
 /// <exception cref="InvalidEnumArgumentException">Thrown when enum value sortOption is not defined.</exception>
 /// <exception cref="ArgumentNullEmptyWhiteSpaceException">Thrown when delimiter is null, empty, or white space.</exception>
 /// <exception cref="InvalidEnumArgumentException">Thrown when enum value auditFormat is not defined.</exception>
 public String AuditToString <T>(IncludeAllProperties includeAllProperties, SortOption sortOption, String delimiter = Constants.DefaultAuditMessageDelimiter, AuditFormat auditFormat = AuditFormat.Compact, String defaultValue = Constants.AuditDefaultValue)
 {
     return(AuditMessageFactory.AuditToString(this, includeAllProperties, sortOption, delimiter, auditFormat, defaultValue));
 }
Ejemplo n.º 20
0
        public MySqlDataReader List(CreditMemoItemStatus CreditMemoItemstatus, string SortField, SortOption SortOrder)
        {
            try
            {
                if (SortField == string.Empty || SortField == null)
                {
                    SortField = "CreditMemoItemID";
                }

                string SQL = SQLSelect() + "WHERE ItemStatus = @ItemStatus " +
                             "ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                {
                    SQL += " ASC";
                }
                else
                {
                    SQL += " DESC";
                }



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmCreditMemoItemStatus = new MySqlParameter("@ItemStatus", MySqlDbType.Int16);
                prmCreditMemoItemStatus.Value = CreditMemoItemstatus.ToString("d");
                cmd.Parameters.Add(prmCreditMemoItemStatus);

                MySqlDataReader myReader = base.ExecuteReader(cmd);

                return(myReader);
            }
            catch (Exception ex)
            {
                {
                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 21
0
		public MySqlDataReader Search(string SearchKey, string SortField, SortOption SortOrder)
		{
			try
			{
				string SQL ="SELECT * FROM tblProductGroupUnitMatrix " +
							"WHERE GroupID LIKE @SearchKey " +
							"ORDER BY " + SortField;

				if (SortOrder == SortOption.Ascending)
					SQL += " ASC";
				else
					SQL += " DESC";

				

				MySqlCommand cmd = new MySqlCommand();
				
				
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;
				
				MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
				prmSearchKey.Value = "%" + SearchKey + "%";
				cmd.Parameters.Add(prmSearchKey);

				
				
				return base.ExecuteReader(cmd);			
			}
			catch (Exception ex)
			{
				
				
				{
					
					
					
					
				}

				throw base.ThrowException(ex);
			}	
		}		
Ejemplo n.º 22
0
        public System.Data.DataTable ListAsDataTable(ReceiptDetails ReceiptDetails, string SortField = "ReceiptID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = SQLSelect() + "WHERE 1=1 ";

                if (ReceiptDetails.ReceiptID != 0)
                {
                    SQL += "AND ReceiptID = @ReceiptID) ";
                    cmd.Parameters.AddWithValue("@ReceiptID", ReceiptDetails.ReceiptID);
                }
                if (!string.IsNullOrEmpty(ReceiptDetails.Module))
                {
                    SQL += "AND Module = @Module) ";
                    cmd.Parameters.AddWithValue("@Module", ReceiptDetails.Module);
                }
                if (!string.IsNullOrEmpty(ReceiptDetails.Value))
                {
                    SQL += "AND Value = @Value) ";
                    cmd.Parameters.AddWithValue("@Value", ReceiptDetails.Value);
                }


                SQL += "ORDER BY " + SortField + " ";
                SQL += SortOrder == SortOption.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);
            }
        }
Ejemplo n.º 23
0
        public System.Data.DataTable ListAsDataTable(long CreditMemoID = 0, string SortField = "CreditMemoItemID", SortOption SortOrder = SortOption.Ascending)
        {
            MySqlCommand cmd = new MySqlCommand();
            string       SQL = SQLSelect();

            if (CreditMemoID != 0)
            {
                SQL += "WHERE CreditMemoID = @CreditMemoID ";

                MySqlParameter prmReturnID = new MySqlParameter("@CreditMemoID", MySqlDbType.Int64);
                prmReturnID.Value = CreditMemoID;
                cmd.Parameters.Add(prmReturnID);
            }

            SQL += "ORDER BY " + SortField;
            if (SortOrder == SortOption.Ascending)
            {
                SQL += " ASC";
            }
            else
            {
                SQL += " DESC";
            }

            cmd.CommandType = System.Data.CommandType.Text;
            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);
        }
Ejemplo n.º 24
0
        public MySqlDataReader List(long TransferInID = 0, string SortField = "TransferInItemID", SortOption SortOrder = SortOption.Desscending)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                string       SQL = SQLSelect();

                if (TransferInID != 0)
                {
                    SQL += "WHERE TransferInID = @TransferInID ";

                    MySqlParameter prmTransferInID = new MySqlParameter("@TransferInID", MySqlDbType.Int64);
                    prmTransferInID.Value = TransferInID;
                    cmd.Parameters.Add(prmTransferInID);
                }

                SQL += "ORDER BY " + SortField;
                if (SortOrder == SortOption.Ascending)
                {
                    SQL += " ASC";
                }
                else
                {
                    SQL += " DESC";
                }

                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlDataReader myReader = base.ExecuteReader(cmd);

                return(myReader);
            }
            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 25
0
        private void search()
        {
            buttonSearch.Enabled = false;
            listViewSearchResults.Items.Clear();

            DirectoryEntry rootDSE = new DirectoryEntry("LDAP://RootDSE");
            String         defaultNamingContext = rootDSE.Properties["defaultNamingContext"].Value.ToString();
            DirectoryEntry searchRoot           = new DirectoryEntry("LDAP://" + defaultNamingContext);

            String sortField = "printername";

            if (radioButtonPrinterLocation.Checked)
            {
                sortField = "location";
            }
            SortOption sortOption = new SortOption(sortField, SortDirection.Ascending);

            DirectorySearcher searcher = new DirectorySearcher(searchRoot);


            string filter = "";

            if (radioButtonPrinterName.Checked)
            {
                filter = "(&(objectcategory=printqueue)(printername=*" + textBox1.Text + "*))";
            }
            else
            {
                filter = "(&(objectcategory=printqueue)(location=*" + textBox1.Text + "*))";
            }

            searcher.ReferralChasing = ReferralChasingOption.All;
            searcher.PageSize        = 1000;
            searcher.Filter          = filter;
            searcher.SearchScope     = SearchScope.Subtree;
            searcher.Sort            = sortOption;

            try
            {
                SearchResultCollection colResults = searcher.FindAll();

                foreach (SearchResult result in colResults)
                {
                    String printername = "";
                    String location    = "";
                    String driverName  = "";
                    String uncname     = "";

                    if ((result.Properties.Contains("printername")) && (result.Properties.Contains("uncname")))
                    {
                        printername = result.Properties["printername"][0].ToString();

                        if (result.Properties.Contains("location"))
                        {
                            location = result.Properties["location"][0].ToString();
                        }

                        if (result.Properties.Contains("driverName"))
                        {
                            driverName = result.Properties["driverName"][0].ToString();
                        }

                        uncname = result.Properties["uncname"][0].ToString();

                        ListViewItem lvi = new ListViewItem(printername);
                        lvi.SubItems.Add(location);
                        lvi.SubItems.Add(driverName);
                        lvi.SubItems.Add(uncname);

                        listViewSearchResults.Items.Add(lvi);
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message, "Search Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }
            finally {
                buttonSearch.Enabled = true;
            }
        }
Ejemplo n.º 26
0
 public async Task <IActionResult> Sort(IFormFile file, SortOption sortOption)
 {
     return(new OkResult());
 }
Ejemplo n.º 27
0
 public System.Data.DataTable ListClosedDataTable(Int32 BranchID, DateTime? TransactionDateFrom = null, DateTime? TransactionDateTo = null, string SortField = "TransactionDate", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
 {
     try
     {
         return ListAsDataTable(BranchID, TransactionDateFrom: TransactionDateFrom, TransactionDateTo: TransactionDateTo, TransactionStatus: TransactionStatus.Closed, SortField: SortField, SortOption: SortOrder, limit: limit);
     }
     catch (Exception ex)
     {
         throw base.ThrowException(ex);
     }
 }
Ejemplo n.º 28
0
		public MySqlDataReader Search(Int64 ProductID, string SearchKey, string SortField, SortOption SortOrder)
		{
			try
			{
				string SQL = "SELECT a.ProductID,a.VariationID,b.VariationCode,b.VariationType " +
							"FROM tblProductVariations a " +
							"LEFT JOIN tblVariations b ON a.VariationID = b.VariationID " +
							"WHERE ProductID = @ProductID " + 
							"AND VariationType LIKE @SearchKey " + 
							"ORDER BY " + SortField;

				if (SortOrder == SortOption.Ascending)
					SQL += " ASC;";
				else
					SQL += " DESC;";

				

				MySqlCommand cmd = new MySqlCommand();
				
				
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;
				
				MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.Int64);			
				prmProductID.Value = ProductID;
				cmd.Parameters.Add(prmProductID);

				MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);			
				prmSearchKey.Value = "%" + SearchKey + "%";
				cmd.Parameters.Add(prmSearchKey);

				
				
				return base.ExecuteReader(cmd);			
			}
			catch (Exception ex)
			{
				
				
				{
					
					
					
					
				}

				throw base.ThrowException(ex);
			}	
		}
Ejemplo n.º 29
0
 public System.Data.DataTable ListAsDataTable(SalesTransactionDetails clsSearchKey, bool WithTF = false, string SortField = "", SortOption SortOption = SortOption.Ascending, Int32 limit = 0)
 {
     try
     {
         return ListAsDataTable(clsSearchKey.BranchID, clsSearchKey.TerminalNo, clsSearchKey.TransactionID, clsSearchKey.TransactionNo, clsSearchKey.TransactionDateFrom, clsSearchKey.TransactionDateTo, clsSearchKey.TransactionStatus, clsSearchKey.PaymentType, clsSearchKey.isConsignment, false, clsSearchKey.CustomerName, clsSearchKey.CustomerGroupName, clsSearchKey.CashierID, clsSearchKey.CashierName, clsSearchKey.AgentName, WithTF, false, SortField, SortOption, limit); ;
     }
     catch (Exception ex)
     {
         throw base.ThrowException(ex);
     }
 }
Ejemplo n.º 30
0
        public System.Data.DataTable AvailableVariationsDataTable(Int64 ProductID, string SortField, SortOption SortOrder)
        {
            try
            {
                string SQL = "SELECT * FROM tblVariations " +
                                "WHERE VariationID NOT IN (SELECT VariationID FROM tblProductVariations WHERE ProductID = @ProductID) " +
                            "ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                    SQL += " ASC;";
                else
                    SQL += " DESC;";

                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@ProductID", ProductID);

                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);
            }
        }
Ejemplo n.º 31
0
 /// <summary>Populates the dictionary with property's name and value in the class for properties decorated with the <see cref="AuditAttribute"/>. If <c>IncludeAllProperties.Yes</c> then all properties will be included with or without the <c>AuditAttribute</c>.</summary>
 /// <param name="instance">The instance.</param>
 /// <param name="dictionary">Pass an IDictionary Object that needs to be populated. This could be the Data property of an exception Object that you want to populate, etc.</param>
 /// <param name="includeAllProperties">The include all properties.</param>
 /// <param name="sortOption">The sort option.</param>
 /// <param name="auditFormat">The audit format.</param>
 /// <param name="defaultValue">
 /// If no class properties are decorated with the <see cref="AuditAttribute"/> and the defaultValue is not null or an empty string, then a single entry will be added to the dictionary that is named 'DefaultValue' and will have the value of defaultValue.
 /// </param>
 /// <returns>IDictionary populated with properties and values.</returns>
 /// <exception cref="ArgumentNullException">Thrown when dictionary is null.</exception>
 /// <exception cref="InvalidEnumArgumentException">Thrown when enum value includeAllProperties is not defined.</exception>
 /// <exception cref="InvalidEnumArgumentException">Thrown when enum value sortOption is not defined.</exception>
 /// <exception cref="InvalidEnumArgumentException">Thrown when enum value auditFormat is not defined.</exception>
 public IDictionary <String, String> AuditToIDictionary(IDictionary <String, String> dictionary, IncludeAllProperties includeAllProperties, SortOption sortOption, AuditFormat auditFormat = AuditFormat.Compact, String defaultValue = Constants.AuditDefaultValue)
 {
     return(AuditMessageFactory.AuditToIDictionary(this, dictionary, includeAllProperties, sortOption, auditFormat, defaultValue));
 }
Ejemplo n.º 32
0
        public System.Data.DataTable ListAsDataTable(CashCountDetails clsSearchKey, string SortField = "CashCountID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = SQLSelect() + "WHERE 1=1 ";

                if (clsSearchKey.CashierID != 0)
                {
                    SQL += "AND CashierID = @CashierID ";
                    cmd.Parameters.AddWithValue("CashierID", clsSearchKey.CashierID);
                }
                if (!string.IsNullOrEmpty(clsSearchKey.TerminalNo))
                {
                    SQL += "AND TerminalNo = @TerminalNo ";
                    cmd.Parameters.AddWithValue("CashierID", clsSearchKey.CashierID);
                }
                if (!string.IsNullOrEmpty(clsSearchKey.CashierName))
                {
                    SQL += "AND CashierName = @CashierName ";
                    cmd.Parameters.AddWithValue("CashierID", clsSearchKey.CashierID);
                }
                if (!string.IsNullOrEmpty(clsSearchKey.DenominationDetails.DenominationCode))
                {
                    SQL += "AND DenominationCode = @DenominationCode ";
                    cmd.Parameters.AddWithValue("CashierID", clsSearchKey.CashierID);
                }

                SQL += "ORDER BY " + SortField + " ";
                SQL += SortOrder == SortOption.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);
            }
        }
Ejemplo n.º 33
0
        private void LoadList()
        {
            SO clsSO = new SO();

            string SortField = "SOID";

            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);
            }

            if (Request.QueryString["Search"] == null)
            {
                if (Request.QueryString["status"] == null)
                {
                    PageData.DataSource = clsSO.ListAsDataTable(SOStatus.Open, SortField, sortoption).DefaultView;
                }
                else
                {
                    SOStatus status = (SOStatus)Enum.Parse(typeof(SOStatus), Common.Decrypt((string)Request.QueryString["status"], Session.SessionID));
                    PageData.DataSource = clsSO.ListAsDataTable(status, SortField, sortoption).DefaultView;
                }
            }
            else
            {
                string SearchKey = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID);
                if (Request.QueryString["status"] == null)
                {
                    PageData.DataSource = clsSO.SearchAsDataTable(SOStatus.Open, SearchKey, SortField, sortoption).DefaultView;
                }
                else
                {
                    SOStatus status = (SOStatus)Enum.Parse(typeof(SOStatus), Common.Decrypt((string)Request.QueryString["status"], Session.SessionID));
                    PageData.DataSource = clsSO.SearchAsDataTable(status, SearchKey, SortField, sortoption).DefaultView;
                }
            }

            clsSO.CommitAndDispose();

            int iPageSize = Convert.ToInt16(Session["PageSize"]);

            PageData.AllowPaging = true;
            PageData.PageSize    = iPageSize;
            try
            {
                PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
                lstItem.DataSource        = PageData;
                lstItem.DataBind();
            }
            catch
            {
                PageData.CurrentPageIndex = 1;
                lstItem.DataSource        = PageData;
                lstItem.DataBind();
            }

            cboCurrentPage.Items.Clear();
            for (int i = 0; i < PageData.PageCount; i++)
            {
                int iValue = i + 1;
                cboCurrentPage.Items.Add(new ListItem(iValue.ToString(), iValue.ToString()));
                if (PageData.CurrentPageIndex == i)
                {
                    cboCurrentPage.Items[i].Selected = true;
                }
                else
                {
                    cboCurrentPage.Items[i].Selected = false;
                }
            }
            lblDataCount.Text = " of " + " " + PageData.PageCount;
        }
Ejemplo n.º 34
0
 /// <summary>
 /// 初始化构造
 /// </summary>
 /// <param name="startRows">开始行数</param>
 /// <param name="pageSize">每页大小</param>
 /// <param name="tableName">要查询的表名</param>
 /// <param name="strColumn">查询结果集中返回的列</param>
 /// <param name="sortColumn">用于排序的列</param>
 /// <param name="SortOption">排序方式</param>
 /// <param name="filter">查询时的过滤条件</param>
 public ListParameters(int startRows, int pageSize, string tableName, string strColumn, string sortColumn, SortOption SortOption, string filter)
 {
     this.m_StartRows  = startRows;
     this.m_PageSize   = pageSize;
     this.m_TableName  = tableName;
     this.m_StrColumn  = strColumn;
     this.m_SortColumn = sortColumn;
     this.m_SortOption = SortOption;
     this.m_Filter     = filter;
 }
Ejemplo n.º 35
0
        public MySqlDataReader List(Int64 MatrixID, string SortField, SortOption SortOrder)
        {
            try
            {
                string SQL = "SELECT " +
                                "a.PackageID, " +
                                "a.MatrixID, " +
                                "Description, " +
                                "a.UnitID, " +
                                "c.UnitCode, " +
                                "c.UnitName, " +
                                "a.Price, " +
                                "a.WSPrice, " +
                                "a.PurchasePrice, " +
                                "a.Quantity, " +
                                "a.VAT, " +
                                "a.EVAT, " +
                                "a.LocalTax " +
                            "FROM tblMatrixPackage a " +
                            "INNER JOIN tblProductBaseVariationsMatrix b ON a.MatrixID = b.MatrixID " +
                            "INNER JOIN tblUnit c ON a.UnitID = c.UnitID " +
                            "WHERE 1=1 AND a.MatrixID = @MatrixID ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                    SQL += " ASC";
                else
                    SQL += " DESC";



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmMatrixID = new MySqlParameter("@MatrixID", MySqlDbType.Int64);
                prmMatrixID.Value = MatrixID;
                cmd.Parameters.Add(prmMatrixID);



                return base.ExecuteReader(cmd);
            }
            catch (Exception ex)
            {


                {




                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 36
0
 public IEnumerable<string> Sort(Uri filePath, SortOption option)
 {
     return this.textSort.Sort(filePath, option);
 }
Ejemplo n.º 37
0
        public System.Data.DataTable ListAsDataTable(Int64 ProductID = 0, DateTime?PurchaseDateFrom = null, string SortField = "PurchasePrice", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = SQLSelect() + "WHERE 1=1 ";

                if (ProductID != 0)
                {
                    SQL += "AND a.ProductID = @ProductID ";
                    cmd.Parameters.AddWithValue("@ProductID", ProductID);
                }

                if (PurchaseDateFrom.GetValueOrDefault() != DateTime.MinValue)
                {
                    SQL += "AND a.PurchaseDate >= @PurchaseDateFrom ";
                    cmd.Parameters.AddWithValue("@PurchaseDateFrom", PurchaseDateFrom.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : PurchaseDateFrom);
                }

                SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "PurchasePrice") + " ";
                SQL += SortOrder == SortOption.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);
            }
        }
Ejemplo n.º 38
0
 public IEnumerable <string> Sort(Uri filePath, SortOption option)
 {
     throw new NotImplementedException();
 }
Ejemplo n.º 39
0
        public MySqlDataReader Search(CreditMemoItemStatus CreditMemoItemstatus, string SearchKey, string SortField, SortOption SortOrder)
        {
            try
            {
                if (SortField == string.Empty || SortField == null)
                {
                    SortField = "CreditMemoItemID";
                }

                string SQL = SQLSelect() + "WHERE (ProductCode LIKE @SearchKey or BarCode LIKE @SearchKey or Description LIKE @SearchKey " +
                             "or MatrixDescription LIKE @SearchKey or ProductGroup LIKE @SearchKey or ProductSubGroup LIKE @SearchKey " +
                             "or Remarks LIKE @SearchKey) " +
                             "ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                {
                    SQL += " ASC";
                }
                else
                {
                    SQL += " DESC";
                }



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmCreditMemoItemStatus = new MySqlParameter("@ItemStatus", MySqlDbType.Int16);
                prmCreditMemoItemStatus.Value = CreditMemoItemstatus.ToString("d");
                cmd.Parameters.Add(prmCreditMemoItemStatus);

                MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey", MySqlDbType.String);
                prmSearchKey.Value = "%" + SearchKey + "%";
                cmd.Parameters.Add(prmSearchKey);

                MySqlDataReader myReader = base.ExecuteReader(cmd);

                return(myReader);
            }
            catch (Exception ex)
            {
                {
                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 40
0
        public System.Data.DataTable ListAstDataTable(PromoBySupplierDetails SearchKey, string SortField = "PromoBySupplierID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = "SELECT " +
                             "PromoBySupplierID, " +
                             "PromoBySupplierCode, " +
                             "PromoBySupplierName, " +
                             "PromoLevel, " +
                             "StartDate, " +
                             "EndDate, " +
                             "Status, " +
                             "a.PromoTypeID, " +
                             "PromoTypeCode, " +
                             "PromoTypeName " +
                             "FROM tblPromoBySupplier a INNER JOIN " +
                             "tblPromoType b ON a.PromoTypeID = b.PromoTypeID " +
                             "WHERE 1=1 ";

                if (!string.IsNullOrEmpty(SearchKey.PromoBySupplierCode))
                {
                    SQL += "AND PromoBySupplierCode LIKE @PromoBySupplierCode ";
                    cmd.Parameters.AddWithValue("@PromoBySupplierCode", SearchKey.PromoBySupplierCode);
                }
                if (!string.IsNullOrEmpty(SearchKey.PromoBySupplierName))
                {
                    SQL += "AND PromoBySupplierCode LIKE @PromoBySupplierName ";
                    cmd.Parameters.AddWithValue("@PromoBySupplierName", SearchKey.PromoBySupplierName);
                }
                if (!string.IsNullOrEmpty(SearchKey.PromoTypeCode))
                {
                    SQL += "AND PromoBySupplierCode LIKE @PromoTypeCode ";
                    cmd.Parameters.AddWithValue("@PromoTypeCode", SearchKey.PromoTypeCode);
                }

                SQL += "ORDER BY " + SortField + " ";
                SQL += SortOrder == SortOption.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);
            }
        }
		public System.Data.DataTable BaseList(Int64 ProductID, string SortField, SortOption SortOrder, Int32 limit = 0)
		{
			try
			{
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

				string SQL =	"SELECT MatrixID, " +
									"ProductID, " + 
									"Description, " + 
									"a.UnitID, " + 
									"UnitName, " + 
									"a.IncludeInSubtotalDiscount " +
								"FROM tblProductBaseVariationsMatrix a INNER JOIN " +
								"tblUnit b ON a.UnitID = b.UnitID " +	
								"WHERE ProductID = @ProductID ORDER BY MatrixID, " + SortField;

				if (SortOrder == SortOption.Ascending)
					SQL += " ASC";
				else
					SQL += " DESC";

                SQL += "ORDER BY " + SortField + " ";
                SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
                SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " ";

                cmd.Parameters.AddWithValue("@ProductID", ProductID);

                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);
			}	
		}
 public static extern void Everything_SetSort(SortOption dwSortType);
Ejemplo n.º 43
0
		public MySqlDataReader AvailableVariations(Int64 ProductID, string SortField, SortOption SortOrder)
		{
			try
			{
				string SQL = "SELECT * FROM tblVariations " + 
								"WHERE VariationID NOT IN (SELECT VariationID FROM tblProductVariations WHERE ProductID = @ProductID) " + 
							"ORDER BY " + SortField;

				if (SortOrder == SortOption.Ascending)
					SQL += " ASC;";
				else
					SQL += " DESC;";

				

				MySqlCommand cmd = new MySqlCommand();
				
				
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;
				
				MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.Int64);			
				prmProductID.Value = ProductID;
				cmd.Parameters.Add(prmProductID);

				
			
				return base.ExecuteReader(cmd);			
			}
			catch (Exception ex)
			{
				
				
				{
					
					
					
					
				}

				throw base.ThrowException(ex);
			}	
		}
 public static extern bool Everything_IsFastSort(SortOption dwSortType);
Ejemplo n.º 45
0
        public MySqlDataReader List(string SortField, SortOption SortOrder, string MatrixIDs)
        {
            try
            {
                string SQL = "SELECT " +
                                "a.PackageID, " +
                                "a.MatrixID, " +
                                "Description, " +
                                "a.UnitID, " +
                                "c.UnitCode, " +
                                "c.UnitName, " +
                                "a.Price, " +
                                "a.WSPrice, " +
                                "a.PurchasePrice, " +
                                "a.Quantity, " +
                                "a.VAT, " +
                                "a.EVAT, " +
                                "a.LocalTax " +
                            "FROM tblMatrixPackage a " +
                            "INNER JOIN tblProductBaseVariationsMatrix b ON a.MatrixID = b.MatrixID " +
                            "INNER JOIN tblUnit c ON a.UnitID = c.UnitID " +
                            "WHERE 1=1 ";

                if (MatrixIDs != "" && MatrixIDs != null)
                    SQL += "AND a.MatrixID in (" + MatrixIDs + ") ";

                SQL += "ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                    SQL += " ASC";
                else
                    SQL += " DESC";



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;



                return base.ExecuteReader(cmd);
            }
            catch (Exception ex)
            {


                {




                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 46
0
        public System.Data.DataTable List(DateTime StartChangeDate, DateTime EndChangeDate, long ProductID = 0, string SortField = "ChangeDate", SortOption SortOrder = SortOption.Ascending)
        {
            try
            {
                string SQL = "CALL procProductPriceHistorySelect(@StartChangeDate, @EndChangeDate, @ProductID, @SortField, @SortOrder)";

                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@StartChangeDate", StartChangeDate.ToString("yyyy-MM-dd HH:mm:ss"));
                cmd.Parameters.AddWithValue("@EndChangeDate", EndChangeDate.ToString("yyyy-MM-dd HH:mm:ss"));
                cmd.Parameters.AddWithValue("@ProductID", ProductID);
                cmd.Parameters.AddWithValue("@SortField", SortField);
                switch (SortOrder)
                {
                case SortOption.Ascending:
                    cmd.Parameters.AddWithValue("@SortOrder", "ASC");
                    break;

                case SortOption.Desscending:
                    cmd.Parameters.AddWithValue("@SortOrder", "DESC");
                    break;
                }

                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);
            }
        }
Ejemplo n.º 47
0
        public System.Data.DataTable ListAsDataTable(Int64 MatrixID, string SortField, SortOption SortOrder)
        {
            try
            {
                string SQL = SQLSelect() + "WHERE 1=1 AND a.MatrixID = @MatrixID ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                    SQL += " ASC";
                else
                    SQL += " DESC";

                MySqlCommand cmd = new MySqlCommand();
                cmd.Connection = GetConnection();

                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@MatrixID", MatrixID);

                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);
            }
        }
Ejemplo n.º 48
0
        public System.Data.DataTable ListAsDataTable(string SearchKey = null, string SortField = "DiscountCode", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = SQLSelect() + " ";

                if (!string.IsNullOrEmpty(SearchKey))
                {
                    SQL += "WHERE DiscountType LIKE @SearchKey ";
                    cmd.Parameters.AddWithValue("@SearchKey", "%" + SearchKey + "%");
                }

                SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "DiscountCode") + " ";
                SQL += SortOrder == SortOption.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);
            }
        }
Ejemplo n.º 49
0
 public static IEnumerable<ClearedTaskModel> GetClearedTasks(SortOption sortOption)
 {
     return DataLayer.TaskDatabase.GetItems<ClearedTaskModel>().OrderByDescending(t => t.DateCompleted);
 }
Ejemplo n.º 50
0
        //public MySqlDataReader Search(string SearchKey, string SortField, SortOption SortOrder)
        //{
        //    try
        //    {
        //        string SQL =	SQLSelect() + "(TransactionNo LIKE @SearchKey " +
        //                        "OR StockTypeCode LIKE @SearchKey " +
        //                        "OR a.Remarks LIKE @SearchKey) " +
        //                        "ORDER BY " + SortField;

        //        if (SortOrder == SortOption.Ascending)
        //            SQL += " ASC";
        //        else
        //            SQL += " DESC";



        //        MySqlCommand cmd = new MySqlCommand();


        //        cmd.CommandType = System.Data.CommandType.Text;
        //        cmd.CommandText = SQL;

        //        MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
        //        prmSearchKey.Value = "%" + SearchKey + "%";
        //        cmd.Parameters.Add(prmSearchKey);



        //        return base.ExecuteReader(cmd);
        //    }
        //    catch (Exception ex)
        //    {


        //        {



        //        }

        //        throw base.ThrowException(ex);
        //    }
        //}
        //public MySqlDataReader List(string SortField, SortOption SortOrder)
        //{
        //    try
        //    {
        //        string SQL = SQLSelect() + "ORDER BY " + SortField;


        //        if (SortOrder == SortOption.Ascending)
        //            SQL += " ASC";
        //        else
        //            SQL += " DESC";



        //        MySqlCommand cmd = new MySqlCommand();


        //        cmd.CommandType = System.Data.CommandType.Text;
        //        cmd.CommandText = SQL;



        //        return base.ExecuteReader(cmd);
        //    }
        //    catch (Exception ex)
        //    {


        //        {



        //        }

        //        throw base.ThrowException(ex);
        //    }
        //}

        public System.Data.DataTable ListAsDataTableActiveInactive(TransactionListFilterType clsTransactionListFilterType, string SearchKey = null, string SortField = "StockID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = SQLSelect() + "WHERE 1=1 ";

                if (clsTransactionListFilterType == TransactionListFilterType.ShowActiveOnly)
                {
                    SQL += "AND a.Active = 1 ";
                }
                else if (clsTransactionListFilterType == TransactionListFilterType.ShowInactiveOnly)
                {
                    SQL += "AND a.Active = 0 ";
                }

                if (!string.IsNullOrEmpty(SearchKey))
                {
                    SQL += "AND (TransactionNo LIKE @SearchKey " +
                           "OR StockTypeCode LIKE @SearchKey " +
                           "OR a.Remarks LIKE @SearchKey) ";
                    cmd.Parameters.AddWithValue("@SearchKey", "%" + SearchKey + "%");
                }

                SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "StockID") + " ";
                SQL += SortOrder == SortOption.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);
            }
        }
Ejemplo n.º 51
0
        public MySqlDataReader List(string SortField, SortOption SortOrder)
        {
            try
            {
                if (SortField == string.Empty || SortField == null) SortField = "CreditMemoItemID";

                string SQL = SQLSelect() + "ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                    SQL += " ASC";
                else
                    SQL += " DESC";

                

                MySqlCommand cmd = new MySqlCommand();
                
                
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlDataReader myReader = base.ExecuteReader(cmd);

                return myReader;
            }
            catch (Exception ex)
            {
                
                
                {
                    
                    
                    
                    
                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 52
0
        public System.Data.DataTable ListAsDataTable(Int64 MatrixID, string SortField, SortOption SortOrder)
        {
            try
            {
                string SQL = SQLSelect() + "WHERE 1=1 AND a.MatrixID = @MatrixID ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                {
                    SQL += " ASC";
                }
                else
                {
                    SQL += " DESC";
                }

                MySqlCommand cmd = new MySqlCommand();
                cmd.Connection = GetConnection();

                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@MatrixID", MatrixID);

                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);
            }
        }
Ejemplo n.º 53
0
        public MySqlDataReader List(CreditMemoItemStatus CreditMemoItemstatus, string SortField, SortOption SortOrder)
        {
            try
            {
                if (SortField == string.Empty || SortField == null) SortField = "CreditMemoItemID";

                string SQL = SQLSelect() + "WHERE ItemStatus = @ItemStatus " +
                            "ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                    SQL += " ASC";
                else
                    SQL += " DESC";

                

                MySqlCommand cmd = new MySqlCommand();
                
                
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmCreditMemoItemStatus = new MySqlParameter("@ItemStatus",MySqlDbType.Int16);
                prmCreditMemoItemStatus.Value = CreditMemoItemstatus.ToString("d");
                cmd.Parameters.Add(prmCreditMemoItemStatus);

                MySqlDataReader myReader = base.ExecuteReader(cmd);

                return myReader;
            }
            catch (Exception ex)
            {
                
                
                {
                    
                    
                    
                    
                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 54
0
        public MySqlDataReader Search(long GJournalID, string SearchKey, string SortField, SortOption SortOrder)
        {
            try
            {
                string SQL = "SELECT " +
                             "GJournalDebitID, " +
                             "GJournalID, " +
                             "a.ChartOfAccountID, " +
                             "ChartOfAccountCode, " +
                             "ChartOfAccountName, " +
                             "Amount " +
                             "FROM tblGJournalDebit a INNER JOIN tblChartOfAccount b " +
                             "ON a.ChartOfAccountID = b.ChartOfAccountID " +
                             "WHERE GJournalID = @GJournalID " +
                             "AND (ChartOfAccountCode LIKE @SearchKey " +
                             "or ChartOfAccountName LIKE @SearchKey) " +
                             "ORDER BY " + SortField;

                if (SortOrder == SortOption.Ascending)
                {
                    SQL += " ASC";
                }
                else
                {
                    SQL += " DESC";
                }



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID", MySqlDbType.Int64);
                prmGJournalID.Value = GJournalID;
                cmd.Parameters.Add(prmGJournalID);

                MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey", MySqlDbType.String);
                prmSearchKey.Value = "%" + SearchKey + "%";
                cmd.Parameters.Add(prmSearchKey);

                MySqlDataReader myReader = base.ExecuteReader(cmd);

                return(myReader);
            }
            catch (Exception ex)
            {
                {
                }

                throw base.ThrowException(ex);
            }
        }
Ejemplo n.º 55
0
        public System.Data.DataTable ListSuspendedDataTable(Int32 BranchID, string TerminalNo, Int64 CashierID = 0, bool isPacked = false, string SortField = "TransactionDate", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
        {
            try
            {
                return ListAsDataTable(BranchID, TerminalNo, CashierID: CashierID, isPacked: isPacked, ShowSuspendedOnly: true, SortField: SortField, SortOption: SortOrder, limit: limit);
                
                //MySqlCommand cmd = new MySqlCommand();
                //cmd.CommandType = System.Data.CommandType.Text;

                //SalesTransactionsColumns clsSalesTransactionsColumns = new SalesTransactionsColumns();
                //clsSalesTransactionsColumns.TransactionNo = true;
                //clsSalesTransactionsColumns.CustomerName = true;
                //clsSalesTransactionsColumns.DateSuspended = true;

                //string SQL = SQLSelect(clsSalesTransactionsColumns) + "WHERE tblTransactions.TransactionStatus = @TransactionStatus ";
                //cmd.Parameters.AddWithValue("@TransactionStatus", TransactionStatus.Suspended.ToString("d"));

                //if (BranchID != 0)
                //{
                //    SQL += "AND tblTransactions.BranchID = @BranchID ";
                //    cmd.Parameters.AddWithValue("@BranchID", BranchID);
                //}

                //if (TerminalNo != string.Empty && TerminalNo != null)
                //{
                //    SQL += "AND tblTransactions.TerminalNo = @TerminalNo ";
                //    cmd.Parameters.AddWithValue("@TerminalNo", TerminalNo);
                //}

                //if (CashierID != 0)
                //{
                //    SQL += "AND tblTransactions.CashierID = @CashierID ";
                //    cmd.Parameters.AddWithValue("@CashierID", CashierID);
                //}
                //SQL += !isPacked ? "" : "AND Packed = 1 ";

                //SQL += "ORDER BY " + SortField + " ";
                //SQL += SortOrder == SortOption.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);
            }
        }
Ejemplo n.º 56
0
        public System.Data.DataTable ListAsDataTable(long POID = 0, string SortField = "POItemID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
        {
            MySqlCommand cmd = new MySqlCommand();

            cmd.CommandType = System.Data.CommandType.Text;

            string SQL = SQLSelect();

            if (POID != 0)
            {
                SQL += "WHERE POID = @POID ";
                cmd.Parameters.AddWithValue("@POID", POID);
            }

            SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "POItemID") + " ";
            SQL += SortOrder == SortOption.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);
        }
Ejemplo n.º 57
0
        public System.Data.DataTable ListAsDataTable(Int32 BranchID, string TerminalNo = "", Int64 TransactionID = 0, string TransactionNo = "", DateTime? TransactionDateFrom = null, DateTime? TransactionDateTo = null,
                                                    TransactionStatus TransactionStatus = TransactionStatus.NotYetApplied, PaymentTypes PaymentType = PaymentTypes.NotYetAssigned, bool isConsignment = false, bool isPacked = false,
                                                    string CustomerName = "", string CustomerGroupName = "", Int64 CashierID = 0, string CashierName = "", string AgentName = "",
                                                    bool WithTF = false, bool ShowSuspendedOnly = false, string SortField = "", SortOption SortOption = SortOption.Ascending, Int32 limit = 0)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = "CALL procTransactionsSelect(@BranchID, @TerminalNo, @TransactionID, @TransactionNo, @TransactionDateFrom, " +
                                                         "@TransactionDateTo, @TransactionStatus, @PaymentType, @isConsignment, @isPacked, @CustomerName, " +
                                                         "@CustomerGroupName, @CashierID, @CashierName, @AgentName, @WithTF, @ShowSuspended, " +
                                                         "@SortField, @SortOption, @Limit);";

                cmd.Parameters.AddWithValue("BranchID", BranchID);
                cmd.Parameters.AddWithValue("TerminalNo", TerminalNo);
                cmd.Parameters.AddWithValue("TransactionID", TransactionID);
                cmd.Parameters.AddWithValue("TransactionNo", TransactionNo);
                cmd.Parameters.AddWithValue("TransactionDateFrom", TransactionDateFrom.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : TransactionDateFrom);
                cmd.Parameters.AddWithValue("TransactionDateTo", TransactionDateTo.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : TransactionDateTo);
                cmd.Parameters.AddWithValue("TransactionStatus", TransactionStatus.ToString("d"));
                cmd.Parameters.AddWithValue("PaymentType", PaymentType.ToString("d"));
                cmd.Parameters.AddWithValue("isConsignment", isConsignment);
                cmd.Parameters.AddWithValue("isPacked", isPacked);
                cmd.Parameters.AddWithValue("CustomerName", CustomerName);
                cmd.Parameters.AddWithValue("CustomerGroupName", CustomerGroupName);
                cmd.Parameters.AddWithValue("CashierID", CashierID);
                cmd.Parameters.AddWithValue("CashierName", CashierName);
                cmd.Parameters.AddWithValue("AgentName", AgentName);
                cmd.Parameters.AddWithValue("WithTF", WithTF);
                cmd.Parameters.AddWithValue("ShowSuspended", ShowSuspendedOnly);
                cmd.Parameters.AddWithValue("SortField", SortField);
                cmd.Parameters.AddWithValue("SortOption", SortOption==SortOption.Ascending ? "ASC" : "DESC");
                cmd.Parameters.AddWithValue("Limit", limit);

                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);
            }
        }
Ejemplo n.º 58
0
 public GetProductsQuery(SortOption sortOption)
 {
     SortOption = sortOption;
 }
Ejemplo n.º 59
0
        public System.Data.DataTable ListAsDataTable(Int64 ParkingRateID, long ProductID, string DayOfWeek, string StartTime = "", string EndTime = "", string SortField = "DayOfWeek", SortOption SortOrder = SortOption.Ascending)
        {
            try
            {
                string SQL = "CALL procParkingRateSelect(@ParkingRateID, @ProductID, @DayOfWeek, @StartTime, @EndTime, @SortField, @SortOrder)";

                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@ParkingRateID", ParkingRateID);
                cmd.Parameters.AddWithValue("@ProductID", ProductID);
                cmd.Parameters.AddWithValue("@DayOfWeek", DayOfWeek);
                cmd.Parameters.AddWithValue("@StartTime", StartTime);
                cmd.Parameters.AddWithValue("@EndTime", EndTime);
                cmd.Parameters.AddWithValue("@SortField", SortField);
                cmd.Parameters.AddWithValue("@SortOrder", SortOrder == SortOption.Ascending ? "ASC" : "DESC");

                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);
            }
        }
Ejemplo n.º 60
0
        public System.Data.DataTable ListAsDataTable(Int64 MainProductID, string SortField = "CompositionID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = SQLSelect() + "WHERE MainProductID = @MainProductID ";

                cmd.Parameters.AddWithValue("@MainProductID", MainProductID);

                SQL += "ORDER BY " + SortField + " ";
                SQL += SortOrder == SortOption.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);
            }
        }