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 GetMarkets()
//{
// TSWCatalogsList retval = new TSWCatalogsList();
// //SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
// //pOut.Direction = ParameterDirection.Output;
// 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 TSWCatalogs Read(SqlDataReader reader)
{
TSWCatalogs retval = new TSWCatalogs();
for (int i = 0; i < reader.FieldCount; i++)
{
switch (reader.GetName(i))
{
case "SiteID":
retval.SiteID = Helper.ToInt32(reader[i]);
break;
case "tourlocationid":
retval.TourLocationID = Helper.ToInt32(reader[i]);
break;
case "location": //tourLocation
retval.TourLocation = Helper.ToString(reader[i]);
break;
case "TourDescription":
retval.TourDescription = Helper.ToString(reader[i]);
break;
case "PersonnelID":
retval.PersonnelID = Helper.ToString(reader[i]);
break;
case "LastName":
retval.LastName = Helper.ToString(reader[i]);
break;
case "FirstName":
retval.FirstName = Helper.ToString(reader[i]);
break;
case "CampaignID":
retval.CampaignID = Helper.ToString(reader[i]);
break;
case "CampaignName":
retval.CampaignName = Helper.ToString(reader[i]);
break;
case "PremInvID":
retval.PremInvID= Helper.ToString(reader[i]);
break;
case "PremInvTypeID":
retval.PremInvTypeID = Helper.ToInt32(reader[i]);
break;
case "PremName":
retval.PremDesc = Helper.ToString(reader[i]);
break;
case "Description":
retval.Description = Helper.ToString(reader[i]);
break;
case "CLookupID":
retval.CLookUpID = Helper.ToString(reader[i]);
break;
case "HotelDescription":
retval.HotelDescription = Helper.ToString(reader[i]);
break;
case "MaritalID":
retval.CLookUpID = Helper.ToString(reader[i]);
break;
case "MaritalStatus":
retval.Description = Helper.ToString(reader[i]);
break;
case "OccupationID":
retval.CLookUpID = Helper.ToString(reader[i]);
break;
case "Occupation":
retval.Description = Helper.ToString(reader[i]);
break;
case "IncomeID":
retval.CLookUpID = Helper.ToString(reader[i]);
break;
case "IncomeDescription":
retval.Description = Helper.ToString(reader[i]);
break;
case "LookupID":
retval.CLookUpID = Helper.ToString(reader[i]);
break;
case "InfoValue":
retval.Description = Helper.ToString(reader[i]);
break;
case "SIHOTHotelCode":
retval.SIHOTHotelCode = Helper.ToInt32(reader[i]);
break;
case "SIHOTVCCode":
retval.SIHOTVCCode = Helper.ToInt32(reader[i]);
break;
case "NQTypesID":
retval.NQTypesID = Helper.ToInt32(reader[i]);
break;
case "NQTypes":
retval.NQTypes = Helper.ToString(reader[i]);
break;
case "PromisedByName":
retval.PromisedByName = Helper.ToString(reader[i]);
break;
case "Quantity":
retval.Quantity = Helper.ToInt32(reader[i]);
break;
case "Amount":
retval.Amount = Helper.ToDecimal(reader[i]);
break;
case "AuditDate":
retval.AuditDate = Helper.ToDateTime(reader[i]);
break;
case "mkN":
retval.MarketDesc = Helper.ToString(reader[i]);
break;
case "mkID":
retval.MarketCode = Helper.ToString(reader[i]);
break;
case "Agency":
retval.Agency= Helper.ToString(reader[i]);
break;
case "TSWStateID":
retval.TSWStateID = Helper.ToString(reader[i]);
break;
case "TSWCountryID":
retval.TSWCountryID = Helper.ToString(reader[i]);
break;
case "StateID":
retval.StateID = Helper.ToString(reader[i]);
break;
case "CountryID":
retval.CountryID = Helper.ToString(reader[i]);
break;
case "CountryName":
retval.CountryName = Helper.ToString(reader[i]).Trim();
break;
case "State":
retval.State = Helper.ToString(reader[i]).Trim();
break;
//****
case "EmailTypeID":
retval.EmailTypeId = Helper.ToString(reader[i]).Trim();
break;
case "EmailType":
retval.EmailType = Helper.ToString(reader[i]).Trim();
break;
case "PhoneTypeID":
retval.PhoneTypeId = Helper.ToString(reader[i]).Trim();
break;
case "PhoneType":
retval.PhoneType = Helper.ToString(reader[i]).Trim();
break;
case "StateShort":
retval.StateShort = Helper.ToString(reader[i]).Trim();
break;
}
}
return retval;
}
private void PopulateAgencySegmentation(DropDownList ddlParameter)
{
TSWCatalogs parItem = new TSWCatalogs();
parItem.FromLive = 1;
TSWCatalogsList list = TSWCatalogsDB.GetAllAgencies(parItem);
ddlParameter.Items.Clear();
ddlParameter.Items.Add(new ListItem("Select..", ""));
//throw new Exception(list.Count.ToString());
foreach (TSWCatalogs item in list)
{
ddlParameter.Items.Add(new ListItem(item.Agency, item.Agency));
}
}
//Fills out with all the names after everything is filled out.
private void PopulatePromotorName(DropDownList ddlParameter)
{
TSWCatalogs parItem = new TSWCatalogs();
parItem.SiteID = SiteId;
parItem.FromLive = m_FromLive;
TSWCatalogsList list = TSWCatalogsDB.GetAllPersonnelNamesPerSite(parItem);
ddlParameter.Items.Clear();
ddlParameter.Items.Add(new ListItem("Select..", ""));
//throw new Exception(list.Count.ToString());
foreach (TSWCatalogs item in list)
{
ddlParameter.Items.Add(new ListItem(item.LastName + ", " + item.FirstName, item.PersonnelID.ToString()));
}
}
private void PopulateOccupations()
{
TSWCatalogs item = new TSWCatalogs();
item.FromLive = m_FromLive;
item.SiteID = SiteId;
item.CLookUpName = "occupation";
TSWCatalogsList list = TSWCatalogsDB.GetOcuppations(item);
ddlOccupation.Items.Add(new ListItem("Select..", ""));
//throw new Exception(list.Count.ToString());
foreach (TSWCatalogs items in list)
{
this.ddlOccupation.Items.Add(new ListItem(items.Description, items.CLookUpID.ToString()));
}
}
private void PopulateIncome()
{
TSWCatalogs itemIncome = new TSWCatalogs();
itemIncome.FromLive = m_FromLive;
itemIncome.SiteID = SiteId;
TSWCatalogsList list = TSWCatalogsDB.GetIncome(itemIncome);
ddlIncome.Items.Add(new ListItem("Select..", ""));
//throw new Exception(list.Count.ToString());
foreach (TSWCatalogs item in list)
{
this.ddlIncome.Items.Add(new ListItem(item.Description, item.CLookUpID.ToString()));
}
}
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 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 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;
}
public static TSWCatalogs GetHotelDescription(int parHotelCode, string parOrigin)
{
TSWCatalogs retval = new TSWCatalogs();
//SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
//pOut.Direction = ParameterDirection.Output;
//throw new Exception(parHotelCode.ToString() +", "+ parOrigin.ToString());
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@ParHotelCode", parHotelCode),
new SqlParameter("@ParOrigin", parOrigin.Trim())
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "Select_tblPMS_HotelDescription", param))
{
if (reader.Read())
{
retval = Read(reader);
//retval.Add(Read(reader));
}
}
return retval;
}
private void PopulateMarket(DropDownList ddlParameter)
{
TSWCatalogs parItem = new TSWCatalogs();
parItem.SiteID = SiteId;
parItem.FromLive = 1;
TSWCatalogsList list = TSWCatalogsDB.GetAllMarkets(parItem);
ddlParameter.Items.Clear();
ddlParameter.Items.Add(new ListItem("Select..", ""));
//throw new Exception(list.Count.ToString());
foreach (TSWCatalogs item in list)
{
ddlParameter.Items.Add(new ListItem(item.MarketDesc, item.MarketDesc));
}
}
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;
}
private void PopulateCampaing()
{
TSWCatalogs paritem = new TSWCatalogs();
paritem.FromLive = m_FromLive;
paritem.SiteID = SiteId;
TSWCatalogsList list = TSWCatalogsDB.GetCampaigns(paritem);
ddlCampaign.Items.Clear();
ddlCampaign.Items.Add(new ListItem("Select..", ""));
//throw new Exception(list.Count.ToString());
foreach (TSWCatalogs item in list)
{
this.ddlCampaign.Items.Add(new ListItem(item.CampaignName, item.CampaignID.ToString()));
}
}
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;
}
private void PopulateMaritalStatus1()
{
TSWCatalogs paritem = new TSWCatalogs();
paritem.SiteID = SiteId;
paritem.FromLive = m_FromLive;
TSWCatalogsList list = TSWCatalogsDB.GetMaritalStatus1(paritem);
ddlMarital1.Items.Add(new ListItem("Select...",""));
//throw new Exception(list.Count.ToString());
foreach (TSWCatalogs item in list)
{
ddlMarital1.Items.Add(new ListItem(item.Description, item.CLookUpID));
}
}
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;
}
private void PopulatePrizes()
{
TSWCatalogs parItem= new TSWCatalogs();
parItem.FromLive = m_FromLive;
parItem.CampaignID = ddlCampaign.SelectedValue;
parItem.SiteID = SiteId; //2
parItem.TourLocationID = Helper.ToInt32(ddlTourLocation.SelectedValue);
TSWCatalogsList list = TSWCatalogsDB.GetPrizes(parItem);
rptrPremiums.DataSource = list;
rptrPremiums.DataBind();
litPremiumsQty.Text = "<font color='blue' size='1' face='Arial' >" + rptrPremiums.Items.Count + " premiums available. </font>";
litPremiumsCaveat.Text = "<font color='blue' size='1' face='Arial'>To save your premiums, type in the amounts and click Book on the Booking Tab.</font>";
}
public static TSWCatalogs Get_RelationalStatesAndCountries_By_TSWStateID(int TSWStateID)
{
TSWCatalogs retval = new TSWCatalogs();
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@TSWStateID", TSWStateID)
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "Sel_RelationalStatesAndCountries_By_TSWStateID", param))
{
if (reader.Read())
{
retval = Read(reader);
//retval.Add(Read(reader));
}
}
return retval;
}
private void PopulateTourLocations()
{
TSWCatalogs paritem = new TSWCatalogs();
paritem.SiteID = SiteId;
if (m_FromLive == 0)
paritem.DBName = "tswpracticeSP1";
else
paritem.DBName = "TSWDATA";
ddlTourLocation.Items.Clear();
TSWCatalogsList list = TSWCatalogsDB.GetTourLocations(paritem);
ddlTourLocation.Items.Add(new ListItem("Select..", ""));
//throw new Exception(list.Count.ToString());
foreach (TSWCatalogs item in list)
{
ddlTourLocation.Items.Add(new ListItem(item.TourLocation, item.TourLocationID.ToString()));
}
}
//Fills out the states.
private void PopulateStates(DropDownList ddlParameter)
{
TSWCatalogs parItem = new TSWCatalogs();
TSWCatalogsList list = TSWCatalogsDB.Get_TSW_States();
ddlParameter.Items.Clear();
ddlParameter.Items.Add(new ListItem("Select..", ""));
//throw new Exception(list.Count.ToString());
foreach (TSWCatalogs item in list)
{
ddlParameter.Items.Add(new ListItem(item.State, item.StateID));
}
}
