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