//Llenado de Combo PCC
private void ComboPCC()
{
List <AllPCCsComplet> listPCCs = AllPCCsCompletBL.GetAllPCCsComplet(Login.OrgId);
bindingSource2.DataSource = listPCCs;
foreach (AllPCCsComplet pccItem in listPCCs)
{
ListItem litem = new ListItem();
litem.Text = string.Format("{0} - {1}",
pccItem.CatPccId, pccItem.CatPccName);
litem.Value = pccItem.CatPccId;
cmbPCC1.Items.Add(litem);
cmbPCC2.Items.Add(litem);
cmbPCC3.Items.Add(litem);
cmbPCC4.Items.Add(litem);
cmbPCC5.Items.Add(litem);
}
}
/// <summary>
/// Se definen las columnas, los nombres y el orden automatico
/// Se les asigna el Texto de cabecera, se extrae la lista con los datos
/// de la BD y se hace el llenado del DataGridView
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ucConsultingPCCs_Load(object sender, EventArgs e)
{
dataGridView1.MultiSelect = false;
dataGridView1.ColumnCount = 15;
dataGridView1.Columns[0].Name = "CatPccId";
dataGridView1.Columns[1].Name = "CatPccName";
dataGridView1.Columns[2].Name = "Status";
dataGridView1.Columns[3].Name = "StandardClass";
dataGridView1.Columns[4].Name = "SpecificClass";
dataGridView1.Columns[5].Name = "Confirmation";
dataGridView1.Columns[6].Name = "BusinessClass1";
dataGridView1.Columns[7].Name = "BusinessClass2";
dataGridView1.Columns[8].Name = "BusinessClass3";
dataGridView1.Columns[9].Name = "BusinessClass4";
dataGridView1.Columns[10].Name = "TYPE";
dataGridView1.Columns[11].Name = "Tool";
dataGridView1.Columns[12].Name = "GDS";
dataGridView1.Columns[13].Name = "ActiveDate";
dataGridView1.Columns[14].Name = "InactiveDate";
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[2].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[3].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[4].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[5].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[6].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[7].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[8].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[9].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[10].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[11].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[12].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[13].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[14].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.ColumnHeadersHeightSizeMode =
DataGridViewColumnHeadersHeightSizeMode.AutoSize;
dataGridView1.Columns["CatPccId"].HeaderText = "CatPccId";
dataGridView1.Columns["CatPccName"].HeaderText = "CatPccName";
dataGridView1.Columns["Status"].HeaderText = "Status";
dataGridView1.Columns["StandardClass"].HeaderText = "StandardClass";
dataGridView1.Columns["SpecificClass"].HeaderText = "SpecificClass";
dataGridView1.Columns["Confirmation"].HeaderText = "Confirmation";
dataGridView1.Columns["BusinessClass1"].HeaderText = "BusinessClass1";
dataGridView1.Columns["BusinessClass2"].HeaderText = "BusinessClass2";
dataGridView1.Columns["BusinessClass3"].HeaderText = "BusinessClass3";
dataGridView1.Columns["BusinessClass4"].HeaderText = "BusinessClass4";
dataGridView1.Columns["Type"].HeaderText = "Type";
dataGridView1.Columns["Tool"].HeaderText = "Tool";
dataGridView1.Columns["GDS"].HeaderText = "GDS";
dataGridView1.Columns["ActiveDate"].HeaderText = "ActiveDate";
// dataGridView1.Columns["InactiveDate"].HeaderText = "InactiveDate";
List <AllPCCsComplet> list = AllPCCsCompletBL.GetAllPCCsComplet(Login.OrgId);
foreach (AllPCCsComplet item in list)
{
if (string.IsNullOrEmpty(item.Status))
{
item.Status = "Null";
}
if (string.IsNullOrEmpty(item.StandardClass))
{
item.StandardClass = "Null";
}
if (string.IsNullOrEmpty(item.SpecificClass))
{
item.SpecificClass = "Null";
}
if (string.IsNullOrEmpty(item.Confirmation))
{
item.Confirmation = "Null";
}
if (string.IsNullOrEmpty(item.BusinessClass1))
{
item.BusinessClass1 = "Null";
}
if (string.IsNullOrEmpty(item.BusinessClass2))
{
item.BusinessClass2 = "Null";
}
if (string.IsNullOrEmpty(item.BusinessClass3))
{
item.BusinessClass3 = "Null";
}
if (string.IsNullOrEmpty(item.BusinessClass4))
{
item.BusinessClass4 = "Null";
}
if (string.IsNullOrEmpty(item.Type))
{
item.Type = "Null";
}
if (string.IsNullOrEmpty(item.Tool))
{
item.Tool = "Null";
}
if (string.IsNullOrEmpty(item.GDS))
{
item.GDS = "Null";
}
//if (string .IsNullOrEmpty(item.ActiveDate))
// item.ActiveDate = "Null";
//if (string.IsNullOrEmpty(item.InactiveDate))
item.InactiveDate = "Null";
dataGridView1.Rows.Add(new object[] { item.CatPccId, item.CatPccName, item.Status,
item.StandardClass, item.SpecificClass, item.Confirmation, item.BusinessClass1,
item.BusinessClass2, item.BusinessClass3, item.BusinessClass4, item.Type, item.Tool,
item.GDS, item.ActiveDate, item.InactiveDate });
//, item.ActiveDate, item.InactiveDate
}
}