Beispiel #1
0
        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);
        }