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;
}
public void Load(long id)
{
try
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.AssignmentsTableAdapter adapter = new AssignmentsDataSetTableAdapters.AssignmentsTableAdapter();
AssignmentsDataSet.AssignmentsDataTable dataTable = adapter.GetDataById(id);
if (dataTable.Rows.Count > 0)
{
_row = (AssignmentsDataSet.AssignmentsRow)dataTable.Rows[0];
RaisePropertyChanged(nameof(Date));
RaisePropertyChanged(nameof(Observations));
RaisePropertyChanged(nameof(Enabled));
UpdateDriverInfo(_row.DriverId);
UpdateCabInfo(_row.CabId);
UpdateTrailerInfo(_row.TrailerId);
}
FormLoadFinished?.Invoke();
}
catch (Exception e)
{
FormLoadError?.Invoke(e);
}
}
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 void Save()
{
try
{
AssignmentsDataSet dataset = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.AssignmentsTableAdapter adapter = new AssignmentsDataSetTableAdapters.AssignmentsTableAdapter();
if (_row.DriverId > 0 && _row.CabId > 0 && _row.TrailerId > 0)
{
if (_row.Id > 0)
{
adapter.UpdateAs(_row.Id, _row.DriverId, _row.CabId, _row.TrailerId, _row.Date, _row.Repeat, _row.Enabled, _row.Observations);
}
else
{
adapter.InsertAs(_row.DriverId, _row.CabId, _row.TrailerId, _row.Date, _row.Repeat, _row.Enabled, _row.Observations);
}
FormSaveFinished?.Invoke();
}
else
{
FormRequiredEmpty?.Invoke();
}
}
catch (Exception e)
{
FormSaveError?.Invoke(e);
}
}
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
});
}
public void Delete()
{
try
{
AssignmentsDataSet dataset = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.AssignmentsTableAdapter adapter = new AssignmentsDataSetTableAdapters.AssignmentsTableAdapter();
adapter.DeleteBy(_row.Id);
FormDeleteFinished?.Invoke();
}
catch (Exception e)
{
FormDeleteError?.Invoke(e);
}
}
private void UpdateCabInfo(int id)
{
if (id > 0)
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.CabInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.CabInfoTableAdapter();
AssignmentsDataSet.CabInfoDataTable dataTable = adapter.GetDataBy(id);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.CabInfoRow row = (AssignmentsDataSet.CabInfoRow)dataTable.Rows[0];
CabCode = row.Code;
CabLicensePlate = row.LicensePlate;
}
}
}
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;
}
}
}
public void LoadDatas(long id)
{
try
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.AssignmentsTableAdapter adapter = new AssignmentsDataSetTableAdapters.AssignmentsTableAdapter();
AssignmentsDataSet.AssignmentsDataTable dataTable = adapter.GetDataById(id);
AssignmentsDataSetTableAdapters.Assignments_ObsTableAdapter adapter2 = new AssignmentsDataSetTableAdapters.Assignments_ObsTableAdapter();
AssignmentsDataSet.Assignments_ObsDataTable dataTableObs = adapter2.GetDataAssignmentsObsById(id);
if (dataTable.Rows.Count > 0)
{
_row = (AssignmentsDataSet.AssignmentsRow)dataTable.Rows[0];
//fecha
txtDate.Text = _row.Date.ToString();
//observaciones
if (dataTableObs.Count > 0)
{
txtObservation.Text = dataTableObs[0].Observations.ToString();
}
else
{
txtObservation.Text = "";
}
//cargamos datos conductor
txtCodeDriver.Text = ReturnDriverCode(_row.DriverId);
txtNameDriver.Text = ReturnDriverInfo(_row.DriverId);
//cargamos datos cabina tractora
txtlicense.Text = ReturnCabLicensePlate(_row.CabId);
tractoraCode.Text = ReturnCabCode(_row.CabId);
//cargamos datos trailer
txttrailerCode.Text = ReturnTrailerCode(_row.TrailerId);
txtRemolquelicense.Text = ReturnTrailerLicense(_row.TrailerId);
txtTrailerVolume.Text = ReturnTrailerVolume(_row.TrailerId);
}
}
catch (Exception e)
{
}
}
//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);
}
public override EnumerableRowCollection Query()
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.CabInfoTableAdapter adapt = new AssignmentsDataSetTableAdapters.CabInfoTableAdapter();
adapt.Fill(ds.CabInfo);
return(from cab in ds.CabInfo.AsEnumerable()
select new
{
Código = cab.Code,
Matricula = cab.LicensePlate,
Tipo = cab.TypeName,
Tamaño = cab.SizeName,
Observaciones = cab.Observations,
Id = cab.Id
});
}
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;
}
}
}
public AssignmentsFormViewModel()
{
AssignmentsDataSet dataset = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.AssignmentsTableAdapter adapter = new AssignmentsDataSetTableAdapters.AssignmentsTableAdapter();
_row = dataset.Assignments.NewAssignmentsRow();
_row.Date = DateTime.Today;
_row.Enabled = true;
_row.Repeat = false;
_row.DriverId = 0;
_row.CabId = 0;
_row.TrailerId = 0;
SaveCommand = new RelayCommand(Save, CanSave);
DeleteCommand = new RelayCommand(Delete, CanDelete);
}
//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);
}
//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);
}
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
});
}
//información de cabina
private string ReturnCabLicensePlate(int Cabid)
{
string LicensePlate = "";
if (Cabid > 0)
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.CabInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.CabInfoTableAdapter();
AssignmentsDataSet.CabInfoDataTable dataTable = adapter.GetDataByIdCab(Cabid);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.CabInfoRow row = (AssignmentsDataSet.CabInfoRow)dataTable.Rows[0];
LicensePlate = row.LicensePlate;
}
}
return(LicensePlate);
}
//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);
}
//información de código de cabina
private string ReturnCabCode(int Cabid)
{
string CodeCab = "";
if (Cabid > 0)
{
AssignmentsDataSet ds = new AssignmentsDataSet();
AssignmentsDataSetTableAdapters.CabInfoTableAdapter adapter = new AssignmentsDataSetTableAdapters.CabInfoTableAdapter();
AssignmentsDataSet.CabInfoDataTable dataTable = adapter.GetDataByIdCab(Cabid);
if (dataTable.Rows.Count > 0)
{
AssignmentsDataSet.CabInfoRow row = (AssignmentsDataSet.CabInfoRow)dataTable.Rows[0];
CodeCab = row.Code;
}
}
return(CodeCab);
}
