public void fillGridView()
{
string json = permitholder.read();
string types = permitholder.readTypes();
var x = JsonConvert.DeserializeObject <IEnumerable <string> >(types);
cmbPtipo.Items.Clear();
foreach (var type in x)
{
cmbPtipo.Items.Add(type);
}
if (!json.Equals("[]"))
{
dtgPermisionario.DataSource = Tools.Util.convertToDataTable(json);
dtgPermisionario.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
// dtgPermisionario.Enabled = false;
this.dtgPermisionario.Columns["active"].Visible = true;
this.dtgPermisionario.Columns["created_at"].Visible = false;
this.dtgPermisionario.Columns["updated_at"].Visible = false;
this.dtgPermisionario.Columns["__v"].Visible = false;
this.dtgPermisionario.Columns["_id"].Visible = false;
dtgPermisionario.Columns["number"].DisplayIndex = 0;
dtgPermisionario.Columns["number"].HeaderText = "Número";
dtgPermisionario.Columns["firstname"].DisplayIndex = 1;
dtgPermisionario.Columns["firstname"].HeaderText = "Nombre";
dtgPermisionario.Columns["firstname"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dtgPermisionario.Columns["lastname"].DisplayIndex = 2;
dtgPermisionario.Columns["lastname"].HeaderText = "Apellidos";
dtgPermisionario.Columns["lastname"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dtgPermisionario.Columns["email"].DisplayIndex = 3;
dtgPermisionario.Columns["email"].HeaderText = "Email";
dtgPermisionario.Columns["email"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dtgPermisionario.Columns["address"].DisplayIndex = 4;
dtgPermisionario.Columns["address"].HeaderText = "Dirección";
dtgPermisionario.Columns["address"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dtgPermisionario.Columns["rfc"].DisplayIndex = 5;
dtgPermisionario.Columns["rfc"].HeaderText = "RFC";
dtgPermisionario.Columns["phone1"].DisplayIndex = 6;
dtgPermisionario.Columns["phone1"].HeaderText = "Teléfono 1";
dtgPermisionario.Columns["phone2"].DisplayIndex = 7;
dtgPermisionario.Columns["phone2"].HeaderText = "Teléfono 2";
dtgPermisionario.Columns["license"].DisplayIndex = 8;
dtgPermisionario.Columns["license"].HeaderText = "Licencia";
dtgPermisionario.Columns["licensevalidity"].DisplayIndex = 9;
dtgPermisionario.Columns["licensevalidity"].HeaderText = "Vigencia";
dtgPermisionario.Columns["type"].DisplayIndex = 10;
dtgPermisionario.Columns["type"].HeaderText = "Tipo";
dtgPermisionario.Columns["dateadmission"].DisplayIndex = 11;
dtgPermisionario.Columns["dateadmission"].HeaderText = "Fecha Ingreso";
dtgPermisionario.Columns["active"].DisplayIndex = 12;
dtgPermisionario.Columns["active"].HeaderText = "Status";
}
}
public void fillGridView()
{
string json = driver.read();
if (!json.Equals("[]"))
{
dtgChoferes.DataSource = Tools.Util.convertToDataTable(json);
dtgChoferes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
// dtgPermisionario.Enabled = false;
this.dtgChoferes.Columns["active"].Visible = true;
this.dtgChoferes.Columns["created_at"].Visible = false;
this.dtgChoferes.Columns["updated_at"].Visible = false;
this.dtgChoferes.Columns["__v"].Visible = false;
this.dtgChoferes.Columns["_id"].Visible = false;
dtgChoferes.Columns["number"].DisplayIndex = 0;
dtgChoferes.Columns["number"].HeaderText = "Número";
dtgChoferes.Columns["firstname"].DisplayIndex = 1;
dtgChoferes.Columns["firstname"].HeaderText = "Nombre";
dtgChoferes.Columns["firstname"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dtgChoferes.Columns["lastname"].DisplayIndex = 2;
dtgChoferes.Columns["lastname"].HeaderText = "Apellidos";
dtgChoferes.Columns["lastname"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dtgChoferes.Columns["email"].DisplayIndex = 3;
dtgChoferes.Columns["email"].HeaderText = "Email";
dtgChoferes.Columns["email"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dtgChoferes.Columns["address"].DisplayIndex = 4;
dtgChoferes.Columns["address"].HeaderText = "Dirección";
dtgChoferes.Columns["address"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dtgChoferes.Columns["rfc"].DisplayIndex = 5;
dtgChoferes.Columns["rfc"].HeaderText = "RFC";
dtgChoferes.Columns["phone1"].DisplayIndex = 6;
dtgChoferes.Columns["phone1"].HeaderText = "Teléfono 1";
dtgChoferes.Columns["phone2"].DisplayIndex = 7;
dtgChoferes.Columns["phone2"].HeaderText = "Teléfono 2";
dtgChoferes.Columns["license"].DisplayIndex = 8;
dtgChoferes.Columns["license"].HeaderText = "Licencia";
dtgChoferes.Columns["licensevalidity"].DisplayIndex = 9;
dtgChoferes.Columns["licensevalidity"].HeaderText = "Vigencia";
dtgChoferes.Columns["type"].DisplayIndex = 10;
dtgChoferes.Columns["type"].HeaderText = "Tipo";
dtgChoferes.Columns["dateadmission"].DisplayIndex = 11;
dtgChoferes.Columns["dateadmission"].HeaderText = "Fecha Ingreso";
dtgChoferes.Columns["active"].DisplayIndex = 12;
dtgChoferes.Columns["active"].HeaderText = "Status";
}
}
private void loadCombobox()
{
Permisionario permitholder = new Permisionario();
string json = permitholder.read();
List <Permisionario> x = JsonConvert.DeserializeObject <List <Permisionario> >(json.Replace("_id", "id"));
if (!json.Equals("[]"))
{
Dictionary <String, String> datasource = new Dictionary <string, string>();
foreach (Permisionario p in x)
{
datasource.Add(p.Id, p.Firstname + " " + p.Lastname);
}
cmbPermitholder.DataSource = new BindingSource(datasource, null);
cmbPermitholder.DisplayMember = "Value";
cmbPermitholder.ValueMember = "Key";
}
}
