/// <summary>
 /// Returns a table with Date and Wishlist amount entered on that date.
 /// </summary>
 /// <param name="days">For the past how many days (Enter -1 for all)</param>
 /// <returns></returns>
 public static object GetPickListSummary(int days)
 {
     string query;
     if (days == -1)
         query = HCMIS.Repository.Queries.PickList.SelectGetPickListSummary();
     else
         query = HCMIS.Repository.Queries.PickList.SelectGetPickListSummary(days);
     PickList pl = new PickList();
     pl.LoadFromRawSql(query);
     return pl.DefaultView;
 }
Example #2
0
        /// <summary>
        /// Returns a table with Date and Wishlist amount entered on that date.
        /// </summary>
        /// <param name="days">For the past how many days (Enter -1 for all)</param>
        /// <returns></returns>
        public static object GetPickListSummary(int days)
        {
            string query;

            if (days == -1)
            {
                query = HCMIS.Repository.Queries.PickList.SelectGetPickListSummary();
            }
            else
            {
                query = HCMIS.Repository.Queries.PickList.SelectGetPickListSummary(days);
            }
            PickList pl = new PickList();

            pl.LoadFromRawSql(query);
            return(pl.DefaultView);
        }