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();
}
