Пример #1
0
 public static void AddOwner(Owner ownerToAdd)
 {
     using (STOContext db = new STOContext())
     {
         db.Owners.Add(ownerToAdd);
         db.SaveChanges();
     }
 }
Пример #2
0
 public static void AddWorker(Worker workerToAdd)
 {
     using (STOContext db = new STOContext())
     {
         db.Workers.Add(workerToAdd);
         db.SaveChanges();
     }
 }
Пример #3
0
 public static void AddCar(Car car)
 {
     using (STOContext db = new STOContext())
     {
         db.Cars.Add(car);
         db.SaveChanges();
     }
 }
Пример #4
0
        public static List <Owner> FindOwners(int ownerID, int driverLicense,
                                              string fioOwner, string adress, int phone)
        {
            List <Owner> owners = new List <Owner>();

            using (STOContext db = new STOContext())
            {
                if (ownerID != 0)
                {
                    owners = db.Owners.Where(k => k.OwnerID == ownerID).ToList();
                }
                if (driverLicense != 0)
                {
                    if (owners.Count != 0)
                    {
                        owners = owners.Where(k => k.DriverLicense == driverLicense).ToList();
                    }
                    else
                    {
                        owners = db.Owners.Where(k => k.DriverLicense == driverLicense).ToList();
                    }
                }
                if (fioOwner != null)
                {
                    if (owners.Count != 0)
                    {
                        owners = owners.Where(k => k.FioOwner == fioOwner).ToList();
                    }
                    else
                    {
                        owners = db.Owners.Where(k => k.FioOwner == fioOwner).ToList();
                    }
                }
                if (adress != null)
                {
                    if (owners.Count != 0)
                    {
                        owners = owners.Where(k => k.Adress == adress).ToList();
                    }
                    else
                    {
                        owners = db.Owners.Where(k => k.Adress == adress).ToList();
                    }
                }
                if (phone != 0)
                {
                    if (owners.Count != 0)
                    {
                        owners = owners.Where(k => k.Phone == phone).ToList();
                    }
                    else
                    {
                        owners = db.Owners.Where(k => k.Phone == phone).ToList();
                    }
                }
            }
            return(owners);
        }
Пример #5
0
        public static Worker FindWorkerById(int id)
        {
            Worker worker = null;

            using (STOContext db = new STOContext())
            {
                worker = db.Workers.Where(k => k.WorkerID == id).ToList().FirstOrDefault();
            }
            return(worker);
        }
Пример #6
0
        public static Car FindCarById(int id)
        {
            Car car = null;

            using (STOContext db = new STOContext())
            {
                car = db.Cars.Where(k => k.CarID == id).ToList().FirstOrDefault();
            }
            return(car);
        }
Пример #7
0
        public static Owner FindOwnerById(int id)
        {
            Owner owner = null;

            using (STOContext db = new STOContext())
            {
                owner = db.Owners.Where(k => k.OwnerID == id).ToList().FirstOrDefault();
            }
            return(owner);
        }
Пример #8
0
 public static void DeleteOwner(Owner ownerToDelete)
 {
     using (STOContext db = new STOContext())
     {
         if (ownerToDelete != null)
         {
             db.Owners.Remove(ownerToDelete);
             db.SaveChanges();
         }
     }
 }
Пример #9
0
 public static void UpdataOwner(Owner owner)
 {
     using (STOContext db = new STOContext())
     {
         if (owner != null)
         {
             db.Owners.Update(owner);
             db.SaveChanges();
         }
     }
 }
Пример #10
0
 public static void DeleteWorker(Worker workerToDelete)
 {
     using (STOContext db = new STOContext())
     {
         if (workerToDelete != null)
         {
             db.Workers.Remove(workerToDelete);
             db.SaveChanges();
         }
     }
 }
Пример #11
0
        public static List <Owner> GetAll()
        {
            List <Owner> all = new List <Owner>();

            using (STOContext db = new STOContext())
            {
                all = db.Owners.ToList();
            }

            return(all);
        }
Пример #12
0
 public static void UpdataWorker(Worker worker)
 {
     using (STOContext db = new STOContext())
     {
         if (worker != null)
         {
             db.Workers.Update(worker);
             db.SaveChanges();
         }
     }
 }
Пример #13
0
 public static void UpdataCar(Car car)
 {
     using (STOContext db = new STOContext())
     {
         if (car != null)
         {
             db.Cars.Update(car);
             db.SaveChanges();
         }
     }
 }
Пример #14
0
 public static void DeleteCar(Car car)
 {
     using (STOContext db = new STOContext())
     {
         if (car != null)
         {
             db.Cars.Remove(car);
             db.SaveChanges();
         }
     }
 }
Пример #15
0
        public static List <Car> GetPage(int pageNumber, int sizeOfPage)
        {
            List <Car> all = new List <Car>();

            using (STOContext db = new STOContext())
            {
                all = db.Cars.Include(t => t.Model)
                      .Include(t => t.Colour).Include(t => t.StateNumber).
                      Skip(pageNumber * sizeOfPage).Take(sizeOfPage).ToList();
            }
            return(all);
        }
Пример #16
0
        public static void Initialize(STOContext db)
        {
            db.Database.EnsureCreated();
            int carsNumber    = 25;
            int ordersNumber  = 50;
            int ownersNumber  = 10;
            int workersNumber = 10;

            InitializeOwners(db, ownersNumber);
            InitializeWorkers(db, workersNumber);
            InitializeCars(db, carsNumber, ownersNumber);
            InitializeOrders(db, ordersNumber, carsNumber, workersNumber);
        }
Пример #17
0
        private static void InitializeOrders(STOContext db, int ordersNumber, int carsNumber, int workersNumber)
        {
            //проверка, занесены ли данные в Orders
            if (db.Orders.Any())
            {
                return; //бд иницилизирована
            }

            int      carID;
            DateTime dateReceipt;
            DateTime?dateCompletion;
            int      workerID;

            Random randomObj = new Random(DateTime.Now.Month * 30 + DateTime.Now.Year * 365 + DateTime.Now.Day
                                          + DateTime.Now.Minute);

            for (int OrderID = 1; OrderID <= ordersNumber; OrderID++)
            {
                var date = new DateTime(randomObj.Next(2000, 2020),
                                        randomObj.Next(1, 12),
                                        randomObj.Next(1, 28));
                carID       = db.Cars.Skip(randomObj.Next(0, db.Cars.Count() - 2)).First().CarID;
                dateReceipt = date;
                var twoDate = new DateTime(randomObj.Next(1, 10),
                                           randomObj.Next(1, 12),
                                           randomObj.Next(1, 28));
                if (OrderID % 5 == 0)
                {
                    dateCompletion = date.Add(new TimeSpan(twoDate.Ticks));
                }
                else
                {
                    dateCompletion = null;
                }
                workerID = db.Workers.Skip(randomObj.Next(0, db.Workers.Count() - 2)).First().WorkerID;

                db.Orders.Add(new Order
                {
                    CarID          = carID,
                    DateReceipt    = dateReceipt,
                    DateCompletion = dateCompletion,
                    WorkerID       = workerID
                });
            }

            //сохранение изменений в бд, связанную с объектом контекста
            db.SaveChanges();
        }
Пример #18
0
        private static void InitializeWorkers(STOContext db, int workersNumber)
        {
            //проверка, занесены ли данные в Workers
            if (db.Workers.Any())
            {
                return; //бд иницилизирована
            }

            string   fioWorker;
            DateTime dateOfEmployment;
            DateTime?dateOfDismissal;
            decimal  salary;

            Random randomObj = new Random(1);

            for (int WorkerID = 1; WorkerID <= workersNumber; WorkerID++)
            {
                var date = new DateTime(randomObj.Next(1990, 2018),
                                        randomObj.Next(1, 12),
                                        randomObj.Next(1, 28));
                fioWorker = MyRandom.RandomString(15);
                var twoDate = new DateTime(randomObj.Next(1, 10),
                                           randomObj.Next(1, 12),
                                           randomObj.Next(1, 28));
                if (WorkerID % 5 == 0)
                {
                    dateOfDismissal = date.Add(new TimeSpan(twoDate.Ticks));
                }
                else
                {
                    dateOfDismissal = null;
                }
                dateOfEmployment = date;
                salary           = randomObj.Next(100, 1000);

                db.Workers.Add(new Worker
                {
                    FioWorker        = fioWorker,
                    DateOfDismissal  = dateOfDismissal,
                    DateOfEmployment = dateOfEmployment,
                    Salary           = salary,
                });
            }

            //сохранение изменений в бд, связанную с объектом контекста
            db.SaveChanges();
        }
Пример #19
0
        private static void InitializeCars(STOContext db, int carsNumber, int ownersNumber)
        {
            //проверка, занесены ли данные в Cars
            if (db.Cars.Any())
            {
                return; //бд иницилизирована
            }

            int    ownerID;
            string model;
            int    power;
            string colour;
            string stateNumber;
            int    yearOfIssue;
            int    bodyNumber;
            int    engineNumber;

            Random randomObj = new Random(1);

            for (int CarID = 1; CarID <= carsNumber; CarID++)
            {
                ownerID      = db.Owners.Skip(randomObj.Next(0, db.Owners.Count() - 2)).First().OwnerID;
                model        = MyRandom.RandomString(10);
                power        = randomObj.Next(10, 100);
                colour       = MyRandom.RandomString(10);
                stateNumber  = MyRandom.RandomString(9);
                yearOfIssue  = randomObj.Next(1, 4);
                bodyNumber   = randomObj.Next(1, 10);
                engineNumber = randomObj.Next(1, 10);

                db.Cars.Add(new Car
                {
                    OwnerID      = ownerID,
                    Model        = model,
                    Power        = power,
                    Colour       = colour,
                    StateNumber  = stateNumber,
                    YearOfIssue  = yearOfIssue,
                    BodyNumber   = bodyNumber,
                    EngineNumber = engineNumber
                });
            }

            //сохранение изменений в бд, связанную с объектом контекста
            db.SaveChanges();
        }
Пример #20
0
        public static List <Worker> FindWorkers(string fioWorker, DateTime dateOfEmployment, DateTime?dateOfDismissal, decimal salary)
        {
            List <Worker> workers = new List <Worker>();

            using (STOContext db = new STOContext())
            {
                if (fioWorker != null && fioWorker != "")
                {
                    workers = db.Workers.Where(k => k.FioWorker == fioWorker).ToList();
                }
                if (dateOfEmployment != null)
                {
                    if (workers.Count != 0)
                    {
                        workers = workers.Where(k => k.DateOfEmployment == dateOfEmployment).ToList();
                    }
                    else
                    {
                        workers = db.Workers.Where(k => k.DateOfEmployment == dateOfEmployment).ToList();
                    }
                }
                if (dateOfDismissal != null)
                {
                    if (workers.Count != 0)
                    {
                        workers = workers.Where(k => k.DateOfDismissal == dateOfDismissal).ToList();
                    }
                    else
                    {
                        workers = db.Workers.Where(k => k.DateOfDismissal == dateOfDismissal).ToList();
                    }
                }
                if (salary != 0)
                {
                    workers = db.Workers.Where(k => k.Salary == salary).ToList();
                }
            }
            return(workers);
        }
Пример #21
0
        public static List <Order> FindOrders(DateTime dateReceipt, DateTime?dateCompletion)
        {
            List <Order> orders = new List <Order>();

            using (STOContext db = new STOContext())
            {
                if (dateReceipt != null)
                {
                    orders = db.Orders.Where(k => k.DateReceipt == dateReceipt).ToList();
                }
                if (dateCompletion != null)
                {
                    if (orders.Count != 0)
                    {
                        orders = orders.Where(k => k.DateCompletion == dateCompletion).ToList();
                    }
                    else
                    {
                        orders = db.Orders.Where(k => k.DateCompletion == dateCompletion).ToList();
                    }
                }
            }
            return(orders);
        }
Пример #22
0
        private static void InitializeOwners(STOContext db, int ownersNumber)
        {
            //проверка, занесены ли данные в Owners
            if (db.Owners.Any())
            {
                return; //бд иницилизирована
            }

            int    ownerID;
            int    driverLicense;
            string fioOwner;
            string adress;
            int    phone;

            Random randomObj = new Random(1);

            for (int OwnerID = 1; OwnerID <= ownersNumber; OwnerID++)
            {
                ownerID       = OwnerID;
                driverLicense = randomObj.Next(1, 3000);
                fioOwner      = MyRandom.RandomString(15);
                adress        = MyRandom.RandomString(15);
                phone         = randomObj.Next(1, 1000000);

                db.Owners.Add(new Owner
                {
                    DriverLicense = driverLicense,
                    FioOwner      = fioOwner,
                    Adress        = adress,
                    Phone         = phone
                });
            }

            //сохранение изменений в бд, связанную с объектом контекста
            db.SaveChanges();
        }
Пример #23
0
        public static List <Car> FindCar(string model, int power,
                                         string colour, string stateNumber, int yearOfIssue, int bodyNumber, int engineNumber)
        {
            List <Car> cars = new List <Car>();

            using (STOContext db = new STOContext())
            {
                if (model != null)
                {
                    cars = db.Cars.Where(k => k.Model == model).ToList();
                }
                if (power != 0)
                {
                    if (cars.Count != 0)
                    {
                        cars = cars.Where(k => k.Power == power).ToList();
                    }
                    else
                    {
                        cars = db.Cars.Where(k => k.Power == power).ToList();
                    }
                }
                if (colour != null)
                {
                    if (cars.Count != 0)
                    {
                        cars = cars.Where(k => k.Colour == colour).ToList();
                    }
                    else
                    {
                        cars = db.Cars.Where(k => k.Colour == colour).ToList();
                    }
                }
                if (stateNumber != null)
                {
                    if (cars.Count != 0)
                    {
                        cars = cars.Where(k => k.StateNumber == stateNumber).ToList();
                    }
                    else
                    {
                        cars = db.Cars.Where(k => k.StateNumber == stateNumber).ToList();
                    }
                }
                if (yearOfIssue != 0)
                {
                    if (cars.Count != 0)
                    {
                        cars = cars.Where(k => k.YearOfIssue == yearOfIssue).ToList();
                    }
                    else
                    {
                        cars = db.Cars.Where(k => k.YearOfIssue == yearOfIssue).ToList();
                    }
                }
                if (bodyNumber != 0)
                {
                    if (cars.Count != 0)
                    {
                        cars = cars.Where(k => k.BodyNumber == bodyNumber).ToList();
                    }
                    else
                    {
                        cars = db.Cars.Where(k => k.BodyNumber == bodyNumber).ToList();
                    }
                }
                if (engineNumber != 0)
                {
                    if (cars.Count != 0)
                    {
                        cars = cars.Where(k => k.EngineNumber == engineNumber).ToList();
                    }
                    else
                    {
                        cars = db.Cars.Where(k => k.EngineNumber == engineNumber).ToList();
                    }
                }
            }
            return(cars);
        }