public static TSWTourList InsertTSW_Tour(TSWTour value)
{
//string prospectId = "";
TSWTourList retval = new TSWTourList();
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@FromLive", value.FromLive),
new SqlParameter("@SiteID", value.SiteID),
new SqlParameter("@ProspectID", value.ProspectId),
new SqlParameter("@CampaignID", value.CampaignID),
new SqlParameter("@TourTypeID", value.TourTypeID),
new SqlParameter("@TourLocationID", value.TourLocationID),
new SqlParameter("@TourDate", value.TourDate),
new SqlParameter("@PreAssignedTo", ""),
new SqlParameter("@WaveID", value.waveID)
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_CreateBookedTour", param))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
//count = Helper.ToInt32(pOut.Value);
return retval;
}
public static TSWTourList GetWaves(TSWTour parItem)
{
TSWTourList retval = new TSWTourList();
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@inDBName", parItem.DBName),
new SqlParameter("@inSiteId", parItem.SiteID),
new SqlParameter("@inTourLocationID", parItem.TourLocationID),
new SqlParameter("@inDate", parItem.TourDate),
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetWaves", param))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
//count = Helper.ToInt32(pOut.Value);
return retval;
}
