public async Task <IActionResult> Put(int id, FactionDTO faction)
{
if (id != faction.Id)
{
return(BadRequest());
}
var _faction = await _context.Factions
.Include(p => p.Campaign)
.Include(p => p.Country)
.Include(p => p.Coalition)
.FirstOrDefaultAsync(p => p.Id == id);
_faction.Name = faction.Name;
_faction.Campaign = await _context.Campaigns.FirstOrDefaultAsync(p => p.Id == faction.CampaignId);
_faction.Coalition = await _context.Coalitions.FirstOrDefaultAsync(p => p.Id == faction.CoalitionId);
_faction.Country = await _context.Countries.FirstOrDefaultAsync(p => p.Id == faction.CountryId);
_faction.Budget = faction.Budget;
_context.Factions.Update(_faction);
await _context.SaveChangesAsync();
return(NoContent());
}
public void CreateWargear(string wargearName, FactionDTO faction, List <WeaponCategoryDTO> wargearCategories)
{
if (Exits(wargearName) == false)
{
IwargearContext.CreateWargear(wargearName);
}
IwargearContext.CreateWargearFaction(wargearName, faction);
foreach (var VARIABLE in wargearCategories)
{
IwargearContext.CreateWargearFactionWeaponCategory(wargearName, faction, VARIABLE);
}
}
public List <WargearDTO> GetAllWargear()
{
List <WargearDTO> wargears = new List <WargearDTO>();
using (SqlConnection conn = new SqlConnection(connenctionString))
{
using (SqlCommand command = new SqlCommand("SELECT Wargear_Faction.WargearFactionID, WargearName, Wargear_Faction.FactionID, FactionName, AmmountTotal, WeaponCategory.WeaponCategoryID, WeaponCategory.WeaponCategoryName From Wargear_Faction INNER JOIN Wargear ON Wargear_Faction.WargearID = Wargear.WargearID INNER JOIN Faction ON Wargear_Faction.FactionID = Faction.FactionID INNER JOIN Wargear_Faction_WeaponCategory on Wargear_Faction.WargearFactionID = Wargear_Faction_WeaponCategory.WargearFactionID INNER JOIN WeaponCategory on Wargear_Faction_WeaponCategory.WeaponCatagoryID = WeaponCategory.WeaponCategoryID", conn))
{
conn.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
WargearDal wargearDal = new WargearDal();
while (reader.Read())
{
List <WeaponCategoryDTO> weaponCategory = new List <WeaponCategoryDTO>();
int id = reader.GetInt32(0);
if (wargearDal.WargearID == id)
{
wargearDal.AddWeaponCategoryDTO(new WeaponCategoryDTO(reader.GetInt32(5), reader.GetString(6)));
}
else
{
if (wargearDal.WargearID != 0)
{
wargears.Add(wargearDal);
}
string name = reader.GetString(1);
FactionDTO faction = new FactionDTO(reader.GetInt32(2), reader.GetString(3));
int total;
if (!reader.IsDBNull(4))
{
total = reader.GetInt32(4);
}
else
{
total = 0;
}
weaponCategory.Add(new WeaponCategoryDTO(reader.GetInt32(5), reader.GetString(6)));
wargearDal = new WargearDal(id, name, total, faction, weaponCategory);
}
}
wargears.Add(wargearDal);
}
conn.Close();
}
}
return(wargears);
}
public void CreateWargearFaction(string wargearName, FactionDTO faction)
{
using (SqlConnection conn = new SqlConnection(connenctionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO dbo.Wargear_Faction(WargearID, FactionID) VALUES ((select WargearID FROM Wargear Where WargearName = @WargearName), @FactionID)", conn))
{
command.Parameters.AddWithValue("@WargearName", wargearName);
command.Parameters.AddWithValue("@FactionID", faction.FactionId);
command.ExecuteNonQuery();
conn.Close();
}
}
}
public async Task <ActionResult <FactionDTO> > Post(FactionDTO faction)
{
var _faction = new Faction {
Name = faction.Name,
Campaign = await _context.Campaigns.FirstOrDefaultAsync(p => p.Id == faction.CampaignId),
Coalition = await _context.Coalitions.FirstOrDefaultAsync(p => p.Id == faction.CoalitionId),
Country = await _context.Countries.FirstOrDefaultAsync(p => p.Id == faction.CountryId),
Budget = faction.Budget
};
await _context.Factions.AddAsync(_faction);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(Get), new { id = _faction.Id }, faction));
}
public void UpdateFaction(FactionDTO faction)
{
string query = "UPDATE dbo.Faction SET FactionName = @FactionName Where FactionID = @FactionId";
using (SqlConnection conn = new SqlConnection(connenctionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(query, conn))
{
command.Parameters.AddWithValue("@FactionId", faction.FactionId);
command.Parameters.AddWithValue("@FactionName", faction.FactionName);
command.ExecuteNonQuery();
conn.Close();
}
}
}
public void CreateWargearFactionWeaponCategory(string wargearName, FactionDTO faction, WeaponCategoryDTO weaponCategory)
{
using (SqlConnection conn = new SqlConnection(connenctionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(
"INSERT INTO dbo.Wargear_Faction_WeaponCategory(WargearFactionID, WeaponCatagoryID) VALUES((select WargearFactionID From Wargear_Faction Where WargearID = (select WargearID FROM Wargear Where WargearName = @WargearName) and FactionID = @FactionID), @WeaponCategoryID )",
conn))
{
command.Parameters.AddWithValue("@WargearName", wargearName);
command.Parameters.AddWithValue("@FactionID", faction.FactionId);
command.Parameters.AddWithValue("@WeaponCategoryID", weaponCategory.WeaponCategoryId);
command.ExecuteNonQuery();
conn.Close();
}
}
}
public FactionDTO GetFactionName(string name)
{
FactionDTO faction = null;
using (SqlConnection conn = new SqlConnection(connenctionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM Faction Where FactionName = @FactionName", conn))
{
command.Parameters.AddWithValue("@FactionName", name);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
faction = new FactionDTO(reader.GetInt32(0), reader.GetString(1));
}
}
conn.Close();
}
}
return(faction);
}
public IActionResult CreateWargear()
{
//TODO. Check if code is in correct Layer.
List <WeaponCategoryDTO> weaponCategory = new List <WeaponCategoryDTO>();
foreach (WeaponCategoryDTO VARweaponCategory in weaponCategoryCollection.GetAllWeaponCategorys())
{
if (VARweaponCategory.WeaponCategoryName == Convert.ToString(HttpContext.Request.Form["weaponCategoryName"]))
{
weaponCategory.Add(VARweaponCategory);
}
}
FactionDTO faction = new FactionDTO();
foreach (FactionDTO Varfaction in factionCollection.GetAllFactions())
{
if (Varfaction.FactionName == Convert.ToString(HttpContext.Request.Form["factionName"]))
{
faction = Varfaction;
}
}
wargearInventory.CreateWargear(Convert.ToString(HttpContext.Request.Form["wargearName"]), faction, weaponCategory);
return(RedirectToAction("Wargear", "Home"));
}
public WargearDal(int wargearId, string wargearName, int ammountTotal, FactionDTO factionBelongTo, List <WeaponCategoryDTO> weaponCategories) : base(wargearId, wargearName, ammountTotal, factionBelongTo, weaponCategories)
{
}
public FactionLogic(FactionDTO factionDto)
{
this.FactionId = factionDto.FactionId;
this.FactionName = factionDto.FactionName;
}
public void CreateWargear(string wargearName, FactionDTO faction, List <WeaponCategoryDTO> wargearCategories)
{
wargearRepository.CreateWargear(wargearName, faction, wargearCategories);
}
public void UpdateFaction(FactionDTO faction)
{
factioncContext.UpdateFaction(faction);
}
public FactionModel(FactionDTO factionDto)
{
FactionId = factionDto.FactionId;
FactionName = factionDto.FactionName;
}
