public static TSWCatalogsList GetAllMarkets(TSWCatalogs parItem)
{
TSWCatalogsList retval = new TSWCatalogsList();
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "usp_Markets"))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList GetAllPersonnelNamesPerSite(TSWCatalogs parItem)
{
TSWCatalogsList retval = new TSWCatalogsList();
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@FromLive", parItem.FromLive),
new SqlParameter("@SiteID", parItem.SiteID),
new SqlParameter("@TitleID", 1), //Per Angel if we pass a number different than 46 should bring all the personnel for that site.
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_SearchForPersonnel", param))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList GetCampaigns(TSWCatalogs paritem)
{
TSWCatalogsList retval = new TSWCatalogsList();
//SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
//pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@FromLive", paritem.FromLive),
new SqlParameter("@SiteID", paritem.SiteID)
//pOut
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetCampaigns", param))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
//count = Helper.ToInt32(pOut.Value);
return retval;
}
public static TSWCatalogsList GetCatalogs(TSWCatalogs value)
{
TSWCatalogsList retval = new TSWCatalogsList();
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@inSiteId ", value.SiteID),
new SqlParameter("@inLookupName", value.CLookUpName),
new SqlParameter("@FromLive", value.FromLive)
};
//WebAPI_GetMaritalStatus
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "Select_TSW_Catalogs", param))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList Get_TSW_States()
{
TSWCatalogsList retval = new TSWCatalogsList();
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "sel_TSW_States"))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList GetTSWCountriesAndStates(TSWCatalogs value)
{
TSWCatalogsList retval = new TSWCatalogsList();
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@TSWStateID", value.TSWStateID),
new SqlParameter("@TSWCountryID", value.TSWCountryID),
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "sel_Rel_States_Ctry"))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList GetPromotorNames(TSWCatalogs parItem)
{
TSWCatalogsList retval = new TSWCatalogsList();
//SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
//pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@FromLive", parItem.FromLive),
new SqlParameter("@SiteID", parItem.SiteID),
new SqlParameter("@TitleID", 46), //Meaning VC Concierge it's ok to leave it like this 6/24
//new SqlParameter("@TeamID", 11) //GMC Marketing. We don't need it any more 6/24
//pOut
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_SearchForPersonnel", param))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
//count = Helper.ToInt32(pOut.Value);
return retval;
}
public static TSWCatalogsList GetTourLocations(TSWCatalogs parItem)
{
TSWCatalogsList retval = new TSWCatalogsList();
//SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
//pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@inDBName", parItem.DBName),
new SqlParameter("@SiteId", parItem.SiteID)
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetTourLocations", param))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList GetPremiumsBackFromTSW(int FromLive, int TourId)
{
TSWCatalogsList retval = new TSWCatalogsList();
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@FromLive", FromLive),
new SqlParameter("@TourID", TourId)
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetTourPremiums", param))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList GetOcuppations(TSWCatalogs value)
{
TSWCatalogsList retval = new TSWCatalogsList();
//SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
//pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@parSiteId", value.SiteID),
new SqlParameter("@FromLive", value.FromLive),
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetOccupations"))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList GetNQReason()
{
TSWCatalogsList retval = new TSWCatalogsList();
SqlParameter[] param = new SqlParameter[]{
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetNQReasons"))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList GetMaritalStatus1(TSWCatalogs value)
{
TSWCatalogsList retval = new TSWCatalogsList();
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@parSiteId", value.SiteID)
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "Select_MaritalStatus"))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
public static TSWCatalogsList GetIncome(TSWCatalogs value)
{
TSWCatalogsList retval = new TSWCatalogsList();
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@FromLive", value.FromLive),
new SqlParameter("@SiteID", value.SiteID)
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetIncomeBySite", param))
{
//throw new Exception(reader.GetSqlValues());
while (reader.Read())
{
retval.Add(Read(reader));
}
}
return retval;
}
