Пример #1
0
        public static string CreateAllPCB(string name, string type,
                                          PowerSupply namePowerSupply, List <ElectronicComponent> electronicComponents,
                                          string pathToSchema)
        {
            var res = "уже существует";

            using (ApplicationContext db = new ApplicationContext())
            {
                //сужествует ли плата
                var checkIsExist = db.PCBs.Any(pcb => pcb.Name == name);

                if (!checkIsExist)
                {
                    PCB newPcb = new PCB
                    {
                        Name = name,
                        Type = type,

                        NamePowerSupplyId = namePowerSupply.Id,
                        //NamePowerSupply = namePowerSupply,

                        //ElectronicComponents = electronicComponents,

                        PathToSchema = pathToSchema
                    };
                    db.PCBs.Add(newPcb);
                    db.SaveChanges();
                    res = $"Плата {newPcb.Name} добавлена";
                }

                return(res);
            }
        }
Пример #2
0
        //создат отдел == PowerSupply
        //public static List<PowerSupply> GetAllPowerSupply()
        //{
        //    return null;
        //}

        //создать позицию == Deadlines //ElectronicComponents
        //public static List<ElectronicComponent> GetAllElectronicComponent()
        //{
        //    return null;
        //}

        //созщдать сутрудника == PCB
        //public static List<PCB> GetAllPCB()
        //{
        //    return null;
        //}

        //удаление отдела == удаление TypeDevice
        //удаление позиции == Deadlines //сроки выполннения
        //удаление сотурдинка == PowerSupply

        #endregion

        #region CreateEntitys


        public static string CreateAllPowerSupply(string name, int power,
                                                  int voltage, List <ElectronicComponent> electronicComponents,
                                                  List <PCB> pCBs, string pathToSchema)
        {
            var res = "уже суещствет";

            using (ApplicationContext db = new ApplicationContext())
            {
                //сужествует ли блок питания
                var checkIsExit = db.PowerSupplies.Any(ps => ps.Name
                                                       == name);
                if (!checkIsExit)
                {
                    PowerSupply newPowerSupply = new PowerSupply
                    {
                        Name    = name,
                        Power   = power,
                        Voltage = voltage,

                        //ElectronicComponents = electronicComponents,

                        //PCBs = pCBs,

                        PathToSchema = pathToSchema
                    };
                    db.PowerSupplies.Add(newPowerSupply);
                    db.SaveChanges();
                    res = $"БП {newPowerSupply.Name} добавлен";
                }

                return(res);
            }
        }
Пример #3
0
        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);
            }
        }
Пример #4
0
        //удалить блок питания
        public static string DeletePowerSupply(PowerSupply powerSupply)
        {
            var res = "такого БП не существует";

            using (ApplicationContext db = new ApplicationContext())
            {
                db.PowerSupplies.Remove(powerSupply);
                db.SaveChanges();
                res = $"БП {powerSupply.Name} удален";
            };

            return(res);
        }
Пример #5
0
        //редактровать блок питания
        public static string EditPowerSupply(PowerSupply oldPowerSupply, string newName,
                                             int NewVoltage, int newPower, string newPathToSchema)
        {
            var res = "такого БП не существует";

            using (ApplicationContext db = new ApplicationContext())
            {
                PowerSupply powerSupply = db.PowerSupplies.FirstOrDefault(ps =>
                                                                          ps.Id == oldPowerSupply.Id);

                if (powerSupply != null)
                {
                    powerSupply.Name         = newName;
                    powerSupply.Voltage      = NewVoltage;
                    powerSupply.Power        = newPower;
                    powerSupply.PathToSchema = newPathToSchema;

                    db.SaveChanges();
                    res = $"БП {oldPowerSupply.Name} изменен";
                }
            };

            return(res);
        }