public dynamic Login() { string username = Request["username"]; string password = Request["password"]; string branch = Request["branch"]; branch = branch.Equals("BRHCM") == true ? "TUIBANK_HCM" : "TUIBANK_HNO"; string CONNECTION_STRING = "metadata=res://*/Models.TUIBANK.csdl|res://*/Models.TUIBANK.ssdl|res://*/Models.TUIBANK.msl;provider=System.Data.SqlClient;provider connection string=\"data source=TUIBANK\\" + branch + ";initial catalog=TUIBANK;user id=" + username + ";password="******";MultipleActiveResultSets=True;App=EntityFramework\""; string SHORT = "Data Source = TUIBANK\\" + branch + "; Initial Catalog = TUIBANK; Persist Security Info = True; User ID =" + username + "; Password = "******"~"); connectionConfiguration.ConnectionStrings.ConnectionStrings["TUIBANKEntities"].ConnectionString = CONNECTION_STRING; connectionConfiguration.Save(ConfigurationSaveMode.Modified); ConfigurationManager.RefreshSection("connectionStrings"); // TODO: get role of user TUIBANKEntities db = new TUIBANKEntities(); string role = db.sp_get_role(username).ToList().ElementAt(0).ToString(); return(RedirectToAction("Index", "Home", new { role = role })); } catch (Exception ex) { return(ex.Message); } } else { return(-1); } }