/// <summary> /// This is a sample specific finder method for Entity1. /// If you want to delete or rename the method think about changing the xml in the BDC model file as well. /// </summary> /// <param name="id"></param> /// <returns>Entity1</returns> public static CornerStone_CourseCatalog ReadItem(string id) { //TODO: This is just a sample. Replace this simple sample with valid code. //CornerStone_CourseCatalog CourseCatolog = new CornerStone_CourseCatalog(); //entity1.Title = id; //entity1.Message = "Hello World"; //return entity1; SqlConnection conn = GetSQLConnection(); CornerStone_CourseCatalog CourseCatolog = new CornerStone_CourseCatalog(); try { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT Title,CreatedDate,Description,SubjectIDs,SubjectTitles,Price,ProviderName,Type,DeepLinkURL,CourseDuration,OUAvailability,LOTitles,LOInstructions,LOLocations,LOInstructors FROM CornerStone_CourseCatalog"; cmd.Connection = conn; SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (rdr.Read()) { CourseCatolog.Title = rdr[0] == null ? string.Empty : rdr[0].ToString(); CourseCatolog.CreatedDate = rdr[1] == null ? DateTime.MinValue : Convert.ToDateTime(rdr[1].ToString()); CourseCatolog.Description = rdr[2] == null ? string.Empty : rdr[2].ToString(); CourseCatolog.SubjectIDs = rdr[3] == null ? string.Empty : rdr[3].ToString(); CourseCatolog.SubjectTitles = rdr[4] == null ? string.Empty : rdr[4].ToString(); CourseCatolog.Price = rdr[5] == null ? 0 : Convert.ToDecimal(rdr[5].ToString()); CourseCatolog.Type = rdr[6] == null ? string.Empty : rdr[6].ToString(); CourseCatolog.DeepLinkURL = rdr[7] == null ? string.Empty : rdr[7].ToString(); CourseCatolog.CourseDuration = rdr[8] == null ? string.Empty : rdr[8].ToString(); CourseCatolog.OUAvailability = rdr[9] == null ? string.Empty : rdr[9].ToString(); CourseCatolog.LOTitles = rdr[10] == null ? string.Empty : rdr[10].ToString(); CourseCatolog.LOInstructions = rdr[11] == null ? string.Empty : rdr[11].ToString(); } } // conn.Dispose(); catch (Exception ex) { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Insert into IFDSLogs values ('" + ex.ToString() + "')"; cmd.ExecuteNonQuery(); return CourseCatolog; } finally { conn.Dispose(); } return CourseCatolog; }
/// <summary> /// This is a sample finder method for Entity1. /// If you want to delete or rename the method think about changing the xml in the BDC model file as well. /// </summary> /// <returns>IEnumerable of Entities</returns> public static IEnumerable<CornerStone_CourseCatalog> ReadList() { SqlConnection conn = GetSQLConnection(); CornerStone_CourseCatalog[] CourseCatologs = new CornerStone_CourseCatalog[0]; try { List<CornerStone_CourseCatalog> allCourseCatolog = new List<CornerStone_CourseCatalog>(); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT Title,CreatedDate,Description,SubjectIDs,SubjectTitles,Price,ProviderName,Type,DeepLinkURL,CourseDuration,OUAvailability,LOTitles,LOInstructions,LOLocations,LOInstructors FROM CornerStone_CourseCatalog"; cmd.Connection = conn; SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (rdr.Read()) { CornerStone_CourseCatalog CourseCatolog = new CornerStone_CourseCatalog(); CourseCatolog.Title = rdr[0] == null ? string.Empty : rdr[0].ToString(); CourseCatolog.CreatedDate = rdr[1] == null ? DateTime.MinValue : Convert.ToDateTime(rdr[1].ToString()); CourseCatolog.Description = rdr[2] == null ? string.Empty : rdr[2].ToString(); CourseCatolog.SubjectIDs = rdr[3] == null ? string.Empty : rdr[3].ToString(); CourseCatolog.SubjectTitles = rdr[4] == null ? string.Empty : rdr[4].ToString(); CourseCatolog.Price = rdr[5] == null ? 0 : Convert.ToDecimal(rdr[5].ToString()); CourseCatolog.Type = rdr[6] == null ? string.Empty : rdr[6].ToString(); CourseCatolog.DeepLinkURL = rdr[7] == null ? string.Empty : rdr[7].ToString(); CourseCatolog.CourseDuration = rdr[8] == null ? string.Empty : rdr[8].ToString(); CourseCatolog.OUAvailability = rdr[9] == null ? string.Empty : rdr[9].ToString(); CourseCatolog.LOTitles = rdr[10] == null ? string.Empty : rdr[10].ToString(); CourseCatolog.LOInstructions = rdr[11] == null ? string.Empty : rdr[11].ToString(); allCourseCatolog.Add(CourseCatolog); } CourseCatologs = new CornerStone_CourseCatalog[allCourseCatolog.Count]; for (int j = 0; j < allCourseCatolog.Count; j++) { CourseCatologs[j] = allCourseCatolog[j]; } return CourseCatologs; } catch (Exception ex) { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Insert into IFDSLogs values ('" + ex.ToString() + "')"; cmd.ExecuteNonQuery(); //CourseCatologs = new CornerStone_CourseCatalog[0]; //CornerStone_CourseCatalog CourseCatolog = new CornerStone_CourseCatalog(); //CourseCatolog.Title = "error"; //CourseCatolog.CreatedDate = DateTime.MinValue; //CourseCatolog.Description = "error"; //CourseCatolog.SubjectIDs = "error"; //CourseCatolog.SubjectTitles = "error"; //CourseCatolog.Price = 0; //CourseCatolog.Type = "error"; //CourseCatolog.DeepLinkURL = "error"; //CourseCatolog.CourseDuration = "error"; //CourseCatolog.OUAvailability = "error"; //CourseCatolog.LOTitles = "error"; //CourseCatolog.LOInstructions = "error"; //CourseCatologs[0] = CourseCatolog; //Customer customer = new Customer(); //customer.CustomerID = -1; //customer.CustomerName = "Not found"; //customer.City = ""; //customers[0] = customer; return CourseCatologs; } finally { conn.Dispose(); } //return allCustomers; }