public static void InsertData(Despesas_Table despesa) { using (var context = new LojaDBEntities()) { context.Despesas_Table.Add(despesa); context.SaveChanges(); } }
public static void UpdateData(Despesas_Table despesa) { using (var context = new LojaDBEntities()) { context.Entry(despesa).State = EntityState.Modified; context.SaveChanges(); } }
//generate modal labels and inputs public static Grid GetInputModal(String action, Despesas_Table table) { Grid gridPanel = new Grid { HorizontalAlignment = HorizontalAlignment.Stretch, VerticalAlignment = VerticalAlignment.Stretch }; //row's definition RowDefinition row = new RowDefinition(); row.Height = GridLength.Auto; gridPanel.RowDefinitions.Add(row); RowDefinition row2 = new RowDefinition(); row2.Height = GridLength.Auto; gridPanel.RowDefinitions.Add(row2); RowDefinition row3 = new RowDefinition(); row3.Height = GridLength.Auto; gridPanel.RowDefinitions.Add(row3); RowDefinition row4 = new RowDefinition(); row4.Height = GridLength.Auto; gridPanel.RowDefinitions.Add(row4); RowDefinition row5 = new RowDefinition(); row5.Height = GridLength.Auto; gridPanel.RowDefinitions.Add(row5); RowDefinition row6 = new RowDefinition(); row6.Height = GridLength.Auto; gridPanel.RowDefinitions.Add(row6); RowDefinition row7 = new RowDefinition(); row7.Height = GridLength.Auto; gridPanel.RowDefinitions.Add(row7); //colunms definition ColumnDefinition col = new ColumnDefinition(); col.Width = new GridLength(100, GridUnitType.Pixel); gridPanel.ColumnDefinitions.Add(col); ColumnDefinition col2 = new ColumnDefinition(); col2.Width = new GridLength(150, GridUnitType.Pixel); gridPanel.ColumnDefinitions.Add(col2); //Label's definition Label labelNome = new Label(); labelNome.Content = "Nome:"; Grid.SetRow(labelNome, 0); Grid.SetColumn(labelNome, 0); Label labelDescricao = new Label(); labelDescricao.Content = "Descrição"; Grid.SetRow(labelDescricao, 1); Grid.SetColumn(labelDescricao, 0); Label labelFactura = new Label(); labelFactura.Content = "Factura:"; Grid.SetRow(labelFactura, 2); Grid.SetColumn(labelFactura, 0); Label labelRetalho = new Label(); labelRetalho.Content = "Retalho:"; Grid.SetRow(labelRetalho, 3); Grid.SetColumn(labelRetalho, 0); Label labelValor = new Label(); labelValor.Content = "Valor:"; Grid.SetRow(labelValor, 4); Grid.SetColumn(labelValor, 0); Label labelData = new Label(); labelData.Content = "Data:"; Grid.SetRow(labelData, 5); Grid.SetColumn(labelData, 0); //Input's definition TextBox inputNome = new TextBox(); if (table != null) { inputNome.Text = table.Nome; } inputNome.TextAlignment = TextAlignment.Center; Grid.SetRow(inputNome, 0); Grid.SetColumn(inputNome, 1); TextBox inputDescricao = new TextBox(); if (table != null) { inputDescricao.Text = table.Descrição; } inputDescricao.TextAlignment = TextAlignment.Center; Grid.SetRow(inputDescricao, 1); Grid.SetColumn(inputDescricao, 1); CheckBox inputFactura = new CheckBox(); if (table != null) { inputFactura.IsChecked = table.Factura; } Grid.SetRow(inputFactura, 2); Grid.SetColumn(inputFactura, 1); CheckBox inputRetalho = new CheckBox(); if (table != null) { inputRetalho.IsChecked = table.Retalho; } Grid.SetRow(inputRetalho, 3); Grid.SetColumn(inputRetalho, 1); TextBox inputValor = new TextBox(); if (table != null) { inputValor.Text = table.Valor.ToString(); } inputValor.TextAlignment = TextAlignment.Center; Grid.SetRow(inputValor, 4); Grid.SetColumn(inputValor, 1); DatePicker inputData = new DatePicker(); Grid.SetRow(inputData, 5); Grid.SetColumn(inputData, 1); //button's definition Button cancelButton = new Button(); cancelButton.Content = "Cancelar"; cancelButton.Click += (sender, e) => { Grid tempGrid = (Grid)gridPanel.Parent; Window tempWindow = (Window)tempGrid.Parent; tempWindow.Close(); }; Grid.SetRow(cancelButton, 6); Grid.SetColumn(cancelButton, 0); Button okButton = new Button(); okButton.Content = "OK"; okButton.Click += (sender, e) => { int error = 0; Despesas_Table despesa = new Despesas_Table(); if (inputNome.Text.Length > 0) { if (table != null) { table.Nome = inputNome.Text; } else { despesa.Nome = inputNome.Text; } } else { error++; } if (inputDescricao.Text.Length > 0) { if (table != null) { table.Descrição = inputDescricao.Text; } else { despesa.Descrição = inputDescricao.Text; } } else { error++; } if (table != null) { table.Factura = inputFactura.IsChecked; } else { despesa.Factura = inputFactura.IsChecked; } if (table != null) { table.Retalho = inputRetalho.IsChecked; } else { despesa.Retalho = inputRetalho.IsChecked; } if (inputValor.Text.Length > 0 && float.TryParse(inputValor.Text, out float valor)) { if (table != null) { table.Valor = valor; } else { despesa.Valor = valor; } } else { error++; } if (inputData.SelectedDate != null) { if (table != null) { table.Data = inputData.SelectedDate; } else { despesa.Data = inputData.SelectedDate; } } if (error < 1) { if (action == "Adicionar") { InsertData(despesa); } if (action == "Editar") { UpdateData(table); } Grid tempGrid = (Grid)gridPanel.Parent; Window tempWindow = (Window)tempGrid.Parent; tempWindow.Close(); } }; Grid.SetRow(okButton, 6); Grid.SetColumn(okButton, 1); //grid's append gridPanel.Children.Add(labelNome); gridPanel.Children.Add(labelDescricao); gridPanel.Children.Add(labelFactura); gridPanel.Children.Add(labelRetalho); gridPanel.Children.Add(labelValor); gridPanel.Children.Add(labelData); gridPanel.Children.Add(inputNome); gridPanel.Children.Add(inputDescricao); gridPanel.Children.Add(inputFactura); gridPanel.Children.Add(inputRetalho); gridPanel.Children.Add(inputValor); gridPanel.Children.Add(inputData); gridPanel.Children.Add(okButton); gridPanel.Children.Add(cancelButton); return(gridPanel); }