private void UpdateTrailerInfo(string code)
{
bool notFound = true;
int id = 0, volume = 0;
string lplate = null;
if (!String.IsNullOrWhiteSpace(code))
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter();
AssignmentsDataSet.TrailerInfoDataTable dataTable = adapter.GetDataByCode(code);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.TrailerInfoRow row = (AssignmentsDataSet.TrailerInfoRow)dataTable.Rows[0];
id = row.Id;
lplate = row.LicensePlate;
volume = row.TankVolume;
notFound = false;
}
}
TrailerId = id;
TrailerLicensePlate = lplate;
TrailerVolume = volume;
TrailerNotFound = notFound;
}
//devuelve el volumen del trailes
private string ReturnTrailerVolume(int idtrailer)
{
string VolumeTrailer = "";
if (idtrailer > 0)
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter();
AssignmentsDataSet.TrailerInfoDataTable dataTable = adapter.GetDataBy1IdTrailer(idtrailer);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.TrailerInfoRow row = (AssignmentsDataSet.TrailerInfoRow)dataTable.Rows[0];
VolumeTrailer = row.TankVolume.ToString();
}
}
return(VolumeTrailer);
}
private void UpdateTrailerInfo(int id)
{
if (id > 0)
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter();
AssignmentsDataSet.TrailerInfoDataTable dataTable = adapter.GetDataBy(id);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.TrailerInfoRow row = (AssignmentsDataSet.TrailerInfoRow)dataTable.Rows[0];
TrailerCode = row.Code;
TrailerLicensePlate = row.LicensePlate;
TrailerVolume = row.TankVolume;
}
}
}
//devuelve la licensia del trailer
private string ReturnTrailerLicense(int idtrailer)
{
string LicenseTrailer = "";
if (idtrailer > 0)
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter();
AssignmentsDataSet.TrailerInfoDataTable dataTable = adapter.GetDataBy1IdTrailer(idtrailer);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.TrailerInfoRow row = (AssignmentsDataSet.TrailerInfoRow)dataTable.Rows[0];
LicenseTrailer = row.LicensePlate;
}
}
return(LicenseTrailer);
}
public override EnumerableRowCollection Query()
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter adapt = new AssignmentsDataSetTableAdapters.TrailerInfoTableAdapter();
adapt.Fill(ds.TrailerInfo);
return(from trailer in ds.TrailerInfo.AsEnumerable()
select new
{
Código = trailer.Code,
Matricula = trailer.LicensePlate,
Tipo = trailer.TypeName,
Tamaño = trailer.SizeName,
Capacidad = trailer.TankVolume,
Observaciones = trailer.Observations,
Id = trailer.Id
});
}
