// Jovana 29.11.21 - ne koristi se //private void password_Enter(object sender, EventArgs e) //{ // PasswordTextBox.Text = ""; //} //private void username_Enter(object sender, EventArgs e) //{ // UsernameTextBox.Text = ""; //} private void UsernameTextBox_Leave(object sender, EventArgs e) { //pictureBox1.Visible = false; aliasDatabase = new Dictionary <string, string>(); cmbBaze.Items.Clear(); CmbOrg.Items.Clear(); CmbOrg.Visible = false; lblGrupa.Visible = false; cmbBaze.Visible = false; lblBaza.Visible = false; if (UsernameTextBox.Text != "") { //var fileReader = File.ReadAllText(Application.StartupPath + @"\XmlLat\xxxx.ini"); Console.WriteLine(Application.StartupPath); //Djora 30.11.20 //var fileReader = File.ReadAllText(Application.StartupPath+ @"\xxxx.ini"); //ivana 15.10.2021. da ne bi pucao, mozda treba obraditi else var fileReader = ""; if (System.IO.File.Exists(@"\\192.168.1.4\Repozitorijum\ISBankom\XXXX\xxxx.ini")) { fileReader = File.ReadAllText(@"\\192.168.1.4\Repozitorijum\ISBankom\XXXX\xxxx.ini"); } else { MessageBox.Show("xxxx.ini Nedostupan."); return; } string[] separators11 = new[] { "[", "]" }; int n = 0; string struser = UsernameTextBox.Text.ToLower(); string strobrada = ""; string[] words = fileReader.Split(separators11, StringSplitOptions.RemoveEmptyEntries); for (n = 0; n < words.Length; n++) { string cc = words[n].ToLower(); if (strobrada != "") { strobrada = words[n]; break; } if (cc == struser) { strobrada = words[n]; } if (cc == "logovanje") { string pom = words[n + 1]; char[] separators1 = { '#' }; pom = pom.Replace("\r\n", "#").Replace("\r", "").Replace("\n", ""); var result1 = pom.Split(separators1, StringSplitOptions.None); for (int j = 0; j < result1.Length; j++) { //steva 04.03.2021. if (result1[j].Contains("RptSlike=")) { ReportSlike = result1[j].Substring(result1[j].IndexOf("=") + 1); // break; } if (result1[j].Contains("Report=")) { ReportServer = result1[j].Substring(result1[j].IndexOf("=") + 1); // break; } //kraj steva 04.03.2021. //Jovana 19.02.21 Console.WriteLine(result1[j]); if (result1[j].Contains("Server=")) { if (result1[j].IndexOf("Server=") == 0) { ImeServera = result1[j].Substring(result1[j].IndexOf("=") + 1); } else { FileServer = result1[j].Substring(result1[j].IndexOf("=") + 1); } //break; } //tamara 22.4.2021. if (result1[j].Contains("SlikaZaposlenog=")) { SlikePutanja = result1[j].Substring(result1[j].IndexOf("=") + 1); } if ((result1[j].Length > 8 && result1[j].Substring(0, 9) == "Dokumenti")) { gDokumenti = result1[j].Substring(result1[j].IndexOf("=") + 3); } } } } //Jovana 19.02.21 gDokumenti = "\\" + FileServer + gDokumenti; // char[] separators = { '#','=' }; char[] separators = { '#' }; strobrada = strobrada.Replace("\r\n", "#").Replace("\r", "").Replace("\n", ""); //ivana 18.10.2021. aliasDatabase.Clear(); var result = strobrada.Split(separators, StringSplitOptions.None); int k = -1; for (n = 0; n < result.Length; n++) { if (result[n] != "") { if (result[n] == "IzborBaze=1") { strIzborBaze = result[n]; } //tamara 12.7.21. else if (result[n] == "IzborBaze=0") { strIzborBaze = result[n]; } if (result[n] == "IzborOrganizacionogDela=1") { strIzborOrganizacionogDela = result[n]; } //tamara 12.7.21. else if (result[n] == "IzborOrganizacionogDela=0") { strIzborOrganizacionogDela = result[n]; } if (result[n].Length > 4 && result[n].Substring(0, 4) == "Baza") { k++; if (result[n].Substring(0, 5) == "Baza1") { indexCurrentbaza = k; strCurrentbaza = result[n].Substring(result[n].IndexOf("=") + 1); } aliasDatabase.Add(result[n].Substring(result[n].IndexOf("-") + 1), result[n].Substring(result[n].IndexOf("=") + 1, result[n].IndexOf("-") - result[n].IndexOf("=") - 1)); cmbBaze.Items.Add(result[n].Substring(result[n].IndexOf("-") + 1)); } if ((result[n].Length > 15 && result[n].Substring(0, 16) == "OrganizacioniDeo")) { strOrgDefaultText = result[n].Substring(result[n].IndexOf("=") + 1); //grupa.AddItem(result[n].Substring(result[n].IndexOf("=") + 1)); } } } switch (strIzborBaze) { case "IzborBaze=0": //tamara 12.7.21. lblBaza.Visible = true; cmbBaze.Visible = true; cmbBaze.Enabled = false; cmbBaze.SelectedIndex = k > -1 ? indexCurrentbaza : -1; break; case "IzborBaze=1": lblBaza.Visible = true; cmbBaze.Visible = true; //ivana 13.10.2021. //cmbBaze.SelectedIndex = indexCurrentbaza; cmbBaze.SelectedIndex = k > -1 ? indexCurrentbaza : -1; break; } switch (strIzborOrganizacionogDela) { case "IzborOrganizacionogDela=0": CmbOrg.Items.Add(strOrgDefaultText); //tamara 12.7.21. lblGrupa.Visible = true; CmbOrg.Visible = true; CmbOrg.Enabled = false; CmbOrg.SelectedIndex = 0; break; case "IzborOrganizacionogDela=1": //ivana 8.12.2021. dodala sam Ccopy = 0 zbog 3. i 4. org.struk., jer su iste var query = "SELECT Naziv FROM OrganizacionaStruktura where Ccopy = 0"; var dataTable = DB.ReturnDataTable(query); for (int i = 0; i < dataTable.Rows.Count; i++) { if (dataTable.Rows[i][0].ToString() == strOrgDefaultText) { indexOrgDefault = i; } CmbOrg.Items.Add(dataTable.Rows[i][0].ToString()); } lblGrupa.Visible = true; CmbOrg.Visible = true; CmbOrg.SelectedIndex = indexOrgDefault; break; } //novo 08.12.2020. zajedno CmbOrg.Items.Clear(); var query1 = "SELECT Naziv FROM OrganizacionaStruktura "; var databaseBroker = new DataBaseBroker(); var dataTable1 = databaseBroker.ReturnDataTable(query1); for (int i = 0; i < dataTable1.Rows.Count; i++) { if (dataTable1.Rows[i][0].ToString() == strOrgDefaultText) { indexOrgDefault = i; } if (dataTable1.Rows[i][0].ToString() != "") { CmbOrg.Items.Add(dataTable1.Rows[i][0].ToString()); } } Console.WriteLine(cmbBaze.Text); Console.WriteLine(CmbOrg.Text); DataSet IdOrg = DB.ReturnDS( " select o.*,o.ID_Zemlja,os.NazivJavni as Firma ,os.NazivStampaca, os.PutanjaStampaca,os.Pib from OrganizacionaStruktura as o WITH (NOLOCK) ,organizacionastrukturastablo os WITH (NOLOCK) where o.Naziv='" + CmbOrg.Text + "' And o.ID_OrganizacionaStrukturaStablo=os.ID_OrganizacionaStrukturaStablo ;"); DataView dv = IdOrg.Tables[0].DefaultView; var zemlja = dv[0]["ID_Zemlja"]; string str = "select v.ID_Sifrarnikvaluta,OznVal,ID_Zemlja from sifrarnikvaluta as v WITH (NOLOCK) ,Zemlja as z WITH (NOLOCK) where z.ID_Zemlja=" + Convert.ToString(dv[0]["ID_Zemlja"]); str += " AND v.SifraZemlje=z.SifraZemlje"; DataTable RsValuta = DB.ReturnDataTable(str); dv.Dispose(); dv = RsValuta.DefaultView; if (RsValuta.Rows.Count == 0) { Program.DomacaValuta = "RSD"; Program.ID_DomacaValuta = 1; Program.ID_MojaZemlja = 4; } else { Program.DomacaValuta = Convert.ToString(dv[0]["OznVal"]); Program.ID_DomacaValuta = Convert.ToInt32(dv[0]["ID_SifrarnikValuta"]); Program.ID_MojaZemlja = Convert.ToInt32(dv[0]["ID_Zemlja"]); } //ivana 8.10.2021. izmenila sam ceo ovaj deo //var upit = "SELECT ID_Radnik FROM KadrovskaEvidencija WHERE Suser = @param0"; var upit = "SELECT ID_KadrovskaEvidencija FROM KadrovskaEvidencija WHERE Suser = @param0"; var prDok = DB.ParamsQueryDT(upit, UsernameTextBox.Text); //if (prDok.Rows.Count != 0 && prDok.Rows[0]["ID_Radnik"] != System.DBNull.Value) if (prDok.Rows.Count != 0 && prDok.Rows[0]["ID_KadrovskaEvidencija"] != System.DBNull.Value) { //int ID_Radnik = Convert.ToInt32(prDok.Rows[0]["ID_Radnik"]); int Id_ke = Convert.ToInt32(prDok.Rows[0]["ID_KadrovskaEvidencija"]); //upit = "SELECT ID_Firma,mbr FROM Radnik where ID = @param0"; upit = "SELECT ID_Firma,mbr FROM Radnik where ID_KadrovskaEvidencija = @param0"; //prDok = DB.ParamsQueryDT(upit, ID_Radnik); prDok = DB.ParamsQueryDT(upit, Id_ke); if (prDok.Rows.Count != 0) { int ID_Firma = Convert.ToInt32(prDok.Rows[0]["ID_Firma"]); int mbr = Convert.ToInt32(prDok.Rows[0]["mbr"]); //tamara 22.4.2021. if (File.Exists(SlikePutanja + ID_Firma + "-" + mbr + ".jpg")) { pictureBox1.Image = Image.FromFile(SlikePutanja + ID_Firma + "-" + mbr + ".jpg"); pictureBox1.Visible = true; } else { //pictureBox1.Visible = false; pictureBox1.Image = Image.FromFile(SlikePutanja + "default.jpg"); } pictureBox1.Refresh(); } else { pictureBox1.Image = Image.FromFile(SlikePutanja + "default.jpg"); } } else { pictureBox1.Image = Image.FromFile(SlikePutanja + "default.jpg"); } } }
private void username_Leave(object sender, EventArgs e) { // Obrada(""); aliasDatabase = new Dictionary <string, string>(); baza.Clear(); grupa.Clear(); grupa.Visible = false; grupalabel.Visible = false; baza.Visible = false; bazalabel.Visible = false; if (username.Text != "") { //var fileReader = File.ReadAllText(Application.StartupPath + @"\XmlLat\xxxx.ini"); var fileReader = File.ReadAllText(@"\\BANKOMW\Repozitorijum\ISBankom\XXXX\xxxx.ini"); string[] separators11 = new[] { "[", "]" }; int n = 0; string struser = username.Text.ToLower(); string strobrada = ""; string[] words = fileReader.Split(separators11, StringSplitOptions.RemoveEmptyEntries); for (n = 0; n < words.Length; n++) { string cc = words[n].ToLower(); if (strobrada != "") { strobrada = words[n]; break; } if (cc == struser) { strobrada = words[n]; } } // char[] separators = { '#','=' }; char[] separators = { '#' }; strobrada = strobrada.Replace("\r\n", "#").Replace("\r", "").Replace("\n", ""); var result = strobrada.Split(separators, StringSplitOptions.None); int k = -1; for (n = 0; n < result.Length; n++) { if (result[n] != "") { if (result[n] == "IzborBaze=1") { strIzborBaze = result[n]; } if (result[n] == "IzborOrganizacionogDela=1") { strIzborOrganizacionogDela = result[n]; } if (result[n].Length > 4 && result[n].Substring(0, 4) == "Baza") { k++; if (result[n].Substring(0, 5) == "Baza1") { indexCurrentbaza = k; strCurrentbaza = result[n].Substring(result[n].IndexOf("=") + 1); } aliasDatabase.Add(result[n].Substring(result[n].IndexOf("-") + 1), result[n].Substring(result[n].IndexOf("=") + 1, result[n].IndexOf("-") - result[n].IndexOf("=") - 1)); baza.AddItem(result[n].Substring(result[n].IndexOf("-") + 1)); } if ((result[n].Length > 15 && result[n].Substring(0, 16) == "OrganizacioniDeo")) { strOrgDefaultText = result[n].Substring(result[n].IndexOf("=") + 1); //grupa.AddItem(result[n].Substring(result[n].IndexOf("=") + 1)); } } } switch (strIzborBaze) { case "IzborBaze=0": baza.selectedIndex = k > -1 ?indexCurrentbaza:-1; break; case "IzborBaze=1": bazalabel.Visible = true; baza.Visible = true; baza.selectedIndex = indexCurrentbaza; break; } switch (strIzborOrganizacionogDela) { case "IzborOrganizacionogDela=0": grupa.AddItem(strOrgDefaultText); grupa.selectedIndex = 0; break; case "IzborOrganizacionogDela=1": var query = "SELECT Naziv FROM OrganizacionaStruktura "; var dataTable = DB.ReturnDataTable(query); for (int i = 0; i < dataTable.Rows.Count; i++) { if (dataTable.Rows[i][0].ToString() == strOrgDefaultText) { indexOrgDefault = i; } grupa.AddItem(dataTable.Rows[i][0].ToString()); } grupalabel.Visible = true; grupa.Visible = true; grupa.selectedIndex = indexOrgDefault; break; } Console.WriteLine(baza.Text); Console.WriteLine(grupa.Text); DataSet IdOrg = DB.ReturnDS( " select o.*,os.NazivJavni as Firma ,os.NazivStampaca, os.PutanjaStampaca,os.Pib from OrganizacionaStruktura as o WITH (NOLOCK) ,organizacionastrukturastablo os WITH (NOLOCK) where o.Naziv='" + grupa.Text + "' And o.ID_OrganizacionaStrukturaStablo=os.ID_OrganizacionaStrukturaStablo ;"); DataView dv = IdOrg.Tables[0].DefaultView; string str = "select v.ID_Sifrarnikvaluta,OznVal,ID_Zemlja from sifrarnikvaluta as v WITH (NOLOCK) ,Zemlja as z WITH (NOLOCK) "; str += " where z.ID_Zemlja=" + Convert.ToString(dv[0]["ID_Zemlja"]); str += " AND v.SifraZemlje=z.SifraZemlje"; DataTable RsValuta = DB.ReturnDataTable(str); dv.Dispose(); dv = RsValuta.DefaultView; if (RsValuta.Rows.Count == 0) { Program.DomacaValuta = "RSD"; Program.ID_DomacaValuta = 1; Program.ID_MojaZemlja = 4; } else { Program.DomacaValuta = Convert.ToString(dv[0]["OznVal"]); Program.ID_DomacaValuta = Convert.ToInt32(dv[0]["ID_SifrarnikValuta"]); Program.ID_MojaZemlja = Convert.ToInt32(dv[0]["ID_Zemlja"]); } var upit = "SELECT ID_Radnik FROM KadrovskaEvidencija WHERE Suser = @param0"; var prDok = DB.ParamsQueryDT(upit, username.Text); int ID_Radnik; if (prDok.Rows.Count != 0 && prDok.Rows[0]["ID_Radnik"] != System.DBNull.Value) { ID_Radnik = Convert.ToInt32(prDok.Rows[0]["ID_Radnik"]); upit = "SELECT ID_Firma,mbr FROM Radnik where ID = @param0"; prDok = DB.ParamsQueryDT(upit, ID_Radnik); if (prDok.Rows.Count != 0) { int ID_Firma = Convert.ToInt32(prDok.Rows[0]["ID_Firma"]); int mbr = Convert.ToInt32(prDok.Rows[0]["mbr"]); if (File.Exists(@"\\BANKOMW\organizacija\Pictures\" + ID_Firma + "-" + mbr + ".jpg")) { pictureBox2.Image = Image.FromFile(@"\\BANKOMW\organizacija\Pictures\" + ID_Firma + "-" + mbr + ".jpg"); } pictureBox2.Refresh(); } } else { pictureBox2.Image = global::Bankom.Properties.Resources.login; pictureBox2.Refresh(); } } }