public List <AdvertModel> Read(string Id)
 {
     using (var db = new SQLiteDBContext())
     {
         return((from a in db.AdvertDBModel where (string.IsNullOrEmpty(Id) || a.Id == Id)select new AdvertModel {
             Title = a.Title, Description = a.Description, Price = a.Price
         }).ToList());
     }
 }
        public async Task <string> Add(AdvertModel model)
        {
            var dbModel = _mapper.Map <AdvertDBModel>(model);

            dbModel.Id = Guid.NewGuid().ToString();
            dbModel.CreationDateTime = DateTime.UtcNow;
            dbModel.Status           = AdvertStatus.Pending;


            using (var db = new SQLiteDBContext())
            {
                db.AdvertDBModel.Add(dbModel);
                db.SaveChanges();
            }

            return(dbModel.Id);
        }