protected void buttonProvjeriServerDatabaseString_Click(object sender, EventArgs e)
{
SimplerAES saes = new SimplerAES();
string connstring;
// 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 = " + textBoxServerServerString.Text + ";";
// 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 (textBoxServerDatabaseAttachString.Text.Length > 0)
connstring += "AttachDbFileName= " + textBoxServerDatabaseAttachString.Text + ";";
connstring += "Database = " + textBoxServerDatabaseName.Text + ";";
connstring += "Integrated Security = " + (checkBoxServerDatabaseIntegratedAuth.Checked == true ? "True" : "False") + ";";
// ako se ne koristi integrated, onda trebamo user name i password
if (!checkBoxServerDatabaseIntegratedAuth.Checked) {
connstring += "User ID=" + textBoxServerDatabaseKorisnik.Text + ";";
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) {
labelServerProvjeraStringa.Text = "Uspješno spajanje na server. Ne zaboravite snimiti testirane postavke.";
textBoxServerDatabaseLozinka.Attributes["h"] = saes.Encrypt(textBoxServerDatabaseLozinka.Text);
// dozvoli snimanje podataka
buttonServerSnimiPostavke.Enabled = true;
}
else {
labelServerProvjeraStringa.Text = "Neuspješno spajanje na server !!! Greška:"+greska;
}
}
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();
}