/// <summary>
///
/// </summary>
/// <param name="touristID"></param>
/// <returns></returns>
public TourList TourListByTourist(Guid touristID)
{
TourList tlist = new TourList();
Tour t;
SqlCommand command;
SqlParameter paramTouristID = new SqlParameter("@IDUtilizador", SqlDbType.UniqueIdentifier);
command = new SqlCommand("PercursosUtilizador", this.connection);
command.CommandType = CommandType.StoredProcedure;
paramTouristID.Value = touristID;
command.Parameters.Add(paramTouristID);
this.reader = command.ExecuteReader();
while (this.reader.Read())
{
t = new Tour();
t.tourID = Int32.Parse(reader["ID"].ToString());
t.cityID = Int32.Parse(reader["IDCidade"].ToString());
t.cityName = reader["NOME"].ToString();
t.begin = DateTime.Parse(reader["DATA_HORA_INICIO"].ToString());
tlist.tours.Add(t);
}
this.reader.Close();
return(tlist);
}
public TourList TourListForTourist(String username, String password)
{
TourList tlist = new TourList();
//if (Membership.ValidateUser(username, password))
//{
//Guid guid = (Guid)Membership.GetUser(username).ProviderUserKey;
Guid guid = new Guid("12345678-9012-3456-7890-123456789013");
Database database = new Database();
database.connect();
tlist = database.Query.TourListByTourist(guid);
database.disconnect();
tlist.authenticated = true;
//}
return(tlist);
}
public TourList TourListForTourist(String username, String password)
{
TourList tlist = new TourList();
//if (Membership.ValidateUser(username, password))
//{
//Guid guid = (Guid)Membership.GetUser(username).ProviderUserKey;
Guid guid = new Guid("12345678-9012-3456-7890-123456789013");
Database database = new Database();
database.connect();
tlist = database.Query.TourListByTourist(guid);
database.disconnect();
tlist.authenticated = true;
//}
return tlist;
}
/// <summary>
///
/// </summary>
/// <param name="touristID"></param>
/// <returns></returns>
public TourList TourListByTourist(Guid touristID)
{
TourList tlist = new TourList();
Tour t;
SqlCommand command;
SqlParameter paramTouristID = new SqlParameter("@IDUtilizador", SqlDbType.UniqueIdentifier);
command = new SqlCommand("PercursosUtilizador", this.connection);
command.CommandType = CommandType.StoredProcedure;
paramTouristID.Value = touristID;
command.Parameters.Add(paramTouristID);
this.reader = command.ExecuteReader();
while (this.reader.Read())
{
t = new Tour();
t.tourID = Int32.Parse(reader["ID"].ToString());
t.cityID = Int32.Parse(reader["IDCidade"].ToString());
t.cityName = reader["NOME"].ToString();
t.begin = DateTime.Parse(reader["DATA_HORA_INICIO"].ToString());
tlist.tours.Add(t);
}
this.reader.Close();
return tlist;
}
