public static void InsertData(IVA_Table iva) { using (var context = new LojaDBEntities()) { context.IVA_Table.Add(iva); context.SaveChanges(); } }
public static void UpdateData(IVA_Table iva) { using (var context = new LojaDBEntities()) { context.Entry(iva).State = EntityState.Modified; context.SaveChanges(); } }
//generate modal labels and inputs public static Grid GetInputModal(String action, IVA_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); //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 labelIva = new Label(); labelIva.Content = "IVA:"; Grid.SetRow(labelIva, 0); Grid.SetColumn(labelIva, 0); Label labelDescricao = new Label(); labelDescricao.Content = "Descrição"; Grid.SetRow(labelDescricao, 1); Grid.SetColumn(labelDescricao, 0); //Input's definition TextBox inputIva = new TextBox(); if (table != null) { inputIva.Text = table.IVA.ToString(); } inputIva.TextAlignment = TextAlignment.Center; Grid.SetRow(inputIva, 0); Grid.SetColumn(inputIva, 1); TextBox inputDescricao = new TextBox(); if (table != null) { inputDescricao.Text = table.Descrição.ToString(); } inputDescricao.TextAlignment = TextAlignment.Center; Grid.SetRow(inputDescricao, 1); Grid.SetColumn(inputDescricao, 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, 2); Grid.SetColumn(cancelButton, 0); Button okButton = new Button(); okButton.Content = "OK"; okButton.Click += (sender, e) => { int error = 0; IVA_Table iva = new IVA_Table(); if (inputIva.Text.Length > 0 && int.TryParse(inputIva.Text, out int ivaValor)) { if (table != null) { table.IVA = ivaValor; } else { iva.IVA = ivaValor; } } else { error++; } if (inputDescricao.Text.Length > 0) { if (table != null) { table.Descrição = inputDescricao.Text; } else { iva.Descrição = inputDescricao.Text; } } else { error++; } if (error < 1) { if (action == "Adicionar") { InsertData(iva); } if (action == "Editar") { UpdateData(table); } Grid tempGrid = (Grid)gridPanel.Parent; Window tempWindow = (Window)tempGrid.Parent; tempWindow.Close(); } }; Grid.SetRow(okButton, 2); Grid.SetColumn(okButton, 1); //grid's append gridPanel.Children.Add(labelIva); gridPanel.Children.Add(labelDescricao); gridPanel.Children.Add(inputIva); gridPanel.Children.Add(inputDescricao); gridPanel.Children.Add(okButton); gridPanel.Children.Add(cancelButton); return(gridPanel); }