public DataTable ExportWorkOrderExcel(WorkOrderViewModel model) { string spName = "stp_GetPostingOrderReportEquinox"; var parameterList = new[] { new SqlParameter("PeriodStart", SqlDbType.DateTime), new SqlParameter("PeriodEnd", SqlDbType.DateTime), new SqlParameter("Advertiser", SqlDbType.Int), new SqlParameter("AdvertiserContactID", SqlDbType.Int), new SqlParameter("SellerID", SqlDbType.Int), new SqlParameter("ContractNumber", SqlDbType.NVarChar), new SqlParameter("OrderType", SqlDbType.NVarChar) }; parameterList[0].Value = GetNullDate(model.FromDate); parameterList[1].Value = GetNullDate(model.ToDate); parameterList[2].Value = model.ProductionVendor; parameterList[3].Value = model.VendorRep; parameterList[4].Value = model.SellerID; parameterList[5].Value = model.ContractNumber; parameterList[6].Value = model.OrderType; DataTable data = _dapperRepository.ExecuteDataTableProc(spName, parameterList); return(data); }