private string TransKLUDruguIUpisUBazu(string datum1, string datum2, string Ddok, int IdDok)
{
var lista = new List <string>();
string transKLUDruguIUpisUBazu = "";
DataTable RSImaNema = db.ReturnDataTable("select * from KursnaLista where Datum = '" + datum1 + "'");
if (RSImaNema.Rows.Count == 0)
{
transKLUDruguIUpisUBazu = "Nema kursne liste za taj datum u bazi";
}
else
{
RSImaNema.Dispose();
RSImaNema = db.ReturnDataTable("select * from KursnaLista where Datum = '" + datum2 + "'");
if (RSImaNema.Rows.Count > 0)
{
string str = "INSERT INTO KursnaLista(Datum, Paritet, Kupovni, Srednji,";
str += " Prodajni, Dogovorni, OBRADA, ID_SifrarnikValuta, Verzija, ";
str += " KupovniZaDevize, ProdajniZaDevize,OznVal, ID_Zemlja,ID_DokumentaView, ";
str += " UUser, TTime) SELECT '" + datum2 + "', Paritet, Kupovni, Srednji, Prodajni, ";
str += " Dogovorni, OBRADA, ID_SifrarnikValuta, Verzija, KupovniZaDevize,";
str += " ProdajniZaDevize,OznVal, ID_Zemlja," + IdDok.ToString();
str += " , UUser, TTime FROM KursnaLista WHERE Datum = '" + datum1 + "'";
lista.Add(str);
string rs = db.ExecuteSqlTransaction(lista);
lista.Clear();
if (rs != "")
{
transKLUDruguIUpisUBazu = rs; return(rs);
}
}
else
{
transKLUDruguIUpisUBazu = "Kursna Lista za taj datum vec postoji";
}
}
RSImaNema.Dispose();
return(transKLUDruguIUpisUBazu);
}
// 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;
}
}
}
// Jovana 29.11.21 - ne koristi se
//private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
//{
//}
//Djora 23.09.19
private void button1_Click(object sender, EventArgs e)
{
//Djora 02.12.19
string Datum = dateTimePicker1.Value.ToString("dd.MM.yy");
string NazivDokumenta = "KursnaLista";
string brojDok = "";
int rbr = 0;
DataBaseBroker db = new DataBaseBroker();
//Provera kursne liste
string sel = " SELECT Id_KursnaLista FROM KursnaLista WHERE datum='" + Datum + "'";
DataTable t = db.ReturnDataTable(sel);
if (t.Rows.Count > 0)
{
MessageBox.Show("Kursna lista vec postoji!");
goto Kraj;
}
int IdDokView;
string opis = string.Concat("Kursna lista ", Datum);
clsObradaOsnovnihSifarnika os = new clsObradaOsnovnihSifarnika();
IdDokView = os.UpisiDokument(ref brojDok, opis, 61, Datum.ToString());
// upisan dokument u dokumenta i izvrseni totali
SqlCommand cmd = new SqlCommand();
//Poziv Web servisa NBA i preuzimanje KursneListe u obliku XML-a
rs.nbs.webservicesListe.ExchangeRateXmlService proxy2 = new rs.nbs.webservicesListe.ExchangeRateXmlService();
rs.nbs.webservicesListe.AuthenticationHeader auth = new rs.nbs.webservicesListe.AuthenticationHeader();
auth.LicenceID = Guid.Parse("15b91077-22f7-4e4c-87cd-c4a3756bee6e");
auth.UserName = "******";
auth.Password = "******";
proxy2.AuthenticationHeaderValue = auth;
proxy2.Url = "https://webservices.nbs.rs/CommunicationOfficeService1_0/ExchangeRateXmlService.asmx";
//Kreiranje data seta na osnovu dobijenog xml-a
DataSet ds = new DataSet();
DataSet ds2 = new DataSet();
DataSet ds3 = new DataSet();
//Djora 19.05.20 primer: datumF = "20200515"
string datumF = dateTimePicker1.Value.Date.ToString("yyyyMMdd");
StringReader stringReaderSrednji = new StringReader(proxy2.GetExchangeRateByDate(datumF, 3)); //Srednji kurs
StringReader stringReaderKupProd = new StringReader(proxy2.GetExchangeRateByDate(datumF, 1)); //Kupovni i prodajni kurs
StringReader stringReaderEfektiva = new StringReader(proxy2.GetExchangeRateByDate(datumF, 2)); //za Efektivu
ds.ReadXml(stringReaderSrednji);
ds2.ReadXml(stringReaderKupProd);
ds3.ReadXml(stringReaderEfektiva);
stringReaderSrednji.Dispose();
stringReaderKupProd.Dispose();
stringReaderEfektiva.Dispose();
//Postavlja kolonu CurrencyCode kao primarni kljuc da bi kasnije, dole, mogo da koristim komandu Find
DataColumn[] keyColumns = new DataColumn[1];
keyColumns[0] = ds.Tables[0].Columns["CurrencyCode"];
ds.Tables[0].PrimaryKey = keyColumns;
ds.Tables[0].Columns.Add("KupovniZaDevize", typeof(String));
ds.Tables[0].Columns.Add("ProdajniZaDevize", typeof(String));
ds.Tables[0].Columns.Add("ID_SifrarnikValuta", typeof(String));
string Paritet;
string Kupovni;
string Prodajni;
string Srednji;
string SifVal;
string Verzija = "";
string KupovniZaDevize;
string ProdajniZaDevize;
string IDSifVal;
string OznVal;
string sql = "";
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection con;
con = new SqlConnection(Program.connectionString);
con.Open();
//Idi kroz r1 i nadji u r2 r1-KupProd r2-Srednji
foreach (DataRow r1 in ds2.Tables[0].Rows)
{
DataRow r2 = ds.Tables[0].Rows.Find(r1["CurrencyCode"]);
//Ako nisi nasao onda nista
if (r2 == null)
{
//ds2.Tables[0].Rows.Add(r1["XID"], r1["X"]);
}
else
{
r2["BuyingRate"] = r1["BuyingRate"];
r2["SellingRate"] = r1["SellingRate"];
}
}
//Idi kroz r1 i nadji u r2 r1-ZaEfektivu r2-Srednji
foreach (DataRow r1 in ds3.Tables[0].Rows)
{
DataRow r2 = ds.Tables[0].Rows.Find(r1["CurrencyCode"]);
//Ako nisi nasao onda nista
if (r2 == null)
{
//ds2.Tables[0].Rows.Add(r1["XID"], r1["X"]);
}
else
{
r2["KupovniZaDevize"] = r1["BuyingRate"];
r2["ProdajniZaDevize"] = r1["SellingRate"];
}
}
DataTable dt = db.ReturnDataTable("SELECT id_sifrarnikvaluta, SifVal FROM dbo.SifrarnikValuta");
DataColumn[] keyColumns2 = new DataColumn[1];
keyColumns2[0] = dt.Columns["SifVal"];
dt.PrimaryKey = keyColumns2;
//Idi kroz r1 i nadji u t
foreach (DataRow r1 in ds.Tables[0].Rows)
{
DataRow r2 = dt.Rows.Find(r1["CurrencyCodeNumChar"]);
//Ako nisi nasao onda nista
if (r2 == null)
{
//ds2.Tables[0].Rows.Add(r1["XID"], r1["X"]);
}
else
{
r1["ID_SifrarnikValuta"] = r2["id_sifrarnikvaluta"];
}
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
Paritet = dr["Unit"].ToString();
Kupovni = dr["BuyingRate"].ToString();
Prodajni = dr["SellingRate"].ToString();
Srednji = dr["MiddleRate"].ToString();
SifVal = dr["CurrencyCode"].ToString();
Verzija = dr["ExchangeRateListNumber"].ToString();
//Datum = dr["Date"].ToString();
KupovniZaDevize = (dr["KupovniZaDevize"].ToString() == "") ? "0" : dr["KupovniZaDevize"].ToString();
ProdajniZaDevize = (dr["ProdajniZaDevize"].ToString() == "") ? "0" : dr["ProdajniZaDevize"].ToString();
IDSifVal = dr["ID_SifrarnikValuta"].ToString();
OznVal = dr["CurrencyCodeAlfaChar"].ToString();
//string sql = "";
//Insert u KursnaLista
sql = "insert into KursnaLista(ID_SifrarnikValuta,ID_Zemlja, ID_DokumentaView, Datum, Paritet, Kupovni, Srednji, Prodajni, Dogovorni, KupovniZaDevize, ProdajniZaDevize, OznVal, Verzija) "
+ "values(" + IDSifVal + ", 4, " + IdDokView + ", '" + Datum.Trim() + "', " + Paritet + ", " + Kupovni + ", " + Srednji + ", " + Prodajni + ", " + Srednji + ", " + KupovniZaDevize + ", " + ProdajniZaDevize + ", '" + OznVal + "', " + Verzija + " )";
da.InsertCommand = new SqlCommand(sql, con);
da.InsertCommand.ExecuteNonQuery();
}
//Unos RSD (domaca valuta)
sql = "insert into KursnaLista(ID_SifrarnikValuta,ID_Zemlja, ID_DokumentaView, Datum, Paritet, Kupovni, Srednji, Prodajni, Dogovorni, KupovniZaDevize, ProdajniZaDevize, OznVal, Verzija) "
+ "values(1, 4, " + IdDokView + ", '" + Datum + "', 1, 1, 1, 1, 1, 1, 1, 'RSD', " + Verzija + " )";
da.InsertCommand = new SqlCommand(sql, con);
da.InsertCommand.ExecuteNonQuery();
//Totali za KurnuListu
string strTabela = "";
string dokType = "";
string strParams = "";
string str = "";
List <string[]> lista = new List <string[]>();
str = "Execute TotaliZaDokument " + NazivDokumenta + "," + IdDokView.ToString();
lista.Add(new string[] { str, strParams, strTabela, dokType, IdDokView.ToString() });
lista.ToArray();
db.ReturnSqlTransactionParamsFull(lista);
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = ds; // dataset
dataGridView1.DataMember = "ExchangeRate";
//tamara 17.6.21.
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].Visible = false;
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[11].Visible = false;
dataGridView1.Columns[12].Visible = false;
dataGridView1.Columns[14].Visible = false;
dataGridView1.Columns[19].Visible = false;
dataGridView1.Columns[20].Visible = false;
dataGridView1.Columns[21].Visible = false;
dataGridView1.Columns[22].Visible = false;
dataGridView1.Columns[7].HeaderText = "Šifra valute";
dataGridView1.Columns[8].HeaderText = "Oznaka valute";
dataGridView1.Columns[10].HeaderText = "Naziv valute";
dataGridView1.Columns[13].HeaderText = "Naziv zemlje";
dataGridView1.Columns[15].HeaderText = "Važi za";
dataGridView1.Columns[16].HeaderText = "Kupovni kurs";
dataGridView1.Columns[17].HeaderText = "Srednji kurs";
dataGridView1.Columns[18].HeaderText = "Prodajni kurs";
db.ExecuteStoreProcedure("TotaliZaDokument", "NazivDokumenta:Dokumenta", "IdDokument:" + IdDokView.ToString());
db.ExecuteStoreProcedure("TotaliZaDokument", "NazivDokumenta:KursnaLista", "IdDokument:" + IdDokView.ToString());
Kraj :;
}
private void Obrada(string imebaze = "")
{
strIzborBaze = "";
strOrgDefaultText = "";
strCurrentbaza = "";
baza.Text = imebaze;
strCurrentbaza = imebaze;
string usrnam = username.Text;
var dv = new DataView();
grupalabel.Visible = false;
grupa.Visible = false;
bazalabel.Visible = false;
baza.Visible = false;
baza.Clear();
grupa.Clear();
if (usrnam != "")
{
//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 = usrnam;
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);
//strIzborBaze statusbaze
//strCurrentbaza defaultna baza.
//strIzborOrganizacionogDela = status org deo
// strOrgDefaultText = defaultna org deo
for (n = 0; n < result.Length; n++)
{
if (result[n] != "")
{
if (result[n].Contains("Baza1") == true)
{
if (strCurrentbaza == "")
{
strCurrentbaza = result[n].Substring(result[n].IndexOf("=") + 1);
}
}
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")
{
if (strIzborBaze == "IzborBaze=1" && strCurrentbaza == "")
{
strCurrentbaza = 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);
//break;
}
}
}
if (strIzborBaze == "IzborBaze=1") // ako je 1 puni combo
{
var con1 = new SqlConnection(Program.connectionString);
if (con1.State == ConnectionState.Closed)
{
con1.Open();
}
var cmd = new SqlCommand();
var da = new SqlDataAdapter();
cmd.Connection = con1;
cmd.CommandText = "listaDB";
cmd.Parameters.Add("@imebaze", SqlDbType.VarChar, 100).Value = imebaze;
cmd.CommandType = CommandType.StoredProcedure;
da.SelectCommand = cmd;
da.Fill(dtUlaz);
string[] tobeDistinct = { "DatabaseName" };
DataTable dtDistinct = GetDistinctRecords(dtUlaz, tobeDistinct);
for (int p = 0; p < dtDistinct.Rows.Count; p++)
{
if (dtDistinct.Rows[p][0].ToString() != "")
{
if (dtDistinct.Rows[p][0].ToString() == strCurrentbaza)
{
indexCurrentbaza = p;
}
}
baza.AddItem(dtDistinct.Rows[p][0].ToString());
aliasDatabase.Add(dtDistinct.Rows[p][0].ToString(), dtDistinct.Rows[p][0].ToString());
}
}
if (strIzborOrganizacionogDela == "IzborOrganizacionogDela=1") // puni combo za org
{
string[] TobeDistinct = { "Naziv" };
DataTable dtDistinct = GetDistinctRecords(dtUlaz, TobeDistinct);
grupa.Clear();
for (int p = 0; p < dtDistinct.Rows.Count; p++)
{
if (dtDistinct.Rows[p][0].ToString() == strOrgDefaultText)
{
indexOrgDefault = p;
}
if (dtDistinct.Rows[p][0].ToString() != "")
{
grupa.AddItem(dtDistinct.Rows[p][0].ToString());
}
}
}
DataTable drr = new DataTable();
baza.Visible = false;
grupa.Visible = false;
switch (strIzborBaze)
{
case "":
baza.Clear();
break;
case "IzborBaze=1":
bazalabel.Visible = true;
baza.Visible = true;
baza.selectedIndex = indexCurrentbaza;
break;
}
switch (strIzborOrganizacionogDela)
{
case "":
grupa.Clear();
break;
case "IzborOrganizacionogDela=1":
grupalabel.Visible = true;
grupa.Visible = true;
grupa.selectedIndex = indexOrgDefault;
DataTable IdOrg = DB.ReturnDataTable(" 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='" + strOrgDefaultText + "' And o.ID_OrganizacionaStrukturaStablo=os.ID_OrganizacionaStrukturaStablo ;");
dv = IdOrg.DefaultView;
if (dv.Count > 0)
{
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";
DataBaseBroker db = new DataBaseBroker();
DataTable t = new DataTable();
t = db.ReturnDataTable(str);
if (t.Rows.Count == 0)
{
Program.DomacaValuta = "RSD";
Program.ID_DomacaValuta = 1;
Program.ID_MojaZemlja = 4;
}
else
{
Program.DomacaValuta = Convert.ToString(t.Rows[0]["OznVal"]);
Program.ID_DomacaValuta = Convert.ToInt32(t.Rows[0]["ID_SifrarnikValuta"]);
Program.ID_MojaZemlja = Convert.ToInt32(t.Rows[0]["ID_Zemlja"]);
}
}
grupa.Text = strOrgDefaultText;
break;
}
}
if (baza.selectedIndex != -1)
{
Program.NazivBaze = baza.selectedValue; // izmeniti konekciju i u Program.cs
// Program.connectionString = "Data Source=DESKTOP-71PLEMH;Initial Catalog=" + cmbBaze.Text + ";User ID=sa;password=password;";
// Program.GetConnection();
}
}
private void bazaonItemSelected(object sender, EventArgs e)
{
string strimebaze = "";
SqlConnection cnn = new SqlConnection(connectionString);
cnn = Program.GetConnection();
if (cnn == null)
{
MessageBox.Show("Greska u konekciji!");
Application.Exit();
System.Environment.Exit(1);
}
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++)
{
if (aliasDatabase[baza.selectedValue] == Convert.ToString(dv[x][0]))
{
strimebaze = Convert.ToString(dv[x][0]); Program.NazivBaze = strimebaze; break;
}
}
if (strimebaze == "")
{
MessageBox.Show("Ne postoji izabrana baza", "info");
grupa.Clear();
}
else
{
changeDatabase(baza.selectedValue);
grupa.Clear();
var query = "SELECT Naziv FROM OrganizacionaStruktura ";
var databaseBroker = new DataBaseBroker();
var dataTable = databaseBroker.ReturnDataTable(query);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
if (dataTable.Rows[i][0].ToString() == strOrgDefaultText)
{
indexOrgDefault = i;
}
if (dataTable.Rows[i][0].ToString() != "")
{
grupa.AddItem(dataTable.Rows[i][0].ToString());
}
}
if (baza.selectedValue == strCurrentbaza)
{
grupa.selectedIndex = indexOrgDefault;
}
}
}
private void OK_Click(object sender, EventArgs e)
{
//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);
Program.RacioWith = (float)widthRatio;
Program.RacioHeight = (float)heightRatio;
if (changePassword)
{
if (password.Text.Trim().Equals(newpassword.Text.Trim()))
{
DB.ReturnDataTable("UPDATE KadrovskaEvidencija SET pass ='******' WHERE Suser = '******'");
MessageBox.Show("Uspešno ste promenili lozinku!");
ReloadLogin();
changePassword = false;
}
else
{
MessageBox.Show("Ne podudaraju se lozinke,pokušajte ponovo!");
}
return;
}
string ImeKorisnika = "";
string PassKorisnika = "";
string n = username.Text;
bazalabel.Text = "";
grupalabel.Text = "";
if (n.Length == 0)
{
porukalabel.Text = "Polje korisničko ime je prazno";
porukalabel.Visible = true;
return;
}
n = password.Text;
if (n.Length == 0)
{
porukalabel.Text = "Polje za lozinku je prazno";
porukalabel.Visible = true;
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 = username.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
{
porukalabel.Text = "Pogresno korisničko ime !";
porukalabel.Visible = true;
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 = '" + grupa.selectedValue + "' and o.ID_OrganizacionaStrukturaStablo=os.ID_OrganizacionaStrukturaStablo ;";
DataSet ds = new DataSet();
ds = DB.ReturnDS(strOrgDeo);
DataView dv = ds.Tables[0].DefaultView;
Program.idOrgDeo = Convert.ToInt32(dv[0]["ID_OrganizacionaStruktura"]);
Program.idFirme = Convert.ToInt32(dv[0]["ID_OrganizacionaStrukturaStablo"]);
Program.imeFirme = dv[0]["Naziv"].ToString();
cnn.Close();
}
if (username.Text != ImeKorisnika)
{
porukalabel.Text = "Pogrešno korisničko ime !";
porukalabel.Visible = true;
username.Text = "";
return;
}
bool result = password.Text.Equals(PassKorisnika);
if (result == false)
{
porukalabel.Text = "Pogrešna lozinka!";
return;
}
Program.imekorisnika = ImeKorisnika;
Program.IntLogovanje = 1;
Hide();
try
{
((BankomMDI)MdiParent).Controls["menuStrip"].Enabled = true;
((BankomMDI)MdiParent).Controls["menuStrip1"].Enabled = true;
((BankomMDI)MdiParent).Text = Program.imeFirme + "-" + Program.imekorisnika;
}
catch { }
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());
}
}
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;
}
}
}
}
}
