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));
}
