private void AddTagButton_Clicked(object sender, RoutedEventArgs e)
{
if (this.TagsDbset == null)
{
this.TagsDbset = Conn.Set <Tags>();
}
if (this.ListOfTags == null)
{
this.ListOfTags = new List <Tags>();
}
//Detect if this tag is currently added to the project
bool TagExist = this.ListOfTags.Where(lt => lt.TagName.ToLower() == this.NewTagTextBox.Text.ToLower().Trim()).FirstOrDefault() != null;
if (TagExist)
{
this.AddTagPopupButton.IsPopupOpen = false;
this.MySnackbar.MessageQueue.Enqueue("This tag is already added to project".ToUpper());
return;
}
//Create the new tag
var newTag = this.TagsDbset.Create();
newTag.TagName = this.NewTagTextBox.Text;
newTag.TagKey = Encryption.GetUniqueKey(16);
newTag.Color = this.TagColorPicker.CurrentSelectedColor.Color.ToString();
newTag.AddedBy = ((MainWindow)App.Current.MainWindow).StaffKey;
newTag.AddOn = ExtendedFunctions.GetNetworkTime();
MyTagChips tc = new MyTagChips(newTag);
tc.Margin = new Thickness(3);
tc.Deleting += Tc_Deleting;
//Add to collections
this.TagWrapPanel.Children.Add(tc);
this.ListOfTags.Add(newTag);
this.TagsDbset.Add(newTag);
//Close the popup
this.AddTagPopupButton.IsPopupOpen = false;
}
/// <summary>
/// Load categories to treeview
/// </summary>
internal void LoadTreeView()
{
//Clear all items
this.ProjectCategoryTree.Items.Clear();
//Create the basic categories
CreateBasicCategory();
using (Data.ConnectContainer Conn = new ConnectContainer())
{
//Create new dbset (short live)
var CategoryDbset = Conn.Set <Data.Category>();
CategoryDbset.Load();
//The root item
this.ProjectCategories = new CategoryItem();
this.ProjectCategories.Category = CategoryDbset.Local.Where(cate => cate.ParentKey == "").FirstOrDefault();
this.FindChild(this.ProjectCategories, CategoryDbset.Local);
//Attach to the tree
this.ProjectCategoryTree.Items.Add(this.ProjectCategories);
this.ProjectCategoryTree.ItemContainerGenerator.StatusChanged += ItemContainerGenerator_StatusChanged;
}
}
/// <summary>
/// Create a dataset from database and bind to datagrid view
/// </summary>
private void BindingDatabase()
{
//Lấy tham chiếu đến Database Entity Model
if (this.Conn == null)
{
this.Conn = new Data.ConnectContainer();
}
//Personal information
if (this.PersonalDataset == null)
{
this.PersonalDataset = Conn.Set(typeof(Data.Staff));
if (this.IsEditing)
{
var Personal = Conn.Staffs.Where(stf => stf.Key == this.StaffKey);
foreach (var item in Personal)
{
PersonalDataset.Attach(item);
}
}
if (this.PersonalDataset.Local.Count == 0)
{
var newPs = this.PersonalDataset.Create();
Staff C = (Staff)newPs;
C.Key = this.StaffKey;
this.PersonalDataset.Local.Add(newPs);
}
this.PersonalDatagrid.ItemsSource = PersonalDataset.Local;
}
//Chức vụ
if (this.JobTitleDataSet == null)
{
this.JobTitleDataSet = Conn.Set(typeof(Data.JobTitles));
JobTitleDataSet.Load();
this.JobTitleDbset = JobTitleDataSet.Local;
}
//Phòng ban
if (this.DepartmentDataSet == null)
{
this.DepartmentDataSet = Conn.Set(typeof(Data.Department));
DepartmentDataSet.Load();
this.DepartmentDbset = DepartmentDataSet.Local;
}
//Học vấn
if (this.EducationDbset == null)
{
var Edus = Conn.Educations.Where(edu => edu.StaffKey == this.StaffKey);
this.EducationDbset = Conn.Set(typeof(Data.Education));
foreach (var item in Edus)
{
EducationDbset.Attach(item);
}
this.EducationGrid.ItemsSource = EducationDbset.Local;
}
//Ngoại ngữ
if (this.LanguageDbset == null)
{
var Language = Conn.ForeignLanguages.Where(lg => lg.StaffKey == this.StaffKey);
this.LanguageDbset = Conn.Set(typeof(Data.ForeignLanguage));
foreach (var item in Language)
{
LanguageDbset.Attach(item);
}
this.ForeignLanguageDatagrid.ItemsSource = this.LanguageDbset.Local;
}
//Lĩnh vực chuyên môn
if (this.ProfessionalDbset == null)
{
this.ProfessionalDbset = Conn.Set(typeof(Data.ProfesstionalArea));
ProfessionalDbset.Load();
}
//Giấy phép hành nghề
if (this.LicenseDbset == null)
{
var Licenses = Conn.PracticingLicenses.Where(lc => lc.StaffKey == this.StaffKey);
this.LicenseDbset = Conn.Set(typeof(Data.PracticingLicense));
foreach (var item in Licenses)
{
LicenseDbset.Attach(item);
}
this.PracticingDatagrid.ItemsSource = this.LicenseDbset.Local;
}
//Kinh nghiệm làm việc
if (this.ExpDbset == null)
{
var Exps = Conn.WorkingExperiences.Where(exp => exp.StaffKey == this.StaffKey);
this.ExpDbset = Conn.Set(typeof(Data.WorkingExperience));
foreach (var item in Exps)
{
ExpDbset.Attach(item);
}
this.ExperienceGrid.ItemsSource = this.ExpDbset.Local;
}
//Phan quyen
if (this.PermissionDbset == null)
{
var Permission = Conn.Permissions.Where(pm => pm.StaffKey == this.StaffKey);
this.PermissionDbset = Conn.Set(typeof(Data.Permission));
foreach (var item in Permission)
{
PermissionDbset.Attach(item);
}
this.PermissionGrid.ItemsSource = PermissionDbset.Local;
if (PermissionDbset.Local.Count == 0)
{
Data.Permission myPermission = (Data.Permission)PermissionDbset.Create();
myPermission.StaffKey = this.StaffKey;
myPermission.Key = Encryption.GetUniqueKey(16);
this.PermissionDbset.Local.Add(myPermission);
}
}
}
