public int AddDecorationItem(DecorationList Emp) { SqlConnection connection = new SqlConnection("Server=Tanmoy-pc; Database=Wedding Management; User Id=sa; Password=1238628257"); connection.Open(); string query = "INSERT INTO DecorationList(item, type, cost ) VALUES('" + Emp.DecorationItem + "', '" + Emp.DecorationType + "', '" + Emp.DecorationCost + "')"; SqlCommand cmd = new SqlCommand(query, connection); int i = cmd.ExecuteNonQuery(); connection.Close(); return(i); }
private void decorationAddButton_Click(object sender, RoutedEventArgs e) { string item = Convert.ToString(itemTextBox.Text); string type = Convert.ToString(typeTextBox.Text); string cost = Convert.ToString(costTextBox.Text); Decoration.DecorationList Dl = new Decoration.DecorationList(item, type, cost); Decoration.DecorationService S1 = new DecorationService(); int i = S1.AddDecorationItem(Dl); if (i == 1) { Close(); } }