//Gumb za prijavo private void button1_Click(object sender, EventArgs e) { string uporabnik = uporabnikComboBox.Text.Trim(); string geslo = textBox2.Text; if (DBHandle.IsValidLogin(uporabnik, geslo)) { LogonSuccessfull = true; Logger.Log(LoggerAction.Prijava, uporabnik); Program.IDUporabnika = (from u in db.Uporabniki where u.Uporabnik == uporabnik select u.SifraOsebe).Single(); this.Close(); } else { if (!DBHandle.DoesUserExist(uporabnik)) { MessageBox.Show("Uporabnik se ne ujema z nobenim v bazi.", "Baza", MessageBoxButtons.OK, MessageBoxIcon.Question); } else { if (!DBHandle.DoesUserHavePassword(uporabnik)) { MessageBox.Show("Uporabnik nima nastavljenega gesla in zato nima vstop v program.", "Ni gesla", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!DBHandle.HasLoginPermission(uporabnik)) { MessageBox.Show("Uporabniku je bilodvzet dostop do programa.", "Ni dostopa", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Geslo se ne ujema z uporabnikom.", "Napačno geslo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnPotrdi_Click(object sender, EventArgs e) { this.Validate(); System.Drawing.Color myColor; try { myColor = System.Drawing.ColorTranslator.FromHtml(txtBarva.Text); } catch { MessageBox.Show("Napaka pri vnosu barve. Uporabljate lahko vse HTML barve.", "Barva", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } try { DBHandle.SaveUserColor(myColor); } catch { MessageBox.Show("Napaka pri shranjevanju.", "Barva", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } this.DialogResult = DialogResult.OK; this.Close(); }
private void Osebe_Load(object sender, EventArgs e) { try { // TODO: This line of code loads data into the 'posojilaDataSet.Oseba' table. You can move, or remove it, as needed. this.osebaTableAdapter.Fill(this.posojilaDataSet.Oseba); } catch { DBHandle.DBError(); } var slovarKrajev = new Dictionary <Object, String>(); slovarKrajev.Add(DBNull.Value, "ni določen"); foreach (var row in DBHandle.db.Posta.OrderBy(p => p.PostnaStevilka)) { slovarKrajev.Add(row.PostnaStevilka.ToString(), row.PostnaStevilka + " " + row.Kraj); } var val = "Value"; var key = "Key"; dataGridViewTextBoxColumn5.DataSource = new BindingSource(slovarKrajev, null); dataGridViewTextBoxColumn5.DisplayMember = val; dataGridViewTextBoxColumn5.ValueMember = key; }
private void uporabnikComboBox_Leave(object sender, EventArgs e) { if (!DBHandle.DoesUserExist(uporabnikComboBox.Text.Trim())) { uporabnikComboBox.Focus(); MessageBox.Show("Uporabnik se ne ujema z nobenim v bazi.", "Baza", MessageBoxButtons.OK, MessageBoxIcon.Question); } }
private void UserManagment_Load(object sender, EventArgs e) { try { // TODO: This line of code loads data into the 'bazaDataSet.Uporabniki' table. You can move, or remove it, as needed. this.uporabnikiTableAdapter.Fill(this.bazaDataSet.Uporabniki); } catch { DBHandle.DBError(); } }
private void Valute_Load(object sender, EventArgs e) { try { // TODO: This line of code loads data into the 'bazaDataSet.Posta' table. You can move, or remove it, as needed. this.postaTableAdapter.Fill(this.bazaDataSet.Posta); } catch { DBHandle.DBError(); } }
public void FillAll() { try { // TODO: This line of code loads data into the 'db.Uporabniki' table. You can move, or remove it, as needed. this.uporabnikiTableAdapter.Fill(bazaDataSet.Uporabniki); } catch { DBHandle.DBError(); } }
private void fillByImeToolStripButton_Click(object sender, EventArgs e) { var ime = imeToolStripTextBox.Text.Trim() == "" ? "" : imeToolStripTextBox.Text + "%"; var priimek = priimekToolStripTextBox.Text.Trim() == "" ? "" : priimekToolStripTextBox.Text + "%"; try { this.osebaTableAdapter.FillByIme(this.posojilaDataSet.Oseba, ime, priimek); } catch { DBHandle.DBError(); } }
private void uporabnikiToolStripMenuItem_Click(object sender, EventArgs e) { bool isadmin = DBHandle.IsUserAdmin(); if (isadmin.Equals(true)) { var umfrm = new UserManagment(); umfrm.ShowIcon = false; umfrm.ShowInTaskbar = false; umfrm.ShowDialog(); } else { MessageBox.Show("Uporabnik ni Administrator.", "Baza", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public void FillAll() { try { // TODO: This line of code loads data into the 'bazaDataSet.Oseba' table. You can move, or remove it, as needed. this.osebaTableAdapter.Fill(this.bazaDataSet.Oseba); // TODO: This line of code loads data into the 'bazaDataSet.Posojila' table. You can move, or remove it, as needed. this.posojilaTableAdapter.Fill(this.bazaDataSet.Posojila); // TODO: This line of code loads data into the 'bazaDataSet.Valute' table. You can move, or remove it, as needed. this.valuteTableAdapter.Fill(this.bazaDataSet.Valute); } catch { DBHandle.DBError(); } }
private void LoginForm_Load(object sender, EventArgs e) { FillAll(); var frm = new AddInitialUser(); if (DBHandle.AreThereAnyUsers() == false) { frm.ShowInTaskbar = false; frm.ControlBox = false; frm.ShowDialog(); if (!frm.success) { Application.Exit(); } FillAll(); } }
private void Main_Load(object sender, EventArgs e) { FillAll(); toolStripStatusLabel.Text = "Prijavljen: " + DBHandle.GetUserFullName(); //ustvari slovarja oseb var slovarOseb = new Dictionary <long, string>(); foreach (DataRow row in DBHandle.db.Oseba) { slovarOseb.Add(Convert.ToInt64(row["ID"]), row["Ime"] + " " + row["Priimek"]); } var val = "Value"; var key = "Key"; dataGridViewTextBoxColumn2.DataSource = new BindingSource(slovarOseb, null); dataGridViewTextBoxColumn2.DisplayMember = val; dataGridViewTextBoxColumn2.ValueMember = key; dataGridViewTextBoxColumn3.DataSource = new BindingSource(slovarOseb, null); dataGridViewTextBoxColumn3.DisplayMember = val; dataGridViewTextBoxColumn3.ValueMember = key; posojevalecComboBox.DataSource = new BindingSource(slovarOseb, null); posojevalecComboBox.DisplayMember = val; posojevalecComboBox.ValueMember = key; izposojevalecComboBox.DataSource = new BindingSource(slovarOseb, null); izposojevalecComboBox.DisplayMember = val; izposojevalecComboBox.ValueMember = key; var colorString = DBHandle.GetUserColor(); System.Drawing.Color myColor; try { myColor = System.Drawing.ColorTranslator.FromHtml(colorString); } catch { MessageBox.Show("Napaka pri vnosu barve. Uporabljate lahko vse HTML barve.", "Barva", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } this.BackColor = myColor; }
private void Main_FormClosing(object sender, FormClosingEventArgs e) { SaveAll(); Logger.Log(LoggerAction.Odjava, DBHandle.GetUserName()); }
private void LoginForm_Load(object sender, EventArgs e) { txtBarva.Text = DBHandle.GetUserColor(); }