示例#1
0
        public string delete(childDelete use)
        {
            string        response = "";
            SqlConnection con      = new SqlConnection(data);
            SqlCommand    cmd      = new SqlCommand("DELETE FROM CourseChild WHERE childId = @childId", con);

            cmd.Parameters.AddWithValue("@childId", use.childId);

            con.Open();
            try
            {
                cmd.ExecuteNonQuery();
                response = "Success";
                deleteOptions(use.childId, use.user);
            }
            catch (Exception ex)
            {
                response = ex.ToString();
                con.Close();
                return(response);
            }

            con.Close();

            try
            {
                parameterDeleteAll del = new parameterDeleteAll();
                del.childId = use.childId;
                del.creator = use.user;

                IparameterClient para = new IparameterClient();
                response = para.deleteAll(del);
            }
            catch (Exception ex)
            {
                response = ex.ToString();
            }

            return(response);
        }