public async Task <IActionResult> PutCustomList(int id, ViewCustomList viewModel)
{
if (id != viewModel.ListId)
{
return(BadRequest());
}
var tempEquipment = _context.Equipment.ToList();
var championId = _context.Champion.Where(champion => champion.Name == viewModel.ChampionName).FirstOrDefault().ChampionId;
Nullable <int> tempE1Id = 0;
Nullable <int> tempE2Id = 0;
Nullable <int> tempE3Id = 0;
Nullable <int> tempE4Id = 0;
Nullable <int> tempE5Id = 0;
Nullable <int> tempE6Id = 0;
if (viewModel.EquipmentName1.Length != 0 && tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName1).FirstOrDefault() != null)
{
tempE1Id = tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName1).FirstOrDefault().EquipmentId;
}
else
{
tempE1Id = null;
}
if (viewModel.EquipmentName2.Length != 0 && tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName2).FirstOrDefault() != null)
{
tempE2Id = tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName2).FirstOrDefault().EquipmentId;
}
else
{
tempE2Id = null;
}
if (viewModel.EquipmentName3.Length != 0 && tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName3).FirstOrDefault() != null)
{
tempE3Id = tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName3).FirstOrDefault().EquipmentId;
}
else
{
tempE3Id = null;
}
if (viewModel.EquipmentName4.Length != 0 && tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName4).FirstOrDefault() != null)
{
tempE4Id = tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName4).FirstOrDefault().EquipmentId;
}
else
{
tempE4Id = null;
}
if (viewModel.EquipmentName5.Length != 0 && tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName5).FirstOrDefault() != null)
{
tempE5Id = tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName5).FirstOrDefault().EquipmentId;
}
else
{
tempE5Id = null;
}
if (viewModel.EquipmentName6.Length != 0 && tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName6).FirstOrDefault() != null)
{
tempE6Id = tempEquipment.Where(equipment => equipment.Name == viewModel.EquipmentName6).FirstOrDefault().EquipmentId;
}
else
{
tempE6Id = null;
}
CustomList customList = new CustomList
{
ListId = viewModel.ListId,
Name = viewModel.Name,
UserId = "50",
ChampionId = championId,
EquipmentId1 = tempE1Id,
EquipmentId2 = tempE2Id,
EquipmentId3 = tempE3Id,
EquipmentId4 = tempE4Id,
EquipmentId5 = tempE5Id,
EquipmentId6 = tempE6Id
};
_context.Entry(customList).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomListExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
//public async Task<ActionResult<IEnumerable<CustomList>>> GetCustomList()
//{
// return await _context.CustomList.ToListAsync();
//}
public ActionResult <List <ViewCustomList> > GetCustomList()
{
var tempCustomList = _context.CustomList.ToList();
var tempEquipment = _context.Equipment.ToList();
var tempChampions = _context.Champion.ToList();
var TempEquipmentName1 = (string)null;
var TempEquipmentName2 = (string)null;
var TempEquipmentName3 = (string)null;
var TempEquipmentName4 = (string)null;
var TempEquipmentName5 = (string)null;
var TempEquipmentName6 = (string)null;
var customLists = new List <ViewCustomList>();
foreach (var custList in tempCustomList)
{
if (custList.EquipmentId1 != null)
{
TempEquipmentName1 = tempEquipment.Where(Equipment => custList.EquipmentId1 == Equipment.EquipmentId).FirstOrDefault().Name;
}
if (custList.EquipmentId2 != null)
{
TempEquipmentName2 = tempEquipment.Where(Equipment => custList.EquipmentId2 == Equipment.EquipmentId).FirstOrDefault().Name;
}
if (custList.EquipmentId3 != null)
{
TempEquipmentName3 = tempEquipment.Where(Equipment => custList.EquipmentId3 == Equipment.EquipmentId).FirstOrDefault().Name;
}
if (custList.EquipmentId4 != null)
{
TempEquipmentName4 = tempEquipment.Where(Equipment => custList.EquipmentId4 == Equipment.EquipmentId).FirstOrDefault().Name;
}
if (custList.EquipmentId5 != null)
{
TempEquipmentName5 = tempEquipment.Where(Equipment => custList.EquipmentId5 == Equipment.EquipmentId).FirstOrDefault().Name;
}
if (custList.EquipmentId6 != null)
{
TempEquipmentName6 = tempEquipment.Where(Equipment => custList.EquipmentId6 == Equipment.EquipmentId).FirstOrDefault().Name;
}
ViewCustomList temp = new ViewCustomList
{
ListId = custList.ListId,
Name = custList.Name,
ChampionName = tempChampions.Where(Champion => custList.ChampionId == Champion.ChampionId).FirstOrDefault().Name,
EquipmentName1 = TempEquipmentName1,
EquipmentName2 = TempEquipmentName2,
EquipmentName3 = TempEquipmentName3,
EquipmentName4 = TempEquipmentName4,
EquipmentName5 = TempEquipmentName5,
EquipmentName6 = TempEquipmentName6,
};
customLists.Add(temp);
TempEquipmentName1 = (string)null;
TempEquipmentName2 = (string)null;
TempEquipmentName3 = (string)null;
TempEquipmentName4 = (string)null;
TempEquipmentName5 = (string)null;
TempEquipmentName6 = (string)null;
}
;
return(customLists);
}
//public async Task<ActionResult<CustomList>> GetCustomList(int id)
//{
// var customList = await _context.CustomList.FindAsync(id);
// if (customList == null)
// {
// return NotFound();
// }
// return customList;
//}
public async Task <ActionResult <ViewCustomList> > GetCustomList(int id)
{
var customList = await _context.CustomList.FindAsync(id);
if (customList == null)
{
return(NotFound());
}
var tempEquipment = _context.Equipment.ToList();
var tempChampions = _context.Champion.ToList();
var TempEquipmentName1 = (string)null;
var TempEquipmentName2 = (string)null;
var TempEquipmentName3 = (string)null;
var TempEquipmentName4 = (string)null;
var TempEquipmentName5 = (string)null;
var TempEquipmentName6 = (string)null;
if (customList.EquipmentId1 != null)
{
TempEquipmentName1 = tempEquipment.Where(Equipment => customList.EquipmentId1 == Equipment.EquipmentId).FirstOrDefault().Name;
}
else
{
TempEquipmentName1 = "None";
}
if (customList.EquipmentId2 != null)
{
TempEquipmentName2 = tempEquipment.Where(Equipment => customList.EquipmentId2 == Equipment.EquipmentId).FirstOrDefault().Name;
}
else
{
TempEquipmentName2 = "None";
}
if (customList.EquipmentId3 != null)
{
TempEquipmentName3 = tempEquipment.Where(Equipment => customList.EquipmentId3 == Equipment.EquipmentId).FirstOrDefault().Name;
}
else
{
TempEquipmentName3 = "None";
}
if (customList.EquipmentId4 != null)
{
TempEquipmentName4 = tempEquipment.Where(Equipment => customList.EquipmentId4 == Equipment.EquipmentId).FirstOrDefault().Name;
}
else
{
TempEquipmentName4 = "None";
}
if (customList.EquipmentId5 != null)
{
TempEquipmentName5 = tempEquipment.Where(Equipment => customList.EquipmentId5 == Equipment.EquipmentId).FirstOrDefault().Name;
}
else
{
TempEquipmentName5 = "None";
}
if (customList.EquipmentId6 != null)
{
TempEquipmentName6 = tempEquipment.Where(Equipment => customList.EquipmentId6 == Equipment.EquipmentId).FirstOrDefault().Name;
}
else
{
TempEquipmentName6 = "None";
}
ViewCustomList ViewModel = new ViewCustomList
{
ListId = customList.ListId,
Name = customList.Name,
ChampionName = tempChampions.Where(Champion => customList.ChampionId == Champion.ChampionId).FirstOrDefault().Name,
EquipmentName1 = TempEquipmentName1,
EquipmentName2 = TempEquipmentName2,
EquipmentName3 = TempEquipmentName3,
EquipmentName4 = TempEquipmentName4,
EquipmentName5 = TempEquipmentName5,
EquipmentName6 = TempEquipmentName6,
};
return(ViewModel);
}
