Grocery list app

Question

Grocery list app

Matthew Zoljan 120

I am wanting to build a grocery app that automatically calculates what groceries you should buy and list the values on a separate content page.

There is a registration page that askes the user questions like how many people in household, shopping frequently, how many kgs of meat/vegetables/fruits a week, how many dozens of eggs a week, how many litres of milk per week, and loathes of bread.

So far I have created the registration page and have been able to store the values in a database. Some other irrelevant information right now is that the user is able to login and update their values in a page called 'Personalize'. That works fine.

What I am needing to know is how do I create a list of fruit, vegetables, kinds of meats, loathes of bread, milk, eggs. I need it installed into a database with their weight/amount then I need to be able to multiple the values by the database values that is being obtained from the registration page and 'Personalize' database.

Does anyone know of a similar app on say GitHub or a tutorial of an app performing similar calculations/functions. Then I can inspect it and get my head around how do I go about even attempting it. Or if someone can give me some tips here like what to do and what I'm doing wrong. So far any help is help for me now as I am totally stuck.

Anonymous

2023-05-18T05:57:17.64+00:00

how do I create a list of fruit, vegetables, kinds of meats, loathes of bread, milk, eggs.

Could you share a screenshot about your needs? If you want to a List, you can use ListView or CollectionView to implement it.

I need it installed into a database with their weight/amount then I need to be able to multiple the values by the database values that is being obtained from the registration page and 'Personalize' database.

Do you want to save weight/amount items in the other tables of SqliteDB?

Does anyone know of a similar app on say GitHub or a tutorial of an app performing similar calculations/functions.

Could you share details needs about calculations/functions? We can write it by ourselves.
Matthew Zoljan 120 Reputation points

2023-05-18T11:27:22.1933333+00:00
Hi Leon,

Thanks, as you can see below is the Personalized screen, where a user can update their weekly intake of the below grocery items in Kilograms, dozens of eggs per week, liters of mil per week, and loathes of bread a week.

The Meat, Fish, Vegetables, Fruit are in kilograms

The Milk is in litres

The loathes per week

Eggs a per dozen

Shopping is it's frequency

See screenshot below, let me know if you can't understand what I mean by above and the screenshot below but hopefully it provides some context.

Then I want to have it calculate how much groceries in kilos, liters, dozens, loathes of bread daily, weekly, biweekly and list the quantities of milk, loathes of bread, dozen of eggs, meat, vegetables and fruit on a list view page similar to below:

If you can show me an example of this with a handful of objects I can work it out from there. Thank you.
Anonymous

2023-05-19T09:09:15.5833333+00:00

Do you want to get the calories of each food that help you to calculate it?
Matthew Zoljan 120 Reputation points

2023-05-20T04:49:48.7066667+00:00

No, I want to calculate it based on how frequently they do their shopping and their weekly consumption in Kilograms. So basically I will research the average consumption of each vegetable, type of meat, fruit and give the user a list on what groceries they need to buy with it quantities in either grams or kilograms. Does that make sense?
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Matthew Zoljan 120 Reputation points

2023-05-29T12:06:56.6233333+00:00

Can you please put exactly what you wrote before it got deleted?

I didn't get the chance to read all of it it.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
David Alex 15 Reputation points

2023-05-29T15:14:18.5266667+00:00

If you decide to fetch data from external sources, you can search for open data APIs or datasets related to groceries and import the information into your database. Fetch user preferences: When a user registers or updates their preferences in the "Personalize" page, store their preferences in the database. You can have a separate table to store user preferences with columns like user ID, number of household members, shopping frequency, etc. Calculate grocery quantities: To calculate the quantities of groceries a user should buy, you'll need to retrieve the user's preferences from the database and multiply them by the quantities stored in the grocery tables.
David Alex 15 Reputation points

2023-05-29T15:15:17.9133333+00:00

You can write SQL queries or use an ORM (Object-Relational Mapping) library in C# to perform these calculations. Once you have the calculated quantities, you can generate a grocery list by displaying the relevant information to the user. You can create a separate content page that retrieves the calculated values from the database and presents them in a user-friendly format.
Matthew Zoljan 120 Reputation points

2023-06-08T06:48:23.1133333+00:00

Hi, thanks for your comments.

OK, so the major dilemma is that it appears that I am using two tables when a user registers to the "Personalize" page (where user after their logged in can update their preferences).

I'm not sure of how to merge them to the one table then I would be able to use them to calculate against grocery items in the database.

Can someone help me strategies how it should be?
Matthew Zoljan 120 Reputation points

2023-06-14T05:30:05.7066667+00:00

Any one. As much as information you can advise. The previous comments were deleted.

2 answers

Your answer

Anonymous

2023-05-18T05:57:17.64+00:00

how do I create a list of fruit, vegetables, kinds of meats, loathes of bread, milk, eggs.

Could you share a screenshot about your needs? If you want to a List, you can use ListView or CollectionView to implement it.

I need it installed into a database with their weight/amount then I need to be able to multiple the values by the database values that is being obtained from the registration page and 'Personalize' database.

Do you want to save weight/amount items in the other tables of SqliteDB?

Does anyone know of a similar app on say GitHub or a tutorial of an app performing similar calculations/functions.

Could you share details needs about calculations/functions? We can write it by ourselves.
Matthew Zoljan 120 Reputation points

2023-05-18T11:27:22.1933333+00:00

Hi Leon,

Thanks, as you can see below is the Personalized screen, where a user can update their weekly intake of the below grocery items in Kilograms, dozens of eggs per week, liters of mil per week, and loathes of bread a week.

The Meat, Fish, Vegetables, Fruit are in kilograms

The Milk is in litres

The loathes per week

Eggs a per dozen

Shopping is it's frequency

See screenshot below, let me know if you can't understand what I mean by above and the screenshot below but hopefully it provides some context.

Then I want to have it calculate how much groceries in kilos, liters, dozens, loathes of bread daily, weekly, biweekly and list the quantities of milk, loathes of bread, dozen of eggs, meat, vegetables and fruit on a list view page similar to below:

If you can show me an example of this with a handful of objects I can work it out from there. Thank you.
Anonymous

2023-05-19T09:09:15.5833333+00:00

Do you want to get the calories of each food that help you to calculate it?
Matthew Zoljan 120 Reputation points

2023-05-20T04:49:48.7066667+00:00

No, I want to calculate it based on how frequently they do their shopping and their weekly consumption in Kilograms. So basically I will research the average consumption of each vegetable, type of meat, fruit and give the user a list on what groceries they need to buy with it quantities in either grams or kilograms. Does that make sense?
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Matthew Zoljan 120 Reputation points

2023-05-29T12:06:56.6233333+00:00

Can you please put exactly what you wrote before it got deleted?

I didn't get the chance to read all of it it.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
David Alex 15 Reputation points

2023-05-29T15:14:18.5266667+00:00

If you decide to fetch data from external sources, you can search for open data APIs or datasets related to groceries and import the information into your database. Fetch user preferences: When a user registers or updates their preferences in the "Personalize" page, store their preferences in the database. You can have a separate table to store user preferences with columns like user ID, number of household members, shopping frequency, etc. Calculate grocery quantities: To calculate the quantities of groceries a user should buy, you'll need to retrieve the user's preferences from the database and multiply them by the quantities stored in the grocery tables.
David Alex 15 Reputation points

2023-05-29T15:15:17.9133333+00:00

You can write SQL queries or use an ORM (Object-Relational Mapping) library in C# to perform these calculations. Once you have the calculated quantities, you can generate a grocery list by displaying the relevant information to the user. You can create a separate content page that retrieves the calculated values from the database and presents them in a user-friendly format.
Matthew Zoljan 120 Reputation points

2023-06-08T06:48:23.1133333+00:00

Hi, thanks for your comments.

OK, so the major dilemma is that it appears that I am using two tables when a user registers to the "Personalize" page (where user after their logged in can update their preferences).

I'm not sure of how to merge them to the one table then I would be able to use them to calculate against grocery items in the database.

Can someone help me strategies how it should be?
Matthew Zoljan 120 Reputation points

2023-06-14T05:30:05.7066667+00:00

Any one. As much as information you can advise. The previous comments were deleted.

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

1 deleted comment

Comments have been turned off. Learn more

Share via

Grocery list app

2 answers

Your answer