public static string CreateAllElectronicComponents(string name, string type, int pcbId, PCB pcb, int namePowerSupplyId, PowerSupply namePowerSupply, string positionNumber, string datasheetLink) { var res = "уже существует"; using (ApplicationContext db = new ApplicationContext()) { //сущесствует ли электронный компонент var checkIsExist = db.ElectronicComponents.Any(ec => ec.Name == name); if (!checkIsExist) { ElectronicComponent newEC = new ElectronicComponent { Name = name, Type = type, PCBId = pcb.Id, //PCB = pcb, NamePowerSupplyId = namePowerSupply.Id, //NamePowerSupply = namePowerSupply, PositionNumber = positionNumber, DatasheetLink = datasheetLink }; db.ElectronicComponents.Add(newEC); db.SaveChanges(); res = $"Элементат {newEC.Name} добавлен"; } return(res); } }
//удалить эл компонент public static string DeleteElectronicComponent(ElectronicComponent electronicComponent) { var res = "такого элемента не сущетвует"; using (ApplicationContext db = new ApplicationContext()) { db.ElectronicComponents.Remove(electronicComponent); db.SaveChanges(); res = $"Элемент {electronicComponent.Name} удален"; } return(res); }
//реадктировать эл компонент public static string EditElectronicComponent(ElectronicComponent oldElectronicComponent, string newName, string newType, string newPositionNumber, string newDatasheetLink) { var res = "такого элемента не сущетвует"; using (ApplicationContext db = new ApplicationContext()) { ElectronicComponent electronicComponent = db.ElectronicComponents. FirstOrDefault(ec => ec.Id == oldElectronicComponent.Id); if (electronicComponent != null) { electronicComponent.Name = newName; electronicComponent.Type = newType; electronicComponent.PositionNumber = newPositionNumber; electronicComponent.DatasheetLink = newDatasheetLink; db.SaveChanges(); res = $"Элемент {oldElectronicComponent.Name} изменен"; } } return(res); }