You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
67 lines
3.7 KiB
67 lines
3.7 KiB
USE [FastMoneyPro_Remit]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[proc_fiscalyear_setup] Script Date: 9/27/2019 1:30:14 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
/*
|
|
select * from FiscalYear
|
|
exec [proc_fiscalyear_setup] 'i','admin','2009',''
|
|
exec [proc_fiscalyear_setup] 's',@id ='2009'
|
|
exec [proc_fiscalyear_setup] 'u','admin','2009','2009','66-67','7/16/2009 12:00:00 AM','7/17/2010 12:00:00 AM','True'
|
|
exec [proc_fiscalyear_setup] 'c'
|
|
*/
|
|
CREATE procedure [dbo].[proc_fiscalyear_setup]
|
|
@flag char(1),
|
|
@user varchar(100)=null,
|
|
@id int=null,
|
|
@FISCAL_YEAR_ENGLISH varchar(20)=null,
|
|
@FISCAL_YEAR_NEPALI varchar(20)=null,
|
|
@EN_YEAR_START_DATE date=null,
|
|
@EN_YEAR_END_DATE date=null,
|
|
@strflag varchar(5)=null
|
|
as
|
|
set nocount on;
|
|
if(@flag ='c')
|
|
begin
|
|
--if exists(select * from FiscalYear where FLAG = @strflag)
|
|
if exists(select * from FiscalYear where FLAG = 'true')
|
|
begin
|
|
select 'True' 'Flag'
|
|
end
|
|
else
|
|
begin
|
|
select 'False' 'Flag'
|
|
return;
|
|
end
|
|
end
|
|
if(@flag ='i')
|
|
begin
|
|
insert into FiscalYear (FISCAL_YEAR_ENGLISH,
|
|
FISCAL_YEAR_NEPALI, EN_YEAR_START_DATE,
|
|
EN_YEAR_END_DATE,FLAG)
|
|
values(@FISCAL_YEAR_ENGLISH,@FISCAL_YEAR_NEPALI,
|
|
@EN_YEAR_START_DATE,@EN_YEAR_END_DATE,@strflag)
|
|
end
|
|
if(@flag ='u')
|
|
begin
|
|
update FiscalYear
|
|
set FISCAL_YEAR_ENGLISH = @FISCAL_YEAR_ENGLISH,
|
|
FISCAL_YEAR_NEPALI = @FISCAL_YEAR_NEPALI,
|
|
EN_YEAR_START_DATE = @EN_YEAR_START_DATE,
|
|
EN_YEAR_END_DATE = @EN_YEAR_END_DATE,
|
|
FLAG = @strflag
|
|
where FISCAL_YEAR_ID = @id
|
|
end
|
|
if(@flag ='s')
|
|
begin
|
|
--CONVERT(VARCHAR,AP.APPLIED_DATE,107)
|
|
select FISCAL_YEAR_ENGLISH, FISCAL_YEAR_NEPALI, CONVERT(VARCHAR,EN_YEAR_START_DATE,101) as 'EN_YEAR_START_DATE',
|
|
CONVERT(VARCHAR, EN_YEAR_END_DATE,101) as 'EN_YEAR_END_DATE',FLAG from FiscalYear
|
|
where FISCAL_YEAR_ID = @id
|
|
end
|
|
|
|
|
|
|
|
GO
|