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