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