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 }); }