public void AddEvent(DBDateTime dTimeStamp, DBString cSeverity, DBString cSource, DBString cMethod,
DBString cThreadInfo, DBString cWindowsIdentity, DBString cPrincipalName, DBString cMessage,
out int retVal)
{
SqlCommand command1 = base.PrepareSPCall("aeAddEvent");
SqlParameter parameter1 = command1.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
parameter1.Direction = ParameterDirection.ReturnValue;
SqlParameter parameter2 = command1.Parameters.Add("@dTimeStamp", SqlDbType.DateTime);
parameter2.Value = dTimeStamp.Value;
SqlParameter parameter3 = command1.Parameters.Add("@cSeverity", SqlDbType.VarChar, 0x20);
parameter3.Value = cSeverity.Value;
SqlParameter parameter4 = command1.Parameters.Add("@cSource", SqlDbType.VarChar, 0x80);
parameter4.Value = cSource.Value;
SqlParameter parameter5 = command1.Parameters.Add("@cMethod", SqlDbType.VarChar, 0x80);
parameter5.Value = cMethod.Value;
SqlParameter parameter6 = command1.Parameters.Add("@cThreadInfo", SqlDbType.VarChar, 0x80);
parameter6.Value = cThreadInfo.Value;
SqlParameter parameter7 = command1.Parameters.Add("@cWindowsIdentity", SqlDbType.VarChar, 0x40);
parameter7.Value = cWindowsIdentity.Value;
SqlParameter parameter8 = command1.Parameters.Add("@cPrincipalName", SqlDbType.VarChar, 0x40);
parameter8.Value = cPrincipalName.Value;
SqlParameter parameter9 = command1.Parameters.Add("@cMessage", SqlDbType.VarChar, 0x200);
parameter9.Value = cMessage.Value;
try
{
command1.ExecuteNonQuery();
}
finally
{
base.FinishSPCall();
}
retVal = (int) parameter1.Value;
}
public void ndihdOrganisationAttachmentUpdate(DBGuid uID,
DBGuid uOrganisationRef,
DBString cPath,
DBString cName,
DBString cDescription,
DBString cAuthor,
DBString cPublisher,
DBString cPublishedYear,
DBString cKeywords,
DBDateTime dCreatedDate,
DBInt nFileSize,
bool bIsActive,
DBString cKefFileTypeRef,
DBInt nRank)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationAttachmentUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cPath", SqlDbType.VarChar, 500);
p3.Value = cPath.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p4.Value = cName.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 1000);
p5.Value = cDescription.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cAuthor", SqlDbType.VarChar, 1000);
p6.Value = cAuthor.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cPublisher", SqlDbType.VarChar, 500);
p7.Value = cPublisher.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cPublishedYear", SqlDbType.Char, 4);
p8.Value = cPublishedYear.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cKeywords", SqlDbType.VarChar, 100);
p9.Value = cKeywords.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@dCreatedDate", SqlDbType.DateTime);
p10.Value = dCreatedDate.Value;
SqlParameter p11 = sqlComm.Parameters.Add("@nFileSize", SqlDbType.Int);
p11.Value = nFileSize.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p12.Value = bIsActive;
SqlParameter p13 = sqlComm.Parameters.Add("@cKefFileTypeRef", SqlDbType.Char, 10);
p13.Value = cKefFileTypeRef.Value;
SqlParameter p14 = sqlComm.Parameters.Add("@nRank", SqlDbType.Int);
p14.Value = nRank.Value;
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 ForumThreadBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_Name = new DBString(node.SelectSingleNode("Name"));
m_Description = new DBString(node.SelectSingleNode("Description"));
m_CreatedBy = new DBString(node.SelectSingleNode("CreatedBy"));
m_CreatedDate = new DBDateTime(node.SelectSingleNode("CreatedDate"));
m_IsActive = Convert.ToBoolean(node.SelectSingleNode("IsActive").InnerText);
m_ForumGroupRef = new DBGuid(node.SelectSingleNode("ForumGroupRef"));
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public QuestionFormBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_TemplateRef = new DBGuid(node.SelectSingleNode("TemplateRef"));
m_LastModifiedDate = new DBDateTime(node.SelectSingleNode("LastModifiedDate"));
m_DecidedDate = new DBDateTime(node.SelectSingleNode("DecidedDate"));
m_IsActual = Convert.ToBoolean(node.SelectSingleNode("IsActual").InnerText);
m_LastModifiedByUser = new DBDateTime(node.SelectSingleNode("LastModifiedByUser"));
m_LastValidationDate = new DBDateTime(node.SelectSingleNode("LastValidationDate"));
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public PendingQuestionFormBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_QuestionFormRef = new DBGuid(node.SelectSingleNode("QuestionFormRef"));
m_TemplateRef = new DBGuid(node.SelectSingleNode("TemplateRef"));
m_Status = new DBString(node.SelectSingleNode("Status"));
m_SentBy = new DBString(node.SelectSingleNode("SentBy"));
m_SentDate = new DBDateTime(node.SelectSingleNode("SentDate"));
m_DecidedBy = new DBString(node.SelectSingleNode("DecidedBy"));
m_DecidedDate = new DBDateTime(node.SelectSingleNode("DecidedDate"));
m_RejectComment = new DBString(node.SelectSingleNode("RejectComment"));
m_IsActual = Convert.ToBoolean(node.SelectSingleNode("IsActual").InnerText);
m_LastModifiedByUser = new DBDateTime(node.SelectSingleNode("LastModifiedByUser"));
m_LastValidationDate = new DBDateTime(node.SelectSingleNode("LastValidationDate"));
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public ProgramAttachmentBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_ProgramRef = new DBGuid(node.SelectSingleNode("ProgramRef"));
m_Path = new DBString(node.SelectSingleNode("Path"));
m_Name = new DBString(node.SelectSingleNode("Name"));
m_Description = new DBString(node.SelectSingleNode("Description"));
m_Author = new DBString(node.SelectSingleNode("Author"));
m_Publisher = new DBString(node.SelectSingleNode("Publisher"));
m_PublishedYear = new DBString(node.SelectSingleNode("PublishedYear"));
m_Keywords = new DBString(node.SelectSingleNode("Keywords"));
m_CreatedDate = new DBDateTime(node.SelectSingleNode("CreatedDate"));
m_FileSize = new DBInt(node.SelectSingleNode("FileSize"));
m_IsActive = Convert.ToBoolean(node.SelectSingleNode("IsActive").InnerText);
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public DesignerDrogAttachmentBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_ItemRef = new DBGuid(node.SelectSingleNode("ItemRef"));
m_Path = new DBString(node.SelectSingleNode("Path"));
m_Name = new DBString(node.SelectSingleNode("Name"));
m_Description = new DBString(node.SelectSingleNode("Description"));
m_CreatedDate = new DBDateTime(node.SelectSingleNode("CreatedDate"));
m_FileSize = new DBInt(node.SelectSingleNode("FileSize"));
m_IsActive = Convert.ToBoolean(node.SelectSingleNode("IsActive").InnerText);
}
// --------------------------------------------------------------------------------
/// <summary>
/// Subtracts the specified date and time from this instance.
/// </summary>
/// <param name="value">An instance of DBDateTime.</param>
/// <returns>
/// A <see cref="TimeSpan"/> interval equal to the date and time represented by
/// this instance minus the date and time represented by <c>value</c>.
/// </returns>
/// <exception cref="ArgumentOutOfRangeException">
/// The resulting DBDateTime is less than <see cref="MinValue"/> or greater than
/// <see cref="MaxValue"/>.
/// </exception>
/// <exception cref="InvalidOperationException">
/// This instance has a Null value.
/// </exception>
/// <remarks>
/// This method does not change the value of this DBDateTime. Instead, a new
/// <see cref="TimeSpan"/> is returned whose value is the result of this operation.
/// </remarks>
// --------------------------------------------------------------------------------
public TimeSpan Subtract(DBDateTime value)
{
if (IsNull)
{
throw new InvalidOperationException ();
}
if (value.IsNull)
{
throw new InvalidOperationException ();
}
return m_Value.Subtract (value);
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public ProgramQuestionFormBase(ProgramQuestionFormBase origInstance)
: base()
{
this.m_ProgramCategoryRef = origInstance.m_ProgramCategoryRef;
this.m_ProgramRef = origInstance.m_ProgramRef;
this.m_QuestionFormRef = origInstance.m_QuestionFormRef;
this.m_LastModifiedDate = origInstance.m_LastModifiedDate;
this.m_DecidedDate = origInstance.m_DecidedDate;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public ProgramQuestionFormBase(XmlNode node)
{
m_ProgramCategoryRef = new DBString(node.Attributes["ProgramCategoryRef"]);
m_ProgramRef = new DBGuid(node.Attributes["ProgramRef"]);
m_QuestionFormRef = new DBGuid(node.Attributes["QuestionFormRef"]);
m_LastModifiedDate = new DBDateTime(node.SelectSingleNode("LastModifiedDate"));
m_DecidedDate = new DBDateTime(node.SelectSingleNode("DecidedDate"));
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public OrganisationAttachmentBase(DBGuid IDVal,
OrganisationAttachmentBase origInstance)
: base()
{
this.m_ID = IDVal;
this.m_OrganisationRef = origInstance.m_OrganisationRef;
this.m_Path = origInstance.m_Path;
this.m_Name = origInstance.m_Name;
this.m_Description = origInstance.m_Description;
this.m_Author = origInstance.m_Author;
this.m_Publisher = origInstance.m_Publisher;
this.m_PublishedYear = origInstance.m_PublishedYear;
this.m_Keywords = origInstance.m_Keywords;
this.m_CreatedDate = origInstance.m_CreatedDate;
this.m_FileSize = origInstance.m_FileSize;
this.m_IsActive = origInstance.m_IsActive;
this.m_KefFileTypeRef = origInstance.m_KefFileTypeRef;
this.m_Rank = origInstance.m_Rank;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public ProgramBase(DBGuid IDVal,
ProgramBase origInstance)
: base()
{
this.m_ID = IDVal;
this.m_Name = origInstance.m_Name;
this.m_Description = origInstance.m_Description;
this.m_StartDate = origInstance.m_StartDate;
this.m_FinishDate = origInstance.m_FinishDate;
this.m_ProgramStatus = origInstance.m_ProgramStatus;
this.m_NonregisteredPartners = origInstance.m_NonregisteredPartners;
this.m_ProgramCategoryRef = origInstance.m_ProgramCategoryRef;
this.m_OrganisationRef = origInstance.m_OrganisationRef;
this.m_ResponsibleRef = origInstance.m_ResponsibleRef;
this.m_Coordinator1Ref = origInstance.m_Coordinator1Ref;
this.m_Coordinator2Ref = origInstance.m_Coordinator2Ref;
this.m_IsActive = origInstance.m_IsActive;
this.m_LastModifiedDate = origInstance.m_LastModifiedDate;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public ProgramBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_Name = new DBString(node.SelectSingleNode("Name"));
m_Description = new DBString(node.SelectSingleNode("Description"));
m_StartDate = new DBString(node.SelectSingleNode("StartDate"));
m_FinishDate = new DBString(node.SelectSingleNode("FinishDate"));
m_ProgramStatus = new DBString(node.SelectSingleNode("ProgramStatus"));
m_NonregisteredPartners = new DBString(node.SelectSingleNode("NonregisteredPartners"));
m_ProgramCategoryRef = new DBString(node.SelectSingleNode("ProgramCategoryRef"));
m_OrganisationRef = new DBGuid(node.SelectSingleNode("OrganisationRef"));
m_ResponsibleRef = new DBGuid(node.SelectSingleNode("ResponsibleRef"));
m_Coordinator1Ref = new DBGuid(node.SelectSingleNode("Coordinator1Ref"));
m_Coordinator2Ref = new DBGuid(node.SelectSingleNode("Coordinator2Ref"));
m_IsActive = Convert.ToBoolean(node.SelectSingleNode("IsActive").InnerText);
if (node.SelectSingleNode("LastModifiedDate") != null)
m_LastModifiedDate = new DBDateTime(node.SelectSingleNode("LastModifiedDate"));
}
public void ndihdPendingQuestionFormInsert(DBGuid uID,
DBGuid uQuestionFormRef,
DBGuid uTemplateRef,
DBString cStatus,
DBString cSentBy,
DBDateTime dSentDate,
DBString cDecidedBy,
DBDateTime dDecidedDate,
DBString cRejectComment,
bool bIsActual,
DBDateTime dLastModifiedByUser,
DBDateTime dLastValidationDate)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormInsert]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p2.Value = uQuestionFormRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uTemplateRef", SqlDbType.UniqueIdentifier);
p3.Value = uTemplateRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cStatus", SqlDbType.Char, 3);
p4.Value = cStatus.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cSentBy", SqlDbType.VarChar, 50);
p5.Value = cSentBy.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@dSentDate", SqlDbType.DateTime);
p6.Value = dSentDate.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cDecidedBy", SqlDbType.VarChar, 50);
p7.Value = cDecidedBy.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@dDecidedDate", SqlDbType.DateTime);
p8.Value = dDecidedDate.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cRejectComment", SqlDbType.VarChar, 1000);
p9.Value = cRejectComment.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@bIsActual", SqlDbType.Bit);
p10.Value = bIsActual;
SqlParameter p11 = sqlComm.Parameters.Add("@dLastModifiedByUser", SqlDbType.DateTime);
p11.Value = dLastModifiedByUser.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@dLastValidationDate", SqlDbType.DateTime);
p12.Value = dLastValidationDate.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
}
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>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public JobOfferBase(DBGuid IDVal,
JobOfferBase origInstance)
: base()
{
m_ID = IDVal;
m_RefId = origInstance.m_RefId;
m_Description = origInstance.m_Description;
m_Message = origInstance.m_Message;
m_Requirements = origInstance.m_Requirements;
m_City = origInstance.m_City;
m_RegionRef = origInstance.m_RegionRef;
m_Status = origInstance.m_Status;
m_QualificationMinRef = origInstance.m_QualificationMinRef;
m_IdealEmployee = origInstance.m_IdealEmployee;
m_ActivityPrevention = origInstance.m_ActivityPrevention;
m_ActivityResearch = origInstance.m_ActivityResearch;
m_ActivityRehabilitation = origInstance.m_ActivityRehabilitation;
m_ActivityOther = origInstance.m_ActivityOther;
m_EmployeeCount = origInstance.m_EmployeeCount;
m_FreeEmployeeCount = origInstance.m_FreeEmployeeCount;
m_HomePage = origInstance.m_HomePage;
m_ContactName = origInstance.m_ContactName;
m_ContactPhone = origInstance.m_ContactPhone;
m_ContactEmail = origInstance.m_ContactEmail;
m_Sender = origInstance.m_Sender;
m_NotificationSend = origInstance.m_NotificationSend;
m_NotificationDate = origInstance.m_NotificationDate;
m_Expiredate = origInstance.m_Expiredate;
m_LastModified = origInstance.m_LastModified;
m_Created = origInstance.m_Created;
}
/// <summary>
/// Fill datagrid with data
/// </summary>
private void FillDatagrid(DBGuid ID)
{
try
{
string sSortColumn = "ForumThreadName";
int nSelectedRow = -1;
// Storing the previous sort order
if (dtgMain.DataSource != null)
{
sSortColumn = ((DataTable) dtgMain.DataSource).DefaultView.Sort;
}
// Set filter
ForumItem filter = new ForumItem(Guid.Empty);
filter.FilterOnIsModerated = DBInt.Null;
if (cmbStatus.SelectedIndex > 0)
{
bool bIsModerated = (cmbStatus.SelectedValue.ToString() == "1" ? true : false);
filter.FilterOnIsModerated = (DBInt) Convert.ToInt32(bIsModerated);
filter.IsModerated = bIsModerated;
}
if (cmbForumGroup.SelectedIndex > 0)
{
filter.ForumGroupRef = new DBGuid(new Guid(cmbForumGroup.SelectedValue.ToString()));
}
if (dtpSentFrom.Checked)
{
filter.FilterOnSentFrom = new DBDateTime(dtpSentFrom.Value);
}
if (dtpSentTo.Checked)
{
DBDateTime dateTo = new DBDateTime(dtpSentTo.Value);
filter.FilterOnSentTo = dateTo.AddDays(1).AddMilliseconds(-1);
}
// Retrieving data from BusinessServices
IForumItemService srv = ServiceFactory.GetForumItemService();
ForumItemContainer allData = srv.ForumItemSelectFiltered(filter);
DataTable dt = allData.AllAsDatatable;
dt.DefaultView.Sort = sSortColumn;
dtgMain.DataSource = dt;
// Locates the row specified by ID param
if (!ID.IsNull)
{
BindingManagerBase bm = dtgMain.BindingContext[dtgMain.DataSource, dtgMain.DataMember];
DataRow dr;
for (int i = 0; i < bm.Count; i++)
{
dr = ((DataRowView) bm.Current).Row;
if (ID.Value.Equals(dr["ID"]))
{
nSelectedRow = i;
break;
}
bm.Position += 1;
}
}
// Makes the row selected
if (nSelectedRow <= ((DataTable) dtgMain.DataSource).DefaultView.Count && nSelectedRow > -1)
{
dtgMain.Select(nSelectedRow);
dtgMain.CurrentRowIndex = nSelectedRow;
}
else if (((DataTable) dtgMain.DataSource).DefaultView.Count != 0)
{
dtgMain.Select(0);
}
// Enabling or disabling the buttons according to record count.
// And is because of previous disable state.
bool bIsEmptyGrid = (((DataTable) dtgMain.DataSource).DefaultView.Count == 0);
tbbInactivate.Enabled = ! bIsEmptyGrid;
tbbModify.Enabled = ! bIsEmptyGrid;
}
catch (Exception ex)
{
// --- Log exception
ExceptionManager.Publish(ex);
// --- Display Exception
ErrorHandler.DisplayError("Nem várt hiba lépett fel a lista frissítése során.", ex);
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="ProgramCategoryRefVal">Value of 'cProgramCategoryRef' field</param>
/// <param name="ProgramRefVal">Value of 'uProgramRef' field</param>
/// <param name="QuestionFormRefVal">Value of 'uQuestionFormRef' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public ProgramQuestionFormBase(DBString ProgramCategoryRefVal,
DBGuid ProgramRefVal,
DBGuid QuestionFormRefVal,
ProgramQuestionFormBase origInstance)
: base()
{
this.m_ProgramCategoryRef = ProgramCategoryRefVal;
this.m_ProgramRef = ProgramRefVal;
this.m_QuestionFormRef = QuestionFormRefVal;
this.m_LastModifiedDate = origInstance.m_LastModifiedDate;
this.m_DecidedDate = origInstance.m_DecidedDate;
}
// --------------------------------------------------------------------------------
/// <summary>
/// Compares two instances of DateTime and returns an indication of their
/// relative values.
/// </summary>
/// <param name="d1">First DBDateTime value.</param>
/// <param name="d2">Second DBDateTime value.</param>
/// <returns>
/// A signed number indicating the relative values of <c>d1</c> and <c>d2</c>.
/// <list type="table">
/// <listheader>
/// <term>Value</term>
/// <description>Meaning</description>
/// </listheader>
/// <item>
/// <term>Less than zero</term>
/// <description><c>d1</c> is less than <c>d2</c>.</description>
/// </item>
/// <item>
/// <term>Zero</term>
/// <description><c>d1</c> is equal to <c>d2</c>.</description>
/// </item>
/// <item>
/// <term>Greater than zero</term>
/// <description><c>d1</c> is greater than <c>d2</c>.</description>
/// </item>
/// </list>
/// </returns>
/// <exception cref="InvalidOperationException">
/// Either <c>d1</c> or <c>d2</c> is Null.
/// </exception>
// --------------------------------------------------------------------------------
public static int Compare(DBDateTime d1, DBDateTime d2)
{
if (! (d1.m_Defined && d2.m_Defined))
{
throw new InvalidOperationException();
}
return DateTime.Compare (d1, d2);
}
/// <summary>
/// Fill datagrid with data
/// </summary>
private void FillDatagrid(DBInt ID)
{
try
{
string sSortColumn = "TimeStamp DESC";
int nSelectedRow = -1;
// Storing the previous sort order
if (dtgMain.DataSource != null)
{
sSortColumn = ((DataTable) dtgMain.DataSource).DefaultView.Sort;
}
// Set filter
Event filter = new Event();
if (cmbFunctions.SelectedIndex > 0)
{
filter.Method = cmbFunctions.SelectedValue.ToString();
}
if (txtLoginName.Text.Length > 0)
{
filter.PrincipalName = txtLoginName.Text;
}
if (dtpFrom.Checked)
{
filter.FilterOnTimeStampFrom = new DBDateTime(dtpFrom.Value.Date);
}
if (dtpTo.Checked)
{
DBDateTime dateTo = new DBDateTime(dtpTo.Value);
filter.FilterOnTimeStampTo = dateTo.AddDays(1).AddMilliseconds(-1);
}
// Retrieving data from BusinessServices
IEventService srv = ServiceFactory.GetEventService();
EventContainer allData = srv.EventSelectFiltered(filter);
DataTable dt = allData.AllAsDatatable;
dt.DefaultView.Sort = sSortColumn;
dtgMain.DataSource = dt;
// Locates the row specified by ID param
if (!ID.IsNull)
{
BindingManagerBase bm = dtgMain.BindingContext[dtgMain.DataSource, dtgMain.DataMember];
DataRow dr;
for (int i = 0; i < bm.Count; i++)
{
dr = ((DataRowView) bm.Current).Row;
if (ID.Value.Equals(dr["ID"]))
{
nSelectedRow = i;
break;
}
bm.Position += 1;
}
}
// Makes the row selected
if (nSelectedRow <= ((DataTable) dtgMain.DataSource).DefaultView.Count && nSelectedRow > -1)
{
dtgMain.Select(nSelectedRow);
dtgMain.CurrentRowIndex = nSelectedRow;
}
else if (((DataTable) dtgMain.DataSource).DefaultView.Count != 0)
{
dtgMain.Select(0);
}
// Enabling or disabling the buttons according to record count.
// And is because of previous disable state.
bool bIsEmptyGrid = (((DataTable) dtgMain.DataSource).DefaultView.Count == 0);
tbbModify.Enabled = ! bIsEmptyGrid;
}
catch (Exception ex)
{
// --- Log exception
ExceptionManager.Publish(ex);
// --- Display Exception
ErrorHandler.DisplayError("Nem várt hiba lépett fel a lista frissítése során.", ex);
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public DesignerDrogAttachmentBase(DBGuid IDVal,
DesignerDrogAttachmentBase origInstance)
: base()
{
this.m_ID = IDVal;
this.m_ItemRef = origInstance.m_ItemRef;
this.m_Path = origInstance.m_Path;
this.m_Name = origInstance.m_Name;
this.m_Description = origInstance.m_Description;
this.m_CreatedDate = origInstance.m_CreatedDate;
this.m_FileSize = origInstance.m_FileSize;
this.m_IsActive = origInstance.m_IsActive;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public DesignerDrogBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_Title = new DBString(node.SelectSingleNode("Title"));
m_Author = new DBString(node.SelectSingleNode("Author"));
m_Source = new DBString(node.SelectSingleNode("Source"));
m_Abstract = new DBString(node.SelectSingleNode("Abstract"));
m_PictureUrl = new DBString(node.SelectSingleNode("PictureUrl"));
m_Body = new DBString(node.SelectSingleNode("Body"));
m_CategoryRef = new DBGuid(node.SelectSingleNode("CategoryRef"));
m_CreatedDate = new DBDateTime(node.SelectSingleNode("CreatedDate"));
m_IsActive = Convert.ToBoolean(node.SelectSingleNode("IsActive").InnerText);
m_IsActual = Convert.ToBoolean(node.SelectSingleNode("IsActual").InnerText);
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public ProgramAttachmentBase(DBGuid IDVal,
ProgramAttachmentBase origInstance)
{
m_ID = IDVal;
m_ProgramRef = origInstance.m_ProgramRef;
m_Path = origInstance.m_Path;
m_Name = origInstance.m_Name;
m_Description = origInstance.m_Description;
m_Author = origInstance.m_Author;
m_Publisher = origInstance.m_Publisher;
m_PublishedYear = origInstance.m_PublishedYear;
m_Keywords = origInstance.m_Keywords;
m_CreatedDate = origInstance.m_CreatedDate;
m_FileSize = origInstance.m_FileSize;
m_IsActive = origInstance.m_IsActive;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public DesignerDrogBase(DBGuid IDVal,
DesignerDrogBase origInstance)
: base()
{
this.m_ID = IDVal;
this.m_Title = origInstance.m_Title;
this.m_Author = origInstance.m_Author;
this.m_Source = origInstance.m_Source;
this.m_Abstract = origInstance.m_Abstract;
this.m_PictureUrl = origInstance.m_PictureUrl;
this.m_Body = origInstance.m_Body;
this.m_CategoryRef = origInstance.m_CategoryRef;
this.m_CreatedDate = origInstance.m_CreatedDate;
this.m_IsActive = origInstance.m_IsActive;
this.m_IsActual = origInstance.m_IsActual;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public PendingQuestionFormBase(DBGuid IDVal,
PendingQuestionFormBase origInstance)
: base()
{
this.m_ID = IDVal;
this.m_QuestionFormRef = origInstance.m_QuestionFormRef;
this.m_TemplateRef = origInstance.m_TemplateRef;
this.m_Status = origInstance.m_Status;
this.m_SentBy = origInstance.m_SentBy;
this.m_SentDate = origInstance.m_SentDate;
this.m_DecidedBy = origInstance.m_DecidedBy;
this.m_DecidedDate = origInstance.m_DecidedDate;
this.m_RejectComment = origInstance.m_RejectComment;
this.m_IsActual = origInstance.m_IsActual;
this.m_LastModifiedByUser = origInstance.m_LastModifiedByUser;
this.m_LastValidationDate = origInstance.m_LastValidationDate;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public JobFindBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_RefId = new DBInt(node.SelectSingleNode("RefId"));
m_Description = new DBString(node.SelectSingleNode("Description"));
m_City = new DBString(node.SelectSingleNode("City"));
m_RegionRef = new DBString(node.SelectSingleNode("RegionRef"));
m_Status = new DBString(node.SelectSingleNode("Status"));
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_Sender = new DBString(node.SelectSingleNode("Sender"));
m_NotificationSend = Convert.ToBoolean(node.SelectSingleNode("NotificationSend").InnerText);
m_NotificationDate = new DBDateTime(node.SelectSingleNode("NotificationDate"));
m_Expiredate = new DBDateTime(node.SelectSingleNode("Expiredate"));
m_LastModified = new DBDateTime(node.SelectSingleNode("LastModified"));
m_Created = new DBDateTime(node.SelectSingleNode("Created"));
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public QuestionFormBase(DBGuid IDVal,
QuestionFormBase origInstance)
: base()
{
this.m_ID = IDVal;
this.m_TemplateRef = origInstance.m_TemplateRef;
this.m_LastModifiedDate = origInstance.m_LastModifiedDate;
this.m_DecidedDate = origInstance.m_DecidedDate;
this.m_IsActual = origInstance.m_IsActual;
this.m_LastModifiedByUser = origInstance.m_LastModifiedByUser;
this.m_LastValidationDate = origInstance.m_LastValidationDate;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public JobFindBase(DBGuid IDVal,
JobFindBase origInstance)
: base()
{
m_ID = IDVal;
m_RefId = origInstance.m_RefId;
m_Description = origInstance.m_Description;
m_City = origInstance.m_City;
m_RegionRef = origInstance.m_RegionRef;
m_Status = origInstance.m_Status;
m_ActivityPrevention = origInstance.m_ActivityPrevention;
m_ActivityResearch = origInstance.m_ActivityResearch;
m_ActivityRehabilitation = origInstance.m_ActivityRehabilitation;
m_ActivityOther = origInstance.m_ActivityOther;
m_Sender = origInstance.m_Sender;
m_NotificationSend = origInstance.m_NotificationSend;
m_NotificationDate = origInstance.m_NotificationDate;
m_Expiredate = origInstance.m_Expiredate;
m_LastModified = origInstance.m_LastModified;
m_Created = origInstance.m_Created;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public ForumThreadBase(DBGuid IDVal,
ForumThreadBase origInstance)
{
m_ID = IDVal;
m_Name = origInstance.m_Name;
m_Description = origInstance.m_Description;
m_CreatedBy = origInstance.m_CreatedBy;
m_CreatedDate = origInstance.m_CreatedDate;
m_IsActive = origInstance.m_IsActive;
m_ForumGroupRef = origInstance.m_ForumGroupRef;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// XmlNode setup constructor
/// </summary>
/// <param name="node">XmlNode containing document data.</param>
// -------------------------------------------------------------------------------------
public JobOfferBase(XmlNode node)
{
m_ID = new DBGuid(node.Attributes["ID"]);
m_RefId = new DBInt(node.SelectSingleNode("RefId"));
m_Description = new DBString(node.SelectSingleNode("Description"));
m_Message = new DBString(node.SelectSingleNode("Message"));
m_Requirements = new DBString(node.SelectSingleNode("Requirements"));
m_City = new DBString(node.SelectSingleNode("City"));
m_RegionRef = new DBString(node.SelectSingleNode("RegionRef"));
m_Status = new DBString(node.SelectSingleNode("Status"));
m_QualificationMinRef = new DBString(node.SelectSingleNode("QualificationMinRef"));
m_IdealEmployee = new DBString(node.SelectSingleNode("IdealEmployee"));
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_EmployeeCount = new DBInt(node.SelectSingleNode("EmployeeCount"));
m_FreeEmployeeCount = new DBInt(node.SelectSingleNode("FreeEmployeeCount"));
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_Sender = new DBString(node.SelectSingleNode("Sender"));
m_NotificationSend = Convert.ToBoolean(node.SelectSingleNode("NotificationSend").InnerText);
m_NotificationDate = new DBDateTime(node.SelectSingleNode("NotificationDate"));
m_Expiredate = new DBDateTime(node.SelectSingleNode("Expiredate"));
m_LastModified = new DBDateTime(node.SelectSingleNode("LastModified"));
m_Created = new DBDateTime(node.SelectSingleNode("Created"));
}