public void GetDataTableContato(DataGridView Table, int Id)
{
Table.ColumnCount = 5;
Table.Columns[0].Name = "ID";
Table.Columns[0].Visible = false;
Table.Columns[1].Name = "Contato";
Table.Columns[1].Width = 150;
Table.Columns[2].Name = "Telefone";
Table.Columns[2].Width = 100;
Table.Columns[3].Name = "Celular";
Table.Columns[3].Width = 150;
Table.Columns[4].Name = "E-mail";
Table.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Table.Rows.Clear();
var address = new PessoaContato();
var data = address.Query()
.Where("EXCLUIR", 0)
.Where("ID_PESSOA", Id)
.OrderByDesc("criado")
.Get();
foreach (var item in data)
{
Table.Rows.Add(
item.ID,
item.CONTATO,
item.TELEFONE,
item.CELULAR,
item.EMAIL
);
}
}
