/* * public void ChangeColor(string color) * { * if (InvokeRequired) * { * this.Invoke(new Action<string>(ChangeColor), new object[] { color }); * return; * } * * if (color.Equals("Green")) * this.button4.BackColor = Color.Green; * else * this.button4.BackColor = Color.Red; * } */ private void fillCmp(long code) { try { MainCmp mpc = new MainCmp(); mpc.GetMainCmpByName(Properties.Settings.Default.CmpName); cmpR.Clear(); cmpR = mpc.MainCmpToCompany(); cmpS.Clear(); cmpS.GetCompanyInfoByID(code); } catch (Exception e1) { new LogWriter(e1); } }
private void button2_Click(object sender, EventArgs e) { ///////////////// LogMe //////////////////////// String function = this.GetType().FullName + " - " + System.Reflection.MethodBase.GetCurrentMethod().Name; String usedQC = "Save to db"; String data = ""; String Result = ""; LogWriter lw = new LogWriter(); //////////////////////////////////////////////// /// Dictionary <String, int> groupArr = new Dictionary <string, int>(); int ind; ind = comboBox5.FindStringExact(comboBox5.Text); if (ind < 0) { comboBox5.ResetText(); } OTPNumber = ""; if (this.label2.Text.Equals("Name")) { Result = "Please select company, nothing done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); } else if (this.listView1.Items.Count == 0) { Result = "There is no items in list, nothing done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); } else { MainCmp mpc = new MainCmp(); mpc.GetMainCmpByName(Properties.Settings.Default.CmpName); cmpS.Clear(); cmpS = mpc.MainCmpToCompany(); if (cmpR.GetCompanyByName(label2.Text.Trim())) { try { List <String> arr = new List <string>(); ConnectionHelper cn = new ConnectionHelper(); using (SqlConnection cnnPR = cn.Connect(WorkingUser.Username, WorkingUser.Password)) { QueryCommands qc = new QueryCommands(); if (cn.TestConnection(cnnPR)) { //Provjera da li brojcano odgovaraju dijelovi String testStr; groupArr.Add(listView1.Items[0].SubItems[2].Text + "_" + listView1.Items[0].SubItems[3].Text + "_" + listView1.Items[0].SubItems[4].Text + "_" + listView1.Items[0].SubItems[5].Text + "_" + WorkingUser.RegionID.ToString(), 1); for (int i = 1; i < listView1.Items.Count; i++) { testStr = listView1.Items[i].SubItems[2].Text + "_" + listView1.Items[i].SubItems[3].Text + "_" + listView1.Items[i].SubItems[4].Text + "_" + listView1.Items[i].SubItems[5].Text + "_" + WorkingUser.RegionID.ToString(); if (groupArr.ContainsKey(testStr)) { groupArr[testStr] = groupArr[testStr] + 1; } else { groupArr.Add(testStr, 1); } } for (int i = 0; i < groupArr.Count(); i++) { var testArr = groupArr.ElementAt(i).Key.Split('_'); int prtConut = qc.GetPartCountByCodeSNCNStateStorage(WorkingUser.Username, WorkingUser.Password, long.Parse(testArr[0]), testArr[1], testArr[2], testArr[3], long.Parse(testArr[4])); if (groupArr[groupArr.ElementAt(i).Key] > prtConut) { data = testArr[0] + ", " + testArr[1] + ", " + testArr[2] + ", " + testArr[3] + ", " + prtConut + ", " + groupArr[groupArr.ElementAt(i).Key]; Result = "You do not have enough patrs in you storage:" + "\n\n Code: " + testArr[0] + "\n SN: " + testArr[1] + "\n CN: " + testArr[2] + "\n State: " + testArr[3] + "\n\nYou have: " + prtConut + "\nYou want: " + groupArr[groupArr.ElementAt(i).Key] + "\n\nNothing Done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result, "Caution", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } //Provjera da li se dijelovi nalaze u mom skladistu for (int i = 0; i < listView1.Items.Count; i++) { if (qc.GetPartIDCompareCodeSNCNStorage(WorkingUser.Username, WorkingUser.Password, long.Parse(listView1.Items[i].SubItems[2].Text), listView1.Items[i].SubItems[3].Text, listView1.Items[i].SubItems[4].Text, WorkingUser.RegionID)[0].Equals("nok")) { data = listView1.Items[i].SubItems[2].Text + ", " + listView1.Items[i].Index + 1; Result = "There is no part in your storage with: \n\n Code: " + listView1.Items[i].SubItems[2].Text + "\n on position " + (listView1.Items[i].Index + 1) + ". \n\nNothing Done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } } //Provjera i spremanje u bazu List <String> allRegions = new List <string>(); allRegions = qc.GetAllRegions(); int index = resultArrC.FindIndex(resultArrC => resultArrC.Name.Equals(label2.Text)); if (resultArrC[index].RegionID != WorkingUser.RegionID) { for (int i = 0; i < listView1.Items.Count; i++) // vec imam provjeru gore kod unosa ali neka ostane(tamo je po imenu) { //long test = long.Parse(listView1.Items[i].SubItems[2].Text.Substring(4)); //DecoderBB long test = Decoder.GetFullPartCodeLng(listView1.Items[i].SubItems[2].Text); if (!resultArrSearchCode.Contains(test.ToString())) { data = test.ToString() + ", " + listView1.Items[i].Index + 1; Result = "There is no part in 'Sifrarnik' with code, = " + test.ToString() + "\n" + "on position " + (listView1.Items[i].Index + 1) + " \n\nNothing Done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } } //Provjera da li se dijelovi nalaze u mom skladistu i dohvacanje dijelova List <Part> partList = new List <Part>(); String napomenaOTP = napomenaOTPPrint = textBox4.Text; for (int i = 0; i < groupArr.Count(); i++) { PartSifrarnik tempSifPart = new PartSifrarnik(); List <Part> tempParts = new List <Part>(); Part tempPart = new Part(); tempSifPart.GetPart(Decoder.GetFullPartCodeStr(listView1.Items[i].SubItems[2].Text)); tempParts = tempPart.GetListOfParts(long.Parse(groupArr.ElementAt(i).Key.Split('_')[0]), groupArr.ElementAt(i).Key.Split('_')[1], groupArr.ElementAt(i).Key.Split('_')[2], groupArr.ElementAt(i).Key.Split('_')[3], long.Parse(groupArr.ElementAt(i).Key.Split('_')[4])); if (tempParts.Count() < groupArr[groupArr.ElementAt(i).Key]) { data = groupArr.ElementAt(i).Key.Split('_')[0] + ", " + groupArr.ElementAt(i).Key.Split('_')[1] + ", " + groupArr.ElementAt(i).Key.Split('_')[2] + ", " + groupArr.ElementAt(i).Key.Split('_')[3] + ", " + tempParts.Count + ", " + groupArr[groupArr.ElementAt(i).Key]; Result = "There is no part in your storage with:" + "" + "\n\n Code: " + groupArr.ElementAt(i).Key.Split('_')[0] + "\n SN: " + groupArr.ElementAt(i).Key.Split('_')[1] + "\n CN: " + groupArr.ElementAt(i).Key.Split('_')[2] + "\n State: " + groupArr.ElementAt(i).Key.Split('_')[3] + "\n\nYou have: " + tempParts.Count + "\nYou want: " + groupArr[groupArr.ElementAt(i).Key] + "\n\nNothing Done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result, "Caution", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); textBox1.SelectAll(); textBox1.Focus(); return; } else { int kk = 0; foreach (Part prt in tempParts) { partList.Add(prt); kk++; if (kk == groupArr[groupArr.ElementAt(i).Key]) { break; } } } } //SPREMANJE U BAZU if (resultArrC[index].RegionID != Properties.Settings.Default.OstaliIDRegion && resultArrC[index].RegionID != Properties.Settings.Default.TransportIDRegion && resultArrC[index].RegionID != Properties.Settings.Default.ServisIDRegion) { OTPNumber = qc.OTPUnesiUredajeDaSuPrimljeniInner(WorkingUser.Username, WorkingUser.Password, partList, cmpR, cmpS, textBox4.Text, 0); } else if (resultArrC[index].RegionID != Properties.Settings.Default.TransportIDRegion && resultArrC[index].RegionID != Properties.Settings.Default.ServisIDRegion) { OTPNumber = qc.OTPUnesiUredajeDaSuPrimljeni(WorkingUser.Username, WorkingUser.Password, partList, cmpR, cmpS, textBox4.Text, br.FilID); } else { Result = "Hm... You cant send part to service!"; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } if (!OTPNumber.Equals("nok")) { PovijestLog pl = new PovijestLog(); Boolean saved = false; for (int k = 0; k < partList.Count; k++) { List <Part> tempPart = new List <Part>(); tempPart.Clear(); tempPart.Add(new Part()); tempPart.Add(partList[k]); if (pl.SaveToPovijestLog(tempPart, DateTime.Now.ToString("dd.MM.yy."), napomenaOTP, cmpR.Name, "", "", "OTP " + Properties.Settings.Default.ShareDocumentName, tempPart[1].State)) { saved = true; } else { saved = false; Properties.Settings.Default.ShareDocumentName = ""; break; } } if (Program.SaveDocumentsPDF) { saveToPDF(partList); } if (saved) { Result = "DONE, document nbr. OTP '" + OTPNumber + "'."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); partListPrint.Clear(); partListPrint.AddRange(partList); isOtpremnicaSaved = true; listView1.Clear(); listView1.View = View.Details; listView1.Columns.Add("RB"); listView1.Columns.Add("Name"); listView1.Columns.Add("Code"); listView1.Columns.Add("SN"); listView1.Columns.Add("CN"); listView1.Columns.Add("Condition"); textBox4.Clear(); napomenaOTPPrint = napomenaOTP; } else { Result = "DONE, document nbr. 'OTP " + OTPNumber + "', but not saved in PL."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); partListPrint.Clear(); partListPrint.AddRange(partList); isOtpremnicaSaved = true; listView1.Clear(); listView1.View = View.Details; listView1.Columns.Add("RB"); listView1.Columns.Add("Name"); listView1.Columns.Add("Code"); listView1.Columns.Add("SN"); listView1.Columns.Add("CN"); listView1.Columns.Add("Condition"); textBox4.Clear(); napomenaOTPPrint = napomenaOTP; } } } else { Result = "Hm... Same receiving and sending company?!"; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } } cnnPR.Close(); } } catch (Exception e1) { new LogWriter(e1); MessageBox.Show(e1.Message); textBox1.SelectAll(); textBox1.Focus(); } } this.printPrewBT.Enabled = isOtpremnicaSaved; } }
private void FindPart() { if (this.textBox1.TextLength > 12) { try { Program.LoadStart(); QueryCommands qc = new QueryCommands(); QueryCommands qc1 = new QueryCommands(); QueryCommands qc2 = new QueryCommands(); List <String> sendArr = new List <string>(); List <String> resultArr = new List <string>(); List <String> resultArr1 = new List <string>(); List <String> resultArr2 = new List <string>(); List <String> resultArr3 = new List <string>(); List <String> resultArrG = new List <string>(); List <String> resultArrNG = new List <string>(); ConnectionHelper cn = new ConnectionHelper(); for (int i = 1; i <= regionCnt; i++) { Control ctn1 = this.Controls["lblAdd_" + i]; Control ctn2 = this.Controls["txtBoxAddNG_" + i]; Control ctn3 = this.Controls["txtBoxAddG_" + i]; this.Controls.Remove(ctn1); this.Controls.Remove(ctn2); this.Controls.Remove(ctn3); } positionX = 20; //positionY = 100; positionPlusY = 0; resultArr3 = qc.GetAllRegions(); PartSifrarnik prt = new PartSifrarnik(); this.label7.Text = prt.PartCode.ToString(); Company cmpO = new Company(); Company cmpC = new Company(); Boolean cmpOb = false; Boolean cmpCb = false; if (Decoder.GetOwnerCode(textBox1.Text).Equals("01")) { MainCmp mpc = new MainCmp(); mpc.GetMainCmpByName(Properties.Settings.Default.CmpName); cmpO = mpc.MainCmpToCompany(); cmpOb = true; } else { cmpOb = cmpO.GetCompanyInfoByCode(Decoder.GetOwnerCode(textBox1.Text)); } if (Decoder.GetOwnerCode(textBox1.Text).Equals("01")) { MainCmp mpc = new MainCmp(); mpc.GetMainCmpByName(Properties.Settings.Default.CmpName); cmpC = mpc.MainCmpToCompany(); cmpCb = true; } else { cmpCb = cmpC.GetCompanyInfoByCode(Decoder.GetCustomerCode(textBox1.Text)); } //if (prt.GetPart(textBox1.Text.Substring(4, 9)) && cmpO.GetCompanyInfoByCode(textBox1.Text.Substring(0, 2)) && cmpC.GetCompanyInfoByCode(textBox1.Text.Substring(2, 2))) //DecoderBB if (prt.GetPart(Decoder.GetFullPartCodeStr(textBox1.Text)) && cmpOb && cmpCb) { this.textBox2.ResetText(); this.textBox2.Text = prt.FullName; ////this.label18.Text = string.Format("{0:0000 000 000 000}", long.Parse(this.textBox1.Text)); this.label18.Text = this.textBox1.Text; this.label7.Text = cmpO.Name; this.label8.Text = cmpC.Name; this.label9.Text = cmpO.Code; this.label10.Text = cmpC.Code; this.label11.Text = prt.CategoryName; this.label12.Text = prt.PartName; this.label13.Text = string.Format("{0:000}", (prt.CategoryCode / 1000000)); this.label14.Text = string.Format("{0:000}", (prt.PartCode / 1000)); this.label15.Text = prt.SubPartName; this.label16.Text = string.Format("{0:000}", prt.SubPartCode); this.label21.Text = string.Format("{0:C}", prt.PriceInKn); this.label22.Text = string.Format("{0:C}", prt.PriceOutKn); var culture = new CultureInfo("de-DE"); this.label25.Text = string.Format(culture, "{0:C}", prt.PriceInEur); this.label26.Text = string.Format(culture, "{0:C}", prt.PriceOutEur); this.label29.Text = prt.PartNumber; sendArr.Clear(); resultArr = qc.InTransport(WorkingUser.Username, WorkingUser.Password, long.Parse(label18.Text.Trim())); this.label30.Text = resultArr[0] == "nok" ? "0" : resultArr[0]; this.label32.Text = prt.Packing; this.textBox3.Text = "*" + this.label18.Text + "*"; regionCnt = (resultArr3.Count() / 3); int j = 1; int jj = 0; for (int i = 1; i <= regionCnt; i++) { if (!resultArr3[j].Equals("O")) { Label lblAdd = new Label(); this.Controls.Add(lblAdd); lblAdd.Size = new Size(50, 20); positionY = this.panel21.Bounds.Bottom + 40 + positionPlusY;// + (40 * i); lblAdd.Location = new Point(positionX, positionY); lblAdd.Font = new Font(lblAdd.Font, FontStyle.Bold); lblAdd.Name = "lblAdd_" + i; lblAdd.Text = resultArr3[j] + " - " + resultArr3[j - 1]; TextBox txtBoxAddG = new TextBox(); this.Controls.Add(txtBoxAddG); txtBoxAddG.Size = new Size(60, 60); positionY = this.panel21.Bounds.Bottom + 60 + positionPlusY;// + (40 * i); txtBoxAddG.Location = new Point(positionX, positionY); txtBoxAddG.BackColor = Color.LightGreen; txtBoxAddG.TextAlign = HorizontalAlignment.Center; txtBoxAddG.ReadOnly = true; resultArrG.Clear(); sendArr.Clear(); if (resultArr3[jj + 1].Equals("S")) { resultArrG = qc.PartsCntGS(WorkingUser.Username, WorkingUser.Password, long.Parse(label18.Text.Trim())); } else { resultArrG = qc.PartsCntG(WorkingUser.Username, WorkingUser.Password, long.Parse(label18.Text.Trim()), long.Parse(resultArr3[jj].Trim())); } if (resultArr3[jj + 1].Equals("S")) { txtBoxAddG.Name = "txtBoxAddSG_" + i; } else { txtBoxAddG.Name = "txtBoxAddG_" + i; } txtBoxAddG.Text = resultArrG[0] == "nok" ? "" : resultArrG[0].Equals("0") ? "" : resultArrG[0]; if (!txtBoxAddG.Text.Equals("")) { totalG = totalG + int.Parse(txtBoxAddG.Text); } TextBox txtBoxAddNG = new TextBox(); this.Controls.Add(txtBoxAddNG); txtBoxAddNG.Size = new Size(60, 60); positionX = txtBoxAddG.Bounds.Right + 10; txtBoxAddNG.Location = new Point(positionX, positionY); txtBoxAddNG.BackColor = Color.LightCoral; txtBoxAddNG.TextAlign = HorizontalAlignment.Center; txtBoxAddNG.ReadOnly = true; resultArrNG.Clear(); sendArr.Clear(); if (resultArr3[jj + 1].Equals("S")) { resultArrNG = qc.PartsCntNGS(WorkingUser.Username, WorkingUser.Password, long.Parse(label18.Text.Trim())); } else { resultArrNG = qc.PartsCntNG(WorkingUser.Username, WorkingUser.Password, long.Parse(label18.Text.Trim()), long.Parse(resultArr3[jj].Trim())); } if (resultArr3[jj + 1].Equals("S")) { txtBoxAddNG.Name = "txtBoxAddSNG_" + i; } else { txtBoxAddNG.Name = "txtBoxAddNG_" + i; } txtBoxAddNG.Text = resultArrNG[0] == "nok" ? "" : resultArrNG[0].Equals("0") ? "" : resultArrNG[0]; if (!txtBoxAddNG.Text.Equals("")) { totalNG = totalNG + int.Parse(txtBoxAddNG.Text); } txtBoxAddNG.Click += new EventHandler(showList); txtBoxAddG.Click += new EventHandler(showList); positionX = positionX + 80; if ((positionX + 150) >= ClientRectangle.Width) { positionPlusY = positionPlusY + 50; positionX = 20; } } j = j + 3; jj = jj + 3; } textBox4.Text = totalG.ToString(); textBox5.Text = totalNG.ToString(); } else { clearME(); } } catch (Exception e1) { new LogWriter(e1); MessageBox.Show(e1.Message); clearME(); return; } finally { Program.LoadStop(); this.Focus(); } } }
private void button2_Click(object sender, EventArgs e) { ///////////////// LogMe //////////////////////// String function = this.GetType().FullName + " - " + System.Reflection.MethodBase.GetCurrentMethod().Name; String usedQC = "Save to db"; String data = ""; String Result = ""; LogWriter lw = new LogWriter(); //////////////////////////////////////////////// /// IUSNumber = ""; if (this.label2.Text.Equals("Name")) { Result = "Please select company, nothing done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); isFocused = true; textBox1.Focus(); isFocused = false; } else if (this.listView1.Items.Count == 0) { Result = "There is no items in list, nothing done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); isFocused = true; textBox1.Focus(); isFocused = false; } else { //List<Part> listOfOtpPartsPrimka = new List<Part>(); MainCmp mpc = new MainCmp(); mpc.GetMainCmpByName(Properties.Settings.Default.CmpName); cmpR.Clear(); cmpR = mpc.MainCmpToCompany(); if (cmpS.GetCompanyByName(label2.Text.Trim())) { try { List <String> arr = new List <string>(); ConnectionHelper cn = new ConnectionHelper(); using (SqlConnection cnnIUS = cn.Connect(WorkingUser.Username, WorkingUser.Password)) { if (cn.TestConnection(cnnIUS)) { //Provjera da li se dijelovi nalaze u mom skladistu QueryCommands qc = new QueryCommands(); for (int i = 0; i < listView1.Items.Count; i++) // vec imam provjeru gore kod unosa ali neka ostane(tamo je po imenu) { if (qc.GetPartIDCompareCodeSNCNStorageState(WorkingUser.Username, WorkingUser.Password, long.Parse(listView1.Items[i].SubItems[2].Text), listView1.Items[i].SubItems[3].Text, listView1.Items[i].SubItems[4].Text, WorkingUser.RegionID, "ng")[0].Equals("nok")) { data = listView1.Items[i].SubItems[2].Text + "\n on position " + (listView1.Items[i].Index + 1); Result = "In your storage does not exist NG part with: \n\n Code: " + listView1.Items[i].SubItems[2].Text + "\n on position " + (listView1.Items[i].Index + 1) + "\n\nNothing Done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); isFocused = true; textBox1.Focus(); isFocused = false; return; } } //Provjera i spremanje u bazu List <String> allRegions = new List <string>(); allRegions = qc.GetAllRegions(); int index = resultArrC.FindIndex(resultArrC => resultArrC.Name.Equals(label2.Text)); List <Part> partList = new List <Part>(); String napomenaIUS = textBox4.Text; for (int i = 0; i < listView1.Items.Count; i++) { PartSifrarnik tempSifPart = new PartSifrarnik(); Part tempPart = new Part(); foreach (Part part in partsArr) { tempSifPart.GetPart(Decoder.GetFullPartCodeStr(listView1.Items[i].SubItems[2].Text)); if (part.PartialCode == tempSifPart.FullCode && part.SN.ToUpper().Equals(listView1.Items[i].SubItems[3].Text.ToUpper()) && part.CN.ToUpper().Equals(listView1.Items[i].SubItems[4].Text.ToUpper()) && !partList.Contains(part)) { tempPart = part; tempPart.StorageID = WorkingUser.RegionID; tempPart.State = "sng"; tempPart.CompanyO = Decoder.GetOwnerCode(listView1.Items[i].SubItems[2].Text); tempPart.CompanyC = Decoder.GetCustomerCode(listView1.Items[i].SubItems[2].Text); break; } } String tmpResult = qc.GetListPartsByPartIDFromParts(tempPart.PartID)[0]; if (tmpResult.Equals("nok")) { data = listView1.Items[i].SubItems[2].Text + "\n on position " + (listView1.Items[i].Index + 1); Result = "There is no NG part in your storage with: \n\n Code: " + listView1.Items[i].SubItems[2].Text + "\n on position " + (listView1.Items[i].Index + 1) + ". \n\nNothing Done."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); textBox1.SelectAll(); isFocused = true; textBox1.Focus(); isFocused = false; return; } else { tempPart.PartID = long.Parse(tmpResult); partList.Add(tempPart); } } IUSNumber = qc.IUSPrebaciUServis(WorkingUser.Username, WorkingUser.Password, partList, WorkingUser.RegionID, cmpS.ID, napomenaIUS); if (!IUSNumber.Equals("nok")) { partsArr = partsArr.Except(partList).ToList(); PovijestLog pl = new PovijestLog(); if (Program.SaveDocumentsPDF) { saveToPDF(partList); } if (pl.SaveToPovijestLog(partList, DateTime.Now.ToString("dd.MM.yy."), napomenaIUS, cmpS.Name, "", "", "IUS " + Properties.Settings.Default.ShareDocumentName, "sng")) { Properties.Settings.Default.ShareDocumentName = ""; Result = "DONE, document nbr. IUS '" + IUSNumber + "'."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); partListPrint.Clear(); partListPrint.AddRange(partList); isIUSSaved = true; listView1.Clear(); listView1.View = View.Details; listView1.Columns.Add("RB"); listView1.Columns.Add("Name"); listView1.Columns.Add("Code"); listView1.Columns.Add("SN"); listView1.Columns.Add("CN"); listView1.Columns.Add("Condition"); textBox4.Clear(); napomenaIUSPrint = napomenaIUS; } else { Result = "DONE, document nbr. 'IUS " + IUSNumber + "', but not saved in PL."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); partListPrint.Clear(); partListPrint.AddRange(partList); isIUSSaved = true; listView1.Clear(); listView1.View = View.Details; listView1.Columns.Add("RB"); listView1.Columns.Add("Name"); listView1.Columns.Add("Code"); listView1.Columns.Add("SN"); listView1.Columns.Add("CN"); listView1.Columns.Add("Condition"); textBox4.Clear(); napomenaIUSPrint = napomenaIUS; } } else { Result = "Unknown error in QUERY."; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result); napomenaIUSPrint = ""; isIUSSaved = false; } //} } cnnIUS.Close(); } } catch (Exception e1) { new LogWriter(e1); MessageBox.Show(e1.Message); textBox1.SelectAll(); isFocused = true; textBox1.Focus(); isFocused = false; } } this.printPrewBT.Enabled = isIUSSaved; } }
private void button2_Click(object sender, EventArgs e) { Program.SaveStart(); ///////////////// LogMe //////////////////////// String function = this.GetType().FullName + " - " + System.Reflection.MethodBase.GetCurrentMethod().Name; String usedQC = "Save to db"; String data = ""; String Result = ""; LogWriter lw = new LogWriter(); //////////////////////////////////////////////// /// PrimkaNumber = ""; if (this.label2.Text.Equals("Name")) { Result = "Please select company, nothing done."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); } else if (this.listView1.Items.Count == 0) { Result = "There is no items in list, nothing done."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); } else { List <Part> listOfOtpPartsFromOTP = new List <Part>(); //List<Part> listOfOtpPartsPrimka = new List<Part>(); MainCmp mpc = new MainCmp(); mpc.GetMainCmpByName(Properties.Settings.Default.CmpName); cmpR.Clear(); cmpR = mpc.MainCmpToCompany(); if (cmpS.GetCompanyByName(label2.Text.Trim())) { try { List <String> arr = new List <string>(); SqlCommand commandPR; String queryPR; ConnectionHelper cn = new ConnectionHelper(); using (SqlConnection cnnPR = cn.Connect(WorkingUser.Username, WorkingUser.Password)) { if (cn.TestConnection(cnnPR)) { //Provjera da li se dijelovi nalaze u mom skladistu QueryCommands qc = new QueryCommands(); for (int i = 0; i < listView1.Items.Count; i++) // vec imam provjeru gore kod unosa ali neka ostane(tamo je po imenu) { if (!listView1.Items[i].SubItems[3].Text.Equals("") && !listView1.Items[i].SubItems[4].Text.Equals("")) { if (!qc.GetPartIDCompareCodeSNCNStorage(WorkingUser.Username, WorkingUser.Password, long.Parse(listView1.Items[i].SubItems[2].Text), listView1.Items[i].SubItems[3].Text, listView1.Items[i].SubItems[4].Text, WorkingUser.RegionID)[0].Equals("nok")) { data = listView1.Items[i].SubItems[2].Text + ", " + listView1.Items[i].Index + 1; Result = "In your storage, part with: \n\n Code: " + listView1.Items[i].SubItems[2].Text + "\n on position " + (listView1.Items[i].Index + 1) + "\n, already exist in DB.\n\nNothing Done."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } } } //Provjera i spremanje u bazu List <String> allRegions = new List <string>(); allRegions = qc.GetAllRegions(); int index = resultArrC.FindIndex(resultArrC => resultArrC.Name.Equals(label2.Text)); if (resultArrC[index].RegionID != Properties.Settings.Default.OstaliIDRegion && resultArrC[index].RegionID != Properties.Settings.Default.TransportIDRegion) { queryPR = "Select RegionIDOut from Transport where RegionIDIn = " + WorkingUser.RegionID + " and UsersUserIDIn is NULL"; commandPR = new SqlCommand(queryPR, cnnPR); commandPR.ExecuteNonQuery(); SqlDataReader dataReader = commandPR.ExecuteReader(); dataReader.Read(); if (dataReader.HasRows) { do { openedTransactionSenderRegions.Add(dataReader["RegionIDOut"].ToString()); } while (dataReader.Read()); dataReader.Close(); } else { data = resultArrC[index].RegionID + ", " + Properties.Settings.Default.OstaliIDRegion + ", " + resultArrC[index].RegionID + ", " + Properties.Settings.Default.TransportIDRegion; Result = "From selected region nothing is sent to you. \n\n Nothing Done."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } for (int i = 0; i < listView1.Items.Count; i++) // vec imam provjeru gore kod unosa ali neka ostane(tamo je po imenu) { //long test = long.Parse(listView1.Items[i].SubItems[2].Text.Substring(4)); //DecoderBB long test = Decoder.GetFullPartCodeLng(listView1.Items[i].SubItems[2].Text); if (!resultArrSearchCode.Contains(test.ToString())) { data = test.ToString() + ", " + listView1.Items[i].Index + 1; Result = "There is no part in 'Sifrarnik' with code, = " + test.ToString() + "\n" + "on position " + (listView1.Items[i].Index + 1) + " \n\n Nothing Done."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } } //Provjera da li sam odabrao dobru tvrtku koja salje Boolean exist = false; for (int j = 0; j < openedTransactionSenderRegions.Count; j++) { if (cmpS.RegionID.ToString().Equals(openedTransactionSenderRegions[j])) { exist = true; break; } } if (!exist) { data = cmpS.RegionID.ToString(); Result = "Please select right company! \n\n Nothing done."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } openedOTP = qc.GetAllOpenedOTP(WorkingUser.Username, WorkingUser.Password, WorkingUser.RegionID); long selectedOTP = 0; if (openedOTP[0].Equals("nok")) { data = openedOTP[0].ToString(); Result = "There is no opened documents for you!"; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } using (Selector selector = new Selector()) { selector.SetLabelText = "Please select receiving document"; selector.SetComboBoxStringList = openedOTP; selector.ShowDialog(); if (selector.GetOTPValue > 0) { selectedOTP = selector.GetOTPValue; } else { data = selectedOTP.ToString(); Result = "Please select valid receiving document! \n\n Nothing done."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } } Part otpParts = new Part(); listOfOtpPartsFromOTP = otpParts.GetListOfPartsOTPParts(selectedOTP); int counterLP = listOfOtpPartsFromOTP.Count; int counterLV = listView1.Items.Count; Boolean same = false; for (int i = 0; i < counterLP; i++) { for (int ii = 0; ii < counterLV; ii++) { if (listOfOtpPartsFromOTP[i].CodePartFull == long.Parse(listView1.Items[ii].SubItems[2].Text) && listOfOtpPartsFromOTP[i].SN.ToUpper().Equals(listView1.Items[ii].SubItems[3].Text.ToUpper()) && listOfOtpPartsFromOTP[i].CN.ToUpper().Equals(listView1.Items[ii].SubItems[4].Text.ToUpper())) { same = true; break; } else { same = false; data = listOfOtpPartsFromOTP[i].CodePartFull.ToString() + ", " + long.Parse(listView1.Items[ii].SubItems[2].Text).ToString() + ", " + listOfOtpPartsFromOTP[i].SN.ToUpper().Equals(listView1.Items[ii].SubItems[3].Text.ToUpper()).ToString() + ", " + listOfOtpPartsFromOTP[i].CN.ToUpper().Equals(listView1.Items[ii].SubItems[4].Text.ToUpper()).ToString(); } } if (!same) { break; } } if (!same || counterLP != counterLV) { Result = "Receiving document and sending document items do not match ! \n\n Nothing done."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); textBox1.SelectAll(); textBox1.Focus(); return; } PrimkaNumber = qc.PRIMUnesiUredajeDaSuPrimljeniInnner(WorkingUser.Username, WorkingUser.Password, listOfOtpPartsFromOTP, cmpS.RegionID, cmpR.RegionID, selectedOTP, textBox4.Text); if (!PrimkaNumber.Equals("nok")) { PovijestLog pl = new PovijestLog(); Boolean saved = false; for (int k = 0; k < listOfOtpPartsFromOTP.Count; k++) { List <Part> tempPart = new List <Part>(); tempPart.Clear(); tempPart.Add(listOfOtpPartsFromOTP[k]); if (pl.SaveToPovijestLog(tempPart, DateTime.Now.ToString("dd.MM.yy."), textBox4.Text, cmpS.Name, "", "", "PRIM " + Properties.Settings.Default.ShareDocumentName, tempPart[0].State)) { saved = true; Properties.Settings.Default.ShareDocumentName = ""; } else { saved = false; break; } } if (saved) { data = PrimkaNumber; Result = "DONE, document nbr. 'PRIM " + PrimkaNumber + "'."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); isPrimkaSaved = true; listView1.Clear(); listView1.View = View.Details; partListPrint.Clear(); partListPrint.AddRange(listOfOtpPartsFromOTP); //partListPrint = listOfOtpPartsPrimka; listView1.Columns.Add("RB"); listView1.Columns.Add("Name"); listView1.Columns.Add("Code"); listView1.Columns.Add("SN"); listView1.Columns.Add("CN"); listView1.Columns.Add("Condition"); textBox4.Clear(); } else { data = PrimkaNumber; Result = "DONE, document nbr. 'PRIM " + PrimkaNumber + "', but not saved in PL."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); listView1.Clear(); listView1.View = View.Details; partListPrint.Clear(); partListPrint.AddRange(listOfOtpPartsFromOTP); //partListPrint = listOfOtpPartsPrimka; listView1.Columns.Add("RB"); listView1.Columns.Add("Name"); listView1.Columns.Add("Code"); listView1.Columns.Add("SN"); listView1.Columns.Add("CN"); listView1.Columns.Add("Condition"); textBox4.Clear(); } } else { Result = "Unknown error in QUERYinner."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); isPrimkaSaved = false; } } else if (resultArrC[index].RegionID == Properties.Settings.Default.OstaliIDRegion) { List <Part> partList = new List <Part>(); String napomenaPRIM = napomenaPRIMPrint = textBox4.Text; for (int i = 0; i < listView1.Items.Count; i++) { PartSifrarnik tempSifPart = new PartSifrarnik(); Part tempPart = new Part(); //tempSifPart.GetPart(listView1.Items[i].SubItems[2].Text.Substring(4)); //DecoderBB tempSifPart.GetPart(Decoder.GetFullPartCodeStr(listView1.Items[i].SubItems[2].Text)); tempPart.PartialCode = tempSifPart.FullCode; tempPart.SN = listView1.Items[i].SubItems[3].Text; tempPart.CN = listView1.Items[i].SubItems[4].Text; tempPart.DateIn = DateTime.Now.ToString("dd.MM.yy."); tempPart.StorageID = WorkingUser.RegionID; tempPart.State = listView1.Items[i].SubItems[5].Text; //tempPart.CompanyO = listView1.Items[i].SubItems[2].Text.Substring(0, 2); //DecoderBB tempPart.CompanyO = Decoder.GetOwnerCode(listView1.Items[i].SubItems[2].Text); //tempPart.CompanyC = listView1.Items[i].SubItems[2].Text.Substring(2, 2); //DecoderBB tempPart.CompanyC = Decoder.GetCustomerCode(listView1.Items[i].SubItems[2].Text); partList.Add(tempPart); } PrimkaNumber = qc.PRIMUnesiUredajeDaSuPrimljeni(WorkingUser.Username, WorkingUser.Password, partList, WorkingUser.RegionID, cmpS.ID, napomenaPRIM); if (!PrimkaNumber.Equals("nok")) { PovijestLog pl = new PovijestLog(); Boolean saved = false; for (int k = 0; k < partList.Count; k++) { List <Part> tempPart = new List <Part>(); tempPart.Clear(); tempPart.Add(partList[k]); if (pl.SaveToPovijestLog(tempPart, DateTime.Now.ToString("dd.MM.yy."), napomenaPRIM, cmpS.Name, "", "", "PRIM " + Properties.Settings.Default.ShareDocumentName, tempPart[0].State)) { saved = true; } else { saved = false; Properties.Settings.Default.ShareDocumentName = ""; break; } } if (Program.SaveDocumentsPDF) { saveToPDF(partList); } if (saved) { data = PrimkaNumber; Result = "DONE, document nbr. 'PRIM " + PrimkaNumber + "'."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); partListPrint.Clear(); partListPrint.AddRange(partList); isPrimkaSaved = true; listView1.Clear(); listView1.View = View.Details; listView1.Columns.Add("RB"); listView1.Columns.Add("Name"); listView1.Columns.Add("Code"); listView1.Columns.Add("SN"); listView1.Columns.Add("CN"); listView1.Columns.Add("Condition"); textBox4.Clear(); napomenaPRIMPrint = napomenaPRIM; } else { data = PrimkaNumber; Result = "DONE, document nbr. 'PRIM " + PrimkaNumber + "', but not saved in PL."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); partListPrint.Clear(); partListPrint.AddRange(partList); isPrimkaSaved = true; listView1.Clear(); listView1.View = View.Details; listView1.Columns.Add("RB"); listView1.Columns.Add("Name"); listView1.Columns.Add("Code"); listView1.Columns.Add("SN"); listView1.Columns.Add("CN"); listView1.Columns.Add("Condition"); textBox4.Clear(); napomenaPRIMPrint = napomenaPRIM; } } else { Result = "Unknown error in QUERYinner."; lw.LogMe(function, usedQC, data, Result); Program.SaveStop(); MessageBox.Show(Result); napomenaPRIMPrint = ""; isPrimkaSaved = false; } } } cnnPR.Close(); } } catch (Exception e1) { Program.SaveStop(); new LogWriter(e1); MessageBox.Show(e1.Message); textBox1.SelectAll(); textBox1.Focus(); } } this.printPrewBT.Enabled = isPrimkaSaved; this.selectPrinterPrintBtn.Enabled = isPrimkaSaved; } Program.SaveStop(); }