public IEnumerable <Orders> GetOrderListUsingSP(string Period, string PeriodYear) { try { return(PSF.ExecuteStoredProcedure <Orders>("GetOrderList", new[] { new SqlParameter("Period", Period), new SqlParameter("PeriodYear", PeriodYear) })); } catch (Exception ex) { throw ex; } }