public TerritoryDTO GetTerritoryById(int p_id)
{
TerritoryDTO Territory;
string sql = "SELECT * FROM Territorys WHERE TerritoryId = @id";
using (SqlConnection sqlCon = new SqlConnection(_connectionString))
{
sqlCon.Open();
using (SqlCommand sqlCmd = new SqlCommand(sql, sqlCon))
{
sqlCmd.Parameters.Add("@id", SqlDbType.Int).Value = p_id;
SqlDataReader rdr = sqlCmd.ExecuteReader();
if (rdr.Read())
{
int id = rdr.GetInt32(0);
string type = rdr.GetString(1);
int owner = rdr.GetInt32(2);
Territory = new TerritoryDTO(id, type, owner);
}
else
{
Territory = new TerritoryDTO();
}
};
sqlCon.Close();
};
return(Territory);
}
public TerritoryDTO GetTerritoryById(int id)
{
var territory = businessManager.GetTerritory(id);
TerritoryDTO territoryDTO = new TerritoryDTO()
{
Owner = territory.Owner.FirstName + " " + territory.Owner.LastName,
TerritoryType = territory.TerritoryType.ToString()
};
return(territoryDTO);
}
// PUT: api/Territories/{id}
public IHttpActionResult Put(int id, [FromBody] TerritoryDTO value)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
ThronesTournamentManager m = new ThronesTournamentManager();
m.UpdateTerritory(value.Transform());
return(Ok());
}
public IHttpActionResult GetTerritoryById(int id)
{
TerritoryDTO Territory = GameManager.Instance.GetTerritoryById(id);
if (Territory.Id == -1)
{
return(NotFound());
}
else
{
return(Ok(Territory));
}
}
public IHttpActionResult PutTerritory(TerritoryDTO territory)
{
Territory territoryPut = db.Territories.FirstOrDefault(s => s.TerritoryID == territory.TerritoryID);
territoryPut.TerritoryID = territory.TerritoryID;
territoryPut.TerritoryDescription = territory.TerritoryDescription;
territoryPut.RegionID = territory.RegionID;
if (db.SaveChanges() > 0)
{
return(Ok());
}
else
{
return(InternalServerError());
}
}
public void AddTerritory(TerritoryDTO Territory)
{
string sql = "INSERT INTO Territories(TerritoryType, OwnerId) Values(@TerritoryType, @OwnerId)";
using (SqlConnection sqlCon = new SqlConnection(_connectionString))
{
sqlCon.Open();
using (SqlCommand sqlCmd = new SqlCommand(sql, sqlCon))
{
sqlCmd.Parameters.Add("@TerritoryType", SqlDbType.VarChar).Value = Territory.Type;
sqlCmd.Parameters.Add("@OwnerId", SqlDbType.Int).Value = Territory.Owner;
sqlCmd.ExecuteNonQuery();
};
sqlCon.Close();
};
}
public IHttpActionResult GetTerritoryById(string id)
{
TerritoryDTO getId = db.Territories.Where(p => p.TerritoryID == id).Select(e => new TerritoryDTO()
{
TerritoryID = e.TerritoryID,
TerritoryDescription = e.TerritoryDescription,
RegionID = e.RegionID
}).FirstOrDefault();
if (getId != null)
{
return(Ok(getId));
}
else
{
return(NotFound());
}
}
public void EditTerritory(TerritoryDTO Territory)
{
string sql = "UPDATE Territorys SET TerritoryType = @TerritoryType, OwnerId = @OwnerId WHERE TerritoryId = @id";
using (SqlConnection sqlCon = new SqlConnection(_connectionString))
{
sqlCon.Open();
using (SqlCommand sqlCmd = new SqlCommand(sql, sqlCon))
{
sqlCmd.Parameters.Add("@TerritoryType", SqlDbType.VarChar).Value = Territory.Type;
sqlCmd.Parameters.Add("@OwnerId", SqlDbType.Int).Value = Territory.Owner;
sqlCmd.Parameters.Add("@id", SqlDbType.Int).Value = Territory.Id;
sqlCmd.ExecuteNonQuery();
};
sqlCon.Close();
};
}
public IHttpActionResult PostNewTerritory(TerritoryDTO territory)
{
Territory territoryInsert = new Territory()
{
TerritoryID = territory.TerritoryID,
TerritoryDescription = territory.TerritoryDescription,
RegionID = territory.RegionID
};
db.Territories.Add(territoryInsert);
if (db.SaveChanges() > 0)
{
return(Ok());
}
else
{
return(InternalServerError());
}
}
public Territory Map(TerritoryDTO dto)
{
if (dto == null) return null;
var territory = Mapper.Map<TerritoryDTO, Territory>(dto);
return territory;
}
public IHttpActionResult PutTerritory([FromBody] TerritoryDTO Territory)
{
GameManager.Instance.EditTerritory(Territory);
return(Ok());
}
public void AddTerritory(TerritoryDTO Territory)
{
bddInterf.AddTerritory(Territory);
}
public TerritoryDTO GetTerritoryById(int id)
{
TerritoryDTO territory = new TerritoryDTO(businessManager.GetTerritoryById(id));
return(territory);
}
public TerritoryModel(TerritoryDTO territoryDTO)
{
ID = territoryDTO.ID;
ID_House = territoryDTO.ID_House;
ID_Type = territoryDTO.ID_Type;
}
public void AddTerritory(TerritoryDTO Territory)
{
DalManager.Instance.AddTerritory(Territory);
}
public void EditTerritory(TerritoryDTO Territory)
{
DalManager.Instance.EditTerritory(Territory);
}
public void EditTerritory(TerritoryDTO Territory)
{
bddInterf.EditTerritory(Territory);
}
