public ISUser(int id, string fullName, string dateOfBirth, ISRoles role, ISGenders gender, string groupId, int studentTicketId, int roomId)
{
this.Id = id;
this.FullName = fullName;
this.DateOfBirth = dateOfBirth;
this.Role = role;
this.Gender = gender;
this.GroupId = groupId;
this.StudentTicketId = studentTicketId;
this.RoomId = roomId;
}
private static ISUser _ReadUserStream(MySqlDataReader reader)
{
int id = Convert.ToInt32(reader[0]);
string fullName = reader[1].ToString();
string dateOfBirth = reader[2].ToString();
ISRoles role = (ISRoles)Enum.Parse(typeof(ISRoles), reader[3].ToString());
ISGenders gender = (ISGenders)Enum.Parse(typeof(ISGenders), reader[4].ToString());
string groupId = reader[5].ToString();
string studTicket = reader[6].ToString();
int studentTicketId = studTicket.Length > 0 ? Convert.ToInt32(studTicket) : 0;
string room = reader[9].ToString();
int roomId = room.Length > 0 ? Convert.ToInt32(room) : 0;
return(new ISUser(id, fullName, dateOfBirth, role, gender, groupId, studentTicketId, roomId));
}
public static List <ISUser> GetRoomMates(ISUser user)
{
List <ISUser> roomMates = new List <ISUser>();
using (MySqlConnection conn = DBUtils.GetConnection())
{
try
{
conn.Open();
string query = $"SELECT * FROM users WHERE id != '{user.Id}' AND roomId = '{user.RoomId}'";
using (var command = new MySqlCommand(query, conn))
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
int id = Convert.ToInt32(reader[0]);
string fullName = reader[1].ToString();
string dateOfBirth = reader[2].ToString();
ISRoles role = (ISRoles)Enum.Parse(typeof(ISRoles), reader[3].ToString());
ISGenders gender = (ISGenders)Enum.Parse(typeof(ISGenders), reader[4].ToString());
string groupId = reader[5].ToString();
int studentTicketId = Convert.ToInt32(reader[6]);
int roomId = Convert.ToInt32(reader[9]);
roomMates.Add(new ISUser(id, fullName, dateOfBirth, role, gender, groupId, studentTicketId, roomId));
}
}
}
catch (Exception err)
{
MessageBox.Show("Error: " + err.Message, "Ошибка!");
}
}
return(roomMates);
}
public static string GetRoleString(ISRoles role)
{
return(ISRoleToStr[role]);
}
private void addUserButton_Click(object sender, EventArgs e)
{
string name = fullNameField.Text;
string birthDate = birthDateField.Value.ToString("yyyy-MM-dd");
ISGenders gender = Utils.GetGenderEnum(genderField.Text);
string genderStr = Enum.GetName(typeof(ISGenders), gender);
string groupId = groupIdField.Text;
ISRoles role = Utils.GetRoleEnum(roleField.Text);
string roleStr = Enum.GetName(typeof(ISRoles), role);
string studTicketId = studTicketIdField.Text;
string userName = userNameField.Text;
ISRoom room = ISRoom.GetRoomByName(rooms, roomIdField.Text);
if (name.Length > 0)
{
if (birthDate.Length > 0)
{
if (genderStr.Length > 0)
{
if (groupId.Length > 0)
{
if (roleStr.Length > 0)
{
if (studTicketId.Length > 0)
{
if (userName.Length > 0)
{
if (room.Id > 0)
{
if (DBUsers.AddUser(name, birthDate, roleStr, genderStr, groupId, studTicketId, userName, room.Id))
{
MessageBox.Show("Пользователь успешно добавлен!", "Успех!");
this.Close();
}
else
{
MessageBox.Show("Произошла ошибка");
}
}
else
{
MessageBox.Show("Необходимо выбрать комнату!", "Ошибка!");
userNameField.Focus();
}
}
else
{
MessageBox.Show("Необходимо ввести имя пользователя!", "Ошибка!");
userNameField.Focus();
}
}
else
{
MessageBox.Show("Необходимо ввести номер студенческого билета!", "Ошибка!");
studTicketIdField.Focus();
}
}
else
{
MessageBox.Show("Необходимо выбрать роль!", "Ошибка!");
roleField.Focus();
}
}
else
{
MessageBox.Show("Необходимо ввести название группы!", "Ошибка!");
groupIdField.Focus();
}
}
else
{
MessageBox.Show("Необходимо выбрать пол!", "Ошибка!");
genderField.Focus();
}
}
else
{
MessageBox.Show("Необходимо выбрать день роджения!", "Ошибка!");
birthDateField.Focus();
}
}
else
{
MessageBox.Show("Необходимо ввести ФИО", "Ошибка!");
fullNameField.Focus();
}
}
