public ActionResult SaveConnection(string ServerName, string DatabaseName, string UserName, string Password, string PortNumber = "", string UseSSL = "", string ActivateSSL = "") { facade = new Fasada(); try { facade = new Fasada(); var dt = facade.GetMysqlScheme(ServerName, DatabaseName, UserName, Password, PortNumber, UseSSL, ActivateSSL); var connectionString = facade.GetMySqlConnectionString(ServerName, DatabaseName, UserName, Password, PortNumber, UseSSL, ActivateSSL); using (var context = new SkyContext()) { var dataBaseType = context.DatabaseTypes.Where(a => a.DatabaseTypeID == 1).Select(a => a).FirstOrDefault(); connectionString += "[1]"; context.ConnectionStrings.Add(new ConnectionString() { Connection = connectionString, }); context.SaveChanges(); } } catch (Exception exception) { //log error @TempData["TestData"] = exception.Message; return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult RegisterPrivateUser(User user) { using (var context = new SkyContext()) { user.CreatedAccount = DateTime.Now; user.BirthdayDate = DateTime.Now; context.Users.Add(user); context.SaveChanges(); } TempData["Registration"] = "Yes"; return(RedirectToAction("LogIn", "Home")); }