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