public Course_elearn create_elearnCourse(Course_elearn course) { SqlConnection conn = new SqlConnection(); Course_elearn toReturn = null; try { conn = new SqlConnection(); string connstr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString(); conn.ConnectionString = connstr; conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "insert into [Elearn_course] " + "(elearn_courseName, elearn_courseProvider, entry_date, start_date, expiry_date, status, description, categoryID, courseCreator, hoursAwarded, targetAudience, courseType) OUTPUT INSERTED.elearn_courseID " + "values (@cName, @provider, Convert(datetime, @entry, 103), convert(datetime,@time,103), Convert(datetime,@expiry,103), @status, @desc, @category, @courseCreator, @hoursAwarded, @targetAudience, @courseType)"; comm.Parameters.AddWithValue("@cName", course.getCourseName()); if (course.getCourseProvider() != null) { comm.Parameters.AddWithValue("@provider", course.getCourseProvider()); } else { comm.Parameters.AddWithValue("@provider", DBNull.Value); } comm.Parameters.AddWithValue("@entry", course.getEntryDate()); if (course.getStartDate() == null) { comm.Parameters.AddWithValue("@time", DBNull.Value); } else { comm.Parameters.AddWithValue("@time", course.getStartDate()); } if (course.getExpiryDate() == null) { comm.Parameters.AddWithValue("@expiry", DBNull.Value); } else { comm.Parameters.AddWithValue("@expiry", course.getExpiryDate()); } comm.Parameters.AddWithValue("@status", course.getStatus()); comm.Parameters.AddWithValue("@desc", course.getDescription()); comm.Parameters.AddWithValue("@category", course.getCategoryID()); comm.Parameters.AddWithValue("@courseCreator", course.getCourseCreator().getUserID()); comm.Parameters.AddWithValue("@hoursAwarded", course.getHoursAwarded()); comm.Parameters.AddWithValue("@targetAudience", course.getTargetAudience()); comm.Parameters.AddWithValue("@courseType", course.getCourseType()); int a = (Int32)comm.ExecuteScalar(); //need new method to create pre-requisities here to store in seperate table (pre-req table) course.setCourseID(a); toReturn = course; } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }