/* Award AddAward(int playId, int festivalId, int categoryId, int userId);
List<AwardMixedDTO> SearchAwards(AwardsSearchingCriteria criteria, int pageNr, int pageAmount)
public ListResponse<ModuleDto> GetModules(SingleRequest request)
{
//Warning: unbound list read from db, do not do this at home!
return ListResponse.Create(request,
InTransaction(tc => tc.Entities.ModuleInstances.Include(mi => mi.ModuleDef).ToList()
.Select(_moduleAssembler.ToSimpleDto).ToList()));
}
*/
//public string GetData(int value)
//{
// return string.Format("You entered: {0}", value);
//}
//public CompositeType GetDataUsingDataContract(CompositeType composite)
//{
// if (composite == null)
// {
// throw new ArgumentNullException("composite");
// }
// if (composite.BoolValue)
// {
// composite.StringValue += "Suffix";
// }
// return composite;
//}
#region Awards
public SingleItemResponse<AwardDataDTO> AddAward(AwardDataDTO newAward)
{
var newAwardFull = new Award()
{
CategoryId = newAward.CategoryId,
PlayId = newAward.PlayId,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
context.Awards.Add(newAwardFull);
context.SaveChanges();
int id = newAwardFull.AwardId;
return GetAward(id);
}
catch (Exception ex)
{
throw;
}
}
}
public Award(Award award)
{
AwardId = award.AwardId;
CategoryId = award.CategoryId;
PlayId = award.PlayId;
EditDate = award.EditDate;
EditedBy = award.EditedBy;
}
public AwardEditViewModel(Award editedAward,List<int> festivalsList, ObservableCollection<Category> categoriesList)
{
FestivalsList = festivalsList;
CategoriesList = categoriesList;
originalAward = editedAward;
var l = new List<Play>();
l.Add(editedAward.Play);
PlaysList = l;
EditedAward = new Award(editedAward);
}
public async Task AddAward(int playId, int categoryId, int userId)
{
var a = new Award()
{
CategoryId = categoryId,
PlayId = playId,
EditedBy = userId,
EditDate = DateTime.Now
};
await DataAccess.AddAward(a);
}
// AF_Context context = new AF_Context();
#region Award
public async Task AddAward(Award newAward)
{
using (var context = new AF_Context())
{
try
{
context.Awards.Add(newAward);
int recordsAffected = await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
}
public async Task UpdateAward(Award updateData)
{
using (var context = new AF_Context())
{
try
{
/*Award awa = await (from a in context.Awards
where a.AwardId == updateData.AwardId
select a).ToListAsync();*/
Award awa = context.Awards.First(a => a.AwardId == updateData.AwardId);
context.Entry(awa).CurrentValues.SetValues(updateData);
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
}
public Award UpdateAward(Award updateData)
{
throw new NotImplementedException();
}
public AwardWindow(Award award, List<int> festivalsList, ObservableCollection<Category> categoriesList)
{
AEViewModel = new AwardEditViewModel(award, festivalsList, categoriesList);
InitializeComponent();
}
public AwardEditViewModel(List<int> festivalsList, ObservableCollection<Category> categoriesList)
{
FestivalsList = festivalsList;
CategoriesList = categoriesList;
EditedAward = new Award();
}
public SingleItemResponse<AwardDataDTO> UpdateAward(AwardDataDTO updateData)
{
var updateDataFull = new Award()
{
AwardId = updateData.AwardId,
CategoryId = updateData.CategoryId,
PlayId = updateData.PlayId,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
Award awa = context.Awards.First(a => a.AwardId == updateData.AwardId);
context.Entry(awa).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.AwardId;
return GetAward(id);
}
catch (Exception ex)
{
throw;
}
}
}
public async Task UpdateAward(Award updateData)
{
var a = new Award(updateData);
a.EditDate = DateTime.Now;
await DataAccess.UpdateAward(a);
}
