public List <RoomNames> Retrieve()
{
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
var sqlRequest =
string.Format(@"select * from roomnames");
using (var cmd = new SqlCommand(sqlRequest, connection))
{
connection.Open();
var sqlDataReader = cmd.ExecuteReader();
var roomNameList = new List <RoomNames>();
while (sqlDataReader.Read())
{
var roomName = new RoomNames
{
RoomNameId = sqlDataReader.GetFieldValue <int>(sqlDataReader.GetOrdinal("id")),
RoomName = sqlDataReader.GetFieldValue <string>(sqlDataReader.GetOrdinal("roomname"))
};
roomNameList.Add(roomName);
}
return(roomNameList);
}
}
}
/// <summary>
/// Получить список комнат пользователя
/// </summary>
/// <param name="login">Логин пользователя</param>
/// <returns>Список названий комнат</returns>
public List <RoomNames> Retrieve(string login)
{
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
var sqlRequest =
string.Format(@"select * from rooms join users on users.id = rooms.userid join roomnames on rooms.id = roomnames.id WHERE login = '******'", login);
using (var cmd = new SqlCommand(sqlRequest, connection))
{
connection.Open();
var sqlDataReader = cmd.ExecuteReader();
var roomNames = new List <RoomNames>();
while (sqlDataReader.Read())
{
var roomName = new RoomNames
{
RoomNameId = sqlDataReader.GetFieldValue <int>(sqlDataReader.GetOrdinal("ID")),
RoomName = sqlDataReader.GetFieldValue <string>(sqlDataReader.GetOrdinal("ROOMNAME"))
};
}
return(roomNames);
}
}
}