// GET: /Play/Details/5
public ActionResult Details(int? id)
{
using (var context = new AF_Context())
{
var play = (from p in context.Plays select p).FirstOrDefault(p => p.PlayId == id);
if (play == null)
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
var data = new PlayCastDTO(play);
data.Helpers = (from pjob in context.RelationsPersonPlayJob select pjob)
.Where(pjob => pjob.PlayId == data.PlayId)
.Include(pjob => pjob.Person)
.Include(pjob => pjob.Job)
.OrderBy(pjob => pjob.JobId)
.ToList()
.Select(PersonFunctionDTO.FromJobEntity);
data.Cast = (from prole in context.RelationsPersonPlayRole select prole)
.Where(prole => prole.PlayId == data.PlayId)
.Include(prole => prole.Person)
.OrderBy(prole => prole.RelationPersonPlayRoleId)
.ToList()
.Select(PersonFunctionDTO.FromRoleEntity);
return View(data);
}
}
/* 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 async Task<ActionResult> Index()
{
using (var context = new AF_Context())
{
var festivals = (from ft in context.Festivals select ft.FestivalId).ToArrayAsync();
return View(await festivals);
}
}
// 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<Award> GetAward(int id)
{
using (var context = new AF_Context())
{
try
{
//Category cat = await Task.Run<Category>(() => context.Categories.First(c => c.CategoryId == id));
Award awa = context.Awards.First(a => a.CategoryId == id);
awa.Editor = context.Users.First(u => u.UserId == awa.EditedBy);
return (awa);
}
catch (Exception ex)
{
throw ex;
}
return null;
}
}
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 async Task RemoveAward(int id)
{
using (var context = new AF_Context())
{
try
{
/*List<Award> awa = await (from a in context.Awards
where a.AwardId == id
select a).ToListAsync();*/
Award awa = context.Awards.First(a => a.AwardId == id);
context.Awards.Remove(awa);
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
}
public override void Validate(string userName, string password)
{
using (var context = new AF_Context())
{
const string pepper = "50.L1`(f761OJdG6fc835M(5(+Ju2!P6,4330_N*/%xz<j7(N15KC'8l997'0c0CEg";
ICryptoService cryptoService = new PBKDF2();
try
{
User u = context.Users.FirstOrDefault(c => c.Login == userName);
if (u == null)
throw new SecurityTokenException("Wrong Username or Password");
bool verified = cryptoService.Compare(cryptoService.Compute(cryptoService.Compute(password, u.Salt), pepper), u.Password);
if (!verified)
throw new SecurityTokenException("Wrong Username or Password");
}
catch (Exception ex)
{
throw;
}
}
}
static void Main(string[] args)
{
string pass = "";
int id=0;
ICryptoService cryptoService = new PBKDF2();
const string pepper = "50.L1`(f761OJdG6fc835M(5(+Ju2!P6,4330_N*/%xz<j7(N15KC'8l997'0c0CEg";
Console.WriteLine("Select user by id:");
if (int.TryParse(Console.ReadLine(),out id))
{
using (var context = new AF_Context())
{
try
{
User user = context.Users.First(u => u.UserId == id);
if (user != null)
{
while (string.IsNullOrEmpty(pass))
{
Console.WriteLine("Input Password:");
pass = Console.ReadLine();
}
user.Salt = cryptoService.GenerateSalt();
user.Password = cryptoService.Compute(cryptoService.Compute(pass, user.Salt), pepper);
}
context.SaveChanges();
}
catch (Exception e)
{
throw;
}
}
}
}
// GET: /Festival/Details/5
public ActionResult Details(int? id)
{
using (var context = new AF_Context())
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
var skip = 0;//pageAmount * (pageNr - 1);
int pageAmount = 100;
var query = (from p in context.Plays select p).Where(p => p.FestivalId == id);
if (query == null)
{
return HttpNotFound();
}
List<PlayDataDTO> tmp = new List<PlayDataDTO>();
foreach (Play pla in (query.OrderBy(p => p.FestivalId)
.ThenBy(p => p.Day)
.ThenBy(p => p.Order)
.Skip(skip)
.Take(pageAmount)))
{
var newPlayDto = new PlayDataDTO()
{
PlayId = pla.PlayId,
Title = pla.Title,
Author = pla.Author,
FestivalId = pla.FestivalId,
Day = pla.Day,
Order = pla.Order,
PlayedBy = pla.PlayedBy,
Motto = pla.Motto
};
tmp.Add(newPlayDto);
}
return View(tmp);
}
}
// GET: /Play/
public ActionResult Index()
{
using (var context = new AF_Context())
{
//var plays = context.Plays;//.Include(p => p.Editor).Include(p => p.Festival);
//return View(plays.ToList());
var skip = 0;//pageAmount * (pageNr - 1);
int pageAmount = 100;
var query = (from p in context.Plays select p);
if (query == null)
{
return HttpNotFound();
}
List<PlayDataDTO> tmp = new List<PlayDataDTO>();
foreach (Play pla in (query.OrderBy(p => p.FestivalId)
.ThenBy(p => p.Day)
.ThenBy(p => p.Order)
.Skip(skip)
.Take(pageAmount)))
{
var newPlayDto = new PlayDataDTO()
{
PlayId = pla.PlayId,
Title = pla.Title,
Author = pla.Author,
FestivalId = pla.FestivalId,
Day = pla.Day,
Order = pla.Order,
PlayedBy = pla.PlayedBy,
Motto = pla.Motto
};
tmp.Add(newPlayDto);
}
return View(tmp);
}
}
// GET: /Festival/
public ActionResult Index()
{
//var festivals = db.Festivals.Include(f => f.Editor);
//return View(festivals.ToList());
using (var context = new AF_Context())
{
var skip = 0;//pageAmount * (pageNr - 1);
int pageAmount = 100;
List<FestivalDTO> tmp = new List<FestivalDTO>();
foreach (Festival fe in (from f in context.Festivals//.Include(u => u.Editor)
select f).OrderBy(f => f.Year).Skip(skip).Take(pageAmount))
{
var newFestivalDto = new FestivalDTO()
{
FestivalId = fe.FestivalId,
Year = fe.Year,
BeginningDate = fe.BeginningDate,
EndDate = fe.EndDate
};
tmp.Add(newFestivalDto);
}
return View(tmp);
}
}
public ListResponse<JobDTO> GetAllJobs()
{
using (var context = new AF_Context())
{
try
{
List<JobDTO> tmp = new List<JobDTO>();
foreach (Job jo in from j in context.Jobs select j)
{
var newJobDto = new JobDTO()
{
JobId = jo.JobId,
JobTitle = jo.JobTitle
};
tmp.Add(newJobDto);
}
return (new ListResponse<JobDTO>(tmp));
}
catch (Exception ex)
{
throw;
}
return null;
}
}
private int GetUserId()
{
string login = ServiceSecurityContext.Current.PrimaryIdentity.Name;
using (var context = new AF_Context())
{
try
{
User us = context.Users.First(u => u.Login == login);
return (us.UserId);
}
catch (Exception ex)
{
throw;
}
}
}
public ActionResult Edit(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
using (var context = new AF_Context())
{
Festival fes = context.Festivals.Find(id);
if (fes == null)
{
return HttpNotFound();
}
var newFestivalDto = new FestivalDTO()
{
FestivalId = fes.FestivalId,
Year = fes.Year,
BeginningDate = fes.BeginningDate,
EndDate = fes.EndDate,
};
//ViewBag.EditedBy = new SelectList(db.Users, "UserId", "Login", play.EditedBy);
//ViewBag.FestivalId = new SelectList(db.Festivals, "FestivalId", "FestivalId", play.FestivalId);
return View(newFestivalDto);
}
}
public SingleItemResponse<PlayDataDTO> GetPlay(int id)
{
using (var context = new AF_Context())
{
try
{
Play pla = context.Plays.First(p => p.PlayId == id);
var newPlayDto = new PlayDataDTO()
{
PlayId = pla.PlayId,
Title = pla.Title,
Author = pla.Author,
FestivalId = pla.FestivalId,
Day = pla.Day,
Order = pla.Order,
PlayedBy = pla.PlayedBy,
Motto = pla.Motto
};
return (new SingleItemResponse<PlayDataDTO>(newPlayDto));
}
catch (Exception ex)
{
throw;
}
}
}
public ListResponse<UserDTO> GetAllUsers()
{
using (var context = new AF_Context())
{
try
{
List<UserDTO> tmp = new List<UserDTO>();
foreach (User a in (from u in context.Users select u))
{
var newUserDto = new UserDTO()
{
UserId = a.UserId,
Login = a.Login,
FirstName = a.FirstName,
LastName = a.LastName,
Email = a.Email
};
tmp.Add(newUserDto);
}
return (new ListResponse<UserDTO>(tmp));
}
catch (Exception ex)
{
throw;
}
}
}
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 SingleItemResponse<JobDTO> UpdateJob(JobDTO updateData)
{
var updateDataFull = new Job()
{
JobId = updateData.JobId,
JobTitle = updateData.JobTitle,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
Job jo = context.Jobs.First(j => j.JobId == updateData.JobId);
context.Entry(jo).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.JobId;
return GetJob(id);
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse<PositionDTO> UpdatePosition(PositionDTO updateData)
{
var updateDataFull = new Position()
{
PositionId = updateData.PositionId,
PositionTitle = updateData.PositionTitle,
Section = updateData.Section,
Order = updateData.Order,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
Position pos = context.Positions.First(p => p.PositionId == updateData.PositionId);
context.Entry(pos).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.PositionId;
return GetPosition(id);
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse<PositionDTO> GetPosition(int id)
{
using (var context = new AF_Context())
{
try
{
Position pos = context.Positions.First(p => p.PositionId == id);
//awa.Editor = context.Users.First(u => u.UserId == awa.EditedBy);
var newPositionDto = new PositionDTO()
{
PositionId = pos.PositionId,
PositionTitle = pos.PositionTitle,
Section = pos.Section,
Order = pos.Order
};
return (new SingleItemResponse<PositionDTO>(newPositionDto));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse<PlayDataDTO> AddPlay(PlayDataDTO newPlay)
{
var newPlayFull = new Play()
{
Title = newPlay.Title,
Author = newPlay.Author,
FestivalId = newPlay.FestivalId,
Day = newPlay.Day,
Order = newPlay.Order,
PlayedBy = newPlay.PlayedBy,
Motto = newPlay.Motto,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
context.Plays.Add(newPlayFull);
context.SaveChanges();
int id = newPlayFull.PlayId;
return GetPlay(id);
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse<PlayTitleDTO> GetPlayTitle(int id)
{
using (var context = new AF_Context())
{
try
{
Play pla = context.Plays.First(p => p.PlayId == id);
var newPlayDto = new PlayTitleDTO()
{
PlayId = pla.PlayId,
Title = pla.Title,
};
return (new SingleItemResponse<PlayTitleDTO>(newPlayDto));
}
catch (Exception ex)
{
throw;
}
}
}
public ListResponse<PlayTitleDTO> SearchPlaysTitles(PlaysSearchingCriteria criteria, int pageNr, int pageAmount)
{
using (var context = new AF_Context())
{
try
{
var skip = pageAmount * (pageNr - 1);
var query = (from p in context.Plays select p);
if (criteria.FestivalIdFilter != null)
query = query.Where(p => p.FestivalId == criteria.FestivalIdFilter);
if (!String.IsNullOrEmpty(criteria.Author))
query = query.Where(p => p.Author.Contains(criteria.Author));
if (!String.IsNullOrEmpty(criteria.Title))
query = query.Where(p => p.Title.Contains(criteria.Title));
if (!String.IsNullOrEmpty(criteria.Motto))
query = query.Where(p => p.Motto.Contains(criteria.Motto));
List<PlayTitleDTO> tmp = new List<PlayTitleDTO>();
foreach (Play pla in (query.OrderBy(p => p.FestivalId)
.ThenBy(p => p.Day)
.ThenBy(p => p.Order)
.Skip(skip)
.Take(pageAmount)))
{
var newPlayDto = new PlayTitleDTO()
{
PlayId = pla.PlayId,
Title = pla.Title,
};
tmp.Add(newPlayDto);
}
return (new ListResponse<PlayTitleDTO>(tmp));
}
catch (Exception ex)
{
throw;
}
}
}
public ActionResult Create([Bind(Include = "FestivalId,Year,BeginningDate,EndDate")] FestivalDTO updateData)
{
if (ModelState.IsValid)
{
var updateDataFull = new Festival()
{
//FestivalId = updateData.FestivalId,
Year = updateData.Year,
BeginningDate = updateData.BeginningDate,
EndDate = updateData.EndDate,
EditedBy = 1,//GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
context.Festivals.Add(updateDataFull);
context.SaveChanges();
return RedirectToAction("Index");
}
}
//ViewBag.EditedBy = new SelectList(db.Users, "UserId", "Login", play.EditedBy);
//ViewBag.FestivalId = new SelectList(db.Festivals, "FestivalId", "FestivalId", play.FestivalId);
return View(updateData);
}
public ListResponse<PositionDTO> GetAllPositions()
{
using (var context = new AF_Context())
{
try
{
List<PositionDTO> tmp = new List<PositionDTO>();
foreach (Position pos in context.Positions.OrderBy(s => s.Section).ThenBy(o => o.Order))
{
var newPositionDto = new PositionDTO()
{
PositionId = pos.PositionId,
PositionTitle = pos.PositionTitle,
Section = pos.Section,
Order = pos.Order
};
tmp.Add(newPositionDto);
}
return (new ListResponse<PositionDTO>(tmp));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse<JobDTO> GetJob(int id)
{
using (var context = new AF_Context())
{
try
{
Job jo = context.Jobs.First(j => j.JobId == id);
var newJobDto = new JobDTO()
{
JobId = jo.JobId,
JobTitle = jo.JobTitle
};
return (new SingleItemResponse<JobDTO>(newJobDto));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse<UserDTO> GetUser(int id)
{
using (var context = new AF_Context())
{
try
{
User us = context.Users.First(u => u.UserId == id);
var newUserDto = new UserDTO()
{
UserId = us.UserId,
Login = us.Login,
FirstName = us.FirstName,
LastName = us.LastName,
Email = us.Email
};
return (new SingleItemResponse<UserDTO>(newUserDto));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse<PositionDTO> AddPosition(PositionDTO newPosition)
{
var newPositionFull = new Position()
{
PositionTitle = newPosition.PositionTitle,
Section = newPosition.Section,
Order = newPosition.Order,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
context.Positions.Add(newPositionFull);
context.SaveChanges();
int id = newPositionFull.PositionId;
return GetPosition(id);
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse<PlayDataDTO> UpdatePlay(PlayDataDTO updateData)
{
var updateDataFull = new Play()
{
PlayId = updateData.PlayId,
Title = updateData.Title,
Author = updateData.Author,
FestivalId = updateData.FestivalId,
Day = updateData.Day,
Order = updateData.Order,
PlayedBy = updateData.PlayedBy,
Motto = updateData.Motto,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
Play pla = context.Plays.First(p => p.PlayId == updateData.PlayId);
context.Entry(pla).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.PlayId;
return GetPlay(id);
}
catch (Exception ex)
{
throw;
}
}
}
