Пример #1
0
        internal int postUser(User user)
        {
            HashAndSalt pwSecurity = new HashAndSalt();
            int         result     = -999999;
            string      password   = user.Password;
            string      salt       = pwSecurity.getSalt();
            //.GenerateHash(password, salt, 0) the last 0 is the starting value for the recursive iteration counter
            string saltedPassword = pwSecurity.GenerateHash(password, salt, 0);

            password      = ""; //ERASING IT FROM MEMORY
            user.Password = saltedPassword;
            user.Salt     = salt;

            rulesencyclopediaDBEntities1 context = new rulesencyclopediaDBEntities1();

            try
            {
                //getting back the key for the created user.
                context.User.Add(user);
                result = context.SaveChanges();
            }
            catch (EntityException ex)
            {
                exHandler.exceptionHandlerEntity(ex, "something went wrong when posting user");
            }
            finally
            {
                context.Dispose();
            }
            return(result);
        }
Пример #2
0
        internal int editUser(User alteredUser)
        {
            int result = -999999;
            rulesencyclopediaDBEntities1 context = new rulesencyclopediaDBEntities1();
            var user = context.User.First(a => a.Id == alteredUser.Id);

            user.FirstName  = alteredUser.FirstName;
            user.MiddleName = alteredUser.MiddleName;
            user.LastName   = alteredUser.LastName;
            user.UserName   = alteredUser.UserName;
            user.Password   = alteredUser.Password;
            user.Date       = alteredUser.Date;
            try
            {
                result = context.SaveChanges();
            } catch (EntityException ex)
            {
                exHandler.exceptionHandlerEntity(ex, "something went wrong when editing user");
            }
            finally
            {
                context.Dispose();
            }
            return(result);
        }
Пример #3
0
        internal int deleteUser(int ID)
        {
            int result = -999999;

            try
            {
                var context = new rulesencyclopediaDBEntities1();
                {
                    var user = new User {
                        Id = ID
                    };
                    context.User.Attach(user);
                    context.User.Remove(user);
                    result = context.SaveChanges();
                }
            }catch (EntityException ex)
            {
                exHandler.exceptionHandlerEntity(ex, "Something went wrong while deleting the user");
            }
            return(result);
        }