public void Remove(long id) { Territories data = GetById(id); this.context.Territories.Remove(data); this.context.SaveChanges(); }
static void Main(string[] args) { Customers customer = new Customers(); Territories territories = new Territories(); foreach (var item in customer.GetCustomersCountries) { Console.WriteLine(item); } Console.WriteLine(); foreach (var item in customer.GetCustomersInCountry("Germany")) { Console.WriteLine(item.ContactName); } Console.WriteLine(); foreach (var item in customer.GetCustomersInCountry("Germany")) { Console.WriteLine(item.ContactName); } Console.WriteLine(); //foreach (var i in customer.GetCustomersInCountryGroup) //{ // Console.WriteLine(i); // Console.WriteLine(); //} }
public async Task TerritoryDeleteReturnsView() { //Arrange Region regionTest = new Region() { RegionID = 100, RegionDescription = "test" }; Territories territoryTest = new Territories() { TerritoryID = "102", TerritoryDescription = "Acasa", Region = regionTest }; await _territoriesControllerTest.Create(territoryTest, regionTest.RegionID); //Act var result = _territoriesControllerTest.Delete(territoryTest.TerritoryID); //Assert Assert.IsNotNull(result); var regions = db.Regions.Where(t => t.RegionDescription.Contains(regionTest.RegionDescription)); db.Regions.RemoveRange(regions); var territory = db.Territories.Where(t => t.TerritoryDescription.Contains("Acasa")); db.Territories.RemoveRange(territory); db.SaveChanges(); }
public async Task TerritoryDeleteDeletes() { //Arrange Region regionTest = new Region() { RegionID = 88, RegionDescription = "test" }; Territories territoryTest = new Territories() { TerritoryID = "102", TerritoryDescription = "Acasa", Region = regionTest }; await _territoriesControllerTest.Create(territoryTest, regionTest.RegionID); int expected = db.Territories.Count() - 1; //Act await _territoriesControllerTest.DeleteConfirmed(territoryTest.TerritoryID); int actual = db.Territories.Count(); //Assert Assert.AreEqual(expected, actual); var regions = db.Regions.Where(t => t.RegionDescription.Contains(regionTest.RegionDescription)); db.Regions.RemoveRange(regions); var territory = db.Territories.Where(t => (t.TerritoryDescription == "Acasa")); db.Territories.RemoveRange(territory); db.SaveChanges(); }
public void InitialBoardIsOccupied() { Assert.IsTrue(initialBoard.IsOccupied(Territories.Get("mun"))); Assert.IsTrue(initialBoard.IsOccupied(Territories.Get("stp"))); Assert.IsTrue(initialBoard.IsUnoccupied(Territories.Get("spa"))); Assert.IsTrue(initialBoard.IsUnoccupied(Territories.Get("gre"))); }
public async Task <IActionResult> PostTerritories([FromBody] Territories territories) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.Territories.Add(territories); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (TerritoriesExists(territories.TerritoryId)) { return(new StatusCodeResult(StatusCodes.Status409Conflict)); } else { throw; } } return(CreatedAtAction("GetTerritories", new { id = territories.TerritoryId }, territories)); }
public List <Territories> getAllTerritories() { List <Territories> territoriesList = new List <Territories>(); Connection conn = new Connection(); SqlConnection connection = conn.SqlConnection; using (SqlCommand command = new SqlCommand("select * from Territories", connection)) { try { connection.Open(); SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { Territories territory = new Territories(dataReader.GetString(0), dataReader.GetString(1), dataReader.GetInt32(2)); territoriesList.Add(territory); } dataReader.Close(); } catch (Exception exc) { logger.logError(DateTime.Now, "Error while trying to get all Territories."); MessageBox.Show(exc.Message); } logger.logInfo(DateTime.Now, "GetAllTerritories method has sucessfully invoked."); return(territoriesList); } }
public void updateTerritory() { Territories territory = new Territories("98101", "neka teritorija", 3); string res = repo.updateTerritory(territory); Assert.IsNotNull(res); }
public void IncluirAtualizarExcluirTerritorioDeUmaRegiao() { using (var uow = CreateTransientUnitOfWork()) { var regionRepository = new RegionRepository(uow); var region = regionRepository.Listar().FirstOrDefault(r => r.Territories.Count >= 2); if (region != null) { var territories = new Territories { TerritoryDescription = "Território de Teste Novo" }; territories.GenerateNewIdentity(); //var Territories = region.Territories.Last(); region.Territories.First().TerritoryDescription = "Território de Teste"; //region.Territories.Remove(Territories); region.Territories.Add(territories); regionRepository.Alterar(region); uow.Commit(); Assert.AreEqual(region.Territories.First().TerritoryDescription , "Território de Teste"); Assert.AreEqual(region.Territories.Last().TerritoryDescription , "Território de Teste Novo"); } else { uow.Rollback(); Assert.IsTrue(false); } } }
public Territory? FindOrAddTerritory(TerritoryType territory) { var newTerritory = Territories.FindOrAddTerritory(_pi, territory); if (newTerritory != null) AddAetherytes(newTerritory); return newTerritory; }
public async Task <IActionResult> PutTerritories([FromRoute] string id, [FromBody] Territories territories) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != territories.TerritoryId) { return(BadRequest()); } _context.Entry(territories).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TerritoriesExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task TerritoryCreate() { //Arrange Region regionTest = new Region() { RegionID = 100, RegionDescription = "test" }; Territories territoryTest = new Territories() { TerritoryID = "102", TerritoryDescription = "Acasa", Region = regionTest }; //Act var expected = db.Territories.Count() + 1; await _territoriesControllerTest.Create(territoryTest, regionTest.RegionID); var actual = db.Territories.Count(); var territory = db.Territories.Where(t => t.TerritoryID == territoryTest.TerritoryID && t.TerritoryDescription == territoryTest.TerritoryDescription); //Assert Assert.AreEqual(expected, actual); var regions = db.Regions.Where(t => t.RegionDescription.Contains(regionTest.RegionDescription)); db.Regions.RemoveRange(regions); var territories = db.Territories.Where(t => t.TerritoryDescription.Contains("Acasa")); db.Territories.RemoveRange(territories); db.SaveChanges(); }
private void button1_Click(object sender, EventArgs e) { using (NorthwindContext db = new NorthwindContext()) { if (String.IsNullOrEmpty(textBoxTerritoryID.Text) || String.IsNullOrEmpty(textBoxTerrDesc.Text)) { MessageBox.Show("Insert product name", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (db.Territories.Any(o => o.TerritoryID == textBoxTerritoryID.Text)) { MessageBox.Show("ID is not UNIQUE", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { Territories cat = new Territories(); int x; cat.TerritoryID = textBoxTerritoryID.Text; cat.TerritoryDescription = textBoxTerrDesc.Text; bool success = int.TryParse(comboBoxRegionID.Text, out x); if (success) { cat.RegionID = x; } db.Territories.Add(cat); db.SaveChanges(); this.Close(); } } }
/// <summary> /// Clears all the global /// </summary> public static void ClearValues() { AccountingGroups.Clear(); CostProfileGroups.Clear(); CountriesOfOrigin.Clear(); CustomerIdConversions.Clear(); ExternalIdTypes.Clear(); ItemCategories.Clear(); ItemGroups.Clear(); ItemIds.Clear(); ItemIdSuffixes.Clear(); ItemRecords.Clear(); Languages.Clear(); Licenses.Clear(); LocalItemIds.Clear(); MetaDescriptions.Clear(); PricingGroups.Clear(); ProductCategories.Clear(); ProductFormats.Clear(); ProductGoups.Clear(); ProductLines.Clear(); Properties.Clear(); PsStatuses.Clear(); RequestStatus.Clear(); SpecialCharacters.Clear(); TariffCodes.Clear(); Territories.Clear(); ToolTips.Clear(); UpcProductFormatExceptions.Clear(); Upcs.Clear(); UserNames.Clear(); UserRoles.Clear(); WebCategoryList.Clear(); }
public async Task <IActionResult> Edit(string id, [Bind("TerritoryId,TerritoryDescription,RegionId")] Territories territories) { if (id != territories.TerritoryId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(territories); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TerritoriesExists(territories.TerritoryId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["RegionId"] = new SelectList(_context.Region, "RegionId", "RegionDescription", territories.RegionId); return(View(territories)); }
public void addTerritory() { Territories territory = new Territories("98101", "neka teritorija", 3); index = repo.addTerritory(territory); Assert.IsNotNull(index); }
private Territories BuscarTerritory(string valor) { Territories ret = null; DataRow[] rows = territories.Select(String.Format("TerritoryID='{0}'", valor)); if (rows == null) { rows = territories.Select(String.Format("TerritoryDescription='{0}'", valor)); } if (rows != null) { DataRow row = rows[0]; ret = new Territories() { TerritoryID = (string)row["TerritoryID"], TerritoryDescription = (string)row["TerritoryDescription"], RegionID = (int)row["RegionID"], Region = solRegions.BuscarId((int)row["RegionID"]) }; } return(ret); }
public void BorrarTerritory(string valor) { Territories t = BuscarTerritory(valor); dao.Delete(t, connstr); CargarTerritories(); }
///<summary> /// Update the Typed Territories Entity with modified mock values. ///</summary> public static void UpdateMockInstance(TransactionManager tm, Territories mock) { TerritoriesTest.UpdateMockInstance_Generated(tm, mock); // make any alterations necessary // (i.e. for DB check constraints, special test cases, etc.) SetSpecialTestData(mock); }
public ActionResult DeleteConfirmed(string id) { Territories territories = db.Territories.Find(id); db.Territories.Remove(territories); db.SaveChanges(); return(RedirectToAction("Index")); }
private void button1_Click(object sender, EventArgs e) { Territories territory = new Territories("98200", "Regulary", 3); TerritoriesRepository repo = new TerritoriesRepository(); string res = repo.addTerritory(territory); Console.WriteLine(res); }
public void DeleteTerritory(Territories territoryToDelete) { if (territoryToDelete == null) { throw new ArgumentNullException(nameof(territoryToDelete)); } _context.Remove(territoryToDelete); }
public async void AddTerritory(Territories territoryToAdd) { if (territoryToAdd == null) { throw new ArgumentNullException(nameof(territoryToAdd)); } await _context.AddAsync(territoryToAdd); }
private void btnIngresar_Click(object sender, EventArgs e) { //Validación. errorTerritorio.Clear();//Limpiar Errores. bError = false; if (String.IsNullOrWhiteSpace(txtID.Text)) { setError(txtID, "Rellenar código de Territorio"); } string id = txtID.Text; bool existeId = db.Territories.Where(t => t.TerritoryID.Equals(id)).Any(); if (existeId) { setError(txtID, "El código del territorio ya existe."); } string Nombre = txtNombre.Text; if (string.IsNullOrWhiteSpace(Nombre)) { setError(txtNombre, "Rellenar el nombre del territorio."); } bool existeTerritorio = db.Territories.Where(t => t.TerritoryDescription.Equals(Nombre)).Any(); if (existeTerritorio) { setError(txtNombre, "Este territorio ya fue registrado."); } if (bError) { return; } // Consultar registro. var territorio = new Territories { TerritoryID = id.ToString(), TerritoryDescription = Nombre, RegionID = (int)cboRegion.SelectedValue, }; db.Territories.InsertOnSubmit(territorio); try { //Insertar registro en base datos. db.SubmitChanges(); //Listar registros. Listar(); Limpiar(); } catch (Exception ex) { MessageBox.Show("Ocurrió un error."); } }
public TerritoriesProxyStub Territories_GetByPrimaryKey(System.String territoryID) { Territories obj = new Territories(); if (obj.LoadByPrimaryKey(territoryID)) { return(obj); } return(null); }
public void Edit(Territories territories) { if (territories == null) { throw new ArgumentNullException(nameof(territories)); } _territoriesRepository.Update(territories); _eventPublisher.EntityUpdated(territories); }
public void Create(Territories territories) { if (territories == null) { throw new ArgumentNullException(nameof(territories)); } _territoriesRepository.Insert(territories); _eventPublisher.EntityInserted(territories); }
public Territory GetTerritory(Location location) { try { return(Territories.Single(t => t.Location == location)); } catch (Exception ex) { throw new TerritoryNotFoundException($"{location} does not exist in the Board", ex); } }
public ActionResult Edit([Bind(Include = "TerritoryID,TerritoryDescription,RegionID")] Territories territories) { if (ModelState.IsValid) { db.Entry(territories).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RegionID = new SelectList(db.Region, "RegionID", "RegionDescription", territories.RegionID); return(View(territories)); }
private void OnLanguage(SaintCoinach.Ex.Language newLanguage) { Realm.GameData.ActiveLanguage = newLanguage; OnPropertyChanged(() => IsEnglish); OnPropertyChanged(() => IsJapanese); OnPropertyChanged(() => IsGerman); OnPropertyChanged(() => IsFrench); Equipment.Refresh(); Territories.Refresh(); }
public ActionResult Create([Bind(Include = "TerritoryID,TerritoryDescription,RegionID")] Territories territories) { if (ModelState.IsValid) { db.Territories.Add(territories); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RegionID = new SelectList(db.Region, "RegionID", "RegionDescription", territories.RegionID); return(View(territories)); }
public IEnumerable <Territory> GetContinent(Territory territory) { var l = territory.Location; var neighborLocations = new[] { new Location(l.Row + 1, l.Column), new Location(l.Row, l.Column - 1), new Location(l.Row, l.Column + 1), new Location(l.Row - 1, l.Column), }; return(Territories.Where(t => neighborLocations.Contains(t.Location))); }
public Territories Save(Territories entity) { if(entity.Id ==0 ) { var ret = this.context.Territories.Add(entity); this.context.SaveChanges(); return ret; } else { var data = GetById(entity.Id); data.Name = entity.Name; data.Region = entity.Region; data.RegionID = entity.RegionID; this.context.SaveChanges(); return data; } }
///<summary> /// Returns a Typed Territories Entity with mock values. ///</summary> public static Territories CreateMockInstance_Generated(TransactionManager tm) { Territories mock = new Territories(); mock.TerritoryId = TestUtility.Instance.RandomString(9, false);; mock.TerritoryDescription = TestUtility.Instance.RandomString(24, false);; int count0 = 0; TList<Region> _collection0 = DataRepository.RegionProvider.GetPaged(tm, 0, 10, out count0); //_collection0.Shuffle(); if (_collection0.Count > 0) { mock.RegionId = _collection0[0].RegionId; } // create a temporary collection and add the item to it TList<Territories> tempMockCollection = new TList<Territories>(); tempMockCollection.Add(mock); tempMockCollection.Remove(mock); return (Territories)mock; }
/// <summary> /// Create a new Territories object. /// </summary> /// <param name="territoryDescription">Initial value of TerritoryDescription.</param> /// <param name="territoryID">Initial value of TerritoryID.</param> public static Territories CreateTerritories(string territoryDescription, string territoryID) { Territories territories = new Territories(); territories.TerritoryDescription = territoryDescription; territories.TerritoryID = territoryID; return territories; }
/// <summary> /// Test methods exposed by the EntityHelper class. /// </summary> private void Step_20_TestEntityHelper_Generated() { using (TransactionManager tm = CreateTransaction()) { mock = CreateMockInstance(tm); Territories entity = mock.Copy() as Territories; entity = (Territories)mock.Clone(); Assert.IsTrue(Territories.ValueEquals(entity, mock), "Clone is not working"); } }
///<summary> /// Update the Typed Territories Entity with modified mock values. ///</summary> public static void UpdateMockInstance_Generated(TransactionManager tm, Territories mock) { mock.TerritoryDescription = TestUtility.Instance.RandomString(24, false);; int count0 = 0; TList<Region> _collection0 = DataRepository.RegionProvider.GetPaged(tm, 0, 10, out count0); //_collection0.Shuffle(); if (_collection0.Count > 0) { mock.RegionId = _collection0[0].RegionId; } }
/// <summary> /// Make any alterations necessary (i.e. for DB check constraints, special test cases, etc.) /// </summary> /// <param name="mock">Object to be modified</param> private static void SetSpecialTestData(Territories mock) { //Code your changes to the data object here. }
/// <summary> /// Serialize a Territories collection into a temporary file. /// </summary> private void Step_08_SerializeCollection_Generated() { using (TransactionManager tm = CreateTransaction()) { string fileName = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp_TerritoriesCollection.xml"); mock = CreateMockInstance(tm); TList<Territories> mockCollection = new TList<Territories>(); mockCollection.Add(mock); EntityHelper.SerializeXml(mockCollection, fileName); Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock collection not found"); System.Console.WriteLine("TList<Territories> correctly serialized to a temporary file."); } }
public static Territories CreateTerritories(string territoryID, int regionID) { Territories territories = new Territories(); territories.TerritoryID = territoryID; territories.RegionID = regionID; return territories; }
private void detach_Territories(Territories entity) { this.SendPropertyChanging(); entity.Region = null; }
partial void DeleteTerritories(Territories instance);
partial void UpdateTerritories(Territories instance);
partial void InsertTerritories(Territories instance);
/// <summary> /// Delete the mock Territories entity into the database. /// </summary> private void Step_05_Delete_Generated() { using (TransactionManager tm = CreateTransaction()) { mock = (Territories)CreateMockInstance(tm); DataRepository.TerritoriesProvider.Insert(tm, mock); Assert.IsTrue(DataRepository.TerritoriesProvider.Delete(tm, mock), "Delete failed."); System.Console.WriteLine("DataRepository.TerritoriesProvider.Delete(mock):"); System.Console.WriteLine(mock); //normally one would commit here //tm.Commit(); //IDisposable will Rollback Transaction since it's left uncommitted } }
/// <summary> /// Serialize the mock Territories entity into a temporary file. /// </summary> private void Step_06_SerializeEntity_Generated() { using (TransactionManager tm = CreateTransaction()) { mock = CreateMockInstance(tm); string fileName = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp_Territories.xml"); EntityHelper.SerializeXml(mock, fileName); Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock not found"); System.Console.WriteLine("mock correctly serialized to a temporary file."); } }
/// <summary> /// There are no comments for Territories in the schema. /// </summary> public void AddToTerritories(Territories territories) { base.AddObject("Territories", territories); }
/// <summary> /// Deep load all Territories children. /// </summary> private void Step_03_DeepLoad_Generated() { using (TransactionManager tm = CreateTransaction()) { int count = -1; mock = CreateMockInstance(tm); mockCollection = DataRepository.TerritoriesProvider.GetPaged(tm, 0, 10, out count); DataRepository.TerritoriesProvider.DeepLoading += new EntityProviderBaseCore<Territories, TerritoriesKey>.DeepLoadingEventHandler( delegate(object sender, DeepSessionEventArgs e) { if (e.DeepSession.Count > 3) e.Cancel = true; } ); if (mockCollection.Count > 0) { DataRepository.TerritoriesProvider.DeepLoad(tm, mockCollection[0]); System.Console.WriteLine("Territories instance correctly deep loaded at 1 level."); mockCollection.Add(mock); // DataRepository.TerritoriesProvider.DeepSave(tm, mockCollection); } //normally one would commit here //tm.Commit(); //IDisposable will Rollback Transaction since it's left uncommitted } }