public static void InsertToDb(SubGroupProduct subgroup)
{
if (SyncData.IsConnect)
{
using (var connection = ConnectionFactory.CreateConnection())
connection.Execute(InsertQuery, subgroup);
}
}
public static void DeleteFromDb(SubGroupProduct subgroup)
{
if (SyncData.IsConnect)
{
const string query = "DELETE FROM SubGrpNameSet WHERE Id = @Id";
using (var connection = ConnectionFactory.CreateConnection())
connection.Execute(query, new { subgroup.Id });
}
}
public static void DeleteSubgroup(SubGroupProduct subgroup)
{
var current = subgroup.Group.SubGroups.First(s => s.Id == subgroup.Id);
subgroup.Group.SubGroups.Remove(current);
var document = XDocument.Load(Path);
var groupElement = document.GetXElements("Palettes", "Palette").First(p => p.GetXAttributeValue("Group", "ID").ToInt() == subgroup.Group.Id);
groupElement.GetXElements("SubGroup").First(s => s.GetXAttributeValue("ID").ToInt() == subgroup.Id).Remove();
document.Save(Path);
RepositorySubGroupProduct.SubGroupProducts.Remove(subgroup);
RepositorySubGroupProduct.DeleteFromDb(subgroup);
}
public static void AddSubgroup(SubGroupProduct subgroup)
{
subgroup.Group.SubGroups.Add(subgroup);
if (!File.Exists(Path))
{
SaveFile();
}
var document = XDocument.Load(Path);
var element = document.GetXElements("Palettes", "Palette").First(p => p.GetXAttributeValue("Group", "ID").ToInt() == subgroup.Group.Id);
GroupProduct.ToXElementSubGroups(element, subgroup.Group);
File.WriteAllText(Path, document.ToString());
RepositorySubGroupProduct.SubGroupProducts.Add(subgroup);
RepositorySubGroupProduct.InsertToDb(subgroup);
}
private void BtnAdd2Click(object sender, RoutedEventArgs e)
{
var selectedGroup = DataGridGroups.SelectedItem as GroupProduct;
if (selectedGroup != null)
{
var window = new TextWindow();
if (window.ShowDialog() == true)
{
var subgroup = new SubGroupProduct(RepositorySubGroupProduct.SubGroupProducts.Count + 1, window.NameText, selectedGroup.Id)
{
Group = selectedGroup
};
RepositoryGroupProduct.AddSubgroup(subgroup);
DataGridSubgroups.ItemsSource = null;
DataGridSubgroups.ItemsSource = selectedGroup.SubGroups;
}
}
}
