private static ClanWarPick ConvertViewToModel(ClanWarPickViewModel viewModel)
{
ClanWarPick model = new ClanWarPick();
model.id = viewModel.Id ?? 0;
model.clanWarId = viewModel.ClanWarId;
model.clanMemberWarPosition = viewModel.ClanMemberWarPosition;
model.clanUserId = viewModel.ClanUserId;
model.pickVS = viewModel.PickVS;
model.note = viewModel.Note;
model.addedOn = viewModel.AddedOn;
model.updatedOn = viewModel.UpdatedOn;
return(model);
}
public static void UpdateMemberWarPosition(string[] sortedPicks)
{
string idParsed = string.Empty;
using (var dbContext = new HouseOfClansEntities())
{
for (short i = 0; i < sortedPicks.Length; i++)
{
idParsed = sortedPicks[i].Replace(_clanWarPickSortedName, "");
ClanWarPick pick = new ClanWarPick()
{
id = int.Parse(idParsed),
clanMemberWarPosition = (short)(i + 1),
updatedOn = DateTime.Now
};
dbContext.ClanWarPicks.Attach(pick);
dbContext.Entry(pick).Property(p => p.clanMemberWarPosition).IsModified = true;
dbContext.Entry(pick).Property(p => p.updatedOn).IsModified = true;
dbContext.SaveChanges();
}
}
}
/// <summary>
/// Inserts or Updates the Clan War Picks depending on the parameters received.
/// </summary>
/// <param name="clanWarPickViewModel">A ClanWarPickViewModel object, if its Id is NULL then do an Insert, else Updates.</param>
public static void Upsert(List <ClanWarPickViewModel> clanWarPicksList)
{
using (var dbContext = new HouseOfClansEntities())
{
foreach (ClanWarPickViewModel pick in clanWarPicksList)
{
ClanWarPick clanWarPick = ClanWarPicksManager.ConvertViewToModel(pick);
if (pick.Id == null)
{
clanWarPick.addedOn = DateTime.Now;
dbContext.ClanWarPicks.Add(clanWarPick);
}
else
{
clanWarPick.updatedOn = DateTime.Now;
dbContext.Entry(clanWarPick).State = EntityState.Modified;
dbContext.Entry(clanWarPick).Property(p => p.clanMemberWarPosition).IsModified = false;
}
dbContext.SaveChanges();
}
}
}
