public void updateEventStatus(BALEventPlan obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "spUpdateEventStatus";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@eventplanid", obj.EventPlanID);
cmd.Parameters.AddWithValue("@planstatus", obj.PlanStatus);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void updateEventPlan(BALEventPlan obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "spUpdateEventPlan";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@eventplanid", obj.EventPlanID);
cmd.Parameters.AddWithValue("@eventtypeid", obj.EventTypeID);
cmd.Parameters.AddWithValue("@eventstartdate", obj.EventStartDate);
cmd.Parameters.AddWithValue("@totaldays", obj.TotalDays);
cmd.Parameters.AddWithValue("@budgetamount", obj.BudgetAmount);
cmd.Parameters.AddWithValue("@aboutplan", obj.AboutPlan);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
