private void NewBuild(FuncionarioVaccinaColletion vacinas, Panel panelToshow)
{
foreach (Vacina vacina in vacinas.ListaVacinas)
{
Control panelToadd = HelperClass.FindTag(panelToshow.Controls, DealWithVaccineNames(vacina));
ViewControls.Vacinas.VaccineViewer vacinaPanel = new ViewControls.Vacinas.VaccineViewer(vacina.Nome, vacina.Dados.Data.ToString("dd/MM/yyyy"), vacina.Dados.Lote, vacina.Dados.Unidade);
panelToadd.Controls.RemoveAt(vacina.Dose);
var margim = vacinaPanel.Margin;
margim.All = 0;
margim.Top = 1;
vacinaPanel.Margin = margim;
vacinaPanel.Size = VacineViewerSizeHandler(vacinaPanel, panelToadd);
panelToadd.Controls.Add(vacinaPanel);
panelToadd.Controls.SetChildIndex(vacinaPanel, (vacina.Dose));
}
}
/// <summary>
/// CONVERT FUNCIONARIO SQL INFORMATION TO FUNCIONARIOITEM
///
/// SEM INFORMACOES DE ONIBUS
/// </summary>
/// <param name="_dt"></param>
/// <returns></returns>
public FuncionarioItem ConvertoFromSqlTo_1_FuncionarioItem(DataTable dt)
{
List <FuncionarioItem> listFUncionarios = new List <FuncionarioItem>();
int aux = 0;
FuncionarioItem funcionario = null;
if (dt.Rows.Count == 1)
{
foreach (DataRow rows in dt.Rows)
{
Image picture = null;
//helper less conversions
int row = 0;
//matricula
int matricula = Convert.ToInt32(dt.Rows[row][0]);
if (matricula >= aux)
{
aux = matricula;
}
//deal if date is a picture
if (Convert.IsDBNull(dt.Rows[row][1]) == false)
{
Byte[] data = new Byte[0];
data = (Byte[])(dt.Rows[row][1]);
MemoryStream mem = new MemoryStream(data);
picture = Image.FromStream(mem);
}
//nome.... etc
string nome = dt.Rows[row][2].ToString();
string identidade = dt.Rows[row][3].ToString();
string cpf = dt.Rows[row][4].ToString();
DateTime dn = Convert.ToDateTime(dt.Rows[row][5]);
string sexo = dt.Rows[row][6].ToString();
string rua = dt.Rows[row][7].ToString();
string numero = dt.Rows[row][8].ToString();
string bairro = dt.Rows[row][9].ToString();
string cidade = dt.Rows[row][10].ToString();
string estado = dt.Rows[row][11].ToString();
string complemento = dt.Rows[row][12].ToString();
string cep = dt.Rows[row][13].ToString();
string observacao = dt.Rows[row][14].ToString();
bool inativo = Convert.ToBoolean(dt.Rows[row][15]);
string telefone = dt.Rows[row][16].ToString();
DateTime admissao = Convert.ToDateTime(dt.Rows[row][17]);
CultureInfo cult = new CultureInfo("pt-BR");
DateTime inativacao;
if (Convert.IsDBNull(dt.Rows[row][18]) == false)
{
inativacao = Convert.ToDateTime(dt.Rows[row][18], cult);
}
else
{
inativacao = Convert.ToDateTime("01/01/1900", cult);
}
var dataBaseHandler = new DataBaseHandler();
var sQlDataHandler = new SqlToSharpHandler();
//Get func information bus
OnibusItemCollection funcListOnibus = new OnibusItemCollection();
funcListOnibus.SetList(sQlDataHandler.ConvertSQlToBusCollectionItem(dataBaseHandler.GetBus(matricula)));
//get information about Vaccine
Vacina.FuncionarioVaccinaColletion funcVaccineList = new Vacina.FuncionarioVaccinaColletion();
funcVaccineList.SetList(sQlDataHandler.ConvertSqlVaccineToColletion(dataBaseHandler.GetVacinas(matricula)));
//get func information about ferias
Ferias.FeriasColletionItem listFerias = new Ferias.FeriasColletionItem();
listFerias.SetList(sQlDataHandler.ConvertSqLtoFeriasItem(dataBaseHandler.GetFerias(matricula)));
//get information about exames
Exames.Data.ExameItemColletion collectionExams = new Exames.Data.ExameItemColletion();
Exames.Data.ExameItemColletion colletion = sQlDataHandler.ConvertSqlExamToItem(dataBaseHandler.GetExames(matricula));
//CollectionExams.SetList(SQlDataHandler.ConvertSqlExamToItem(DataBaseHandler.GetExames(matricula)));
//GENERATES FUNCIONARIO ITEM WITH ALL INFO COLLECTED
funcionario = new FuncionarioItem(matricula, picture, nome, cpf, identidade, sexo, dn, rua, numero, complemento, bairro, observacao, cidade, estado, cep, telefone, inativo, admissao, inativacao, null, funcListOnibus, funcVaccineList, listFerias, colletion);
var funcionarioSelected = new FuncionarioItemEdit();
funcionarioSelected.SetFuncionarioEdit(funcionario);
row++;
}
}
return(funcionario);
}
private void ShowVaccineInfo(FuncionarioVaccinaColletion vacina)
{
int squares = 1;
foreach (Vacina vacinainfo in vacina.ListaVacinas)
{
FlowLayoutPanel pn1Dose = new FlowLayoutPanel();
pn1Dose.MaximumSize = new Size((VacinaPanel.Size.Width - 6) / 6, (VacinaPanel.Size.Height - 46) / 3);
pn1Dose.MinimumSize = new Size((VacinaPanel.Size.Width - 6) / 6, (VacinaPanel.Size.Height - 46) / 3);
var margim = pn1Dose.Margin;
margim.All = 1;
pn1Dose.Margin = margim;
pn1Dose.BackColor = Color.LightGray;
Label lbData = new Label();
Label lbLote = new Label();
Label lbUnid = new Label();
lbData.Text = String.Format("Data:" + vacinainfo.Dados.Data.ToString("dd/MM/yyyy"));
lbLote.Text = String.Format("Lote:" + vacinainfo.Dados.Lote);
lbUnid.Text = String.Format("Unid:" + vacinainfo.Dados.Unidade);
ViewControls.Vacinas.VaccineViewer vacineInfo = new ViewControls.Vacinas.VaccineViewer(vacinainfo.Nome, vacinainfo.Dados.Data.ToString("dd/MM/yyyy"), vacinainfo.Dados.Lote, vacinainfo.Dados.Unidade);
margim.All = 1;
vacineInfo.Margin = margim;
//lbData.Dock = DockStyle.Top;
lbData.Margin = margim;
lbData.Left = (pn1Dose.ClientSize.Width - lbData.Width) / 2;
lbData.Top = (pn1Dose.ClientSize.Height - lbData.Height) / 5;
//pn1Dose.Controls.Add(lbData);
//pn1Dose.Controls.Add(lbLote);
lbLote.Left = lbData.Left;
lbLote.Top = lbData.Top + 25;
//lbLote.Dock = DockStyle.Top;
lbLote.Margin = margim;
//lbUnid.Dock = DockStyle.Top;
lbUnid.Margin = margim;
//pn1Dose.Controls.Add(lbUnid);
lbUnid.Left = lbData.Left;
string nomevacina = "";
switch (vacinainfo.Nome)
{
case "HEPATITE B":
{
nomevacina = "Heb B";
squares = 3;
}
break;
case "DUPLA ADULTA":
{
nomevacina = "Dupla Adulta";
squares = 1;
}
break;
case "RUBEOLA":
{
nomevacina = "Rubeola";
squares = 1;
}
break;
case "FEBREAMARELA":
{
nomevacina = "Febre Amar.";
squares = 2;
}
break;
case "TRIPLICE VIRAL":
{
nomevacina = "Trip. Viral";
squares = 2;
}
break;
default:
nomevacina = "nao deu";
break;
}
//finds flowpanel with vaccine name
Control panelToadd = HelperClass.FindTag(VacinaPanel.Controls, nomevacina);
int dose = vacinainfo.Dose;
//Size sizetose = pn1Dose.Size;
vacineInfo.Size = new Size(_columDimentions[2].Width, (_columDimentions[2].Height - 1));
panelToadd.Controls.RemoveAt(dose);
panelToadd.Controls.Add(vacineInfo);
panelToadd.Controls.SetChildIndex(vacineInfo, (dose));
}
var helper = HelperClass.FindTag(VacinaPanel.Controls, "teste");
}
public void PopulateColumns(FuncionarioVaccinaColletion func)
{
if (func.ListaVacinas != null)
{
if (func.ListaVacinas.Count > 0)
{
foreach (Vacina vacina in func.ListaVacinas)
{
//insert column
//deal with square containing labels
Panel pnlegendaDose = new Panel();
//pnlegendaDose.Name = "nome";
var margim = pnlegendaDose.Margin;
margim.All = 1;
pnlegendaDose.MaximumSize = new Size((VacinaPanel.Size.Width - 6) / 6, 40);
pnlegendaDose.Margin = margim;
pnlegendaDose.BackColor = Color.LightGray;
Label dosevacina = new Label();
dosevacina.Text = vacina.Nome;
//panel for name of vaccine handler
pnlegendaDose.Controls.Add(dosevacina);
dosevacina.Left = (pnlegendaDose.ClientSize.Width - dosevacina.Width) / 2;
dosevacina.Top = (pnlegendaDose.ClientSize.Height - dosevacina.Height) / 2;
//panel for name of vaccine 1st dose
//check if there s acolumn for related vaccine
bool auxControl = true;
Control aux1 = null;
//foreach (Control c in vacinaPanel.Controls)
//{
// if (vacina._nome == c.Tag)
// {
// if (vacina._nome == c.Name)
// {
// //c.Controls.Add();
// aux1 = c;
// c.BackColor = Color.Red;
// auxControl = false;
// }
// }
//}
FlowLayoutPanel column2 = new FlowLayoutPanel();
if (auxControl)
{
column2.BackColor = Color.Yellow;
column2.Tag = vacina.Nome;
column2.Name = vacina.Nome;
var margin = column2.Margin;
margin.All = 0;
margin.Right = 1;
column2.Margin = margin;
column2.MaximumSize = new Size((VacinaPanel.Size.Width - 6) / 6, VacinaPanel.Size.Height);
column2.MinimumSize = new Size((VacinaPanel.Size.Width - 6) / 6, VacinaPanel.Size.Height);
}
Panel teste = new Panel();
dosevacina.Left = (pnlegendaDose.ClientSize.Width - dosevacina.Width) / 2;
dosevacina.Top = (pnlegendaDose.ClientSize.Height - dosevacina.Height) / 2;
Panel pn1Dose = new Panel();
pn1Dose.MaximumSize = new Size((VacinaPanel.Size.Width - 6) / 6, (VacinaPanel.Size.Height - 46) / 3);
pn1Dose.MinimumSize = new Size((VacinaPanel.Size.Width - 6) / 6, (VacinaPanel.Size.Height - 46) / 3);
margim = pnlegendaDose.Margin;
margim.All = 1;
pn1Dose.Margin = margim;
pn1Dose.BackColor = Color.LightGray;
Label lbData = new Label();
Label lbLote = new Label();
Label lbUnid = new Label();
lbData.Text = String.Format("Data:" + vacina.Dados.Data.ToString("dd/MM/yyyy"));
lbLote.Text = String.Format("Lote:" + vacina.Dados.Lote);
lbUnid.Text = String.Format("Unid:" + vacina.Dados.Unidade);
margim.All = 1;
//lbData.Dock = DockStyle.Top;
lbData.Margin = margim;
lbData.Left = (pn1Dose.ClientSize.Width - lbData.Width) / 2;
lbData.Top = (pn1Dose.ClientSize.Height - lbData.Height) / 5;
pn1Dose.Controls.Add(lbData);
pn1Dose.Controls.Add(lbLote);
lbLote.Left = lbData.Left;
lbLote.Top = lbData.Top + 25;
//lbLote.Dock = DockStyle.Top;
lbLote.Margin = margim;
//lbUnid.Dock = DockStyle.Top;
lbUnid.Margin = margim;
pn1Dose.Controls.Add(lbUnid);
lbUnid.Left = lbData.Left;
lbUnid.Top = lbData.Top + 50;
teste = pn1Dose;
if (aux1 != null)
{
aux1.Controls.Add(pn1Dose);
}
foreach (Control c in VacinaPanel.Controls)
{
if (vacina.Nome == c.Tag)
{
if (vacina.Nome == c.Name)
{
//c.Controls.Add();
aux1 = c;
c.BackColor = Color.Red;
auxControl = false;
VacinaPanel.Controls.Remove(c);
c.Controls.Add(pn1Dose);
VacinaPanel.Controls.Add(c);
}
}
}
//vacinaPanel.Controls.Add(Column2);
if (auxControl)
{
column2.Controls.Add(pnlegendaDose);
VacinaPanel.Controls.Add(column2);
}
else
{
VacinaPanel.Controls.Remove(aux1);
aux1.Controls.Add(teste);
VacinaPanel.Controls.Add(aux1);
}
}
}
}
}
