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();
}
}
}
