public void CreateUser(string user, string email, bool active, string Password, string fname, string last_name) { Accountservice User = new Accountservice(); Tuple <byte[], byte[]> password = User.Generatepass(Password); postgres sql = new postgres(); // Behöver skrivas om! klart! postgres sql2 = new postgres(); int id = sql2.SqlQueryString("INSERT INTO login (salt, hash, reset_time, reset_hash) VALUES (@salt ,@hash, @time, 1) RETURNING login_id;", postgres.list = new List <NpgsqlParameter>() { new NpgsqlParameter("@salt", password.Item1), new NpgsqlParameter("@hash", password.Item2), new NpgsqlParameter("@time", Convert.ToDateTime("1970-01-01 00:00:00")) }); postgres sql3 = new postgres(); int id_setting = sql3.SqlQueryString("INSERT INTO usersettings (day_of_slumpcron) VALUES (6) RETURNING setting_id;", postgres.list = new List <NpgsqlParameter>() { }); sql.SqlNonQuery("INSERT INTO users (username,roles_id,email,acc_active,last_login,login_id,settings_id,fname,last_name) VALUES (@par1,'2',@email,@active,@last_login,@login_id,@settings_id,@fname,@last_name)", postgres.list = new List <NpgsqlParameter>() { new NpgsqlParameter("@par1", user), new NpgsqlParameter("@email", email), new NpgsqlParameter("@active", active), new NpgsqlParameter("@login_id", id), new NpgsqlParameter("@settings_id", id_setting), new NpgsqlParameter("@last_login", DateTime.Now), new NpgsqlParameter("@fname", fname), new NpgsqlParameter("@last_name", last_name) }); }
public ActionResult Newpassword(UserService model) { try { postgres sql = new postgres(); int id = sql.SqlQueryString("SELECT login_id FROM users WHERE user_id = @id", postgres.list = new List <NpgsqlParameter>() { new NpgsqlParameter("@id", Convert.ToInt16(User.Identity.Name)) }); _accountService.Newpassword(id, model.Password); return(RedirectToAction("index", "users")); } catch { return(View()); } }