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(); } }