public void UserDelete(string userNameForDeletion)
{
using (var db = new MenuShellDbContext())
{
var foundUser = db.Users.FirstOrDefault(x => x.Username == userNameForDeletion);
if (foundUser == null)
{
return;
}
db.Users.Remove(foundUser);
db.SaveChanges();
}
//var sqlCommand = new SqlCommand();
//string connectionString = "Data Source=(local);Initial Catalog=MenuShell;Integrated Security=true";
//using (var connection = new SqlConnection(connectionString))
//{
// connection.Open();
// string queryString = $"DELETE FROM [User] WHERE Username = '******'";
// sqlCommand = new SqlCommand(queryString, connection);
// sqlCommand.ExecuteReader();
// connection.Close();
//}
}
public void UserAdd(User userForAdding)
{
using (var context = new MenuShellDbContext())
{
context.Users.Add(userForAdding);
context.SaveChanges();
}
//var users = new List<User>();
//string connectionString = "Data Source=(local);Initial Catalog=MenuShell;Integrated Security=true";
//string queryString = $"INSERT INTO [User] VALUES('{userForAdding.Username}', '{userForAdding.Password}', " +
// $"'{userForAdding.Role}')";
//using (var connection = new SqlConnection(connectionString))
//{
// connection.Open();
// var sqlCommand = new SqlCommand(queryString, connection);
// sqlCommand = new SqlCommand(queryString, connection);
// sqlCommand.ExecuteReader();
// connection.Close();
//}
}
public List <User> UserList()
{
using (var db = new MenuShellDbContext())
{
var userList = db.Users.ToList();
return(userList);
}
//var sqlCommand = new SqlCommand();
//var userList = new List<User>();
//string connectionString = "Data Source=(local);Initial Catalog=MenuShell;Integrated Security=true";
//string queryString = $"SELECT [Username], [Password], [Role] FROM [User]";
//using (var connection = new SqlConnection(connectionString))
//{
// connection.Open();
// sqlCommand = new SqlCommand(queryString, connection);
// var reader = sqlCommand.ExecuteReader();
// userList = new List<User>();
// while (reader.Read())
// {
// userList.Add(new User(reader[0].ToString(), reader[1].ToString(), reader[2].ToString()));
// }
// connection.Close();
//}
//return userList;
}
public static void Main(string[] args)
{
using (var context = new MenuShellDbContext())
{
var users = context.Users.ToList();
}
var loginView = new LoginView();
loginView.Display();
}
public User LoadUsers(string userName)
{
using (var db = new MenuShellDbContext())
{
using (db)
{
var userList = db.Users.ToList();
foreach (var user in userList)
{
if (user.Username.StartsWith(userName))
{
return(user);
}
}
}
return(null);
}
//var users = new Dictionary<string, User>();
//string connectionString = "Data Source=(local);Initial Catalog=MenuShell;Integrated Security=true";
//string queryString = $"SELECT [Username], [Password], [Role] FROM [User] WHERE Username = '******'";
//using (var connection = new SqlConnection(connectionString))
//{
// connection.Open();
// var sqlCommand = new SqlCommand(queryString, connection);
// var reader = sqlCommand.ExecuteReader();
// while (reader.Read())
// {
// var user = new User(reader[0].ToString(), reader[1].ToString(), reader[2].ToString());
// return user;
// }
// connection.Close();
//}
}
public List <User> UserSearch(string searchString)
{
using (var db = new MenuShellDbContext())
{
var userList = db.Users.ToList();
var searchHits = new List <User>();
foreach (var user in userList)
{
if (user.Username.StartsWith(searchString))
{
searchHits.Add(user);
}
}
return(searchHits);
}
//var sqlCommand = new SqlCommand();
//string connectionString = "Data Source=(local);Initial Catalog=MenuShell;Integrated Security=true";
//using (var connection = new SqlConnection(connectionString))
//{
// connection.Open();
// string queryString = $"SELECT [Username], [Password], [Role] FROM [User] WHERE Username LIKE '{searchString}%'";
// sqlCommand = new SqlCommand(queryString, connection);
// var reader = sqlCommand.ExecuteReader();
// while (reader.Read())
// {
// searchHits.Add(new User(reader[0].ToString(), reader[1].ToString(), reader[2].ToString()));
// }
// connection.Close();
//}
}
public User Authenticate(string userName, string passWord)
{
using (var db = new MenuShellDbContext())
{
var userList = db.Users.ToList();
foreach (var user in userList)
{
if (user.Username == userName && user.Password == passWord)
{
return(user);
}
}
}
//string connectionString = "Data Source=(local);Initial Catalog=MenuShell;Integrated Security=true";
//string queryString = $"SELECT [Username], [Password], [Role] FROM [User] WHERE [Username] = '{userName}'";
//using (var connection = new SqlConnection(connectionString))
//{
// connection.Open();
// var sqlCommand = new SqlCommand(queryString, connection);
// var reader = sqlCommand.ExecuteReader();
// while (reader.Read())
// {
// var user = new User(reader[0].ToString(), reader[1].ToString(), reader[2].ToString());
// if (user.Username == userName && user.Password == passWord)
// {
// return user;
// }
// }
// connection.Close();
//}
return(null);
}
