public Entities.Avatar GetAvatarInfo(string name)
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand("SELECT Avatar, Type FROM dbo.UserAbout RIGHT JOIN Users ON Users.Login = UserAbout.Login Where Users.Login = @Login", con);
command.Parameters.Add(new SqlParameter("@Login", name));
con.Open();
Entities.Avatar info = new Entities.Avatar()
{
Login = name
};
int count = 0;
var reader = command.ExecuteReader();
while (reader.Read())
{
if (DBNull.Value.Equals(reader["Avatar"]))
{
info.Pic = null;
}
else
{
info.Pic = (byte[])reader["Avatar"];
}
if (DBNull.Value.Equals(reader["Type"]))
{
info.MimeType = null;
}
else
{
info.MimeType = (string)reader["Type"];
}
count++;
}
if (count < 0)
{
return(info = null);
}
else
{
return(info);
}
}
}
public bool AddAvatar(Entities.Avatar avatar)
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand("UPDATE dbo.UserAbout SET Avatar = @Pic, Type = @Type WHERE Login = @Login", con);
command.Parameters.Add(new SqlParameter("@Pic", avatar.Pic));
command.Parameters.Add(new SqlParameter("@Type", avatar.MimeType));
command.Parameters.Add(new SqlParameter("@Login", avatar.Login));
con.Open();
int count = command.ExecuteNonQuery();
if (count > 0)
{
logger.Info("DB: Аватр добавлен: " + avatar.Login);
return(true);
}
else
{
logger.Error("DB: Ошибка добавления аватара: " + avatar.Login);
return(false);
}
}
}
