private spare_group CreateItem()
{
DataAccess da = new DataAccess();
spare_group i = new spare_group();
i.name = edtName.Text;
i.description = edtDescr.Text;
i.ParentGroup = da.GetSpareGroups().FirstOrDefault(g => g.name == _parentName);
return da.SpareGroupCreate(i);
}
// ЗАПЧАСТЬ - РЕДАКТИРОВАТЬ - СОХРАНИТЬ
public spare SpareEdit(int SpareID, string Name, string Code, string CodeShatem, int QDemand, int GroupID, int BrandID, int UnitID, string Description)
{
DataAccess da = new DataAccess();
spare sp = da.GetSpare(SpareID);
sp.name = Name;
sp.code = Code;
sp.codeShatem = CodeShatem;
sp.q_demand = QDemand;
sp.q_demand_clear = QDemand;
sp.q_rest = 0;
sp.description = Description;
if (sp.brand == null)
sp.brandReference.Load();
if (sp.spare_group == null)
sp.spare_groupReference.Load();
string OldBrandName = sp.BrandName;
int OldBrandID = sp.brand.id;
int OldGroupID = sp.spare_group.id;
spare s = da.SpareEdit(sp, BrandID, GroupID, UnitID);
SpareContainer.Instance.Update(s.id);
if (OldBrandID != BrandID || OldGroupID != GroupID)
{
if (SpareContainer.Instance.Spares.Where(i => i.BrandID == OldBrandID && i.GroupID == OldGroupID).Count() == 0)
{
da.SpareGroupDelete(OldBrandID, OldGroupID);
mainWindowObj.LoadGroups(false);
}
if (SpareContainer.Instance.Spares.Where(i => i.BrandID == BrandID && i.GroupID == GroupID).Count() == 1)
{
da.SpareGroupCreate(GroupID, BrandID);
mainWindowObj.LoadGroups(false);
}
}
return s;
}
public SpareView SpareCreateSilent(string Name, string CodeShatem, string GroupName, string ParentGroupName, string BrandName, string UnitName, string Description)
{
DataAccess da = new DataAccess();
spare s = da.SpareCreateSilent(Name, CodeShatem, GroupName, ParentGroupName, BrandName, UnitName, Description);
SpareView SpareViewItem = da.GetSpareView(s.id);
SpareContainer.Instance.Update(s.id);
int BrandID = SpareViewItem.BrandID;
int GroupID = SpareViewItem.GroupID;
if (SpareContainer.Instance.Spares.Where(i => i.BrandID == BrandID && i.GroupID == GroupID).Count() == 1)
{
if (s.brand == null)
s.brandReference.Load();
da.SpareGroupCreate(GroupID, s.brand.name);
}
return SpareViewItem;
}
// ЗАПЧАСТЬ - ДОБАВИТЬ - СОХРАНИТЬ
public spare SpareCreate(string Name, string Code, string CodeShatem, int QDemand, int GroupID, int BrandID, string UnitName, string Description)
{
DataAccess da = new DataAccess();
spare sp = new spare();
sp.name = Name;
sp.code = Code;
sp.codeShatem = CodeShatem;
sp.q_demand = QDemand;
sp.q_demand_clear = QDemand;
sp.q_rest = 0;
sp.description = Description;
spare s = da.SpareCreate(sp, BrandID, GroupID, UnitName);
SpareContainer.Instance.Update(s.id);
if (SpareContainer.Instance.Spares.Where(
i => i.BrandID == BrandID && i.GroupID == GroupID).Count() == 1)
{
da.SpareGroupCreate(GroupID, BrandID);
}
return s;
}
public static List<spare_group> getGroups(string FilePath)
{
List<spare_group> items = new List<spare_group>();
// Объявляем и забиваем файл в документ
XmlDocument xd = new XmlDocument();
FileStream fs = new FileStream(FilePath, FileMode.Open);
xd.Load(fs);
XmlNodeList list = xd.GetElementsByTagName("Row"); // Создаем и заполняем лист по тегу "row"
for (int i = 0; i < list.Count; i++)
{
spare_group b = new spare_group();
b.code1C = list[i].FirstChild.InnerText;
b.name = list[i].LastChild.InnerText;
items.Add(b);
}
MessageBox.Show("Сформирован список из " + items.Count.ToString() + " элементов.");
DataAccess da = new DataAccess();
int xc = 0;
foreach (spare_group i in items)
{
da.SpareGroupCreate(i);
xc++;
}
MessageBox.Show("Добавлено " + xc.ToString() + " элементов.");
FixGroupsParents(list);
// Закрываем поток
fs.Close();
return items;
}
private void BackgroundEdit_DoWork(object sender, DoWorkEventArgs e)
{
int SpareID = _spare.id;
DataAccess da = new DataAccess();
spare sp = da.GetSpare(SpareID);
sp.name = SpareUpdateName;
sp.code = SpareUpdateCode;
sp.codeShatem = SpareUpdateCodeShatem;
sp.q_demand = SpareUpdateQDemand;
sp.q_demand_clear = SpareUpdateQDemand;
sp.q_rest = 0;
sp.description = SpareUpdateDescription;
if (sp.brand == null)
sp.brandReference.Load();
if (sp.spare_group == null)
sp.spare_groupReference.Load();
string OldBrandName = sp.BrandName;
int OldBrandID = sp.brand.id;
int OldGroupID = sp.spare_group.id;
spare s = da.SpareEdit(sp, SpareUpdateBrandID, SpareUpdateGroupID, SpareUpdateUnitID);
SpareContainer.Instance.Update(s.id);
if (OldBrandID != SpareUpdateBrandID || OldGroupID != SpareUpdateGroupID)
{
if (SpareContainer.Instance.Spares.Where(i => i.BrandID == OldBrandID && i.GroupID == OldGroupID).Count() == 0)
{
da.SpareGroupDelete(OldBrandID, OldGroupID);
ReloadGroups = true;
}
if (SpareContainer.Instance.Spares.Where(i => i.BrandID == SpareUpdateBrandID && i.GroupID == SpareUpdateGroupID).Count() == 1)
{
da.SpareGroupCreate(SpareUpdateGroupID, SpareUpdateBrandID);
ReloadGroups = true;
}
}
}
private void BackgroundCreate_DoWork(object sender, DoWorkEventArgs e)
{
DataAccess da = new DataAccess();
spare sp = new spare();
sp.name = SpareUpdateName;
sp.code = SpareUpdateCode;
sp.codeShatem = SpareUpdateCodeShatem;
sp.q_demand = SpareUpdateQDemand;
sp.q_demand_clear = SpareUpdateQDemand;
sp.q_rest = 0;
sp.description = SpareUpdateDescription;
spare s = da.SpareCreate(sp, SpareUpdateBrandID, SpareUpdateGroupID, SpareUpdateUnitID);
SpareContainer.Instance.Update(s.id);
if (SpareContainer.Instance.Spares.Where(i => i.BrandID == SpareUpdateBrandID && i.GroupID == SpareUpdateGroupID).Count() == 1)
{
if (s.brand == null)
s.brandReference.Load();
da.SpareGroupCreate(SpareUpdateGroupID, s.brand.name);
ReloadGroups = true;
}
}
