New page wikitext, after the edit (new_wikitext) | '{{redirect|Country house|the song by Blur|Country House}}
{{No footnotes|date=October 2010}}
[[Image:Holkham Hall South.jpg|thumb|right|400px|[[Holkham Hall]], one of the grandest English country houses. Country houses not only displayed the owners' taste, but were the centre of an [[estate (house)|estate]], providing employment to hundreds]]
The '''English country house''' is generally accepted as a large [[house]] or [[mansion]], once in the ownership of an individual who also usually owned another [[great house]] in town allowing one to spend time in the country and in the city.
Country houses and [[stately home]]s are sometimes confused—while a country house is always in the country, a stately home can also be in a town. [[Apsley House]], built for the [[Arthur Wellesley, 1st Duke of Wellington|Duke of Wellington]] at the corner of [[Hyde Park, London|Hyde Park]] (''No. 1, London'' it was called), is one example. Other country houses such as [[Ascott House|Ascott]] in Buckinghamshire were deliberately designed not to be stately, and to harmonise with the landscape, while some of the great houses such as [[Kedleston Hall]] and [[Holkham Hall]] were built as "power houses" to impress and dominate the landscape, and were certainly intended to be "stately homes". Today many former stately homes, while still country houses, are far from stately and most certainly not homes.
The country house was not only a weekend retreat for aristocrats, but also often a full time residence for the minor [[gentry]] who were a central node in the so-called squirearchy that ruled Britain until the [[Reform Act 1832]] (as documented in ''The Purefoy Letters, 1735–53'' by L G Mitchell). Even some of the formal business of the shire was transacted in the Hall.
== Evolution ==
The country houses of England have evolved over the last 500 years. Before this time larger houses were more often than not fortified, reflecting the position of their owners as [[Feudalism|feudal lords]], ''de facto'' overlords of their [[Manorialism|manor]]. The [[Tudor period]] of stability in the country saw the first of the large unfortified mansions. [[Henry VIII of England|Henry VIII]]'s policy of the [[Dissolution of the Monasteries]] saw many former [[ecclesiastical]] properties turned over to the King's favourites, who then converted them into private country houses. [[Woburn Abbey]], [[Forde Abbey]] and many other mansions with [[Abbey]] or [[Priory]] in their name often date from this period as private houses. Other terms used in the name of houses to describe their origin or importance include [[Palace]], [[Castle]], [[Court (disambiguation)|Court]], [[Hall]], [[Mansion]], [[Park]], [[House]], [[Manor House|Manor]], [[Location (geography)|Place]] and [[Tower house|Tower]].
It was during the later half of the reign of [[Elizabeth I of England|Elizabeth I]] and her successor [[James I of England|James I]] that the first architect designed mansions, thought of today as epitomising the English country house, and began to make their appearance. [[Burghley House]], [[Longleat|Longleat House]], and [[Hatfield House]] are perhaps amongst the most well known. Hatfield House was one of the first houses in England to show the Italianate influences of the renaissance, which was eventually to see the end of the hinting-at-castle-architecture "turrets and towers" Gothic style. By the reign of [[Charles I of England|Charles I]], [[Inigo Jones]] and his form of [[Palladianism]] had changed the face of British domestic architecture completely. While there were later various Gothic Revival styles, the Palladian style in various forms, interrupted briefly by [[baroque]], was to predominate until the second half of the 18th century when, influenced by ancient Greek styles, it gradually evolved into the [[neoclassicism]] championed by such architects as [[Robert Adam]].
Some of the best known of England's country houses tend to have been built by one [[architect]] at one particular time: [[Montacute House]], [[Chatsworth House]], and [[Blenheim Palace]] are examples. It is interesting that while the latter two are [[Duke|ducal]] [[palace]]s, Montacute, although built by a [[Master of the Rolls]] to Queen Elizabeth I, spent the next 400 years in the occupation of his descendants who were Gentry without a London [[townhouse]], rather than aristocracy. They finally ran out of funds in the early 20th century.
However, the vast majority of the lesser-known English country houses, often owned by both gentry and aristocracy, are an evolution of one or more styles with [[facade]]s and wings in various styles in a mixture of high architecture, often as interpreted by a local architect or surveyor and determined by practicality as much as the whims of architectural taste. An example might be [[Brympton d'Evercy]] in Somerset, a house of many periods that is unified architecturally by the continuing use of the same mellow local Ham Hill stone.
The fashionable [[William Kent]] redesigned [[Rousham House]] only to have it quickly and drastically altered to accommodate space for the owner's twelve children. [[Canons Ashby]], home to [[poet]] [[John Dryden]]'s family, exemplifies this: a medieval farmhouse enlarged in the Tudor era around a courtyard, given grandiose plaster ceilings in the [[Stewart]] period and then given [[Georgian architecture|Georgian]] facades in the 18th century. The whole is a glorious mismatch of styles and fashions which seamlessly blend together—this could be called the true English country house. [[Wilton House]], one of England's grandest houses, is in a remarkably similar vein; although, while the Drydens, mere squires, at Canons Ashby employed a local architect, at Wilton the mighty [[Earls of Pembroke]] employed the finest architects of the day: first [[Holbein]], 150 years later Inigo Jones, and then Wyatt followed by Chambers. Each employed a different style of architecture, seemingly unaware of the design of the wing around the next corner. These varying "improvements", often criticised at the time, today are the qualities which make English country houses unique. Scarcely anywhere else in the world would an elite class have allowed, or indeed pursued, such an indifference to style.
----------\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\/////////////////////////////////////////
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPBloodGroupDetail]
as
select * from tbBloodGroupMaster
order by BloodGroupId desc
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SPClassSection]
(
@classid int
)
as
select sectionid,sectionname from tbsectionmaster a inner join tbclassmaster b on
a.classid=b.classid where b.classid=@classid
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SPDocumentByClass]
(
@ClassId int
)
as
select
d.documentid,
d.documentname ,
c.classid
from tbClassDocuments c inner join tbdocumentmaster d
on c.documentid= d.documentid
where ClassId=@ClassID
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[SP_StudentCategory_Select]
As
Select
StudentCategoryID,
StudentCategoryName,
StudentCategoryDescription,
ArbStudentCategoryName,
ArbStudentCategoryDescription,
AppliedWithOtherConcession,
MaxDiscount,
CreateUserID,
CreateDate,
ModifyUserID,
ModifyDate
from tbStudentCategoryMaster
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SPClassSectionClassWise]
(
@ClassId int
)as
begin
select a.classname as classnameOnly , a.classname +'-'+ b.sectionname as classname ,a.classid,b.sectionid,b.sectionname
from tbclassmaster a inner join tbsectionmaster b on a.classid=b.classid
where a.classid = @ClassId
end
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SPStudentnameByClassANDSectionId]
(
@ClassId int,
@SectionId int
)as
begin
declare @qry varchar(max)
set @qry='select a.studentid ,a.studentname + ''('' + a.admissionNo + '')'' as studentname ,c.sectionid
, a.admissionNo,d.classid
from tbstudentmaster a inner join tbstudentclassSession b on
a.studentid=b.studentid inner join tbsectionmaster c on c.sectionid=b.sectionid
inner join tbclassmaster d on d.classid= c.classid
where 1=1'
exec( @qry)
if(@ClassId<>0)
begin
set @qry = @qry + ' and d.classid='+ convert(varchar,@ClassId)
end
if(@SectionId<>0)
begin
set @qry = @qry +' and c.sectionId='+ convert(varchar,@SectionId)
end
set @qry = @qry +' order by a.studentname'
exec (@qry)
end
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[spGetSerialno]
(
@admissiontype varchar(100)
)
as
select isnull( max(serialno),0)+1 from tbstudentmaster where admissiontype=@admissiontype
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[sp_studentAdmissionDetail] --1802
(
@studentID int
)
as
select a.studentid ,a.studentname ,a.registrationId,a.rollno,
Convert(char,a.DateOfBirth,107) as DateOfBirth,
a.Address,a.FatherName,a.MotherName,a.Gender,rm.StudentEmailId,a.AdmissionType,
a.AdmissionNo,
Convert(char,a.AdmissionDate,107) as AdmissionDate,
d.classname + '-'+ c.sectionname as classname ,
d.classid,c.sectionid,a.admissionno ,a.fathername
from
tbstudentmaster a inner join tbstudentclassSession b
on
a.studentid=b.studentid inner join tbsectionmaster c
on
c.sectionid=b.sectionid inner join tbclassmaster d
on
d.classid= c.classid inner join tbRegistrationMaster rm
on
a.registrationId=rm.registrationId
where
a.studentid=@studentID
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SPStudentDetailSave]
(
@StudentId int,
@SectionID int,
@RegistrationId int,
@SponserID int,
@AdmissionType varchar(50),
@SerialNo int,
@AdmissionNo varchar(50),
@AdmissionDate datetime,
@ClassID int,
@StudentName varchar(50),
@StudentNameAre nvarchar(50),
@LastName varchar(100),
@ARBLastName nvarchar(100),
@Gender varchar(50),
@ARBGender nvarchar(50),
@DateOfBirth datetime,
@Nationality varchar(50),
@ARBNationality nvarchar(50),
@MedicalHistory varchar(50),
@ARBMedicalHistory nvarchar(50),
@MedicalDescription varchar(200),
@ARBMedicalDescription nvarchar(200),
@AttentionRequired varchar(50),
@OnMedication bit,
@FirstContactName varchar(100),
@ARBFirstContactName nvarchar(100),
@FirstRelationId int,
@FirstEmgPhNo varchar(50),
--@ARBFirstEmgPhNo nvarchar(50),
@FirstEmgMobNo varchar(50),
--@ARBFirstEmgMobNo nvarchar(50),
@FirstFAX varchar(50),
--@ARBFirstFAX nvarchar(50),
@SecondContactName varchar(100),
@ARBSecondContactName nvarchar(100),
@SecondRelationId int,
@SecondEmgPhNo varchar(50),
--@ARBSecondEmgPhNo nvarchar(50),
@SecondEmgMobNo varchar(50),
--@ARBSecondEmgMobNo nvarchar(50),
@SecondFAX varchar(50),
--@ARBSecondFAX nvarchar(50),
@MotherLanguageID int,
@ReligionId int,
@StudentCategoryID int,
@BloodGroupID int,
--@StudentBloodGroup varchar(50),
--@ARBStudentBloodGroup nvarchar(50),
@CommunicableDisease bit,
@CityID int,
@TelNumber varchar(50),
--@ARBTelNumber nvarchar(50),
@PhoneNumber varchar(50),
--@ARBPhoneNumber nvarchar(50),
@PermanentAddress varchar(200),
@ARBPermanentAddress nvarchar(200),
@CorrespondingAddress varchar(200),
@ARBCorrespondingAddress nvarchar(200),
@StudentHeight varchar(50),
@ARBStudentHeight nvarchar(50),
@StudentWeight int,
@FatherName varchar(50),
@ARBFatherName nvarchar(50),
@MotherName varchar(50),
@ARBMotherBName nvarchar(50),
@GuardianName varchar(50),
@ARBGuardianName nvarchar(50),
@FatherNationality varchar(50),
@ARBFatherNationality nvarchar(50),
@MotherNationality varchar(50),
@ARBMotherNationality nvarchar(50),
@GuardianNationality varchar(50),
@ARBGuardianNationality nvarchar(50),
@FatherAddress varchar(200),
@ARBFatherAddress nvarchar(200),
@MotherAddress varchar(200),
@ARBMotherAddress nvarchar(200),
@GuardianAddress varchar(200),
@ARBGuardianAddress nvarchar(200),
@FatherHomePh varchar(50),
--@ARBFatherHomePh nvarchar(50),
@MotherHomePh varchar(50),
--@ARBMotherHomePh nvarchar(50),
@GuardianHomePh varchar(50),
--@ARBGuardianHomePh nvarchar(50),
@FatherOfficePh varchar(50),
--@ARBFatherOfficePh nvarchar(50),
@MotherOfficePh varchar(50),
--@ARBMotherOfficePh nvarchar(50),
@GuardianOfficePh varchar(50),
--@ARBGuardianOfficePh nvarchar(50),
@FatherFAX varchar(50),
--@ARBFatherFAX nvarchar(50),
@MotherFAX varchar(50),
--@ARBMotherFAX nvarchar(50),
@GuardianFAX varchar(50),
--@ARBGuardianFAX nvarchar(50),
@FatherEmailId varchar(50),
@ARBFatherEmailId nvarchar(50),
@MotherEmailId varchar(50),
@ARBMotherEmailId nvarchar(50),
@GuardianEmailId varchar(50),
@ARBGuardianEmailId nvarchar(50),
@FatherMobileNo varchar(50),
--@ARBFatherMobileNo nvarchar(50),
@MotherMobileNo varchar(50),
--@ARBMotherMobileNo nvarchar(50),
@GuardianMobileNo varchar(50),
--@ARBGuardianMobileNo nvarchar(50),
@FatherJob varchar(50),
@ARBFatherJob nvarchar(50),
@MotherJob varchar(50),
@ARBMotherJob nvarchar(50),
@GuardianJob varchar(50),
@ARBGuardianJob nvarchar(50),
@FatherOfficeName varchar(50),
@ARBFatherOfficeName nvarchar(50),
@MotherOfficeName varchar(50),
@ARBMotherOfficeName nvarchar(50),
@GuardianOfficeName varchar(50),
@ARBGuardianOfficeName nvarchar(50),
@StudentPicture varchar(50),
@FatherPicture varchar(50),
@MotherPicture varchar(50),
@GuardianPicture varchar(50),
@PhysicianName varchar(50),
@ARBPhysicianName nvarchar(50),
@PhysicianPhone varchar(50),
--@ARBPhysicianPhone nvarchar(50),
@PhysicianEmailID varchar(50),
@ARBPhysicianEmailID nvarchar(50),
@Action varchar(10)
)
as
Begin
If(@ReligionId =0)
begin
set @ReligionId=null
end
if(@RegistrationId=0)
begin
set @RegistrationId=null
end
If(@StudentCategoryId =0)
begin
set @StudentCategoryId=null
end
If(@MotherLanguageId =0)
begin
set @MotherLanguageId=null
end
If(@StudentWeight='')
begin
set @StudentWeight =null
end
If(@SponserID=0)
Begin set @SponserID=null
End
if(@BloodGroupID=0)
Begin
Set @BloodGroupID=null
End
if(@SectionID=0)
Begin
Set @SectionID=null
End
declare @RollNo as int
--------------------------------------------------
set @RollNo= (select isnull(max(rollno),0)+1 from tbstudentmaster inner join tbStudentClassSession
on tbstudentmaster.studentid =tbStudentClassSession.studentid
inner join tbsectionmaster on tbsectionmaster.sectionid=tbStudentClassSession.sectionid
inner join tbclassmaster on tbclassmaster.classid=tbsectionmaster.classid
where tbsectionmaster.sectionid =@SectionID)
-------------------------------------------------------
If(@Action='Save')
begin
--if exists(select tbStudentClassSession.StudentId from tbStudentMaster inner join tbStudentClassSession on tbStudentClassSession.studentid=tbStudentMaster.studentid where sectionid=@Sectionid)
--begin
--return 3
--end
if not exists(select StudentName from tbregistrationmaster where registrationid=@RegistrationId)
begin
set @RegistrationId=null end
select @StudentId = isnull(max(studentid),0)+1 from tbStudentMaster
insert into tbStudentMaster
(
StudentId,
RegistrationId,
SponserID,
AdmissionType,
SerialNo,
AdmissionNo,
AdmissionDate,
RollNo,
StudentName,
StudentNameAre,
LastName,
ARBLastName,
Gender,
ARBGender,
DateOfBirth,
Nationality,
ARBNationality,
MedicalHistory,
ARBMedicalHistory,
MedicalDescription,
ARBMedicalDescription,
AttentionRequired ,
OnMedication,
FirstContactName,
ARBFirstContactName,
FirstRelationId,
FirstEmgPhNo,
--ARBFirstEmgPhNo,
FirstEmgMobNo,
--ARBFirstEmgMobNo,
FirstFAX,
--ARBFirstFAX,
SecondContactName,
ARBSecondContactName,
SecondRelationId,
SecondEmgPhNo,
--ARBSecondEmgPhNo,
SecondEmgMobNo,
--ARBSecondEmgMobNo,
SecondFAX,
--ARBSecondFAX,
MotherLanguageID,
ReligionId,
StudentCategoryID,
BloodGroupID,
--StudentBloodGroup,
--ARBStudentBloodGroup,
CommunicableDisease,
CityID,
TelNumber,
--ARBTelNumber,
PhoneNumber,
--ARBPhoneNumber,
PermanentAddress,
ARBPermanentAddress,
CorrespondingAddress,
ARBCorrespondingAddress,
StudentHeight,
ARBStudentHeight,
StudentWeight,
FatherName,
ARBFatherName,
MotherName,
ARBMotherBName,
GuardianName,
ARBGuardianName,
FatherNationality,
ARBFatherNationality,
MotherNationality,
ARBMotherNationality,
GuardianNationality,
ARBGuardianNationality,
FatherAddress,
ARBFatherAddress,
MotherAddress,
ARBMotherAddress,
GuardianAddress ,
ARBGuardianAddress,
FatherHomePh,
--ARBFatherHomePh,
MotherHomePh,
--ARBMotherHomePh,
GuardianHomePh,
--ARBGuardianHomePh,
FatherOfficePh,
--ARBFatherOfficePh,
MotherOfficePh,
--ARBMotherOfficePh,
GuardianOfficePh,
--ARBGuardianOfficePh,
FatherFAX,
--ARBFatherFAX,
MotherFAX,
--ARBMotherFAX,
GuardianFAX,
--ARBGuardianFAX,
FatherEmailId,
ARBFatherEmailId,
MotherEmailId,
ARBMotherEmailId,
GuardianEmailId,
ARBGuardianEmailId,
FatherMobileNo,
--ARBFatherMobileNo,
MotherMobileNo,
--ARBMotherMobileNo,
GuardianMobileNo,
--ARBGuardianMobileNo,
FatherJob,
ARBFatherJob,
MotherJob,
ARBMotherJob,
GuardianJob,
ARBGuardianJob,
FatherOfficeName,
ARBFatherOfficeName,
MotherOfficeName,
ARBMotherOfficeName,
GuardianOfficeName,
ARBGuardianOfficeName,
StudentPicture,
FatherPicture,
MotherPicture,
GuardianPicture,
PhysicianName,
ARBPhysicianName,
PhysicianPhone,
--ARBPhysicianPhone,
PhysicianEmailID ,
ARBPhysicianEmailID
)
values
(
@StudentId,
@RegistrationId,
@SponserID,
@AdmissionType,
@SerialNo,
@AdmissionNo,
@AdmissionDate,
@RollNo,
@StudentName,
@StudentNameAre,
@LastName,
@ARBLastName,
@Gender,
@ARBGender,
@DateOfBirth,
@Nationality,
@ARBNationality,
@MedicalHistory,
@ARBMedicalHistory,
@MedicalDescription,
@ARBMedicalDescription,
@AttentionRequired ,
@OnMedication,
@FirstContactName,
@ARBFirstContactName,
@FirstRelationId,
@FirstEmgPhNo,
--@ARBFirstEmgPhNo,
@FirstEmgMobNo,
--@ARBFirstEmgMobNo,
@FirstFAX,
--@ARBFirstFAX,
@SecondContactName,
@ARBSecondContactName,
@SecondRelationId,
@SecondEmgPhNo,
--@ARBSecondEmgPhNo,
@SecondEmgMobNo,
--@ARBSecondEmgMobNo,
@SecondFAX,
--@ARBSecondFAX,
@MotherLanguageID,
@ReligionId,
@StudentCategoryID,
@BloodGroupID,
--@StudentBloodGroup,
--@ARBStudentBloodGroup,
@CommunicableDisease,
@CityID,
@TelNumber,
--@ARBTelNumber,
@PhoneNumber,
--@ARBPhoneNumber,
@PermanentAddress,
@ARBPermanentAddress,
@CorrespondingAddress,
@ARBCorrespondingAddress,
@StudentHeight,
@ARBStudentHeight,
@StudentWeight,
@FatherName,
@ARBFatherName,
@MotherName,
@ARBMotherBName,
@GuardianName,
@ARBGuardianName,
@FatherNationality,
@ARBFatherNationality,
@MotherNationality,
@ARBMotherNationality,
@GuardianNationality,
@ARBGuardianNationality,
@FatherAddress,
@ARBFatherAddress,
@MotherAddress,
@ARBMotherAddress,
@GuardianAddress ,
@ARBGuardianAddress,
@FatherHomePh,
--@ARBFatherHomePh,
@MotherHomePh,
--@ARBMotherHomePh,
@GuardianHomePh,
--@ARBGuardianHomePh,
@FatherOfficePh,
--@ARBFatherOfficePh,
@MotherOfficePh,
--@ARBMotherOfficePh,
@GuardianOfficePh,
--@ARBGuardianOfficePh,
@FatherFAX,
--@ARBFatherFAX,
@MotherFAX,
--@ARBMotherFAX,
@GuardianFAX,
--@ARBGuardianFAX,
@FatherEmailId,
@ARBFatherEmailId,
@MotherEmailId,
@ARBMotherEmailId,
@GuardianEmailId,
@ARBGuardianEmailId,
@FatherMobileNo,
--@ARBFatherMobileNo,
@MotherMobileNo,
--@ARBMotherMobileNo,
@GuardianMobileNo,
--@ARBGuardianMobileNo,
@FatherJob,
@ARBFatherJob,
@MotherJob,
@ARBMotherJob,
@GuardianJob,
@ARBGuardianJob,
@FatherOfficeName,
@ARBFatherOfficeName,
@MotherOfficeName,
@ARBMotherOfficeName,
@GuardianOfficeName,
@ARBGuardianOfficeName,
@StudentPicture,
@FatherPicture,
@MotherPicture,
@GuardianPicture,
@PhysicianName,
@ARBPhysicianName,
@PhysicianPhone,
--@ARBPhysicianPhone,
@PhysicianEmailID ,
@ARBPhysicianEmailID
)
insert into tbstudentclasssession
(
StudentId,
SectionId
)
values
(
@StudentId,
@SectionId
)
return @StudentId
end
if(@Action='Update')
begin
update tbStudentMaster
set
RegistrationId=@RegistrationId,
SponserID=@SponserID,
AdmissionType=@AdmissionType,
SerialNo=@SerialNo,
AdmissionNo=@AdmissionNo,
AdmissionDate=@AdmissionDate,
StudentName=@StudentName,
StudentNameAre=@StudentNameAre,
LastName=@LastName,
ARBLastName=@ARBLastName,
Gender=@Gender,
ARBGender=@ARBGender,
DateOfBirth=@DateOfBirth,
Nationality=@Nationality,
ARBNationality=@ARBNationality,
MedicalHistory=@MedicalHistory,
ARBMedicalHistory=@ARBMedicalHistory,
MedicalDescription=@MedicalDescription,
ARBMedicalDescription=@ARBMedicalDescription,
AttentionRequired =@AttentionRequired ,
OnMedication=@OnMedication,
FirstContactName=@FirstContactName,
ARBFirstContactName=@ARBFirstContactName,
FirstRelationId=@FirstRelationId,
FirstEmgPhNo=@FirstEmgPhNo,
--ARBFirstEmgPhNo=@ARBFirstEmgPhNo,
FirstEmgMobNo=@FirstEmgMobNo,
--ARBFirstEmgMobNo=@ARBFirstEmgMobNo,
FirstFAX=@FirstFAX,
--ARBFirstFAX=@ARBFirstFAX,
SecondContactName=@SecondContactName,
ARBSecondContactName=@ARBSecondContactName,
SecondRelationId=@SecondRelationId,
SecondEmgPhNo=@SecondEmgPhNo,
--ARBSecondEmgPhNo=@ARBSecondEmgPhNo,
SecondEmgMobNo=@SecondEmgMobNo,
--ARBSecondEmgMobNo=@ARBSecondEmgMobNo,
SecondFAX=@SecondFAX,
--ARBSecondFAX=@ARBSecondFAX,
MotherLanguageID=@MotherLanguageID,
ReligionId=@ReligionId,
StudentCategoryID=@StudentCategoryID,
BloodGroupID=@BloodGroupID,
--StudentBloodGroup=@StudentBloodGroup,
--ARBStudentBloodGroup=@ARBStudentBloodGroup,
CommunicableDisease=@CommunicableDisease,
CityID=@CityID,
TelNumber=@TelNumber,
--ARBTelNumber=@ARBTelNumber,
PhoneNumber=@PhoneNumber,
--ARBPhoneNumber=@ARBPhoneNumber,
PermanentAddress=@PermanentAddress,
ARBPermanentAddress=@ARBPermanentAddress,
CorrespondingAddress=@CorrespondingAddress,
ARBCorrespondingAddress=@ARBCorrespondingAddress,
StudentHeight=@StudentHeight,
ARBStudentHeight=@ARBStudentHeight,
StudentWeight=@StudentWeight,
FatherName=@FatherName,
ARBFatherName=@ARBFatherName,
MotherName=@MotherName,
ARBMotherBName=@ARBMotherBName,
GuardianName=@GuardianName,
ARBGuardianName=@ARBGuardianName,
FatherNationality=@FatherNationality,
ARBFatherNationality=@ARBFatherNationality,
MotherNationality=@MotherNationality,
ARBMotherNationality=@ARBMotherNationality,
GuardianNationality=@GuardianNationality,
ARBGuardianNationality=@ARBGuardianNationality,
FatherAddress=@FatherAddress,
ARBFatherAddress=@ARBFatherAddress,
MotherAddress=@MotherAddress,
ARBMotherAddress=@ARBMotherAddress,
GuardianAddress=@GuardianAddress ,
ARBGuardianAddress=@ARBGuardianAddress,
FatherHomePh=@FatherHomePh,
--ARBFatherHomePh=@ARBFatherHomePh,
MotherHomePh=@MotherHomePh,
--ARBMotherHomePh=@ARBMotherHomePh,
GuardianHomePh=@GuardianHomePh,
--ARBGuardianHomePh=@ARBGuardianHomePh,
FatherOfficePh=@FatherOfficePh,
--ARBFatherOfficePh=@ARBFatherOfficePh,
MotherOfficePh=@MotherOfficePh,
--ARBMotherOfficePh=@ARBMotherOfficePh,
GuardianOfficePh=@GuardianOfficePh,
--ARBGuardianOfficePh=@ARBGuardianOfficePh,
FatherFAX=@FatherFAX,
--ARBFatherFAX=@ARBFatherFAX,
MotherFAX=@MotherFAX,
--ARBMotherFAX=@ARBMotherFAX,
GuardianFAX=@GuardianFAX,
--ARBGuardianFAX=@ARBGuardianFAX,
FatherEmailId=@FatherEmailId,
ARBFatherEmailId=@ARBFatherEmailId,
MotherEmailId=@MotherEmailId,
ARBMotherEmailId=@ARBMotherEmailId,
GuardianEmailId=@GuardianEmailId,
ARBGuardianEmailId=@ARBGuardianEmailId,
FatherMobileNo=@FatherMobileNo,
--ARBFatherMobileNo=@ARBFatherMobileNo,
MotherMobileNo=@MotherMobileNo,
--ARBMotherMobileNo=@ARBMotherMobileNo,
GuardianMobileNo=@GuardianMobileNo,
--ARBGuardianMobileNo=@ARBGuardianMobileNo,
FatherJob=@FatherJob,
ARBFatherJob=@ARBFatherJob,
MotherJob=@MotherJob,
ARBMotherJob=@ARBMotherJob,
GuardianJob=@GuardianJob,
ARBGuardianJob=@ARBGuardianJob,
FatherOfficeName=@FatherOfficeName,
ARBFatherOfficeName=@ARBFatherOfficeName,
MotherOfficeName=@MotherOfficeName,
ARBMotherOfficeName=@ARBMotherOfficeName,
GuardianOfficeName=@GuardianOfficeName,
ARBGuardianOfficeName=@ARBGuardianOfficeName,
StudentPicture=@StudentPicture,
FatherPicture=@FatherPicture,
MotherPicture=@MotherPicture,
GuardianPicture=@GuardianPicture,
PhysicianName=@PhysicianName,
ARBPhysicianName=@ARBPhysicianName,
PhysicianPhone=@PhysicianPhone,
--ARBPhysicianPhone=@ARBPhysicianPhone,
PhysicianEmailID =@PhysicianEmailID ,
ARBPhysicianEmailID=@ARBPhysicianEmailID
where
StudentId =@StudentId
update tbstudentclasssession set SectionId= @SectionId,SessionId=null
where
studentid=@studentid
return 2
end
end
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[SPPreviousSchooldetail_delete]
@StudentID int
as
delete from tbPreviousSchoolDetail where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPPreviousSchooldetail2]
(
@StudentID int,
@RegistrationId int,
@ClassId int,
--@CountryID int,
@CityID int,
@FromMonthYear datetime,
@ToMonthYear datetime,
@NameofSchool varchar(200),
@ARBNameofSchool nvarchar(200)
)
as
if(@RegistrationId=0)
begin
set @RegistrationId=null
end
declare @PreviousSchoolID int
select @PreviousSchoolID=isnull(max(PreviousSchoolID),0)+1 from tbPreviousSchoolDetail
insert into tbPreviousSchoolDetail
(
PreviousSchoolID,
StudentID,
RegistrationId,
ClassId,
--CountryID,
CityID,
FromMonthYear,
ToMonthYear,
NameofSchool,
ARBNameofSchool
)
values
(
@PreviousSchoolID,
@StudentID,
@RegistrationId,
@ClassId,
--@CountryID,
@CityID,
@FromMonthYear,
@ToMonthYear,
@NameofSchool,
@ARBNameofSchool
)
return 1
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPSiblingdetail_delete]
@StudentID int
as
delete from tbSiblingsDetail where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPSiblingdetail]
(
@StudentID int,
@SiblingID int,
@SiblingSchool varchar(200),
@ARBSiblingSchool nvarchar(200)
)
as
begin
declare @SiblingDetailID int
select @SiblingDetailID=isnull(max(SiblingDetailID),0)+1 from tbSiblingsDetail
insert into tbSiblingsDetail
(
SiblingDetailID,
StudentID,
SiblingID,
SiblingSchool,
ARBSiblingSchool
)
values
(
@SiblingDetailID,
@StudentID,
@SiblingID,
@SiblingSchool,
@ARBSiblingSchool
)
return 1
end
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPStudentDocuments_delete]
@StudentID int
as
delete from tbStudentDocuments where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SaveStudentDocuments]
(
@StudentID int,
@DocumentID int
)
as
declare @StudentDocumentId int
select @StudentDocumentId = isnull(max(StudentDocumentId),0)+1 from tbStudentDocuments
insert into tbStudentDocuments
(
StudentDocumentId,
StudentID,
DocumentID
)
values
(
@StudentDocumentId,
@StudentID,
@DocumentID
)
return 1
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPStudentMedicine_delete]
@StudentID int
as
delete from tbStudentMedicine where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SaveStudentMedicine]
(
@StudentID int,
@MedicineID int,
@AtAdmTime varchar(5),
@AtVisitNo int
)
as
declare @StudentMedicineID int
select @StudentMedicineID = isnull(max(StudentMedicineID),0)+1 from tbStudentMedicine
insert into tbStudentMedicine
(
StudentMedicineID,
StudentID,
MedicineID,
AtAdmTime,
AtVisitNo
)
values
(
@StudentMedicineID,
@StudentID,
@MedicineID,
@AtAdmTime,
@AtVisitNo
)
return 1
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPStudentExtraCurricular_delete]
@StudentID int
as
delete from tbStudentExtraCurricular where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SPStudentExtraCurricularSave]
(
@StudentId int,
@CurricularId int,
@Remarks varchar(250)
)
as
declare @StudentExtraCurricularId int
select @StudentExtraCurricularId=isnull(max(StudentExtraCurricularId),0)+1 from tbStudentExtraCurricular
insert into tbStudentExtraCurricular
(
StudentExtraCurricularId,
StudentId,
CurricularId,
Remarks
)
values
(
@StudentExtraCurricularId ,
@StudentId ,
@CurricularId ,
@Remarks
)
return 1
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPStudentDisease_delete]
@StudentID int
as
delete from tbStudentDiseases where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SPStudentDiseaseSave]
(
@StudentId int,
@DiseaseID int,
@Precautions varchar(250)
)
as
declare @StudentDiseaseId int
select @StudentDiseaseId = isnull(max(StudentDiseaseId),0)+1 from tbStudentDiseases
insert into tbStudentDiseases
(
StudentDiseaseId ,
StudentId,
DiseaseID,
Precautions
)
values
(
@StudentDiseaseId ,
@StudentId,
@DiseaseID,
@Precautions
)
return 1
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPStudentIdentityDetail_delete]
@StudentID int
as
delete from tbRegStudentIdentityDetail where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[SPRegistrationStudentIdentitySave]
(
@RegistrationID int,
@StudentID int,
@StuIdentityID int,
@StuIdentityNumber varchar(50),
@ARBStuIdentityNumber nvarchar(50),
@StuIssueDate datetime,
@StuIssuePlace varchar(50),
@ARBStuIssuePlace nvarchar(50),
@StuValidUpTo datetime,
@StuVisaType int,
@StuVisaNumber varchar(50),
@ARBStuVisaNumber nvarchar(50),
@StuVisaValidUpTo datetime,
@StuIsForeigner bit
)
as
Declare @StudentRegIdentityID as int
Set @StudentRegIdentityID =(select isnull(max(StudentRegIdentityID),0)+1 as StudentRegIdentityID from tbRegStudentIdentityDetail)
Insert into tbRegStudentIdentityDetail
(
StudentRegIdentityID,
RegistrationID,
StudentID,
StuIdentityID,
StuIdentityNumber,
ARBStuIdentityNumber,
StuIssueDate,
StuIssuePlace,
ARBStuIssuePlace,
StuValidUpTo,
StuVisaType,
StuVisaNumber,
ARBStuVisaNumber,
StuVisaValidUpTo,
StuIsForeigner
)
values
(
@StudentRegIdentityID,
@RegistrationID,
@StudentID,
@StuIdentityID,
@StuIdentityNumber,
@ARBStuIdentityNumber,
@StuIssueDate,
@StuIssuePlace,
@ARBStuIssuePlace,
@StuValidUpTo,
@StuVisaType,
@StuVisaNumber,
@ARBStuVisaNumber,
@StuVisaValidUpTo,
@StuIsForeigner
)
return 1
-- if(@StudentID<>0)
-- Begin
-- update tbRegStudentIdentityDetail set
-- StudentID=@StudentID
-- where RegistrationID=@RegistrationID and StudentID=0
-- End
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPFatherIdentityDetail_delete]
@StudentID int
as
delete from tbRegFatherIdntityDetail where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[SPRegistrationFatherIdentitySave]
(
@RegistrationID int,
@StudentID int,
@FatIdentityID int,
@FatIsForeigner bit,
@FatIdentityNumber varchar(50),
@ARBFatIdentityNumber nvarchar(50),
@FatIssueDate datetime,
@FatIssuePlace varchar(50),
@ARBFatIssuePlace nvarchar(50),
@FatValidUpTo datetime,
@FatVisaType int,
@FatVisaNumber varchar(50),
@ARBFatVisaNumber nvarchar(50),
@FatVisaValidUpTo datetime
)
as
--if(@StudentID=0)
--Begin
declare @FatherRegIdentityID as int
set @FatherRegIdentityID =(select isnull(max(FatherRegIdentityID),0)+1 as FatherRegIdentityID from tbRegFatherIdntityDetail)
insert into tbRegFatherIdntityDetail
(
FatherRegIdentityID,
RegistrationID,
StudentID,
FatIdentityID,
FatIsForeigner,
FatIdentityNumber,
ARBFatIdentityNumber,
FatIssueDate,
FatIssuePlace,
ARBFatIssuePlace,
FatValidUpTo,
FatVisaType,
FatVisaNumber,
ARBFatVisaNumber,
FatVisaValidUpTo
)
values
(
@FatherRegIdentityID,
@RegistrationID,
@StudentID,
@FatIdentityID,
@FatIsForeigner,
@FatIdentityNumber,
@ARBFatIdentityNumber,
@FatIssueDate,
@FatIssuePlace,
@ARBFatIssuePlace,
@FatValidUpTo,
@FatVisaType,
@FatVisaNumber,
@ARBFatVisaNumber,
@FatVisaValidUpTo
)
return 1
--end
--if(@StudentID<>0)
-- Begin
-- update tbRegFatherIdntityDetail set
-- StudentID=@StudentID
-- where RegistrationID=@RegistrationID and StudentID=0
-- End
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPMotherIdentityDetail_delete]
@StudentID int
as
delete from tbRegMotherIdentityDetail where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[SPRegistrationMotherIdentitySave]
(
@RegistrationID int,
@StudentID int,
@MomIdentityID int,
@MomIsForeigner bit,
@MomIdentityNumber varchar(50),
@ARBMomIdentityNumber nvarchar(50),
@MomIssueDate datetime,
@MomIssuePlace varchar(50),
@ARBMomIssuePlace nvarchar(50),
@MomValidUpTo datetime,
@MomVisaType int,
@MomVisaNumber varchar(50),
@ARBMomVisaNumber nvarchar(50),
@MomVisaValidUpTo datetime
)
as
--if(@StudentID=0)
--Begin
declare @MotherRegIdentityID as int
set @MotherRegIdentityID =(select isnull(max(MotherRegIdentityID),0)+1 as MotherRegIdentityID from tbRegMotherIdentityDetail)
insert into tbRegMotherIdentityDetail
(
MotherRegIdentityID,
RegistrationID,
StudentID,
MomIdentityID,
MomIsForeigner,
MomIdentityNumber,
ARBMomIdentityNumber,
MomIssueDate,
MomIssuePlace,
ARBMomIssuePlace,
MomValidUpTo,
MomVisaType,
MomVisaNumber,
ARBMomVisaNumber,
MomVisaValidUpTo
)
values
(
@MotherRegIdentityID,
@RegistrationID,
@StudentID,
@MomIdentityID,
@MomIsForeigner,
@MomIdentityNumber,
@ARBMomIdentityNumber,
@MomIssueDate,
@MomIssuePlace,
@ARBMomIssuePlace,
@MomValidUpTo,
@MomVisaType,
@MomVisaNumber,
@ARBMomVisaNumber,
@MomVisaValidUpTo
)
return 1
--end
--if(@StudentID<>0)
-- Begin
-- update tbRegMotherIdentityDetail set
-- StudentID=@StudentID
-- where RegistrationID=@RegistrationID and StudentID=0
-- End
--return 1
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPGuardianIdentityDetail_delete]
@StudentID int
as
delete from tbRegGuardianIdentityDetail where StudentID=@StudentID
return 4
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[SPRegistrationGuardianIdentitySave]
(
@RegistrationID int,
@StudentID int,
@GuardianIdentityID int,
@GuardianIsForeigner bit,
@GuardianIdentityNumber varchar(50),
@ARBGuardianIdentityNumber nvarchar(50),
@GuardianIssueDate datetime,
@GuardianIssuePlace varchar(50),
@ARBGuardianIssuePlace nvarchar(50),
@GuardianValidUpto datetime,
@GuardianVisaType int,
@GuardianVisaNumber varchar(50),
@ARBGuardianVisaNumber nvarchar(50),
@GuardianVisaValidUpto datetime
)
as
--if(@StudentID=0)
--Begin
declare @GuardianRegIdentityID as int
set @GuardianRegIdentityID =(select isnull(max(GuardianRegIdentityID),0)+1 as GuardianRegIdentityID from tbRegGuardianIdentityDetail)
insert into tbRegGuardianIdentityDetail
(
GuardianRegIdentityID,
RegistrationID,
StudentID,
GuardianIdentityID,
GuardianIsForeigner,
GuardianIdentityNumber,
ARBGuardianIdentityNumber,
GuardianIssueDate,
GuardianIssuePlace,
ARBGuardianIssuePlace,
GuardianValidUpto,
GuardianVisaType,
GuardianVisaNumber,
ARBGuardianVisaNumber,
GuardianVisaValidUpto
)
values
(
@GuardianRegIdentityID,
@RegistrationID,
@StudentID,
@GuardianIdentityID,
@GuardianIsForeigner,
@GuardianIdentityNumber,
@ARBGuardianIdentityNumber,
@GuardianIssueDate,
@GuardianIssuePlace,
@ARBGuardianIssuePlace,
@GuardianValidUpto,
@GuardianVisaType,
@GuardianVisaNumber,
@ARBGuardianVisaNumber,
@GuardianVisaValidUpto
)
return 1
--end
--if(@StudentID<>0)
-- Begin
-- update tbRegMotherIdentityDetail set
-- StudentID=@StudentID
-- where RegistrationID=@RegistrationID and StudentID=0
-- End
--return 1
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SP_StudentAdmission] --5,''
(
@RegistrationId int,
@StudentName varchar(50)
)
AS
--exec SPStudentRegistrationDetailForReport @RegistrationId
if exists(Select * from tbregistrationmaster where registrationid=@RegistrationId)
begin
if exists(select * from tbRegistrationfeesreceipt where registrationid=@RegistrationId)
begin
if exists(select * from tbInterviewmaster where registrationid=@RegistrationId)
begin
Select
RM.RegistrationId
,Convert(varchar(50),RegistrationDate,106) AS RegistrationDate
,CM.ClassID
,ClassName
,GroupID
,StudentName
,LastName
,FamilyName
,convert(varchar(50),DateOfBirth,106) AS DateOfBirth
,datediff(yy,DateOfBirth,getdate()) as Age
,Gender
,RM.CityId
,csc.CityName
,csc.StateName
,csc.CountryName
,Address
,StudentEmailId
,StudentPhoneNo
,StudentMobileNo
,GuardianRelationId
,GuardianName
,FatherName
,MotherName
,AdmissionFees
,Convert(varchar(50),Date,106) AS Date
,Time
,ISInterview
,Reason
,Status
,StatusReason
From tbInterviewMaster IM Right Outer Join tbRegistrationMaster RM
On RM.RegistrationId=IM.RegistrationId Left Outer Join
tbClassMaster CM ON RM.ClassID=CM.ClassID
Left Outer join vwCityStateCounry csc on RM.CityID=csc.CityID
Where RM.RegistrationId=@RegistrationId or RM.StudentName=@StudentName
Select SD.ClassID,SD.NameofSchool,SD.ARBNameOFSchool,Convert(varchar(50),SD.FromMonthYear,106) as FromMonthYear
,convert(varchar(50),SD.ToMonthYear,106) as ToMonthYear,SD.CityID,csc.CityName,Cm.ClassName
From tbClassMaster CM Right outer join tbPreviousSchoolDetail SD On SD.ClassID=CM.ClassID left Outer Join
vwCityStateCounry csc on csc.cityID=SD.Cityid
Where SD.RegistrationId=@RegistrationId
-------------------------------------------------------------
Select count(*) as counts from tbRegistrationMaster rm inner join tbStudentMaster sm on rm.RegistrationId=sm.RegistrationId where rm.RegistrationId=@RegistrationId
-------------------------------------------------------------
end
end
end
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPStudentDetailSelect]
(
@StudentName varchar(50),
@AdmissionNo varchar(50),
@ClassID int,
@SectionID int
)
AS
begin
declare @qry varchar(max)
set @qry='select * from vw_Studentmasternew where 1=1 '
if (@StudentName !='')
Begin
set @qry=@Qry+' And StudentName = ''' + @StudentName +''''
End
if(@AdmissionNo!='')
begin
set @qry=@Qry+' And AdmissionNo = ''' + @AdmissionNo+''''
end
if (@ClassId !=0)
Begin
set @qry=@Qry+' And ClassId = ' + convert(varchar,@ClassId)
End
if (@SectionID !=0)
Begin
set @qry=@Qry+' And SectionID = ' + convert(varchar,@SectionID)
End
exec (@qry)
end
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[SPGetAdmissionDetail]
(@StudentID int)
as
----Sibling Detail----------------------------------------------------------------------------------------------------------------------
Select SB.SiblingDetailID,SB.StudentID,sm.classid,sm.className,sm.sectionid ,sm.SectionName,SB.SiblingID,SiblingSchool,ARBSiblingSchool,sm.StudentName as SiblingName from tbSiblingsDetail Sb
inner join vw_studentmasternew sm on sb.studentID=sm.studentID
where sm.StudentID=@StudentID
----------------------------------------------------------------------------------------------------------------------------------------
----------------Previous School Details -------------------------------------------------------------------------------------------------------------------
select
PSD.RegistrationId,
PSD.StudentID,
PSD.ClassId,
PSD.CountryID,
PSD.CityID,
Convert(varchar(50),FromMonthYear,106) AS FromMonthYear,
Convert(varchar(50),ToMonthYear,106) AS ToMonthYear,
PSD.NameofSchool,
PSD.ARBNameofSchool,
PSD.PreviousSchoolID,
CM.ClassName,
CM.ARBClassName,
CM.ClassID,
CI.CityName
from tbClassMaster CM
Right outer join tbPreviousSchoolDetail PSD on
CM.ClassID =PSD.ClassID right outer join tbCityMaster CI on CI.CItyID=PSD.CityID
where StudentID=@StudentID
------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------Concession Details--------------------------------------------------------------------------------------------------------------------------
Select CD.*,CM.ChargeName from tbConcessionDetail CD Left Outer Join tbChargeMaster CM on CD.ChargeID=CM.ChargeID where StudentID=@StudentID
-------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------StudentExtraCurriDetails-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select SEC.ExtraCurricularID,SEC.ExtraCurricularName
from tbStudentExtraCurricular SID
Left outer join tbExtraCurricularMaster
SEC on SID.CurricularID=SEC.ExtraCurricularID where StudentID=@StudentID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------StudentDisease----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Select DM.DiseaseID As DiseaseID,DM.DiseaseName
From tbStudentDiseases SD Left outer Join tbDiseaseMaster DM On SD.DiseaseID=DM.DiseaseID Where StudentID=@StudentID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------StudentDocument---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Select DM.DocumentID from tbStudentDocuments tSD Left Outer Join tbDocumentMaster DM ON tsd.DocumentID=DM.DocumentID Where StudentID=@StudentID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------StudentMedicine---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Select DM.MedicineID from tbStudentMedicine SM Left Outer Join tbMedicineMaster DM On SM.MedicineID=DM.MedicineID Where StudentID=@StudentID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPStudentIdentitySelect]
(@StudentID int)
AS
Select * from tbRegStudentIdentityDetail
where StudentID=@StudentID
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPFatherIdentitySelect]
(@StudentID int)
AS
select * from tbRegFatherIdntityDetail
Where StudentID=@StudentID
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPMotherIdentitySelect]
(@StudentID int)
AS
select * from tbRegMotherIdentityDetail
Where StudentID=@StudentID
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPGuardianIdentitySelect]
(@StudentID int)
AS
select * from tbRegGuardianIdentityDetail
Where StudentID=@StudentID
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[sp_TransportReport]
(
@VehicleId int
)
as
begin
SELECT vw.StudentName,vw.Address,vw.PhoneNumber,dm.ContactNo,tc.AreaType,
vw.Class,vm.VehiclaNo,vm.VehicleType,tc.AreaName,vw.ParentidFather
from
vw_studentmasternew vw left Outer join tbStudentTransportationMaster stm
on
vw.StudentId=stm.StudentID left outer join tbVehicleMaster vm
on
stm.VehicleId=vm.VehicleId left outer join tbTransportCharges tc
on
stm.TransportChargeId=tc.TransportChargeId left outer join tbVehicleDriverRelation vdr
on
vm.VehicleID=vdr.VehicleID left outer join tbdriverMaster dm
on
vdr.DriverID=dm.DriverID
where vm.VehicleID=@VehicleID
end
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[Sp_TransportReports]
as
begin
SELECT vw.StudentName,vw.Address,vw.PhoneNumber,
vw.Class,vm.VehiclaNo,vm.VehicleType,tc.AreaName,vw.parentidFather ,dm.ContactNo,tc.AreaType
from
vw_studentmasternew vw left outer join tbStudentTransportationMaster stm
on
vw.StudentId=stm.StudentID left outer join tbVehicleMaster vm
on
stm.VehicleId=vm.VehicleId left outer join tbTransportCharges tc
on
stm.TransportChargeId=tc.TransportChargeId left outer join tbVehicleDriverRelation vdr
on
vm.VehicleID=vdr.VehicleID left outer join tbdriverMaster dm
on
vdr.DriverID=dm.DriverID
end
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
== Power houses and family homes ==
[[Image:Compton Wynyates.gif|thumb|left|thumb|350px|15th century: [[Compton Wynyates]]. Today the private residence of the family who built it, Compton Wynyates was one of the last houses in England to be laid siege in the 17th century]]
The inhabitants of the English country house have become collectively referred to as the Ruling class, because this is exactly what they did in varying degrees, whether by holding high political influence and power in national government or in the day-to-day running of their own localities in such offices as [[magistrates]], or occasionally even [[clergy]]. These [[aristocracy (class)|aristocrat]]s continued, in diminishing degrees, to frequently hold the highest offices until well into the second half of the 20th century. Sir [[Winston Churchill]] and Sir [[Alec Douglas-Home]] were the last [[Prime Minister]]s to spring from this class. So necessary was the country house deemed to be that following the election of the first Labour Government in 1921, [[Arthur Lee, 1st Viscount Lee of Fareham|Viscount Lee of Fareham]] donated his country house [[Chequers]] to the nation for the use of a [[Prime Minister]] who might not possess one of his own. Chequers still fulfils that need today as do both [[Chevening House]] and [[Dorneywood]] country houses, donated for sole use of high-ranking ministers of the crown.
== Zenith ==
[[File:Group portrait Hardwick House Hawstead Suffolk 1887.jpg|thumb|right|250px|House party, [[Hardwick House (Suffolk)|Hardwick House]], [[Hawstead]], [[Suffolk]], 1887.]]
During the 18th and 19th centuries to the highest echelons of British society the country house served as a place for relaxing, [[hunting]] and running the country with one's equals at the end of the week, with some houses having their own [[Country House Theatres|theatre]] where performances were held. However, there were many [[Squire]]s who lived permanently on their country estates, seldom visiting London at all. The country house was the centre of its own world, providing employment to literally hundreds of people in the vicinity of its [[estate (house)|estate]]. In previous eras when state benefits were unheard of, those working on an estate were among the most fortunate, receiving secured employment and rent-free accommodation. At the summit of these fortunate people was the indoor staff of the country house. Until the 20th century, unlike many of their contemporaries, they slept in proper beds, wore well-made adequate clothes and received three proper meals a day, plus a small wage. In an era when many still died for lack of [[medicine]] or malnutrition, the long working hours were a small price to pay. The [[film]] ''[[Gosford Park]]'', the reality series ''[[The Edwardian Country House]]'' and some episodes of the [[TV series]] ''[[Upstairs, Downstairs]]'' accurately recreated the stratified and repressed but secure atmosphere of the English country house just surviving into the age of the automobile.
Many aristocrats owned more than one country house and would visit each according to the season: [[Grouse]] shooting in [[Scotland]], [[pheasant]] shooting and [[fox hunting]] in England. The [[Earl of Rosebery]], for instance, had [[Dalmeny House]] in Scotland, [[Mentmore Towers]] in [[Buckinghamshire]] and another near [[Epsom]] just for the racing season. The largest country house in England is [[Blenheim Palace]], compared with [[Hopetoun House]] in Scotland, [[Castletown House]] in Ireland and possibly [[Penrhyn Castle]], [[Chirk Castle]], [[Erddig]] or [[Glynllifon]] in Wales. The largest in Derbyshire is [[Chatsworth House]], and in Cambridgeshire is [[Wimpole Hall]].
== Decline ==
[[File:Entrance drive and porch Hardwick House Hawstead Suffolk.jpg|thumb|right|250px|[[Hardwick House (Suffolk)|Hardwick House]], [[Hawstead]], [[Suffolk]]. Built by the [[Robert Drury|Drury family]], the home was purchased by the [[Cullum Baronets|Cullums]], who enlarged it. When the last Cullum heir died in the 20th century, the house was demolished, the ruins used for building materials.]]
The slow decline of the English country house coincided with the rise of modern industry, which provided alternate means of employment for large numbers of people and contributed to upwardly mobile [[middle class]]es, but its ultimate demise began immediately following [[World War I]]. The huge staff required to maintain them had either left to fight and never returned, departed to work in the munitions factories, or to fulfil the void left by the fighting men in other workplaces. Of those who returned with the cessation of war, many left the countryside for better-paid jobs in towns. The final blow for many country houses came following [[World War II]]; having been requisitioned during the war, they were returned to the owners in poor repair. Many of whom having lost their heirs, if not in the immediately preceding war then in World War I, were now paying far higher rates of [[tax]], and [[agricultural]] incomes from the accompanying estates had dropped. Thus, the solution appeared to be to hold [[English country house contents auctions|contents auctions]] and then demolish the house and sell its stone, [[fireplace]]s, and [[panelling]]. And this is exactly what happened to many of Britain's finest houses.
Today in Britain, country houses provide for a variety of needs. Many are owned by public bodies such as [[Kedleston Hall]], [[Knole House]], [[Lyme Park]], [[Montacute House]], [[Petworth House]], [[West Wycombe Park]] and [[Waddesdon Manor]], owned by the [[National Trust for Places of Historic Interest or Natural Beauty|National Trust]], [[Brodsworth Hall]], [[Kenwood House]] & [[Osborne House]] are owned by [[English Heritage]] and are open to the public as museums as part of the so-called "[[Stately home]] industry". Some, including [[Wilton House]] and [[Chatsworth House]], and many smaller houses such as [[Pencarrow]] in [[Cornwall]] and [[Rousham House]] in [[Oxfordshire]] are still owned by the families who built them, retain their [[treasure]]s and are open during summer months to the public. Fewer still are owned by the original families and are not open to the public: [[Compton Wynyates]] is one. [[Easton Neston]] in [[Northamptonshire]], one of the last of the architecturally important country houses never to have been opened to public viewing, was sold in 2005 for £15 million by [[Lord Hesketh]].
== Today's English country house ==
The majority have become schools, hospitals, museums and prisons. Some, for example, [[Cliveden]], [[Coworth House]], [[Hartwell House]], [[Peckforton Castle]] & [[Taymouth Castle]], have become luxury hotels. Examples used as schools or other educational uses include [[Ashridge Business School|Ashridge House]], [[Bramshill House]], [[Dartington Hall]], [[Harlaxton Manor]], [[Heslington Hall]], [[Prior Park College|Prior Park]], [[Scarisbrick Hall]], [[Stowe House]], [[Tring Park]] & [[Westonbirt House]]. [[Hewell (HM Prison)|Hewell Grange]] is now an open prison. [[Compton Verney]] is now an art gallery, [[Cusworth Hall]] is now the museum of South Yorkshire Life, [[Duff House]] & [[Paxton House, Berwickshire|Paxton House]] are outstations of the [[National Gallery of Scotland]], [[Temple Newsam|Temple Newsam House]] is a museum of the decorative arts, [[St Fagans National History Museum]] is based in and around St Fagans Castle, [[Wollaton Hall]] is now a natural history museum. The [[National Portrait Gallery (London)]] has several outstations at country houses: [[Montacute House]] is partially used to display Elizabethan and Jacobean portraits; [[Beningbrough Hall]] is used to display 18th-century portraits and [[Bodrhyddan Hall]] displays 19th-century portraits. [[Alton Towers]] has become an amusement park. [[Knebworth House]] stages rock concerts in the park. [[Glyndebourne]] has an [[opera house]] attached. [[Port Lympne Wild Animal Park|Port Lympne]] is now a zoo, several houses also have [[Safari park]]s in the grounds: [[Knowsley Hall]] (The house has never been open to the public), [[Longleat]] & [[Woburn Abbey]]. [[Clouds House]] is used as a centre for treating alcoholics and drug addicts. [[Moor Park (house)|Moor Park]] is a golf club-house. [[Halton House]] is used by the Royal Air Force and [[Minley Manor]] is used by the army. Another common use of country houses is to convert them for multiple occupation [[Kinmel Hall]], [[New Wardour Castle]], [[Sheffield Park Garden|Sheffield Park House]] & [[Stoneleigh Abbey]] whose former park [[Stoneleigh Park]] is used for exhibitions and agricultural shows. [[Culzean Castle]], [[Margam Castle]] & [[Tatton Hall]] are at the centre of country parks. [[Goodwood House]] is a centre of both horse & motor racing. [[Ince Blundell|Ince Blundell Hall]] is now a nunnery. [[Toddington Manor]] is being convert into an art gallery and home by [[Damien Hirst]]. Many houses are now in the ownership of [[Local government]] and operated as country house museums including [[Ashton Court]], [[Aston Hall]] being the first to be so owned from 1864, [[Cardiff Castle]], [[Heaton Park|Heaton Hall]] & [[Tredegar House]]. [[Ditchley]] is owned and used for conferences by the [[Ditchley Foundation]]. Some houses have survived as conserved ruins: [[Kirby Hall]], [[Lowther Castle]] & [[Witley Court]]. These are among the fortunate few. In Britain during the 1920s to the early 1960s, thousands of country houses were demolished including [[East Cowes Castle]], [[Hamilton Palace]] & [[Nuthall Temple]].
Today owning a "Country House" can be a mixed blessing. Usually listed as a building of historic interest, they can only be maintained under Government supervision, often interpreted by the owners as interference as the most faithful, most accurate, and most precise restoration and recreation is also usually the most expensive and the one Government inspectors insist upon. This system does, however, ensure that all work is correctly and authentically done. The negative side is that many owners cannot afford the work, so a roof remains leaking for the sake of a cheap roof tile. Although the ownership or management of some houses has been transferred to a [[Trust law|private trust]] such as [[Blair Castle]], [[Burghley House]], [[Grimsthorpe Castle]] and [[Hopetoun House]]. Other houses have transferred art works and furnishings under the [[Acceptance in Lieu]] scheme to ownership by various national or local museums, but are retained for display in the building. This enables the former owners to offset tax, the payment of which would otherwise have necessitated the sale of the art works, for example tapestries and furniture at [[Houghton Hall]] are now owned by the [[Victoria and Albert Museum]]. Increasing numbers of country houses hold licenses for [[Wedding|weddings]] and [[Civil ceremony|civil ceremonies]]. Another source of income is use as a [[Filming location|film location]], many of the houses listed on the page have been used for this purpose. Many of the larger houses are available for hire for [[Corporate entertainment]]. Another source of revenue is using houses for [[Murder mystery game]]s.
== See also ==
*[[Stately home]]
*[[List of historic houses in England]]
*[[List of National Trust properties in England]]
*[[List of English Heritage properties]]
*[[List of castles in England]]
*[[List of historic buildings and architects of the United Kingdom]] - country house architectural periods and styles
*[[Historic house]]
*[[Manor House]]
*[[Great house]]
*[[English country house contents auctions]]
*[[Country House Theatres]]
*[[Treasure Houses of England]]
*[[Country house poems]]
*''[[Country Life (magazine)|Country Life]]''
*[[Category:Britain's lost houses]]
==References==
*{{Cite book |last=Airs |first=Malcolm |year=1975 |title=The Making of the English Country House, 1500–1640 |location=London |publisher=Architectural Press |isbn=0851393780 }}
*{{Cite book |last=Girouard |first=Mark |author-link=Mark Girouard |title=Life in the English Country House: a social and architectural history |location=New Haven |publisher=Yale University Press |year=1978 |isbn=0300022735 }} <small>Details the impact of social change on design.</small>
*{{Cite book |last=Lewis |first=Lesley |author-link=Lesley Lewis |title=The Private Life of a Country House |location=Stroud |publisher=Sutton |year=1997 |isbn=0750916788 }} <small>Gives much detail of how a smaller country house operated in the early 20th century.</small>
==External links==
{{Commons|Castles, palaces and houses in England}}
*[http://www.nationaltrust.org.uk The National Trust - England, Wales, & Northern Ireland]
*[http://www.nts.org.uk The National Trust for Scotland]
*[http://www.english-heritage.org.uk English Heritage]
*[http://www.hha.org.uk Historic Houses Association]
*[http://www.hudsonsguide.co.uk Hudson's Historic Houses and Gardens] - [[Norman Hudson|Hudson's]] list of 2,000 properties open to the public
*[http://www.dicamillocompanion.com The DiCamillo Companion to British & Irish Country Houses]
*[http://www.lostheritage.org.uk Lost Heritage - A Memorial to the Lost Country Houses of England]
*[http://countryhouses.wordpress.com Country House news blog]
*[http://toddingtonmanor.blogspot.com An English Manor House Head Gardener's Online Diary]
[[Category:House types in the United Kingdom]]
[[Category:English architecture]]
[[Category:Country houses]]
[[es:Casa de campo]]
[[it:Casa di campagna inglese]]
[[mk:Куќа на село]]
[[ja:カントリー・ハウス]]
[[pt:Casa de campo]]
[[simple:English country house]]
[[th:คฤหาสน์ชนบท]]' |
