public static tb_Usuario AchouUsuario(NickUsuario oUsuario) { using (United_BDEntities oDB = Helper.DataBaseHelper.getDataContext()) { var Res = from p in oDB.tb_Usuario where p.USR_Nick == oUsuario.USR_Nick select p; return(Res.FirstOrDefault()); } }
public static void Alterar(tb_Usuario aUsuario) { using (United_BDEntities oDB = Helper.DataBaseHelper.getDataContext()) { oDB.Entry(aUsuario).State = System.Data.Entity.EntityState.Modified; oDB.SaveChanges(); } }
public static void Incluir(tb_Usuario atb_Usuario) { using (United_BDEntities oDB = Helper.DataBaseHelper.getDataContext()) { oDB.tb_Usuario.Add(atb_Usuario); oDB.SaveChanges(); } }
public static void Incluir(tb_Feedback atb_Feedback) { using (United_BDEntities oDB = Helper.DataBaseHelper.getDataContext()) { oDB.tb_Feedback.Add(atb_Feedback); oDB.SaveChanges(); } }
public static List <tb_Score> AchouLevelArcade(string Level) { using (United_BDEntities oDB = Helper.DataBaseHelper.getDataContext()) { var Res = from p in oDB.tb_Score where p.SCR_Level == Level orderby p.SCR_Score descending select p; return(Res.Take(100).ToList()); } }
public static NickUsuario AchouUsuarioExistente(string nick) { using (United_BDEntities oDB = Helper.DataBaseHelper.getDataContext()) { var Res = from p in oDB.tb_Usuario where p.USR_Nick == nick select p.USR_Nick; NickUsuario oNick = new NickUsuario(); oNick.USR_Nick = Res.FirstOrDefault(); return(oNick); } }