public void ProgramAttachmentInactivate(DBGuid IdVal)
{
// check permission: admin
PrincipalPermission permReg = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Registered");
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permReg.Union(permAdmin).Demand();
ProgramAttachment selected = base.ProgramAttachmentSelect(IdVal);
if (selected == null)
throw new ApplicationException("A megadott azonosítóval nem létezik csatolt fájl.");
ProgramService progSrv = new ProgramService();
Program selectedProgram = progSrv.ProgramSelect(selected.ProgramRef);
if (selectedProgram == null)
throw new ApplicationException("A megadott azonosítóval nem létezik program.");
string writerRole = selectedProgram.OrganisationRef.Value.ToString() + ".Writer";
PrincipalPermission permWriter = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, writerRole);
permWriter.Union(permAdmin).Demand();
TraceCallEnterEvent.Raise();
try
{
// save data
selected.IsActive = false;
base.ProgramAttachmentUpdate(selected);
BusinessAuditEvent.Success(
new EventParameter("ProgramAttachmentID", IdVal.ToString()),
new EventParameter("ProgramAttachmentName", selected.Name),
new EventParameter("ProgramID", selected.ProgramRef.ToString())
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("ProgramAttachmentID", IdVal.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public new void ProgramPartnerDelete(ProgramPartner entity)
{
TraceCallEnterEvent.Raise();
try
{
// logical checks:
ProgramService progSrv = new ProgramService();
Program selected = progSrv.ProgramSelect(entity.ProgramRef);
if (selected == null)
throw new ApplicationException("Ezzel az azonosítóval nem létezik program.");
if (!selected.IsActive)
throw new ApplicationException("A program nem aktív.");
// check permission: Writer or Admin
string writerRole = selected.OrganisationRef.Value.ToString() + ".Writer";
PrincipalPermission permWriter = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, writerRole);
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permWriter.Union(permAdmin).Demand();
// save data:
base.ProgramPartnerDelete(entity);
BusinessAuditEvent.Success(
new EventParameter("ProgramID", entity.ProgramRef.ToString()),
new EventParameter("OrganisationID", entity.OrganisationRef.ToString())
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("ProgramID", entity.ProgramRef.ToString()),
new EventParameter("OrganisationID", entity.OrganisationRef.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
/// <summary>
/// Programs the question form validate priv.
/// </summary>
/// <param name="org">The org.</param>
/// <param name="prog">The prog.</param>
/// <param name="referenceDate">The reference date.</param>
/// <param name="refreshNum">The refresh num.</param>
/// <param name="service">if set to <c>true</c> [service].</param>
/// <returns></returns>
private string ProgramQuestionFormValidatePriv(Organisation org, Program prog, DateTime referenceDate, int refreshNum, bool service)
{
string organisationState = org.ValidationState ?? "";
var filter = new Template(DBGuid.Null)
{
PublicityLevel = 1,
FilterOnIsActive = 1,
FilterOnCategory = prog.ProgramCategoryRef
};
//IOrganisationService organisationService = ServiceFactory.GetOrganisationService();
ProgramService programService = new ProgramService();
PendingQuestionFormService pqfService = new PendingQuestionFormService();
TemplateService templateSrv = new TemplateService();
ProgramPendingQuestionFormContainer qfPendings =
programService.SelectChildrenByPendingQuestionFormOfProgram(prog.ID);
//Ezek azok a kérdőívek, amiknek ki kellene töltve lennie a programhoz
TemplateContainer templSelectedOrg = templateSrv.TemplateSelectFiltered(filter);
foreach (Template template in templSelectedOrg.All)
{
bool isFilled = false;
var allPendingsToTemplate = new PendingQuestionFormContainer();
// ebben a konténerben lesznek az ehhez a templatehez tartozó pendingek
//megnézem van-e ilyen a szervezethez
//ezek vannak kitöltve a szervezethez
foreach (ProgramPendingQuestionForm qf in qfPendings.All)
{
//Az organisationhoz tartozóak a pendingben
PendingQuestionForm pqf = pqfService.PendingQuestionFormSelect(qf.PendingQuestionFormRef);
if (pqf != null && pqf.TemplateRef == template.ID /*&& pqf.Status != QuestionFormStatus.Updated_SendBack && pqf.Status != QuestionFormStatus.New_SendBack*/) // ki van töltve
{
//invaild státuszok
if (pqf.Status.Equals(QuestionFormStatus.New) || pqf.Status.Equals(QuestionFormStatus.New_Rejected) ||
pqf.Status.Equals(QuestionFormStatus.New_SendBack) ||
pqf.Status.Equals(QuestionFormStatus.Updated) ||
pqf.Status.Equals(QuestionFormStatus.Updated_Rejected) ||
pqf.Status.Equals(QuestionFormStatus.Updated_SendBack))
{
isFilled = false;
// Nincs kitöltve neki
if (organisationState == OrganisationValidate.IsValid || organisationState == "")
{
organisationState = OrganisationValidate.NoQuestionForm;
}
else
{
if (organisationState.IndexOf(OrganisationValidate.NoQuestionForm) < 0) //még nem írtam be ezt a hibát
organisationState += " " + OrganisationValidate.NoQuestionForm;
}
continue; //tovább a ciklusban, mert ezt elég egyszer beírni a státuszba
}
isFilled = true;
//nincs még ilyen
if (allPendingsToTemplate[pqf.HashString()] == null)
allPendingsToTemplate.Add(pqf);
}
} // amikor ideérek, akkor az isFilled true, ha van ilyen kérdőív kitöltve a szervezethez
//és a allPendingsToTemplate -ben benne van az összes pending ehhez a template-hez
//amikor itt tartunk megvan az összes szervezethez tartozó pendibgünk, ehhez a template-hoz
if (allPendingsToTemplate.AllCount > 0)
{
//Ebből ki kell vennünk a legutolsót
ArrayList allSorted = allPendingsToTemplate.All.SortBy("SentDate");
//Itt egy sorrendezett listánk van
//Kiveszem az utolsót, mert dátum szerint ezt kell nézni
var validable = (PendingQuestionForm)allSorted[allSorted.Count - 1];
//Mindig csak az utolsót kell validálni
if (validable != null)
{
if (validable.Status.Equals(QuestionFormStatus.New_WaitingForDecision) ||
validable.Status.Equals(QuestionFormStatus.Updated_WaitingForDecision))
{
continue; // végeztünk, mert jóváhagyásra váró kérdőíve van ehhez a template-hez
}
//megnézzük hogy jóváhagyottja van-e
if (validable.Status.Equals(QuestionFormStatus.New_Accepted) ||
validable.Status.Equals(QuestionFormStatus.Updated_Accepted))
{
if (service)
{
//van jóváhagyottja, akkor meg kell nézni, hogy az utplsó módosíás dátuma nem túl régi-e
//if (referenceDate < (DateTime) validable.SentDate)
{
// Túl régi ehhez a template-hoz
if (organisationState == OrganisationValidate.IsValid || organisationState == "")
{
organisationState = OrganisationValidate.NoQuestionFormRefresh;
}
else
{
if (organisationState.IndexOf(OrganisationValidate.NoQuestionFormRefresh) < 0)
//még nem írtam be ezt a hibát
organisationState += " " + OrganisationValidate.NoQuestionFormRefresh;
}
}
}
else
{
//van jóváhagyottja, akkor meg kell nézni, hogy az utplsó módosíás dátuma nem túl régi-e
if (referenceDate.AddDays(-(int)refreshNum) > (DateTime)validable.SentDate)
{
// Túl régi ehhez a template-hoz
if (organisationState == OrganisationValidate.IsValid || organisationState == "")
{
organisationState = OrganisationValidate.NoQuestionFormRefresh;
}
else
{
if (organisationState.IndexOf(OrganisationValidate.NoQuestionFormRefresh) < 0)
//még nem írtam be ezt a hibát
organisationState += " " + OrganisationValidate.NoQuestionFormRefresh;
}
}
}
}
////invaild státuszok
//if (validable.Status.Equals(QuestionFormStatus.New) || validable.Status.Equals(QuestionFormStatus.New_Rejected) ||
// validable.Status.Equals(QuestionFormStatus.New_SendBack) ||
// validable.Status.Equals(QuestionFormStatus.Updated) ||
// validable.Status.Equals(QuestionFormStatus.Updated_Rejected) ||
// validable.Status.Equals(QuestionFormStatus.Updated_SendBack))
//{
// isFilled = false;
//}
}
}
//nincs kitöltve
if (!isFilled)
if (organisationState == OrganisationValidate.IsValid || organisationState == "")
{
organisationState = OrganisationValidate.NoQuestionForm;
}
if (organisationState.IndexOf(OrganisationValidate.NoQuestionForm) < 0)
//még nem írtam be ezt a hibát
organisationState += " " + OrganisationValidate.NoQuestionForm;
}
//Mindig csak a legutolsó pendinget kell megnéznem. Ennek a státusza számít
return organisationState;
}
public new void ProgramAttachmentInsert(ProgramAttachment entity)
{
// check permission: admin
PrincipalPermission permReg = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Registered");
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permReg.Union(permAdmin).Demand();
TraceCallEnterEvent.Raise();
try
{
ProgramService progSrv = new ProgramService();
Program selectedProgram = progSrv.ProgramSelect(entity.ProgramRef);
if (selectedProgram == null)
throw new ApplicationException("A megadott azonosítóval nem létezik program.");
string writerRole = selectedProgram.OrganisationRef.Value.ToString() + ".Writer";
PrincipalPermission permWriter = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, writerRole);
permWriter.Union(permAdmin).Demand();
// check required fields:
if (entity.Name.Length == 0)
throw new ArgumentNullException("ProgramAttachment.Name", "A csatolt fájl neve nincs megadva.");
if (entity.Description.Length == 0)
throw new ArgumentNullException("ProgramAttachment.Description", "A csatolt fájl leírása nincs megadva.");
if (entity.Path.Length == 0 || entity.Path == DBString.Null)
throw new ArgumentNullException("ProgramAttachment.Path", "A fájlnév nincs megadva.");
if (entity.FileData == null || entity.FileData.Length == 0)
throw new ArgumentNullException("ProgramAttachment.FileData", "A fájl tartalma nincs megadva.");
string fileName = entity.ID.Value.ToString() + Path.GetExtension(entity.Path);
// save data
FileDataContext fileDataContext = new FileDataContext();
fileDataContext.ProgramAttachmentInsert(entity.ProgramRef, fileName, entity.FileData);
entity.CreatedDate = DBDateTime.Now;
entity.IsActive = true;
entity.FileSize = entity.FileData.Length;
base.ProgramAttachmentInsert(entity);
BusinessAuditEvent.Success(
new EventParameter("ProgramAttachmentID", entity.ID.ToString()),
new EventParameter("ProgramAttachmentName", entity.Name),
new EventParameter("ProgramID", entity.ProgramRef.ToString())
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("ProgramAttachmentID", entity.ID.ToString()),
new EventParameter("ProgramAttachmentName", entity.Name),
new EventParameter("ProgramID", entity.ProgramRef.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public new void ProgramAttachmentUpdate(ProgramAttachment entity)
{
// check permission: admin, writer
PrincipalPermission permReg = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Registered");
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permReg.Union(permAdmin).Demand();
TraceCallEnterEvent.Raise();
try
{
ProgramService progSrv = new ProgramService();
Program selectedProgram = progSrv.ProgramSelect(entity.ProgramRef);
if (selectedProgram == null)
throw new ApplicationException("A megadott azonosítóval nem létezik program.");
string writerRole = selectedProgram.OrganisationRef.Value.ToString() + ".Writer";
PrincipalPermission permWriter = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, writerRole);
permWriter.Union(permAdmin).Demand();
// check required fields:
if (entity.Name.Length == 0)
throw new ArgumentNullException("ProgramAttachment.Name", "A csatolt fájl neve nincs megadva.");
if (entity.Description.Length == 0)
throw new ArgumentNullException("ProgramAttachment.Description", "A csatolt fájl leírása nincs megadva.");
ProgramAttachment selected = base.ProgramAttachmentSelect(entity.ID);
if (selected == null)
throw new ApplicationException("A csatolt dokumentum nem létezik.");
if (!selected.IsActive)
throw new ApplicationException("A csatolt dokumentum nem aktív.");
// save data
if (entity.FileData != null && entity.FileData.Length > 0)
{
if (entity.Path.Length == 0 || entity.Path == DBString.Null)
throw new ArgumentNullException("ProgramAttachment.Path", "A fájlnév nincs megadva.");
ProgramAttachment newAttachment = new ProgramAttachment(Guid.NewGuid(), entity);
string fileName = newAttachment.ID.Value.ToString() + Path.GetExtension(newAttachment.Path);
FileDataContext fileDataContext = new FileDataContext();
fileDataContext.ProgramAttachmentInsert(newAttachment.ProgramRef, fileName, entity.FileData);
newAttachment.CreatedDate = DBDateTime.Now;
newAttachment.IsActive = true;
newAttachment.FileSize = entity.FileData.Length;
selected.IsActive = false;
m_DataContext.BeginNestedTran();
try
{
base.ProgramAttachmentInsert(newAttachment);
base.ProgramAttachmentUpdate(selected);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
}
else
{
selected.Name = entity.Name;
selected.Description = entity.Description;
selected.Author = entity.Author;
selected.Publisher = entity.Publisher;
selected.PublishedYear = entity.PublishedYear;
selected.Keywords = entity.Keywords;
base.ProgramAttachmentUpdate(selected);
}
BusinessAuditEvent.Success(
new EventParameter("ProgramAttachmentID", entity.ID.ToString()),
new EventParameter("ProgramAttachmentName", entity.Name),
new EventParameter("ProgramID", entity.ProgramRef.ToString())
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("ProgramAttachmentID", entity.ID.ToString()),
new EventParameter("ProgramAttachmentName", entity.Name),
new EventParameter("ProgramID", entity.ProgramRef.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public void PendingQuestionFormUpdateForProgram(PendingQuestionForm entity)
{
TraceCallEnterEvent.Raise();
try
{
if (entity.ProgramID.IsNull)
throw new ArgumentNullException("PendingQuestionForm.ProgramID", "A program azonosítója nincs megadva.");
ProgramService programSrv = new ProgramService(m_DataContext);
Program program = programSrv.ProgramSelect(entity.ProgramID);
if (program == null)
throw new ApplicationException("A megadott azonosítóval nem létezik program.");
string writerRole = program.OrganisationRef.Value.ToString() + ".Writer";
PrincipalPermission permWriter = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, writerRole);
permWriter.Demand();
// required:
if (entity.TemplateRef.IsNull)
throw new ArgumentNullException("PendingQuestionForm.TemplateRef", "A sablon azonosítója nincs megadva.");
if (entity.Status.Length == 0)
throw new ArgumentNullException("PendingQuestionForm.Status", "A státusz nincs megadva.");
// logical check:
TemplateCategoryService templCatSrv = new TemplateCategoryService(m_DataContext);
TemplateCategory templCat = templCatSrv.TemplateCategorySelect(entity.TemplateRef, program.ProgramCategoryRef);
if (templCat == null)
throw new ApplicationException("A megadott programhoz nem tölthetõ ki ez a sablon.");
PendingQuestionForm selectedPending = base.PendingQuestionFormSelect(entity.ID);
if (selectedPending == null)
throw new ApplicationException("A módosítani kívánt kérdõív nem létezik.");
// set data:
entity.SentBy = Thread.CurrentPrincipal.Identity.Name;
entity.SentDate = DBDateTime.Now;
entity.LastModifiedByUser = DBDateTime.Now;
if (entity.Status == "UWD" || entity.Status == "NWD")
entity.IsActual = true;
else
{
entity.IsActual = false;
}
PendingQuestionFormDetailService detailService = new PendingQuestionFormDetailService(m_DataContext);
ProgramPendingQuestionFormService programPendingSrv = new ProgramPendingQuestionFormService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
base.PendingQuestionFormUpdate(entity);
base.DeleteChildrenByDetailOfPendingQuestionForm(entity.ID);
foreach (PendingQuestionFormDetail detail in entity.Details.All)
{
detailService.PendingQuestionFormDetailInsert(detail);
}
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
// Log success
BusinessAuditEvent.Success(
new EventParameter("PendingQuestionFormID", entity.ID.ToString()),
new EventParameter("ProgramID", entity.ProgramID.ToString())
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("PendingQuestionFormID", entity.ID.ToString()),
new EventParameter("ProgramID", entity.ProgramID.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public void PendingQuestionFormInsertForProgram(PendingQuestionForm entity)
{
TraceCallEnterEvent.Raise();
try
{
if (entity.ProgramID.IsNull)
throw new ArgumentNullException("PendingQuestionForm.ProgramID", "A program azonosítója nincs megadva.");
ProgramService programSrv = new ProgramService(m_DataContext);
Program program = programSrv.ProgramSelect(entity.ProgramID);
if (program == null)
throw new ApplicationException("A megadott azonosítóval nem létezik program.");
string writerRole = program.OrganisationRef.Value.ToString() + ".Writer";
PrincipalPermission permWriter = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, writerRole);
permWriter.Demand();
// required:
if (entity.TemplateRef.IsNull)
throw new ArgumentNullException("PendingQuestionForm.TemplateRef", "A sablon azonosítója nincs megadva.");
if (entity.Status.Length == 0)
throw new ArgumentNullException("PendingQuestionForm.Status", "A státusz nincs megadva.");
/* TODO módosításnál ez is kötelezõ:
if(entity.QuestionFormRef.IsNull)
throw new ArgumentNullException("PendingQuestionForm.QuestionFormRef", "Az eredeti kérdõív azonosítója nincs megadva.");
*/
// logical check:
TemplateCategoryService templCatSrv = new TemplateCategoryService(m_DataContext);
TemplateCategory templCat = templCatSrv.TemplateCategorySelect(entity.TemplateRef, program.ProgramCategoryRef);
if (templCat == null)
throw new ApplicationException("A megadott programhoz nem tölthetõ ki ez a sablon.");
// ellenõrizzük, hogy nincs folyamatban ilyen kérdõív kitöltése:
TemplateService srv = new TemplateService(m_DataContext);
Template tmplCurrentPending =
srv.TemplateSelectOfProgramPendingQuestionFormByTemplateID(program.ID, entity.TemplateRef);
if (!tmplCurrentPending.Status.IsNull)
{
throw new ApplicationException("A kérdõív nem módosítható, mert a módosítás már folyamatban van.");
}
// set data:
entity.SentBy = Thread.CurrentPrincipal.Identity.Name;
entity.SentDate = DBDateTime.Now;
entity.LastModifiedByUser = DBDateTime.Now;
if (entity.Status == "UWD" || entity.Status == "NWD")
entity.IsActual = true;
else
{
entity.IsActual = false;
}
ProgramPendingQuestionForm programPending = new ProgramPendingQuestionForm(program.ID, entity.ID);
PendingQuestionFormDetailService detailService = new PendingQuestionFormDetailService(m_DataContext);
ProgramPendingQuestionFormService programPendingSrv = new ProgramPendingQuestionFormService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
base.PendingQuestionFormInsert(entity);
foreach (PendingQuestionFormDetail detail in entity.Details.All)
{
detailService.PendingQuestionFormDetailInsert(detail);
}
programPendingSrv.ProgramPendingQuestionFormInsert(programPending);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
// Log success
BusinessAuditEvent.Success(
new EventParameter("PendingQuestionFormID", entity.ID.ToString()),
new EventParameter("ProgramID", entity.ProgramID.ToString())
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("PendingQuestionFormID", entity.ID.ToString()),
new EventParameter("ProgramID", entity.ProgramID.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public TemplateContainer TemplateSelectOfProgramQuestionFormOwn(DBGuid ProgramIdVal, DBGuid OrganisationIdVal)
{
TraceCallEnterEvent.Raise();
try
{
ProgramService progSrv = new ProgramService(m_DataContext);
Program selectedProg = progSrv.ProgramSelect(ProgramIdVal);
if (selectedProg == null)
throw new ApplicationException("A megadott azonosítóval nem létezik program.");
if (!selectedProg.IsActive)
throw new ApplicationException("A program nem aktív.");
TemplateContainer result;
DataSet entitySet = m_DataContext.ndihdTemplateSelectOfProgramQuestionFormOwn(
ProgramIdVal, OrganisationIdVal);
result = new TemplateContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
/// <summary>
///
/// </summary>
/// <param name="programID"></param>
/// <param name="templateID"></param>
/// <returns></returns>
public string GetQuestionFormAsXML(DBGuid programID, DBGuid templateID)
{
TraceCallEnterEvent.Raise();
try
{
string result = "";
ProgramService programService = new ProgramService(m_DataContext);
Program program = programService.ProgramSelect(programID);
if (program == null)
throw new ApplicationException("Ezzel az azonosítóval nem létezik program.");
TemplateContainer availableTemplates = TemplateSelectOfProgramPendingQuestionForm(programID);
Template currentTemplate = (Template) availableTemplates[templateID.ToString()];
if (currentTemplate == null)
throw new ApplicationException("Ezzel az azonosítóval nem létezik kérdõív a megadott programhoz.");
if (currentTemplate.Status.Equals("NWD") || currentTemplate.Status.Equals("UWD"))
{
throw new ApplicationException("A megadott kérdõív jóváhagyásra vár, nem módosítható.");
}
Template extendedTemplate = TemplateSelect(currentTemplate.ID);
// feltöltjük a válaszokat
PendingQuestionFormService pendingQuestionFormService = new PendingQuestionFormService(m_DataContext);
QuestionFormService questionFormService = new QuestionFormService(m_DataContext);
if (!currentTemplate.PendingQuestionFormID.IsNull)
{
PendingQuestionFormDetailContainer pendingAnswers =
pendingQuestionFormService.SelectChildrenByDetailOfPendingQuestionForm(currentTemplate.PendingQuestionFormID);
foreach (TemplateDetail d in extendedTemplate.Details.All)
{
string hash = currentTemplate.PendingQuestionFormID.ToString() + "<#>" +
d.ID.ToString() + "<#>" +
d.TemplateRef.ToString();
PendingQuestionFormDetail answer = (PendingQuestionFormDetail) pendingAnswers[hash];
if (answer != null)
{
d.Answer = answer.Answer;
}
}
}
else
{
if (!currentTemplate.QuestionFormID.IsNull)
{
QuestionFormDetailContainer acceptedAnswers =
questionFormService.SelectChildrenByDetailOfQuestionForm(currentTemplate.QuestionFormID);
foreach (TemplateDetail d in extendedTemplate.Details.All)
{
string hash = currentTemplate.QuestionFormID.ToString() + "<#>" +
d.ID.ToString() + "<#>" +
d.TemplateRef.ToString();
QuestionFormDetail answer = (QuestionFormDetail) acceptedAnswers[hash];
if (answer != null)
{
d.Answer = answer.Answer;
}
}
}
}
// Build XML
StringWriter sw = new StringWriter();
XmlTextWriter xtw = new XmlTextWriter(sw);
xtw.WriteStartElement("QuestionForm");
xtw.WriteElementString("QuestionFormID", currentTemplate.QuestionFormID.AsXmlString);
xtw.WriteElementString("PendingQuestionFormID", currentTemplate.PendingQuestionFormID.AsXmlString);
xtw.WriteElementString("Status", currentTemplate.Status.AsXmlString);
// --- program paramétereinek beállítása
ProgramCategoryService pcs = new ProgramCategoryService(m_DataContext);
if (!program.ProgramCategoryRef.IsNull)
{
ProgramCategory pc = pcs.ProgramCategorySelect(program.ProgramCategoryRef);
if (pc != null) program.ProgramCategoryName = pc.Name;
}
OrganisationService os = new OrganisationService(m_DataContext);
if (!program.OrganisationRef.IsNull)
{
Organisation org = os.OrganisationSelect(program.OrganisationRef);
if (org != null) program.OrganisationName = org.Name;
}
xtw.WriteRaw(program.AsXmlString);
string templateXML = ConvertTemplateToXML(extendedTemplate);
xtw.WriteRaw(templateXML);
xtw.WriteEndElement();
result = sw.ToString();
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public Template TemplateSelectOfProgramPendingQuestionFormByTemplateID(DBGuid ProgramIdVal, DBGuid TemplateIdVal)
{
TraceCallEnterEvent.Raise();
try
{
ProgramService progSrv = new ProgramService(m_DataContext);
Program selectedProg = progSrv.ProgramSelect(ProgramIdVal);
if (selectedProg == null)
throw new ApplicationException("A megadott azonosítóval nem létezik program.");
string writerRole = selectedProg.OrganisationRef.Value.ToString() + ".Writer";
string readerRole = selectedProg.OrganisationRef.Value.ToString() + ".Reader";
PrincipalPermission permWriter = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, writerRole);
PrincipalPermission permReader = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, readerRole);
permWriter.Union(permReader).Demand();
if (!selectedProg.IsActive)
throw new ApplicationException("A program nem aktív.");
DataSet entitySet =
m_DataContext.ndihdTemplateSelectOfProgramPendingQuestionFormByTemplateID(ProgramIdVal, TemplateIdVal);
Template retTempl = new Template(entitySet);
TraceCallReturnEvent.Raise();
return retTempl;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
private string AddProgramRelated(Guid progID)
{
string searchText = "";
ProgramService srvProg = new ProgramService(m_DataContext);
DataSet ds = srvProg.ProgramSelectRelated(progID);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
searchText = searchText + " " + dr["cAnswer"];
searchText = searchText + " " + dr["cID"];
searchText = searchText + " " + dr["cQuestion"];
searchText = searchText + " " + dr["cDescription"];
}
return searchText;
}
public void SaveProgram(Guid progID)
{
TraceCallEnterEvent.Raise();
Program entity = null;
try
{
//lekérdezzük a program ID alapján a programot
ProgramService srvProg = new ProgramService();
entity = srvProg.ProgramSelect(progID);
//logical check
if (entity == null)
throw new ApplicationException("Ezzel az azonosítóval nem létezik program.");
//megnézzük hogy van e már hozzá megadott keresõ szöveg .. mert akkor azt update -eljük
GlobalSearch search = base.GlobalSearchSelect(entity.ID, "PROGRAM");
if (search != null)
{
search.SearchText = entity.Name.ToString() + " " + entity.Description.ToString();
//lekérdezzük a hozzá tartozó összes kérdõív adatait és hozzáadjuk a SearchText -hez
search.SearchText = search.SearchText + AddProgramRelated(entity.ID);
//ha van ilyen UPDATE
base.GlobalSearchUpdate(search);
}
else //ha még nincs ilyen INSERT
{
search = new GlobalSearch(entity.ID, "PROGRAM");
search.SearchText = entity.Name.ToString() + " " + entity.Description.ToString();
//lekérdezzük a hozzá tartozó összes kérdõív adatait és hozzáadjuk a SearchText -hez
search.SearchText = search.SearchText + AddProgramRelated(entity.ID);
base.GlobalSearchInsert(search);
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("IDRef", entity.ID.ToString()),
new EventParameter("SearchCategory", "PROGRAM")
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
