public DataAccess() { objDataContext = new DriveEntities(); objDataContext.ContextOptions.LazyLoadingEnabled = true; root = objDataContext.spare_group.FirstOrDefault(i => i.id == 1); u = objDataContext.units.FirstOrDefault(i => i.id == 1); }
private unit getItem() { unit item = new unit(); item.id = this._id; item.name = edtName.Text; item.description = edtDescr.Text; return item; }
/// <summary> /// Create a new unit object. /// </summary> /// <param name="id">Initial value of the id property.</param> /// <param name="name">Initial value of the name property.</param> public static unit Createunit(global::System.Int32 id, global::System.String name) { unit unit = new unit(); unit.id = id; unit.name = name; return unit; }
/// <summary> /// Deprecated Method for adding a new object to the units EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTounits(unit unit) { base.AddObject("units", unit); }
public void UnitEdit(unit item) { unit original = objDataContext.units.FirstOrDefault(b => b.id == item.id); if (original != null) { original.name = item.name; original.description = item.description; //if (original.created_on == null) // original.created_on = DateTime.Now; objDataContext.SaveChanges(); } }
public void UnitCreate(unit _obj) { //_obj.created_on = DateTime.Now; objDataContext.AddTounits(_obj); objDataContext.SaveChanges(); }
public spare SpareCreateSilent(string Name, string CodeShatem, string GroupName, string ParentGroupName, string BrandName, string UnitName, string Description) { // получим группу //spare_group ParentGroup = objDataContext.spare_group.FirstOrDefault(i => i.id == 1).spare_group1.FirstOrDefault(x => x.name.ToUpper() == ParentGroupName.ToUpper()); List<spare_group> groups = objDataContext.spare_group.Where(i => i.ParentGroup.id == 1).ToList(); // все группы, дочерние группе #1 groups = groups.Where(i => i.name.ToUpper().Equals(ParentGroupName.ToUpper())).ToList(); spare_group ParentGroup = null; if (groups.Count > 0) ParentGroup = groups[0]; if (ParentGroup == null) { // создать новую группу spare_group sgNew = new spare_group(); sgNew.name = ParentGroupName; spare_group root = objDataContext.spare_group.FirstOrDefault(x => x.id == 1); sgNew.ParentGroup = root; sgNew.IsBrand = false; sgNew.ChildCount = 0; sgNew.code1C = ""; sgNew.description = ""; sgNew.ParentGroupName = root.name; objDataContext.AddTospare_group(sgNew); objDataContext.SaveChanges(); ParentGroup = sgNew; } // получим подгруппу //spare_group group = objDataContext.spare_group.FirstOrDefault(i => i.id == ParentGroup.id).spare_group1.FirstOrDefault(x => x.name.ToUpper() == GroupName.ToUpper()); groups = objDataContext.spare_group.Where(i => i.ParentGroup.id == ParentGroup.id).ToList(); groups = groups.Where(i => i.name.ToUpper().Equals(GroupName.ToUpper())).ToList(); spare_group group = null; if (groups.Count > 0) group = groups[0]; if (group == null) { // создать новую группу spare_group sgNew = new spare_group(); sgNew.name = GroupName; spare_group parent = objDataContext.spare_group.FirstOrDefault(x => x.id == ParentGroup.id); sgNew.ParentGroup = parent; sgNew.IsBrand = false; sgNew.ChildCount = 0; sgNew.code1C = ""; sgNew.description = ""; sgNew.ParentGroupName = parent.name; parent.ChildCount++; objDataContext.AddTospare_group(sgNew); objDataContext.SaveChanges(); group = sgNew; } // получим брэнд brand b = objDataContext.brands.FirstOrDefault(i => i.name == BrandName); if (b == null) { brand bNew = new brand(); bNew.name = BrandName; objDataContext.AddTobrands(bNew); objDataContext.SaveChanges(); b = bNew; } // получим unit unit u = objDataContext.units.FirstOrDefault(x => x.name == UnitName); if (u == null) { unit bNew = new unit(); bNew.name = UnitName; objDataContext.AddTounits(bNew); objDataContext.SaveChanges(); u = bNew; } spare sp = new spare(); sp.name = Name; sp.code = ""; sp.codeShatem = CodeShatem; sp.q_demand = 0; sp.q_demand_clear = 0; sp.q_rest = 0; sp.description = Description; sp.spare_group1 = ParentGroup; sp.spare_group = group; int GroupID = group.id; sp.brand = b; sp.unit = u; // [spare_group2_id] if (sp.spare_group1.ParentGroup != null) { spare_group group2 = objDataContext.spare_group.FirstOrDefault(x => x.id == sp.spare_group1.ParentGroup.id); if (group2 != null) { sp.spare_group2 = group2; // [spare_group3_id] if (group2.ParentGroup != null) { spare_group group3 = objDataContext.spare_group.FirstOrDefault(x => x.id == group2.ParentGroup.id); if (group3 != null) sp.spare_group3 = group3; } } } // [BrandName] sp.BrandName = sp.brand.name; // [GroupName] sp.GroupName = sp.spare_group.name; // [ParentGroupName] sp.ParentGroupName = sp.spare_group1.name; objDataContext.AddTospares(sp); objDataContext.SaveChanges(); //spare s = SpareCreate(sp, sp.brand.id, sp.spare_group.id, b.id); return sp; }