public static void CreateProperyStat(PropertyObject po, RealtyDb _db)
 {
     _db.PropertyStats.Add(new PropertyStat()
     {
         PropertyObject = po,
         day = DateTime.Today.Day,
         month = DateTime.Today.Month,
         year = DateTime.Today.Year
     });
     _db.SaveChanges();
 }
 public AgencyToPhoneRoutines(RealtyDb _db)
 {
     this._db = _db;
 }
 public CityDistrictRoutines(RealtyDb _db)
 {
     this._db = _db;
 }
 public DBBasicDataLoader(string sourceFolder, RealtyDb context)
 {
     this.sourceFolder = sourceFolder;
     this.context = context;
 }
        private bool ValidateData(List<Instruction> data)
        {

            RealtyDb _db = new RealtyDb();

            var city = (from s in _db.Cities
                        select s).ToArray<City>();

            var district = (from s in _db.CityDistricts.Include("City")
                            select s).ToList<CityDisctict>();

            var propertyTypes = (from s in _db.PropertyTypes
                                 select s).ToList<PropertyType>();

            var propertyActions = (from s in _db.PropertyActions
                                   select s).ToList<PropertyAction>();

            var propertyObjects = (from s in _db.PropertyObjects
                                   select s).ToList<PropertyObject>();


            if (data == null || data.Count() == 0)
            {
                Console.WriteLine("Отсутствуют  инструкции на проверки, работа остановлена");
                return false;
            }
            int countErrors = 0;
            for (int i = 0; i < data.Count(); i++)
            {

                if (!string.IsNullOrEmpty(data[i].city.ToLower().Trim()))
                {
                    var cityObj = (from s in city
                                   where s.CityName.ToLower() == data[i].city.ToLower().Trim()//"Киев".ToLower()//
                                   select s).SingleOrDefault<City>();
                    if (cityObj == null)
                    {
                        Console.WriteLine("Не найден  город " + data[i].city);
                        countErrors++;
                    }

                    if (!string.IsNullOrEmpty(data[i].district.ToLower().Trim()))
                    {
                        var districtObj = (from s in district
                                           where s.District.ToLower() == data[i].district.ToLower().Trim()
                                           && s.City.Id == cityObj.Id
                                           select s).SingleOrDefault<CityDisctict>();

                        if (districtObj == null)
                        {
                            if (cityObj != null)
                                Console.WriteLine("Не найден  район " + data[i].district + " для города " + cityObj.CityName);
                            else
                                Console.WriteLine("Не найден  район " + data[i].district);
                            countErrors++;
                        }
                    }
                }

                var propertyTypeObj = (from s in propertyTypes
                                       where s.PropertyTypeName.ToLower() == data[i].propertyType.ToLower().Trim()//"Квартиры".ToLower()//
                                       select s).SingleOrDefault<PropertyType>();

                if (propertyTypeObj == null)
                {
                    Console.WriteLine("Не найден тип недвижимости" + data[i].propertyType);
                    countErrors++;
                }

                var propertyActionObj = (from s in propertyActions
                                         where s.PropertyActionName.ToLower() == data[i].propertyAction.ToLower().Trim()//"Продажа".ToLower()//
                                         && s.PropertyType.Id == propertyTypeObj.Id
                                         select s).SingleOrDefault<PropertyAction>();

                if (propertyActionObj == null)
                {
                    Console.WriteLine("Не найден тип действия с недвижимостью" + data[i].propertyAction);
                    countErrors++;
                }


            }

            _db.Dispose();
            _db = null;
            return countErrors == 0 ? true : false;
        }
        private void StoreEntity()
        {


            lock (dbLoaderLock)
            {
                Monitor.Wait(dbLoaderLock);
            }

            RealtyDb _db = new RealtyDb();
            bool stopLoop = false;
            Entity ent = null;
            int countStoredObjects = 0;

            var city = (from s in _db.Cities
                        select s).ToArray<City>();

            var district = (from s in _db.CityDistricts.Include("City")
                            select s).ToList<CityDisctict>();

            var propertyTypes = (from s in _db.PropertyTypes
                                 select s).ToList<PropertyType>();

            var propertyActions = (from s in _db.PropertyActions
                                   select s).ToList<PropertyAction>();

            var propertyObjects = (from s in _db.PropertyObjects
                                   select s).ToList<PropertyObject>();

            var periods = (from s in _db.Periods
                           select s).ToList<Periods>();

            var buildingTypes = (from s in _db.BuildingTypes
                                 select s).ToList<BuildingType>();

            var wcTypes = (from s in _db.WCTypes
                           select s).ToList<WCType>();

            var currencyTypes = (from s in _db.CurrencyTypes
                                 select s).ToList<CurrencyType>();

            var priceForTypes = (from s in _db.PriceForTypes
                                 select s).ToList<PriceForType>();

            var landCommunications = (from s in _db.LandCommunications
                                      select s).ToList<LandCommunication>();

            var landFunctions = (from s in _db.LandFunctions
                                 select s).ToList<LandFunction>();

            var commercialPropertyTypes = (from s in _db.CommercialPropertyTypes
                                           select s).ToList<CommercialPropertyType>();

            var serviceTypes = (from s in _db.ServiceTypes
                                select s).ToList<ServiceType>();


            _db.Dispose();
            _db = null;

            string connStr = "server=localhost; Port =3306; user id=root; password=mysqlPass; database=RealtyDb; pooling=true; CharSet=utf8; Connection Timeout=10000; Protocol=socket;";
            SqlObjectManipulation sql = new SqlObjectManipulation(connStr);
            WebRealty.Common.ImageProcessing imgHelper = new WebRealty.Common.ImageProcessing();

            DataValidator validate = new DataValidator();
            //int countInstructions = 0;
            //int countLinksToObject = 0;
            int countEntities = 0;
            int tmpInt = -1;
            do
            {
                lock (entitiesLocker)
                {
                    if (entities.Count > 0)
                        ent = entities.Dequeue();
                    countEntities = entities.Count;
                }

                //if (countEntities < minLimitList)
                //{
                //    lock (collectEntityLock)
                //    {
                //        Monitor.PulseAll(collectEntityLock);
                //    }
                //}



                //lock (instructionLocker)//получаем количество доступных инструкций
                //{
                //    countInstructions = instructions.Count();
                //}

                if (ent == null && t2.IsAlive)//засыпаем, пока нес не позовут
                {
                    eventLog.AddEventToLog("StoreEntity- сслыку на объект получить не удалось, поток собиратель объетов еще живой- засыпаем");
                    lock (dbLoaderLock)
                    {
                        Monitor.Wait(dbLoaderLock);
                    }
                    continue;
                }

                if (ent != null)
                {
                    var houseTypeObj = (from s in buildingTypes.AsEnumerable()
                                        where s.BuildingTypeName.ToLower() == ent.houseType.ToLower().Trim()
                                        select s).SingleOrDefault<BuildingType>();

                    var wcTypeObj = (from s in wcTypes.AsEnumerable()
                                     where s.WCTypeName.ToLower() == ent.wctype.ToLower().Trim()
                                     select s).SingleOrDefault<WCType>();

                    var currencyObj = (from s in currencyTypes
                                       where s.CurrencyTypeName.ToLower() == (ent.currency != null ? ent.currency.ToLower().Trim() : "у.е")
                                       select s).SingleOrDefault<CurrencyType>();

                    PriceForType priceForObj = null;
                    if (ent.priceFor != null)
                        priceForObj = (from s in priceForTypes
                                       where s.PriveForTypeName.ToLower().Replace(".", "") == ent.priceFor.ToLower().Trim().Replace(".", "")
                                       select s).FirstOrDefault<PriceForType>();

                    var cityObj = (from s in city
                                   where s.CityName.ToLower() == ent.City.ToLower().Trim()//"Киев".ToLower()//
                                   select s).SingleOrDefault<City>();

                    var districtObj = (from s in district
                                       where s.District.ToLower() == ent.District.ToLower().Trim()//"Голосеевский р-н.".ToLower()//
                                       && s.City.Id == cityObj.Id
                                       select s).SingleOrDefault<CityDisctict>();

                    var propertyTypeObj = (from s in propertyTypes
                                           where s.PropertyTypeName.ToLower() == ent.propertyType.ToLower().Trim()//"Квартиры".ToLower()//
                                           select s).SingleOrDefault<PropertyType>();

                    var propertyActionObj = (from s in propertyActions
                                             where s.PropertyActionName.ToLower() == ent.propertyAction.ToLower().Trim()//"Продажа".ToLower()//
                                             && s.PropertyType.Id == propertyTypeObj.Id
                                             select s).SingleOrDefault<PropertyAction>();

                    PropertyObject po = new PropertyObject()
                    {
                        BalconAvailable = ent.balconyAvailable,
                        BalconSpace = ent.balconySize,
                        BuildingTypeName = houseTypeObj,
                        City = cityObj,
                        CityDistrict = districtObj,
                        CommercialPropertyType = null,
                        ContactName = ent.contactName,
                        CountFloors = ent.countFloors, //???????
                        CountPhotos = (ent.photos != null ? ent.photos.Count() : 0),//ent.LinkToPhotos.Count(),
                        //CreatedDate=
                        Currency = currencyObj,
                        DistanceToCity = ent.distanceToCity,
                        Floor = ent.floor,
                        IsActive = true,
                        isBalconGlassed = ent.isBalconyGlassed,
                        IsNewBuilding = ent.isNewBuilding,
                        KitchenSpace = ent.kitchenSize,
                        LivingSpace = ent.livingSize,
                        NoCommission = ent.noComission,
                        //Periods=
                        Phone1 = ent.phone1,
                        Price = ent.price,
                        PriceForTypeName = priceForObj,
                        PropertyAction = propertyActionObj,
                        PropertyDescription = ent.description,
                        PropertyType = propertyTypeObj,
                        RoomCount = ent.roomsCount,
                        ServiceType = null,
                        Title = ent.title,
                        TotalSpace = ent.allSize,
                        WCType = wcTypeObj,
                        LinkOfObjectGrab = ent.linkToOriginalObject

                    };



                    if (po.CountFloors <= 0)
                        po.CountFloors = (int)ent.houseCountFloor;


                    if (po.LivingSpace <= 0)
                        po.LivingSpace = ent.houseGardenSize;

                    if (po.TotalSpace <= 0)
                        po.TotalSpace = ent.houseSize;

                    if (po.TotalSpace <= 0)
                        po.TotalSpace = ent.commercialObjectSize;




                    var datePart = ent.CreatedDate.Split('-');
                    if (datePart != null && datePart.Length > 1)
                    {
                        var dateSplitted = datePart[0].Split('.');
                        var timeSplitted = datePart[1].Split(':');
                        if (dateSplitted.Length == 3)
                        {
                            DateTime createdDate = new DateTime(Convert.ToInt32(dateSplitted[2]),
                                Convert.ToInt32(dateSplitted[1]),
                                Convert.ToInt32(dateSplitted[0]),
                                Convert.ToInt32(timeSplitted[0]),
                                Convert.ToInt32(timeSplitted[1]),
                                0, DateTimeKind.Local
                                );
                            po.CreatedDate = createdDate;
                        }
                    }

                    validate.ValidateAndFix(po);
                    try
                    {
                        int objectId = sql.AddPropertyObject(po);//uncomment it

                        for (int i = 0; i < ent.photos.Count(); i++)
                        {
                            if (ent.photos[i] != null && ent.photos[i].Length > 0)
                            {
                                //uncomment it
                                sql.Mysql_File_Save(objectId, 0, i.ToString() + ".jpg", "", 521, 521,
                                     ent.photos[i], imgHelper.ResizeImage(ent.photos[i], new System.Drawing.Size(120, 90)), false);
                            }
                        }
                        ent = null;
                        po = null;
                        Console.WriteLine("Stored objects : " + (++countStoredObjects).ToString());
                    }
                    catch (Exception ex)
                    {
                        eventLog.AddEventToLog("ОШИБКА сохранения объекта в БД: " + ex.Message.ToString() + " стэк ошибки: " + ex.StackTrace.ToString());
                    }
                }



                if (!t2.IsAlive && countEntities == 0)
                {
                    stopLoop = true;
                    linkLogger.TerminateLog();
                }

            } while (!stopLoop);

            Console.WriteLine("StoreEntity terminated");
            eventLog.AddEventToLog("StoreEntity завершает работу");
            return;

        }
 public PropertyTypeRoutines(RealtyDb _db)
 {
     this._db = _db;
 }
 public CityRoutines(RealtyDb _db)
 {
     this._db = _db;
 }
 public PropertyActionRoutines(RealtyDb _db)
 {
     this._db = _db;
 }