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) { ///////////////// 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 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(); }