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