public void EditAccount(AccountGridModel acct)
{
DbLink link = new DbLink();
using (SqlConnection conn = link.InitializeSqlConnection())
{
// Insert to the AB table.
SqlCommand comm = new SqlCommand("UPDATE dbo.tbl_AB SET AB_Amount = " + acct.AB + " WHERE Acct_Code = '" + acct.AcctCode + "'", conn);
conn.Open();
comm.ExecuteNonQuery();
}
}
public ActionResult Index(string name)
{
ObservableCollection <AccountGridModel> accountList = new ObservableCollection <AccountGridModel>();
List <S_User> userList;
if (String.IsNullOrEmpty(name))
{
userList = UserManager.GetUsers();
}
else
{
userList = UserManager.GetUsersByName(name);
if (userList.Count() == 0)
{
TempData["error"] = "Er zijn geen accounts gevonden.";
}
else
if (userList.Count() == 1)
{
TempData["message"] = "Er is 1 account gevonden.";
}
else
{
TempData["message"] = "Er zijn " + userList.Count().ToString() + " accounts gevonden.";
}
}
foreach (S_User user in userList)
{
AccountGridModel accountGridModel = new AccountGridModel();
accountGridModel.Id = user.id;
accountGridModel.Name = user.name;
accountGridModel.Address = user.address;
accountGridModel.City = user.city;
accountGridModel.Email = user.email;
accountGridModel.FrequentBowlerNumber = user.frequentbowlernumber;
accountList.Add(accountGridModel);
}
return(View(accountList));
}
