public async Task <T> Update(DbSet <T> pTable, pneContext pContext, T pUser) { pTable.Update(pUser); await pContext.SaveChangesAsync(); return(pUser); }
public async Task <ActionResult <T1> > Update([FromServices] pneContext pContext, [FromBody] T1 pObject) { if (ModelState.IsValid) { string sPropertyName = typeof(T1).ToString().Split('.')[typeof(T1).ToString().Split('.').Length - 1]; return(await((GenericModel <T1>)Activator.CreateInstance(typeof(T2))).Update((DbSet <T1>)pContext.GetType().GetProperty(sPropertyName).GetValue(pContext), pContext, pObject)); } else { return(BadRequest(ModelState)); } }
public async Task <List <Ranking> > GetCalculatedRanking(pneContext pContext, String nickname = null) { string sQuery = "select us.nickname as nickname, sum (trp.points ) as points, " + "max(trp.created_at ) as last_active_date, us.name as name, us.cellphone as phone, " + "ROW_NUMBER() OVER ( order by sum(trp.points) desc, max(trp.created_at) asc ) as position " + "from tbl_ranking_px trp " + "inner join tbl_user us on trp.id_user =us.id "; if (nickname != null) { sQuery += " where us.nickname = '" + nickname + "' "; } sQuery += "group by us.name,us.nickname,us.cellphone "; List <Ranking> pRankingList = new List <Ranking>(); using (var command = pContext.Database.GetDbConnection().CreateCommand()) { command.CommandText = sQuery; pContext.Database.OpenConnection(); using (var result = await command.ExecuteReaderAsync()) { while (result.Read()) { Ranking pRanking = new Ranking(); pRanking.Nickname = result["nickname"].ToString(); pRanking.Name = result["name"].ToString(); if (nickname != null) { pRanking.Phone = result["phone"].ToString(); pRanking.LastActiveDate = (DateTime)result["last_active_date"]; } pRanking.Points = (decimal)result["points"]; pRanking.Position = (Int64)result["position"]; pRankingList.Add(pRanking); } } } return(pRankingList); }
public async Task <ActionResult <TblUser> > ForgotPassword([FromServices] pneContext pContext, [FromBody] TblUser pUser) { return(await new User().ForgotPassword(pContext.TblUser, pUser.Cellphone, pUser.Cpf, (DateTime)pUser.Birthday)); }
public async Task <ActionResult <TblUser> > Login([FromServices] pneContext pContext, [FromBody] TblUser pUser) { return(await new User().Login(pContext.TblUser, pUser.Cellphone, pUser.Password)); }
public async Task <ActionResult <List <TblTrip> > > GetUserTrips([FromServices] pneContext pContext, int id) { return(await new Trip().GetTripsById(pContext.TblTrip, id)); }
public async Task <ActionResult <T1> > Get([FromServices] pneContext pContext, int id) { string sPropertyName = typeof(T1).ToString().Split('.')[typeof(T1).ToString().Split('.').Length - 1]; return(await((GenericModel <T1>)Activator.CreateInstance(typeof(T2))).Get((DbSet <T1>)pContext.GetType().GetProperty(sPropertyName).GetValue(pContext), id)); }
public async Task <ActionResult <List <Ranking> > > GetCalculatedRanking([FromServices] pneContext pContext, String nickname) { return(await new RankingPX().GetCalculatedRanking(pContext, nickname)); }
public async Task <ActionResult <List <TblRankingPx> > > GetTripStopsById([FromServices] pneContext pContext, int id) { return(await new RankingPX().GetPointsByTripId(pContext.TblRankingPx, id)); }