private void Button_Click_1(object sender, RoutedEventArgs e) { try { db = new TODOEntities(); dataGrid = myDataGrid2; int list_id = (dataGrid.SelectedItem as ITEM_INFO).list_id; string item_name = (dataGrid.SelectedItem as ITEM_INFO).item_name; DateTime creation_date = (myDataGrid2.SelectedItem as ITEM_INFO).creation_date; var deletedItem = db.ITEM_INFO.Where( d => d.list_id == list_id && d.item_name == item_name && d.creation_date == creation_date) .Single(); db.ITEM_INFO.Remove(deletedItem); db.SaveChanges(); isExpired(); dataGrid.ItemsSource = db.ITEM_INFO.Where(a => a.list_id == list_id).ToList(); } catch (Exception) { MessageBox.Show("You have to pick an item to delete"); } }
private void btnChange_Click(object sender, RoutedEventArgs e) { string itemStatus = (sender as Button).Tag.ToString(); if (itemStatus != "Expired") { db = new TODOEntities(); dataGrid = myDataGrid2; int list_id = (dataGrid.SelectedItem as ITEM_INFO).list_id; string item_name = (dataGrid.SelectedItem as ITEM_INFO).item_name; DateTime creation_date = (myDataGrid2.SelectedItem as ITEM_INFO).creation_date; foreach (var item in db.ITEM_INFO) { if (item.item_name == item_name && item.list_id == list_id && item.creation_date == creation_date) { if (item.item_status == "Complete") { item.item_status = "Not Complete"; } else if (item.item_status == "Not Complete") { item.item_status = "Complete"; } } } db.SaveChanges(); dataGrid.ItemsSource = db.ITEM_INFO.Where(a => a.list_id == list_id).ToList(); } else { MessageBox.Show("You can't change status of expired."); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { db = new TODOEntities(); isExpired(); dataGrid = myDataGrid2; dataGrid.ItemsSource = db.ITEM_INFO.Where(a => a.list_id == list_id).ToList(); }
private void Button_Click(object sender, RoutedEventArgs e) { try { db = new TODOEntities(); USER_INFO newUser = new USER_INFO() { mail_adress = txtMail.Text, username = txtNick.Text, full_name = txtName.Text, surname = txtSurname.Text, user_password = txtPass.Text }; db.USER_INFO.Add(newUser); db.SaveChanges(); MessageBox.Show("You've just registrated !"); this.Hide(); } catch (Exception) { MessageBox.Show("The fields can not be blank."); } }
private void Button_Click_3(object sender, RoutedEventArgs e) { string filterName = txtSearch.Text; db = new TODOEntities(); dataGrid = myDataGrid2; dataGrid.ItemsSource = db.ITEM_INFO.Where(a => a.item_name == filterName && a.list_id == list_id).ToList(); }
public static void isExpired() { TODOEntities db; db = new TODOEntities(); foreach (var item in db.ITEM_INFO) { if (item.item_deadline < DateTime.Now) { item.item_status = "Expired"; } } db.SaveChanges(); }
private void Button_Click_2(object sender, RoutedEventArgs e) { string filter = cmbFilter.Text; db = new TODOEntities(); dataGrid = myDataGrid2; if (filter == "Expired" || filter == "Complete" || filter == "Not Completed") { dataGrid.ItemsSource = db.ITEM_INFO.Where(f => f.item_status == filter && f.list_id == list_id).ToList(); } else { dataGrid.ItemsSource = db.ITEM_INFO.Where(a => a.list_id == list_id).ToList(); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { db = new TODOEntities(); ITEM_INFO newItem = new ITEM_INFO() { item_name = txtName.Text, item_desc = txtDesc.Text, item_deadline = datePicker.SelectedDate, creation_date = DateTime.Now, item_status = "Not Completed", list_id = list_id }; db.ITEM_INFO.Add(newItem); try { db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } ItemPage.isExpired(); ItemPage.dataGrid.ItemsSource = db.ITEM_INFO.Where(a => a.list_id == list_id).ToList(); this.Hide(); } catch (System.Data.Entity.Validation.DbEntityValidationException) { MessageBox.Show("Wrong"); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { db = new TODOEntities(); dataGrid = myDataGrid; int list_id = (dataGrid.SelectedItem as LIST_INFO).list_id; var deletedList = db.LIST_INFO.Where(d => d.list_id == list_id).Single(); db.LIST_INFO.Remove(deletedList); foreach (var item in db.ITEM_INFO) { if (item.list_id == list_id) { db.ITEM_INFO.Remove(item); } } db.SaveChanges(); dataGrid.ItemsSource = db.LIST_INFO.Where(a => a.list_owner == myUser).ToList(); }
private void Button_Click(object sender, RoutedEventArgs e) { if (txtList.Text == "") { MessageBox.Show("Name of the list can not be empty."); } else { db = new TODOEntities(); LIST_INFO newList = new LIST_INFO() { list_name = txtList.Text, list_owner = myUser }; db.LIST_INFO.Add(newList); db.SaveChanges(); UserPage.dataGrid.ItemsSource = db.LIST_INFO.Where(a => a.list_owner == myUser).ToList(); this.Hide(); } }
private void btnLogin_Click(object sender, RoutedEventArgs e) { int flag = 0; string myUser = ""; db = new TODOEntities(); foreach (var user in db.USER_INFO) { if (user.username == txtName.Text && user.user_password == txtPass.Text) { flag = 1; myUser = user.username; } } if (flag == 1) { UserPage userPage = new UserPage(myUser); userPage.ShowDialog(); } else { MessageBox.Show("You entered wrong informations"); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { db = new TODOEntities(); dataGrid = myDataGrid; dataGrid.ItemsSource = db.LIST_INFO.Where(a => a.list_owner == myUser).ToList(); }