private void UpdateDriverCode(string code)
{
bool notFound = true;
int id = 0;
string name = null;
if (!String.IsNullOrWhiteSpace(code))
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.DriversInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.DriversInfoTableAdapter();
AssignmentsDataSet.DriversInfoDataTable dataTable = adapter.GetDataByCode(code);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.DriversInfoRow row = (AssignmentsDataSet.DriversInfoRow)dataTable.Rows[0];
id = row.Id;
name = row.Name;
notFound = false;
}
}
DriverId = id;
DriverName = name;
DriverNotFound = notFound;
}
public override EnumerableRowCollection Query()
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.DriversInfoTableAdapter adapt = new AssignmentsDataSetTableAdapters.DriversInfoTableAdapter();
adapt.Fill(ds.DriversInfo);
return(from driver in ds.DriversInfo.AsEnumerable()
select new
{
Código = driver.Code,
Nombre = driver.Name,
Id = driver.Id
});
}
private void UpdateDriverInfo(int id)
{
if (id > 0)
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.DriversInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.DriversInfoTableAdapter();
AssignmentsDataSet.DriversInfoDataTable dataTable = adapter.GetDataBy(id);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.DriversInfoRow row = (AssignmentsDataSet.DriversInfoRow)dataTable.Rows[0];
DriverCode = row.Code;
DriverName = row.Name;
}
}
}
//información del conducto
public string ReturnDriverInfo(int idDriver)
{
string infodriver = "";
if (idDriver > 0)
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.DriversInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.DriversInfoTableAdapter();
AssignmentsDataSet.DriversInfoDataTable dataTable = adapter.GetDataBy(idDriver);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.DriversInfoRow row = (AssignmentsDataSet.DriversInfoRow)dataTable.Rows[0];
infodriver = row.Name;
}
}
return(infodriver);
}
//codigo conductor
private string ReturnDriverCode(int idDriver)
{
string Code = "";
if (idDriver > 0)
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.DriversInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.DriversInfoTableAdapter();
AssignmentsDataSet.DriversInfoDataTable dataTable = adapter.GetDataBy(idDriver);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.DriversInfoRow row = (AssignmentsDataSet.DriversInfoRow)dataTable.Rows[0];
Code = row.Code;
}
}
return(Code);
}