public ActionResult NewUser(Users model)
{
try
{
Accountservice User = new Accountservice();
Tuple <byte[], byte[]> password = User.Generatepass(model.Password);
postgres sql = new postgres();
// Behöver skrivas om
sql.SqlNonQuery("INSERT INTO login (salt, key ,username,roles_id,email,acc_active,last_login) VALUES (@par2,@par3,@par1,'2',@email,@active,@last_login)", postgres.list = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@par1", model.User),
new NpgsqlParameter("@par2", password.Item1),
new NpgsqlParameter("@email", model.email),
new NpgsqlParameter("@active", model.active),
new NpgsqlParameter("@last_login", DateTime.Now),
new NpgsqlParameter("@par3", password.Item2)
});
return(RedirectToAction("index", "admin"));
}
catch
{
return(View());
}
}
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 void Newpassword(int login_id, string newpassword)
{
Accountservice User1 = new Accountservice();
Tuple <byte[], byte[]> password = User1.Generatepass(newpassword);
postgres sql = new postgres();
// behöver skrivas om! klart
sql.SqlNonQuery("UPDATE login set salt= @par2, hash =@par3 WHERE login_id =@par1", postgres.list = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@par1", login_id),
new NpgsqlParameter("@par2", password.Item1),
new NpgsqlParameter("@par3", password.Item2)
});
}
