Tasks performed:

Downloaded and installed Visual Studio 2008 and SQLite engine to my desktop. Updated settings in VS to work with SQLite.

Reminded myself about usage of VS2008, eg. forms, properties, design, coding.

Followed instructions from lectures and tutorials for creating a test database and code.

Followed lecture notes for C++ specifics.

Problems encountered:

Encountered problems while installing SQLite without any training but figured out everything when checked lecture notes.

Tasks performed:

Thinking about the program I have created few prototypes of user interfaces. Of course these are not complete but at the moment I can see them like drawn.

Researched for any examples of C++ with sql.

Updated this post with basic UML class diagram for the application and state machine diagram for the contacts form. Please find attached documents.

Used MagicDraw experience to create some diagrams which can be seen on the right.

Problems encountered:

Visual studio helps a lot with the graphical user interfase as the programmer do not need to write the code manually to create windows forms.

Lecture notes, tutorial exercises

Various websites from google search

Prototypes of the user interfaces in different forms:

UML Diagrams:

Tasks performed:

Decided to do only one form with a tabs like contacts, diary and memos. Included the one I have created.

Figured out how to create my database when application sarts or open already created one and load contacts into the DataGrid:

public ref class Form1 : public System::Windows::Forms::Form
{
public:
Form1(void)
{
InitializeComponent();
//Creating sqlite tables

SQLiteConnection^ newConnection = gcnew SQLiteConnection("Data Source=anotherdatabase.db3");
newConnection->Open();
SQLiteCommand^ newCommand = gcnew SQLiteCommand(newConnection);
try//trying to create new table, if no exists
{
newCommand->CommandText = String::Format("create table {0}(" +
" ID integer not null primary key autoincrement," +
" Name text," +
" Phone text," +
" Birthday)",
"Adresses");
newCommand->ExecuteNonQuery();
}
catch (SQLiteException^)
{
MessageBox::Show("Table already exists","Failed creating new DB");
}
//Writing Tables into dataGridView
newCommand =gcnew SQLiteCommand("SELECT * FROM Contacts ", newConnection);
newCommand->CommandType = CommandType::Text;
SQLiteDataAdapter^ newDataAdapter = gcnew SQLiteDataAdapter(newCommand);
DataSet^ dataSet = gcnew DataSet();
newDataAdapter->Fill(dataSet, "Contacts");
dataGridView3->RowCount=1;
dataGridView1->DataSource = dataSet->Tables["Contacts"];
newConnection->Close();
}

Problems encountered:

Because I am a beginner in C++ and SQLite I have had and will have a lot of difficulties while programming but as I have some backgrounds in programming in VB, Java, php I will try to solve any difficulties and refere to various information sources for the help and support.

Tasks performed:

Decided to do only one form with a tabs like contacts, diary and memos. Included the one I have created.

Updated my contact list tab to work with SQLite. All the buttons works perfectly so I can add, edit, delete a contact in my application now.

//Adding a contact
SQLiteConnection^ saveConnection=gcnew SQLiteConnection("Data Source=anotherdatabase.db3");
saveConnection->Open();
SQLiteCommand^ saveCommand=gcnew SQLiteCommand(saveConnection);

saveCommand->CommandText=String::Format("insert into Contacts (Name,Phone,Birthday) values('{0}','{1}','{2}') ",
this->dataGridView3->Rows[0]->Cells[0]->Value->ToString(), this->dataGridView3->Rows[0]->Cells[1]->Value->ToString(), this->dataGridView3->Rows[0]->Cells[2]->Value->ToString());
saveCommand->ExecuteNonQuery();

saveConnection->Close();

//Deletion
SQLiteConnection^ deleteConnection=gcnew SQLiteConnection("Data Source=anotherdatabase.db3");
deleteConnection->Open();
SQLiteCommand^ deleteCommand =gcnew SQLiteCommand(deleteConnection);
deleteCommand->CommandText = String::Format("delete from Contacts where id="+textBox1->Text->ToString());
deleteCommand->ExecuteNonQuery();
deleteConnection->Close();

Problems encountered:

The coding part of the project can't exist without errors and mistakes. I am solving them on the go and there will be a large list if I will write all the problems and solutions here.

I was advised by course tutor to implement some idea - a scenario into my project to have higher value and to be more business oriented. For quite a while I was choosing a scenario and decided why not to do a program for students which will help them to organise their student life more efficiently. I have thought of some functionality which will be more specific for students but still the application will be pretty much the same. The difference will make some categories related to courses, course works, examinations and possibly teaching staff.

I have designed in VisualStudio more tabs with some information in them like buttons, text boxes, combo boxes. Played around with different attributes to remind myself what is what as I was working a lot in Visual studio last year while doing team project where I was the main programmer. That was a very useful experience which helps me with this project a lot.

I have attached a screen shot to show you my current progress.

Quite exhaustive work it is. Started coding of the buttons, hiding/showing them where needed. Also declared variables to be used in methods and constructors. Managed to create database connections for diary and events. Now I can save everything to the database.

Code for saving a note to the diary:

private: System::Void button1_Click_2(System::Object^ sender, System::EventArgs^ e) {

SQLiteConnection^ iConnection=gcnew SQLiteConnection("Data Source=anotherdatabase.db3");
iConnection->Open();
SQLiteCommand^ iCommand =gcnew SQLiteCommand(iConnection);
iCommand->CommandText=String::Format("UPDATE Notice SET Fill = '"+richTextBox2->Text->ToString()+"' WHERE Fill='"+dataGridView4->Rows[0]->Cells[0]->Value->ToString()+"'");
iCommand->ExecuteNonQuery();
}

Works fine but still need to manage deletion process and think about how events will be handled.

Did not have major problems with coding but there were many silly mistakes in spelling or syntax.

Managed to do the database part. can add, edit and delete a contact, add a note to diary, add and remove events.

Started playing around with dynamic arrays and that is far not the easiest part of the project. Tried to load data from the database to put it into array but just waisted my time. Error after error. Will do some more research next week for better understanding.

After spending dozens of time on understanding dynamicity of C++ I have managed to do something useful for my application.

Completed the design of my application. Made all the buttons clearly visible and understandable.