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