Notes

/* insert crudu */
create procedure spAboneKaydet(
@uNo int,
@tar date,
@ucr smallmoney
)
as
begin
insert into tblAbone
values (@uNo,@tar,@ucr)
end
go
exec spAboneKaydet 2,'01.05.2019',80
go
/* Abone sil crudu */
create procedure spAboneSil(
@aNo int
)
as
begin
delete from tblAbone where aboneNo=@aNo
end
go
exec spAboneSil 1
go
/* abone güncelle crudu */
create procedure spAboneGuncelle(
@uNo int,
@tar date,
@ucr smallmoney,
@aboNo int
)
as
begin
update tblAbone set uyeNo=@uNo,tarih=@tar,ucret=@ucr where aboneNo=@aboNo
end
go
exec spAboneKaydet 2,'01.01.2019',70
go
exec spAboneGuncelle 3,'01.03.2019',70,2
/* Tekli listeleme crudu */
create procedure spAboneSec(
@aNo int
)
as
begin
select * from tblAbone where aboneNo=@aNo
end
go
exec spAboneSec 2
/* çoklu listeleme crudu */
create procedure spAboneTum
as
begin
select * from tblAbone
end
go
exec spAboneTum

////////////////////////////////////////////
/* aktif aboneliği olan uyeler */
create procedure spAboneAktif
as
begin
select *,* from tblAbone,tblUye where tblUye.abone=1 and tblAbone.uyeNo=tblUye.uyeNo
end
go
exec spAboneAktif

/*tblArac Crud*/
/*Insert into*/
create procedure spAracKayit(@arPlaka varchar(50),@uyeNo int)
as
begin
insert into tblArac values(@arPlaka,@uyeNo)
end
GO
exec spAracKayit '29ND61',1
GO
/*Delete*/
create procedure spAracSil(@arPlaka varchar(50))
as
begin
delete from tblArac where @arPlaka=aracPlaka
end
GO
exec spAracSil '34AWD584'
GO
/*Update*/
create procedure spAracGuncelle(@arPlaka varchar(50),@uyeNo int)
as
begin
update tblArac set aracPlaka=@arPlaka,uyeNo=@uyeNo where aracPlaka=@arPlaka
end
exec spAracGuncelle '29ND61'
GO
/* Tekli listeleme crudu */
create procedure spAracSec(
@aNo int
)
as
begin
select * from tblArac where aracPlaka=@aNo
end
go
exec spAracSec 2
/*Çoklu listeleme crudu */
create procedure spAracTum
as
begin
select * from tblArac
end
go
exec spAracTum
GO
/////////////////////////////////////////////////////////////////////////////////////////
/*tblIslem Cruds*/




CREATE PROCEDURE spAracKaydet(@plaka varchar(15),@uno int)
as
begin
insert into tblAbone
values(@plaka,@uno)
end

exec spAracKaydet '34A1111',2


////////////////////////////

CREATE PROCEDURE spAracPlakaTanimla(@plaka varchar(15))
as
begin
declare @var int
set @var=(select count(aracPlakaPk) from tblArac where aracPlakaPk like '34T33')
if @var=0 begin
exec spAracKaydet @plaka,1
end
end
////////////////////////////////////////
/* insert crudu */
create procedure spAboneKaydet(
@uNo int,
@tar date,
@ucr smallmoney
)
as
begin
insert into tblAbone
values (@uNo,@tar,@ucr)
end
go
exec spAboneKaydet 2,'01.05.2019',80
go
/* Abone sil crudu */
create procedure spAboneSil(
@aNo int
)
as
begin
delete from tblAbone where aboneNo=@aNo
end
go
exec spAboneSil 1
go
/* abone güncelle crudu */
create procedure spAboneGuncelle(
@uNo int,
@tar date,
@ucr smallmoney,
@aboNo int
)
as
begin
update tblAbone set uyeNoFk=@uNo,tarih=@tar,ucret=@ucr where aboneNo=@aboNo
end
go
exec spAboneKaydet 2,'01.01.2019',70
go
exec spAboneGuncelle 3,'01.03.2019',70,2
/* Tekli listeleme crudu */
create procedure spAboneSec(
@aNo int
)
as
begin
select * from tblAbone where aboneNo=@aNo
end
go
exec spAboneSec 2
/* çoklu listeleme crudu */
create procedure spAboneTum
as
begin
select * from tblAbone
end
go
exec spAboneTum

////////////////////////////////////////////
/* aktif aboneliği olan uyeler */
create procedure spAboneAktif
as
begin
select *,* from tblAbone,tblUye where tblUye.abone=1 and tblAbone.uyeNoFk=tblUye.uyeNo
end
go
exec spAboneAktif