public HttpResponseMessage Post(int compId, string userName, [FromBody] TblCompetitorsClimb value)
{
value.Paid = false;
value.CompetitionId = compId;
string accountId = CompetitionDB.Users.FirstOrDefault(x => x.UserName == userName).Id;
value.UserId = CompetitionDB.TblUsers.FirstOrDefault(x => x.UserId == accountId).Id;
value.Paid = false;
CompetitionDB.TblCompetitorsClim.Add(value);
CompetitionDB.SaveChanges();
List <RouteClimbModel> routes = CompetitionDB.TblRoutesClim.ToArray().Where(x => x.CompetitionId == compId && x.Type == "ATRANKA").Select(x => new RouteClimbModel(x)).ToList();
TblJudgesPaperClim paper = new TblJudgesPaperClim();
foreach (RouteClimbModel r in routes)
{
paper.JudgeId = 0;
paper.RouteId = r.Id;
paper.TopAttempt = 0;
paper.BonusAttempt = 0;
paper.ClimberId = CompetitionDB.TblUsers.FirstOrDefault(x => x.UserId == accountId).Id;
paper.Date = DateTime.Now;
paper.TypeId = 0;
CompetitionDB.TblJudgesPapersClimb.Add(paper);
CompetitionDB.SaveChanges();
}
return(ToJsonCreated(CompetitionDB.SaveChanges()));
}
public CompetitorsClimModel(TblCompetitorsClimb row)
{
Id = row.Id;
CompId = row.CompetitionId;
ClimberId = row.UserId;
Group = row.Group;
Paid = row.Paid;
}
public HttpResponseMessage Put(int id)
{
TblCompetitorsClimb value = CompetitionDB.TblCompetitorsClim.Find(id);
value.Paid = true;
CompetitionDB.Entry(value).State = EntityState.Modified;
return(ToJsonOK(CompetitionDB.SaveChanges()));
}
public HttpResponseMessage Post(int compId, int id)
{
TblCompetitorsClimb value = new TblCompetitorsClimb();
value.Paid = false;
value.CompetitionId = compId;
value.UserId = id;
int dateYear = 0;
int dateNow = 0;
if (CompetitionDB.TblUsers.Find(id).BirthYear.ToString().Length == 22)
{
dateYear = Convert.ToInt32(CompetitionDB.TblUsers.Find(id).BirthYear.ToString().Substring(6, 4));
}
else if (CompetitionDB.TblUsers.Find(id).BirthYear.ToString().Length == 20)
{
dateYear = Convert.ToInt32(CompetitionDB.TblUsers.Find(id).BirthYear.ToString().Substring(4, 4));
}
else
{
dateYear = Convert.ToInt32(CompetitionDB.TblUsers.Find(id).BirthYear.ToString().Substring(5, 4));
}
if (DateTime.Now.ToString().Length == 22)
{
dateNow = Convert.ToInt32(DateTime.Now.ToString().Substring(6, 4));
}
else if (DateTime.Now.ToString().Length == 20)
{
dateNow = Convert.ToInt32(DateTime.Now.ToString().Substring(4, 4));
}
else if (DateTime.Now.ToString().Length == 21)
{
dateNow = Convert.ToInt32(DateTime.Now.ToString().Substring(5, 4));
}
if ((dateNow - dateYear) > 17)
{
value.Group = "JAUNIMAS";
}
else if ((dateNow - dateYear) > 15)
{
value.Group = "JAUNIAI";
}
else if ((dateNow - dateYear) > 13)
{
value.Group = "JAUNUOLIAI";
}
else if ((dateNow - dateYear) > 11)
{
value.Group = "JAUNUČIAI";
}
else
{
value.Group = "VAIKAI";
}
CompetitionDB.TblCompetitorsClim.Add(value);
List <RouteClimbModel> routes = CompetitionDB.TblRoutesClim.ToArray().Where(x => x.CompetitionId == compId && x.Type == value.Group).Select(x => new RouteClimbModel(x)).ToList();
TblJudgesPaperClim paper = new TblJudgesPaperClim();
foreach (RouteClimbModel r in routes)
{
paper.JudgeId = 0;
paper.RouteId = r.Id;
paper.TopAttempt = 0;
paper.BonusAttempt = 0;
paper.ClimberId = id;
paper.Date = DateTime.Now;
paper.TypeId = 0;
CompetitionDB.TblJudgesPapersClimb.Add(paper);
CompetitionDB.SaveChanges();
}
return(ToJsonCreated(CompetitionDB.SaveChanges()));
}
