Example #1
0
        public string updateString(string id, courseUpdate course)
        {
            if (id == null || id.Length <= 0)
            {
                return("courseIdNull");
            }
            Guid courseId = new Guid(id);

            return(update(courseId, course));
        }
Example #2
0
        public string update(Guid id, courseUpdate course)
        {
            try
            {
                SqlConnection con = new SqlConnection(data);
                SqlCommand    cmd = new SqlCommand("UPDATE courseData SET "
                                                   + " status = @status, "
                                                   + " information = @information, "
                                                   + " price = @price, "
                                                   + " currency = @currency, "
                                                   + " duration = @duration, "
                                                   + " durationUnit = @durationUnit "
                                                   + " WHERE courseId = @courseId"
                                                   , con);
                cmd.Parameters.AddWithValue("@status", course.status);
                cmd.Parameters.AddWithValue("@information", course.information);
                cmd.Parameters.AddWithValue("@price", course.price);
                cmd.Parameters.AddWithValue("@currency", course.currency);
                cmd.Parameters.AddWithValue("@duration", course.duration);
                cmd.Parameters.AddWithValue("@durationUnit", course.durationUnit);
                cmd.Parameters.AddWithValue("@courseId", id);

                con.Open();

                cmd.ExecuteNonQuery();

                con.Close();
                return("Success");
            }
            catch (SqlException ex)
            {
                return(ex.ToString());
            }
            catch
            {
                return("Error");
            }
        }
Example #3
0
            public string courseUpdate(courseClass list)
            {
                courseUpdate  update   = new courseUpdate();
                IcourseClient client   = new IcourseClient();
                string        response = "Error";

                try
                {
                    update.status       = list.status;
                    update.information  = list.information;
                    update.price        = list.price;
                    update.currency     = list.currency;
                    update.duration     = list.duration;
                    update.durationUnit = list.durationUnit;

                    response = client.updateString(list.courseId.ToString(), update);
                }
                catch
                {
                    //  Error
                }

                return(response);
            }