IF NOT EXISTS (SELECT 1 FROM [sCommon].[tReport] WHERE Id = 20935)
BEGIN
INSERT INTO [sCommon].[tReport]
           ([Id]
           ,[Title]
           ,[ReportPath]
           ,[TitleResourceKeyId]
           ,[IsElectronicSignatureRequired]
           ,[IsDirectPrint]
           ,[NoOfCopies]
           ,[ReportGroup]
           ,[ReportCondition]
           ,[OrderIndex]
           ,[TaskId]
           ,[ReportFormatGroupId]
           ,[ReportName]
           ,[ReportTypeId]
           ,[IsObsolete]
           ,[OrgGroupId]
           ,[HelpRemark]
           ,[SelectableField]
           ,[SamplePath])
     VALUES
           (20935
           ,'Student ICard14'
           ,'~\ReportCustom\Student_iCard14.rdlc'
           ,1
           ,0
           ,0
           ,1
           ,59
           ,NULL
           ,1800
           ,10126
           ,4
           ,'Student Identity Card'
           ,NULL
           ,0
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           )
  END
GO

IF NOT EXISTS (SELECT 1 FROM sCommon.tUpdateFieldMaster WHERE Id = 5)
BEGIN
INSERT INTO [sCommon].[tUpdateFieldMaster]
           ([Id]
           ,[FunctionalityName]
           ,[SubFunctionalityName]
           ,[Field]
           ,[IsObsolete]
           ,[DataTypeId])
     VALUES
          (5
           ,'Student'
           ,'General'
           ,'SUId'
           ,'False'
           ,1)
END           
GO


IF NOT EXISTS(SELECT 1 FROM [sStudent].[tICardTemplate] WHERE Id = 15)
BEGIN
INSERT INTO [sStudent].[tICardTemplate]
           ([Id]
           ,[Title]
           ,[Remark]
           ,[DesignTemplate]
           ,[ICardImage]
           ,[ReportId]
           ,[ICardPDF])
     VALUES
           (
			15,
           'Icard_14',
           'Shows Icard in Landscape format  in both side', 
           '~/ContentTemplates/ICard/Icard_14.psd', 
           '~/ContentTemplates/ICard/Icard_14.jpg', 
           20935, 
           '~/ContentTemplates/ICard/ICard-14.pdf'
           )
END
GO




