public override IBaseItem Get(IBaseItem item) { string mySql = string.Empty; IBlogEntry myEntry = item as IBlogEntry; IList<string> myValues = new List<string>(); if (item.Id == null) { myValues.Add(myEntry.Title); myValues.Add(myEntry.Subtitle); myValues.Add(myEntry.DateCreated.ToString()); mySql = FillItem(GET_SQL_NO_ID, myValues); } else { myValues.Add(myEntry.Id.ToString()); mySql = FillItem(GET_SQL_ID, myValues); } using (SqlCeConnection myConnection = DataAccess.Connection()) { myConnection.Open(); using (SqlCeCommand myCommand = myConnection.CreateCommand()) { myCommand.CommandText = mySql; using (SqlCeDataReader myReader = myCommand.ExecuteReader()) { while (myReader.Read()) { myEntry = new BlogEntry(); myEntry.Id = Convert.ToInt32(myReader[FIELD_ID]); myEntry.Title = myReader[FIELD_TITLE].ToString(); myEntry.Subtitle = myReader[FIELD_SUBTITLE].ToString(); myEntry.Content = myReader[FIELD_CONTENT].ToString(); myEntry.DateCreated = DateTime.Parse(myReader[FIELD_CREATED].ToString()); myEntry.CreatedBy = myReader[FIELD_CREATED_BY].ToString(); } } myConnection.Close(); } } return myEntry; }
public override IEnumerable<IBaseItem> GetRows(IBaseItem item) { List<IBlogEntry> myEntries = new List<IBlogEntry>(); using (SqlCeConnection myConnection = DataAccess.Connection()) { myConnection.Open(); using (SqlCeCommand myCommand = myConnection.CreateCommand()) { myCommand.CommandText = GET_ROWS_SQL; using (SqlCeDataReader myReader = myCommand.ExecuteReader()) { while (myReader.Read()) { IBlogEntry myEntry = new BlogEntry(); myEntry.Id = Convert.ToInt32(myReader[FIELD_ID]); myEntry.Title = myReader[FIELD_TITLE].ToString(); myEntry.Subtitle = myReader[FIELD_SUBTITLE].ToString(); myEntry.Content = myReader[FIELD_CONTENT].ToString(); myEntry.DateCreated = DateTime.Parse(myReader[FIELD_CREATED].ToString()); myEntry.CreatedBy = myReader[FIELD_CREATED_BY].ToString(); myEntries.Add(myEntry); } } myConnection.Close(); } } return myEntries; }