// --------------------------------------------------------------------------------
/// <summary>
/// Returns a value indicating whether the specified number evaluates to positive
/// infinity.
/// </summary>
/// <param name="d">DBDouble value</param>
/// <returns>True, if this is a positive infinity value.</returns>
// --------------------------------------------------------------------------------
public static bool IsPositiveInfinity(DBDouble d)
{
return Double.IsPositiveInfinity (d.m_Value);
}
// --------------------------------------------------------------------------------
/// <summary>
/// Returns a value indicating whether the specified number evaluates to a value
/// that is not a number (NaN).
/// </summary>
/// <param name="d">DBDouble value</param>
/// <returns>True, if this is NaN</returns>
// --------------------------------------------------------------------------------
public static bool IsNaN(DBDouble d)
{
return Double.IsNaN (d.m_Value);
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public OrganisationBase(DBGuid IDVal,
OrganisationBase origInstance)
{
m_ID = IDVal;
m_Name = origInstance.m_Name;
m_Department = origInstance.m_Department;
m_PostCode = origInstance.m_PostCode;
m_City = origInstance.m_City;
m_Address = origInstance.m_Address;
m_RegionRef = origInstance.m_RegionRef;
m_Country = origInstance.m_Country;
m_MailingPostCode = origInstance.m_MailingPostCode;
m_MailingCity = origInstance.m_MailingCity;
m_MailingAddress = origInstance.m_MailingAddress;
m_Phone1 = origInstance.m_Phone1;
m_Phone2 = origInstance.m_Phone2;
m_Phone3 = origInstance.m_Phone3;
m_PhoneDiscounted = origInstance.m_PhoneDiscounted;
m_Fax = origInstance.m_Fax;
m_Email1 = origInstance.m_Email1;
m_Email2 = origInstance.m_Email2;
m_Email3 = origInstance.m_Email3;
m_HomePage = origInstance.m_HomePage;
m_ContactName = origInstance.m_ContactName;
m_ContactPhone = origInstance.m_ContactPhone;
m_ContactEmail = origInstance.m_ContactEmail;
m_Description = origInstance.m_Description;
m_CallingHours = origInstance.m_CallingHours;
m_OrganisationFormRef = origInstance.m_OrganisationFormRef;
m_SourceGovernment = origInstance.m_SourceGovernment;
m_SourceCompetition = origInstance.m_SourceCompetition;
m_SourceSponsor = origInstance.m_SourceSponsor;
m_SourceDonation = origInstance.m_SourceDonation;
m_SourceTax = origInstance.m_SourceTax;
m_SourceOther = origInstance.m_SourceOther;
m_SourceOtherName = origInstance.m_SourceOtherName;
m_EstablishmentYear = origInstance.m_EstablishmentYear;
m_ActivityPrevention = origInstance.m_ActivityPrevention;
m_ActivityResearch = origInstance.m_ActivityResearch;
m_ActivityRehabilitation = origInstance.m_ActivityRehabilitation;
m_ActivityOther = origInstance.m_ActivityOther;
m_WorkingAreaRef = origInstance.m_WorkingAreaRef;
m_WorkingAreaOther = origInstance.m_WorkingAreaOther;
m_WorkersFix = origInstance.m_WorkersFix;
m_WorkersExternal = origInstance.m_WorkersExternal;
m_WorkersVolunteer = origInstance.m_WorkersVolunteer;
m_IsActive = origInstance.m_IsActive;
m_JobPsychologist = origInstance.m_JobPsychologist;
m_JobPsychiater = origInstance.m_JobPsychiater;
m_JobDoctor = origInstance.m_JobDoctor;
m_JobMedicalExpert = origInstance.m_JobMedicalExpert;
m_JobHealthExpert = origInstance.m_JobHealthExpert;
m_JobSociologist = origInstance.m_JobSociologist;
m_JobSocialPolitician = origInstance.m_JobSocialPolitician;
m_JobSocialWorker = origInstance.m_JobSocialWorker;
m_JobSocialPedagogist = origInstance.m_JobSocialPedagogist;
m_JobPedagogist = origInstance.m_JobPedagogist;
m_JobManualist = origInstance.m_JobManualist;
m_JobLawyer = origInstance.m_JobLawyer;
m_JobPoliceman = origInstance.m_JobPoliceman;
m_JobMentalhygiene = origInstance.m_JobMentalhygiene;
m_JobCultureOrganizer = origInstance.m_JobCultureOrganizer;
m_JobOther1 = origInstance.m_JobOther1;
m_JobOther2 = origInstance.m_JobOther2;
m_JobOther3 = origInstance.m_JobOther3;
m_JobOtherName1 = origInstance.m_JobOtherName1;
m_JobOtherName2 = origInstance.m_JobOtherName2;
m_JobOtherName3 = origInstance.m_JobOtherName3;
m_IsKef = origInstance.m_IsKef;
m_RegionSearchCodeRef = origInstance.m_RegionSearchCodeRef;
m_DistrictSearchCodeRef = origInstance.m_DistrictSearchCodeRef;
m_IntroduceText = origInstance.m_IntroduceText;
m_DrogStrategyDescription = origInstance.m_DrogStrategyDescription;
m_AreaDescription = origInstance.m_AreaDescription;
m_EstablishmentMonth = origInstance.m_EstablishmentMonth;
m_AreaHomePage = origInstance.m_AreaHomePage;
m_LastModified = origInstance.m_LastModified;
m_IntroduceTextLastModified = origInstance.m_IntroduceTextLastModified;
m_AreaDescriptionLastModified = origInstance.m_AreaDescriptionLastModified;
m_DrogStrategyLastModified = origInstance.m_DrogStrategyLastModified;
m_KefMembersLastModified = origInstance.m_KefMembersLastModified;
m_KefDownloadsLastModified = origInstance.m_KefDownloadsLastModified;
m_KefEventsLastModified = origInstance.m_KefEventsLastModified;
m_ValidationState = origInstance.m_ValidationState;
m_LastValidationDate = origInstance.m_LastValidationDate;
m_IsActual = origInstance.m_IsActual;
}
public void ndihdOrganisationUpdate(DBGuid uID,
DBString cName,
DBString cDepartment,
DBString cPostCode,
DBString cCity,
DBString cAddress,
DBString cRegionRef,
DBString cCountry,
DBString cMailingPostCode,
DBString cMailingCity,
DBString cMailingAddress,
DBString cPhone1,
DBString cPhone2,
DBString cPhone3,
DBString cPhoneDiscounted,
DBString cFax,
DBString cEmail1,
DBString cEmail2,
DBString cEmail3,
DBString cHomePage,
DBString cContactName,
DBString cContactPhone,
DBString cContactEmail,
DBString cDescription,
DBString cCallingHours,
DBString cOrganisationFormRef,
DBDouble nSourceGovernment,
DBDouble nSourceCompetition,
DBDouble nSourceSponsor,
DBDouble nSourceDonation,
DBDouble nSourceTax,
DBDouble nSourceOther,
DBString cSourceOtherName,
DBString cEstablishmentYear,
bool bActivityPrevention,
bool bActivityResearch,
bool bActivityRehabilitation,
bool bActivityOther,
DBString cWorkingAreaRef,
DBString cWorkingAreaOther,
DBInt nWorkersFix,
DBInt nWorkersExternal,
DBInt nWorkersVolunteer,
bool bIsActive,
DBInt nJobPsychologist,
DBInt nJobPsychiater,
DBInt nJobDoctor,
DBInt nJobMedicalExpert,
DBInt nJobHealthExpert,
DBInt nJobSociologist,
DBInt nJobSocialPolitician,
DBInt nJobSocialWorker,
DBInt nJobSocialPedagogist,
DBInt nJobPedagogist,
DBInt nJobManualist,
DBInt nJobLawyer,
DBInt nJobPoliceman,
DBInt nJobMentalhygiene,
DBInt nJobCultureOrganizer,
DBInt nJobOther1,
DBInt nJobOther2,
DBInt nJobOther3,
DBString cJobOtherName1,
DBString cJobOtherName2,
DBString cJobOtherName3,
bool bIsKef,
DBString cRegionSearchCodeRef,
DBInt nDistrictSearchCodeRef,
DBString cIntroduceText,
DBString cDrogStrategyDescription,
DBString cAreaDescription,
DBString cEstablishmentMonth,
DBString cAreaHomePage,
DBDateTime dLastModified,
DBDateTime dIntroduceTextLastModified,
DBDateTime dAreaDescriptionLastModified,
DBDateTime dDrogStrategyLastModified,
DBDateTime dKefMembersLastModified,
DBDateTime dKefDownloadsLastModified,
DBDateTime dKefEventsLastModified,
DBString cValidationState,
DBDateTime dLastValidationDate,
bool bIsActual)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cDepartment", SqlDbType.VarChar, 250);
p3.Value = cDepartment.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cPostCode", SqlDbType.VarChar, 10);
p4.Value = cPostCode.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cCity", SqlDbType.VarChar, 100);
p5.Value = cCity.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cAddress", SqlDbType.VarChar, 100);
p6.Value = cAddress.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cRegionRef", SqlDbType.Char, 10);
p7.Value = cRegionRef.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cCountry", SqlDbType.VarChar, 100);
p8.Value = cCountry.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cMailingPostCode", SqlDbType.VarChar, 10);
p9.Value = cMailingPostCode.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@cMailingCity", SqlDbType.VarChar, 100);
p10.Value = cMailingCity.Value;
SqlParameter p11 = sqlComm.Parameters.Add("@cMailingAddress", SqlDbType.VarChar, 100);
p11.Value = cMailingAddress.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@cPhone1", SqlDbType.VarChar, 20);
p12.Value = cPhone1.Value;
SqlParameter p13 = sqlComm.Parameters.Add("@cPhone2", SqlDbType.VarChar, 20);
p13.Value = cPhone2.Value;
SqlParameter p14 = sqlComm.Parameters.Add("@cPhone3", SqlDbType.VarChar, 20);
p14.Value = cPhone3.Value;
SqlParameter p15 = sqlComm.Parameters.Add("@cPhoneDiscounted", SqlDbType.VarChar, 20);
p15.Value = cPhoneDiscounted.Value;
SqlParameter p16 = sqlComm.Parameters.Add("@cFax", SqlDbType.VarChar, 20);
p16.Value = cFax.Value;
SqlParameter p17 = sqlComm.Parameters.Add("@cEmail1", SqlDbType.VarChar, 250);
p17.Value = cEmail1.Value;
SqlParameter p18 = sqlComm.Parameters.Add("@cEmail2", SqlDbType.VarChar, 250);
p18.Value = cEmail2.Value;
SqlParameter p19 = sqlComm.Parameters.Add("@cEmail3", SqlDbType.VarChar, 250);
p19.Value = cEmail3.Value;
SqlParameter p20 = sqlComm.Parameters.Add("@cHomePage", SqlDbType.VarChar, 250);
p20.Value = cHomePage.Value;
SqlParameter p21 = sqlComm.Parameters.Add("@cContactName", SqlDbType.VarChar, 250);
p21.Value = cContactName.Value;
SqlParameter p22 = sqlComm.Parameters.Add("@cContactPhone", SqlDbType.VarChar, 20);
p22.Value = cContactPhone.Value;
SqlParameter p23 = sqlComm.Parameters.Add("@cContactEmail", SqlDbType.VarChar, 250);
p23.Value = cContactEmail.Value;
SqlParameter p24 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 1000);
p24.Value = cDescription.Value;
SqlParameter p25 = sqlComm.Parameters.Add("@cCallingHours", SqlDbType.VarChar, 1000);
p25.Value = cCallingHours.Value;
SqlParameter p26 = sqlComm.Parameters.Add("@cOrganisationFormRef", SqlDbType.Char, 10);
p26.Value = cOrganisationFormRef.Value;
SqlParameter p27 = sqlComm.Parameters.Add("@nSourceGovernment", SqlDbType.Float);
p27.Value = nSourceGovernment.Value;
SqlParameter p28 = sqlComm.Parameters.Add("@nSourceCompetition", SqlDbType.Float);
p28.Value = nSourceCompetition.Value;
SqlParameter p29 = sqlComm.Parameters.Add("@nSourceSponsor", SqlDbType.Float);
p29.Value = nSourceSponsor.Value;
SqlParameter p30 = sqlComm.Parameters.Add("@nSourceDonation", SqlDbType.Float);
p30.Value = nSourceDonation.Value;
SqlParameter p31 = sqlComm.Parameters.Add("@nSourceTax", SqlDbType.Float);
p31.Value = nSourceTax.Value;
SqlParameter p32 = sqlComm.Parameters.Add("@nSourceOther", SqlDbType.Float);
p32.Value = nSourceOther.Value;
SqlParameter p33 = sqlComm.Parameters.Add("@cSourceOtherName", SqlDbType.VarChar, 100);
p33.Value = cSourceOtherName.Value;
SqlParameter p34 = sqlComm.Parameters.Add("@cEstablishmentYear", SqlDbType.Char, 4);
p34.Value = cEstablishmentYear.Value;
SqlParameter p35 = sqlComm.Parameters.Add("@bActivityPrevention", SqlDbType.Bit);
p35.Value = bActivityPrevention;
SqlParameter p36 = sqlComm.Parameters.Add("@bActivityResearch", SqlDbType.Bit);
p36.Value = bActivityResearch;
SqlParameter p37 = sqlComm.Parameters.Add("@bActivityRehabilitation", SqlDbType.Bit);
p37.Value = bActivityRehabilitation;
SqlParameter p38 = sqlComm.Parameters.Add("@bActivityOther", SqlDbType.Bit);
p38.Value = bActivityOther;
SqlParameter p39 = sqlComm.Parameters.Add("@cWorkingAreaRef", SqlDbType.Char, 10);
p39.Value = cWorkingAreaRef.Value;
SqlParameter p40 = sqlComm.Parameters.Add("@cWorkingAreaOther", SqlDbType.VarChar, 500);
p40.Value = cWorkingAreaOther.Value;
SqlParameter p41 = sqlComm.Parameters.Add("@nWorkersFix", SqlDbType.Int);
p41.Value = nWorkersFix.Value;
SqlParameter p42 = sqlComm.Parameters.Add("@nWorkersExternal", SqlDbType.Int);
p42.Value = nWorkersExternal.Value;
SqlParameter p43 = sqlComm.Parameters.Add("@nWorkersVolunteer", SqlDbType.Int);
p43.Value = nWorkersVolunteer.Value;
SqlParameter p44 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p44.Value = bIsActive;
SqlParameter p45 = sqlComm.Parameters.Add("@nJobPsychologist", SqlDbType.Int);
p45.Value = nJobPsychologist.Value;
SqlParameter p46 = sqlComm.Parameters.Add("@nJobPsychiater", SqlDbType.Int);
p46.Value = nJobPsychiater.Value;
SqlParameter p47 = sqlComm.Parameters.Add("@nJobDoctor", SqlDbType.Int);
p47.Value = nJobDoctor.Value;
SqlParameter p48 = sqlComm.Parameters.Add("@nJobMedicalExpert", SqlDbType.Int);
p48.Value = nJobMedicalExpert.Value;
SqlParameter p49 = sqlComm.Parameters.Add("@nJobHealthExpert", SqlDbType.Int);
p49.Value = nJobHealthExpert.Value;
SqlParameter p50 = sqlComm.Parameters.Add("@nJobSociologist", SqlDbType.Int);
p50.Value = nJobSociologist.Value;
SqlParameter p51 = sqlComm.Parameters.Add("@nJobSocialPolitician", SqlDbType.Int);
p51.Value = nJobSocialPolitician.Value;
SqlParameter p52 = sqlComm.Parameters.Add("@nJobSocialWorker", SqlDbType.Int);
p52.Value = nJobSocialWorker.Value;
SqlParameter p53 = sqlComm.Parameters.Add("@nJobSocialPedagogist", SqlDbType.Int);
p53.Value = nJobSocialPedagogist.Value;
SqlParameter p54 = sqlComm.Parameters.Add("@nJobPedagogist", SqlDbType.Int);
p54.Value = nJobPedagogist.Value;
SqlParameter p55 = sqlComm.Parameters.Add("@nJobManualist", SqlDbType.Int);
p55.Value = nJobManualist.Value;
SqlParameter p56 = sqlComm.Parameters.Add("@nJobLawyer", SqlDbType.Int);
p56.Value = nJobLawyer.Value;
SqlParameter p57 = sqlComm.Parameters.Add("@nJobPoliceman", SqlDbType.Int);
p57.Value = nJobPoliceman.Value;
SqlParameter p58 = sqlComm.Parameters.Add("@nJobMentalhygiene", SqlDbType.Int);
p58.Value = nJobMentalhygiene.Value;
SqlParameter p59 = sqlComm.Parameters.Add("@nJobCultureOrganizer", SqlDbType.Int);
p59.Value = nJobCultureOrganizer.Value;
SqlParameter p60 = sqlComm.Parameters.Add("@nJobOther1", SqlDbType.Int);
p60.Value = nJobOther1.Value;
SqlParameter p61 = sqlComm.Parameters.Add("@nJobOther2", SqlDbType.Int);
p61.Value = nJobOther2.Value;
SqlParameter p62 = sqlComm.Parameters.Add("@nJobOther3", SqlDbType.Int);
p62.Value = nJobOther3.Value;
SqlParameter p63 = sqlComm.Parameters.Add("@cJobOtherName1", SqlDbType.VarChar, 50);
p63.Value = cJobOtherName1.Value;
SqlParameter p64 = sqlComm.Parameters.Add("@cJobOtherName2", SqlDbType.VarChar, 50);
p64.Value = cJobOtherName2.Value;
SqlParameter p65 = sqlComm.Parameters.Add("@cJobOtherName3", SqlDbType.VarChar, 50);
p65.Value = cJobOtherName3.Value;
SqlParameter p66 = sqlComm.Parameters.Add("@bIsKef", SqlDbType.Bit);
p66.Value = bIsKef;
SqlParameter p67 = sqlComm.Parameters.Add("@cRegionSearchCodeRef", SqlDbType.Char, 10);
p67.Value = cRegionSearchCodeRef.Value;
SqlParameter p68 = sqlComm.Parameters.Add("@nDistrictSearchCodeRef", SqlDbType.Int);
p68.Value = nDistrictSearchCodeRef.Value;
SqlParameter p69 = sqlComm.Parameters.Add("@cIntroduceText", SqlDbType.Text);
p69.Value = cIntroduceText.Value;
SqlParameter p70 = sqlComm.Parameters.Add("@cDrogStrategyDescription", SqlDbType.Text);
p70.Value = cDrogStrategyDescription.Value;
SqlParameter p71 = sqlComm.Parameters.Add("@cAreaDescription", SqlDbType.Text);
p71.Value = cAreaDescription.Value;
SqlParameter p72 = sqlComm.Parameters.Add("@cEstablishmentMonth", SqlDbType.Char, 2);
p72.Value = cEstablishmentMonth.Value;
SqlParameter p73 = sqlComm.Parameters.Add("@cAreaHomePage", SqlDbType.VarChar, 250);
p73.Value = cAreaHomePage.Value;
SqlParameter p74 = sqlComm.Parameters.Add("@dLastModified", SqlDbType.DateTime);
p74.Value = dLastModified.Value;
SqlParameter p75 = sqlComm.Parameters.Add("@dIntroduceTextLastModified", SqlDbType.DateTime);
p75.Value = dIntroduceTextLastModified.Value;
SqlParameter p76 = sqlComm.Parameters.Add("@dAreaDescriptionLastModified", SqlDbType.DateTime);
p76.Value = dAreaDescriptionLastModified.Value;
SqlParameter p77 = sqlComm.Parameters.Add("@dDrogStrategyLastModified", SqlDbType.DateTime);
p77.Value = dDrogStrategyLastModified.Value;
SqlParameter p78 = sqlComm.Parameters.Add("@dKefMembersLastModified", SqlDbType.DateTime);
p78.Value = dKefMembersLastModified.Value;
SqlParameter p79 = sqlComm.Parameters.Add("@dKefDownloadsLastModified", SqlDbType.DateTime);
p79.Value = dKefDownloadsLastModified.Value;
SqlParameter p80 = sqlComm.Parameters.Add("@dKefEventsLastModified", SqlDbType.DateTime);
p80.Value = dKefEventsLastModified.Value;
SqlParameter p81 = sqlComm.Parameters.Add("@cValidationState", SqlDbType.VarChar, 50);
p81.Value = cValidationState.Value;
SqlParameter p82 = sqlComm.Parameters.Add("@dLastValidationDate", SqlDbType.DateTime);
p82.Value = dLastValidationDate.Value;
SqlParameter p83 = sqlComm.Parameters.Add("@bIsActual", SqlDbType.Bit);
p83.Value = bIsActual;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public OrganisationBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_Name = new DBString(node.SelectSingleNode("Name"));
m_Department = new DBString(node.SelectSingleNode("Department"));
m_PostCode = new DBString(node.SelectSingleNode("PostCode"));
m_City = new DBString(node.SelectSingleNode("City"));
m_Address = new DBString(node.SelectSingleNode("Address"));
m_RegionRef = new DBString(node.SelectSingleNode("RegionRef"));
m_Country = new DBString(node.SelectSingleNode("Country"));
m_MailingPostCode = new DBString(node.SelectSingleNode("MailingPostCode"));
m_MailingCity = new DBString(node.SelectSingleNode("MailingCity"));
m_MailingAddress = new DBString(node.SelectSingleNode("MailingAddress"));
m_Phone1 = new DBString(node.SelectSingleNode("Phone1"));
m_Phone2 = new DBString(node.SelectSingleNode("Phone2"));
m_Phone3 = new DBString(node.SelectSingleNode("Phone3"));
m_PhoneDiscounted = new DBString(node.SelectSingleNode("PhoneDiscounted"));
m_Fax = new DBString(node.SelectSingleNode("Fax"));
m_Email1 = new DBString(node.SelectSingleNode("Email1"));
m_Email2 = new DBString(node.SelectSingleNode("Email2"));
m_Email3 = new DBString(node.SelectSingleNode("Email3"));
m_HomePage = new DBString(node.SelectSingleNode("HomePage"));
m_ContactName = new DBString(node.SelectSingleNode("ContactName"));
m_ContactPhone = new DBString(node.SelectSingleNode("ContactPhone"));
m_ContactEmail = new DBString(node.SelectSingleNode("ContactEmail"));
m_Description = new DBString(node.SelectSingleNode("Description"));
m_CallingHours = new DBString(node.SelectSingleNode("CallingHours"));
m_OrganisationFormRef = new DBString(node.SelectSingleNode("OrganisationFormRef"));
m_SourceGovernment = new DBDouble(node.SelectSingleNode("SourceGovernment"));
m_SourceCompetition = new DBDouble(node.SelectSingleNode("SourceCompetition"));
m_SourceSponsor = new DBDouble(node.SelectSingleNode("SourceSponsor"));
m_SourceDonation = new DBDouble(node.SelectSingleNode("SourceDonation"));
m_SourceTax = new DBDouble(node.SelectSingleNode("SourceTax"));
m_SourceOther = new DBDouble(node.SelectSingleNode("SourceOther"));
m_SourceOtherName = new DBString(node.SelectSingleNode("SourceOtherName"));
m_EstablishmentYear = new DBString(node.SelectSingleNode("EstablishmentYear"));
m_ActivityPrevention = Convert.ToBoolean(node.SelectSingleNode("ActivityPrevention").InnerText);
m_ActivityResearch = Convert.ToBoolean(node.SelectSingleNode("ActivityResearch").InnerText);
m_ActivityRehabilitation = Convert.ToBoolean(node.SelectSingleNode("ActivityRehabilitation").InnerText);
m_ActivityOther = Convert.ToBoolean(node.SelectSingleNode("ActivityOther").InnerText);
m_WorkingAreaRef = new DBString(node.SelectSingleNode("WorkingAreaRef"));
m_WorkingAreaOther = new DBString(node.SelectSingleNode("WorkingAreaOther"));
m_WorkersFix = new DBInt(node.SelectSingleNode("WorkersFix"));
m_WorkersExternal = new DBInt(node.SelectSingleNode("WorkersExternal"));
m_WorkersVolunteer = new DBInt(node.SelectSingleNode("WorkersVolunteer"));
m_IsActive = Convert.ToBoolean(node.SelectSingleNode("IsActive").InnerText);
m_JobPsychologist = new DBInt(node.SelectSingleNode("JobPsychologist"));
m_JobPsychiater = new DBInt(node.SelectSingleNode("JobPsychiater"));
m_JobDoctor = new DBInt(node.SelectSingleNode("JobDoctor"));
m_JobMedicalExpert = new DBInt(node.SelectSingleNode("JobMedicalExpert"));
m_JobHealthExpert = new DBInt(node.SelectSingleNode("JobHealthExpert"));
m_JobSociologist = new DBInt(node.SelectSingleNode("JobSociologist"));
m_JobSocialPolitician = new DBInt(node.SelectSingleNode("JobSocialPolitician"));
m_JobSocialWorker = new DBInt(node.SelectSingleNode("JobSocialWorker"));
m_JobSocialPedagogist = new DBInt(node.SelectSingleNode("JobSocialPedagogist"));
m_JobPedagogist = new DBInt(node.SelectSingleNode("JobPedagogist"));
m_JobManualist = new DBInt(node.SelectSingleNode("JobManualist"));
m_JobLawyer = new DBInt(node.SelectSingleNode("JobLawyer"));
m_JobPoliceman = new DBInt(node.SelectSingleNode("JobPoliceman"));
m_JobMentalhygiene = new DBInt(node.SelectSingleNode("JobMentalhygiene"));
m_JobCultureOrganizer = new DBInt(node.SelectSingleNode("JobCultureOrganizer"));
m_JobOther1 = new DBInt(node.SelectSingleNode("JobOther1"));
m_JobOther2 = new DBInt(node.SelectSingleNode("JobOther2"));
m_JobOther3 = new DBInt(node.SelectSingleNode("JobOther3"));
m_JobOtherName1 = new DBString(node.SelectSingleNode("JobOtherName1"));
m_JobOtherName2 = new DBString(node.SelectSingleNode("JobOtherName2"));
m_JobOtherName3 = new DBString(node.SelectSingleNode("JobOtherName3"));
m_IsKef = Convert.ToBoolean(node.SelectSingleNode("IsKef").InnerText);
m_RegionSearchCodeRef = new DBString(node.SelectSingleNode("RegionSearchCodeRef"));
m_DistrictSearchCodeRef = new DBInt(node.SelectSingleNode("DistrictSearchCodeRef"));
m_IntroduceText = new DBString(node.SelectSingleNode("IntroduceText"));
m_DrogStrategyDescription = new DBString(node.SelectSingleNode("DrogStrategyDescription"));
m_AreaDescription = new DBString(node.SelectSingleNode("AreaDescription"));
m_EstablishmentMonth = new DBString(node.SelectSingleNode("EstablishmentMonth"));
m_AreaHomePage = new DBString(node.SelectSingleNode("AreaHomePage"));
m_LastModified = new DBDateTime(node.SelectSingleNode("LastModified"));
m_IntroduceTextLastModified = new DBDateTime(node.SelectSingleNode("IntroduceTextLastModified"));
m_AreaDescriptionLastModified = new DBDateTime(node.SelectSingleNode("AreaDescriptionLastModified"));
m_DrogStrategyLastModified = new DBDateTime(node.SelectSingleNode("DrogStrategyLastModified"));
m_KefMembersLastModified = new DBDateTime(node.SelectSingleNode("KefMembersLastModified"));
m_KefDownloadsLastModified = new DBDateTime(node.SelectSingleNode("KefDownloadsLastModified"));
m_KefEventsLastModified = new DBDateTime(node.SelectSingleNode("KefEventsLastModified"));
m_ValidationState = new DBString(node.SelectSingleNode("ValidationState"));
m_LastValidationDate = new DBDateTime(node.SelectSingleNode("LastValidationDate"));
m_IsActual = Convert.ToBoolean(node.SelectSingleNode("IsActual").InnerText);
}