/// <summary>
/// /
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmAddNewApp_Load(object sender, EventArgs e)
{
//this.cleanSDataset.EnforceConstraints = false;
ViewEmpPerContract = new ViewEmpPerContractTableAdapter();
employeeTableAdapter = new EmployeeTableAdapter();
this.contractTableAdapter.Fill(this.cleanSDataset.Contract);
this.customerTableAdapter.Fill(this.cleanSDataset.Customer);
}
private void FillGrid(object value)
{
dataSet1.Tables[0].Clear();
dataSet1.Tables[0].AcceptChanges();
gridControl1.RefreshDataSource();
if (ViewEmpPerContract == null)
{
ViewEmpPerContract = new ViewEmpPerContractTableAdapter();
}
if (employeeTableAdapter == null)
{
employeeTableAdapter = new EmployeeTableAdapter();
}
ViewEmpPerContract.Fill(this.cleanSDataset.ViewEmpPerContract);
employeeTableAdapter.Fill(this.cleanSDataset.Employee);
if (this.cleanSDataset.ViewEmpPerContract.Count > 0)
{
DataView dv = new DataView(cleanSDataset.ViewEmpPerContract)
{
RowFilter = "IdContract=" + value
};
if (dv.Count > 0)
{
dataSet1.Tables[0].Clear();
dataSet1.Tables[0].AcceptChanges();
foreach (DataRowView rowView in dv)
{
var row = dataSet1.Tables[0].NewRow();
row[0] = true;
row[1] = rowView["FirstName"];
row[2] = rowView["LastName"];
row["Id"] = rowView["IdEmployee"];
dataSet1.Tables[0].Rows.Add(row);
}
dataSet1.Tables[0].AcceptChanges();
}
foreach (var rowEmp in this.cleanSDataset.Employee)
{
var dataView = new DataView(dataSet1.Tables[0])
{
RowFilter = "id=" + rowEmp["IdEmployee"]
};
if (dataView.Count == 0)
{
var row = dataSet1.Tables[0].NewRow();
row[0] = false;
row[1] = rowEmp["FirstName"];
row[2] = rowEmp["LastName"];
row["Id"] = rowEmp["IdEmployee"];
dataSet1.Tables[0].Rows.Add(row);
dataSet1.Tables[0].AcceptChanges();
}
}
}
}
