public NoteBookStatsWindow(NoteBookDetails details, int numOfPages, int wordCount)
{
InitializeComponent();
NameValueLabel.Content = details.Name;
DateOfCreationValueLabel.Content = details.DateOfCreation.ToString(CultureInfo.InvariantCulture);
DateOfLastModValueLabel.Content = details.DateOfLastOpen.ToString(CultureInfo.InvariantCulture);
DefaultLanguageValueLabel.Content = details.DefaultLanguage;
NumOfPagesValueLabel.Content = numOfPages.ToString();
WordCountValueLabel.Content = wordCount.ToString();
}
public NoteBookDetails Load(Int32 id)
{
sql = "SELECT * FROM " + table + " WHERE " + table + "ID = " + id;
db.Open();
command.Connection = db;
command.CommandText = sql;
SqlCeDataReader result = command.ExecuteReader();
NoteBookDetails data = new NoteBookDetails();
while (result.Read())
{
data = new NoteBookDetails(result.GetInt32(0), result.GetString(1), DateTime.Now.ToUniversalTime(), result.GetString(3), result.GetString(4));
}
db.Close();
return data;
}
public void Add(NoteBookDetails item)
{
db.Open();
command.Connection = db;
SqlCeResultSet result;
command.CommandType = CommandType.TableDirect;
command.CommandText = table;
result = command.ExecuteResultSet(ResultSetOptions.Scrollable | ResultSetOptions.Updatable);
result.Read();
SqlCeUpdatableRecord record = result.CreateRecord();
record.SetInt32(0, item.NoteBookID);
record.SetString(1, item.title);
record.SetDateTime(2, item.date);
record.SetString(3, item.publish);
record.SetString(4, item.category);
result.Insert(record, DbInsertOptions.PositionOnInsertedRow);
db.Close();
}
