public static bool Register(User user)
{
// TODO: Register log ekle
if (!UserExists(user))
{
string query = "Insert into [User](Fullname , Email , Username , Password , RegistrationDate, IsAdmin) Values (@fullname, @email , @username , @password , @registerdate, 0)";
SqlCommand command = new SqlCommand(query, _connection);
command.Parameters.AddWithValue("@fullname", user.FullName);
command.Parameters.AddWithValue("@email", user.Email);
command.Parameters.AddWithValue("@username", user.Username);
command.Parameters.AddWithValue("@password", user.Password);
command.Parameters.AddWithValue("@registerdate", user.RegistrationDate);
int rowCount = command.ExecuteNonQuery();
return rowCount != 0;
}
return false;
}
public static bool UserExists(User user)
{
string query = "SELECT 1 FROM [User] WHERE Username = @username or Email = @email";
SqlCommand command = new SqlCommand(query, _connection);
command.Parameters.AddWithValue("@username", user.Username);
command.Parameters.AddWithValue("@email", user.Email);
var results = command.ExecuteScalar();
return results != null;
}
public static List<User> GetUsers()
{
List<User> users = new List<User>();
string query = "SELECT UserId, FullName, Username, Email, RegistrationDate, IsAdmin FROM dbo.[User]";
SqlCommand command = new SqlCommand(query, _connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
User u = new User()
{
UserId = reader.GetGuid(0),
FullName = reader.GetString(1),
Username = reader.GetString(2),
Email = reader.GetString(3),
RegistrationDate = reader.GetDateTime(4),
IsAdmin = reader.GetBoolean(5)
};
users.Add(u);
}
}
return users;
}
