private void ISSSelectorCb_SelectedIndexChanged(object sender, EventArgs e) { if (oneTimeISSSelectorCb) { if (obj != null) { obj = null; oneTimeISSSelectorCb = false; } ///////////////// LogMe //////////////////////// String function = this.GetType().FullName + " - " + System.Reflection.MethodBase.GetCurrentMethod().Name; String usedQC = "ISS loaded"; String data = ""; String Result = ""; LogWriter lw = new LogWriter(); //////////////////////////////////////////////// /// try { CleanMe(); listView2.Clear(); listView2.View = View.Details; listView2.Columns.Add("RB"); listView2.Columns.Add("Name"); listView2.Columns.Add("CodeO"); listView2.Columns.Add("SNO"); listView2.Columns.Add("CNO"); listView2.Columns.Add("CodeN"); listView2.Columns.Add("SNN"); listView2.Columns.Add("CNN"); listView2.Columns.Add("Date"); listView2.Columns.Add("Time"); listView2.Columns.Add("Work done"); listView2.Columns.Add("Comment"); long issID = long.Parse(ISSSelectorCb.SelectedItem.ToString()); Part mainPr = new Part(); //List<String> allISSInfo = new List<String>(); getISSList(issID.ToString(), "ID"); ISSid = issID; allISSInfo = qc.GetAllISSInfoById(issID); if (allISSInfo[0].Equals("nok")) { return; } totalTime = allISSInfo[6] + ":00"; mainPart = qc.SearchPartsInAllTablesBYPartID(long.Parse(allISSInfo[4]))[0]; PartTb.Text = mainPart.CodePartFull.ToString(); cmpCust.GetCompanyInfoByCode(Decoder.GetCustomerCode(mainPart.CodePartFull)); listIssParts.Clear(); listIssParts = qc.GetAllISSPartsByISSid(issID); NameTb.Text = Decoder.ConnectCodeName(sifrarnikArr, mainPart); SNTb.Text = mainPart.SN; CNTb.Text = mainPart.CN; DateInTb.Text = mainPart.DateIn; DateSentTb.Text = mainPart.DateSend; IDTb.Text = mainPart.PartID.ToString(); for (int i = 0; i < listIssParts.Count; i++) { ListViewItem lvi1 = new ListViewItem(listIssParts[i].RB.ToString().ToString()); lvi1.SubItems.Add(qc.PartInfoByFullCodeSifrarnik(mainPart.PartialCode).FullName); ////////////////////////////////////////////////////////////// if (listIssParts[i].PrtO.CodePartFull == 0) { lvi1.SubItems.Add(""); } else { lvi1.SubItems.Add(listIssParts[i].PrtO.CodePartFull.ToString()); } if (listIssParts[i].PrtO.SN == null) { lvi1.SubItems.Add(""); } else { lvi1.SubItems.Add(listIssParts[i].PrtO.SN.ToString()); } if (listIssParts[i].PrtO.CN == null) { lvi1.SubItems.Add(""); } else { lvi1.SubItems.Add(listIssParts[i].PrtO.CN.ToString()); } ////////////////////////////////////////////////////////////// if (listIssParts[i].PrtN.CodePartFull == 0) { lvi1.SubItems.Add(""); } else { lvi1.SubItems.Add(listIssParts[i].PrtN.CodePartFull.ToString()); } if (listIssParts[i].PrtN.SN == null) { lvi1.SubItems.Add(""); } else { lvi1.SubItems.Add(listIssParts[i].PrtN.SN.ToString()); } if (listIssParts[i].PrtN.CN == null) { lvi1.SubItems.Add(""); } else { lvi1.SubItems.Add(listIssParts[i].PrtN.CN.ToString()); } ////////////////////////////////////////////////////////////// lvi1.SubItems.Add(allISSInfo[1]); lvi1.SubItems.Add(listIssParts[i].Time.ToString()); lvi1.SubItems.Add(listIssParts[i].Work.ToString()); lvi1.SubItems.Add(listIssParts[i].Comment.ToString()); if (listView2.Items.Count > 1) { listView2.EnsureVisible(listView2.Items.Count - 1); } listView2.Items.Add(lvi1); } for (int i = 0; i < 12; i++) { listView2.AutoResizeColumn(i, ColumnHeaderAutoResizeStyle.ColumnContent); listView2.AutoResizeColumn(i, ColumnHeaderAutoResizeStyle.HeaderSize); } rb = listView2.Items.Count + 1; data = cmpCust.Name + ", " + cmpM.Name + ", " + "Sifrarnik arr cnt " + sifrarnikArr.Count + ", " + mainPart.CodePartFull + ", " + "listIssParts cnt " + listIssParts.Count + ", " + ISSid.ToString() + ", " + Properties.strings.ServiceReport + ", " + Properties.strings.customer + ", false"; Result = "ISS selected " + ISSid; lw.LogMe(function, usedQC, data, Result); SystemSounds.Hand.Play(); } catch (Exception e1) { data = ISSid + Environment.NewLine; Result = e1.Message; lw.LogMe(function, usedQC, data, Result); MessageBox.Show(Result, "NOT SAVED", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { oneTimeISSSelectorCb = true; } }
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; } }