private void PuniDgrid()
{
string pom = textBox1.Text;
string query = "Select CeloIme, Firma, Posao, E_mail,Napomene, Pejdzer, Adresa, Mesto, Drzava from [Imenik] where [CeloIme] like @param0 or [Firma] like @param0 or [Posao] like @param0 or [E_mail] like @param0 or [Napomene] like @param0 or [Pejdzer] like @param0 or [Drzava] like @param0 or [Mesto] like @param0 or [Adresa] like @param0 ";
dt = db.ParamsQueryDT(query, "%" + pom + "%");
dataGridView1.DataSource = dt;
dataGridView1.Columns["Pejdzer"].HeaderText = "Napomena2";
dataGridView1.Columns["Napomene"].HeaderText = "Napomena1";
dataGridView1.Columns["CeloIme"].HeaderText = "Ime i prezime";
dataGridView1.Columns["CeloIme"].Width = 200;
dataGridView1.Columns["Posao"].HeaderText = "Brojevi telefona";
dataGridView1.Columns["E_mail"].HeaderText = "E-mail";
dataGridView1.Columns["E_mail"].Width = 130;
dataGridView1.Columns["Drzava"].HeaderText = "Dr`ava";
int rc = dataGridView1.Rows.Count;
for (int i = 0; i < rc; i++)
{
var cell = dataGridView1.Rows[i].Cells[3];
cell.Style.Font = new Font("Times New Roman", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
}
}
private void frmSlika_Load(object sender, EventArgs e)
{
cmbNazivSlike.AllowDrop = false;
string path = @"\\" + LoginForm.FileServer + @"\ISDokumenta\" + Program.imeFirme + "\\Pdf\\";
System.IO.DirectoryInfo di = new DirectoryInfo(path);
//foreach (FileInfo file in di.GetFiles("*.pdf"))
//{
// string naziv = file.Name.ToString();
// cmbNazivPdf.Items.Add(naziv);
//}
DataTable dt = new DataTable();
//ivana 15.10.2021. pretvorila u parametarski upit
//ivana 4.11.2021. dodala sam uslov s.Original = 'True' za sva dokumenta koja imaju Originale
string sselect = "select distinct NazivJavni from DokumentaStablo as d join SifarnikDokumenta as s on d.Naziv=s.Naziv where s.Original = 'True' or s.NacinRegistracije='P' and ccopy= 0 and VrstaCvora='d' and d.Naziv in "
+ "(select g.naziv from Grupa as g,KadroviIOrganizacionaStrukturaStavkeView as ko Where (KO.ID_OrganizacionaStruktura = G.ID_OrganizacionaStruktura Or KO.id_kadrovskaevidencija = G.id_kadrovskaevidencija) "
+ " And KO.ID_OrganizacionaStrukturaStablo = @param0 and ko.id_kadrovskaevidencija = @param1)";
dt = db.ParamsQueryDT(sselect, Program.idFirme, Program.idkadar);
for (int i = 0; i < dt.Rows.Count; i++)
{
cmbVrsta.Items.Add(dt.Rows[i][0].ToString());
}
}
private void frmPrint_Load(object sender, EventArgs e)
{
this.FormBorderStyle = FormBorderStyle.None;
statusPrint.Visible = false;
string[] separators = new[] { "," };
string putanja = "";
string mid = intCurrentdok.ToString();
ParamZaStampu = "";
string baza = "";
panelPrint.Width = Width - 136;
panelPrint.Height = Height - 30;
if (izvor == "kocka")
{
baza = "";
}
else
{
baza = Program.NazivBaze;
}
if (kojiprint == "rpt")
{
if (kojinacin == "")
{
if (string.IsNullOrEmpty(Program.param))
{
}
else
{
string[] mparam = Program.param.Split(separators, StringSplitOptions.None);
string[] mvred = Program.vred.Split(separators, StringSplitOptions.None);
for (int i = 0; i < mparam.Length; i++)
{
ParamZaStampu += "&" + mparam[i] + "=" + mvred[i];
}
}
}
}
else
{
ParamZaStampu += "&id=" + mid;
}
// steva ; izvuci iz connection stringa username i pass
string[] niz = Program.connectionString.Split(';');
string DatabaseUsername = niz[2].Split('=')[1];
string DatabasePassword = niz[3].Split('=')[1];
//tamara
switch (kojiprint)
{
//Djora 01.06.21
case "xml":
putanja = @"c:\TempXml\" + imefajla + ".xml";
break;
case "prn":
//Djora 24.06.21
//steva 9.9.2021. dodao + "&rc:Stylesheet=Djora"
//steva 14.9.2021. izmenio "&rc:Zoom=150%"
putanja = "http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2fprn" + imefajla + "&rs:Command=Render" + "&database=" + Program.NazivBaze + "&server=" + LoginForm.ImeServera + "&username="******"&password="******"&Firma=" + Program.imeFirme + "&slike=" + LoginForm.ReportSlike + ParamZaStampu + "&lang=" + LoginForm.OznakaLangReport + "&rc:Zoom=Whole Page" + "&rc:Stylesheet=Djora";
//putanja = "http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2fprn" + imefajla + "&rs:Command=Render" + "&rc:Stylesheet=Djora&database=" + Program.NazivBaze + "&server=" + LoginForm.ImeServera + "&username="******"&password="******"&Firma=" + Program.imeFirme + "&slike=" + LoginForm.ReportSlike + ParamZaStampu + "&lang=" + LoginForm.OznakaLangReport;
putanja = putanja.Replace("#", "%23").Replace("+", "%2b"); //prilagodi specijalne karaktere kod passworda (znak + i # prave probleme)
//Ivana 13.1.2021.
string upit = "select Email from Komitenti where Email<>''";
rez = db.ParamsQueryDT(upit);
for (int i = 0; i < rez.Rows.Count; i++)
{
cmbEmail.Items.Add(rez.Rows[i][0].ToString());
}
break;
case "rpt":
//Djora 02.06.21
Control[] controls = this.MdiParent.Controls.Find("toolbar", true);
foreach (Control ctrl in controls)
{
if (ctrl.Name == "ToolBar")
{
ToolStrip strip = ctrl as ToolStrip;
strip.Items["Email"].Enabled = true;
}
}
//Program.Parent.ToolBar.Items["Email"].Enabled = true;
//putanja = "http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2frpt" + imefajla + "&rs:Command=Render" + "&database=" + Program.NazivBaze + "&server=" + LoginForm.ImeServera + "&username="******"&password="******"&slike=" + LoginForm.ReportSlike + ParamZaStampu;
//putanja = putanja.Replace("#", "%23").Replace("+", "%2b");//prilagodi specijalne karaktere kod passworda (znak + i # prave probleme)
putanja = "http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2frpt" + imefajla + "&rs:Command=Render" + "&rc:Stylesheet=Djora&database=dbbbTestNew2003Bankom&server=sql2019&username="******"&password=#Wa61+hK@34&slike=" + LoginForm.ReportSlike + ParamZaStampu + "&rc:Zoom=100";
putanja = putanja.Replace("#", "%23").Replace("+", "%2b"); //prilagodi specijalne karaktere kod passworda (znak + i # prave probleme)
break;
case "lot":
//steva 9.9.2021. dodao + "&rc:Stylesheet=Djora"
putanja = @"http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2fprnLot" + "&rs:Command=Render" + "&id_lot=" + intCurrentdok + "&lang=" + LoginForm.OznakaLangReport + "&rc:Zoom=100" + "&rc:Stylesheet=Djora";
break;
case "sif":
//steva 9.9.2021. dodao + "&rc:Stylesheet=Djora"
//ivana 17.9.2021.
string pom;
if (imeSifarnika == "")
{
pom = "";
}
else
{
pom = "&Grupa=" + imeSifarnika;
}
//steva 17.9.2021. dodao + "&Grupa=" + imeSifarnika
putanja = "http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2fsif" + imefajla + "&rs:Command=Render" +
"&database=" + Program.NazivBaze + "&server=" + LoginForm.ImeServera + "&username="******"&password="******"&lang=" + LoginForm.OznakaLangReport + "&rc:Zoom=100" + "&rc:Stylesheet=Djora" + pom;
putanja = putanja.Replace("#", "%23").Replace("+", "%2b"); //prilagodi specijalne karaktere kod passworda (znak + i # prave probleme)
break;
case "pre":
case "nag":
case "pla":
case "ako":
statusPrint.Visible = true;
LayoutMdi(MdiLayout.TileVertical);
webBrowser1.Dock = DockStyle.Fill;
webBrowser1.Top = Top - 25;
webBrowser1.Width = MdiParent.Width;
webBrowser1.Height = MdiParent.Height;
putanja = @"c:\TempXml\prevoz.xml";
if (kojiprint == "nag")
{
putanja = @"c:\TempXml\nagrade.xml";
}
if (kojiprint == "pla")
{
putanja = @"c:\TempXml\plate.xml";
}
if (kojiprint == "ako")
{
putanja = @"c:\TempXml\akontacije.xml";
}
if (kojiprint == "pre")
{
putanja = @"c:\TempXml\prevoz.xml";
}
break;
default:
putanja = "http://" + LoginForm.ImeServera + "/ReportServer/Pages/ReportViewer.aspx?/Izvestaji/prn" + imefajla + "&rs:Command=Render&id=" + Convert.ToString(intCurrentdok) + "&rc:Zoom=100";
break;
}
Program.putanjaEmail = putanja;
webBrowser1.Navigate(putanja);
}
//Djora 19.05.21
public void KreirajPDF(string imefajla, string kojiprint, string ParamZaStampu)
{
string adresaFrom = "";
string lozinka = "";
// Pretvara pravi password u skremblovani. Ove dve linije mi treba samo u debug modu radi testa
//clsPasswords pom = new clsPasswords();
//lozinka = pom.EncodePasswordToBase64("62+Wt9#H*v");
//Djora 07.09.21 pocetak -----------------------------------
DataBaseBroker db = new DataBaseBroker();
DataTable dt = new DataTable();
string sql = " SELECT DISTINCT dbo.Radnik.E_mail, dbo.Radnik.EmailPass FROM dbo.Radnik INNER JOIN "
+ " dbo.KadrovskaEvidencija ON dbo.Radnik.id_kadrovskaevidencija = dbo.KadrovskaEvidencija.ID_KadrovskaEvidencija "
+ " WHERE(dbo.Radnik.id_kadrovskaevidencija <> 1) AND (dbo.KadrovskaEvidencija.ID_KadrovskaEvidencija = @param0)";
dt = db.ParamsQueryDT(sql, Program.idkadar);
if (dt.Rows.Count != 0)
{
foreach (DataRow row in dt.Rows)
{
adresaFrom = row["E_mail"].ToString().Trim();
//lozinka = row["EmailPass"].ToString().Trim();
clsPasswords ps = new clsPasswords();
lozinka = ps.DecodeFrom64(row["EmailPass"].ToString().Trim());
}
}
else
{
MessageBox.Show("Mail nije poslat. Trazite od IT sluzbe da vam otvori mail !", "UPOZORENJE", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//Djora 07.09.21 kraj ---------------------------------------
//Izvlaci iz connestionstring-a user name i password
string[] niz0 = Program.connectionString.Split(';');
string DatabaseUsername = niz0[2].Split('=')[1];
string DatabasePassword = niz0[3].Split('=')[1];
//Djora 22.10.21 30.08.21 Inicijacija Vrednosti //Djora 07.09.21
//string[,] niz = { { "Ko salje", "*****@*****.**", "t", "" }, { "Password", "@R01d1969S", "t", "" }, { "Kome se salje", "*****@*****.**", "t", "" }, { "Tema", "Ovo je Subject", "t", "" }, { "Poruka", "Ovo je Body", "t", "" } };
string[,] niz = { { "Ko šalje", adresaFrom, "t", "" }, { "Password", lozinka, "t", "" }, { "Kome se šalje", "", "t", "" }, { "Naslov", "", "t", "" }, { "Poruka", "", "t", "" } };
//Djora 22.10.21 Prikaz forme za unos mag.polja, lota i kolicine sa njihovim inicijalnim vrednostima
string[,] niz2 = { };
//ivana 19.10.2021.
//niz2 = Dijalog.Prikazi(niz);
niz2 = Dijalog.Prikazi(niz, "Mail");
//Djora 30.08.21
if (niz2.Length == 0)
{
return;
}
//string URL = "";
//string RS = "http://sql2019/ReportServer/Pages/ReportViewer.aspx?%2fPlate%2fPlatnaKartica";
//string Command = "Render";
//string Format = "PDF";
////Parametri koji se predaju
//string mbr = "1"; //Inicijalno
//string mes = "0320k"; //Zadaje se
//string idfirma = "5"; //Zadaje se
//string server = "server"; //Zadaje se
//string database = "BankomVeza"; //Zadaje se
//string username = "******"; //Zadaje se
//string password = "******"; //Zadaje se
//string URL = " ";
////URL = "http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2f" + kojiprint + imefajla + "&rs:Command=Render&rs:Format=PDF" + "&database=" + Program.NazivBaze + "&Firma=" + Program.imeFirme + "&slike=" + LoginForm.ReportSlike; //+ "&rs:ParameterLanguage=" + culture.ToString() + ParamZaStampu;
//URL = RS + "&rs:Command=" + Command + "&rs:Format=" + Format + "&mbr=" + mbr + "&mes=" + mes + "&idfirma=" + idfirma + "&server=" + server + "&database=" + database + "&username="******"&password="******"http://sql2019/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2fprnKonacniUlazniRacun&rs:Command=Render&rs:Format=PDF&database="BankomTest&server=server&username=sa&password=password&Firma=Bankom&slike=\\sql2016\\D\\logo\\&id=1564246";
//Djora 03.06.21
//string URL = @"http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2f" + kojiprint + imefajla + "&rs:Command=Render&rs:Format=PDF&database=" + Program.NazivBaze + "&server=server&username=sa&password=password&Firma=" + Program.imeFirme + "&slike=\\sql2016\\D\\logo\\" + ParamZaStampu;
//Djora 30.08.21
//string URL = @"http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2f" + kojiprint + imefajla + "&rs:Command=Render&rs:Format=PDF&database=BankomTest&server=server&username=sa&password=password&Firma=" + Program.imeFirme + "&slike=\\sql2016\\D\\logo\\" + ParamZaStampu;
string URL = @"http://" + LoginForm.ReportServer + "/ReportServer/Pages/ReportViewer.aspx?%2fIzvestaji%2f" + kojiprint + imefajla + "&rs:Command=Render&rs:Format=PDF&database=" + Program.NazivBaze + "&server=" + LoginForm.ImeServera + "&username="******"&password="******"&Firma=" + Program.imeFirme + "&slike=" + LoginForm.ReportSlike + ParamZaStampu;
URL = URL.Replace("#", "%23").Replace("+", "%2b");//prilagodi specijalne karaktere kod passworda (znak + i # prave probleme)
System.Diagnostics.Debug.WriteLine(ParamZaStampu);
System.Net.HttpWebRequest Req = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(URL);
Req.Credentials = System.Net.CredentialCache.DefaultCredentials;
Req.Method = "GET";
//Folder gde je aplikacija pokrenuta
string directory = AppDomain.CurrentDomain.BaseDirectory;
//Djora 18.10.21 poc --------------------------
string mailDir = directory + "mail";
if (!Directory.Exists(mailDir))
{
System.IO.Directory.CreateDirectory(mailDir);
}
else
{
System.IO.DirectoryInfo di = new DirectoryInfo(mailDir);
foreach (FileInfo file in di.GetFiles())
{
file.Delete();
}
}
//Djora 18.10.21 kraj --------------------------
//Putanja gde ce biti snimljen fajl.
//Djora 18.10.21
//string path = directory + @"mail\" + imefajla + ".pdf"; //@"D:\xxxx.pdf";
string path = mailDir + @"\" + imefajla + ".pdf"; //@"D:\xxxx.pdf";
System.Net.WebResponse objResponse = Req.GetResponse();
System.IO.FileStream fs = new System.IO.FileStream(path, System.IO.FileMode.Create);
System.IO.Stream stream = objResponse.GetResponseStream();
byte[] buf = new byte[1024];
int len = stream.Read(buf, 0, 1024);
while (len > 0)
{
fs.Write(buf, 0, len);
len = stream.Read(buf, 0, 1024);
}
stream.Close();
fs.Close();
//Djora 30.08.21
clsMail pismo = new clsMail();
//pismo.KonekcijaNaSmtp("*****@*****.**", "@R01d1969S", "*****@*****.**","Dokument", "Ovo je proba", path, "mail.bankom.rs");
pismo.KonekcijaNaSmtp(niz2[0, 1], niz2[1, 1], niz2[2, 1], niz2[3, 1], niz2[4, 1], path, "mail.bankom.rs");
//---------------------------------------------------------------------------------------------------
//Djora 30.08.21
//////newFileName = directory + @"mail\mail_lista.csv";
//////File.WriteAllText(newFileName, String.Empty);
//////createCSV(niz[1, 1], "Hello C#", "Ovo je napisano u C#", directory +@"mail\", "xxxx.pdf");
////////createCSV("*****@*****.**", "Hello C#", "Ovo je napisano u C#", "proba.txt");
//////string putanja = directory + @"mail\start.bat";
////////Process.Start(putanja);
//////Process.Start(@".\mail\start.bat");
//////MessageBox.Show("Gotovo !");
//////// //Slanje maila
//////// //posaljiMail("@R01d1969S", "*****@*****.**", "Plata " + mes, "Plata za mesec mart", path, "Luka Djoric <*****@*****.**>", row["Ime"].ToString(), row["E_Mail"].ToString());
}
// 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 OK_Click(object sender, EventArgs e)
{
if (CmbOrg.Text.Trim() == "")
{
MessageBox.Show("Morate odabrati grupu.");
}
else
{
//tamara 21.10.2020.
Program.ID_Jezik = VratiJezik();
//Djora 26.09.20
int standardHeight = 1080; // 600; //900
int standardWidth = 1920; // 800; //1440
int presentHeight = Screen.PrimaryScreen.Bounds.Height; //.Bounds.Height;
int presentWidth = Screen.PrimaryScreen.Bounds.Width;
float heightRatio = (float)((float)presentHeight / (float)standardHeight);
float widthRatio = (float)((float)presentWidth / (float)standardWidth);
//Djora 28.10.21 dodato jer se kod Bojane i ako ima iste parametre za ekran kao ja, 1920x1080 i kod menbe je dobro, a kod nje nije
//moj ekran je ima velicinu 226, a njena 223
//heightRatio = heightRatio + (float)0.1;
float skalFaktor = getScalingFactor();
heightRatio = heightRatio * skalFaktor;
widthRatio = widthRatio * skalFaktor;
Program.RacioWith = (float)widthRatio;
//Djora 17.11.21
if ((presentHeight == 768 && presentWidth == 1366) || (presentHeight == 768 && presentWidth == 1360))
{
Program.RacioHeight = (float)0.80;
}
else
{
Program.RacioHeight = (float)heightRatio;
}
string ImeKorisnika = "";
string PassKorisnika = "";
string n = UsernameTextBox.Text;
lblBaza.Text = "";
lblGrupa.Text = "";
if (n.Length == 0)
{
MessageBox.Show("Polje korisničko ime je prazno.");
return;
}
n = PasswordTextBox.Text;
if (n.Length == 0)
{
MessageBox.Show("Polje za lozinku je prazno.");
return;
}
using (SqlConnection cnn = new SqlConnection(connectionString))
{
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
string str = " select suser,Pass,ID_KadrovskaEvidencija,SifRadnika from KadrovskaEvidencija WITH (NOLOCK) where SUSER = @username and id_kadrovskaevidencija <> 1 ";
var usernameParam = new SqlParameter("username", SqlDbType.NVarChar)
{
Value = UsernameTextBox.Text.Trim()
};
var cmd = new SqlCommand
{
CommandText = str,
Connection = cnn
};
cmd.Parameters.Add(usernameParam);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
ImeKorisnika = Convert.ToString(rdr[0]);
PassKorisnika = Convert.ToString(rdr[1]);
Program.idkadar = Convert.ToInt32(rdr[2]);
Program.SifRadnika = Convert.ToString(rdr[3]);
}
else
{
MessageBox.Show("Pogrešno korisničko ime.");
lblBaza.Visible = false;
cmbBaze.Visible = false;
lblGrupa.Visible = false;
CmbOrg.Visible = false;
rdr.Close();
cmd.Dispose();
cnn.Close();
return;
}
rdr.Close();
cmd.Dispose();
string strOrgDeo = "select o.ID_OrganizacionaStruktura,o.ID_OrganizacionaStrukturaStablo,os.Naziv ";
strOrgDeo += " from OrganizacionaStruktura as o WITH(NOLOCK) ,organizacionastrukturastablo os WITH(NOLOCK) ";
strOrgDeo += " where o.Naziv = '" + CmbOrg.Text + "' and o.ID_OrganizacionaStrukturaStablo=os.ID_OrganizacionaStrukturaStablo ;";
DataSet ds = new DataSet();
ds = DB.ReturnDS(strOrgDeo);
DataView dv = ds.Tables[0].DefaultView;
Program.imeFirme = dv[0]["Naziv"].ToString();
Program.idOrgDeo = Convert.ToInt32(dv[0]["ID_OrganizacionaStruktura"]);
Program.idFirme = Convert.ToInt32(dv[0]["ID_OrganizacionaStrukturaStablo"]);
Program.NazivOrg = CmbOrg.Text;
cnn.Close();
}
//ivana 26.10.2021. dodala sam ToLower()
if (UsernameTextBox.Text.ToLower() != ImeKorisnika.ToLower())
{
MessageBox.Show("Pogrešno korisničko ime.");
lblBaza.Visible = false;
cmbBaze.Visible = false;
lblGrupa.Visible = false;
CmbOrg.Visible = false;
UsernameTextBox.Text = "";
return;
}
bool result = PasswordTextBox.Text.Equals(PassKorisnika);
if (result == false)
{
MessageBox.Show("Pogrešna lozinka.");
PasswordTextBox.Text = "";
return;
}
Program.imekorisnika = ImeKorisnika;
Program.IntLogovanje = 1;
Hide();
Program.Parent.Text = Program.imeFirme + "-" + Program.imekorisnika;
Close();
int godina = DateTime.Now.Year;
string ssel = " Select DatumPocetkaObrade from ZakljucenjeKnjiga WITH(NOLOCK) "
+ " where GodinaZakljucenja=" + (godina - 1).ToString() + " and id_firma =1 ";
DataBaseBroker dk = new DataBaseBroker();
DataTable tk = new DataTable();
tk = dk.ReturnDataTable(ssel);
if (tk.Rows.Count > 0)
{
Program.kDatum = Convert.ToDateTime(tk.Rows[0]["DatumPocetkaObrade"]);
}
else
{
Program.kDatum = Convert.ToDateTime("01.01." + (godina - 1).ToString());
}
//Luka 14.07.21 Ako stoji min(Godina) onda iako nije nasao id_kadrovskaEvidencija sa flegom = 1 ipak muje rows.count =1 umesto nula
//ssel = " SELECT min(Godina) as god FROM Godine where flag=1 AND ID_KadrovskaEvidencija=@param0";
ssel = " SELECT Godina as god FROM Godine where flag=1 AND ID_KadrovskaEvidencija=@param0";
tk = dk.ParamsQueryDT(ssel, Program.idkadar);
if (tk.Rows.Count == 0)
{
Program.mGodina = 0;
//Djora 17.07.21
Program.mGodina2 = "";
}
else
{
Program.mGodina = Convert.ToInt32(tk.Rows[0]["god"].ToString());
//Djora 14.07.21
clsRazneFunkcije rf = new clsRazneFunkcije();
Program.mGodina2 = rf.fGodine();
}
//Djora 24.08.21 pocetak ---------------------------------------------------------
var MyIni = new clsIniFile(@"\\192.168.1.4\Repozitorijum\ISBankom\XXXX\xxxx.ini");
//Djora 04.11.21
string mm = MyIni.PopValue("LOGOVANJE", "PutanjaPrenosa");
Program.PutanjaPrenosa = mm;
//ivana 13.12.2021.
mm = MyIni.PopValue("LOGOVANJE", "PutanjaKomitenti");
Program.PutanjaKomitenti = mm;
mm = MyIni.PopValue("LOGOVANJE", "LogError");
Program.LogError = mm;
mm = MyIni.PopValue("LOGOVANJE", "IOSI=");
Program.IOSI = mm;
//Uzima po defoltu
mm = MyIni.PopValue("LOGOVANJE", "FontVelicina");
Program.FontVelicina = Int16.Parse(mm);
mm = MyIni.PopValue("LOGOVANJE", "FontStil");
Program.FontStil = mm;
mm = MyIni.PopValue("LOGOVANJE", "FontColor");
Program.FontColor = mm;
mm = MyIni.PopValue("LOGOVANJE", "BackgroundColor");
Program.BackgroundColor = mm;
mm = MyIni.PopValue("LOGOVANJE", "OddTableRowColor");
Program.OddTableRowColor = mm;
mm = MyIni.PopValue("LOGOVANJE", "EvenTableRowColor");
Program.EvenTableRowColor = mm;
mm = MyIni.PopValue("LOGOVANJE", "ControlBackColor");
Program.ControlBackColor = mm;
mm = MyIni.PopValue("LOGOVANJE", "GridColor");
Program.GridColor = mm;
mm = MyIni.PopValue("LOGOVANJE", "TableBackColor");
Program.TableBackColor = mm;
mm = MyIni.PopValue("LOGOVANJE", "TableHeaderColor");
Program.TableHeaderColor = mm;
//Djora 02.12.21
mm = MyIni.PopValue("LOGOVANJE", "RequiredColor");
Program.RequiredColor = mm;
//Uzima za korisnika ako ima
mm = MyIni.PopValue(Program.imekorisnika, "FontVelicina");
if (mm != "")
{
Program.FontVelicina = Int16.Parse(mm);
}
mm = MyIni.PopValue(Program.imekorisnika, "FontStil");
if (mm != "")
{
Program.FontStil = mm;
}
mm = MyIni.PopValue(Program.imekorisnika, "FontColor");
if (mm != "")
{
Program.FontColor = mm;
}
mm = MyIni.PopValue(Program.imekorisnika, "BackgroundColor");
if (mm != "")
{
Program.BackgroundColor = mm;
}
mm = MyIni.PopValue(Program.imekorisnika, "OddTableRowColor");
if (mm != "")
{
Program.OddTableRowColor = mm;
}
mm = MyIni.PopValue(Program.imekorisnika, "EvenTableRowColor");
if (mm != "")
{
Program.EvenTableRowColor = mm;
}
mm = MyIni.PopValue(Program.imekorisnika, "ControlBackColor");
if (mm != "")
{
Program.ControlBackColor = mm;
}
mm = MyIni.PopValue(Program.imekorisnika, "GridColor");
if (mm != "")
{
Program.GridColor = mm;
}
mm = MyIni.PopValue(Program.imekorisnika, "TableBackColor");
if (mm != "")
{
Program.TableBackColor = mm;
}
mm = MyIni.PopValue(Program.imekorisnika, "TableHeaderColor");
if (mm != "")
{
Program.TableHeaderColor = mm;
}
//Djora 24.08.21 kraj ------------------------------------------------------------
//Djora 02.12.21
mm = MyIni.PopValue(Program.imekorisnika, "RequiredColor");
if (mm != "")
{
Program.RequiredColor = mm;
}
}
}
private void CmbBaze_SelectedIndexChanged(object sender, EventArgs e)
{
string strimebaze = "";
SqlConnection cnn = new SqlConnection(connectionString);
cnn = Program.GetConnection();
if (cnn == null)
{
MessageBox.Show("Greska u konekciji! =>" + connectionString);
Application.Exit();
System.Environment.Exit(1);
}
Console.WriteLine(aliasDatabase[cmbBaze.SelectedItem.ToString()]);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT name FROM master.dbo.sysdatabases";
cmd.Connection = cnn;
DataSet dss = new DataSet();
DataView dv = new DataView();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(dss);
dv = dss.Tables[0].DefaultView;
for (int x = 0; x < dv.Count; x++)
{
Console.WriteLine(Convert.ToString(dv[x][0]));
if (aliasDatabase[cmbBaze.SelectedItem.ToString()].Trim() == Convert.ToString(dv[x][0]))
{
strimebaze = Convert.ToString(dv[x][0]);
Program.NazivBaze = strimebaze;
break;
}
}
if (strimebaze == "")
{
MessageBox.Show("Ne postoji izabrana baza", "info");
lista.Clear();
CmbOrg.Items.Clear();
}
else
{
changeDatabase(cmbBaze.SelectedItem.ToString());
lista.Clear();
CmbOrg.Items.Clear();
CmbOrg.Text = "";
//ivana 8.10.2021.
//var query = "SELECT Naziv FROM OrganizacionaStruktura ";
var query = "SELECT Naziv FROM OrganizacionaStruktura inner join KadroviIOrganizacionaStruktura on OrganizacionaStruktura.ID_OrganizacionaStruktura = " +
"KadroviIOrganizacionaStruktura.ID_OrganizacionaStruktura inner join KadrovskaEvidencija on KadrovskaEvidencija.ID_KadrovskaEvidencija = " +
"KadroviIOrganizacionaStruktura.ID_KadrovskaEvidencija and KadrovskaEvidencija.Suser = @param0";
var databaseBroker = new DataBaseBroker();
var dataTable = databaseBroker.ParamsQueryDT(query, UsernameTextBox.Text);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
if (dataTable.Rows[i][0].ToString() == strOrgDefaultText)
{
indexOrgDefault = i;
}
if (dataTable.Rows[i][0].ToString() != "")
{
lista.Add(dataTable.Rows[i][0].ToString());
}
}
}
}
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();
}
}
}
private void frmChield_Load(object sender, EventArgs e)
{
//steva 20.04.21 pritiskanje F1 dugmeta za help
this.KeyPreview = true;
this.KeyDown += new KeyEventHandler(pozivanjeHelpa);
//tamara 03.2021. Djora 10.05.21
//if (exe=="Excel.exe")
if (Program.Excel != "" && Program.Excel != null)
{
this.FormBorderStyle = FormBorderStyle.None;
//Djora 24.08.21
//this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(226)))), ((int)(((byte)(220)))));
this.BackColor = Color.FromArgb(Int32.Parse(Program.BackgroundColor)); //Color.Green;
this.AutoScroll = true;
//Djora 10.05.21
panel2.Dock = DockStyle.Fill;
//Djora 10.05.21
//panel2.Visible = true;
//panel2.BringToFront();
excelApp = new Microsoft.Office.Interop.Excel.Application();
//string putanja1 = "C:\\Users\\tamara.martinovic\\Desktop\\AnalitikaNabavkePoDobavljacima.xls";
object misValue = System.Reflection.Missing.Value;
//excelApp.Wait(8000);
string PutanjaDokumenta = "";
string sql = "select UlazniIzlazni as NazivKlona,NacinRegistracije,PutanjaZaCuvanje,prikaz,vrsta,OdakleSePreuzima from SifarnikDokumenta where Naziv=@param0";
System.Data.DataTable dt1 = db.ParamsQueryDT(sql, Program.Excel);
if (dt1.Rows.Count != 0)
{
PutanjaDokumenta = dt1.Rows[0]["PutanjaZaCuvanje"].ToString().Trim();
PutanjaDokumenta = PutanjaDokumenta.Replace("ImeServera", LoginForm.FileServer.ToUpper()).Replace("FFirma", Program.imeFirme);
}
//Djora 10.05.21
Thread thread = Thread.CurrentThread;
System.Diagnostics.Debug.WriteLine(thread.ManagedThreadId);
if (File.Exists(@PutanjaDokumenta + Program.Excel + ".xls"))
{
//Djora 20.07.21 treci parametar (read only) je stavljen na false, jer kad je true onda se ne vidi meni.
excelWorkBook = excelApp.Workbooks.Open(PutanjaDokumenta + Program.Excel + ".xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
// Jovana 25.10.21 vratila red iznad da bi bilo read only
//excelWorkBook = excelApp.Workbooks.Open(PutanjaDokumenta + Program.Excel + ".xls", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
excelApp.Visible = true;
excelWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)excelWorkBook.Sheets[1];
excelWorkSheet.SelectionChange += new Microsoft.Office.Interop.Excel.DocEvents_SelectionChangeEventHandler(excelWorkSheet_SelectionChange);
IntPtr excelHwnd = new IntPtr(excelApp.Application.Hwnd);
panel2.Height = this.Height - 70;
panel2.Width = this.Width;
//ivana 23.3.2021. Djora 01.06.21 Djora 20.07.21 Treba da ostane zagradjeno, nemojte vise da odgradjujete ili resite na drugi nacin
//excelApp.Width = panel2.Width;
//excelApp.Height = panel2.Height - 229;
//ivana 19.5.2021.
((BankomMDI)this.MdiParent).itemn_click(this.Name, e);
SetParent(excelHwnd, panel2.Handle);
this.Tag = excelHwnd;
panel2.Visible = true;
panel2.BringToFront();
}
else
{
MessageBox.Show("Ne postoji dati izveštaj!");
}
}
else
{
this.FormBorderStyle = FormBorderStyle.None;
//Djora 24.08.21
//this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(226)))), ((int)(((byte)(220)))));
this.BackColor = Color.FromArgb(Int32.Parse(Program.BackgroundColor)); //Color.Green;
this.AutoScroll = true;
////tamara 01.02.2021.
//this.Text = ".";
intStart = 0;
toolStripStatusPrazno.Text = new String(' ', 150);
toolStripStatusprdva.Text = new String(' ', 50);
clscontrolsOnForm cononf = new clscontrolsOnForm();
clsdokumentRefresh docref = new clsdokumentRefresh();
DataBaseBroker db = new DataBaseBroker();
liddok.Text = iddokumenta.ToString();
ldokje.Text = DokumentJe;
lidstablo.Text = idstablo.ToString();
limestabla.Text = imestabla;
limedok.Text = imedokumenta;
lBrDok.Text = brdok;
lDatum.Text = datum;
panel1.Visible = false;
switch (VrstaPrikaza)
{
case "TreeView":
clsTreeProcessing tw = new clsTreeProcessing();
tw.ObradaStabla(this, "1", imedokumenta, DokumentJe);
break;
default:
string supit = "";
switch (DokumentJe)
{
case "D":
if (imedokumenta == "KalkulacijaUlaza" || imedokumenta == "PDVKalkulacijaUlaza")
{
// punimo tabelu kalk za odabranu kalkulaciju da bismo imali podatke za zavisne troskove
string Odakle = "Load";
clsObradaKalkulacije okal = new clsObradaKalkulacije();
okal.RasporedTroskova(iddokumenta, " ", " ", " ", Odakle);
Odakle = "";
}
cononf.addFormControls(this, imedokumenta, iddokumenta.ToString(), OOperacija.Text);
docref.refreshDokumentBody(this, imedokumenta, iddokumenta.ToString(), DokumentJe);
docref.refreshDokumentGrid(this, imedokumenta, iddokumenta.ToString(), "", "", DokumentJe);
break;
case "P":
cononf.addFormControls(this, imedokumenta, iddokumenta.ToString(), OOperacija.Text);
clsObradaStablaPtipa procp = new clsObradaStablaPtipa();
supit = procp.Proces(imestabla, imedokumenta, idstablo);
docref.refreshDokumentGrid(this, imedokumenta, idstablo.ToString(), supit, "1", DokumentJe);
break;
case "I":
cononf.addFormControls(this, imedokumenta, iddokumenta.ToString(), OOperacija.Text); //cononf.addFormControls(this, imestabla, idstablo.ToString(), OOperacija.Text);
string sel = "Select TUD From Upiti Where NazivDokumenta='" + imedokumenta + "' and ime like'GGrr%' AND TUD>0 Order by TUD";
Console.WriteLine(sel);
System.Data.DataTable ti = db.ReturnDataTable(sel);
clsObradaStablaItipa proci = new clsObradaStablaItipa();
for (int j = 0; j < ti.Rows.Count; j++)
{
supit = proci.Proces(imedokumenta, ti.Rows[j]["TUD"].ToString());
Console.WriteLine(supit);
docref.refreshDokumentGrid(this, imedokumenta, idstablo.ToString(), supit, ti.Rows[j]["TUD"].ToString(), DokumentJe);
}
break;
case "S":
clsObradaStablaStipa procss = new clsObradaStablaStipa();
supit = procss.Proces(imestabla, imedokumenta, Convert.ToInt32(idstablo));
if (supit != "")
{
cononf.addFormControls(this, imestabla, idstablo.ToString(), OOperacija.Text);
docref.refreshDokumentGrid(this, imestabla, idstablo.ToString(), supit, "1", DokumentJe);
}
break;
}
break;
}
panel1.Top = 0;
if (this.Text == "LOT")
{
foreach (var pb in this.Controls.OfType <Field>())
{
//if (pb.cTip == 10 || pb.cTip == 8)
// pb.Enabled = false;
if (pb.cTip == 10)
{
if (pb.VrstaKontrole == "combo")
{
pb.comboBox.Enabled = false;
}
else
{
pb.textBox.Enabled = false;
}
}
if (pb.cTip == 8)
{
pb.dtp.Enabled = false;
}
}
}
}
}
