private void DelModify_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
DBHoleData = new List <DBHoleInfos>();
string TemplateFolder = "";
string Path = System.Reflection.Assembly.GetExecutingAssembly().CodeBase.Substring(8, System.Reflection.Assembly.GetExecutingAssembly().CodeBase.Length - 8);
string directory = System.IO.Path.GetDirectoryName(Path);
double Tolerance = 0;
bool UseMethod = false;
bool DepthFromTop = false;
bool AllowTagDuplicate = true;
//Get the template from the option page
TagHoles.ExtractINIData(out MachineCells);
TagHoles.GetActiveMachineCellInfos(MachineCell_Drop.Text, MachineCells, out CSVPath, out TemplateFolder, out Tolerance, out UseMethod, out DepthFromTop, out AllowTagDuplicate);
TagHoles.ExtractNewDatabaseData(CSVPath, out DBHoleData);
LoadFamilyTypes();
}
public void UpdateCSVFile(bool Modify)
{
string Line = null;
string TempFileName = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\DrillingAutomation\\Temp.csv";
string TemplateFolder = "";
double Tolerance = 0;
bool UseMethod = false;
string FullLine = "";
bool DepthFromTop = false;
bool AllowTagDuplicate = true;
//Get the template from the option page
TagHoles.ExtractINIData(out MachineCells);
TagHoles.GetActiveMachineCellInfos(MachineCell_Drop.Text, MachineCells, out CSVPath, out TemplateFolder, out Tolerance, out UseMethod, out DepthFromTop, out AllowTagDuplicate);
if (File.Exists(TempFileName))
{
File.Delete(TempFileName);
}
File.Copy(CSVPath, TempFileName);
File.Delete(CSVPath);
using (StreamReader reader = new StreamReader(TempFileName))
{
using (StreamWriter writer = new StreamWriter(CSVPath))
{
while ((Line = reader.ReadLine()) != null)
{
if (Line != "")
{
if (Line.Substring(0, 1) != "*")
{
// Split the Line
string[] CurrentHole = Regex.Split(Line, ";");
if (CurrentHole.Count() >= 3)
{
if (CurrentHole[1] == HoleTypes.Text)
{
if (Modify)
{
HoleFullSignature(out FullLine, true);
SearchForExistingHole(CSVPath, FullLine, Modify, AllowTagDuplicate, out bool HoleExist);
if (HoleExist)
{
if (AllowTagDuplicate)
{
MessageBox.Show("Hole already exist in the database", "Error");
}
else
{
MessageBox.Show("Hole tag already exist in the database", "Error");
}
}
else
{
writer.WriteLine(FullLine);
}
}
continue;
}
}
}
writer.WriteLine(Line);
}
}
writer.Close();
}
reader.Close();
}
File.Delete(TempFileName);
TagHoles.ExtractNewDatabaseData(CSVPath, out DBHoleData);
}