public ActionResult Register(Register model)
{
string passwort = FormsAuthentication.HashPasswordForStoringInConfigFile(model.passwort, "SHA1");
DB.aendern("INSERT INTO " +
"Benutzer " +
"( vorname, nachname, email, studiengang, fachsemester, strasse, hausnummer, wohnort, plz, passwort, rechte, freischaltung, matrikelnummer, institut, stellvertreter) " +
"VALUES " +
"(" +
"'" + model.vorname + "', '" + model.nachname + "', '" + model.email + "', '" + model.studiengang + "', " + model.fachsemester + ", '" + model.strasse + "', '" + model.hausnummer + "', '" + model.wohnort + "', " +
model.plz + ", '" + passwort + "', 0, 1, " + model.matrikelnummer + ", '" + model.institut + "', 12)");
return RedirectToAction("Index");
}
/**
* speichert den übergebenen Benutzer in der Datenbank
*/
private bool SaveUserToDB(Register user)
{
string query = "INSERT INTO " +
"Benutzer " +
"(" +
"vorname, " +
"nachname, " +
"email, " +
"studiengang, " +
"fachsemester, " +
"strasse, " +
"hausnummer, " +
"wohnort, " +
"plz, " +
"passwort, " +
"rechte, " +
"freischaltung, " +
"matrikelnummer, " +
"institut, " +
"stellvertreter" +
") " +
"VALUES " +
"(" +
"'" + user.vorname + "', " +
"'" + user.nachname + "', " +
"'" + user.email + "', " +
"'" + user.studiengang + "', " +
user.fachsemester + ", " +
"'" + user.strasse + "', " +
"'" + user.hausnummer + "', " +
"'" + user.wohnort + "', " +
user.plz + ", " +
"'" + user.passwort + "', " +
user.rechte + ", " +
user.freischaltung + ", " +
user.matrikelnummer + ", " +
"'" + user.institut + "', " +
user.stellvertreter +
")";
DB.aendern(query);
return true;
}
//Benutzer registrieren
public ActionResult Register()
{
var model = new Register();
return View(model);
}
