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