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