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