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;
}
}
