user.dal

namespace Team4Calories.DAL
{
    public class UserRepository : Repository
    {
        public int Insert(User user)
        {
            using (IDbConnection dbConnection = Connection)
            {
                dbConnection.Open();
                return dbConnection.Query<InsertID>("Team4Calories.DAL.InsertUser", user, commandType: CommandType.StoredProcedure).First().ID;
            }
        }

        public void Delete(User user)
        {
            using (IDbConnection dbConnection = Connection)
            {
                dbConnection.Open();
                dbConnection.Execute("Team4Calories.DAL.DeleteUser", user, commandType: CommandType.StoredProcedure);
            }
        }

        public void Update(User user)
        {
            using (IDbConnection dbConnection = Connection)
            {
                dbConnection.Open();
                dbConnection.Execute("Team4Calories.DAL.UpdateUser", user, commandType: CommandType.StoredProcedure);
            }
        }


    }
}