private void CB_email_MouseClick(object sender, MouseEventArgs e)
{
if (CB_email.Items.Count > 0)
{
return;
}
Project project = new Project();
DBEntity dbExpert = new Expert(null);
string projName = this.CB_project.Text;
string linkTB = "`projeto_especialista`";
string filter = DBEntity.getJoinFilter(projName, Project.ST.ST_NAME, project, dbExpert, linkTB);
dbExpert.setFilter(filter);
this.access.dbExperts = dbExpert.getDataSource();
int nExperts = this.access.dbExperts.Count;
CB_email.Items.Clear();
for (int i = 0; i < nExperts; i++)
{
if (((Expert)this.access.dbExperts[i]).id != 0)
{
CB_email.Items.Add(((Expert)this.access.dbExperts[i]).email);
}
}
}
public FormularioCadastro(IFormPrincipal iformPrincipal)
{
int j = 0;
ST_P_GRAU = Expert.ST.DEGREES[j]; j++;
ST_S_GRAU = Expert.ST.DEGREES[j]; j++;
ST_CURSO_TECNICO = Expert.ST.DEGREES[j]; j++;
ST_GRADUACAO = Expert.ST.DEGREES[j]; j++;
ST_ESPECIALIDADE = Expert.ST.DEGREES[j]; j++;
ST_MESTRADO = Expert.ST.DEGREES[j]; j++;
ST_DOUTORADO = Expert.ST.DEGREES[j]; j++;
InitializeComponent();
this.iformPrincipal = iformPrincipal;
//InterfaceBanco banco = InterfaceBanco.getInstance();
//analistas = banco.retornarAnalistas();
DBEntity dbProject = new Project();
access.dbProjects = dbProject.getDataSource();
int nProjects = access.dbProjects.Count;
for (int i = 1; i < nProjects; i++)
{
CB_project.Items.Add(((Project)access.dbProjects[i]).name);
}
DBEntity dbAnalyst = new Analyst();
access.dbAnalysts = dbAnalyst.getDataSource();
int nAnalysts = access.dbAnalysts.Count;
for (int i = 1; i < nAnalysts; i++)
{
CB_analista.Items.Add(((Analyst)access.dbAnalysts[i]).name);
}
DBEntity dbMethod = new Method(-1);
dbMethods = dbMethod.getDataSource();
int nMethods = dbMethods.Count;
for (int i = 0; i < nMethods; i++)
{
if ((((Method)dbMethods[i]).name) != "0")
{
//CB_MetodoEducao.Items.Add (((Method)dbMethods[i]).name);
CB_MetodoEducao.Items.Add(new ComboBoxItem(((Method)dbMethods[i]).id.ToString(), ((Method)dbMethods[i]).name));
//CB_MetodoTreinamento.Items.Add (((Method)dbMethods[i]).name);
CB_MetodoTreinamento.Items.Add(new ComboBoxItem(((Method)dbMethods[i]).id.ToString(), ((Method)dbMethods[i]).name));
}
}
DBEntity dbExpert = new Expert(null);
this.access.dbExperts = dbExpert.getDataSource();
int nExperts = this.access.dbExperts.Count;
CB_email.Items.Clear();
for (int i = 1; i < nExperts; i++)
{
CB_email.Items.Add(((Expert)this.access.dbExperts[i]).email);
}
}
public Filter(IFormPrincipal iFPrincipal)
{
this.iFPrincipal = iFPrincipal;
this.tempo = new List <double>();
this.id_question = new List <int>();
this.nome_arquivo_accuracy = "../../accuracy.txt";
this.nome_arquivo_efficiency = "../../efficiency.txt";
this.queryAccuracy = "select * from estatisticas inner join processos p"
+ " on p.id_processos = estatisticas.id_processos"
+ " inner join projeto prj on prj.id_projeto = p.id_projeto"
+ " inner join analistas a on a.id_analistas = p.id_analistas"
+ " inner join especialistas e on e.id_especialista = p.id_especialista"
+ " inner join titulacao t on t.id_especialista = e.id_especialista";
//+"where e.id_especialista = 1 and prj.id_projeto = 1 and a.id_analistas = 1 and t.titulacao = 'Mestrado'";
this.queryEficience = "select * from time_events inner join processos p"
+ " on p.id_processos = time_events.id_processos"
+ " inner join projeto prj on prj.id_projeto = p.id_projeto"
+ " inner join analistas a on a.id_analistas = p.id_analistas"
+ " inner join especialistas e on e.id_especialista = p.id_especialista"
+ " inner join titulacao t on t.id_especialista = e.id_especialista";
//+ "where e.id_especialista = 1 and prj.id_projeto = 1 and a.id_analistas = 1 and t.titulacao = 'Mestrado'";
InitializeComponent();
LB_filter.Text = queryAccuracy + "\n" + queryEficience;
DBEntity dbProject = new Project();
this.access.dbProjects = dbProject.getDataSource();
int length = this.access.dbProjects.Count;
for (int i = 1; i < length; i++)
{
Project proj_i = (Project)this.access.dbProjects[i];
this.CLB_ATS_projects.addItem(proj_i.name);
}
DBEntity dbExpert = new Expert(null);
this.access.dbExperts = dbExpert.getDataSource();
length = this.access.dbExperts.Count;
for (int i = 0; i < length; i++)
{
Expert exp_i = (Expert)this.access.dbExperts[i];
if (exp_i.email != "NULL")//não pegar o especialista nulo
{
this.CLB_ATS_emails.addItem(exp_i.email);
}
}
this.CLB_ATS_professionalProfile.addItems(Expert.ST.PROFESSINOAL_PROFILES);
this.CLB_ATS_mathDomain.addItems(Expert.ST.SCALE_0_10);
this.CLB_ATS_uncertaintyDomain.addItems(Expert.ST.SCALE_0_10);
this.CLB_ATS_degree.addItems(Expert.ST.DEGREES);
DBEntity dbAnalista = new Analyst();
this.access.dbAnalysts = dbAnalista.getDataSource();
for (int i = 1; i < this.access.dbAnalysts.Count; i++)
{
Analyst ana_i = (Analyst)this.access.dbAnalysts[i];
this.CLB_ATS_analysts.addItem(ana_i.name);
}
}
