public User Register(User user) { using (var context = DataContextHelper.GetPPDataContext()) { context.Insert(user); return(user); } }
public User Login(string email, string password) { using (var context = DataContextHelper.GetPPDataContext()) { var ppSql = PetaPoco.Sql.Builder.Select("*").From("Users").Where("Email = @0 AND Password = @1 AND IsActive = 1", email, password); return(context.Fetch <User>(ppSql).FirstOrDefault()); } }