private void LoadGrid()
        {
            databaseEntities  db        = new databaseEntities();
            List <attendance> tableData = db.attendances.ToList();

            dataGrid.ItemsSource = tableData;
        }
        private void SaveToDatabase(string name, DateTime now)
        {
            databaseEntities db = new databaseEntities();
            attendance       at = new attendance();

            at.studentid = Convert.ToInt32(name);
            db.attendances.Add(at);
            at.dateandtime = now;
            db.attendances.Add(at);
            db.SaveChanges();
        }
Пример #3
0
 private void BtnLogin_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         databaseEntities db = new databaseEntities();
         if (TBx_User.Text != string.Empty || PBx_Password.Password != string.Empty)
         {
             int username = Convert.ToInt32(TBx_User.Text);
             var user     = db.logins.FirstOrDefault(a => a.Id.Equals(username));
             if (user != null)
             {
                 if (user.pass.Equals(PBx_Password.Password))
                 {
                     MainWindow mainWindow = new MainWindow();
                     mainWindow.Show();
                     this.Hide();
                 }
                 else
                 {
                     LBl_Login_Message.Content = "Login id or password is incorrect";
                 }
             }
             else
             {
                 LBl_Login_Message.Content = "Login id or password is incorrect";
             }
         }
         else
         {
             LBl_Login_Message.Content = "Enter login id and password";
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }