private void BgWorker_DoWork(object sender, DoWorkEventArgs e) { try { if (!errorClamp.Clamptype.Contains("PC")) { if (!Directory.Exists(save + @"\Final Control")) { Directory.CreateDirectory(save + @"\Final Control"); } string dest = save + @"\Final Control"; string destfile = "FC " + DateTime.Now.ToString("dd-MM-yyyy") + " " + textBox3.Text + " " + textBox4.Text + ".xlsx"; File.Copy(Path.Combine(direktorijum, "final control.xlsx"), Path.Combine(dest, destfile), true); string editfile = dest + "\\" + destfile; resultDB = ClampOperations.InsertClamp(errorClamp); //ExcellClass.crateFinalControl(@"C:\Users\AleksandraTos\Documents\Visual Studio 2008\Projects\Control Generator\bin\Debug\final control.xlsx", @"Desktop\final control.xlsx", errorClamp); resultEX = ExcellClass.crateFinalControl(editfile, errorClamp); } else { if (!Directory.Exists(save + @"\Final Control")) { Directory.CreateDirectory(save + @"\Final Control"); } string dest = save + @"\Final Control"; string destfile = "FC " + DateTime.Now.ToString("dd-MM-yyyy") + " " + textBox3.Text + " " + textBox4.Text + ".xlsx"; File.Copy(Path.Combine(direktorijum, "final control PC.xlsx"), Path.Combine(dest, destfile), true); string editfile = dest + "\\" + destfile; resultDB = ClampOperations.InsertClamp(errorClamp); //ExcellClass.crateFinalControl(@"C:\Users\AleksandraTos\Documents\Visual Studio 2008\Projects\Control Generator\bin\Debug\final control.xlsx", @"Desktop\final control.xlsx", errorClamp); resultEX = ExcellClass.crateFinalControl(editfile, errorClamp); } } catch (Exception ex) { string newfolder = direktorijum + "\\Logs"; if (!Directory.Exists(newfolder)) { Directory.CreateDirectory(newfolder); } newfolder += "\\log1" + DateTime.Now.ToString("dd_MM_yyyy hh_mm_ss") + ".txt"; StreamWriter sw = new StreamWriter(newfolder); sw.Write(ex.ToString()); sw.Close(); } }
private void BgWorker_DoWork(object sender, DoWorkEventArgs e) { List <Clamp> counter = new List <Clamp>(); if (buttonpressedPL && !buttonpressedFCR) { counter = ClampOperations.ReturnClampPackingList(textBox3.Text, textBox4.Text); if (counter.Count > 0) { if (!Directory.Exists(save + @"\Packing List")) { Directory.CreateDirectory(save + @"\Packing List"); } string dest = save + @"\Packing List"; string destfile = "PL " + DateTime.Now.ToString("dd-MM-yyyy -- HH-mm-ss") + ".xlsx"; File.Copy(Path.Combine(direktorijum, "packing list.xlsx"), Path.Combine(dest, destfile), true); string editfile = dest + "\\" + destfile; resultPL = ExcellClass.createPackingList(editfile, counter, paramPL, ClampOperations.ReturnClampRN(textBox3.Text, textBox4.Text)); buttonpressedPL = false; Process process = new Process(); process = Process.Start(editfile); } else { resultPL = false; } } if (buttonpressedFCR && !buttonpressedPL) { counter = ClampOperations.ReturnClampFCR(textBox1.Text, textBox2.Text); if (counter.Count > 0) { if (!Directory.Exists(save + @"\Final Control Report")) { Directory.CreateDirectory(save + @"\Final Control Report"); } string dest = save + @"\Final Control Report"; string destfile = "FCR " + DateTime.Now.ToString("dd-MM-yyyy -- HH-mm-ss") + ".xlsx"; File.Copy(Path.Combine(direktorijum, "final control report.xlsx"), Path.Combine(dest, destfile), true); string editfile = dest + "\\" + destfile; resultFCR = ExcellClass.createFinalControlReport(editfile, counter, dateTimePicker1.Value.ToString("dd-MM-yyyy"), ClampOperations.ReturnClampRN(textBox1.Text, textBox2.Text)); buttonpressedFCR = false; Process process = new Process(); process = Process.Start(editfile); } else { resultFCR = false; } } }