/zaretna

Windows Form Application - back office of Zaretna online website.

Primary LanguageC#

Overview

My farmer uncle that has been farming for more than 15 years (works as agriculture engineer as well) decided to start selling fruits & vegetables online (we called this website Zaretna), so my elder brother made him a website, and I was there to make the "back-office" windows application that manages the website and the business, such as managing orders, products, customers, delivery, statistics and more.

Social media links of Zaretna business:

Managing Products

image

  • Managing products is user-friendly.
  • Same product can appear on multiple categories.
  • Ability to add new categories or modify already existing ones.
  • Each category products can be ordered (organized in the category menu) manually.

Managing Orders

image

This is the window to view and manage orders.

  • Orders with golden background are collected, weighted (priced), and are ready for delivery.
  • Orders with white background are not collected yet.
  • Supports advanced search (filter by delivery region, customer's first name/last name, phone number, show orders between two dates).
  • To view an order, we simply click on it, and the following window will open: image After collecting and weighting the products, we enter the final price of the order (after weighting the products and getting the exact price), then the order will have the golden background.

Delivery

  • When an order is collected and a final price was set for it, then the order will appear in the delivery window.
  • Delivery window displays all collected orders, and in it we choose an email address for delivery. (Or multiple email addresses)
  • We can then send an email to the delivery man that contains a table of collected orders with all needed details.
  • Here's an example of an email sent from the program for delivery: image
  • When an order is delivered, by clicking on the link on the most left column, the order is set as "delivered" and will disappear from the orders list in the app, this feature makes the app and the business in general more organized and focused.

Sales & Statistics

image

  • This is real-time graph, that shows the number of orders between two given dates.
  • We can also see more detailed graph, such that it shows how many orders were done from each region between two given dates: image

Installation

  • Clone this repo.
  • Make sure MySQL.Data (By Oracle) is installed.
  • Open the cloned project with Visual Studio (2019+).
  • Compile the project and run it.
  • That's it.