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);
}
}
