private void AddBlueprintEntity(BlueprintEntity converted, IEnumerable <WallEntity> itsWalls, IEnumerable <ColumnEntity> itsColumns, ICollection <Opening> itsOpenings, IEnumerable <SignatureEntity> itsSignatures) { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { context.Blueprints.Add(converted); UserEntity owner = converted.Owner; if (context.Users.Any(u => u.UserName.Equals(owner.UserName))) { context.Entry(converted.Owner).State = EntityState.Unchanged; } context.Columns.AddRange(itsColumns); context.Walls.AddRange(itsWalls); context.Signatures.AddRange(itsSignatures); MaterialAndEntityConverter materialTranslator = new MaterialAndEntityConverter(); foreach (Opening op in itsOpenings) { string tempName = op.getTemplateName(); OpeningTemplateEntity itsTemplate = context.OpeningTemplates .FirstOrDefault(t => t.Name.Equals(tempName)); OpeningEntity opRecord = materialTranslator.OpeningToEntity(op, itsTemplate, converted); context.Openings.Add(opRecord); } context.SaveChanges(); } }
private void TryAddPrice(CostPriceEntity toSave) { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { context.CostsAndPrices.Add(toSave); context.SaveChanges(); } }
private void TrySettingPrice(int componentType, float newPrice) { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { CostPriceEntity record = context.CostsAndPrices.FirstOrDefault(cp => cp.ComponentType == componentType); record.Price = newPrice; context.SaveChanges(); } }
private void TryAdd(User aUser) { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { UserAndEntityConverter translator = new UserAndEntityConverter(); UserEntity anEntity = translator.ToEntity(aUser); context.Users.Add(anEntity); context.SaveChanges(); } }
private void TryDeletingBlueprintsOfUser(User aUser) { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { foreach (BlueprintEntity bpEnt in context.Blueprints.Where(bp => bp.Owner.UserName.Equals(aUser.UserName))) { context.Blueprints.Remove(bpEnt); } context.SaveChanges(); } }
private void TryToClear() { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { foreach (CostPriceEntity record in context.CostsAndPrices) { context.CostsAndPrices.Remove(record); } context.SaveChanges(); } }
private void TryClearing() { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { foreach (OpeningTemplateEntity template in context.OpeningTemplates) { context.OpeningTemplates.Remove(template); } context.SaveChanges(); } }
private void TryModify(User modified) { UserAndEntityConverter translator = new UserAndEntityConverter(); using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { UserEntity record = translator.ToEntity(modified); context.Users.Attach(record); context.Entry(record).State = EntityState.Modified; context.SaveChanges(); } }
private void TryDeleting(Template toDelete) { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { OpeningTemplateEntity entity = context.OpeningTemplates.FirstOrDefault(ote => ote.Name.Equals(toDelete.Name)); if (entity != null) { context.OpeningTemplates.Remove(entity); context.SaveChanges(); } } }
private void TryDelete(User toDelete) { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { UserEntity entity = context.Users.FirstOrDefault(r => r.UserName.Equals(toDelete.UserName)); //if it exists, delete it. if (entity != null) { context.Users.Remove(entity); context.SaveChanges(); } } }
private void TryToClear() { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { foreach (SignatureEntity se in context.Signatures) { context.Signatures.Remove(se); } foreach (BlueprintEntity bpe in context.Blueprints) { context.Blueprints.Remove(bpe); } context.SaveChanges(); } }
private void TryModifying(Template entity) { if (!Exists(entity)) { throw new TemplateDoesNotExistException(); } MaterialAndEntityConverter translator = new MaterialAndEntityConverter(); OpeningTemplateEntity record = translator.OpeningTemplateToEntity(entity); using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { context.Entry(record).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
private void TryToDelete(IBlueprint toRemove) { if (Exists(toRemove)) { BlueprintAndEntityConverter translator = new BlueprintAndEntityConverter(); BlueprintEntity converted = translator.BlueprintToEntiy(toRemove); using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { Guid removeId = toRemove.GetId(); BlueprintEntity record = context.Blueprints.FirstOrDefault(be => be.Id == removeId); context.Blueprints.Remove(record); context.SaveChanges(); } } }
private void TryClearUsers() { using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { foreach (UserEntity userEnt in context.Users) { context.Users.Remove(userEnt); } AdminEntity putBackAdmin = new AdminEntity() { Name = "admin", Surname = "admin", UserName = "******", Password = "******" }; context.Users.Add(putBackAdmin); context.SaveChanges(); } }
private void TryAdding(Template entity) { MaterialAndEntityConverter translator = new MaterialAndEntityConverter(); using (BlueBuilderDBContext context = new BlueBuilderDBContext()) { try { OpeningTemplateEntity converted = translator.OpeningTemplateToEntity(entity); context.OpeningTemplates.Add(converted); context.SaveChanges(); } catch (DbUpdateException) { throw new TemplateAlreadyExistsException(); } } }