private void butDel_Click(object sender, EventArgs e) { Clamp clamp = new Clamp() { Serialnum = tbSerial.Text }; DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete?", "Delete last added", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { bool result = ClampOperations.DeleteClamp(clamp); if (result) { MessageBox.Show("Success"); } else { MessageBox.Show("Could not delete clamp"); } } else if (dialogResult == DialogResult.No) { return; } }
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 BasicForm_Load(object sender, EventArgs e) { if (HiddenButtons) { butAdvanced.Hide(); butDel.Dock = DockStyle.Top; } clamp = ClampOperations.ReturnClamp(); tbSerial.Text = clamp.Serialnum; tbRado.Text = clamp.Rado; tbRN.Text = clamp.Rn; textBox3.Text = clamp.Serialnum; textBox4.Text = clamp.Rado; NewForm(ff); }
private void butSerialUpdate_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(textBox6.Text) && !String.IsNullOrEmpty(textBox7.Text)) { status.Text = "Please wait..."; status.ForeColor = Color.Red; status.Visible = true; Clamp clamp = new Clamp() { Rado = textBox7.Text, Serialnum = textBox6.Text }; bool result = ClampOperations.UpdateClampBarcode(clamp); if (result) { MessageBox.Show("Success"); textBox6.Clear(); textBox7.Clear(); status.ForeColor = Color.Green; status.Text = "Done"; } else { MessageBox.Show("Could not update your barcode"); status.ForeColor = Color.Red; status.Text = "Error"; } } else { MessageBox.Show("Please fill in all data"); } }
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; } } }