protected void submit_Click(object sender, EventArgs e)
 {
     Auth auth = new Auth();
     SQLDB db = new SQLDB();
     string netname = Netname.Text.ToUpper();
     string login = Login.Text.ToUpper();
     string password = Password.Text;
     string tab_num = auth.Authentication(netname, login, password);
     if (tab_num != null)
     {
         List<Role> roles = auth.getRoles(tab_num);
         Person pers = new Person(null, login, password, tab_num, auth.getRoles(tab_num));
         Session["User"] = pers;
         if (roles != null)
         {
             db.insertLogon(tab_num, DateTime.Now, Request.UserHostAddress, Request.UserAgent);
             Response.Redirect("TimeTable.aspx?role=" + roles[0].RoleID);
         }
         else MessageBox.Show("Вам не присвоена роль!");
     }
     else MessageBox.Show("Неправильный логин или пароль!");
 }
 protected void Page_Init(object sender, EventArgs e)
 {
     // авторизация Windows
     Auth auth = new Auth();
     SQLDB db = new SQLDB();
     string netname = "";
     string user = User.Identity.Name.ToUpper();
     if (user.Contains("\\"))
         netname = user.Substring(user.IndexOf('\\') + 1, user.Length - user.IndexOf('\\') - 1);
     string tab_num = auth.Authentication(netname, "", "");
     //string tab_num = auth.Authentication(user, "", "");
     if (tab_num != null)
     {
         List<Role> roles = auth.getRoles(tab_num);
         Person pers = new Person(user, null, null, tab_num, roles);
         Session["User"] = pers;
         if (roles != null)
         {
             db.insertLogon(tab_num, DateTime.Now, Request.UserHostAddress, Request.UserAgent);
             Response.Redirect("TimeTable.aspx?role=" + roles[0].RoleID);
         }
         else MessageBox.Show("Вам не присвоена роль! ");
     }
 }