USE [master]਀䜀伀
/****** Object:  Database [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF]    Script Date: 1/20/2025 9:00:20 AM ******/਀䌀刀䔀䄀吀䔀 䐀䄀吀䄀䈀䄀匀䔀 嬀䌀㨀尀唀匀䔀刀匀尀䈀䰀䄀䌀䬀尀䐀䔀匀䬀吀伀倀尀䄀尀匀䄀䰀䴀䄀匀倀䠀伀一䔀䈀伀伀䬀尀匀䄀䰀䴀䄀匀倀䠀伀一䔀䈀伀伀䬀尀䈀䤀一尀䐀䔀䈀唀䜀尀䐀䄀吀䄀䈀䄀匀䔀尀匀䄀䰀䴀䄀匀䐀䈀⸀䴀䐀䘀崀
 CONTAINMENT = NONE਀ 伀一  倀刀䤀䴀䄀刀夀 
( NAME = N'SalmasDB', FILENAME = N'C:\Users\Black\Desktop\a\SalmasPhoneBook\SalmasPhoneBook\bin\Debug\DataBase\SalmasDB.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )਀ 䰀伀䜀 伀一 
( NAME = N'SalmasDB_log', FILENAME = N'C:\Users\Black\Desktop\a\SalmasPhoneBook\SalmasPhoneBook\bin\Debug\DataBase\SalmasDB_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )਀ 圀䤀吀䠀 䌀䄀吀䄀䰀伀䜀开䌀伀䰀䰀䄀吀䤀伀一 㴀 䐀䄀吀䄀䈀䄀匀䔀开䐀䔀䘀䄀唀䰀吀
GO਀䄀䰀吀䔀刀 䐀䄀吀䄀䈀䄀匀䔀 嬀䌀㨀尀唀匀䔀刀匀尀䈀䰀䄀䌀䬀尀䐀䔀匀䬀吀伀倀尀䄀尀匀䄀䰀䴀䄀匀倀䠀伀一䔀䈀伀伀䬀尀匀䄀䰀䴀䄀匀倀䠀伀一䔀䈀伀伀䬀尀䈀䤀一尀䐀䔀䈀唀䜀尀䐀䄀吀䄀䈀䄀匀䔀尀匀䄀䰀䴀䄀匀䐀䈀⸀䴀䐀䘀崀 匀䔀吀 䌀伀䴀倀䄀吀䤀䈀䤀䰀䤀吀夀开䰀䔀嘀䔀䰀 㴀 ㄀　　
GO਀䤀䘀 ⠀㄀ 㴀 䘀唀䰀䰀吀䔀堀吀匀䔀刀嘀䤀䌀䔀倀刀伀倀䔀刀吀夀⠀✀䤀猀䘀甀氀氀吀攀砀琀䤀渀猀琀愀氀氀攀搀✀⤀⤀
begin਀䔀堀䔀䌀 嬀䌀㨀尀唀匀䔀刀匀尀䈀䰀䄀䌀䬀尀䐀䔀匀䬀吀伀倀尀䄀尀匀䄀䰀䴀䄀匀倀䠀伀一䔀䈀伀伀䬀尀匀䄀䰀䴀䄀匀倀䠀伀一䔀䈀伀伀䬀尀䈀䤀一尀䐀䔀䈀唀䜀尀䐀䄀吀䄀䈀䄀匀䔀尀匀䄀䰀䴀䄀匀䐀䈀⸀䴀䐀䘀崀⸀嬀搀戀漀崀⸀嬀猀瀀开昀甀氀氀琀攀砀琀开搀愀琀愀戀愀猀攀崀 䀀愀挀琀椀漀渀 㴀 ✀攀渀愀戀氀攀✀
end਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET ANSI_NULL_DEFAULT OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET ANSI_NULLS OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET ANSI_PADDING OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET ANSI_WARNINGS OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET ARITHABORT OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET AUTO_CLOSE ON ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET AUTO_SHRINK OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET AUTO_UPDATE_STATISTICS ON ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET CURSOR_CLOSE_ON_COMMIT OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET CURSOR_DEFAULT  GLOBAL ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET CONCAT_NULL_YIELDS_NULL OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET NUMERIC_ROUNDABORT OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET QUOTED_IDENTIFIER OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET RECURSIVE_TRIGGERS OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET  DISABLE_BROKER ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET DATE_CORRELATION_OPTIMIZATION OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET TRUSTWORTHY OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET ALLOW_SNAPSHOT_ISOLATION OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET PARAMETERIZATION SIMPLE ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET READ_COMMITTED_SNAPSHOT OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET HONOR_BROKER_PRIORITY OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET RECOVERY SIMPLE ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET  MULTI_USER ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET PAGE_VERIFY CHECKSUM  ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET DB_CHAINING OFF ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET TARGET_RECOVERY_TIME = 60 SECONDS ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET DELAYED_DURABILITY = DISABLED ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET ACCELERATED_DATABASE_RECOVERY = OFF  ਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET QUERY_STORE = OFF਀䜀伀
USE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF]਀䜀伀
/****** Object:  Table [dbo].[Contact]    Script Date: 1/20/2025 9:00:20 AM ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一
GO਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䌀漀渀琀愀挀琀崀⠀
	[Code] [int] NOT NULL,਀ऀ嬀䘀椀爀猀琀一愀洀攀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㔀　⤀ 一伀吀 一唀䰀䰀Ⰰ
	[Family] [nvarchar](50) NOT NULL,਀ऀ嬀䴀漀戀椀氀攀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㄀㄀⤀ 一伀吀 一唀䰀䰀Ⰰ
	[TypeSimCard] [nvarchar](10) NOT NULL,਀ऀ嬀匀攀砀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㌀⤀ 一伀吀 一唀䰀䰀Ⰰ
 CONSTRAINT [PK_Contact] PRIMARY KEY CLUSTERED ਀⠀
	[Code] ASC਀⤀圀䤀吀䠀 ⠀倀䄀䐀开䤀一䐀䔀堀 㴀 伀䘀䘀Ⰰ 匀吀䄀吀䤀匀吀䤀䌀匀开一伀刀䔀䌀伀䴀倀唀吀䔀 㴀 伀䘀䘀Ⰰ 䤀䜀一伀刀䔀开䐀唀倀开䬀䔀夀 㴀 伀䘀䘀Ⰰ 䄀䰀䰀伀圀开刀伀圀开䰀伀䌀䬀匀 㴀 伀一Ⰰ 䄀䰀䰀伀圀开倀䄀䜀䔀开䰀伀䌀䬀匀 㴀 伀一Ⰰ 伀倀吀䤀䴀䤀娀䔀开䘀伀刀开匀䔀儀唀䔀一吀䤀䄀䰀开䬀䔀夀 㴀 伀䘀䘀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
) ON [PRIMARY]਀䜀伀
/****** Object:  StoredProcedure [dbo].[AddContact]    Script Date: 1/20/2025 9:00:20 AM ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一
GO਀挀爀攀愀琀攀 瀀爀漀挀攀搀甀爀攀 嬀搀戀漀崀⸀嬀䄀搀搀䌀漀渀琀愀挀琀崀
@Code int,਀䀀䘀椀爀猀琀一愀洀攀 渀瘀愀爀挀栀愀爀⠀㔀　⤀Ⰰ
@Family nvarchar(50),਀䀀䴀漀戀椀氀攀 渀瘀愀爀挀栀愀爀⠀㄀㄀⤀Ⰰ
@TypeSimCard nvarchar(10),਀䀀匀攀砀 渀瘀愀爀挀栀愀爀⠀㌀⤀
as਀椀渀猀攀爀琀 椀渀琀漀 䌀漀渀琀愀挀琀⠀䌀漀搀攀Ⰰ䘀椀爀猀琀一愀洀攀Ⰰ䘀愀洀椀氀礀Ⰰ䴀漀戀椀氀攀Ⰰ吀礀瀀攀匀椀洀䌀愀爀搀Ⰰ匀攀砀⤀ 瘀愀氀甀攀猀 ⠀䀀䌀漀搀攀Ⰰ䀀䘀椀爀猀琀一愀洀攀Ⰰ䀀䘀愀洀椀氀礀Ⰰ䀀䴀漀戀椀氀攀Ⰰ䀀吀礀瀀攀匀椀洀䌀愀爀搀Ⰰ䀀匀攀砀⤀
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  匀琀漀爀攀搀倀爀漀挀攀搀甀爀攀 嬀搀戀漀崀⸀嬀䄀氀氀䌀漀渀琀愀挀琀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 ㄀⼀㈀　⼀㈀　㈀㔀 㤀㨀　　㨀㈀　 䄀䴀 ⨀⨀⨀⨀⨀⨀⼀
SET ANSI_NULLS ON਀䜀伀
SET QUOTED_IDENTIFIER ON਀䜀伀
create procedure [dbo].[AllContact]਀愀猀
select * from Contact਀䜀伀
/****** Object:  StoredProcedure [dbo].[AzartelCount]    Script Date: 1/20/2025 9:00:20 AM ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一
GO਀䌀刀䔀䄀吀䔀 瀀爀漀挀攀搀甀爀攀 嬀搀戀漀崀⸀嬀䄀稀愀爀琀攀氀䌀漀甀渀琀崀
as਀匀䔀䰀䔀䌀吀 䌀伀唀一吀⠀⨀⤀ 䘀刀伀䴀 䌀漀渀琀愀挀琀 眀栀攀爀攀 吀礀瀀攀匀椀洀䌀愀爀搀 㴀 一✀∀〆ㄆ⨆䐆✆
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  匀琀漀爀攀搀倀爀漀挀攀搀甀爀攀 嬀搀戀漀崀⸀嬀䐀攀氀攀琀攀䌀漀渀琀愀挀琀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 ㄀⼀㈀　⼀㈀　㈀㔀 㤀㨀　　㨀㈀　 䄀䴀 ⨀⨀⨀⨀⨀⨀⼀
SET ANSI_NULLS ON਀䜀伀
SET QUOTED_IDENTIFIER ON਀䜀伀
CREATE procedure [dbo].[DeleteContact]਀䀀䌀漀搀攀 渀瘀愀爀挀栀愀爀⠀㔀　⤀
as਀戀攀最椀渀
declare @abc nvarchar(50)਀猀攀琀 䀀愀戀挀㴀✀搀攀氀攀琀攀 昀爀漀洀 䌀漀渀琀愀挀琀 眀栀攀爀攀 䌀漀搀攀 椀渀⠀✀⬀䀀䌀漀搀攀⬀✀⤀✀
exec(@abc)਀攀渀搀
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  匀琀漀爀攀搀倀爀漀挀攀搀甀爀攀 嬀搀戀漀崀⸀嬀䔀搀椀琀䌀漀渀琀愀挀琀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 ㄀⼀㈀　⼀㈀　㈀㔀 㤀㨀　　㨀㈀　 䄀䴀 ⨀⨀⨀⨀⨀⨀⼀
SET ANSI_NULLS ON਀䜀伀
SET QUOTED_IDENTIFIER ON਀䜀伀
create procedure [dbo].[EditContact]਀䀀䌀漀搀攀 椀渀琀Ⰰ
@FirstName nvarchar(50),਀䀀䘀愀洀椀氀礀 渀瘀愀爀挀栀愀爀⠀㔀　⤀Ⰰ
@Mobile nvarchar(11),਀䀀吀礀瀀攀匀椀洀䌀愀爀搀 渀瘀愀爀挀栀愀爀⠀㄀　⤀Ⰰ
@Sex nvarchar(3)਀愀猀
update Contact set FirstName=@FirstName,Family=@Family,Mobile=@Mobile,TypeSimCard=@TypeSimCard,Sex=@Sex where Code=@Code਀䜀伀
/****** Object:  StoredProcedure [dbo].[IranCellCount]    Script Date: 1/20/2025 9:00:20 AM ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一
GO਀䌀刀䔀䄀吀䔀 瀀爀漀挀攀搀甀爀攀 嬀搀戀漀崀⸀嬀䤀爀愀渀䌀攀氀氀䌀漀甀渀琀崀
as਀
SELECT COUNT(*) FROM Contact where TypeSimCard = N'ایرانسل'਀䜀伀
/****** Object:  StoredProcedure [dbo].[MCICount]    Script Date: 1/20/2025 9:00:20 AM ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一
GO਀䌀刀䔀䄀吀䔀 瀀爀漀挀攀搀甀爀攀 嬀搀戀漀崀⸀嬀䴀䌀䤀䌀漀甀渀琀崀
as਀匀䔀䰀䔀䌀吀 䌀伀唀一吀⠀⨀⤀ 䘀刀伀䴀 䌀漀渀琀愀挀琀 眀栀攀爀攀 吀礀瀀攀匀椀洀䌀愀爀搀 㴀 一✀䜀䔆ㄆ✆䜆 ✀䠆䐆✆
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  匀琀漀爀攀搀倀爀漀挀攀搀甀爀攀 嬀搀戀漀崀⸀嬀刀椀最琀攀氀䌀漀甀渀琀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 ㄀⼀㈀　⼀㈀　㈀㔀 㤀㨀　　㨀㈀　 䄀䴀 ⨀⨀⨀⨀⨀⨀⼀
SET ANSI_NULLS ON਀䜀伀
SET QUOTED_IDENTIFIER ON਀䜀伀
CREATE procedure [dbo].[RigtelCount]਀愀猀
SELECT COUNT(*) FROM Contact where TypeSimCard = N'رایتل'਀䜀伀
USE [master]਀䜀伀
ALTER DATABASE [C:\USERS\BLACK\DESKTOP\A\SALMASPHONEBOOK\SALMASPHONEBOOK\BIN\DEBUG\DATABASE\SALMASDB.MDF] SET  READ_WRITE ਀䜀伀