Exemplo n.º 1
0
        public IHttpActionResult PuttblMatch(int id, tblMatch tblMatch)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tblMatch.Id)
            {
                return(BadRequest());
            }

            db.Entry(tblMatch).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!tblMatchExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Exemplo n.º 2
0
        public IHttpActionResult GettblMatch(int id)
        {
            tblMatch tblMatch = db.tblMatches.Find(id);

            if (tblMatch == null)
            {
                return(NotFound());
            }

            return(Ok(tblMatch));
        }
Exemplo n.º 3
0
        public IHttpActionResult PosttblMatch(tblMatch tblMatch)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.tblMatches.Add(tblMatch);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = tblMatch.Id }, tblMatch));
        }
Exemplo n.º 4
0
        public static int Delete(Guid id)
        {
            using (BoBEntities bob = new BoBEntities())
            {
                tblMatch row = bob.tblMatches.FirstOrDefault(m => m.Id == id);

                if (row != null)
                {
                    bob.tblMatches.Remove(row);
                }
                return(bob.SaveChanges());
            }
        }
Exemplo n.º 5
0
        public IHttpActionResult DeletetblMatch(int id)
        {
            tblMatch tblMatch = db.tblMatches.Find(id);

            if (tblMatch == null)
            {
                return(NotFound());
            }

            db.tblMatches.Remove(tblMatch);
            db.SaveChanges();

            return(Ok(tblMatch));
        }
Exemplo n.º 6
0
 public static int Update(Match match)
 {
     using (BoBEntities bob = new BoBEntities())
     {
         tblMatch row = bob.tblMatches.FirstOrDefault(m => m.Id == match.Id);
         if (row != null)
         {
             row.Team1           = match.Player1.Id;
             row.Team2           = match.Player2.Id;
             row.Outcome         = match.Winner.Id;
             row.ReportingPlayer = match.ReportingPlayer.Id;
             row.Round           = match.Round;
             row.Division        = match.Division;
         }
         return(bob.SaveChanges());
     }
 }
Exemplo n.º 7
0
 public static Match LoadById(Guid id)
 {
     using (BoBEntities bob = new BoBEntities())
     {
         tblMatch row = bob.tblMatches.FirstOrDefault(m => m.Id == id);
         return(new Match
         {
             Id = row.Id,
             Player1 = UserManager.LoadById(row.Team1),
             Player2 = UserManager.LoadById(row.Team2),
             Winner = UserManager.LoadById(row.Outcome),
             BracketId = row.BracketId,
             ReportingPlayer = UserManager.LoadById(row.ReportingPlayer),
             Round = row.Round,
             Division = row.Division
         });
     }
 }
Exemplo n.º 8
0
 public static int Insert(Match match, Guid bracketid)
 {
     using (BoBEntities bob = new BoBEntities())
     {
         tblMatch row = new tblMatch
         {
             Id              = Guid.NewGuid(),
             Team1           = match.Player1.Id,
             Team2           = match.Player2.Id,
             Outcome         = match.Winner.Id,
             BracketId       = bracketid,
             ReportingPlayer = match.ReportingPlayer.Id,
             Round           = match.Round,
             Division        = match.Division
         };
         match.Id = row.Id;
         bob.tblMatches.Add(row);
         return(bob.SaveChanges());
     }
 }