private bool checkUser() { List <User> users = new List <User>(); string sqlInquiryString = $"SELECT * FROM users_authorization where login = '******'"; using var connection = new MySqlConnection(createConnection.ConnectionString()); connection.Open(); MySqlCommand command = new MySqlCommand(sqlInquiryString, connection); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { users.Add(new User { Login = reader["login"].ToString(), Password = reader["password"].ToString() }); } } if (users.Any(u => u.Password.Equals(Password))) { return(true); } else { return(false); } }
private void getInformationAboutCalls() { string sqlInquiryString = $"SELECT * FROM leads_and_calls WHERE login = '******'"; using var connection = new MySqlConnection(createConnection.ConnectionString()); connection.Open(); MySqlCommand command = new MySqlCommand(sqlInquiryString, connection); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Calls.Add(new AboutCall { ClientInformation = reader["client_phone_number"].ToString() + " " + reader["create_lead_date"].ToString() + " " + reader["lead_stats"].ToString(), CallMadeDate = reader["lead_call_date"].ToString(), Login = reader["login"].ToString(), CallTime = reader["call_time"].ToString() }); } } }