public static int CreateSpender(SpenderModels model)
{
using (SqliteConnection db = new SqliteConnection("DataSource=app.db"))
{
string query = @"INSERT INTO main.Spenders (Id, Nickname, SignupDate, Name) Values (@Id, @Nickname, @SignupDate, @Name);";
return(db.Execute(query, model));
}
}
public ActionResult Index(SpenderModels inModel)
{
if (ModelState.IsValid)
{
string name = User.Identity.Name;
string id = DataAccess.GetIdUsingName(name);
SpenderModels model = new SpenderModels(id, inModel.Nickname, name);
SpenderLogic.CreateSpender(model);
ViewBag.SpenderRegistered = SpenderLogic.HasSpenderRegistered(id);
}
return(RedirectToAction("Home", "SpendingTracker"));
}
