public void createTodaysTasks() { //if todays tasklist has not yet been generated do it now dataBase db = new dataBase(); XmlDocument xdoc = new XmlDocument(); FileStream rfile = new FileStream(path + @"tasks\tasklist.xml", FileMode.Open); xdoc.Load(rfile); XmlNodeList list = xdoc.GetElementsByTagName("task"); for (int i = 0; i < list.Count; i++) { XmlElement taskName = (XmlElement)xdoc.GetElementsByTagName("task_name")[i]; XmlElement frequency = (XmlElement)xdoc.GetElementsByTagName("frequency")[i]; if (frequency.InnerText == "daily") { ArrayList element = new ArrayList(); ArrayList text = new ArrayList(); //the name of the xml element to be added element.Add("date"); //the text inside the xml element to be added text.Add(fileNameDate); //the name of the xml element to be added element.Add("task"); //the text inside the xml element to be added text.Add(taskName.InnerText); //the description text of the xml element to be added element.Add("description"); //the xml text to be added text.Add(""); //the description text of the xml element to be added element.Add("completed"); //the text inside the xml element to be added text.Add("false"); //save each task as an xml element db.write(path + fileNameDate + ".xml", element, text, "tasks"); } } rfile.Close(); }
public void addContractorVisitToXml(string company, string description) { dataBase db = new dataBase(); XmlDocument xdoc = new XmlDocument(); FileStream rfile = new FileStream(path + @"contractors\lists\contractors.xml", FileMode.Open); xdoc.Load(rfile); XmlNodeList list = xdoc.GetElementsByTagName("contractor"); for (int i = 0; i < list.Count; i++) { XmlElement xCompany = (XmlElement)xdoc.GetElementsByTagName("company")[i]; if (xCompany.InnerText == company) { XmlElement xName = (XmlElement)xdoc.GetElementsByTagName("name")[i]; ArrayList element = new ArrayList(); ArrayList text = new ArrayList(); //the name of the xml element to be added element.Add("name"); //the text inside the xml element to be added text.Add(xName.InnerText); //the name of the xml element to be added element.Add("company"); //the text inside the xml element to be added text.Add(xCompany.InnerText); //the description text of the xml element to be added element.Add("description"); //the xml text to be added text.Add(description); //the description text of the xml element to be added element.Add("date"); //the text inside the xml element to be added text.Add(fileNameDate); //save each task as an xml element db.write(path + @"contractors\"+fileNameDate+".xml", element, text, "visitor"); } } rfile.Close(); }
private void createExtraTasks() { try { //if extra tasklist has not yet been generated do it now dataBase db = new dataBase(); XmlDocument xdoc = new XmlDocument(); FileStream rfile = new FileStream(path + @"tasks\tasklist.xml", FileMode.Open); xdoc.Load(rfile); XmlNodeList list = xdoc.GetElementsByTagName("task"); for (int i = 0; i <= list.Count; i++) { XmlElement taskName = (XmlElement)xdoc.GetElementsByTagName("task_name")[i]; XmlElement frequency = (XmlElement)xdoc.GetElementsByTagName("frequency")[i]; if (frequency.InnerText == "weekly") { for (int w = 0; w < 4; w++) { ArrayList element = new ArrayList(); ArrayList text = new ArrayList(); //the name of the xml element to be added element.Add("task"); //the text inside the xml element to be added text.Add(taskName.InnerText); //the name of the xml element to be added element.Add("weekly_or_monthly"); //the text inside the xml element to be added text.Add("weekly"); //the name of the xml element to be added element.Add("completed"); //the text inside the xml element to be added text.Add("false"); //the name of the xml element to be added element.Add("date_completed"); //the text inside the xml element to be added text.Add(""); //save each task as an xml element db.write(path + @"extra\" + DateTime.Now.ToString("MMMM-yyyy") + ".xml", element, text, "extra_tasks"); } } else if (frequency.InnerText == "two_monthly") { string date = xdoc.GetElementsByTagName("month")[i].InnerText; DateTime startDate = DateTime.Now; if (date == startDate.AddMonths(2).ToString("MMMM") || date == startDate.AddMonths(4).ToString("MMMM") || date == startDate.AddMonths(6).ToString("MMMM") || date == startDate.AddMonths(8).ToString("MMMM") || date == startDate.AddMonths(10).ToString("MMMM") || date == startDate.AddMonths(12).ToString("MMMM")) { ArrayList element = new ArrayList(); ArrayList text = new ArrayList(); //the name of the xml element to be added element.Add("task"); //the text inside the xml element to be added text.Add(taskName.InnerText); //the name of the xml element to be added element.Add("weekly_or_monthly"); //the text inside the xml element to be added text.Add(frequency.InnerText); //the name of the xml element to be added element.Add("completed"); //the text inside the xml element to be added text.Add("false"); //the name of the xml element to be added element.Add("date_completed"); //the text inside the xml element to be added text.Add(""); //save each task as an xml element db.write(path + @"extra\" + DateTime.Now.ToString("MMMM-yyyy") + ".xml", element, text, "extra_tasks"); } else { } } else if (frequency.InnerText == "three_monthly") { string date = xdoc.GetElementsByTagName("date")[i].ToString(); if (getMonthAsInt(date) == getMonthAsInt(date) || getMonthAsInt(date) == getMonthAsInt(date) + 3) { ArrayList element = new ArrayList(); ArrayList text = new ArrayList(); //the name of the xml element to be added element.Add("task"); //the text inside the xml element to be added text.Add(taskName.InnerText); //the name of the xml element to be added element.Add("weekly_or_monthly"); //the text inside the xml element to be added text.Add(frequency.InnerText); //the name of the xml element to be added element.Add("completed"); //the text inside the xml element to be added text.Add("false"); //the name of the xml element to be added element.Add("date_completed"); //the text inside the xml element to be added text.Add(""); //save each task as an xml element } } else if (frequency.InnerText == "six_monthly") { DateTime startDate = DateTime.Now; string date = xdoc.GetElementsByTagName("month")[i].ToString(); if (date == startDate.AddMonths(6).ToString("MMMM") || date == startDate.AddMonths(12).ToString("MMMM")) { ArrayList element = new ArrayList(); ArrayList text = new ArrayList(); //the name of the xml element to be added element.Add("task"); //the text inside the xml element to be added text.Add(taskName.InnerText); //the name of the xml element to be added element.Add("weekly_or_monthly"); //the text inside the xml element to be added text.Add(frequency.InnerText); //the name of the xml element to be added element.Add("completed"); //the text inside the xml element to be added text.Add("false"); //the name of the xml element to be added element.Add("date_completed"); //the text inside the xml element to be added text.Add(""); //save each task as an xml element } } else if (frequency.InnerText == "monthly") { ArrayList element = new ArrayList(); ArrayList text = new ArrayList(); //the name of the xml element to be added element.Add("task"); //the text inside the xml element to be added text.Add(taskName.InnerText); //the name of the xml element to be added element.Add("weekly_or_monthly"); //the text inside the xml element to be added text.Add(frequency.InnerText); //the name of the xml element to be added element.Add("completed"); //the text inside the xml element to be added text.Add("false"); //the name of the xml element to be added element.Add("date_completed"); //the text inside the xml element to be added text.Add(""); //save each task as an xml element db.write(path + @"extra\" + DateTime.Now.ToString("MMMM-yyyy") + ".xml", element, text, "extra_tasks"); } else { } rfile.Close(); } } catch (Exception err) { debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); } }
public void startUp() { try { dataBase db = new dataBase(); fileFolder ff = new fileFolder(); //check the core folder database exists - if not create it ff.createFolder(path); ff.createFolder(path + @"extra\"); ff.createFolder(path + @"tasks\"); ff.createFolder(path + @"maintenence\"); ff.createFolder(path + @"maintenence\inventory\"); ff.createFolder(path + @"contractors\"); ff.createFolder(path + @"contractors\lists\"); ff.createFolder(path + @"\contractors\providers\lists\"); ff.createFolder(Application.StartupPath + @"\database\config\"); ff.createFolder(Application.StartupPath + @"\database\temp\"); db.create("contractor_lists", path + @"\contractors\lists\contractors.xml"); db.create("contractors_today", path + @"\contractors\" + fileNameDate + ".xml"); db.create("provider_lists", path + @"\contractors\providers\lists\providers.xml"); //check if tasks xml datbase exists db.create("tasks", path + @"tasks\tasklist.xml"); if (db.create("extra_tasks", path + @"extra\" + DateTime.Now.ToString("MMMM-yyyy") + ".xml")) { createExtraTasks(); } //check if todays tasks xml datbase exists if (db.create("root", path + DateTime.Now.ToString("d-MM-yyyy") + ".xml")) { //file does not exist returns true - create todays tasks createTodaysTasks(); } db.create("inventory", path + @"maintenence\inventory\list.xml"); db.create("item_maintenence", path + @"maintenence\"+fileNameDate+".xml"); //check for update } catch (Exception err) { debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); } }
public string getContractorName(string company) { dataBase db = new dataBase(); XmlDocument xdoc = new XmlDocument(); xdoc.Load(path + @"contractors\lists\contractors.xml"); XmlNodeList list = xdoc.GetElementsByTagName("contractor"); for (int i = 0; i < list.Count; i++) { XmlElement xCompany = (XmlElement)xdoc.GetElementsByTagName("company")[i]; if (xCompany.InnerText == company) { XmlElement xName = (XmlElement)xdoc.GetElementsByTagName("name")[i]; return xName.InnerText; } } return ""; }
public void loadDashboard() { //if todays tasklist has not yet been generated do it now applicationCore ap = new applicationCore(fileNameDate); dataBase db = new dataBase(); richTextBoxDashTasks.Text += "Daily Tasks that need attention \n\n"; XmlDocument xdoc = new XmlDocument(); FileStream rfile = new FileStream(ap.path + fileNameDate + ".xml", FileMode.Open); xdoc.Load(rfile); XmlNodeList list = xdoc.GetElementsByTagName("task"); for (int i = 0; i < list.Count; i++) { XmlElement taskName = (XmlElement)xdoc.GetElementsByTagName("task")[i]; XmlElement completed = (XmlElement)xdoc.GetElementsByTagName("completed")[i]; if (completed.InnerText == "false") { richTextBoxDashTasks.Text += taskName.InnerText + " - Not Completed\n" ; } } richTextBoxDashTasks.Text += "\n\nWeekly & Monthly Tasks that need attention \n\n"; //now extra tasks rfile = new FileStream(ap.path + @"extra\" + DateTime.Now.ToString("MMMM-yyyy") + ".xml", FileMode.Open); xdoc.Load(rfile); list = xdoc.GetElementsByTagName("task"); for (int i = 0; i < list.Count; i++) { XmlElement taskName = (XmlElement)xdoc.GetElementsByTagName("task")[i]; XmlElement completed = (XmlElement)xdoc.GetElementsByTagName("completed")[i]; XmlElement frequency = (XmlElement)xdoc.GetElementsByTagName("weekly_or_monthly")[i]; if (completed.InnerText == "false") { richTextBoxDashTasks.Text += taskName.InnerText + " - Not Completed\n"; } } rfile.Close(); //contractors richTextBoxDashTasks.Text += "\n\nContractors Visting \n\n"; //now extra tasks rfile = new FileStream(ap.path + @"contractors\lists\contractors.xml", FileMode.Open); xdoc.Load(rfile); list = xdoc.GetElementsByTagName("contractor"); for (int i = 0; i < list.Count; i++) { XmlElement name = (XmlElement)xdoc.GetElementsByTagName("name")[i]; XmlElement company = (XmlElement)xdoc.GetElementsByTagName("company")[i]; XmlElement next = (XmlElement)xdoc.GetElementsByTagName("next_visit")[i]; int result = DateTime.Compare(Convert.ToDateTime(next.InnerText), DateTime.Now); if (result >= 0) { richTextBoxDashTasks.Text += name.InnerText + " from " + company.InnerText + " - Due in "+result+" days \n"; } } rfile.Close(); }
private void addTask(object sender, EventArgs e) { try { if (textBoxFutureName.Text.Length > 3) { dataBase db = new dataBase(); applicationCore ap = new applicationCore(fileNameDate); ArrayList element = new ArrayList(); //add the xml elements names element.Add("task_name"); element.Add("description"); element.Add("frequency"); ArrayList text = new ArrayList(); //add the xml elements text values text.Add(textBoxFutureName.Text); text.Add(""); if (radioButtonDailyTask.Checked) { text.Add("daily"); } else if (radioButtonWeeklyTask.Checked) { text.Add("weekly"); } else if (radioButtonMonthlyTask.Checked) { text.Add("monthly"); } else if (radioButtonTwoMonthly.Checked) { text.Add("two_monthly"); element.Add("month"); text.Add(DateTime.Now.ToString("MMMM")); } else if (radioButtonThreeMonthly.Checked) { text.Add("three_monthly"); element.Add("month"); text.Add(DateTime.Now.ToString("MMMM")); } else if (radioButtonSixMonthly.Checked) { text.Add("six_monthly"); element.Add("month"); text.Add(DateTime.Now.ToString("MMMM")); } //write new task to tasklist db.write(ap.path + @"tasks/tasklist.xml", element, text, "task"); loadAllTheTasks(); //add/ write the new task to todays task if (radioButtonDailyTask.Checked) { ArrayList elementName = new ArrayList(); elementName.Add("task"); elementName.Add("description"); elementName.Add("completed"); ArrayList textValue = new ArrayList(); textValue.Add(textBoxFutureName.Text); textValue.Add(""); textValue.Add("false"); db.write(ap.path + fileNameDate + ".xml", elementName, textValue, "tasks"); } if (radioButtonWeeklyTask.Checked) { for (int w = 0; w < 4; w++) { ArrayList elementNameTwo = new ArrayList(); elementNameTwo.Add("date"); elementNameTwo.Add("task"); elementNameTwo.Add("description"); elementNameTwo.Add("weekly_or_monthly"); elementNameTwo.Add("completed"); elementNameTwo.Add("date_completed"); ArrayList textValueTwo = new ArrayList(); textValueTwo.Add(fileNameDate); textValueTwo.Add(textBoxFutureName.Text); textValueTwo.Add(""); textValueTwo.Add("weekly"); textValueTwo.Add("false"); textValueTwo.Add(""); db.write(ap.path + @"extra\" + DateTime.Now.ToString("MMMM-yyyy") + ".xml", elementNameTwo, textValueTwo, "extra_tasks"); } } if (radioButtonMonthlyTask.Checked) { ArrayList elementNameTwo = new ArrayList(); elementNameTwo.Add("date"); elementNameTwo.Add("task"); elementNameTwo.Add("description"); elementNameTwo.Add("weekly_or_monthly"); elementNameTwo.Add("completed"); elementNameTwo.Add("date_completed"); ArrayList textValueTwo = new ArrayList(); textValueTwo.Add(fileNameDate); textValueTwo.Add(textBoxFutureName.Text); textValueTwo.Add(""); textValueTwo.Add("monthly"); textValueTwo.Add("false"); textValueTwo.Add(""); db.write(ap.path + @"extra\" + DateTime.Now.ToString("MMMM-yyyy") + ".xml", elementNameTwo, textValueTwo, "extra_tasks"); } loadTodaysTasks(selectedDate); loadExtraTasks(); labelAddTaskValidate.Text = "Task added succesfully"; } else { labelAddTaskValidate.Text = "Task must not already exist and has to be over three letters long."; } } catch (Exception err) { labelAddTaskValidate.Text = "Adding task failed"; debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); } }
private void AddProvider(object sender, EventArgs e) { try { dataBase db = new dataBase(); applicationCore ap = new applicationCore(fileNameDate); ArrayList element = new ArrayList(); //add the xml elements names element.Add("name"); element.Add("due_date"); element.Add("date_completed"); ArrayList text = new ArrayList(); text.Add(textBoxAddProvidersName.Text); text.Add(textBoxAddProviderDueDate.Text); text.Add(textBoxAddProviderDateCompleted.Text); db.write(ap.path + @"\contractors\providers\lists\providers.xml", element, text, "provider"); labelAddProviderValidate.Text = "Adding provider succeded"; loadAllProviders(); } catch (Exception err) { debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); labelAddProviderValidate.Text = "Adding provider failed"; } }
private void loadSelectedMaintenenceItems(object sender, EventArgs e) { selectedDate = this.dateTimePicker3.Value.ToString("d-MM-yyyy"); applicationCore ap = new applicationCore(selectedDate); dataBase db = new dataBase(); if (!File.Exists(ap.path + @"maintenence\" + selectedDate + @".xml")) { labelMaintenenceNoTasks.Visible = true; buttonNoMaintenenceItems.Visible = true; } else { selectedDate = fileNameDate; labelMaintenenceNoTasks.Visible = false; buttonNoMaintenenceItems.Visible = false; } }
private void addItemMaintenence(object sender, EventArgs e) { try { dataBase db = new dataBase(); applicationCore ap = new applicationCore(fileNameDate); ArrayList element = new ArrayList(); //add the xml elements names element.Add("item"); element.Add("area"); element.Add("quantity"); ArrayList text = new ArrayList(); text.Add(textBoxAddInventoryItem.Text); text.Add(textBoxAddInventoryArea.Text); text.Add(textBoxAddInventoryQuantity.Text); labelAddInventoryValidate.Text = textBoxAddInventoryItem.Text + " succesfully added"; textBoxAddInventoryItem.Clear(); db.write(ap.path + @"maintenence\inventory\" + "list.xml", element, text, "items"); loadInventoryItems(); } catch (Exception err) { debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); } }
private void AddContractors(object sender, EventArgs e) { try { dataBase db = new dataBase(); applicationCore ap = new applicationCore(fileNameDate); ArrayList element = new ArrayList(); //add the xml elements names element.Add("name"); element.Add("company"); element.Add("phone"); element.Add("description"); element.Add("next_visit"); element.Add("certification_no"); ArrayList text = new ArrayList(); text.Add(textBoxAddContractorName.Text); text.Add(textBoxAddContractorCompany.Text); text.Add(textBoxAddContractorPhone.Text); text.Add(richTextBoxAddContractorDescription.Text); text.Add(textBoxAddContractorNextVisit.Text); text.Add(textBoxAddContractorCertNumber.Text); //if contractor visits is re-occuring if (checkBoxAddContractorEveryXMonths.Checked) { element.Add("every"); element.Add("frequency"); text.Add(textBoxAddContractorAmountOfTimeBetweenVisits.Text); text.Add(comboBoxAddContractorPeriodOfTime.Text); } db.write(ap.path + @"\contractors\lists\contractors.xml", element, text, "contractor"); labelAddContractorValidate.Text = "Adding contractor succeded"; loadAllContractors(); } catch (Exception err) { debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); labelAddContractorValidate.Text = "Adding contractor failed"; } }
private void updateAddOneOffDailyTask(object sender, EventArgs e) { dataBase db = new dataBase(); applicationCore ap = new applicationCore(fileNameDate); ArrayList element = new ArrayList(); //add the xml elements names element.Add("date"); element.Add("task"); element.Add("description"); element.Add("completed"); ArrayList text = new ArrayList(); //add the xml elements text values text.Add(fileNameDate); text.Add(textBoxTodaysTasksExtraTask.Text); text.Add(richTextBoxTodaysTaskAddDescrition.Text); if (checkBoxAddOneOffTask.Checked) { text.Add("true"); } else { text.Add("false"); } db.write(ap.path + selectedDate + @".xml", element, text, "tasks"); labelAddOneOffTaskValidate.Text = "Task added to todays tasks"; loadTodaysTasks(selectedDate); }
private void removeDeletedRowFromOtherTasks(object sender, DataGridViewRowCancelEventArgs e) { try { dataBase db = new dataBase(); applicationCore ap = new applicationCore(fileNameDate); //get the name of the task from the deleted row and the first cell string deletedTaskValue = (string)dataGridView2.Rows[e.Row.Index].Cells[1].Value; string deletedFreqValue = (string)dataGridView2.Rows[e.Row.Index].Cells[2].Value; //delete rows with the same task name from other xml files if (deletedFreqValue == "daily") { db.delete(ap.path + fileNameDate + ".xml", "/root/tasks[task='" + deletedTaskValue + "']"); loadTodaysTasks(selectedDate); } if (deletedFreqValue == "weekly" || deletedFreqValue == "monthly") for (int w = 0; w < 4; w++) { db.delete(ap.path + @"extra\" + DateTime.Now.ToString("MMMM-yyyy") + ".xml", "/extra_tasks/extra_tasks[task='" + deletedTaskValue + "']"); } loadExtraTasks(); //now we update the table datasetToXml(ap.path + @"tasks/tasklist.xml", 2); } catch (Exception err) { debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); } }
private void noTasks(object sender, EventArgs e) { labelNoDailyItems.Visible = false; buttonNoDailyTasks.Visible = false; dataBase db = new dataBase(); applicationCore ap = new applicationCore(selectedDate); if (db.create("root", ap.path + selectedDate + ".xml")) { ap.createTodaysTasks(); loadTodaysTasks(selectedDate); } }
private void noMaintenence(object sender, EventArgs e) { applicationCore ap = new applicationCore(selectedDate); dataBase db = new dataBase(); if (db.create("item_maintenence", ap.path + @"maintenence\" + selectedDate + ".xml")) { ap.createTodaysTasks(); loadAllMaintenceItems(selectedDate); } labelMaintenenceNoTasks.Visible = false; buttonNoMaintenenceItems.Visible = false; }
private void noContractors(object sender, EventArgs e) { dataBase db = new dataBase(); applicationCore ap = new applicationCore(selectedDate); db.create("contractors_today", ap.path + @"contractors\" + selectedDate + @".xml"); labelContractorsNoTasks.Visible = false; buttonNoContractors.Visible = false; }
private void addItemMaintenenceItem(object sender, EventArgs e) { try { dataBase db = new dataBase(); applicationCore ap = new applicationCore(fileNameDate); ArrayList element = new ArrayList(); //add the xml elements names element.Add("area"); element.Add("room"); element.Add("item_name"); element.Add("description"); element.Add("next_visit"); ArrayList text = new ArrayList(); text.Add(textBoxItemMaintenenceArea.Text); text.Add(textBoxAddItemMaintenceRoom.Text); text.Add(textBoxAddItemMaintenenceItem.Text); text.Add(richTextBoxAddItemMaintenceDescription.Text); text.Add(textBoxAddContractorNextVisit.Text); db.write(ap.path + @"maintenence\" + selectedDate + ".xml", element, text, "item"); loadAllMaintenceItems(selectedDate); } catch (Exception err) { debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); } }
private void loadSelectedContractorVisits(object sender, EventArgs e) { selectedDate = this.dateTimePicker2.Value.ToString("d-MM-yyyy"); applicationCore ap = new applicationCore(selectedDate); dataBase db = new dataBase(); if (!File.Exists(ap.path + @"contractors\" + selectedDate + @".xml")) { labelContractorsNoTasks.Visible = true; buttonNoContractors.Visible = true; } else { selectedDate = fileNameDate; labelContractorsNoTasks.Visible = false; buttonNoContractors.Visible = false; } loadDailyContractors(selectedDate); }