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