public ActionResult Aanpassen(int?id)
{
if (!id.HasValue)
{
return(RedirectToAction("Index"));
}
ItOrganisation org = organisatie.Find(o => o.Id == id.Value) as ItOrganisation;
return(View("Aanpassen", org));
}
public ActionResult Aanpassen(ItOrganisation org)
{
if (!ModelState.IsValid)
{
return(View("Aanpassen", org));
}
int getal = VerenigingDA.UpdateVereniging(org);
return(RedirectToAction("index"));
}
public static int UpdateVereniging(ItOrganisation org)
{
string sql = "Update Organisations Set OrganisationName = @OrganisationName, Address = @Address, Email = @Email, Phone = @Phone where Id = @Id";
DbParameter par1 = Database.addParameter("AdminConnection", "@OrganisationName", org.OrganistionName);
DbParameter par2 = Database.addParameter("AdminConnection", "@Address", org.Address);
DbParameter par3 = Database.addParameter("AdminConnection", "@Email", org.Email);
DbParameter par4 = Database.addParameter("AdminConnection", "@Phone", org.Phone);
DbParameter par5 = Database.addParameter("AdminConnection", "@Id", org.Id);
return(Database.ModifyData("AdminConnection", sql, par1, par2, par3, par4, par5));
}
public static List <ItOrganisation> getVerenigingen()
{
List <ItOrganisation> resultaat = new List <ItOrganisation>();
DbDataReader reader = Database.GetData("AdminConnection", "select Id,Login,Password,DbName,DbLogin,DbPassword,OrganisationName, Address, Email, Phone from organisations");
while (reader.Read())
{
ItOrganisation org = CreateOrganisation(reader);
resultaat.Add(org);
}
reader.Close();
return(resultaat);
}
public ActionResult Nieuw(ItOrganisation org)
{
if (!ModelState.IsValid)
{
return(View("Nieuw", org));
}
org.DbLogin = Cryptography.Encrypt(org.DbLogin);
org.DbName = Cryptography.Encrypt(org.DbName);
org.DBpass = Cryptography.Encrypt(org.DBpass);
org.Login = Cryptography.Encrypt(org.Login);
org.Pass = Cryptography.Encrypt(org.Pass);
int id = VerenigingDA.NieuweVerenigingToevoegen(org);
ItOrganisation organisat = VerenigingDA.getVereniging(id);
OrganisatieCreateDatabase.CreateDatabase(organisat);
return(RedirectToAction("index"));
}
public override Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
ItOrganisation o = OrganisationDA.GetOrganisationByLoginAndPassword(context.UserName, context.Password);
if (o == null)
{
context.Rejected();
return(Task.FromResult(0));
}
var id = new ClaimsIdentity(context.Options.AuthenticationType);
id.AddClaim(new Claim("dbname", o.DbName));
id.AddClaim(new Claim("dblogin", o.DbLogin));
id.AddClaim(new Claim("dbpass", o.DBpass));
context.Validated(id);
return(Task.FromResult(0));
}
public static int NieuweVerenigingToevoegen(ItOrganisation org)
{
try
{
//wachtwoorden nog encrypteren
string sql = "INSERT INTO Organisations (Login,Password,DbName,DbLogin,DbPassword,OrganisationName,Address,Email,Phone) VALUES (@Login,@Password,@DbName,@DbLogin,@DbPassword,@OrganisationName,@Address,@Email,@Phone)";
DbParameter par1 = Database.addParameter("AdminConnection", "@Login", org.Login);
DbParameter par2 = Database.addParameter("AdminConnection", "@Password", org.Pass);
DbParameter par3 = Database.addParameter("AdminConnection", "@DbName", org.DbName);
DbParameter par4 = Database.addParameter("AdminConnection", "@DbPassword", org.DBpass);
DbParameter par5 = Database.addParameter("AdminConnection", "@OrganisationName", org.OrganistionName);
DbParameter par6 = Database.addParameter("AdminConnection", "@Address", org.Address);
DbParameter par7 = Database.addParameter("AdminConnection", "@Email", org.Email);
DbParameter par8 = Database.addParameter("AdminConnection", "@Phone", org.Phone);
DbParameter par9 = Database.addParameter("AdminConnection", "@DbLogin", org.DbLogin);
return(Database.InsertData("AdminConnection", sql, par1, par2, par3, par4, par5, par6, par7, par8, par9));
}
catch {
return(0);
}
}
//gemaakt door frederik duchi
public static void CreateDatabase(ItOrganisation o)
{
try
{
// create the actual database
string create = System.IO.File.ReadAllText(HostingEnvironment.MapPath(@"~/App_Data/createDatabase/create.txt"));
//string create = System.IO.File.ReadAllText(@"App_Data/createDatabase/create.txt");// only for desktop
string sql = create.Replace("@@DbName", o.DbName).Replace("@@DbLogin", o.DbLogin).Replace("@@DbPassword", o.DBpass);
foreach (string commandText in RemoveGo(sql))
{
Database.ModifyData("AdminConnection", commandText);
}
}
catch
{
}
// create login, user and tables
DbTransaction trans = null;
try
{
trans = Database.BeginTransaction("AdminConnection");
string fill = System.IO.File.ReadAllText(HostingEnvironment.MapPath(@"~/App_Data/createDatabase/fill.txt"));
//string fill = System.IO.File.ReadAllText(@"App_Data/createDatabase/fill.txt"); // only for desktop
string sql2 = fill.Replace("@@DbName", o.DbName).Replace("@@DbLogin", o.DbLogin).Replace("@@DbPassword", o.DBpass);
foreach (string commandText in RemoveGo(sql2))
{
Database.ModifyData(trans, commandText);
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
Console.WriteLine(ex.Message);
}
}
public ActionResult Nieuw()
{
ItOrganisation org = new ItOrganisation();
return(View(org));
}
