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