//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();
}
}
