public void createContractorsCSVDocument()
{
try
{
string cnStr =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Extended Properties='text;HDR=Yes;FMT=Delimited';" +
"Data Source=" + dir + ";";
using (var cn = new OleDbConnection(cnStr))
{
cn.Open();
var cmd = new OleDbCommand(
"CREATE TABLE contractors.csv ([Name] VARCHAR(30), [Company] VARCHAR(30), [Description] VARCHAR(100), [Date] VARCHAR(10))", cn);
cmd.ExecuteNonQuery();
cn.Close();
}
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
public bool create(string xmlRoot, string fileName)
{
//create the root elements of the xml document if the dont alreasy exist
try
{
if (!System.IO.File.Exists(fileName))
{
XmlTextWriter xtw;
xtw = new XmlTextWriter(fileName, Encoding.UTF8);
xtw.WriteStartDocument();
xtw.WriteStartElement(xmlRoot);
xtw.WriteEndElement();
xtw.Close();
//if file exists return true
return true;
}
else { return false; }
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
return false;
}
}
public Form1()
{
InitializeComponent();
try
{
AutoUpdater.Start("http://www.matthewmarillac.com/mmm/versioninfo.xml");
}
catch (Exception err)
{
MessageBox.Show("Updater failed!");
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
public void loadAllTheTasks()
{
try
{
applicationCore ap = new applicationCore(fileNameDate);
DataSet ds = new DataSet();
ds.ReadXml(ap.path + @"tasks/tasklist.xml").ToString();
dataGridView2.DataSource = ds;
if (ds.Tables.Count > 0)
{
dataGridView2.DataMember += "task";
}
}
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());
}
}
private void exportProvidersToCSV()
{
try
{
//first step is too check if temp file exists and if it does delete it
//to start again
if (File.Exists(Application.StartupPath + @"\database\temp\providers.csv"))
{
File.Delete(Application.StartupPath + @"\database\temp\providers.csv");
}
//now we get the value of all input and selection fields and convert them to appropriate data type
exportToCSV CSV = new exportToCSV();
CSV.createProvidersCSVDocument();
string year = textBoxSaveToCSVEndYear.Text;
try
{
if (File.Exists(Application.StartupPath + @"\database\" + year + @"\contractors\providers\lists\providers.xml"))
{
CSV.generateProvidersCSVDocument(Application.StartupPath + @"\database\" + year + @"\contractors\providers\lists\providers.xml",
DateTime.Now.ToString("d/MM/yyyy"), "provider");
}
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
//now we let the user save the temp excel file
SaveFileDialog save = new SaveFileDialog();
save.Filter = "Excel|*.CSV";
save.FileName = "myProvidersList.csv";
progressBar1.Value = 50;
save.ShowDialog();
File.Copy(Application.StartupPath + @"\database\temp\providers.csv", save.FileName);
//exportCSVValidate.Text = "File Saved";
//delete temp file
File.Delete(Application.StartupPath + @"\database\temp\providers.csv");
progressBar1.Value = 100;
}
catch (Exception err)
{
exportCSVValidate.Text = "File was not saved";
progressBar1.Value = 0;
if (File.Exists(Application.StartupPath + @"\database\temp\providers.csv"))
{
File.Delete(Application.StartupPath + @"\database\temp\providers.csv");
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
}
private void exportMaintenenceToCSV()
{
try
{
//first step is too check if temp file exists and if it does delete it
//to start again
if (File.Exists(Application.StartupPath + @"\database\temp\maintenence.csv"))
{
File.Delete(Application.StartupPath + @"\database\temp\maintenence.csv");
}
//now we get the value of all input and selection fields and convert them to appropriate data type
int sd = Convert.ToInt32(textBoxSaveToCSVStartDate.Text);
int fd = Convert.ToInt32(textBoxSaveToCSVEndDay.Text);
if (sd > 0 && sd < 31 && fd > 0 && fd < 31)
{
string sm = comboBoxSaveToCSVStartMonth.Text;
string fm = comboBoxSaveToCSVEndMonth.Text;
string sy = textBoxSaveToCSVStartYear.Text;
string fy = textBoxSaveToCSVEndYear.Text;
applicationCore apc = new applicationCore(fileNameDate);
exportToCSV CSV = new exportToCSV();
//get selected months as numbers
int startMonth = apc.getMonthAsInt(sm);
int endMonth = apc.getMonthAsInt(fm);
int nsy = Convert.ToInt32(sy);
int nfy = Convert.ToInt32(fy);
//now we get data from each file between te selected time period
//based on its date based file name
CSV.createMaintenenceCSVDocument();
//loop through years
for (int y = nsy; y <= nfy; y++)
{
//loop through months
for (int m = startMonth; m <= endMonth; m++)
{
//loop through days
for (int d = sd; d <= 31; d++)
{
try
{
if (File.Exists(Application.StartupPath + @"\database\" + y + @"\maintenence\" + d + "-" + m + "-" + y + ".xml"))
{
CSV.generateMaintenenceCSVDocument(Application.StartupPath + @"\database\" + y + @"\maintenence\" + d + "-" + m + "-" + y + ".xml",
DateTime.Now.ToString("d/MM/yyyy"), "item");
}
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
}
}
//now we let the user save the temp excel file
SaveFileDialog save = new SaveFileDialog();
save.Filter = "Excel|*.CSV";
save.FileName = "myMaintenenceCheckList.csv";
progressBar1.Value = 50;
save.ShowDialog();
File.Copy(Application.StartupPath + @"\database\temp\maintenence.csv", save.FileName);
//exportCSVValidate.Text = "File Saved";
//delete temp file
File.Delete(Application.StartupPath + @"\database\temp\maintenence.csv");
progressBar1.Value = 100;
}
else
{
exportCSVValidate.Text = "The days added were not correct month numbers";
}
}
catch (Exception err)
{
exportCSVValidate.Text = "File was not saved";
progressBar1.Value = 0;
if (File.Exists(Application.StartupPath + @"\database\temp\maintenence.csv"))
{
File.Delete(Application.StartupPath + @"\database\temp\maintenence.csv");
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
}
private void loadAllProviders()
{
try
{
applicationCore ap = new applicationCore(fileNameDate);
DataSet ds = new DataSet();
ds.ReadXml(ap.path + @"\contractors\providers\lists\providers.xml");
dataGridView8.DataSource = ds;
if (ds.Tables.Count > 0)
{
dataGridView8.DataMember = "provider";
}
}
catch (System.IO.FileNotFoundException)
{
//error warning
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
private void datasetToXml(string fileName, int dgv)
{
try
{
DataSet ds = new DataSet();
switch (dgv)
{
case 1:
ds = (DataSet)dataGridView1.DataSource;
for (int i = 0; i < ds.Tables.Count; i++)
{
ds.Tables[i].WriteXml(fileName, System.Data.XmlWriteMode.IgnoreSchema);
loadTodaysTasks(selectedDate);
labelTodaysTasksUpdate.Text = "Tasks Succesfully Updated";
}
break;
case 2:
ds = (DataSet)dataGridView2.DataSource;
for (int i = 0; i < ds.Tables.Count; i++)
{
ds.Tables[i].WriteXml(fileName, System.Data.XmlWriteMode.IgnoreSchema);
loadTodaysTasks(selectedDate);
labelAddTasksUpdate.Text = "Tasks Succesfully Updated";
}
break;
case 3:
ds = (DataSet)dataGridView3.DataSource;
for (int i = 0; i < ds.Tables.Count; i++)
{
ds.Tables[i].WriteXml(fileName, System.Data.XmlWriteMode.IgnoreSchema);
loadExtraTasks();
labelExtraTasksUpdate.Text = "Tasks Succesfully Updated";
}
break;
case 4:
ds = (DataSet)dataGridView4.DataSource;
for (int i = 0; i < ds.Tables.Count; i++)
{
ds.Tables[i].WriteXml(fileName, System.Data.XmlWriteMode.IgnoreSchema);
loadAllContractors();
labelUpdateContractors.Text = "Contractors Succesfully Updated";
}
break;
case 5:
ds = (DataSet)dataGridView5.DataSource;
for (int i = 0; i < ds.Tables.Count; i++)
{
ds.Tables[i].WriteXml(fileName, System.Data.XmlWriteMode.IgnoreSchema);
loadAllContractors();
labelUpdateTodaysContractors.Text = "Contractors Succesfully Updated";
}
break;
case 6:
ds = (DataSet)dataGridView6.DataSource;
for (int i = 0; i < ds.Tables.Count; i++)
{
ds.Tables[i].WriteXml(fileName, System.Data.XmlWriteMode.IgnoreSchema);
loadAllMaintenceItems(selectedDate);
}
break;
case 7:
ds = (DataSet)dataGridView7.DataSource;
for (int i = 0; i < ds.Tables.Count; i++)
{
ds.Tables[i].WriteXml(fileName, System.Data.XmlWriteMode.IgnoreSchema);
loadInventoryItems();
}
break;
case 8:
ds = (DataSet)dataGridView8.DataSource;
for (int i = 0; i < ds.Tables.Count; i++)
{
ds.Tables[i].WriteXml(fileName, System.Data.XmlWriteMode.IgnoreSchema);
loadAllProviders();
}
break;
}
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
public void generateProvidersCSVDocument(string fileName, string date, string element)
{
try
{
string cnStr =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Extended Properties='text;HDR=Yes;FMT=Delimited';" +
"Data Source=" + dir + ";";
using (var cn = new OleDbConnection(cnStr))
{
cn.Open();
//define the file layout (a.k.a. the table)
//start pumping data
XmlDocument xdoc = new XmlDocument();
FileStream rfile = new FileStream(fileName, FileMode.Open);
xdoc.Load(rfile);
XmlNodeList list = xdoc.GetElementsByTagName(element);
for (int i = 0; i < list.Count; i++)
{
var cmd = new OleDbCommand(
"INSERT INTO providers.csv ([Name], [Date Due], [Date Completed]) VALUES (?, ?, ?)", cn);
XmlElement name = (XmlElement)xdoc.GetElementsByTagName("name")[i];
XmlElement due = (XmlElement)xdoc.GetElementsByTagName("due_date")[i];
XmlElement completed = (XmlElement)xdoc.GetElementsByTagName("date_completed")[i];
cmd.Parameters.AddWithValue("?", name.InnerText);
cmd.Parameters.AddWithValue("?", due.InnerText + "");
cmd.Parameters.AddWithValue("?", completed.InnerText + "");
cmd.ExecuteNonQuery();
}
rfile.Close();
cn.Close();
}
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
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 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 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 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";
}
}
public void loadTodaysTasks(string date)
{
try
{
applicationCore ap = new applicationCore(fileNameDate);
DataSet ds = new DataSet();
ds.ReadXml(ap.path + date + ".xml").ToString();
dataGridView1.DataSource = ds;
if (ds.Tables.Count > 0)
{
dataGridView1.DataMember += "tasks";
}
}
catch (System.IO.FileNotFoundException)
{
//error warning
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
public void loadExtraTasks()
{
try
{
applicationCore ap = new applicationCore(fileNameDate);
DataSet ds = new DataSet();
ds.ReadXml(ap.path + @"extra\" + DateTime.Now.ToString("MMMM-yyyy") + ".xml").ToString();
dataGridView3.DataSource = ds;
if (ds.Tables.Count > 0)
{
dataGridView3.DataMember = "extra_tasks";
}
}
catch (System.IO.FileNotFoundException)
{
//error warning
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
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());
}
}
private void loadDailyContractors(string date)
{
try
{
applicationCore ap = new applicationCore(date);
DataSet ds1 = new DataSet();
ds1.ReadXml(ap.path + @"\contractors\lists\contractors.xml");
//load all created contractors into combo boxs
comboBox1.DataSource = ds1.Tables["contractor"];
if (ds1.Tables.Count > 0)
{
comboBox1.DisplayMember = "company";
}
//load todays contractors into box
DataSet ds2 = new DataSet();
ds2.ReadXml(ap.path + @"\contractors\" + date + ".xml");
if (ds2.Tables.Count > 0)
{
dataGridView5.DataSource = ds2;
dataGridView5.DataMember = "visitor";
}
else
{
dataGridView5.DataSource = null;
labelUpdateTodaysContractors.Text = "There are no records for this day, add one bellow";
}
}
catch (System.IO.FileNotFoundException)
{
//error warning
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
public void generateContractorListsCSVDocument(string fileName, string date, string element)
{
try
{
string cnStr =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Extended Properties='text;HDR=Yes;FMT=Delimited';" +
"Data Source=" + dir + ";";
using (var cn = new OleDbConnection(cnStr))
{
cn.Open();
//define the file layout (a.k.a. the table)
//start pumping data
XmlDocument xdoc = new XmlDocument();
FileStream rfile = new FileStream(fileName, FileMode.Open);
xdoc.Load(rfile);
XmlNodeList list = xdoc.GetElementsByTagName(element);
for (int i = 0; i < list.Count; i++)
{
var cmd = new OleDbCommand(
"INSERT INTO contractorlists.csv ([Name], [Company], [Phone], [Description], [NextVist], [CertNo], [Date]) VALUES (?, ?, ?, ?, ?, ?, ?)", cn);
XmlElement name = (XmlElement)xdoc.GetElementsByTagName("name")[i];
XmlElement company = (XmlElement)xdoc.GetElementsByTagName("company")[i];
XmlElement phone = (XmlElement)xdoc.GetElementsByTagName("phone")[i];
XmlElement description = (XmlElement)xdoc.GetElementsByTagName("description")[i];
XmlElement visit = (XmlElement)xdoc.GetElementsByTagName("next_visit")[i];
XmlElement cert = (XmlElement)xdoc.GetElementsByTagName("certification_no")[i];
cmd.Parameters.AddWithValue("?", name.InnerText);
cmd.Parameters.AddWithValue("?", company.InnerText + "");
cmd.Parameters.AddWithValue("?", phone.InnerText + "");
cmd.Parameters.AddWithValue("?", description.InnerText + "");
cmd.Parameters.AddWithValue("?", visit.InnerText + "");
cmd.Parameters.AddWithValue("?", cert.InnerText + "");
cmd.Parameters.AddWithValue("?", DateTime.Now.ToString());
cmd.ExecuteNonQuery();
}
rfile.Close();
cn.Close();
}
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
private void loadInventoryItems()
{
try
{
applicationCore ap = new applicationCore(fileNameDate);
DataSet ds = new DataSet();
ds.ReadXml(ap.path + @"maintenence\inventory\" + "list.xml").ToString();
dataGridView7.DataSource = ds;
if (ds.Tables.Count > 0)
{
dataGridView7.DataMember = "items";
}
}
catch (System.IO.FileNotFoundException)
{
//error warning
}
catch (Exception err)
{
debugTerminal terminal = new debugTerminal();
terminal.output(err.ToString());
}
}
public void generateTasksCSVDocument(string fileName, string date, string element)
{
try
{
string cnStr =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Extended Properties='text;HDR=Yes;FMT=Delimited';" +
"Data Source=" + dir + ";";
using (var cn = new OleDbConnection(cnStr))
{
cn.Open();
//define the file layout (a.k.a. the table)
//start pumping data
XmlDocument xdoc = new XmlDocument();
FileStream rfile = new FileStream(fileName, FileMode.Open);
xdoc.Load(rfile);
XmlNodeList list = xdoc.GetElementsByTagName(element);
for (int i = 0; i < list.Count; i++)
{
if (element == "tasks")
{
var cmd = new OleDbCommand(
"INSERT INTO data.csv ([Date], [Task], [Completed], [Frequency]) VALUES (?, ?, ?, ?)", cn);
XmlElement task = (XmlElement)xdoc.GetElementsByTagName("task")[i];
XmlElement completed = (XmlElement)xdoc.GetElementsByTagName("completed")[i];
cmd.Parameters.AddWithValue("?", date);
cmd.Parameters.AddWithValue("?", task.InnerText + "");
cmd.Parameters.AddWithValue("?", completed.InnerText + "");
cmd.Parameters.AddWithValue("", "daily task");
cmd.ExecuteNonQuery();
}
else if (element == "extra_tasks")
{
var cmd = new OleDbCommand(
"INSERT INTO data.csv ([Date], [Task], [Completed], [Frequency]) VALUES (?, ?, ?, ?)", cn);
XmlElement task = (XmlElement)xdoc.GetElementsByTagName("task")[i];
XmlElement completed = (XmlElement)xdoc.GetElementsByTagName("completed")[i];
XmlElement frequency = (XmlElement)xdoc.GetElementsByTagName("weekly_or_monthly")[i];
cmd.Parameters.AddWithValue("?", date);
cmd.Parameters.AddWithValue("?", task.InnerText + "");
cmd.Parameters.AddWithValue("?", completed.InnerText + "");
cmd.Parameters.AddWithValue("?", frequency.InnerText + " task");
cmd.ExecuteNonQuery();
}
else { }
}
rfile.Close();
cn.Close();
}
}
catch (Exception err)
{
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 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 launchDegugTerminal(object sender, EventArgs e)
{
debugTerminal terminal = new debugTerminal();
terminal.Visible = true;
}
