Ejemplo n.º 1
0
 /// <summary>
 /// 删除一个缴纳地
 /// </summary>
 /// <param name="validationErrors">返回的错误信息</param>
 /// <param name="id">一个缴纳地的主键</param>
 /// <returns></returns>
 public bool Delete(ref ValidationErrors validationErrors, string id)
 {
     try
     {
         return(repository.Delete(id) == 1);
     }
     catch (Exception ex)
     {
         validationErrors.Add(ex.Message);
         ExceptionsHander.WriteExceptions(ex);
     }
     return(false);
 }
Ejemplo n.º 2
0
 public void DeleteCity(int cityId)
 {
     //unitOfWork.StartTransaction();
     CityRepository repo = new CityRepository(unitOfWork);
     repo.Delete(x => x.CityId == cityId);
     //unitOfWork.Commit();
 }
Ejemplo n.º 3
0
        public void DeleteCity()
        {
            Console.Clear();
            Console.WriteLine("Введите город который хотите удалить - ");
            var cityName = CheckNullString(Console.ReadLine());

            using (var repository = new CityRepository())
            {
                try
                {
                    var id = repository.GetCity(cityName);
                    repository.Delete(id);
                }
                catch (Exception exception)
                {
                    Console.WriteLine(exception.Message);
                    Console.WriteLine("Нажмите Enter чтобы продолжить!");
                    Console.ReadKey();
                    return;
                }
            }
            Console.WriteLine("Данные удалены!");
            Console.WriteLine("Нажмите Enter чтобы продолжить!");
            Console.ReadKey();
        }
Ejemplo n.º 4
0
 public void Delete(int id)
 {
     using (Repository = new CityRepository())
     {
         Message = DeleteSuccessMessage;
         Repository.Delete(id);
     }
 }
Ejemplo n.º 5
0
        public ActionResult Delete(int id)
        {
            int CityId = id;
            var e      = cityRepository.GetById(CityId);

            // TODO: Add delete logic here
            cityRepository.Delete(e);
            return(RedirectToAction("Index"));
        }
Ejemplo n.º 6
0
        public void Delete(long id)
        {
            City city = cityRepository.GetById(id);

            if (city == null)
            {
                throw new Exception("City não encontrada");
            }

            cityRepository.Delete(city);
        }
Ejemplo n.º 7
0
        private async Task <object> DeleteCity(ResolveFieldContext <object> context)
        {
            var cityId = context.GetArgument <Guid>("cityID");
            var city   = await _cityRepository.Delete(cityId);

            if (city == null)
            {
                context.Errors.Add(new ExecutionError("Couldn't find city to delete"));
            }

            return(city);
        }
Ejemplo n.º 8
0
 public int DeleteCity(int Id)
 {
     try
     {
         _ICityRepository.Delete(Id);
         return(_ICityRepository.Save());
     }
     catch (Exception exception)
     {
         exception.Log();
         return(0);
     }
 }
Ejemplo n.º 9
0
        public async Task Delete(CityDTO item)
        {
            using (var repo = new CityRepository())
            {
                City existing = await repo.GetById(item.Id);

                if (existing == null)
                {
                    return;
                }
                await repo.Delete(existing);

                await repo.Commit();
            }
        }
Ejemplo n.º 10
0
        public bool Delete(string cityID)
        {
            //Guid gCityID = new Guid(cityID);
            var city = CityRepository.GetQueryable()
                       .FirstOrDefault(i => i.CITY_ID == cityID);

            if (city != null)
            {
                CityRepository.Delete(city);
                CityRepository.SaveChanges();
            }
            else
            {
                return(false);
            }
            return(true);
        }
        public ActionResult Delete(CityVM cityVM)
        {
            //Get Item
            City city = new City();

            city = cityRepository.GetCity(cityVM.City.CityCode);

            //Check Exists
            if (cityVM.City == null)
            {
                ViewData["ActionMethod"] = "DeletePost";
                return(View("RecordDoesNotExistError"));
            }

            //Check Access Rights to Domain
            if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }

            //Delete Item
            try
            {
                cityRepository.Delete(city);
            }
            catch (SqlException ex)
            {
                //Versioning Error - go to standard versionError page
                if (ex.Message == "SQLVersioningError")
                {
                    ViewData["ReturnURL"] = "/City.mvc/Delete/" + city.CityCode;
                    return(View("VersionError"));
                }

                //Generic Error
                ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
                return(View("Error"));
            }

            //Return
            return(RedirectToAction("List"));
        }
Ejemplo n.º 12
0
        public ActionResult Delete(int id)
        {
            CityRepository.Delete(id);

            return(RedirectToAction("Index"));
        }
Ejemplo n.º 13
0
 public ActionResult Delete(int ID)
 {
     repository.Delete(ID);
     return(RedirectToAction(nameof(Index)));
 }
Ejemplo n.º 14
0
        // [TAG] Delete cascade
        static void DeleteCity()
        {
            var cityRepo = new CityRepository();

            cityRepo.Delete(4);
        }
        public void DeleteTest()
        {
            int rows = 0;

            using (DBContext db = new DBContext(settings.Database.ConnectionString, logger))
            {
                Assert.NotNull(db);
                ContactRepository contactRepos = new ContactRepository(settings, logger, db);
                CityRepository    cityRepos    = new CityRepository(settings, logger, db);
                StateRepository   stateRepos   = new StateRepository(settings, logger, db);

                #region Delete Contact Test
                Contact contact = contactRepos.FindByPK(new PrimaryKey()
                {
                    Key = 8
                });
                Assert.NotNull(contact);
                rows = contactRepos.Delete(new PrimaryKey()
                {
                    Key = 8
                });
                Assert.Equal(1, rows);
                contact = contactRepos.FindByPK(new PrimaryKey()
                {
                    Key = 8
                });
                Assert.Null(contact);
                #endregion

                #region Delete City Test
                City city = cityRepos.FindByPK(new PrimaryKey()
                {
                    Key = 17
                });
                Assert.NotNull(city);
                rows = cityRepos.Delete(new PrimaryKey()
                {
                    Key = 17
                });
                Assert.Equal(1, rows);
                city = cityRepos.FindByPK(new PrimaryKey()
                {
                    Key = 17
                });
                Assert.Null(city);
                #endregion

                #region Delete State Test
                State state = stateRepos.FindByPK(new PrimaryKey()
                {
                    Key = "WA"
                });
                Assert.NotNull(state);
                rows = stateRepos.Delete(new PrimaryKey()
                {
                    Key = "WA"
                });
                Assert.Equal(1, rows);
                state = stateRepos.FindByPK(new PrimaryKey()
                {
                    Key = "WA"
                });
                Assert.Null(state);
                #endregion
            }
        }
Ejemplo n.º 16
0
        public string Delete(City city)
        {
            bool success = CityRepository.Delete(city);

            return("City removed with success");
        }
        public async Task Delete(Guid id)
        {
            var city = await CityRepository.FindById(id);

            await CityRepository.Delete(city);
        }
Ejemplo n.º 18
0
 public IHttpActionResult Delete(int id)
 {
     repo.Delete(id);
     return(Ok());
 }
Ejemplo n.º 19
0
        public async Task DeleteTest()
        {
            int rows = 0;

            using (DBContext db = new DBContext(settings.Database.ConnectionString, logger))
            {
                Assert.NotNull(db);
                ContactRepository        contactRepos        = new ContactRepository(settings, logger, db);
                CityRepository           cityRepos           = new CityRepository(settings, logger, db);
                StateRepository          stateRepos          = new StateRepository(settings, logger, db);
                ProjectContactRepository projectContactRepos = new ProjectContactRepository(settings, logger, db);

                #region Delete Contact Test
                Contact contact = await contactRepos.FindByPK(new PrimaryKey()
                {
                    Key = 8
                });

                Assert.NotNull(contact);
                rows = await contactRepos.Delete(new PrimaryKey()
                {
                    Key = 8
                });

                Assert.Equal(1, rows);
                contact = await contactRepos.FindByPK(new PrimaryKey()
                {
                    Key = 8
                });

                Assert.Null(contact);
                #endregion

                #region Delete City Test
                City city = await cityRepos.FindByPK(new PrimaryKey()
                {
                    Key = 17
                });

                Assert.NotNull(city);
                rows = await cityRepos.Delete(new PrimaryKey()
                {
                    Key = 17
                });

                Assert.Equal(1, rows);
                city = await cityRepos.FindByPK(new PrimaryKey()
                {
                    Key = 17
                });

                Assert.Null(city);
                #endregion

                #region Delete State Test
                State state = await stateRepos.FindByPK(new PrimaryKey()
                {
                    Key = "WA"
                });

                Assert.NotNull(state);
                rows = await stateRepos.Delete(new PrimaryKey()
                {
                    Key = "WA"
                });

                Assert.Equal(1, rows);
                state = await stateRepos.FindByPK(new PrimaryKey()
                {
                    Key = "WA"
                });

                Assert.Null(state);
                #endregion

                #region Delete ProjectContact Test
                ProjectContact projectContact = await projectContactRepos.FindByPK(new PrimaryKey()
                {
                    CompositeKey = new object[] { 1, 1 }, IsComposite = true
                });

                Assert.NotNull(projectContact);
                rows = await projectContactRepos.Delete(new PrimaryKey()
                {
                    CompositeKey = new object[] { 1, 1 }, IsComposite = true
                });

                Assert.Equal(1, rows);
                projectContact = await projectContactRepos.FindByPK(new PrimaryKey()
                {
                    CompositeKey = new object[] { 1, 1 }, IsComposite = true
                });

                Assert.Null(projectContact);
                #endregion
            }
        }