C# Full Project Tutorial Pet Shop Management System in single video(C#.Net and SQL Database Server)

Опубликовано: 21 Ноябрь 2024
на канале: Mdemy

43,878

799

Lets, start to develop C# project for Pet Shop Management System by using visual studio 2019.
All students can easily learn about visual studio and SQL server and they may be expertise with it.

Source Code Link
https://u.pcloud.link/publink/show?co...

╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
LINK-- https://www.youtube.com/channel/UC1fw...

App of PetShopMS that for test run
Here -- https://u.pcloud.link/publink/show?co...

Requirement
Code Editor -- Visual Studio 2019
https://www.techspot.com/downloads/72...
Database Management -- Microsoft SQL Sever Management Studio 18
https://docs.microsoft.com/en-us/sql/...

what we need for this tutorial
pet shop management system
photo
1. pet photo - 2 (download from https://www.pexels.com/)
2. user photo - 1 (download from https://randomuser.me/photos)

Pichon software (for icons)
(download form https://pichon.en.uptodown.com/window...)
icon(.png)
1. dashboard - 2(gray,white)
2. customer - 2(gray,white)
3. User - 2(gray,white)
4. product - 2(gray,white)
5. Cash - 2(gray,white)
6. logout - 2(gray,white)

icon(.icon)
(Pet)shop - 1 (color)

Database
Microsoft SQL Sever Management Studio 18
(To manage database)
Database table
1.User (id,name,address,phone,role,DOB,password)
2.Customer (id,name,address,phone)
3.Product (product code, product name,product type,product category,qty,price)
4.Cash (cashid,transitoin,pcode,qty,price,total,customer id, cashier)

Window Form
1. Splash
2. Login
3. Main
4. Dashboard
5. User
6. User Module(For Registration and Edit)
7. Customer
8. Customer Module (For Registration and Edit)
9. Product
10. Product Module (For Registration and Edit)
11. Cash
12. Cash Product (For Choice Product)
13. Cash Customer (For Select Customer)

Class
DbConnect (To connect database)
00:00:00 Introduction
00:00:56 Splash Form (For progress bar loading)
00:03:50 Guna.UI2.Winforms Installation by NuGet
00:08:11 Login Form
00:16:01 Add Main Form (Create User Interface Design)
00:32:08 Add User Form(search box, Add button, DataGridView)
00:41:24 Add User Module(For user registration and user's record update)
00:47:49 Create New Database
00:48:08 Add New Class (for database connection)
00:51:39 Create user table.
00:54:14 Coding for user registration (Insert data into database)
01:03:18 Coding for user list (data display on the datagridview)
01:21:10 Age calculator
01:31:35 Call edit form by click on the datagirdview
01:40:56 Update user data
01:53:07 Add New Product Form
01:54:42 Add Product Module (For product registration and product data update)
01:57:56 Create product table
01:59:04 Product registration
02:19:12 Product record update and delete
02:27:21 textbox qty accept only digit number
02:40:58 Add New Customer Form
02:42:12 Add Customer Module(For customer registration and customer data update)
02:43:27 Create customer table
02:44:17 Customer registration
02:55:30 Customer record update and delete
03:07:49 Add new Cash form
03:15:47 Create Cash table
03:17:37 Add new cash product form
03:36:18 Generate transation number
03:44:59 Database trigger for cash total
04:00:03 Cash item unit increase, decrease and delete
04:21:01 Coding for login form
04:41:00 Add new cash customer form
05:04:55 Add new dashboard form
05:29:00 create daily sale report
05:45:24 Create digital clock design on mainform
05:55:36 Finishing and test run
05:58:49 To produce executable file(exe)

Inventory Management System | POS by Using C # and SQL Database Full Project in one video11:28 ⏲
   • C# Full Projects Supermarket Manageme...

Inventory Management System(C# Full Project using SQL server with source code)
   • Inventory Management System(C# Full P...

C# full project(student Management System)with source code
   • C# full project(student Management Sy...

C# Full Project Tutorial for Beginners - (Hotel Management System)- WITH SOURCE CODE (Used MYSQL )
   • C# Full Project Tutorial (Hotel Manag...

C# Full Project Tutorial-Minimarket Management System-With source code and sql sever (for beginner)
   • C# Full Project Tutorial (Minimarket ...

PlayList
Point Of Sales And Inventory Management System Tutorial
   • Point Of Sales And Inventory Manageme...

C# Project with Database (Full Project in One Video)
   • C# Full Projects with Database (One V...