public ActionResult ViewDetails(int id)
{
Account account = context.Accounts.Find(id);
account.Password = passwordHelper.DecryptPassword(account.Password);
return(PartialView(account));
}
private bool VerifyAuthentication(string username, string password, int truckId)
{
bool result = false;
var user = db.Users.FirstOrDefault(u => u.Username == username && u.IsActive && !u.IsLockedOut);
if (user != null)
{
var clearPassword = PasswordHelper.DecryptPassword(user.Password);
result = clearPassword == password;
var truck = db.Trucks.FirstOrDefault(t => t.TripApiUserId == user.UserId);
result = result && truck != null && truck.TruckId == truckId;
}
return(result);
}
public static IDbConnection GetConnection(dbplatformdefinition pDbPlatformDef, projectsettingsDbplatformsDbplatform pDbPlatform)
{
// Aktuellen provider+providerdef ermitteln
projectsettingsDbplatformsDbplatformDbprovidersDbprovider provider = null;
foreach (projectsettingsDbplatformsDbplatformDbprovidersDbprovider p in pDbPlatform.dbproviders.dbprovider)
{
if (p.name.Equals(pDbPlatform.dbproviders.selected))
{
provider = p;
break;
}
}
if (provider == null)
{
throw new PVException("No or invalid db provider selected.");
}
dbplatformdefinitionDbproviderdefinition providerdef = null;
foreach (dbplatformdefinitionDbproviderdefinition pd in pDbPlatformDef.dbproviderdefinitions)
{
if (pd.name.Equals(provider.name))
{
providerdef = pd;
break;
}
}
if (providerdef == null)
{
throw new PVException("No provider definition found for provider '" + provider.name + "'.");
}
string strConnect = providerdef.connectionstring;
if (provider.parameters != null)
{
foreach (parametersParameter param in provider.parameters)
{
string strValue = param.Value;
if (param.name.Equals("password"))
{
try {
strValue = PasswordHelper.DecryptPassword(strValue);
}
catch (Exception) {}
}
strConnect = strConnect.Replace("{" + param.name + "}", strValue);
}
}
Assembly asm = null;
try {
asm = Assembly.Load(providerdef.providerassembly);
}
catch (Exception ex) {
try {
asm = Assembly.LoadWithPartialName(providerdef.providerassembly);
}
catch (Exception) {
throw ex;
}
}
IDbConnection con = (IDbConnection)asm.CreateInstance(providerdef.providerclass);
con.ConnectionString = strConnect;
con.Open();
return(con);
}
