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