public Form2(ToDoListItem item)
{
InitializeComponent();
TaskTypes2.DropDownStyle = ComboBoxStyle.DropDownList;
this.item = item;
Edit();
}
private void UpdateColors(ToDoListItem toDoListItem, ListViewItem item)
{
DateTime dt;
if (DateTime.TryParse(toDoListItem.date, out dt))
{
TimeSpan difference = dt - DateTime.Now;
item.SubItems.Add(difference.Days.ToString());
if (item.Checked)
{
item.BackColor = Color.White;
item.ForeColor = Color.Gray;
}
else
{
item.ForeColor = Color.Black;
if (difference.TotalDays > 1)
{
item.BackColor = Color.Green;
}
else if (difference.TotalDays >= 0)
{
item.BackColor = Color.Yellow;
}
else
{
item.BackColor = Color.Red;
}
}
}
}
private void loadTaskFromDatabase()
{
using (SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Roba\Documents\Visual Studio 2013\Projects\Todo+duomb\WindowsFormsApplication6\Database.mdf;Integrated Security=True"))
{
con.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM list", con))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
bool check = reader.GetBoolean(1);
string type = reader.GetString(2);
string task = reader.GetString(3);
string date = reader.GetString(4);
ToDoListItem todo = new ToDoListItem(check, id, type, task, date);
list.AddLast(todo);
}
}
}
refreshTaskView();
}
private void AddTask_Click(object sender, EventArgs e)
{
ToDoListItem todo = new ToDoListItem(false, 0, "", "", "");
Form2 secondForm = new Form2(todo);
if (secondForm.ShowDialog(this) == DialogResult.OK)
{
var item = new ListViewItem();
item.Tag = todo;
item.Checked = todo.check;
item.SubItems.Add(todo.type);
item.SubItems.Add(todo.todo);
if (!String.IsNullOrEmpty(todo.date))
{
DateTime temp;
if (DateTime.TryParse(todo.date, out temp))
{
DateTime dt = DateTime.Parse(todo.date);
TimeSpan difference = dt - DateTime.Now;
item.SubItems.Add(todo.date);
item.SubItems.Add(difference.Days.ToString());
}
}
list.AddLast(todo);
listView1.Items.Add(item);
refreshTaskView();
writeTasksToDatabase();
}
}
private void loadTaskFile()
{
ToDoListItem todo = new ToDoListItem(false, 0, "", "", "");
XmlDocument doc = new XmlDocument();
if (new FileInfo("todo.xml").Length < 10)
{
return;
}
doc.Load("todo.xml");
XmlNodeList elemList = doc.GetElementsByTagName("ToDo");
list.Clear();
foreach(XmlNode element in elemList)
{
string check = element["Check"].InnerText;
string taskNumber = element["TaskNumber"].InnerText;
string taskType = element["TaskType"].InnerText;
string task = element["Task"].InnerText;
string date = element["Date"].InnerText;
int num = Convert.ToInt32(taskNumber);
bool ch = Convert.ToBoolean(check);
ToDoListItem ToDoItem = new ToDoListItem( ch, num, taskType, task, date);
list.AddLast(ToDoItem);
}
refreshTasksView();
doc.Save("todo.xml");
}