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