public void DeletePrice(List <string> lstSymbole)
        {
            try
            {
                using (var unitOfWork = new EFUnitOfWork())
                {
                    var priceRepo =
                        new PriceRepository(new EFRepository <Price>(), unitOfWork);

                    ObjectSet <Price> priceObj =
                        ((CurrentDeskClientsEntities)priceRepo.Repository.UnitOfWork.Context).Prices;

                    var lstPrice = priceObj.Where(p => lstSymbole.Contains(p.Symbole)).ToList();

                    foreach (var price in lstPrice)
                    {
                        priceRepo.Delete(price);
                    }
                    priceRepo.Save();
                }
            }
            catch (Exception ex)
            {
                CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
            }
        }
        // Add your own data access methods here.  If you wish to
        // expose your public method to a WCF service, marked them with
        // the attribute [NCPublish], and another T4 template will generate your service contract
        public void DeleteSymbol(string symbole)
        {
            try
            {
                using (var unitOfWork = new EFUnitOfWork())
                {
                    var priceRepo =
                        new PriceRepository(new EFRepository <Price>(), unitOfWork);

                    ObjectSet <Price> priceObj =
                        ((CurrentDeskClientsEntities)priceRepo.Repository.UnitOfWork.Context).Prices;

                    var price = priceObj.Where(s => s.Symbole == symbole).FirstOrDefault();
                    if (price != null)
                    {
                        priceRepo.Delete(price);
                        priceRepo.Save();
                    }
                }
            }
            catch (Exception ex)
            {
                CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
            }
        }
        public void InsertPrice(List <Price> lstPrice)
        {
            try
            {
                using (var unitOfWork = new EFUnitOfWork())
                {
                    var priceRepo =
                        new PriceRepository(new EFRepository <Price>(), unitOfWork);


                    ObjectSet <Price> priceObj =
                        ((CurrentDeskClientsEntities)priceRepo.Repository.UnitOfWork.Context).Prices;

                    var lstSymbole = lstPrice.Select(s => s.Symbole).ToList();

                    //Get the existing price from DB and update with New DB
                    var lstDBPrice = priceObj.Where(p => lstSymbole.Contains(p.Symbole)).ToList();
                    foreach (var uPrice in lstDBPrice)
                    {
                        var newPrice = lstPrice.Where(s => s.Symbole == uPrice.Symbole.Trim()).FirstOrDefault();
                        if (newPrice != null)
                        {
                            uPrice.Ask = newPrice.Ask;
                            uPrice.Bid = newPrice.Bid;
                        }
                    }

                    //Add new price
                    var lstDBPriceSymbole = lstDBPrice.Select(p => p.Symbole.Trim()).ToList();
                    var newPricesToAdd    = lstPrice.Where(lp => !lstDBPriceSymbole.Contains(lp.Symbole)).Distinct().ToList();
                    foreach (var price in newPricesToAdd)
                    {
                        priceRepo.Add(price);
                    }

                    priceRepo.Save();
                }
            }
            catch (Exception ex)
            {
                CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
            }
        }