private void UploadOPCFile_Click(object sender, EventArgs e)
{
openOPCFile.Filter = "OPC file (*.csv)|*.csv|All files (*.*)|*.*";
resultOPC = openOPCFile.ShowDialog();
if (resultOPC == System.Windows.Forms.DialogResult.OK)
{
try
{
string CSVFileOnly = Path.GetFileName(openOPCFile.FileName);
OPCFileText.Text = CSVFileOnly;
validOPCFile = CreateTagListFromIGS_OPC.checkOPCFile(openOPCFile.FileName);
}
catch (System.IO.FileNotFoundException fnfe)
{
MessageBox.Show("File does not exist!\r\n\r\n" + fnfe.Message, "File Not Found", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show("An Error Occured\r\n\r\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void buttonGenerateTagList_Click(object sender, EventArgs e)
{
// this checks if the siteName and the Project Number boxes have been populated
if (string.IsNullOrEmpty(txtAONumberBox.Text))
{
MessageBox.Show("Please enter a project Number");
txtAONumberBox.Focus();
return;
}
if (string.IsNullOrEmpty(txtSiteBox.Text))
{
MessageBox.Show("Please enter a Site Name");
txtSiteBox.Focus();
return;
}
//Case 1: When no IGS file has been uploaded
if ((resultIGS != System.Windows.Forms.DialogResult.OK && validIGSFile == false))
{
MessageBox.Show("Please Upload a correct IGS config (.csv) file");
return;
}
// Case 2: When an incorrect IGS file has been uploaded
else if ((resultIGS == System.Windows.Forms.DialogResult.OK && validIGSFile == false))
{
MessageBox.Show("Please Re-Upload a correct IGS config (.csv) file");
return;
}
// Case 3: When an incorrect OPC file has been uploaded
else if (((resultOPC == System.Windows.Forms.DialogResult.OK) || (resultOPC == System.Windows.Forms.DialogResult.Cancel)) && validOPCFile == false)
{
MessageBox.Show("Please Re-Upload a correct OPC config (.csv) file");
return;
}
// Case when no OPC file is uploaded, so program generated taglist based on just IGS file
else if (((resultOPC == System.Windows.Forms.DialogResult.None) && validOPCFile == false))
{
MessageBox.Show("TagList will be generated using only the IGS file as no OPC file was uploaded");
string excelFileName = txtAONumberBox.Text + txtSiteBox.Text + "TagList"; // this is the excel file name without the extensions
saveFile.FileName = excelFileName;
saveFile.Filter = "Excel File (*.xlsx)|*.xlsx";
System.Windows.Forms.DialogResult result;
result = saveFile.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
try
{
CreateTagListFromIGS obj = new CreateTagListFromIGS(openIGSFile.FileName, openOPCFile.FileName, saveFile.FileName);
obj.generateTagList(); // this generateTagList method is the only method that can be excuted from the createTagListFromIGS object
return;
}
catch (Exception ex)
{
MessageBox.Show("An Error Occured\r\n\r\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
string excelFileName = txtAONumberBox.Text + txtSiteBox.Text + "TagList"; // this is the excel file name without the extensions
saveFile.FileName = excelFileName;
saveFile.Filter = "Excel File (*.xlsx)|*.xlsx";
System.Windows.Forms.DialogResult result;
result = saveFile.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
try
{
CreateTagListFromIGS_OPC obj = new CreateTagListFromIGS_OPC(openIGSFile.FileName, openOPCFile.FileName, saveFile.FileName);
obj.generateTagList(); // this generateTagList method is the only method that can be excuted from the createTagListFromIGS object
return;
}
catch (Exception ex)
{
MessageBox.Show("An Error Occured\r\n\r\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
