public bool OrganisationPendingUserReject(OrganisationPendingUser entity)
{
//Check permission: Admin
PrincipalPermission permissionAdm =
new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permissionAdm.Demand();
TraceCallEnterEvent.Raise();
try
{
// Check required fields
if (entity.RejectComment.Length == 0)
throw new ArgumentNullException("OrganisationPendingUser.RejectComment",
"Az elutasítás indoklása nincs megadva.");
// Logical checks
OrganisationPendingUser selected = base.OrganisationPendingUserSelect(entity.ID);
if (selected == null)
throw new ApplicationException("A megadott azonosítóhoznemtartozik igénylés.");
if (! selected.Status.Equals(RegistrationStatus.New))
throw new ApplicationException("Csak új státuszú regisztráció bírálható el.");
// Set properties
selected.DecidedBy = Thread.CurrentPrincipal.Identity.Name;
selected.DecidedDate = DBDateTime.Now;
selected.Status = RegistrationStatus.Rejected;
selected.RejectComment = entity.RejectComment;
//Emailben szereplõ adatok lekkérdezése
string userEmail = "";
string userFullName = "";
string organisationName = "";
IOrganisationPendingUserService srvOpu = new OrganisationPendingUserService();
OrganisationPendingUser opu = srvOpu.OrganisationPendingUserSelect(entity.ID);
IOrganisationService srvOrg = new OrganisationService();
IUserService srvUser = new UserService();
Organisation org = srvOrg.OrganisationSelect(opu.OrganisationRef);
User u = srvUser.UserSelect(opu.LoginNameRef);
userEmail = u.Email;
userFullName = u.Name;
organisationName = org.Name;
//set mail:
Email mail = new Email(Guid.NewGuid());
mail.Category = EmailCategory.OrganisationRegistrationReject;
mail.To = userEmail;
//Subject és body lekérdezése
string body = "";
string subject = "";
IEmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, EmailCategory.OrganisationRegistrationReject);
mail.Subject = subject;
body = body.Replace("<FULL_USER_NAME>", userFullName);
body = body.Replace("<LOGIN_NAME>", u.LoginName);
body = body.Replace("<ORGANISATION>", organisationName);
body = body.Replace("<REJECT_COMMENT>", entity.RejectComment);
mail.MailBody = body;
// Save data to database
EmailService emailSrv = new EmailService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
base.OrganisationPendingUserUpdate(selected);
emailSrv.EmailInsert(mail);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
// Sending mail:
try
{
emailSrv.EmailSend(mail.ID);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return false;
}
// Log success
BusinessAuditEvent.Success(
new EventParameter("RegisterOrganisationID", entity.ID.ToString()),
new EventParameter("OrganisationName", organisationName),
new EventParameter("LoginName", u.LoginName)
);
TraceCallReturnEvent.Raise();
return true;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("RegisterOrganisationID", entity.ID.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public bool OrganisationPendingUserAccept(Guid OrgPendingUseID, Guid OrganisationID, string LoginName,
string RejectText)
{
//Check permission: Admin
PrincipalPermission permissionAdm =
new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permissionAdm.Demand();
TraceCallEnterEvent.Raise();
try
{
// Check required fields
if (OrgPendingUseID == Guid.Empty)
throw new ArgumentNullException("OrganisationPendingUser.OrgPendingUseID",
"A jóváhagyás azonosítója nincs megadva.");
if (OrganisationID == Guid.Empty)
throw new ArgumentNullException("OrganisationPendingUser.OrganisationRef",
"A regisztrálandó szervezet azonosítója nincs megadva.");
if (LoginName.Length == 0)
throw new ArgumentNullException("OrganisationPendingUser.LoginNameRef",
"A regisztrálandó felhasználó nincs megadva.");
// Logical checks
OrganisationPendingUser selected = base.OrganisationPendingUserSelect(OrgPendingUseID);
if (selected == null)
throw new ApplicationException("A megadott azonosítóval nem létezik regisztráció.");
if (! selected.Status.Equals(RegistrationStatus.New))
throw new ApplicationException("Csak új státuszú regisztráció bírálható el.");
// Frissitjük a regisztráció adatait
selected.SentDate = selected.SentDate;
selected.DecidedBy = Thread.CurrentPrincipal.Identity.Name;
selected.DecidedDate = DBDateTime.Now;
selected.Status = RegistrationStatus.Accepted;
selected.RejectComment = RejectText;
//Emailben szereplõ adatok lekkérdezése
string userEmail = "";
string userFullName = "";
string organisationName = "";
OrganisationService srvOrg = new OrganisationService();
UserService srvUser = new UserService();
Organisation org = srvOrg.OrganisationSelect(OrganisationID);
User u = srvUser.UserSelect(LoginName);
userEmail = u.Email;
userFullName = u.Name;
organisationName = org.Name;
//set mail:
Email mail = new Email(Guid.NewGuid());
mail.Category = EmailCategory.OrganisationPendingUserAccept;
mail.To = userEmail;
//Subject és body lekérdezése
string body = "";
string subject = "";
IEmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, EmailCategory.OrganisationPendingUserAccept);
mail.Subject = subject;
body = body.Replace("<FULL_USER_NAME>", userFullName);
body = body.Replace("<LOGIN_NAME>", LoginName);
body = body.Replace("<ORGANISATION>", organisationName);
mail.MailBody = body;
// Save data to database
EmailService emailSrv = new EmailService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
//eltároljuk a szervezet-felhasználó kapcsolatot
OrganisationUserService orgUserSrv = new OrganisationUserService(m_DataContext);
OrganisationUser orgUser = new OrganisationUser(OrganisationID, LoginName);
orgUser.Right = selected.Right;
orgUserSrv.OrganisationUserInsert(orgUser);
base.OrganisationPendingUserUpdate(selected);
emailSrv.EmailInsert(mail);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
// Sending mail:
try
{
emailSrv.EmailSend(mail.ID);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return false;
}
// Log success
BusinessAuditEvent.Success(
new EventParameter("OrganisationPendingUser", OrgPendingUseID.ToString()),
new EventParameter("OrganisationID", OrganisationID.ToString()),
new EventParameter("LoginName", LoginName)
);
TraceCallReturnEvent.Raise();
return true;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("OrganisationPendingUser", OrgPendingUseID.ToString()),
new EventParameter("OrganisationID", OrganisationID.ToString()),
new EventParameter("LoginName", LoginName)
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public void JobAnswerInactivateExpired()
{
TraceCallEnterEvent.Raise();
try
{
// Save data
//m_DataContext.ndihdJobFindSetStatus(entity.ID, entity.Status);
// Save data
//m_DataContext.ndihdJobFindSetStatus(entity.ID, entity.Status);
//ki kell keresni azokat az aktív hirdetéseket, amiknek a lejárati dátuma már eljött, de még aktívak
JobAnswer filter = new JobAnswer(Guid.Empty, "", "", "");
filter.FilterOnIsActive = 1;
filter.Expiredate = DateTime.Now;
//filter.FilterOnSubscriberNotificationSend = 0;
JobAnswerContainer answers = JobAnswerSelectFiltered(filter);
string body = "";
string subject = "";
EmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, EmailCategory.JobExpired);
UserService srvUser = new UserService();
JobFindService srvFind = new JobFindService();
JobOfferService srvOff = new JobOfferService();
foreach (JobAnswer answer in answers.All)
{
User subscriber = srvUser.UserSelect(answer.SubscriberNameRef);
string refId = "";
string description = "";
if (answer.Type == JobAnswerTypeEnum.FIN)
{
JobFind job = srvFind.JobFindSelect(answer.JobRef);
if (job != null)
{
refId = job.RefId.ToString();
description = job.Description;
}
}
else
{
JobOffer job = srvOff.JobOfferSelect(answer.JobRef);
if (job != null)
{
refId = job.RefId.ToString();
description = job.Description;
}
}
string bodynew = "";
//küldünk egy levelet a barátunknak
bodynew = body.Replace("<FULL_USER_NAME>", subscriber == null ? answer.SubscriberNameRef : subscriber.Name);
bodynew = bodynew.Replace("<JOB_REFID>", refId);
bodynew = bodynew.Replace("<JOB_DESCRIPTION>", description);
bodynew = bodynew.Replace("<JOB_TYPE>", "állásajánlat");
bodynew = bodynew.Replace("<JOB_DATE>", answer.Expiredate.ToShortDateString());
if (subscriber == null)
break;
SendMailToSender(EmailCategory.JobExpired, bodynew, subject, subscriber.Email, true, answer);
}
BusinessAuditEvent.Success();
TraceCallReturnEvent.Raise("JobAnswerInactivateExpired");
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail("JobAnswerInactivateExpired",
new EventParameter("Exception", ex.ToString()));
TraceCallReturnEvent.Raise(false);
throw;
}
}
public new void JobOfferInsert(JobOffer entity)
{
// check permission: Writer or 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();
m_DataContext.BeginNestedTran();
try
{
// check required fields:
if (entity.Description.Length == 0)
throw new ArgumentNullException("JobOffer.Description", "A hirdetés leírása nincs megadva.");
entity.Sender = Thread.CurrentPrincipal.Identity.Name;
entity.Status = JobStatusEnum.ACT;
entity.NotificationSend = false;
entity.LastModified = DateTime.Now;
entity.Created = DateTime.Now;
base.JobOfferInsert(entity);
JobOfferAttachmentService attSrv = new JobOfferAttachmentService(m_DataContext);
// EDocumentAttachments - insert:
foreach (JobOfferAttachment file in entity.JobOfferAttachments.Current)
{
file.JobOfferRef = entity.ID;
file.IsActive = true;
file.CreatedDate = DateTime.Now;
attSrv.JobOfferAttachmentInsert(file);
}
m_DataContext.CommitNested();
#region Találati mail
entity = JobOfferSelect(entity.ID); // a refid miatt kell
//Ellenõrizni kell, hogy van-epárja megye, végzettség szerint. Ha van levelet kell küldeni
//a pár feladójának
JobFindService srvJobFind = new JobFindService();
JobFind filter = new JobFind(Guid.Empty);
filter.RegionRef = entity.RegionRef;
filter.Qualification = entity.QualificationMinRef;
filter.Status = JobStatusEnum.ACT;
//filter.Expiredate = DateTime.Now;
QualificationService srvQualification = new QualificationService();
UserService srvUser = new UserService();
JobFindContainer finds = srvJobFind.JobFindSelectFiltered(filter);
//Van pár
foreach (JobFind find in finds.All)
{
//Itt meg kell nézni azt is, hogy nem õ-e a másik hirdetés feladója
if (find.Sender != entity.Sender)
{
//értesítjük a feladót, hogy valaki válaszolt a hirdetésére
//set mail:
Email mail = new Email(Guid.NewGuid());
//Subject és body lekérdezése
string body = "";
string subject = "";
EmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, EmailCategory.JobFindMatchCreated);
mail.Category = EmailCategory.JobFindMatchCreated;
mail.Subject = subject;
User findSender = srvUser.UserSelect(find.Sender);
if (findSender != null)
{
mail.To = findSender.Email;
body = body.Replace("<FULL_USER_NAME>", findSender.Name);
body = body.Replace("<JOB_REFID>", entity.RefId.ToString());
body = body.Replace("<JOB_DESCRIPTION>", entity.Description);
body = body.Replace("<SENDER_NAME>", entity.ContactName);
body = body.Replace("<SENDER_MAIL>", entity.ContactEmail);
}
mail.MailBody = body;
if (mail.MailBody != null && mail.To != null && mail.Subject != null)
{
// Save data to database
EmailService emailSrv = new EmailService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
emailSrv.EmailInsert(mail);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
// Sending mail:
try
{
emailSrv.EmailSend(mail.ID);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return;
}
}
}
}
#endregion
BusinessAuditEvent.Success(
new EventParameter("JobOfferID", entity.ID.ToString()),
new EventParameter("JobOfferLogin", entity.Sender)
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
m_DataContext.RollbackNested();
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("JobOfferID", entity.ID.ToString()),
new EventParameter("JobOfferLogin", entity.Sender)
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public new void JobAnswerInsert(JobAnswer entity)
{
try
{
PrincipalPermission permReg = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Registered");
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permReg.Union(permAdmin).Demand();
JobAnswer ja = base.JobAnswerSelect(entity.JobRef, entity.Type, entity.SubscriberNameRef, entity.SenderNameRef);
if(ja != null)
{
if(ja.IsActive)
throw new ApplicationException("Erre a hirdetésre már válaszolt.");
}
//entity.SubscriberNameRef = Thread.CurrentPrincipal.Identity.Name;
entity.Created = DateTime.Now;
entity.IsActive = true;
if (ja == null)
{
base.JobAnswerInsert(entity);
}
else
{
ja = entity;
base.JobAnswerUpdate(ja);
}
//értesítjük a feladót, hogy valaki válaszolt a hirdetésére
//set mail:
Email mail = new Email(Guid.NewGuid());
//Subject és body lekérdezése
string body = "";
string subject = "";
EmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, EmailCategory.JobAnswerCreated);
mail.Category = EmailCategory.JobAnswerCreated;
mail.Subject = subject;
UserService srvUser = new UserService();
User subscriber = srvUser.UserSelect(entity.SubscriberNameRef);
//Ha keresés hirdetésre jelentkezett valaki
if (entity.Type == JobAnswerTypeEnum.FIN)
{
User sender = srvUser.UserSelect(entity.SenderNameRef);
if (sender != null && sender.Email.Length > 0)
{
JobFindService srvJob = new JobFindService();
JobFind find = srvJob.JobFindSelect(entity.JobRef);
mail.To = sender.Email;
body = body.Replace("<FULL_USER_NAME>", sender.Name);
if (find != null)
{
body = body.Replace("<JOB_REFID>", find.RefId.ToString());
body = body.Replace("<JOB_DESCRIPTION>", find.Description);
}
}
}
else
{
//ajánlat
JobOfferService srvJob = new JobOfferService();
JobOffer offer = srvJob.JobOfferSelect(entity.JobRef);
if (offer != null && offer.ContactEmail.Length > 0)
{
mail.To = offer.ContactEmail;
body = body.Replace("<FULL_USER_NAME>", offer.ContactName);
body = body.Replace("<JOB_REFID>", offer.RefId.ToString());
body = body.Replace("<JOB_DESCRIPTION>", offer.Description);
}
}
if (subscriber != null)
{
body = body.Replace("<SUBSCRIBER_NAME>", subscriber.Name);
body = body.Replace("<SUBSCRIBER_MAIL>", subscriber.Email);
body = body.Replace("<MOTIVATION>", entity.Motivation);
}
mail.MailBody = body;
if (mail.MailBody != null && mail.To != null && mail.Subject != null)
{
// Save data to database
EmailService emailSrv = new EmailService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
emailSrv.EmailInsert(mail);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
// Sending mail:
try
{
emailSrv.EmailSend(mail.ID);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return;
}
}
// Log success
BusinessAuditEvent.Success(
new EventParameter("JobRef", entity.JobRef.ToString()),
new EventParameter("OrganisationID", Thread.CurrentPrincipal.Identity.Name)
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("JobRef", entity.JobRef.ToString()),
new EventParameter("OrganisationID", Thread.CurrentPrincipal.Identity.Name)
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public bool OrganisationValidateSendEmailByCategory(Organisation entity, string category, string adminMail)
{
//Check permission: Admin
PrincipalPermission permissionAdm =
new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permissionAdm.Demand();
TraceCallEnterEvent.Raise();
try
{
// Logical checks:
Organisation selected = base.OrganisationSelect(entity.ID);
if (selected == null)
throw new ApplicationException("A megadott azonosítóval nem létezik szervezet.");
//Subject és body lekérdezése
string body = "";
string subject = "";
EmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, category);
// Le kell kérdezni a szervezethez tartozó irási joggal rendelkező felhasználókat
User filter = new User(DBString.Empty);
filter.Right = "W";
filter.OrganisationRef = entity.ID;
filter.IsActive = true;
filter.FilterOnIsactive = DBInt.Null;
filter.FilterOnLockedOut = 0;
// Retrieving data from BusinessServices
UserService srvUser = new UserService();
UserContainer allUser = srvUser.UserSelectFiltered(filter);
if (allUser.AllCount == 0)
{
OrganisationService srvOrgUser = new OrganisationService();
OrganisationUserContainer orgUsers = srvOrgUser.SelectChildrenByOrganisationOfOrganisationUser(selected.ID);
foreach (OrganisationUser orguser in orgUsers.All)
{
User user = srvUser.UserSelect(orguser.LoginNameRef);
if (allUser[user.HashString()] == null)
allUser.Add(user);
}
}
foreach (User user in allUser.All)
{
string tmpBody = body;
//set mail:
Email mail = new Email(Guid.NewGuid());
mail.Category = category;
mail.To = user.Email; //"*****@*****.**";
mail.OrganisationRef = entity.ID;
tmpBody = tmpBody.Replace("<FULL_USER_NAME>", user.Name);
tmpBody = tmpBody.Replace("<LOGIN_NAME>", user.LoginName);
tmpBody = tmpBody.Replace("<ORGANISATION>", selected.Name);
mail.MailBody = tmpBody;
mail.Subject = subject;
SendMail(mail);
}
if (!string.IsNullOrEmpty(adminMail)) //küldünk mailt az adminna is
{
string tmpBody = body;
//set mail:
Email mail = new Email(Guid.NewGuid());
mail.Category = EmailCategory.ValidationInactivationAdmin;
mail.To = adminMail; //"*****@*****.**";
mail.OrganisationRef = entity.ID;
tmpBody = tmpBody.Replace("<ORGANISATION>", selected.Name);
mail.MailBody = tmpBody;
mail.Subject = subject;
SendMail(mail);
}
// Log success
BusinessAuditEvent.Success(new EventParameter("OrganisationID", entity.ID.ToString()));
TraceCallReturnEvent.Raise();
return true;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("RegisterUserID", entity.ID.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public void JobFindInactivateExpired()
{
TraceCallEnterEvent.Raise();
try
{
// Save data
//m_DataContext.ndihdJobFindSetStatus(entity.ID, entity.Status);
//ki kell keresni azokat az aktív hirdetéseket, amiknek a lejárati dátuma már eljött, de még aktívak
JobFind filter = new JobFind(Guid.Empty);
filter.Status = JobStatusEnum.ACT;
filter.Expiredate = DateTime.Now;
JobFindContainer finds = JobFindSelectFiltered(filter);
string body = "";
string subject = "";
EmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, EmailCategory.JobExpired);
UserService srvUser = new UserService();
foreach (JobFind find in finds.All)
{
string bodynew;
User sender = srvUser.UserSelect(find.Sender);
find.LastModified = DateTime.Now;
find.Status = JobStatusEnum.EXP;
JobFindSetStatus(find); //inaktiváljuk
//küldünk egy levelet a barátunknak
bodynew = body.Replace("<FULL_USER_NAME>", sender == null ? find.Sender : sender.Name);
bodynew = bodynew.Replace("<JOB_REFID>", find.RefId.ToString());
bodynew = bodynew.Replace("<JOB_DESCRIPTION>", find.Description);
bodynew = bodynew.Replace("<JOB_TYPE>", "álláskeresés");
if (sender == null)
break;
SendMailToSender(EmailCategory.JobExpired, bodynew, subject, sender.Email, false, find.ID);
}
BusinessAuditEvent.Success();
TraceCallReturnEvent.Raise("JobFindInactivateExpired");
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail("JobFindInactivateExpired",
new EventParameter("Exception", ex.ToString()));
TraceCallReturnEvent.Raise(false);
throw;
}
}
public bool PendingQuestionFormSendBackNew(PendingQuestionForm entity)
{
//Check permission: Admin
PrincipalPermission permissionAdm =
new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permissionAdm.Demand();
TraceCallEnterEvent.Raise();
try
{
//Check required fields
if (entity.ID.IsNull)
throw new ArgumentNullException("PendingQuestionForm.ID", "Az elbírálandó kérdõív azonosítója nincs megadva.");
if (entity.ProgramCategoryId.Length == 0)
throw new ArgumentNullException("PendingQuestionForm.ProgramCategoryId",
"Az elbírálandó kérdõív kategóriája nincs megadva.");
if (entity.TemplateRef.IsNull)
throw new ArgumentNullException("PendingQuestionForm.TemplateRef", "A sablon azonosítója nincs megadva.");
if (entity.RejectComment.Length == 0)
throw new ArgumentNullException("PendingQuestionForm.RejectComment", "A visszaküldés indoklása nincs megadva.");
// Logical checks:
PendingQuestionForm selected = base.PendingQuestionFormSelect(entity.ID);
if (selected == null)
throw new ApplicationException("A megadott azonosítóval nem létezik elbírálandó kérdõív.");
if (!selected.Status.Equals(QuestionFormStatus.New_WaitingForDecision))
throw new ApplicationException("Csak jóváhagyásra váró státuszú kérdõív bírálható el.");
// Set properties
selected.DecidedBy = Thread.CurrentPrincipal.Identity.Name;
selected.DecidedDate = DBDateTime.Now;
selected.Status = QuestionFormStatus.New_SendBack;
selected.RejectComment = entity.RejectComment;
selected.QuestionFormRef = entity.QuestionFormRef;
selected.IsActual = false;
//Set mail:
UserService userSrv = new UserService(m_DataContext);
User sentBy = userSrv.UserSelect(selected.SentBy);
Email mail = new Email(Guid.NewGuid());
mail.Category = EmailCategory.QuestionFormInsertSendBack;
mail.To = sentBy.Email;
//Subject és body lekérdezése
string body = "";
string subject = "";
EmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, EmailCategory.QuestionFormInsertSendBack);
mail.Subject = subject;
body = body.Replace("<FULL_USER_NAME>", sentBy.Name);
body = body.Replace("<SENT_DATE>", entity.SentDate.ToString());
body = body.Replace("<TEMPLATE_NAME>", entity.TemplateName);
body = body.Replace("<REJECT_COMMENT>", entity.RejectComment);
mail.MailBody = body;
// Save data to database
EmailService emailSrv = new EmailService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
base.PendingQuestionFormUpdate(selected);
emailSrv.EmailInsert(mail);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
// Sending mail:
try
{
emailSrv.EmailSend(mail.ID);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return false;
}
// Log success
BusinessAuditEvent.Success(
new EventParameter("PendingQuestionFormID", entity.ID.ToString()),
new EventParameter("ProgramID", entity.ProgramID.ToString()),
new EventParameter("OrganisationID", entity.OrganisationID.ToString())
);
TraceCallReturnEvent.Raise();
return true;
}
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()),
new EventParameter("OrganisationID", entity.OrganisationID.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public bool PendingQuestionFormAcceptNew(PendingQuestionForm entity)
{
//Check permission: Admin
PrincipalPermission permissionAdm =
new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permissionAdm.Demand();
TraceCallEnterEvent.Raise();
try
{
//Check required fields
if (entity.ID.IsNull)
throw new ArgumentNullException("PendingQuestionForm.ID", "Az elbírálandó kérdõív azonosítója nincs megadva.");
if (entity.ProgramCategoryId.Length == 0)
throw new ArgumentNullException("PendingQuestionForm.ProgramCategoryId",
"Az elbírálandó kérdõív kategóriája nincs megadva.");
if (entity.TemplateRef.IsNull)
throw new ArgumentNullException("PendingQuestionForm.TemplateRef", "A sablon azonosítója nincs megadva.");
if (entity.Details.AllCount == 0)
throw new ArgumentNullException("PendingQuestionForm.Details", "A válaszok nincsenek megadva.");
if (entity.ProgramCategoryId.Equals("ORG"))
{
if (entity.OrganisationID.IsNull)
throw new ArgumentNullException("PendingQuestionForm.OrganisationID",
"A szervezet azonosítója nincs megadva.");
}
else
{
if (entity.ProgramID.IsNull)
throw new ArgumentNullException("PendingQuestionForm.ProgramID", "A program azonosítója nincs megadva.");
}
// Logical checks:
PendingQuestionForm selected = base.PendingQuestionFormSelect(entity.ID);
if (selected == null)
throw new ApplicationException("A megadott azonosítóval nem létezik elbírálandó kérdõív.");
if (!selected.Status.Equals(QuestionFormStatus.New_WaitingForDecision))
throw new ApplicationException("Csak jóváhagyásra váró státuszú kérdõív bírálható el.");
// Set properties
DBGuid questionFormID = Guid.NewGuid();
QuestionForm questionForm = new QuestionForm(questionFormID);
questionForm.TemplateRef = entity.TemplateRef;
selected.DecidedBy = Thread.CurrentPrincipal.Identity.Name;
selected.DecidedDate = DBDateTime.Now;
selected.Status = QuestionFormStatus.New_Accepted;
selected.QuestionFormRef = questionFormID;
selected.IsActual = true;
//utolsó módosítás, és elfogadás dátuma
questionForm.LastModifiedDate = selected.SentDate;
questionForm.DecidedDate = selected.DecidedDate;
questionForm.LastModifiedByUser = selected.LastModifiedByUser;
questionForm.IsActual = true;
//Set mail:
string modifiedAnswers = "";
PendingQuestionFormDetailContainer origAnswers = base.SelectChildrenByDetailOfPendingQuestionForm(entity.ID);
TemplateDetailService templateDetailService = new TemplateDetailService(m_DataContext);
foreach (PendingQuestionFormDetail origDetail in origAnswers.All)
{
string hash = origDetail.HashString();
PendingQuestionFormDetail currentDetail = (PendingQuestionFormDetail) entity.Details[hash];
if (currentDetail != null)
{
if (!origDetail.Answer.Equals(currentDetail.Answer))
{
TemplateDetail question =
templateDetailService.TemplateDetailSelect(origDetail.TemplateDetailRef, origDetail.TemplateRef);
modifiedAnswers += "Kérdés: " + question.Question + "\n";
modifiedAnswers += " Eredeti válasz: " + origDetail.Answer + "\n";
modifiedAnswers += " Módosított válasz: " + currentDetail.Answer + "\n\n";
}
}
}
if (modifiedAnswers.Length == 0)
{
modifiedAnswers = " A jóváhagyó módosítás nélkül fogadta el a kitöltött kérdõívet.\n";
}
UserService userSrv = new UserService(m_DataContext);
User sentBy = userSrv.UserSelect(selected.SentBy);
Email mail = new Email(Guid.NewGuid());
mail.Category = EmailCategory.QuestionFormInsertAccept;
mail.To = sentBy.Email;
//Subject és body lekérdezése
string body = "";
string subject = "";
EmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, EmailCategory.QuestionFormInsertAccept);
mail.Subject = subject;
body = body.Replace("<FULL_USER_NAME>", sentBy.Name);
body = body.Replace("<SENT_DATE>", entity.SentDate.ToString());
body = body.Replace("<TEMPLATE_NAME>", entity.TemplateName);
body = body.Replace("<MODIFIED_ANSWERS>", modifiedAnswers);
mail.MailBody = body;
// Save data to database
EmailService emailSrv = new EmailService(m_DataContext);
QuestionFormService questionFormService = new QuestionFormService(m_DataContext);
ProgramQuestionFormService programQuestionFormService = new ProgramQuestionFormService(m_DataContext);
OrganisationQuestionFormService organisationQuestionFormService =
new OrganisationQuestionFormService(m_DataContext);
QuestionFormDetailService questionFormDetailService = new QuestionFormDetailService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
questionFormService.QuestionFormInsert(questionForm);
base.PendingQuestionFormUpdate(selected);
if (entity.ProgramCategoryId.Equals("ORG"))
{
OrganisationQuestionForm organisationQuestionForm =
new OrganisationQuestionForm("ORG", entity.OrganisationID, questionFormID);
//organisationQuestionForm.QuestionFormRef = questionFormID;
organisationQuestionFormService.OrganisationQuestionFormInsert(organisationQuestionForm);
}
else
{
ProgramQuestionForm programQuestionForm =
new ProgramQuestionForm(entity.ProgramCategoryId, entity.ProgramID, questionFormID);
//programQuestionForm.QuestionFormRef = questionFormID;
programQuestionFormService.ProgramQuestionFormInsert(programQuestionForm);
}
foreach (PendingQuestionFormDetail pendingDetail in entity.Details.All)
{
QuestionFormDetail detail =
new QuestionFormDetail(questionFormID, pendingDetail.TemplateDetailRef, entity.TemplateRef);
detail.Answer = pendingDetail.Answer;
detail.FreetextId = Guid.NewGuid();
questionFormDetailService.QuestionFormDetailInsert(detail);
}
emailSrv.EmailInsert(mail);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
// Sending mail:
try
{
emailSrv.EmailSend(mail.ID);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return false;
}
// Log success
BusinessAuditEvent.Success(
new EventParameter("PendingQuestionFormID", entity.ID.ToString()),
new EventParameter("ProgramID", entity.ProgramID.ToString()),
new EventParameter("OrganisationID", entity.OrganisationID.ToString())
);
TraceCallReturnEvent.Raise();
return true;
}
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()),
new EventParameter("OrganisationID", entity.OrganisationID.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}