public ColorFormViewModel()
{
ColorDataSet dataset = new ColorDataSet();
ColorDataSetTableAdapters.Factories_ColorsTableAdapter FactoryColors = new ColorDataSetTableAdapters.Factories_ColorsTableAdapter();
ColorDataSetTableAdapters.FactoriesTableAdapter factoryname = new ColorDataSetTableAdapters.FactoriesTableAdapter();
_row = dataset.Factories_Colors.NewFactories_ColorsRow();
_rowName = dataset.Factories.NewFactoriesRow();
_rowCode = dataset.Factories.NewFactoriesRow();
//colores factorias
_row.ClientColor = "";
_row.FactoryColor = "";
_row.PreferenceColor = "";
_row.UrgentColor = "";
_row.FinalDayColor = "";
_row.TheLastPreferent = "";
_row.Id = 0;
//nombre factoría
_rowName.Name = "";
//codigo factoría
_rowCode.Code = "";
SaveCommand = new RelayCommand(Save, CanSave);
}
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 Save()
{
bool validate = true;
try
{
ColorDataSet dataset = new ColorDataSet();
ColorDataSetTableAdapters.Factories_ColorsTableAdapter TableFactoriesColors = new ColorDataSetTableAdapters.Factories_ColorsTableAdapter();
if (validate)
{
ColorDataSet.Factories_ColorsDataTable dataTable = TableFactoriesColors.GetDataColorsById(_row.Id);
//actualizamnos si existe el registro
if (dataTable.Rows.Count > 0)
{
var rowFactorisColors = dataset.Factories_Colors.NewFactories_ColorsRow();
rowFactorisColors = dataTable[0];
rowFactorisColors["ClientColor"] = GlobaltextboxClientColor.Text.Trim();
rowFactorisColors["FactoryColor"] = GlobaltextboxFactoryColor.Text.Trim();
rowFactorisColors["PreferenceColor"] = GlobaltextboxPreferenceColor.Text.Trim();
rowFactorisColors["UrgentColor"] = GlobaltextboxUrgentColor.Text.Trim();
rowFactorisColors["FinalDayColor"] = GlobaltextboxFinalDayColor.Text.Trim();
rowFactorisColors["TheLastPreferent"] = GlobaltextboxTheLastPreferent.Text.Trim();
int numeroderegistros = TableFactoriesColors.Update(rowFactorisColors);
}
/*
* else
* {
* TableFactoriesColors = new ColorDataSetTableAdapters.Factories_ColorsTableAdapter();
* //obtenemos de la tabla factories_colors el nuevo registro que se introducira
* var rowFactoriesColors = dataset.Factories_Colors.NewFactories_ColorsRow();
*
* //ClientColor
* rowFactoriesColors.ClientColor = _row.ClientColor;
* //FactoryColor
* rowFactoriesColors.FactoryColor = _row.FactoryColor;
* //PreferenceColor
* rowFactoriesColors.PreferenceColor = _row.PreferenceColor;
* //UrgentColor
* rowFactoriesColors.UrgentColor = _row.UrgentColor;
* //FinalDayColor
* rowFactoriesColors.FinalDayColor = _row.FinalDayColor;
* //thelastPreference
* rowFactoriesColors.TheLastPreferent = _row.TheLastPreferent;
*
* //agregamos la nueva fila
* dataset.Factories_Colors.AddFactories_ColorsRow(rowFactoriesColors);
* //actualizamos la tabla factories_colors en el dataset
* TableFactoriesColors.Update(dataset.Factories_Colors);
*
* }
*/
FormSaveFinished?.Invoke();
}
}
catch (Exception e)
{
FormSaveError?.Invoke(e);
}
}
