private void GetPasswordOptions(DatabaseModel databaseModel)
{
string sessionKey = $"{databaseModel.ServerName}||{databaseModel.DatabaseName}";
if (Connections.SessionPasswords.ContainsKey(sessionKey))
{
this._username = Connections.SessionPasswords[sessionKey].UserName;
this._password = Connections.SessionPasswords[sessionKey].Password;
return;
}
UserNameAndPasswordModel model = new UserNameAndPasswordModel
{
UserName = databaseModel.UserName,
Password = databaseModel.Password
};
UserNameAndPassword userPassword = new UserNameAndPassword(model);
bool?result = userPassword.ShowDialog();
if (!result.HasValue || !result.Value)
{
throw new ApplicationException("Operation canceled");
}
this._username = model.UserName;
this._password = model.Password;
Connections.SessionPasswords.Add(sessionKey, model);
}
public ActionResult showDetails(UserNameAndPassword credentials)
{
using (Entities db = new Entities())
{
var val = db.tbl_login.Where(m => m.Username == credentials.Username && m.password == credentials.password).FirstOrDefault();
if (val != null)
{
Session["UserName"] = credentials.Username;
return(RedirectToAction("Home", "Home"));
}
else
{
credentials.LoginErrorMSg = "UserName and password is Wrong";
TempData["Alert"] = credentials.LoginErrorMSg;
return(RedirectToAction("Index", "Login"));
}
}
}
