public static string cancel_app1(appointment_mg name) { string query = string.Format("select app_id from appointment inner join employee_doctor on employee_doctor.emp_doc_id = appointment.emp_doc_id where employee_doctor.emp_doc_name = '{0}'", name.emp_doc_name); try { conn.Open(); command.CommandText = query; // string app_id = command.ExecuteScalar().ToString(); int app_id = (int)command.ExecuteScalar(); query = String.Format("Update appointment set status_approve = 0,status_app = 0 where app_id = {0}", app_id); // conn.Open(); command.CommandText = query; command.ExecuteNonQuery(); return("อัพเดตข้อมูลเรียบร้อย"); } finally { conn.Close(); } // return null; }
public static string cancel_app(appointment_mg app) { try { string query = String.Format("Update appointment set status_approve = 0,status_app = 0 where app_id = {0}", app.app_id); conn.Open(); command.CommandText = query; command.ExecuteNonQuery(); return("อัพเดตข้อมูลเรียบร้อย"); } finally { conn.Close(); } }