public void prikaziSemafor(int pSemaforID)
{
SemaforiDataContext db = new SemaforiDataContext();
var semafor = (from tblSemafor in db.tblSemafors where tblSemafor.Id == pSemaforID select tblSemafor).Single();
// straniceSrc.DataBind();
textBoxSemaforNaziv.Text = semafor.naziv;
labelSemaforID.Text = semafor.Id.ToString();
ViewState["EditMode"] = "1";
ListViewStranice.DataBind();
// trebalo bi odabrati prvu stranicu za prikaz ako je moguće
// najlakše je da nađemo kontrolu?
// pronađi prvu stranicu
// pazi da li slučajno nije niz prazan
if (ListViewStranice.Items.Count > 0) {
foreach (Control b in ListViewStranice.Items[0].Controls) {
if (b is LinkButton) {
OdabranaStranica_Click(b as LinkButton, null);
//ListViewCommandEventArgs args = new ListViewCommandEventArgs(ListViewStranice.Items[0], (b as LinkButton),);
ListViewStranice_ItemCommand(b as LinkButton, null);
}
}
}
//editSemafor.Visible = true;
//contentUpdatePanel.Update();
prikaziContentDiv("semafor");
}
void dodajCelije(int pRedak_DB_ID, string redakID)
{
string HTML_ID_Celije;
int i = 1;
SemaforiDataContext db = new SemaforiDataContext();
IEnumerable<tblCelija>
celije = from c in db.tblCelijas
where c.redakID == pRedak_DB_ID
select c;
foreach (tblCelija celijaItem in celije) {
HTML_ID_Celije = redakID + "_celija_" + i;
CelijaRetkaSemafora celija = new CelijaRetkaSemafora(HTML_ID_Celije, celijaItem.id);
celija.Attributes["class"] = "col-lg-4 col-md-6";
Controls.Add(celija);
++i;
}
/*for (int i = 1; i <= brojCelija; ++i) {
idCelije = redakID+"_celija_" + i;
celijaRetkaSemafora celija = new celijaRetkaSemafora(idCelije);
celija.Attributes["class"] = "col-lg-4 col-md-6";
Controls.Add(celija);
}*/
}
void dodajRetke(int pstranica_DB_ID)
{
string idRetka;
//dodajemo retke
int i= 1;
SemaforiDataContext db = new SemaforiDataContext();
IEnumerable<tblRedak> redci = from r in db.tblRedaks
where r.stranicaID == stranica_DB_ID
select r;
foreach (tblRedak redakItem in redci) {
idRetka = "redak_" + i;
redakStraniceSemafora redak = new redakStraniceSemafora(idRetka, semafor_DB_ID,redakItem.id);
redak.Attributes["class"] = "row";
Controls.Add(redak);
++i;
}
/*for (int i = 1; i <= brojRedaka; ++i) {
idRetka = "redak_" + i;
redakStraniceSemafora redak = new redakStraniceSemafora(idRetka,semafor_DB_ID);
redak.Attributes["class"] = "row";
Controls.Add(redak);
}*/
}
private void dohvatiBrojRedaka(int semaforID)
{
SemaforiDataContext db = new SemaforiDataContext();
IEnumerable<tblStranica>
stranice = from s in db.tblStranicas
where s.Id == stranica_DB_ID
select s;
}
public void dohvatiNaslovSemafora(LinkButton linkButtonNaslov)
{
SemaforiDataContext db = new SemaforiDataContext();
tblSemafor
semafor = (from p in db.tblSemafors where p.Id == semafor_DB_ID
select p).Single() ;
//tblStranica stranica = (from s in db.tblStranicas where s.semaforID == semafor.Id select s).First();
// db.Dispose(); // ovo će garbage collector srediti
// naslovSemaforaCelija.InnerHtml = semafori.Last().naziv + " - Stranica " + trenutnaStranica;
nazivSemafora = semafor.naziv;
//HttpContext.Current.Session["NaslovSemaforaIStranice"]= semafor.naziv + " - " + stranica.naziv;
}
private void prikaziBazu(int pbazaID)
{
SemaforiDataContext db = new SemaforiDataContext();
var baza = (from tblDB in db.tblDBs where tblDB.id == pbazaID select tblDB).Single();
//labelBazaID.Text = baza.id.ToString();
//textBoxBazaNaziv.Text = baza.naziv;
//textBoxBazaKorisnik.Text = baza.korisnik;
//textBoxBazaLozinka.Text = baza.lozinka;
////checkBoxBazaIntegratedAuth.
//prikaziContentDiv("baza");
}
protected void TextBoxStranicaNaziv_TextChanged(object sender, EventArgs e)
{
SemaforiDataContext db = new SemaforiDataContext();
var stranica = (from tblStranica in db.tblStranicas where tblStranica.Id == Convert.ToInt32(LabelStranicaID.Text) select tblStranica).Single();
stranica.naziv = TextBoxStranicaNaziv.Text;
try {
db.SubmitChanges();
}
catch (Exception e1) {
Console.WriteLine(e1);
}
ListViewStranice.DataBind();
oznaciTabStranice(stranica.Id);
}
protected void TextBoxStranicaVrijemePrikazivanja_TextChanged(object sender, EventArgs e)
{
SemaforiDataContext db = new SemaforiDataContext();
var stranica = (from tblStranica in db.tblStranicas where tblStranica.Id == Convert.ToInt32(LabelStranicaID.Text) select tblStranica).Single();
try {
stranica.refreshPeriod = Convert.ToInt32(TextBoxStranicaVrijemePrikazivanja.Text);
Session["periodOsvjezavanjaStranice"] = TextBoxStranicaVrijemePrikazivanja.Text;
try {
db.SubmitChanges();
}
catch (Exception e1) {
Console.WriteLine(e1);
}
ListViewStranice.DataBind();
oznaciTabStranice(stranica.Id);
}
catch (Exception e2) {
Console.Write(e2);
}
}
protected void prikaziStranicu(int stranicaID)
{
ListViewStranice.DataBind();
SemaforiDataContext db = new SemaforiDataContext();
var stranica = (from tblStranica in db.tblStranicas where tblStranica.Id == stranicaID select tblStranica).Single();
LabelStranicaID.Text = stranica.Id.ToString();
TextBoxStranicaNaziv.Text = stranica.naziv;
TextBoxStranicaVrijemePrikazivanja.Text = stranica.refreshPeriod.ToString();
DropDownListStranicaBrojRedova.SelectedValue = stranica.brojRedova.ToString();
oznaciTabStranice(stranicaID);
}
protected void textBoxSemaforNaziv_TextChanged(object sender, EventArgs e)
{
SemaforiDataContext db = new SemaforiDataContext();
var sem = (from s in db.tblSemafors where s.Id == Convert.ToInt32(labelSemaforID.Text) select s).Single();
sem.naziv = textBoxSemaforNaziv.Text;
try {
db.SubmitChanges();
}
catch (Exception e1) {
Console.WriteLine(e1);
}
ListViewSemafori.DataBind();
//menuUpdatePanel.Update();
//Response.Redirect(HttpContext.Current.Request.Path);
}
protected void buttonServerSnimiPostavke_Click(object sender, EventArgs e)
{
SemaforiDataContext db = new SemaforiDataContext();
SimplerAES saes = new SimplerAES();
if (Convert.ToInt32(labelServerID.Text) > 0) { // ako imamo ID, znači da mijenjamo postojeći
tblServer server = (from tblServer in db.tblServers where tblServer.id == Convert.ToInt32(labelServerID.Text) select tblServer).Single();
server.naziv = textBoxServerNaziv.Text;
server.serverString = textBoxServerServerString.Text;
db.SubmitChanges();
tblDB dbase = (from tblDB in db.tblDBs where tblDB.serverid == server.id select tblDB).Single();
dbase.naziv = textBoxServerDatabaseName.Text;
dbase.serverid = server.id;
dbase.integratedAuth = checkBoxServerDatabaseIntegratedAuth.Checked;
dbase.korisnik = textBoxServerDatabaseKorisnik.Text;
dbase.dbAttachString = textBoxServerDatabaseAttachString.Text;
// kriptiramo lozinku da je baš ne spremimo u clear text u bazu
// ako nešto piše u TXt, to je nova lozinka. Spremi u H atribut
if (textBoxServerDatabaseLozinka.Text.Length>0) {
textBoxServerDatabaseLozinka.Attributes["h"] = saes.Encrypt(textBoxServerDatabaseLozinka.Text);
}
dbase.lozinka = textBoxServerDatabaseLozinka.Attributes["h"];
db.SubmitChanges();
(sender as Button).Enabled = false;
labelServerProvjeraStringa.Text = "";
}
else { //nemamo ID, upisujemo novi
tblServer server = new tblServer();
tblDB dbase = new tblDB();
server.naziv = textBoxServerNaziv.Text;
server.serverString = textBoxServerServerString.Text;
db.tblServers.InsertOnSubmit(server);
db.SubmitChanges();
dbase.naziv = textBoxServerDatabaseName.Text;
dbase.serverid = server.id;
dbase.integratedAuth = checkBoxServerDatabaseIntegratedAuth.Checked;
dbase.korisnik = textBoxServerDatabaseKorisnik.Text;
dbase.dbAttachString = textBoxServerDatabaseAttachString.Text;
// kriptiramo password prije nego ga upišemo u bazu
textBoxServerDatabaseLozinka.Attributes["h"] = saes.Encrypt(textBoxServerDatabaseLozinka.Text);
dbase.lozinka = saes.Encrypt(textBoxServerDatabaseLozinka.Text);
db.tblDBs.InsertOnSubmit(dbase);
db.SubmitChanges();
(sender as Button).Enabled = false;
labelServerProvjeraStringa.Text = "";
}
ListViewServeri.DataBind();
menuUpdatePanel.Update();
}
protected void DodajSemafor_Click(object sender, EventArgs e)
{
/*
dodajemo semafor
Svaki semafor odmah dobije jednu stranicu i jedan red
dignemo prozor sa nazivom semafora, upišemo ga i prikažemo sve na desnoj strani
*/
SemaforiDataContext db = new SemaforiDataContext();
string privremeniNaslovSemafora = "Novi Semafor";
tblSemafor semafor = new tblSemafor();
tblStranica stranica = new tblStranica();
tblRedak redak = new tblRedak();
// upisi semafor
semafor.naziv = privremeniNaslovSemafora;
db.tblSemafors.InsertOnSubmit(semafor);
db.SubmitChanges();
//upisi stranicu semafora
stranica.semaforID = semafor.Id;
stranica.naziv = "Privremeni naziv stranice";
stranica.refreshPeriod = 10000;
stranica.brojRedova = 1;
db.tblStranicas.InsertOnSubmit(stranica);
db.SubmitChanges();
//upisi redove
redak.stranicaID = stranica.Id;
db.tblRedaks.InsertOnSubmit(redak);
db.SubmitChanges();
//dodaj retku 3 celije
for (int i = 0; i < 3; ++i) {
tblCelija celija = new tblCelija();
celija.redakID = redak.id;
celija.grafID = 9999; //samo privremeno da ne bude problema kasnije !!!
celija.upitID = 9999;
db.tblCelijas.InsertOnSubmit(celija);
db.SubmitChanges();
}
prikaziSemafor(semafor.Id);
}
protected void buttonUpitSnimi_Click(object sender, EventArgs e)
{
SemaforiDataContext db = new SemaforiDataContext();
// slično kao i kod servera; ako je Id=-1, onda je dodavanje novog, inače je edit
if (Convert.ToInt32(labelUpitID.Text)>0) { //edit postojećeg
tblUpit upit = (from u in db.tblUpits where u.id == Convert.ToInt32(labelUpitID.Text) select u).Single();
upit.naziv = textBoxUpitNaziv.Text;
upit.upit = textBoxUpitDefinicija.Text;
upit.serverID = Convert.ToInt32(dropDownListUpitOdaberiDatasource.SelectedValue);
// petljanje, ali kad se mora.
tblDB dbase = (from d in db.tblDBs where d.serverid == upit.serverID select d).Single();
upit.dbID = dbase.id;
db.SubmitChanges();
}
else { //dodajemo novi
tblUpit upit = new tblUpit();
upit.naziv = textBoxUpitNaziv.Text;
upit.upit = textBoxUpitDefinicija.Text;
upit.serverID = Convert.ToInt32(dropDownListUpitOdaberiDatasource.SelectedValue);
// petljanje, ali kad se mora.
tblDB dbase = (from d in db.tblDBs where d.serverid == upit.serverID select d).Single();
upit.dbID = dbase.id;
db.tblUpits.InsertOnSubmit(upit);
db.SubmitChanges();
}
ListViewUpiti.DataBind();
menuUpdatePanel.Update();
}
protected void LinkButtonBrisiStranicu_Click(object sender, EventArgs e)
{
// brisanje stranice, redova i celija
int stranicaID = Convert.ToInt32(LabelStranicaID.Text);
SemaforiDataContext db = new SemaforiDataContext();
// pripazi na kaskadno brisanje
var stranica = (from tblStranica in db.tblStranicas where tblStranica.Id == stranicaID select tblStranica).Single();
var brisiRedove = from tblRedak in db.tblRedaks where tblRedak.stranicaID == stranicaID select tblRedak;
foreach (var redak in brisiRedove) {
// pronađi da li ima celija i ako ima, obriši ih
var brisiCelije = from tblCelija in db.tblCelijas where tblCelija.redakID == redak.id select tblCelija;
foreach (var celija in brisiCelije) {
db.tblCelijas.DeleteOnSubmit(celija);
}
// obriši redak
db.tblRedaks.DeleteOnSubmit(redak);
}
// obrisi stranicu
db.tblStranicas.DeleteOnSubmit(stranica);
db.SubmitChanges();
// pronađi ID prethodne stranice i nju prikaži
stranica = (from tblStranica in db.tblStranicas where tblStranica.Id < stranicaID select tblStranica).OrderByDescending(x => x.Id).First();
prikaziStranicu(stranica.Id);
menuUpdatePanel.Update();
contentUpdatePanel.Update();
}
protected void DropDownListStranicaBrojRedova_SelectedIndexChanged(object sender, EventArgs e)
{
//ovdje dodajemo ili brišemo redove i njihove pripadne ćelije
SemaforiDataContext db = new SemaforiDataContext();
var stranica = (from tblStranica in db.tblStranicas where tblStranica.Id == Convert.ToInt32(LabelStranicaID.Text) select tblStranica).Single();
stranica.brojRedova = Convert.ToInt32(DropDownListStranicaBrojRedova.SelectedValue);
try {
db.SubmitChanges();
}
catch (Exception e1) {
Console.WriteLine(e1);
}
// tu trebamo dodati ili brisati redove, zavisi da li ih ima više ili manje. Također treba dodavati ili brisati i njihove ćelije
switch (stranica.brojRedova) {
case 1:
// bili smo na 2, briši zadnji red
// prvo provjeri koja dva imamo pokupi redakID iz celije
IEnumerable<tblRedak> redovi = (from tblRedak in db.tblRedaks where tblRedak.stranicaID == Convert.ToInt32(LabelStranicaID.Text) select tblRedak).OrderByDescending(x => x.id);
tblRedak redZaBrisanje = redovi.First();
if (redovi.Count() > 1) {
db.tblRedaks.DeleteOnSubmit(redZaBrisanje);
IEnumerable<tblCelija> celije = (from tblCelija in db.tblCelijas where tblCelija.redakID == redZaBrisanje.id select tblCelija);
db.tblCelijas.DeleteAllOnSubmit(celije);
db.SubmitChanges();
}
break;
case 2:
// trebamo dodati red
tblRedak redak = new tblRedak();
redak.stranicaID = stranica.Id;
db.tblRedaks.InsertOnSubmit(redak);
db.SubmitChanges();
// dodajemo i njegove celije
for (int i = 0; i < 3; ++i) {
tblCelija celija = new tblCelija();
celija.redakID = redak.id;
celija.upitID = 9999;
celija.grafID = 9999;
db.tblCelijas.InsertOnSubmit(celija);
db.SubmitChanges();
}
break;
}
ListViewStranice.DataBind();
ListViewRedovi.DataBind();
contentUpdatePanel.Update();
oznaciTabStranice(stranica.Id);
}
protected void LinkButtonBrisiSemafor_Click(object sender, EventArgs e)
{
int semaforID = Convert.ToInt32(labelSemaforID.Text);
SemaforiDataContext db = new SemaforiDataContext();
// pripazi na kaskadno brisanje
var brisiSemafor = (from tblSemafor in db.tblSemafors where tblSemafor.Id == semaforID select tblSemafor).Single();
var brisiStranice = (from tblStranica in db.tblStranicas where tblStranica.semaforID == semaforID select tblStranica);
foreach (tblStranica stranica in brisiStranice) {
var brisiRedove = from tblRedak in db.tblRedaks where tblRedak.stranicaID == stranica.Id select tblRedak;
foreach (var redak in brisiRedove) {
// pronađi da li ima celija i ako ima, obriši ih
var brisiCelije = from tblCelija in db.tblCelijas where tblCelija.redakID == redak.id select tblCelija;
foreach (var celija in brisiCelije) {
db.tblCelijas.DeleteOnSubmit(celija);
}
// obriši redak
db.tblRedaks.DeleteOnSubmit(redak);
}
// obrisi stranicu
db.tblStranicas.DeleteOnSubmit(stranica);
}
// obrisi semafor
db.tblSemafors.DeleteOnSubmit(brisiSemafor);
db.SubmitChanges();
ListViewSemafori.DataBind();
menuUpdatePanel.Update();
contentUpdatePanel.Update();
editSemafor.Visible = false;
}
protected void DropDownListOdabirUpita_SelectedIndexChanged(object sender, EventArgs e)
{
// upiši u tablicu celije koji upit smo odabrali
// celijaID nam je zapisana kao custom atribut za svaki dropdown
int celijaID =Convert.ToInt32((sender as DropDownList).Attributes["celijaID"]);
SemaforiDataContext db = new SemaforiDataContext();
tblCelija celija = (from c in db.tblCelijas where c.id == celijaID select c).Single();
celija.upitID = Convert.ToInt32((sender as DropDownList).SelectedValue);
db.SubmitChanges();
}
protected void DropDownListOdabirUpita_DataBinding(object sender, EventArgs e)
{
// tu smo kad bi spajali podatke :-)
//prikazujemo selected value ovisno o Id-uint upisanom u tblCelija. Stvar je u tome da kad upisujemo novu celiju, kao id za upit upisujemo 9999
int celijaID = Convert.ToInt32((sender as DropDownList).Attributes["celijaID"]);
SemaforiDataContext db = new SemaforiDataContext();
tblCelija celija = (from c in db.tblCelijas where c.id == celijaID select c).Single();
if (celija.upitID != 9999) {
(sender as DropDownList).SelectedValue = celija.upitID.ToString();
}
else {
// vidi da li postoji već sa 9999. ako ne postoji, dodaj ga
if ((sender as DropDownList).Items.FindByValue("9999") == null) {
(sender as DropDownList).Items.Insert(0, new ListItem("Odaberite", "9999"));
contentUpdatePanel.Update();
}
}
}
protected void DropDownListcelijaOdabirVrsteGrafa_DataBinding(object sender, EventArgs e)
{
// tu smo kad bi spajali podatke :-)
//prikazujemo selected value ovisno o Id-uint upisanom u tblCelija. Stvar je u tome da kad upisujemo novu celiju, kao id za graf upisujemo 9999
int celijaID = Convert.ToInt32((sender as DropDownList).Attributes["celijaID"]);
SemaforiDataContext db = new SemaforiDataContext();
tblCelija celija = (from c in db.tblCelijas where c.id == celijaID select c).Single();
if (celija.grafID != 9999) {
(sender as DropDownList).SelectedValue = celija.grafID.ToString();
}
}
private void prikaziServer(int pserverID)
{
SemaforiDataContext db = new SemaforiDataContext();
var server = (from tblServer in db.tblServers where tblServer.id == pserverID select tblServer).Single();
labelServerID.Text = server.id.ToString();
textBoxServerNaziv.Text = server.naziv;
textBoxServerServerString.Text = server.serverString;
var dbase = (from tblDB in db.tblDBs where tblDB.serverid == server.id select tblDB).Single();
textBoxServerDatabaseName.Text = dbase.naziv;
//checkBoxServerDatabaseIntegratedAuth.Checked = (bool)dbase.integratedAuth;
if ((bool)dbase.integratedAuth) {
checkBoxServerDatabaseIntegratedAuth.Checked = true;
textBoxServerDatabaseKorisnik.Enabled = false;
textBoxServerDatabaseLozinka.Enabled = false;
}
else {
checkBoxServerDatabaseIntegratedAuth.Checked = false;
textBoxServerDatabaseKorisnik.Enabled = true;
textBoxServerDatabaseLozinka.Enabled = true;
}
textBoxServerDatabaseKorisnik.Text = dbase.korisnik;
textBoxServerDatabaseLozinka.Attributes["h"] = dbase.lozinka;
textBoxServerDatabaseAttachString.Text = dbase.dbAttachString;
//po defaultu je snimi disabled
buttonServerSnimiPostavke.Enabled = false;
labelServerProvjeraStringa.Text = "";
prikaziContentDiv("server");
}
protected void LinkButtonDodajStranicu_Click(object sender, EventArgs e)
{
//upisi stranicu semafora
SemaforiDataContext db = new SemaforiDataContext();
tblStranica stranica = new tblStranica();
tblRedak redak = new tblRedak();
stranica.semaforID = Convert.ToInt32(labelSemaforID.Text);
stranica.naziv = "Privremeni naziv stranice";
stranica.refreshPeriod = 10000;
stranica.brojRedova = 1;
db.tblStranicas.InsertOnSubmit(stranica);
db.SubmitChanges();
//upisi redove
redak.stranicaID = stranica.Id;
db.tblRedaks.InsertOnSubmit(redak);
db.SubmitChanges();
//po defaultu nam graID i upitID ne postoje, pa nas onda strga u null vrijednosti kod prikaza !!!
//upisi celije
for (int i = 0; i < 3; ++i) {
tblCelija celija = new tblCelija();
celija.redakID = redak.id;
celija.upitID = 9999;
celija.grafID = 9999;
db.tblCelijas.InsertOnSubmit(celija);
db.SubmitChanges();
}
prikaziSemafor(stranica.semaforID);
prikaziStranicu(stranica.Id);
oznaciTabStranice(stranica.Id);
}
private void prikaziUpit(int pUpitID)
{
SemaforiDataContext db = new SemaforiDataContext();
tblUpit upit = (from u in db.tblUpits where u.id == pUpitID select u).Single();
// napuni kontrole.
labelUpitID.Text = upit.id.ToString();
textBoxUpitNaziv.Text = upit.naziv;
textBoxUpitDefinicija.Text = upit.upit;
//dropdown za odabir datasource-a
dropDownListUpitOdaberiDatasource.SelectedValue = upit.serverID.ToString();
prikaziContentDiv("upit");
}
protected void ListViewStranice_ItemCommand(object sender, ListViewCommandEventArgs e)
{
// ovdje se pune kontrole kad kliknemo na odabranu stranicu u listview
LinkButton t = sender as LinkButton;
//if (String.Equals(e.CommandName, "OdabranaStranica")) {
// sad napuni podatke za stranicu
SemaforiDataContext db = new SemaforiDataContext();
if (sender is LinkButton) { // zavisi da li smo pozvali na ruke ili klikom na link
var stranica = (from tblStranica in db.tblStranicas where tblStranica.Id == Convert.ToInt32(t.CommandArgument) select tblStranica).Single();
LabelStranicaID.Text = stranica.Id.ToString();
TextBoxStranicaNaziv.Text = stranica.naziv;
TextBoxStranicaVrijemePrikazivanja.Text = stranica.refreshPeriod.ToString();
DropDownListStranicaBrojRedova.SelectedValue = stranica.brojRedova.ToString();
}
else {
var stranica = (from tblStranica in db.tblStranicas where tblStranica.Id == Convert.ToInt32(e.CommandArgument) select tblStranica).Single();
LabelStranicaID.Text = stranica.Id.ToString();
TextBoxStranicaNaziv.Text = stranica.naziv;
TextBoxStranicaVrijemePrikazivanja.Text = stranica.refreshPeriod.ToString();
DropDownListStranicaBrojRedova.SelectedValue = stranica.brojRedova.ToString();
}
//LabelStranicaID.Text = stranica.Id.ToString();
//TextBoxStranicaNaziv.Text = stranica.naziv;
//TextBoxStranicaVrijemePrikazivanja.Text = stranica.refreshPeriod.ToString();
//DropDownListStranicaBrojRedova.SelectedValue = stranica.brojRedova.ToString();
// }
}
protected void LinkButtonBrisiServerDatasource_Click(object sender, EventArgs e)
{
// brisemo sada taj datasource
SemaforiDataContext db = new SemaforiDataContext();
tblServer server = (from s in db.tblServers where s.id == Convert.ToInt32(labelServerID.Text) select s).Single();
tblDB dbase = (from d in db.tblDBs where d.serverid == server.id select d).Single();
db.tblServers.DeleteOnSubmit(server);
db.tblDBs.DeleteOnSubmit(dbase);
db.SubmitChanges();
ListViewServeri.DataBind();
prikaziContentDiv("nista");
}
protected void buttonUpitTestiraj_Click(object sender, EventArgs e)
{
// generiramo upit i dovlačimo podatke, te ih prikazujemo u gridu na posebnom layeru
SemaforiDataContext db = new SemaforiDataContext();
SimplerAES saes = new SimplerAES();
string connstring;
viewDatasource datasrc = (from s in db.viewDatasources where s.id == Convert.ToInt32(dropDownListUpitOdaberiDatasource.SelectedValue) select s).First(); //može biti više, daj samo prvi koji štima
// tu sad testiramo da li se možemo spojiti na server ili ćemo dobiti grešku
//connString = "Server = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=|DataDirectory|\\BMS_Data.mdf; Integrated Security = False; User ID=tonza;Password=tonza";
connstring = "Server = " + datasrc.serverString + ";";
// ovaj dio dopisujemo samo ako postoji u bazi, a koristi se samo kad se radi o localDB-u, kada treba attachati bazu. Kad se spajamo na "Veliki" SQL to nam ne treba, pa kod unosa upozori korisnika na to
if (datasrc.dbAttachString.Length > 0)
connstring += "AttachDbFileName= " + datasrc.dbAttachString + ";";
connstring += "Database = " + datasrc.dbNaziv + ";";
connstring += "Integrated Security = " + (datasrc.integratedAuth == true ? "True" : "False") + ";";
// ako se ne koristi integrated, onda trebamo user name i password
if (!datasrc.integratedAuth) {
connstring += "User ID=" + datasrc.korisnik + ";";
connstring += "Password="******";";
}
// mi bi i manji timeout isto
connstring += "Connection Timeout=3";
bool uspjesno = true;
string greska = "";
SqlConnection myConn = new SqlConnection(connstring);
try {
myConn.Open();
}
catch (SqlException se) {
uspjesno = false;
greska = se.Message;
}
if (uspjesno) {
SqlCommand komanda = new SqlCommand(textBoxUpitDefinicija.Text,myConn);
SqlDataReader citac; // = new SqlDataReader();
using (SqlDataReader oReader = komanda.ExecuteReader()) {
// pazi, ne smije biti više od 2 stupca
HtmlTable tablica = new HtmlTable();
HtmlTableRow red;
HtmlTableCell celija;
//tablica.Attributes["Style"] = "border: 1px solid black; margin-left:auto;margin-right:auto;";
tablica.Attributes.Add("class", "previewUpitTablica");
//tablica.Border = 1;
//tablica.CellPadding = 1;
//tablica.CellSpacing = 1;
red = new HtmlTableRow();
// dodaj naslov tablice
for (int i = 0;i< 2; ++i) {
celija = new HtmlTableCell();
celija.Attributes.Add("class", "previewUpitNaslov");
celija.InnerHtml = oReader.GetName(i);
red.Cells.Add(celija);
}
tablica.Rows.Add(red);
while (oReader.Read()) {
red = new HtmlTableRow();
for (int i = 0; i < 2; ++i) {
celija = new HtmlTableCell();
//celija.Attributes["Style"] = "border: 1px solid black; ";
celija.Attributes.Add("class", "previewUpitTd"+(i%2).ToString());
celija.InnerHtml = oReader.GetValue(i).ToString();
red.Cells.Add(celija);
}
tablica.Rows.Add(red);
}
myConn.Close();
prikazTestUpita.Attributes.Add("style", "height:400px");
prikazTestUpita.Controls.AddAt(0,tablica);
}
}
else {
// nema
}
prikazTestUpita.Visible = true;
}