hello friends We shared the C # Parking Automation SQL Database Source Code and Project file.You can download it for free and use it in your projects.

C# Parking Automation SQL Database Source Code

Our project is designed with only one design.www.iconarchive.com icons are downloaded.https: //www.onlinelogomaker.com/logomaker/# logos are designed, colors are https://material.io/resources/color/#!/? view.left = 0 & view.right = 0 is selected.3 User type entry is available. These are customer, personnel and technical support entry. Tools can be added, deleted, updated.

The locations where the vehicles are located can appear dynamically and write the plates in the locations they pass. Where can the customers learn the vehicles from their accounts. We will enter 2020 with hundreds of automations with plain design.

Here you can see the images of our project. Before downloading our project, this is a request, please follow our Instagram account.

Follow us on Instagram! Follow us on Instagram!Do not forget to follow our projects 🙂

 

Download Parking Automation! Our Project is Here, set up the database with the codes below!Do not forget to follow our projects 🙂

C # Parking Automation SQL Database Tables Codes (Don’t forget to create tables and set database path accordingly)
To run the following codes, you need to log in to your SQL server, create a database named car park, then call new query and paste it one by one.

C # Parking Automation Admin Table



USE [otopark] GO

/****** Object: Table [dbo].[admin] Script Date: 09.02.2020 01:36:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[admin](
[id] [int] IDENTITY(1,1) NOT NULL,
[k_adi] [nvarchar](50) NULL,
[sifre] [nvarchar](50) NULL,
CONSTRAINT [PK_admin] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

GO


C # Parking Automation Table called ‘bos‘


USE [otopark] GO

/****** Object: Table [dbo].[bos] Script Date: 09.02.2020 01:36:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[bos](
[bosyerler] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_bos] PRIMARY KEY CLUSTERED
(
[bosyerler] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

GO


C # Parking Automation ‘full‘ table

USE [otopark] GO

/****** Object: Table [dbo].[dolu] Script Date: 09.02.2020 01:37:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[dolu](
[doluyerler] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_dolu] PRIMARY KEY CLUSTERED
(
[doluyerler] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

GO


‘Musbil‘ table

USE [otopark] GO

/****** Object: Table [dbo].[musbil] Script Date: 09.02.2020 01:37:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[musbil](
[id] [int] IDENTITY(1,1) NOT NULL,
[TcKimlik] [nvarchar](50) NULL,
[Ad] [nvarchar](50) NULL,
[Soyad] [nvarchar](50) NULL,
[CepTel] [nvarchar](50) NULL,
[PlakaNo] [nvarchar](50) NULL,
[Marka] [nvarchar](50) NULL,
[Model] [nvarchar](50) NULL,
[Renk] [nvarchar](50) NULL,
[Konumu] [nvarchar](50) NULL,
CONSTRAINT [PK_musbil] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

GO


Codes of the table named ‘customer‘

 

USE [otopark] GO

/****** Object: Table [dbo].[musteri] Script Date: 09.02.2020 01:38:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[musteri](
[id] [int] IDENTITY(1,1) NOT NULL,
[TcKimlik] [nvarchar](50) NULL,
[Ad] [nvarchar](50) NULL,
[Soyad] [nvarchar](50) NULL,
[CepTel] [nvarchar](50) NULL,
[PlakaNo] [nvarchar](50) NULL,
[Marka] [nvarchar](50) NULL,
[Model] [nvarchar](50) NULL,
[Renk] [nvarchar](50) NULL,
[Sifre] [nvarchar](50) NULL,
[Gizli_Soru] [nvarchar](50) NULL,
[Yanit] [nvarchar](50) NULL,
CONSTRAINT [PK_musteri] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

GO


C # Parking Automation ‘staff‘ codes of the table

USE [otopark] GO

/****** Object: Table [dbo].[personel] Script Date: 09.02.2020 01:39:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[personel](
[id] [int] IDENTITY(1,1) NOT NULL,
[tc] [nvarchar](50) NULL,
[adi_soyadi] [nvarchar](50) NULL,
[cinsiyet] [nvarchar](50) NULL,
[telefon] [nvarchar](50) NULL,
[dogum_tarihi] [nvarchar](50) NULL,
[gorevi] [nvarchar](50) NULL,
[sifre] [nvarchar](50) NULL,
[gizli_soru] [nvarchar](50) NULL,
[yaniti] [nvarchar](50) NULL,
CONSTRAINT [PK_personel] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

GO


C # Parking Automation Codes of ‘satis’ table

USE [otopark] GO

/****** Object: Table [dbo].[satis] Script Date: 09.02.2020 01:39:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[satis](
[id] [int] IDENTITY(1,1) NOT NULL,
[plaka] [nvarchar](50) NULL,
[giris_tarih] [nvarchar](50) NULL,
[cikis_tarih] [nvarchar](50) NULL,
[ucret] [nvarchar](50) NULL,
CONSTRAINT [PK_satis] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

GO


Our article will hopefully be useful. Please do not forget to follow us.

Bir Cevap Yazın

Menü
%d blogcu bunu beğendi: