//private void DataRefresh() //{ // db = new TableContext(); // db.Pictures.Include("Status").Load(); // dGVPicturesList.DataSource = db.Pictures.Local.ToBindingList(); // dGVPicturesList.Refresh(); //} private void bInput_Click(object sender, EventArgs e) { Users user; if ((user = DBFunction.Auth(tbLogin.Text, tbPassword.Text)) != null) { FormMain formMain = new FormMain(user); formMain.Show(); formMain.Closed += (s, Args) => this.Close(); this.Hide(); } }
public FormGenreList(Users sess) { this.sess = sess; TabCon = new TableContext(); InitializeComponent(); if (DBFunction.Session(sess)) { TabCon.Genres.Load(); dGVGenreList.DataSource = TabCon.Genres.Local.ToBindingList(); bDel.Visible = false; } else { MessageBox.Show("Ай-ай"); FormAutorization formAuth = new FormAutorization(); formAuth.Show(); formAuth.Closed += (s, Args) => this.Close(); this.Hide(); } }
public FormMain(Users sess) { this.sess = sess; InitializeComponent(); if (DBFunction.Session(sess)) { db = new TableContext(); fillchbox(); bPicSbros_Click(null, null); dtPicker.Format = DateTimePickerFormat.Custom; dtPicker.CustomFormat = "yyyy"; dtPicker.ShowUpDown = true; switch (sess.Position.Position) { case "Администратор": db.Pictures.Include("Status").Load(); dGVPicturesList.DataSource = db.Pictures.Local.ToBindingList(); dGVPicturesList.Columns[4].DefaultCellStyle.Format = "yyyy"; db.Expositions.Load(); dGVExpositionList.DataSource = db.Expositions.Local.ToBindingList(); CbExposition_Refresh(); cbExposition_SelectionChangeCommitted(null, null); db.Users.Include("Position").Load(); db.Users.Load(); dGVUserList.DataSource = db.Users.Local.ToBindingList(); break; case "Реставратор": db.Pictures.Include("Status").Load(); dGVPicturesList.DataSource = db.Pictures.Local.ToBindingList(); dGVPicturesList.Columns[4].DefaultCellStyle.Format = "yyyy"; tabControl3.TabPages.Remove(tabPageExpToPic); tabControl3.TabPages.Remove(tabPageExp); tabControl3.TabPages.Remove(tabPageUser); bGenre.Visible = false; break; case "Помошник администратора": db.Pictures.Include("Status").Load(); dGVPicturesList.DataSource = db.Pictures.Local.ToBindingList(); dGVPicturesList.Columns[4].DefaultCellStyle.Format = "yyyy"; db.Expositions.Load(); dGVExpositionList.DataSource = db.Expositions.Local.ToBindingList(); CbExposition_Refresh(); cbExposition_SelectionChangeCommitted(null, null); break; case "Директор": db.Pictures.Include("Status").Load(); dGVPicturesList.DataSource = db.Pictures.Local.ToBindingList(); dGVPicturesList.Columns[4].DefaultCellStyle.Format = "yyyy"; tabControl3.TabPages.Remove(tabPageExpToPic); tabControl3.TabPages.Remove(tabPageExp); tabControl3.TabPages.Remove(tabPageUser); bGenre.Visible = false; break; default: Console.WriteLine("Ой-ой"); break; } } else { MessageBox.Show("Ай-ай"); FormAutorization formAuth = new FormAutorization(); formAuth.Show(); formAuth.Closed += (s, Args) => this.Close(); this.Hide(); } }