private void gridUsers_AddingNewDataItem(object sender, GridViewAddingNewEventArgs e) { var user = new t_Users(); user.userid = uid; user.username = uname; user.userpass = upass; user.usertype = utype; e.NewObject = user; db.t_Users.Add(user); }
private void gridUsers_PreviewKeyDown(object sender, KeyEventArgs e) { try { if (e.Key == Key.Delete) { string sMessageBoxText = "Do you want to continue?"; string sCaption = "Delete User"; MessageBoxButton btnMessageBox = MessageBoxButton.YesNo; MessageBoxImage icnMessageBox = MessageBoxImage.Warning; MessageBoxResult rsltMessageBox = MessageBox.Show(sMessageBoxText, sCaption, btnMessageBox, icnMessageBox); switch (rsltMessageBox) { case MessageBoxResult.Yes: foreach (var data in gridUsers.SelectedItems) { t_Users myData = data as t_Users; var deleteuser = db.t_Users.Where(u => u.userid == myData.userid).FirstOrDefault(); db.t_Users.Remove(deleteuser); db.SaveChanges(); } break; case MessageBoxResult.No: /* ... */ break; } } else { return; } } catch { } }
private void gridUsers_RowEditEnded(object sender, GridViewRowEditEndedEventArgs e) { if (e.EditAction == GridViewEditAction.Cancel) { return; } if (e.EditOperationType == GridViewEditOperationType.Insert) { try { db.SaveChanges(); binddatagrid(); } catch { MessageBox.Show("already exist"); } } else if (e.EditOperationType == GridViewEditOperationType.Edit) { try { foreach (var data in gridUsers.SelectedItems) { t_Users myData = data as t_Users; uid = myData.userid; uname = myData.username; upass = myData.userpass; utype = myData.usertype; t_Users us = db.t_Users.First(p => p.userid == uid); us.username = uname; us.userpass = upass; us.usertype = utype; db.SaveChanges(); binddatagrid(); } } catch { } } }
void login() { try { t_Users newuser = new t_Users(); var user = db.t_Users.Where(i => i.username == this.username.Text && i.userpass == this.userpass.Password).FirstOrDefault(); if (user == null) { MessageBox.Show("Unable to Login, incorrect credentials."); } else { MainForm UserMain = new MainForm(); UserMain.adminusers.Text = username.Text; UserMain.Show(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }