public List <WorkOrderViewModel> GetWorkOrder(WorkOrderViewModel model) { string spName = "stp_GetPostingOrderReportEquinox"; var Params = new DynamicParameters(); Params.Add("PeriodStart", model.FromDate); Params.Add("PeriodEnd", model.ToDate); Params.Add("Advertiser", model.ProductionVendor); Params.Add("AdvertiserContactID", model.VendorRep); Params.Add("SellerID", model.SellerID); Params.Add("ContractNumber", model.ContractNumber); Params.Add("OrderType", model.OrderType); var data = _dapperRepository.ExecuteStoredProc <WorkOrderViewModel>(spName, Params).ToList(); return(data); }