//private List<PasswordAccount> GetAccountsData()
//{
// //List<PasswordAccount> accounts = new List<PasswordAccount>();
// //accounts.Add(new PasswordAccount { Id = 1, AccountName = "Turbo Tax", Url = "", UserName = "******", Password = "******", AccountOwner = "Jim" });
// //accounts.Add(new PasswordAccount { Id = 2, AccountName = "Verizon Wireless" , Url = "", UserName = "******", Password = "******", AccountOwner = "Jim & Carolyn"});
// //accounts.Add(new PasswordAccount { Id = 3, AccountName = "Health Equity", Url = "", UserName = "******", Password = "******", AccountOwner = "Jim" });
// //return accounts;
//}
public void SaveAccount(PasswordAccount account)
{
sqlitePasswordManager.SaveAccount(account);
//if (account.Id == 0)
//{
// account.Id = GetNewAccountId();
//}
}
public void SaveAccount(PasswordAccount account)
{
using (var connection = CreateConnection())
{
connection.Open();
using (var transaction = connection.BeginTransaction())
{
if (account.Id == 0)
{
connection.Execute("INSERT INTO PasswordAccount(AccountName, Url, UserName, Password, AccountOwner, SecurityQuestions) VALUES (?,?,?,?,?,?)",
new { account.AccountName, account.Url, account.UserName, account.Password, account.AccountOwner, account.SecurityQuestions });
account.Id = (int)connection.LastInsertRowId;
}
else
{
connection.Execute("UPDATE PasswordAccount SET AccountName = ?, Url = ?, UserName = ?, Password = ?, AccountOwner = ?, SecurityQuestions = ? WHERE Id = ?",
new { account.AccountName, account.Url, account.UserName, account.Password, account.AccountOwner, account.SecurityQuestions, account.Id });
}
transaction.Commit();
}
}
}
public ActionResult SaveAccount(PasswordAccount model)
{
passwordManager.SaveAccount(model);
return(RedirectToAction("Index", "PasswordAccount"));
}
public ActionResult AddAccount()
{
var model = new PasswordAccount();
return(View("AddPasswordAccount", model));
}
