/// <summary> /// Handles the Click event of the btnExportCsv control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnExportCsv_Click(object sender, EventArgs e) { try { #region lekérdezzük a OrganisationContainer -t (a szûrési feltételeknek megfelelõen) // Get query result from database Organisation filter = new Organisation(Guid.NewGuid()); filter.Name = txtName.Text; filter.RegionRef = cmbRegion.SelectedValue; filter.OrganisationFormRef = cmbOrganisationForm.SelectedValue; if (cbxPrevention.Checked) filter.ActivityPrevention = true; if (cbxResearch.Checked) filter.ActivityResearch = true; if (cbxRehabilitation.Checked) filter.ActivityRehabilitation = true; if (cbxOther.Checked) filter.ActivityOther = true; filter.FilterOnIsactive = 1; IOrganisationService orgSrv = ServiceFactory.GetOrganisationService(); OrganisationContainer selected = orgSrv.OrganisationSelectFiltered(filter); #endregion // Writes result to response string csv = selected.ExportToCsv(); Helpers.DownloadFile(csv, "szervezetek.csv"); } catch (Exception ex) { errorPanel.Exception = ex; } }
protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { //lekérdezzük a régió kódhoz tartozó nevet IOrganisationService srvOrg = ServiceFactory.GetOrganisationService(); Organisation filter = new Organisation(Guid.NewGuid()); filter.FilterOnIsactive = (DBInt) Convert.ToInt32(true); filter.IsActive = true; filter.IsKef = true; OrganisationDispsetContainer data = srvOrg.OrganisationSelectDispsetFiltered(filter); OrganisationDispsetContainer contUnion = data; ArrayList sortableList = null; // Sort if necessary if (sort == null) { sortableList = contUnion.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = contUnion.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = contUnion.All.SortBy(sort, false); } else { sortableList = data.All.SortBy(sort); } } if (contUnion.AllCount > 0) { // Bind list to datagrid control dataGrid.CurrentPageIndex = index; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = sortableList; dataGrid.DataBind(); dataGrid.Visible = true; dataGrid.Focus(); } else { dataGrid.Visible = false; } }
/// <summary> /// Noes the program validation. /// </summary> /// <param name="org">The org.</param> /// <returns></returns> public string NoProgramValidate(Organisation org) { string organisationState = org.ValidationState ?? ""; if (organisationState == OrganisationValidate.IsValid || organisationState == "") { organisationState = OrganisationValidate.NoProgram; } else { if (organisationState.IndexOf(OrganisationValidate.NoProgram) < 0) //még nem írtam be ezt a hibát organisationState += " " + OrganisationValidate.NoProgram; } return organisationState; }
public OrganisationContainer OrganisationSelectFiltered(Organisation filter) { TraceCallEnterEvent.Raise(); try { DBInt ActivityPrevention = DBInt.Null; if (filter.ActivityPrevention) ActivityPrevention = 1; DBInt ActivityResearch = DBInt.Null; if (filter.ActivityResearch) ActivityResearch = 1; DBInt ActivityRehabilitation = DBInt.Null; if (filter.ActivityRehabilitation) ActivityRehabilitation = 1; DBInt ActivityOther = DBInt.Null; if (filter.ActivityOther) ActivityOther = 1; DBInt ActivityCoord = DBInt.Null; if (filter.FilterOnIsKef != DBInt.Null) ActivityCoord = filter.FilterOnIsKef; OrganisationContainer result; DataSet entitySet = m_DataContext.ndihdOrganisationSelectFiltered( filter.Name, filter.RegionRef, filter.OrganisationFormRef, ActivityPrevention, ActivityResearch, ActivityRehabilitation, ActivityOther, filter.FilterOnIsactive, filter.FilterOnIsKef, filter.ValidationState); result = new OrganisationContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
public void OrganisationSetActive(Organisation entity) { // Check permission: Admin PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator"); permAdmin.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."); // Save data selected.IsActive = entity.IsActive; base.OrganisationUpdate(selected); BusinessAuditEvent.Success( new EventParameter("OrganisationID", entity.ID.ToString()), new EventParameter("OrganisationName", entity.Name) ); TraceCallReturnEvent.Raise(); return; } catch (Exception ex) { ExceptionManager.Publish(ex); BusinessAuditEvent.Fail( new EventParameter("Exception", ex.ToString()), new EventParameter("OrganisationID", entity.ID.ToString()), new EventParameter("OrganisationName", entity.Name) ); TraceCallReturnEvent.Raise(false); throw; } }
// ------------------------------------------------------------------------------------- /// <summary> /// Copy constructor. /// </summary> /// <param name="IDVal">Value of 'uID' field</param> /// <param name="origInstance">Original document data to copy.</param> // ------------------------------------------------------------------------------------- public Organisation(DBGuid IDVal, Organisation origInstance) : base(IDVal, origInstance) { }
// ------------------------------------------------------------------------------------- /// <summary> /// Copy constructor. /// </summary> /// <param name="origInstance">Original document data to copy.</param> // ------------------------------------------------------------------------------------- public Organisation(Organisation origInstance) : base(origInstance) { }
/// <summary> /// Organisations the base data validation priv. /// </summary> /// <param name="org">The org.</param> /// <param name="referenceDate">The reference date.</param> /// <param name="numDays">The num days.</param> /// <param name="service">if set to <c>true</c> [service].</param> /// <returns></returns> private string OrganisationBaseDataValidationPriv(Organisation org, DateTime referenceDate, int numDays, bool service) { string organisationState = org.ValidationState ?? ""; if (service) { // if (referenceDate < (DateTime) (org.LastModified?? DateTime.MinValue)) { if (organisationState == OrganisationValidate.IsValid || organisationState == "") organisationState = OrganisationValidate.NoBaseDatasRefresh; else { if (organisationState.IndexOf(OrganisationValidate.NoBaseDatasRefresh) < 0) //még nem írtam be ezt a hibát organisationState += " " + OrganisationValidate.NoBaseDatasRefresh; } } } else { if (referenceDate.AddDays(-numDays) > (DateTime)(org.LastModified ?? DateTime.MinValue)) { if (organisationState == OrganisationValidate.IsValid || organisationState == "") organisationState = OrganisationValidate.NoBaseDatasRefresh; else { if (organisationState.IndexOf(OrganisationValidate.NoBaseDatasRefresh) < 0) //még nem írtam be ezt a hibát organisationState += " " + OrganisationValidate.NoBaseDatasRefresh; } } } return organisationState; }
protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order, string regionCode) { dataGrid.PageSize = Helper.GetPageSize("PageSize.RegionSearch"); if (regionCode != null) { //lekérdezzük a régió kódhoz tartozó nevet IRegionSearchService srvRegSearch = ServiceFactory.GetRegionSearchService(); lblRegionName.Text = srvRegSearch.RegionSearchSelect(regionCode).RegionDescription; lblRegionName.Text = "(" + lblRegionName.Text + ")"; IOrganisationService srvOrg = ServiceFactory.GetOrganisationService(); Organisation filter = new Organisation(Guid.NewGuid()); filter.FilterOnIsactive = (DBInt) Convert.ToInt32(true); filter.IsActive = true; filter.RegionSearchCodeRef = regionCode; OrganisationDispsetContainer data = srvOrg.OrganisationSelectDispsetFiltered(filter); OrganisationDispsetContainer contUnion = data; ArrayList sortableList = null; // Sort if necessary if (sort == null) { sortableList = contUnion.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = contUnion.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = contUnion.All.SortBy(sort, false); } else { sortableList = data.All.SortBy(sort); } } if (contUnion.AllCount > 0) { // Bind list to datagrid control dataGrid.CurrentPageIndex = index; dataGrid.CurrentSortExpression = sort; dataGrid.CurrentSortOrder = order; dataGrid.DataSource = sortableList; dataGrid.DataBind(); dataGrid.Visible = true; dataGrid.Focus(); lblPleaseSelect.Visible = false; } else { dataGrid.Visible = false; lblNotFound.Visible = true; lblPleaseSelect.Visible = false; } } else lblPleaseSelect.Visible = true; }
public void OrganisationUpdateBase(Organisation entity) { // check permission: Writer or Admin string writerRole = entity.ID.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(); TraceCallEnterEvent.Raise(); try { // check required fields: if (entity.Name.Length == 0) throw new ArgumentNullException("Organisation.Name", "A szervezet neve nincs megadva."); if (entity.PostCode.Length == 0) throw new ArgumentNullException("Organisation.PostCode", "A szervezet címének irányítószáma nincs megadva."); if (entity.City.Length == 0) throw new ArgumentNullException("Organisation.City", "A szervezet címének települése nincs megadva."); if (entity.Address.Length == 0) throw new ArgumentNullException("Organisation.Address", "A szervezet címének utca, házszám része nincs megadva."); if (entity.OrganisationFormRef.Length == 0) throw new ArgumentNullException("Organisation.OrganisationFormRef", "A szervezeti forma kódja nincs megadva."); if (entity.WorkingAreaRef.Length == 0) throw new ArgumentNullException("Organisation.WorkingAreaRef", "A mûködési terület nincs megadva."); // logical checks: Organisation selected = base.OrganisationSelect(entity.ID); if (selected == null) throw new ApplicationException("Ezzel az azonosítóval nem létezik szervezet."); NdiPrincipal principal = (NdiPrincipal) Thread.CurrentPrincipal; if (!selected.IsActive && !principal.IsInRole("Administrator")) throw new ApplicationException("A szervezet nem aktív."); // save data: entity.IsActive = selected.IsActive; entity.LastValidationDate = selected.LastValidationDate; entity.ValidationState = selected.ValidationState; //entity.LastModified = DateTime.Now; //Ezt azért vettem ki, hogyha az admin módosít, akkor ne tűnjön módosításnak try { m_DataContext.BeginNestedTran(); //elmentjük a szervezet módosított adatokat base.OrganisationUpdate(entity); m_DataContext.CommitNested(); } catch { m_DataContext.RollbackNested(); throw; } BusinessAuditEvent.Success( new EventParameter("OrganisationID", entity.ID.ToString()), new EventParameter("OrganisationName", entity.Name) ); TraceCallReturnEvent.Raise(); return; } catch (Exception ex) { ExceptionManager.Publish(ex); BusinessAuditEvent.Fail( new EventParameter("Exception", ex.ToString()), new EventParameter("OrganisationID", entity.ID.ToString()), new EventParameter("OrganisationName", entity.Name) ); TraceCallReturnEvent.Raise(false); throw; } }
// ------------------------------------------------------------------------------------- /// <summary> /// Fill edit window controls /// </summary> // ------------------------------------------------------------------------------------- private void RetrieveData() { try { // Get data IOrganisationService srv = ServiceFactory.GetOrganisationService(); IOrganisationAttachmentService srvOrgAtt = ServiceFactory.GetOrganisationAttachmentService(); Organisation org = srv.OrganisationSelect(CurrentID); // Fill the controls // First page txtOrganisationName.Text = org.Name; txtDepartment.Text = org.Department; txtPostCode.Text = org.PostCode; txtCity.Text = org.City; txtOrgAddress.Text = org.Address; txtCountry.Text = org.Country; cmbRegion.SelectedValue = org.RegionRef.ToString(); txtMailingPostCode.Text = org.MailingPostCode; txtMailingCity.Text = org.MailingCity; txtMailingAddress.Text = org.MailingAddress; txtPhone1.Text = org.Phone1; txtPhone2.Text = org.Phone2; txtPhone3.Text = org.Phone3; txtPhonediscounted.Text = org.PhoneDiscounted; txtFax.Text = org.Fax; txtHomePage.Text = org.HomePage; txtEmail1.Text = org.Email1; txtEmail2.Text = org.Email2; txtEmail3.Text = org.Email3; txtContactName.Text = org.ContactName; txtContactPhone.Text = org.ContactPhone; txtContactEmail.Text = org.ContactEmail; txtDescription.Text = org.Description; txtCallingHours.Text = org.CallingHours; cmbOrganisationForm.SelectedValue = org.OrganisationFormRef.ToString(); txtEstablishmentYear.Text = org.EstablishmentYear; cbxOrgActPrevention.Checked = org.ActivityPrevention; cbxOrgActRehabilitation.Checked = org.ActivityRehabilitation; cbxOrgActResearch.Checked = org.ActivityResearch; cbxOrgActOther.Checked = org.ActivityOther; cmbOrgWorkingArea.SelectedValue = org.WorkingAreaRef.ToString(); txtOrgWorkingAreaOther.Text = org.WorkingAreaOther; cbxActivate.Checked = org.IsActive; // Second page txtSourceGovernment.Text = org.SourceGovernment.ToString(); txtSourceCompetition.Text = org.SourceCompetition.ToString(); txtSourceSponsor.Text = org.SourceSponsor.ToString(); txtSourceDonation.Text = org.SourceDonation.ToString(); txtSourceTax.Text = org.SourceTax.ToString(); txtSourceOther.Text = org.SourceOther.ToString(); txtSourceOtherName.Text = org.SourceOtherName; txtWorkersFix.Text = org.WorkersFix.ToString(); txtWorkersExternal.Text = org.WorkersExternal.ToString(); txtWorkersVolunteer.Text = org.WorkersVolunteer.ToString(); txtJobPsychologist.Text = org.JobPsychologist.ToString(); txtJobPsychiater.Text = org.JobPsychiater.ToString(); txtJobDoctor.Text = org.JobDoctor.ToString(); txtJobMedicalExpert.Text = org.JobMedicalExpert.ToString(); txtJobHealthExpert.Text = org.JobHealthExpert.ToString(); txtJobSociologist.Text = org.JobSociologist.ToString(); txtJobSocialPolitician.Text = org.JobSocialPolitician.ToString(); txtJobSocialWorker.Text = org.JobSocialWorker.ToString(); txtJobSocialPedagogist.Text = org.JobSocialPedagogist.ToString(); txtJobPedagogist.Text = org.JobPedagogist.ToString(); txtJobManualist.Text = org.JobManualist.ToString(); txtJobLawyer.Text = org.JobLawyer.ToString(); txtJobPoliceman.Text = org.JobPoliceman.ToString(); txtJobMentalhygiene.Text = org.JobMentalhygiene.ToString(); txtJobCultureOrganizer.Text = org.JobCultureOrganizer.ToString(); txtJobOther1.Text = org.JobOther1.ToString(); txtJobOther2.Text = org.JobOther2.ToString(); txtJobOther3.Text = org.JobOther3.ToString(); txtJobOtherName1.Text = org.JobOtherName1; txtJobOtherName2.Text = org.JobOtherName2; txtJobOtherName3.Text = org.JobOtherName3; // Save original value bIsActive = org.IsActive; cbxActual.Checked = org.IsActual; #region Egyéb dokumentumok m_CurrentOrganisation = srv.OrganisationSelect(org.ID); m_CurrentOrganisation.OrgAttachments = srvOrgAtt.OrganisationAttachmentSelectFiltered(org.ID, false, false, true); foreach (OrganisationAttachment file in m_CurrentOrganisation.OrgAttachments.All) { OrganisationAttachment fileData = srvOrgAtt.OrganisationAttachmentSelectFile(file.ID); file.DownloadData = fileData.DownloadData; } FillKefFilesDatagrid(DBGuid.Null); #endregion } catch (Exception ex) { // --- Log exception ExceptionManager.Publish(ex); // --- Display Exception ErrorHandler.DisplayError("Hiba lépett fel az adatok lekérdezése során", ex); // --- invisible btnOk button btnOk.Visible = false; } }
public virtual void OrganisationUpdate(Organisation entity) { TraceCallEnterEvent.Raise(); try { m_DataContext.BeginNestedTran(); try { int count; m_DataContext.ndihdOrganisationUpdate(entity.ID, entity.Name, entity.Department, entity.PostCode, entity.City, entity.Address, entity.RegionRef, entity.Country, entity.MailingPostCode, entity.MailingCity, entity.MailingAddress, entity.Phone1, entity.Phone2, entity.Phone3, entity.PhoneDiscounted, entity.Fax, entity.Email1, entity.Email2, entity.Email3, entity.HomePage, entity.ContactName, entity.ContactPhone, entity.ContactEmail, entity.Description, entity.CallingHours, entity.OrganisationFormRef, entity.SourceGovernment, entity.SourceCompetition, entity.SourceSponsor, entity.SourceDonation, entity.SourceTax, entity.SourceOther, entity.SourceOtherName, entity.EstablishmentYear, entity.ActivityPrevention, entity.ActivityResearch, entity.ActivityRehabilitation, entity.ActivityOther, entity.WorkingAreaRef, entity.WorkingAreaOther, entity.WorkersFix, entity.WorkersExternal, entity.WorkersVolunteer, entity.IsActive, entity.JobPsychologist, entity.JobPsychiater, entity.JobDoctor, entity.JobMedicalExpert, entity.JobHealthExpert, entity.JobSociologist, entity.JobSocialPolitician, entity.JobSocialWorker, entity.JobSocialPedagogist, entity.JobPedagogist, entity.JobManualist, entity.JobLawyer, entity.JobPoliceman, entity.JobMentalhygiene, entity.JobCultureOrganizer, entity.JobOther1, entity.JobOther2, entity.JobOther3, entity.JobOtherName1, entity.JobOtherName2, entity.JobOtherName3, entity.IsKef, entity.RegionSearchCodeRef, entity.DistrictSearchCodeRef, entity.IntroduceText, entity.DrogStrategyDescription, entity.AreaDescription, entity.EstablishmentMonth, entity.AreaHomePage, entity.LastModified, entity.IntroduceTextLastModified, entity.AreaDescriptionLastModified, entity.DrogStrategyLastModified, entity.KefMembersLastModified, entity.KefDownloadsLastModified, entity.KefEventsLastModified, entity.ValidationState, entity.LastValidationDate, entity.IsActual, 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; } }
protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order, string selectedRegion) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.OrganisationList"); // Get query result from database Organisation filter = new Organisation(Guid.NewGuid()); filter.RegionRef = selectedRegion; filter.FilterOnIsactive = 1; IOrganisationService orgSrv = ServiceFactory.GetOrganisationService(); OrganisationDispsetContainer orgSelected = orgSrv.OrganisationSelectDispsetFiltered(filter); if (orgSelected.AllCount > 0) { dataGrid.Visible = true; lblNotFound.Visible = false; } else { dataGrid.Visible = false; lblNotFound.Visible = true; } ArrayList sortableList = null; // Sort if necessary if (sort == null) { sortableList = orgSelected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = orgSelected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = orgSelected.All.SortBy(sort, false); } else { sortableList = orgSelected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (orgSelected.AllCount <= dataGrid.PageSize * dataGrid.CurrentPageIndex) { dataGrid.CurrentPageIndex = 0; } else { dataGrid.CurrentPageIndex = index; } //dataGrid.CurrentSortExpression = sort; //dataGrid.CurrentSortOrder = order; if (sort != null) { dataGrid.CurrentSortExpression = sort; } if (order != null) { dataGrid.CurrentSortOrder = order; } dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
public virtual Organisation OrganisationSelect(DBGuid IDVal) { TraceCallEnterEvent.Raise(); try { Organisation result = null; DataSet entitySet = m_DataContext.ndihdOrganisationSelect(IDVal); if (entitySet.Tables[0].Rows.Count != 0) { result = new Organisation(entitySet); } TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
public virtual void OrganisationDelete(Organisation entity) { TraceCallEnterEvent.Raise(); try { m_DataContext.BeginNestedTran(); try { m_DataContext.ndihdOrganisationDelete(entity.ID); m_DataContext.CommitNested(); } catch { m_DataContext.RollbackNested(); throw; } TraceCallReturnEvent.Raise(); return; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
protected void btnModify_Click(object sender, EventArgs e) { try { if (!Page.IsValid) { return; } IOrganisationService orgSrv = ServiceFactory.GetOrganisationService(); NdiPrincipal principal = (NdiPrincipal) Context.User; Organisation origOrg = orgSrv.OrganisationSelect(principal.OrganisationID); Organisation org = new Organisation(principal.OrganisationID); org.SourceTax = Convert.ToInt32(txtSourceTax.Text); org.Name = txtOrgName.Text; org.Department = txtDepartment.Text; org.PostCode = txtPostCode.Text; org.City = txtCity.Text; org.Address = txtAddress.Text; if (rbtHungary.Checked) { if (cmbRegion.SelectedValue.Length == 0) { throw new ArgumentNullException("Organisation.Region", "A megye nincs megadva."); } org.RegionRef = cmbRegion.SelectedValue; } if (rbtAbroad.Checked) { org.Country = txtCountry.Text; } org.MailingPostCode = txtMailingPostCode.Text; org.MailingCity = txtMailingCity.Text; org.MailingAddress = txtMailingAddress.Text; org.Phone1 = txtPhone1.Text; org.Phone2 = txtPhone2.Text; org.Phone3 = txtPhone3.Text; org.PhoneDiscounted = txtPhoneDiscounted.Text; org.Fax = txtFax.Text; org.Email1 = txtEmail1.Text; org.Email2 = txtEmail2.Text; org.Email3 = txtEmail3.Text; org.HomePage = txtHomePage.Text; org.ContactName = txtContactName.Text; org.ContactPhone = txtContactPhone.Text; org.ContactEmail = txtContactEmail.Text; org.Description = txtDescription.Text; org.CallingHours = txtCallingHours.Text; org.OrganisationFormRef = cmbOrganisationForm.SelectedValue; org.SourceGovernment = Convert.ToDouble(txtSourceGovernment.Text); org.SourceCompetition = Convert.ToDouble(txtSourceCompetition.Text); org.SourceSponsor = Convert.ToDouble(txtSourceSponsor.Text); org.SourceDonation = Convert.ToDouble(txtSourceDonation.Text); org.SourceTax = Convert.ToDouble(txtSourceTax.Text); org.SourceOther = Convert.ToDouble(txtSourceOther.Text); org.SourceOtherName = txtSourceOtherName.Text; org.EstablishmentYear = txtEstablishmentYear.Text; org.ActivityPrevention = cbxPrevention.Checked; org.ActivityResearch = cbxResearch.Checked; org.ActivityRehabilitation = cbxRehabilitation.Checked; org.ActivityOther = cbxOther.Checked; org.WorkingAreaRef = cmbWorkingArea.SelectedValue; org.WorkingAreaOther = txtWorkingAreaOther.Text; org.WorkersFix = Convert.ToInt32(txtWorkersFix.Text); org.WorkersExternal = Convert.ToInt32(txtWorkersExternal.Text); org.WorkersVolunteer = Convert.ToInt32(txtWorkersVolunteer.Text); org.JobPsychologist = Convert.ToInt32(txtJobPsychologist.Text); org.JobPsychiater = Convert.ToInt32(txtJobPsychiater.Text); org.JobDoctor = Convert.ToInt32(txtJobDoctor.Text); org.JobMedicalExpert = Convert.ToInt32(txtJobMedicalExpert.Text); org.JobHealthExpert = Convert.ToInt32(txtJobHealthExpert.Text); org.JobSociologist = Convert.ToInt32(txtJobSociologist.Text); org.JobSocialPolitician = Convert.ToInt32(txtJobSocialPolitician.Text); org.JobSocialWorker = Convert.ToInt32(txtJobSocialWorker.Text); org.JobSocialPedagogist = Convert.ToInt32(txtJobSocialPedagogist.Text); org.JobPedagogist = Convert.ToInt32(txtJobPedagogist.Text); org.JobManualist = Convert.ToInt32(txtJobManualist.Text); org.JobLawyer = Convert.ToInt32(txtJobLawyer.Text); org.JobPoliceman = Convert.ToInt32(txtJobPoliceman.Text); org.JobMentalhygiene = Convert.ToInt32(txtJobMentalhygiene.Text); org.JobCultureOrganizer = Convert.ToInt32(txtJobCultureOrganizer.Text); org.JobOther1 = Convert.ToInt32(txtJobOther1.Text); org.JobOther2 = Convert.ToInt32(txtJobOther2.Text); org.JobOther3 = Convert.ToInt32(txtJobOther3.Text); org.JobOtherName1 = txtJobOtherName1.Text; org.JobOtherName2 = txtJobOtherName2.Text; org.JobOtherName3 = txtJobOtherName3.Text; org.LastModified = DateTime.Now; if (origOrg != null && origOrg.IsActual && !chkIsActual.Checked) //konrétan annyit módosított, hogy direkt kikapcsolta org.IsActual = false; else org.IsActual = true ; //Amikor módosít, akkor úgy véli, hogy naprakészchkIsActual.Checked; orgSrv.OrganisationUpdateBase(org); Response.Redirect("OrganisationData.aspx?orgID=" + principal.OrganisationID.ToString()); } catch (Exception ex) { errorPanel.Exception = ex; } }
public new void OrganisationUpdate(Organisation entity) { // check permission: Writer or Admin string writerRole = entity.ID.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(); TraceCallEnterEvent.Raise(); try { // check required fields: if (entity.Name.Length == 0) throw new ArgumentNullException("Organisation.Name", "A szervezet neve nincs megadva."); if (entity.PostCode.Length == 0) throw new ArgumentNullException("Organisation.PostCode", "A szervezet címének irányítószáma nincs megadva."); if (entity.City.Length == 0) throw new ArgumentNullException("Organisation.City", "A szervezet címének települése nincs megadva."); if (entity.Address.Length == 0) throw new ArgumentNullException("Organisation.Address", "A szervezet címének utca, házszám része nincs megadva."); //if(entity.MailingPostCode.Length == 0) throw new ArgumentNullException("Organisation.MailingPostCode", "A szervezet levelezési címének irányítószáma nincs megadva."); //if(entity.MailingCity.Length == 0) throw new ArgumentNullException("Organisation.MailingCity", "A szervezet levelezési címének települése nincs megadva."); //if(entity.MailingAddress.Length == 0) throw new ArgumentNullException("Organisation.MailingAddress", "A szervezet levelezési címének utca, házszám része nincs megadva."); if (entity.OrganisationFormRef.Length == 0) throw new ArgumentNullException("Organisation.OrganisationFormRef", "A szervezeti forma kódja nincs megadva."); //if(entity.EstablishmentYear.Length == 0) throw new ArgumentNullException("Organisation.EstablishmentYear", "A szervezet alapításának éve nincs megadva."); if (entity.WorkingAreaRef.Length == 0) throw new ArgumentNullException("Organisation.WorkingAreaRef", "A mûködési terület nincs megadva."); // logical checks: Organisation selected = base.OrganisationSelect(entity.ID); if (selected == null) throw new ApplicationException("Ezzel az azonosítóval nem létezik szervezet."); NdiPrincipal principal = (NdiPrincipal) Thread.CurrentPrincipal; if (!selected.IsActive && !principal.IsInRole("Administrator")) throw new ApplicationException("A szervezet nem aktív."); // save data: entity.IsActive = selected.IsActive; //entity.LastModified = DateTime.Now; ide csak az user módosítás lesz beírva, és ezt nem hívja az user try { m_DataContext.BeginNestedTran(); //elmentjük a szervezet módosított adatokat base.OrganisationUpdate(entity); //elmentjük a szervezethez tartozó feltöltött fileokat OrganisationAttachmentService srvOrgAtt = new OrganisationAttachmentService(m_DataContext); // Clear old files: OrganisationAttachmentContainer oldFiles = base.SelectChildrenByAttachmentOfOrganisation(entity.ID); foreach (OrganisationAttachment oldFile in oldFiles.All) { srvOrgAtt.OrganisationAttachmentDelete(oldFile); } foreach (OrganisationAttachment file in entity.OrgAttachments.Current) { srvOrgAtt.OrganisationAttachmentInsert(file); } m_DataContext.CommitNested(); } catch { m_DataContext.RollbackNested(); throw; } BusinessAuditEvent.Success( new EventParameter("OrganisationID", entity.ID.ToString()), new EventParameter("OrganisationName", entity.Name) ); TraceCallReturnEvent.Raise(); return; } catch (Exception ex) { ExceptionManager.Publish(ex); BusinessAuditEvent.Fail( new EventParameter("Exception", ex.ToString()), new EventParameter("OrganisationID", entity.ID.ToString()), new EventParameter("OrganisationName", entity.Name) ); TraceCallReturnEvent.Raise(false); throw; } }
/// <summary> /// Organisations the base data validate. /// </summary> /// <param name="org">The org.</param> /// <param name="numDays">The num days.</param> /// <param name="referenceDate"></param> /// <returns></returns> public string OrganisationBaseDataValidate(Organisation org, int numDays, DateTime referenceDate) { return OrganisationBaseDataValidationPriv(org, referenceDate, numDays, false); }
private void SetOrganisationCombo() { IOrganisationService srv = ServiceFactory.GetOrganisationService(); Organisation filter = new Organisation(Guid.NewGuid()); filter.FilterOnIsactive = 1; OrganisationDispsetContainer data = srv.OrganisationSelectDispsetFiltered(filter); ArrayList sortableList = data.All.SortBy("Name"); cmbOrganisation.DataSource = sortableList; cmbOrganisation.DataValueField = "ID"; cmbOrganisation.DataTextField = "Name"; cmbOrganisation.DataBind(); ListItem li = new ListItem("-- Összes --", ""); cmbOrganisation.Items.Insert(0, li); }
//kész // ------------------------------------------------------------------------------------- /// <summary> /// Loads combos /// </summary> // ------------------------------------------------------------------------------------- private void LoadCombos() { try { //Load Organisations // First set filter Organisation filter = new Organisation(Guid.Empty); filter.FilterOnIsactive = 1; filter.IsActive = false; filter.IsKef = false; filter.IsKef = true; IOrganisationService srvOrg = ServiceFactory.GetOrganisationService(); OrganisationDispsetContainer contOrg = srvOrg.OrganisationSelectDispsetFiltered(filter); DataTable dtKefMembers = contOrg.AllAsDatatable; CreateSimpleCombo(dtKefMembers, cmbKefMembers); //cmbKefMembers.LoadListItem(dtKefMembers,"ID","Name",false); #region Lehet e egyszerre több is ebbõl a tagból? FillContactTypeCombo(); #endregion } catch (Exception ex) { // --- Log exception ExceptionManager.Publish(ex); // --- Display Exception ErrorHandler.DisplayError("Hiba lépett fel a lista adatok feltöltése során", ex); // --- invisible btnOk button btnOk.Visible = false; } }
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; } }
/// <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; }
/// <summary> /// Programs the question from validate for service. /// </summary> /// <param name="org">The org.</param> /// <param name="prog">The prog.</param> /// <param name="refreshNum">The refresh num.</param> /// <param name="referenceDate">The reference date.</param> /// <returns></returns> public string ProgramQuestionFromValidateForService(Organisation org, Program prog, int refreshNum, DateTime referenceDate) { return ProgramQuestionFormValidatePriv(org, prog, referenceDate, refreshNum, true); }
public void OrganisationKefUpdate(Organisation org, KefEventContainer kefEvents, DataTable kefMembers) { // check permission: Writer or Admin string writerRole = org.ID.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(); TraceCallEnterEvent.Raise(); try { // check required fields: if (org.Name.Length == 0) throw new ArgumentNullException("Organisation.Name", "A szervezet neve nincs megadva."); if (org.PostCode.Length == 0) throw new ArgumentNullException("Organisation.PostCode", "A szervezet címének irányítószáma nincs megadva."); if (org.City.Length == 0) throw new ArgumentNullException("Organisation.City", "A szervezet címének települése nincs megadva."); if (org.Address.Length == 0) throw new ArgumentNullException("Organisation.Address", "A szervezet címének utca, házszám része nincs megadva."); if (org.OrganisationFormRef.Length == 0) throw new ArgumentNullException("Organisation.OrganisationFormRef", "A szervezeti forma kódja nincs megadva."); if (org.WorkingAreaRef.Length == 0) throw new ArgumentNullException("Organisation.WorkingAreaRef", "A mûködési terület nincs megadva."); // logical checks: Organisation selected = base.OrganisationSelect(org.ID); if (selected == null) throw new ApplicationException("Ezzel az azonosítóval nem létezik szervezet."); NdiPrincipal principal = (NdiPrincipal) Thread.CurrentPrincipal; if (!selected.IsActive && !principal.IsInRole("Administrator")) throw new ApplicationException("A szervezet nem aktív."); // save data: org.IsActive = selected.IsActive; try { //elmentjük a szervezet módosított adatokat base.OrganisationUpdate(org); m_DataContext.BeginNestedTran(); //töröljük az összes kapcsolódó eseményt ... OrganisationService srvOrg = new OrganisationService(m_DataContext); KefEventService srvKefEvent = new KefEventService(m_DataContext); srvOrg.DeleteChildrenByOrganisationOfKefEvent(org.ID); //majd beszúrjuk az újakat foreach (KefEvent item in kefEvents.Current) { srvKefEvent.KefEventInsert(item); } //töröljük az összes kapcsolódó tagot ... srvOrg.DeleteChildrenByKefOrgOfOrg(org.ID); OrgMemberOfOrgService srvKefMember = new OrgMemberOfOrgService(m_DataContext); //majd beszúrjuk az újakat foreach (DataRow row in kefMembers.Rows) { OrgMemberOfOrg member = new OrgMemberOfOrg(Guid.NewGuid()); member.OrganisationKefRef = new Guid(row["uOrganisationKefRef"].ToString()); member.OrganisationMemberRef = new Guid(row["uOrganisationMemberRef"].ToString()); member.ContactName = row["cContactName"].ToString(); member.ContactInstitution = row["cContactInstitution"].ToString(); member.ContactZipCode = row["cContactZipCode"].ToString(); member.ContactTownShip = row["cContactTownShip"].ToString(); member.ContactAddress = row["cContactAddress"].ToString(); member.ContactPhone1 = row["cContactPhone1"].ToString(); member.ContactPhone2 = row["cContactPhone2"].ToString(); member.ContactPhone3 = row["cContactPhone3"].ToString(); member.ContactFax = row["cContactFax"].ToString(); member.ContactPosition = row["cContactPosition"].ToString(); member.ContactPositionInKef = row["cContactPositionInKef"].ToString(); member.ContactEmail1 = row["cContactEmail1"].ToString(); member.ContactEmail2 = row["cContactEmail2"].ToString(); member.ContactEmail3 = row["cContactEmail3"].ToString(); member.ContactQualification = row["cContactQualification"].ToString(); member.KefContactTypeRef = row["cKefContactTypeRef"].ToString(); srvKefMember.OrgMemberOfOrgInsert(member); } //elmentjük a szervezethez tartozó feltöltött fileokat OrganisationAttachmentService srvOrgAtt = new OrganisationAttachmentService(m_DataContext); // Clear old files: OrganisationAttachmentContainer oldFiles = base.SelectChildrenByAttachmentOfOrganisation(org.ID); foreach (OrganisationAttachment oldFile in oldFiles.All) { srvOrgAtt.OrganisationAttachmentDelete(oldFile); } foreach (OrganisationAttachment file in org.OrgAttachments.Current) { if(file.DownloadData != null) srvOrgAtt.OrganisationAttachmentInsert(file); } m_DataContext.CommitNested(); } catch { m_DataContext.RollbackNested(); throw; } BusinessAuditEvent.Success( new EventParameter("OrganisationID", org.ID.ToString()), new EventParameter("OrganisationName", org.Name) ); TraceCallReturnEvent.Raise(); return; } catch (Exception ex) { ExceptionManager.Publish(ex); BusinessAuditEvent.Fail( new EventParameter("Exception", ex.ToString()), new EventParameter("OrganisationID", org.ID.ToString()), new EventParameter("OrganisationName", org.Name) ); TraceCallReturnEvent.Raise(false); throw; } }
/// <summary> /// Fill datagrid with data /// </summary> private void FillDatagridOrg(DBGuid OrganisationID) { try { string sSortColumn = "Name"; int nSelectedRow = -1; // Storing the previous sort order if (dtgOrg.DataSource != null) { sSortColumn = ((DataTable) dtgOrg.DataSource).DefaultView.Sort; } if (m_allDataOrg == null) { // Retrieving Organisations // Set filter Organisation filter = new Organisation(Guid.Empty); filter.FilterOnIsactive = DBInt.Null; filter.FilterOnIsactive = 1; filter.IsActive = true; // Retrieving data from BusinessServices IOrganisationService srv = ServiceFactory.GetOrganisationService(); m_allDataOrg = srv.OrganisationSelectFiltered(filter); // Retrieving ProgramPartners DBGuid ProgramID = new DBGuid(new Guid(m_sCurrentID)); IProgramService srvP = ServiceFactory.GetProgramService(); ProgramPartnerContainer allDataP = srvP.SelectChildrenByPartnerProgram(ProgramID); // Hide selected Organisation items for (int i = 0; i < allDataP.All.Count; i++) { DBGuid OrganisationRef = ((ProgramPartner) allDataP.All.Items[i]).OrganisationRef; Organisation selected = (Organisation) m_allDataOrg[OrganisationRef.ToString()]; if (selected != null) { m_allDataOrg.Delete(selected); } } } // Fill organisation grid DataTable dt = m_allDataOrg.CurrentAsDatatable; dt.DefaultView.Sort = sSortColumn; dtgOrg.DataSource = dt; // Fill organisation "detail" grid DataTable dtDetail = m_allDataOrg.DeletedAsDatatable; dtDetail.DefaultView.Sort = sSortColumn; dtgOrgDetail.DataSource = dtDetail; // Locates the row specified by ID param if (!OrganisationID.IsNull) { BindingManagerBase bm = dtgOrg.BindingContext[dtgOrg.DataSource, dtgOrg.DataMember]; int nPositionStart = bm.Position; DataRow dr; for (int i = 0; i < bm.Count; i++) { dr = ((DataRowView) bm.Current).Row; if (OrganisationID.Value.Equals(dr["ID"])) { nSelectedRow = i; break; } bm.Position += 1; } bm.Position = nPositionStart; } // Makes the row selected if (nSelectedRow <= ((DataTable) dtgOrg.DataSource).DefaultView.Count && nSelectedRow > -1) { dtgOrg.Select(nSelectedRow); dtgOrg.CurrentRowIndex = nSelectedRow; } else if (((DataTable) dtgOrg.DataSource).DefaultView.Count != 0) { dtgOrg.Select(0); } // Enabling or disabling the buttons according to record count. // And is because of previous disable state. bool bIsEmptyGrid = (((DataTable) dtgOrg.DataSource).DefaultView.Count == 0); btnAddOrganisation.Enabled = ! bIsEmptyGrid; btnDetailOrganisation.Enabled = ! bIsEmptyGrid; bIsEmptyGrid = (((DataTable) dtgOrgDetail.DataSource).DefaultView.Count == 0); btnRemoveOrganisation.Enabled = ! bIsEmptyGrid; } catch (Exception ex) { // --- Log exception ExceptionManager.Publish(ex); // --- Display Exception ErrorHandler.DisplayError("Nem várt hiba lépett fel a szervezet lista frissítése során.", ex); } }
/// <summary> /// Organisations the question from validate. /// </summary> /// <param name="org">The org.</param> /// <param name="refreshNum">The refresh num.</param> /// <param name="referenceDate"></param> /// <returns></returns> public string OrganisationQuestionFromValidate(Organisation org, int refreshNum, DateTime referenceDate) { return OrganisationQuestionFormValidatePriv(org, referenceDate, refreshNum, false); }
/// <summary> /// Shows the grid. /// </summary> /// <param name="dataGrid">The data grid.</param> /// <param name="index">The index.</param> /// <param name="sort">The sort.</param> /// <param name="order">The order.</param> protected void ShowGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.OrganisationList"); // Get query result from database Organisation filter = new Organisation(Guid.NewGuid()); filter.Name = Helpers.CreateLikeSearchText(txtName.Text); filter.RegionRef = cmbRegion.SelectedValue; filter.OrganisationFormRef = cmbOrganisationForm.SelectedValue; if (cbxPrevention.Checked) filter.ActivityPrevention = true; if (cbxResearch.Checked) filter.ActivityResearch = true; if (cbxRehabilitation.Checked) filter.ActivityRehabilitation = true; if (cbxOther.Checked) filter.ActivityOther = true; filter.FilterOnIsactive = 1; IOrganisationService orgSrv = ServiceFactory.GetOrganisationService(); OrganisationDispsetContainer orgSelected = orgSrv.OrganisationSelectDispsetFiltered(filter); if (orgSelected.AllCount > 0) { gridOrganisation.Visible = true; lblNotFound.Visible = false; } else { gridOrganisation.Visible = false; lblNotFound.Visible = true; } ArrayList sortableList = null; // Sort if necessary if (sort == null) { sortableList = orgSelected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = orgSelected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = orgSelected.All.SortBy(sort, false); } else { sortableList = orgSelected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (orgSelected.AllCount <= dataGrid.PageSize*dataGrid.CurrentPageIndex) { dataGrid.CurrentPageIndex = 0; } else { dataGrid.CurrentPageIndex = index; } //dataGrid.CurrentSortExpression = sort; //dataGrid.CurrentSortOrder = order; if (sort != null) { dataGrid.CurrentSortExpression = sort; } if (order != null) { dataGrid.CurrentSortOrder = order; } dataGrid.DataSource = sortableList; dataGrid.DataBind(); }
public OrganisationDispsetContainer OrganisationSelectDispsetOwnOrganisation() { TraceCallEnterEvent.Raise(); Organisation filter = new Organisation(Guid.Empty); try { DBInt ActivityPrevention = DBInt.Null; if (filter.ActivityPrevention) ActivityPrevention = 1; DBInt ActivityResearch = DBInt.Null; if (filter.ActivityResearch) ActivityResearch = 1; DBInt ActivityRehabilitation = DBInt.Null; if (filter.ActivityRehabilitation) ActivityRehabilitation = 1; DBInt ActivityOther = DBInt.Null; if (filter.ActivityOther) ActivityOther = 1; DBInt IsKef = 0; OrganisationDispsetContainer result; DataSet entitySet = m_DataContext.ndihdOrganisationSelectDispsetFiltered( filter.Name, filter.RegionRef, filter.OrganisationFormRef, ActivityPrevention, ActivityResearch, ActivityRehabilitation, ActivityOther, filter.FilterOnIsactive, IsKef, filter.RegionSearchCodeRef); result = new OrganisationDispsetContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
/// <summary> /// Handles the Click event of the btnExportRtf control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnExportRtf_Click(object sender, EventArgs e) { try { string rtf = @""; #region lekérdezzük a OrganisationContainer -t (a szûrési feltételeknek megfelelõen) // Get query result from database Organisation filter = new Organisation(Guid.NewGuid()); filter.Name = txtName.Text; filter.RegionRef = cmbRegion.SelectedValue; filter.OrganisationFormRef = cmbOrganisationForm.SelectedValue; if (cbxPrevention.Checked) filter.ActivityPrevention = true; if (cbxResearch.Checked) filter.ActivityResearch = true; if (cbxRehabilitation.Checked) filter.ActivityRehabilitation = true; if (cbxOther.Checked) filter.ActivityOther = true; filter.FilterOnIsactive = 1; IOrganisationService orgSrv = ServiceFactory.GetOrganisationService(); OrganisationContainer selected = orgSrv.OrganisationSelectFiltered(filter); #endregion if (selected.AllCount > 0) { DataTable dt = selected.AllAsDatatable; dt = Helper.DataTableTypeMakeString(dt); dt = Helper.DataTableColumnReplace(dt, "ActivityPrevention", "True", "Igen"); dt = Helper.DataTableColumnReplace(dt, "ActivityPrevention", "False", "Nem"); dt = Helper.DataTableColumnReplace(dt, "ActivityResearch", "True", "Igen"); dt = Helper.DataTableColumnReplace(dt, "ActivityResearch", "False", "Nem"); dt = Helper.DataTableColumnReplace(dt, "ActivityRehabilitation", "True", "Igen"); dt = Helper.DataTableColumnReplace(dt, "ActivityRehabilitation", "False", "Nem"); dt = Helper.DataTableColumnReplace(dt, "ActivityOther", "True", "Igen"); dt = Helper.DataTableColumnReplace(dt, "ActivityOther", "False", "Nem"); rtf = Helpers.CreateRtfFromDataSet(dt, "ORGANIZATIONS", Server.MapPath("")); // Writes result to response Helpers.DownloadFile(rtf, "szervezetek.rtf"); } else lblNotFound.Visible = true; } catch (Exception ex) { errorPanel.Exception = ex; } }
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; } }