public void updateEventService(BALEventService obj) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "spUpdateEventService"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@eventserviceid", obj.ServicePackageID); cmd.Parameters.AddWithValue("@eventplanid", obj.EventPlanID); cmd.Parameters.AddWithValue("@servicepackageid", obj.ServicePackageID); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void updateEventServiceQuantity(BALEventService obj) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "spUpdateEventServiceQuantity"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@eventserviceid", obj.EventServiceID); cmd.Parameters.AddWithValue("@servicepackagequantity", obj.ServicePackageQuantity); cmd.Parameters.AddWithValue("@servicepackageamount", obj.ServicePackageAmount); cmd.Parameters.AddWithValue("@servicepackagetotalamount", obj.ServicePackageTotalAmount); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }