// if the user exists and is valid, return the user, else return null internal static RewardDefinition getRewardDefinition(Guid defid) { DBClassesDataContext dbc = new DBClassesDataContext(); RewardDefinition ach = (from u in dbc.RewardDefinitions where u.RewardID == defid select u).SingleOrDefault(); return(ach); }
internal static void delete(Guid achID) { using (DBClassesDataContext dbc = new DBClassesDataContext()) { RewardDefinition ach = (from u in dbc.RewardDefinitions where u.RewardID == achID select u).SingleOrDefault(); if (ach != null) { dbc.RewardDefinitions.DeleteOnSubmit(ach); dbc.SubmitChanges(); } } }
// if the user exists and is valid, return the user, else return null public static ArrayList getRewardsForPilot(String pilotid) { ArrayList classes = new ArrayList(); using (DBClassesDataContext dbc = new DBClassesDataContext()) { IEnumerable <PilotReward> ach = (from u in dbc.PilotRewards where u.PilotEmail == pilotid select u); foreach (PilotReward pc in ach) { RewardDefinition pcd = RewardDefinition.getRewardDefinition(pc.RewardID); if (pcd != null) { classes.Add(pcd); } } } return(classes); }