public static List <UserForProfile> getUsersByName(SqlConnection sqlConnection, string username)
{
sqlConnection.Close();
SqlCommand cmd = new SqlCommand(DBUtils.getUsersByNameCommand, sqlConnection);
cmd.Parameters.AddWithValue(nameWithAt(USERS_COLUMN_NAME), "%" + username + "%");
sqlConnection.Open();
List <UserForProfile> users = new List <UserForProfile>();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
UserForProfile user = new UserForProfile();
user.Id = reader.GetInt32(0);
user.UserName = reader.GetString(1);
user.Mail = reader.GetString(2);
if (!reader.IsDBNull(3))
{
user.City = reader.GetString(3);
}
if (!reader.IsDBNull(4))
{
user.VehicleMake = reader.GetString(4);
}
if (!reader.IsDBNull(5))
{
user.VehicleModel = reader.GetString(5);
}
if (!reader.IsDBNull(6))
{
user.Birthdate = reader.GetDateTime(6).ToShortDateString();
}
users.Add(user);
}
}
sqlConnection.Close();
return(users);
}
public static UserForProfile getUserForProfile(SqlConnection sqlConnection, int id)
{
sqlConnection.Close();
SqlCommand cmd = new SqlCommand(DBUtils.getUserCommand, sqlConnection);
cmd.Parameters.AddWithValue(nameWithAt(USERS_COLUMN_ID), id);
sqlConnection.Open();
UserForProfile user = null;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
user = new UserForProfile();
user.Id = reader.GetInt32(0);
user.UserName = reader.GetString(1);
user.Mail = reader.GetString(3);
if (!reader.IsDBNull(4))
{
user.City = reader.GetString(4);
}
if (!reader.IsDBNull(7))
{
user.VehicleMake = reader.GetString(7);
}
if (!reader.IsDBNull(8))
{
user.VehicleModel = reader.GetString(8);
}
if (!reader.IsDBNull(9))
{
user.Birthdate = reader.GetDateTime(9).ToShortDateString();
}
}
}
sqlConnection.Close();
return(user);
}