private void Worker_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e) { string[] arg = (string[])e.Argument; using (AvnConnect.Data.ConnectContainer conn = new Data.ConnectContainer()) { string email = arg[0]; string password = arg[1]; var Staff = conn.Staffs.Where(st => st.EmailAddress == email && st.Password == password).FirstOrDefault(); if (Staff != null) { e.Result = Staff; } } }
private void UpdateCategoryToDb() { try { MainWindow M = (MainWindow)App.Current.MainWindow; using (Data.ConnectContainer conn = new Data.ConnectContainer()) { var cate = conn.Categories.Where(c => c.Key == EditingCategory.Key).FirstOrDefault(); var Parent = ((ComboBoxItem)this.NestCombobox.SelectedItem).Tag as Category; bool changed = false; if (cate != null) { changed = changed || (cate.Name != NameTextbox.Text); changed = changed || (cate.ParentKey != Parent.Key); changed = changed || (cate.Color != this.colorPicker.CurrentSelectedColor.Color.ToString()); } if (changed) { cate.Name = NameTextbox.Text; cate.Color = this.colorPicker.CurrentSelectedColor.Color.ToString(); cate.ParentKey = Parent.Key; cate.ModifiedBy = M.StaffKey; cate.ModifiedOn = ExtendedFunctions.GetNetworkTime(); cate.Level = Parent.Level + 1; } int i = conn.SaveChanges(); if (i > 0) { this.Confirmed?.Invoke(this, EventArgs.Empty); } else { this.Failed?.Invoke(this, EventArgs.Empty); } }; } catch (Exception ex) { Console.WriteLine(ex.Message); throw; } }
private void AddNewCategoryToDb() { try { MainWindow M = (MainWindow)App.Current.MainWindow; using (Data.ConnectContainer conn = new Data.ConnectContainer()) { var cate = new Data.Category() { Name = NameTextbox.Text, ModifiedBy = M.StaffKey, ModifiedOn = ExtendedFunctions.GetNetworkTime(), AddedBy = M.StaffKey, AddedOn = ExtendedFunctions.GetNetworkTime(), Color = this.colorPicker.CurrentSelectedColor.Color.ToString(), IsDeleted = false, Key = Encryption.GetUniqueKey(16) }; var Parent = ((ComboBoxItem)this.NestCombobox.SelectedItem).Tag as Category; cate.ParentKey = Parent.Key; cate.Level = Parent.Level + 1; conn.Categories.Add(cate); int i = conn.SaveChanges(); if (i > 0) { this.Confirmed?.Invoke(this, EventArgs.Empty); } else { this.Failed?.Invoke(this, EventArgs.Empty); } }; } catch (Exception ex) { Console.WriteLine(ex.Message); } }
private void tryDeleteCategory(string Key) { using (Data.ConnectContainer Conn = new Data.ConnectContainer()) { try { var categoryToDelete = Conn.Categories.Where(c => c.Key == Key).FirstOrDefault(); string name = categoryToDelete.Name; if (categoryToDelete != null) { Conn.Categories.Remove(categoryToDelete); var i = Conn.SaveChanges(); if (i >= 1) { this.Notify("CATEGORY:\"" + name.ToUpper() + "\" DELETED"); this.NeedToReloadTree?.Invoke(this, EventArgs.Empty); } else { this.Notify("ERROR:\"" + name.ToUpper() + "\" NOT DELETED"); } } else { this.Notify("0 CATEGORY DELETED"); } } catch (Exception ex) { Console.WriteLine(ex.Message); this.Notify("ERROR:\"" + ex.Message + "\""); } finally { Conn.Dispose(); } } }