protected void btnExportRtf_Click(object sender, EventArgs e) { try { string rtf = @""; #region lekérdezzük a ExpertContainer -t (a szûrési feltételeknek megfelelõen) // Get query result from database Expert filter = new Expert(Guid.NewGuid()); filter.Name = txtName.Text; filter.FilterOnIsactive = 1; IExpertService srv = ServiceFactory.GetExpertService(); ExpertContainer selected = srv.ExpertSelectFiltered(filter); #endregion DataTable dt = selected.AllAsDatatable; dt = Helper.DataTableTypeMakeString(dt); rtf = Helpers.CreateRtfFromDataSet(dt, "EXPERTS", Server.MapPath("")); // Writes result to response Helpers.DownloadFile(rtf, "Szakemberek.rtf"); } catch (Exception ex) { errorPanel.Exception = ex; } }
protected void btnExportCsv_Click(object sender, EventArgs e) { try { #region lekérdezzük a ExpertContainer -t (a szûrési feltételeknek megfelelõen) // Get query result from database Expert filter = new Expert(Guid.NewGuid()); filter.Name = txtName.Text; filter.FilterOnIsactive = 1; IExpertService srv = ServiceFactory.GetExpertService(); ExpertContainer selected = srv.ExpertSelectFiltered(filter); #endregion string csv = selected.ExportToCsv(); Helpers.DownloadFile(csv, "Szakemberek.csv"); } catch (Exception ex) { errorPanel.Exception = ex; } }
/// <summary> /// Fill datagrid with data /// </summary> private void FillDatagridExp(DBGuid ExpertID) { try { string sSortColumn = "Name"; int nSelectedRow = -1; // Storing the previous sort order if (dtgExpert.DataSource != null) { sSortColumn = ((DataTable) dtgExpert.DataSource).DefaultView.Sort; } if (m_allDataExp == null) { // Retrieving Experts // Set filter Expert filter = new Expert(Guid.Empty); filter.FilterOnIsactive = DBInt.Null; filter.FilterOnIsactive = 1; filter.IsActive = true; // Retrieving data from BusinessServices IExpertService srv = ServiceFactory.GetExpertService(); m_allDataExp = srv.ExpertSelectFiltered(filter); // Retrieving ProgramParticipant DBGuid ProgramID = new DBGuid(new Guid(m_sCurrentID)); IProgramService srvP = ServiceFactory.GetProgramService(); ProgramParticipantContainer allDataPP = srvP.SelectChildrenByProgramParticipant(ProgramID); // Hide selected Expert items for (int i = 0; i < allDataPP.All.Count; i++) { DBGuid ExpertRef = ((ProgramParticipant) allDataPP.All.Items[i]).ExpertRef; Expert selected = (Expert) m_allDataExp[ExpertRef.ToString()]; if (selected != null) { m_allDataExp.Delete(selected); } } } // Fill expert grid DataTable dt = m_allDataExp.CurrentAsDatatable; dt.DefaultView.Sort = sSortColumn; dtgExpert.DataSource = dt; // Fill expert "detail" grid DataTable dtDetail = m_allDataExp.DeletedAsDatatable; dtDetail.DefaultView.Sort = sSortColumn; dtgExpertDetail.DataSource = dtDetail; // Locates the row specified by ID param if (!ExpertID.IsNull) { BindingManagerBase bm = dtgExpert.BindingContext[dtgExpert.DataSource, dtgExpert.DataMember]; int nPositionStart = bm.Position; DataRow dr; for (int i = 0; i < bm.Count; i++) { dr = ((DataRowView) bm.Current).Row; if (ExpertID.Value.Equals(dr["ID"])) { nSelectedRow = i; break; } bm.Position += 1; } bm.Position = nPositionStart; } // Makes the row selected if (nSelectedRow <= ((DataTable) dtgExpert.DataSource).DefaultView.Count && nSelectedRow > -1) { dtgExpert.Select(nSelectedRow); dtgExpert.CurrentRowIndex = nSelectedRow; } else if (((DataTable) dtgExpert.DataSource).DefaultView.Count != 0) { dtgExpert.Select(0); } // Enabling or disabling the buttons according to record count. // And is because of previous disable state. bool bIsEmptyGrid = (((DataTable) dtgExpert.DataSource).DefaultView.Count == 0); btnAddExpert.Enabled = ! bIsEmptyGrid; btnDetailExpert.Enabled = ! bIsEmptyGrid; bIsEmptyGrid = (((DataTable) dtgExpertDetail.DataSource).DefaultView.Count == 0); btnRemoveExpert.Enabled = ! bIsEmptyGrid; } catch (Exception ex) { // --- Log exception ExceptionManager.Publish(ex); // --- Display Exception ErrorHandler.DisplayError("Nem várt hiba lépett fel a szakember lista frissítése során.", ex); } }
protected void btnCreate_Click(object sender, EventArgs e) { try { if (!Page.IsValid) { return; } string displayMode = Request["mode"]; string progId = Request["progId"]; Guid expertGuid = Guid.NewGuid(); Guid programGuid = new Guid(progId); Expert expert = new Expert(expertGuid); expert.Name = txtName.Text; expert.NamePrefix = txtNamePrefix.Text; expert.Phone1 = txtPhone1.Text; if (txtPhone2.Text.Trim().Length > 0) expert.Phone2 = txtPhone2.Text; if (txtPhone3.Text.Trim().Length > 0) expert.Phone3 = txtPhone3.Text; if (txtFax.Text.Trim().Length > 0) expert.Fax = txtFax.Text; expert.Email1 = txtEmail1.Text; if (txtEmail2.Text.Trim().Length > 0) expert.Email2 = txtEmail2.Text; if (txtEmail3.Text.Trim().Length > 0) expert.Email3 = txtEmail3.Text; if (txtAddressInstitute.Text.Trim().Length > 0) expert.AddressInstitute = txtAddressInstitute.Text; expert.PostCode = txtMailingPostCode.Text; expert.City = txtMailingCity.Text; expert.Address = txtMailingAddress.Text; if (txtJob.Text.Trim().Length > 0) expert.Job = txtJob.Text; expert.QualificationRef = cmbQualification.SelectedValue; if (txtProfession.Text.Trim().Length > 0) expert.Profession = txtProfession.Text; if (txtGraduate.Text.Trim().Length > 0) expert.Graduation = txtGraduate.Text; if (txtActivity.Text.Trim().Length > 0) expert.Activity = txtActivity.Text; if (txtPublication.Text.Trim().Length > 0) expert.Publications = txtPublication.Text; if (txtBiography.Text.Trim().Length > 0) expert.Biography = txtBiography.Text; IExpertService expSrv = ServiceFactory.GetExpertService(); //akar feltölteni önéletrajzot #region önéletrajz feltöltés //kiválasztott egy file-t if (fileUpload.PostedFile != null && fileUpload.PostedFile.ContentLength != 0) { Guid attachmentID = Guid.NewGuid(); ExpertAttachment attachment = new ExpertAttachment(attachmentID); attachment.Name = txtFileName.Text.Length == 0 ? attachmentID.ToString() : txtFileName.Text; attachment.Description = txtFileDesc.Text.Length == 0 ? "" : txtFileDesc.Text; string fileName = Path.GetFileName(fileUpload.PostedFile.FileName); attachment.Path = fileName; BinaryReader reader = new BinaryReader(fileUpload.PostedFile.InputStream); byte[] buffer = new byte[fileUpload.PostedFile.ContentLength]; reader.Read(buffer, 0, fileUpload.PostedFile.ContentLength); attachment.FileData = buffer; expert.ExpertAttachments.Add(attachment); } #endregion expSrv.ExpertInsert(expert); IProgramService programSrv = ServiceFactory.GetProgramService(); switch (displayMode) { case "participantSelect": ProgramParticipant participant = new ProgramParticipant(expertGuid, programGuid); IProgramParticipantService participantSrv = ServiceFactory.GetProgramParticipantService(); participantSrv.ProgramParticipantInsert(participant); break; case "responsibleSelect": Program responsible = new Program(programGuid); responsible.ResponsibleRef = expertGuid; programSrv.ProgramResponsibleUpdate(responsible); break; case "coordinator1Select": Program coordinator1 = new Program(programGuid); coordinator1.Coordinator1Ref = expertGuid; programSrv.ProgramCoordinator1Update(coordinator1); break; case "coordinator2Select": Program coordinator2 = new Program(programGuid); coordinator2.Coordinator2Ref = expertGuid; programSrv.ProgramCoordinator2Update(coordinator2); break; } Response.Redirect("ProgramData.aspx?progId=" + progId); } catch (Exception ex) { errorPanel.Exception = ex; } }
// ------------------------------------------------------------------------------------- /// <summary> /// Copy constructor. /// </summary> /// <param name="origInstance">Original document data to copy.</param> // ------------------------------------------------------------------------------------- public Expert(Expert origInstance) : base(origInstance) { }
// ------------------------------------------------------------------------------------- /// <summary> /// Copy constructor. /// </summary> /// <param name="IDVal">Value of 'uID' field</param> /// <param name="origInstance">Original document data to copy.</param> // ------------------------------------------------------------------------------------- public Expert(DBGuid IDVal, Expert origInstance) : base(IDVal, origInstance) { }
public virtual void ExpertUpdate(Expert entity) { TraceCallEnterEvent.Raise(); try { m_DataContext.BeginNestedTran(); try { int count; m_DataContext.ndihdExpertUpdate(entity.ID, entity.Name, entity.NamePrefix, entity.Phone1, entity.Phone2, entity.Phone3, entity.Fax, entity.Email1, entity.Email2, entity.Email3, entity.PostCode, entity.City, entity.Address, entity.AddressInstitute, entity.Job, entity.QualificationRef, entity.Graduation, entity.Profession, entity.Activity, entity.Publications, entity.Biography, entity.IsActive, 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 Expert ExpertSelect(DBGuid IDVal) { TraceCallEnterEvent.Raise(); try { Expert result = null; DataSet entitySet = m_DataContext.ndihdExpertSelect(IDVal); if (entitySet.Tables[0].Rows.Count != 0) { result = new Expert(entitySet); } TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
public virtual void ExpertDelete(Expert entity) { TraceCallEnterEvent.Raise(); try { m_DataContext.BeginNestedTran(); try { m_DataContext.ndihdExpertDelete(entity.ID); m_DataContext.CommitNested(); } catch { m_DataContext.RollbackNested(); throw; } TraceCallReturnEvent.Raise(); return; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
/// <summary> /// Fill datagrid with data /// </summary> private void FillDatagrid(DBGuid ID) { try { string sSortColumn = "Name"; int nSelectedRow = -1; // Storing the previous sort order if (dtgMain.DataSource != null) { sSortColumn = ((DataTable) dtgMain.DataSource).DefaultView.Sort; } // Set filter Expert filter = new Expert(Guid.Empty); if (txtName.Text.Length > 0) { filter.Name = txtName.Text; } filter.FilterOnIsactive = DBInt.Null; if (cmbStatus.SelectedIndex > 0) { bool bIsActive = (cmbStatus.SelectedValue.ToString() == "1" ? true : false); filter.FilterOnIsactive = (DBInt) Convert.ToInt32(bIsActive); filter.IsActive = bIsActive; } // Retrieving data from BusinessServices IExpertService srv = ServiceFactory.GetExpertService(); ExpertContainer allData = srv.ExpertSelectFiltered(filter); DataTable dt = allData.AllAsDatatable; dt.DefaultView.Sort = sSortColumn; dtgMain.DataSource = dt; // Locates the row specified by ID param if (!ID.IsNull) { BindingManagerBase bm = dtgMain.BindingContext[dtgMain.DataSource, dtgMain.DataMember]; DataRow dr; for (int i = 0; i < bm.Count; i++) { dr = ((DataRowView) bm.Current).Row; if (ID.Value.Equals(dr["ID"])) { nSelectedRow = i; break; } bm.Position += 1; } } // Makes the row selected if (nSelectedRow <= ((DataTable) dtgMain.DataSource).DefaultView.Count && nSelectedRow > -1) { dtgMain.Select(nSelectedRow); dtgMain.CurrentRowIndex = nSelectedRow; } else if (((DataTable) dtgMain.DataSource).DefaultView.Count != 0) { dtgMain.Select(0); } // Enabling or disabling the buttons according to record count. // And is because of previous disable state. bool bIsEmptyGrid = (((DataTable) dtgMain.DataSource).DefaultView.Count == 0); tbbModify.Enabled = ! bIsEmptyGrid; tbbInactivate.Enabled = ! bIsEmptyGrid; tbbReplace.Enabled = ! bIsEmptyGrid; if (bIsEmptyGrid && pnlReplace.Visible) { ShowReplacePanel(false); } } 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); } }
private void ExportList() { try { if (csvSaveFileDialog.ShowDialog() == DialogResult.OK) { // Set filter Expert filter = new Expert(Guid.Empty); if (txtName.Text.Length > 0) { filter.Name = txtName.Text; } filter.FilterOnIsactive = DBInt.Null; if (cmbStatus.SelectedIndex > 0) { bool bIsActive = (cmbStatus.SelectedValue.ToString() == "1" ? true : false); filter.FilterOnIsactive = (DBInt) Convert.ToInt32(bIsActive); filter.IsActive = bIsActive; } // Retrieving data from BusinessServices IExpertService srv = ServiceFactory.GetExpertService(); ExpertContainer allData = srv.ExpertSelectFiltered(filter); string csv = allData.ExportToCsv(); Stream stream = csvSaveFileDialog.OpenFile(); if (stream != null) { StreamWriter writer = new StreamWriter(stream, Encoding.Default); writer.Write(csv); writer.Flush(); writer.Close(); stream.Close(); } } } catch (Exception ex) { // --- Log exception ExceptionManager.Publish(ex); // --- Display Exception ErrorHandler.DisplayError("Hiba történt az adatok módosítása során.", ex); } }
/// <summary> /// Edit constructor /// </summary> public frmExpertEdit(DBGuid ID, bool bReadOnly) { // Required for Windows Form Designer support InitializeComponent(); CurrentID = ID; IExpertService expSrv = ServiceFactory.GetExpertService(); m_currentExpert = expSrv.ExpertSelect(CurrentID); m_bReadOnly = bReadOnly; }
/// <summary> /// Edit constructor /// </summary> public frmExpertEdit(DBGuid ID) { // Required for Windows Form Designer support InitializeComponent(); CurrentID = ID; IExpertService expSrv = ServiceFactory.GetExpertService(); m_currentExpert = expSrv.ExpertSelect(CurrentID); m_currentExpert.ExpertAttachments = expSrv.SelectChildrenByAttachmentOfExpert(m_currentExpert.ID); m_bReadOnly = false; }
protected void ShowExpertGrid(DataGrid dataGrid, int index, string sort, string order) { dataGrid.PageSize = Helpers.GetPageSize("PageSize.ExpertList"); // Get query result from database Expert filter = new Expert(Guid.NewGuid()); filter.Name = Helpers.CreateLikeSearchText(txtName.Text); filter.FilterOnIsactive = 1; IExpertService srv = ServiceFactory.GetExpertService(); ExpertContainer selected = srv.ExpertSelectFiltered(filter); if (selected.AllCount > 0) { dataGrid.Visible = true; lblNotFound.Visible = false; } else { dataGrid.Visible = false; lblNotFound.Visible = true; return; } ArrayList sortableList = null; // Sort if necessary if (sort == null) { sortableList = selected.All.Items; } else { if (String.Compare(order, "Ascending", true) == 0) { sortableList = selected.All.SortBy(sort, true); } else if (String.Compare(order, "Descending", true) == 0) { sortableList = selected.All.SortBy(sort, false); } else { sortableList = selected.All.SortBy(sort); } } // Bind list to datagrid control dataGrid.CurrentPageIndex = index; if (selected.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(); }