public virtual void OrganisationUserDelete(OrganisationUser entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
m_DataContext.ndihdOrganisationUserDelete(entity.OrganisationRef,
entity.LoginNameRef);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
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;
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public OrganisationUser(OrganisationUser origInstance)
: base(origInstance)
{
}
/// ----------------------------------------------------------------------------------------
/// <summary>
/// A felhasználó-szervezet-jogosultság összerendeléseket törlése
/// </summary>
/// ----------------------------------------------------------------------------------------
private void DeleteOrganisationUser()
{
IOrganisationUserService srvOrgUser = ServiceFactory.GetOrganisationUserService();
Guid orgId = new Guid(dtgOrgUser.GetSelectedRowCell("uOrganisationRef").ToString());
string userRight = dtgOrgUser.GetSelectedRowCell("cRight").ToString();
OrganisationUser orgUser = new OrganisationUser(orgId, CurrentID);
orgUser.Right = userRight;
srvOrgUser.OrganisationUserDelete(orgUser);
//Lista frissitése
FillDataGrid(CurrentID, orgUser.OrganisationRef);
}
/// ----------------------------------------------------------------------------------------
/// <summary>
/// A felhasználó-szervezet-jogosultság összerendeléseket elmenti (Insert/Update)
/// </summary>
/// ----------------------------------------------------------------------------------------
private void SaveOrganisationUser()
{
IOrganisationUserService srvOrgUser = ServiceFactory.GetOrganisationUserService();
OrganisationUser orgUser = new OrganisationUser(new Guid(cmbOrganisation.SelectedValue.ToString()), CurrentID);
orgUser.Right = cmbRight.SelectedValue.ToString();
if (m_IsNewInsert == true)
{
//Insert
try
{
if (CheckOrganisationExist(orgUser.OrganisationRef) == false)
{
srvOrgUser.OrganisationUserInsert(orgUser);
}
else
{
MessageBox.Show("A szervezet már hozzá van rendelve a felhasználóhoz", "", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
}
}
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);
}
m_IsNewInsert = false;
cmbOrganisation.Enabled = false;
//Lista frissitése
FillDataGrid(CurrentID, orgUser.OrganisationRef);
}
else
{
//Update
srvOrgUser.OrganisationUserUpdate(orgUser);
//Lista frissitése
FillDataGrid(CurrentID, orgUser.OrganisationRef);
}
}
public virtual void OrganisationUserUpdate(OrganisationUser entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
int count;
m_DataContext.ndihdOrganisationUserUpdate(entity.OrganisationRef,
entity.LoginNameRef,
entity.Right, out count);
if (count == 0) throw new ServiceUpdateException();
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual OrganisationUser OrganisationUserSelect(DBGuid OrganisationRefVal,
DBString LoginNameRefVal)
{
TraceCallEnterEvent.Raise();
try
{
OrganisationUser result = null;
DataSet entitySet = m_DataContext.ndihdOrganisationUserSelect(OrganisationRefVal,
LoginNameRefVal);
if (entitySet.Tables[0].Rows.Count != 0)
{
result = new OrganisationUser(entitySet);
}
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public bool RegisterOrganisationToUserAccept(RegisterOrganisation entity)
{
//Check permission: Admin
PrincipalPermission permissionAdm =
new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permissionAdm.Demand();
TraceCallEnterEvent.Raise();
try
{
// Check required fields
// Organisation
if (entity.Name.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.Name", "A regisztrálandó szervezet neve nincs megadva.");
if (entity.RegionRef.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.RegionRef",
"A regisztrálandó szervezet megyéje nincs megadva.");
if (entity.WorkingAreaRef.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.WorkingAreaRef",
"A regisztrálandó szervezet mûködési területe nincs megadva.");
if (entity.OrganisationFormRef.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.OrganisationFormRef",
"A regisztrálandó szervezet szervezeti formája nincs megadva.");
if (entity.ReasonOfRegistration.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.ReasonOfRegistration",
"Az adatbázis használatának célja nincs megadva.");
if (entity.PostCode.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.PostCode",
"A szervezet címének irányítószáma nincs megadva.");
if (entity.City.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.City",
"A szervezet címének település része nincs megadva.");
if (entity.Address.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.Address",
"A szervezet címének utca, házszám része nincs megadva.");
// User
if (entity.LoginName.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.LoginName",
"A regisztrálandó felhasználó bejelentkezési neve nincs megadva.");
if (entity.UserName.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.UserName",
"A regisztrálandó felhasználó neve nincs megadva.");
if (entity.UserSex.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.UserSex",
"A regisztrálandó felhasználó neme nincs megadva.");
if (entity.UserBirthYear.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.UserBirthYear",
"A regisztrálandó felhasználó születési éve nincs megadva.");
if (entity.UserEmail.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.UserEmail",
"A regisztrálandó felhasználó e-mail címe nincs megadva.");
if (entity.QualificationRef.Length == 0)
throw new ArgumentNullException("RegisterOrganisation.QualificationRef",
"A regisztrálandó felhasználó legmagasabb iskolai végzettsége nincs megadva.");
// Logical checks
RegisterOrganisation selected = base.RegisterOrganisationSelect(entity.ID);
if (selected == null)
throw new ApplicationException("A megadott azonosítóval nem létezik regisztrálandó szervezet.");
if (! selected.Status.Equals(RegistrationStatus.New))
throw new ApplicationException("Csak új státuszú regisztráció bírálható el.");
// Set properties
entity.SentDate = selected.SentDate;
entity.DecidedBy = Thread.CurrentPrincipal.Identity.Name;
entity.DecidedDate = DBDateTime.Now;
entity.Status = RegistrationStatus.Accepted;
Organisation newOrg = new Organisation(entity.ID);
newOrg.Name = entity.Name;
newOrg.Department = entity.Department;
newOrg.PostCode = entity.PostCode;
newOrg.City = entity.City;
newOrg.Address = entity.Address;
newOrg.Country = entity.Country;
newOrg.Phone1 = entity.Phone1;
newOrg.Fax = entity.Fax;
newOrg.Email1 = entity.Email1;
newOrg.HomePage = entity.HomePage;
newOrg.RegionRef = entity.RegionRef;
newOrg.WorkingAreaRef = entity.WorkingAreaRef;
newOrg.WorkingAreaOther = entity.WorkingAreaOther;
newOrg.OrganisationFormRef = entity.OrganisationFormRef;
newOrg.ActivityPrevention = entity.ActivityPrevention;
newOrg.ActivityRehabilitation = entity.ActivityRehabilitation;
newOrg.ActivityResearch = entity.ActivityResearch;
newOrg.ActivityOther = entity.ActivityOther;
newOrg.SourceGovernment = 0;
newOrg.SourceCompetition = 0;
newOrg.SourceSponsor = 0;
newOrg.SourceDonation = 0;
newOrg.SourceTax = 0;
newOrg.SourceOther = 0;
newOrg.IsActive = true;
// defaults
newOrg.WorkersFix = 0;
newOrg.WorkersExternal = 0;
newOrg.WorkersVolunteer = 0;
newOrg.JobPsychologist = 0;
newOrg.JobPsychiater = 0;
newOrg.JobDoctor = 0;
newOrg.JobMedicalExpert = 0;
newOrg.JobHealthExpert = 0;
newOrg.JobSociologist = 0;
newOrg.JobSocialPolitician = 0;
newOrg.JobSocialWorker = 0;
newOrg.JobSocialPedagogist = 0;
newOrg.JobPedagogist = 0;
newOrg.JobManualist = 0;
newOrg.JobLawyer = 0;
newOrg.JobPoliceman = 0;
newOrg.JobMentalhygiene = 0;
newOrg.JobCultureOrganizer = 0;
newOrg.JobOther1 = 0;
newOrg.JobOther2 = 0;
newOrg.JobOther3 = 0;
newOrg.IsActual = true;
newOrg.LastModified = DateTime.Now;
//set mail:
Email mail = new Email(Guid.NewGuid());
mail.Category = EmailCategory.OrganisationRegistrationAccept;
mail.To = entity.UserEmail;
//Subject és body lekérdezése
string body = "";
string subject = "";
EmailTemplateService srvTemplate = new EmailTemplateService();
srvTemplate.GetEmailTemplateByCode(ref subject, ref body, EmailCategory.OrganisationRegistrationAccept);
mail.Subject = subject;
body = body.Replace("<FULL_USER_NAME>", entity.Name);
body = body.Replace("<LOGIN_NAME>", entity.LoginName);
body = body.Replace("<ORGANIZATION>", newOrg.Name);
mail.MailBody = body;
// Save data to database
EmailService emailSrv = new EmailService(m_DataContext);
m_DataContext.BeginNestedTran();
try
{
//elmentjük a szervezet adatait
OrganisationService orgSrv = new OrganisationService(m_DataContext);
orgSrv.OrganisationInsert(newOrg);
//eltároljuk a szervezet-felhasználó kapcsolatot
OrganisationUserService orgUserSrv = new OrganisationUserService(m_DataContext);
OrganisationUser orgUser = new OrganisationUser(newOrg.ID, entity.LoginName);
orgUser.Right = UserRights.Write;
orgUserSrv.OrganisationUserInsert(orgUser);
base.RegisterOrganisationUpdate(entity);
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("OrganisationID", newOrg.ID.ToString()),
new EventParameter("OrganisationName", entity.Name),
new EventParameter("LoginName", entity.LoginName)
);
TraceCallReturnEvent.Raise();
return true;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("RegisterOrganisationID", entity.ID.ToString()),
new EventParameter("OrganisationName", entity.Name),
new EventParameter("LoginName", entity.LoginName)
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
