public void Load(int IdUsuario, TextBox txtoldPassword)
{
try
{
ContraseñaTextbox = txtoldPassword;
idusuario = IdUsuario;
UserDataSet dataset = new UserDataSet();
UserDataSetTableAdapters.System_UsersTableAdapter TableUser = new UserDataSetTableAdapters.System_UsersTableAdapter();
UserDataSet.System_UsersDataTable dataTable = TableUser.GetDataUserById(IdUsuario);
if (dataTable.Rows.Count > 0)
{
UserDataSetTableAdapters.System_Users_ObsTableAdapter User_obs = new UserDataSetTableAdapters.System_Users_ObsTableAdapter();
UserDataSet.System_Users_ObsDataTable dataTable_Obs = User_obs.GetDataUser_ObsById(IdUsuario);
_row = (UserDataSet.System_UsersRow)dataTable.Rows[0];
RaisePropertyChanged(nameof(Name));
RaisePropertyChanged(nameof(Phone));
RaisePropertyChanged(nameof(FullName));
RaisePropertyChanged(nameof(Email));
RaisePropertyChanged(nameof(Enabled));
_row_obs = (UserDataSet.System_Users_ObsRow)dataTable_Obs.Rows[0];
RaisePropertyChanged(nameof(Observations));
}
FormLoadFinished?.Invoke();
}
catch (Exception e)
{
FormLoadError?.Invoke(e);
}
}
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 Load(int IdProduct)
{
try
{
ProductDataSet dataset = new ProductDataSet();
ProductDataSetTableAdapters.ProductsTableAdapter TableProduct = new ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable dataTable = TableProduct.GetDataProductById(IdProduct);
if (dataTable.Rows.Count > 0)
{
ProductDataSetTableAdapters.Products_ObsTableAdapter Product_obs = new ProductDataSetTableAdapters.Products_ObsTableAdapter();
ProductDataSet.Products_ObsDataTable dataTable_Obs = Product_obs.GetDataProductr_ObsById(IdProduct);
_row = (ProductDataSet.ProductsRow)dataTable.Rows[0];
RaisePropertyChanged(nameof(Name));
RaisePropertyChanged(nameof(Code));
RaisePropertyChanged(nameof(Density));
RaisePropertyChanged(nameof(MeasureUnit));
RaisePropertyChanged(nameof(Enabled));
_row_obs = (ProductDataSet.Products_ObsRow)dataTable_Obs.Rows[0];
RaisePropertyChanged(nameof(Observations));
}
FormLoadFinished?.Invoke();
}
catch (Exception e)
{
FormLoadError?.Invoke(e);
}
}
public void Load(int IdColor, TextBox textboxFactoryColor, TextBox textboxClientColor, TextBox textboxUrgentColor, TextBox textboxFinalDayColor, TextBox textboxPreferenceColor, TextBox textboxTheLastPreferent, ColorPicker ClrPcker_Background, ColorPicker ClrPcker_Background1, ColorPicker ClrPcker_Background2, ColorPicker ClrPcker_Background3, ColorPicker ClrPcker_Background4, ColorPicker ClrPcker_Background5)
{
AssignTextBox(textboxFactoryColor, textboxClientColor, textboxUrgentColor, textboxFinalDayColor, textboxPreferenceColor, textboxTheLastPreferent);
try
{
ColorDataSet dataset = new ColorDataSet();
ColorDataSetTableAdapters.Factories_ColorsTableAdapter TableFactoriesColors = new ColorDataSetTableAdapters.Factories_ColorsTableAdapter();
ColorDataSet.Factories_ColorsDataTable dataTable = TableFactoriesColors.GetDataColorsById(IdColor);
if (dataTable.Rows.Count > 0)
{
ColorDataSetTableAdapters.FactoriesTableAdapter factoryname = new ColorDataSetTableAdapters.FactoriesTableAdapter();
ColorDataSet.FactoriesDataTable dataTable_name = factoryname.GetDataById(IdColor);
_row = (ColorDataSet.Factories_ColorsRow)dataTable.Rows[0];
RaisePropertyChanged(nameof(ClientColor));
RaisePropertyChanged(nameof(FactoryColor));
RaisePropertyChanged(nameof(PreferenceColor));
RaisePropertyChanged(nameof(UrgentColor));
RaisePropertyChanged(nameof(FinalDayColor));
RaisePropertyChanged(nameof(TheLastPreferent));
//incializamos las barras con el color
textboxFactoryColor.Background = (SolidColorBrush)(new BrushConverter().ConvertFrom(_row.FactoryColor.ToString().Trim()));
textboxClientColor.Background = (SolidColorBrush)(new BrushConverter().ConvertFrom(_row.ClientColor.ToString().Trim()));
textboxUrgentColor.Background = (SolidColorBrush)(new BrushConverter().ConvertFrom(_row.UrgentColor.ToString().Trim()));
textboxFinalDayColor.Background = (SolidColorBrush)(new BrushConverter().ConvertFrom(_row.FinalDayColor.ToString().Trim()));
textboxPreferenceColor.Background = (SolidColorBrush)(new BrushConverter().ConvertFrom(_row.PreferenceColor.ToString().Trim()));
textboxTheLastPreferent.Background = (SolidColorBrush)(new BrushConverter().ConvertFrom(_row.TheLastPreferent.ToString().Trim()));
_rowName = (ColorDataSet.FactoriesRow)dataTable_name.Rows[0];
_rowCode = (ColorDataSet.FactoriesRow)dataTable_name.Rows[0];
RaisePropertyChanged(nameof(Name));
RaisePropertyChanged(nameof(Code));
}
FormLoadFinished?.Invoke();
}
catch (Exception e)
{
FormLoadError?.Invoke(e);
}
}
public void Load(long IdOrder)
{
try
{
OrderDataSet dataset = new OrderDataSet();
OrderDataSetTableAdapters.OrdersTableAdapter TableOrder = new OrderDataSetTableAdapters.OrdersTableAdapter();
OrderDataSet.OrdersDataTable dataTable = TableOrder.GetDataOrderById(IdOrder);
if (dataTable.Rows.Count > 0)
{
OrderDataSetTableAdapters.Orders_ObsTableAdapter order_obs = new OrderDataSetTableAdapters.Orders_ObsTableAdapter();
OrderDataSet.Orders_ObsDataTable dataTable_Obs = order_obs.GetDataOrder_ObsById(IdOrder);
_row = (OrderDataSet.OrdersRow)dataTable.Rows[0];
RaisePropertyChanged(nameof(Reference));
RaisePropertyChanged(nameof(OperatorCode));
RaisePropertyChanged(nameof(ClientCode));
RaisePropertyChanged(nameof(ProductCode));
RaisePropertyChanged(nameof(FactoryCode));
RaisePropertyChanged(nameof(ClientId));
RaisePropertyChanged(nameof(Address));
RaisePropertyChanged(nameof(City));
RaisePropertyChanged(nameof(PostCode));
RaisePropertyChanged(nameof(FromDate));
RaisePropertyChanged(nameof(ToDate));
RaisePropertyChanged(nameof(ProductId));
RaisePropertyChanged(nameof(VehicleSize));
RaisePropertyChanged(nameof(RequestedAmount));
RaisePropertyChanged(nameof(Status));
//Cargamos datos
LoadDatasInterface(_row.ProductId, _row.OperatorId, _row.ClientId, _row.FactoryId);
_row_obs = (OrderDataSet.Orders_ObsRow)dataTable_Obs.Rows[0];
RaisePropertyChanged(nameof(Description));
RaisePropertyChanged(nameof(Observation));
}
FormLoadFinished?.Invoke();
}
catch (Exception e)
{
FormLoadError?.Invoke(e);
}
}