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
}
}
