private void EventDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
//MessageBox.Show("Changed");
if (e.AddedItems.Count > 0)
{
EventList.EventsList p = (EventList.EventsList)e.AddedItems[0];
EventIdTexBox.Text = p.EventId;
}
}
public int AddEvent(EventsList EL)
{
SqlConnection connection = new SqlConnection("Server=Tanmoy-pc; Database=Wedding Management; User Id=sa; Password=1238628257");
connection.Open();
string query = "INSERT INTO EventList(EventId,EventDate,StartTime,PhotographyCost,DecorationCost,CenterCost,Vat,Discount,TotalCost,AdvancePayment,Remaining,CustomerName,CustomerContact, CustomerEmail,CustomerAddress,PackageId,PackageCost,EDate,PaymentStatus) VALUES('" + EL.EventId + "', '" + EL.EventDate + "', '" + EL.StartTime + "', '" + EL.PhotographyCost + "','" + EL.DecorationCost + "','" + EL.CenterCost + "','" + EL.Vat + "','" + EL.Discount + "','" + EL.TotalCost + "','" + EL.AdvancePayment + "','" + EL.Remaining + "','" + EL.CustomerName + "','" + EL.CustomerContactNo + "','" + EL.CustomerEmail + "','" + EL.CustomerAddress + "','" + EL.PackageId + "','" + EL.PackageCost + "','" + EventCalculation.date + "','" + EventCalculation.paymentStatus + "')";
SqlCommand cmd = new SqlCommand(query, connection);
int i = cmd.ExecuteNonQuery();
return(i);
}