/// <summary> /// Sets the status activity modified field /// </summary> /// <param name="activityModified">The activity modified being set</param> public static void setStatusActivityModified(DateTime activityModified) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(activityModified.ToString()).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Sets the status kidIdentifier field /// </summary> /// <param name="kidIdentifier">The kidIdentifier being set</param> public static void setStatusKidIdentifier(string kidIdentifier) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(kidIdentifier).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Sets the status active field /// </summary> /// <param name="active">The active being set</param> public static void setStatusActive(string active) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(active).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Returns a list of all the statuses /// </summary> /// <returns>list of statuses</returns> public static List <Status> getAllStatuses() { using (OCRCDbContext db = new OCRCDbContext()) { List <Status> statuses = db.Statuses.ToList(); return(statuses); } }
/// <summary> /// Returns the notes by it's id /// </summary> /// <param name="id">the id that's being searched on</param> /// <returns>The note being searched for</returns> public static Notes findNoteById(int?id) { using (OCRCDbContext db = new OCRCDbContext()) { Notes note = db.Notes.Find(id); return(note); } }
/// <summary> /// Sets the ranking sport type field /// </summary> /// <param name="sportType">The sport type</param> public static void setRankingSportType(string sportType) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(sportType).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Returns the status by it's id /// </summary> /// <param name="id">the id that's being searched on</param> /// <returns>The status being searched for</returns> public static Status findStatusById(int?id) { using (OCRCDbContext db = new OCRCDbContext()) { Status status = db.Statuses.Find(id); return(status); } }
/// <summary> /// Sets the ranking date created field /// </summary> /// <param name="dateCreated">The date that it was created</param> public static void setRankingDateCreated(DateTime dateCreated) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(dateCreated.ToString()).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Adds a ranking to the database /// </summary> /// <param name="ranking">The ranking being added</param> public static void addRanking(Ranking ranking) { using (OCRCDbContext db = new OCRCDbContext()) { db.Rankings.Add(ranking); db.SaveChanges(); } }
/// <summary> /// Returns a list of all the rankings /// </summary> /// <returns>list of rankings</returns> public static List <Ranking> getAllRankings() { using (OCRCDbContext db = new OCRCDbContext()) { List <Ranking> rankings = db.Rankings.ToList(); return(rankings); } }
/// <summary> /// Returns the ranking by it's id /// </summary> /// <param name="id">the id that's being searched on</param> /// <returns>The ranking being searched for</returns> public static Ranking findRankingById(int?id) { using (OCRCDbContext db = new OCRCDbContext()) { Ranking ranking = db.Rankings.Find(id); return(ranking); } }
/// <summary> /// Returns the user by it's id /// </summary> /// <param name="id">the id that's being searched on</param> /// <returns>The user being searched for</returns> public static User findUserById(int?id) { using (OCRCDbContext db = new OCRCDbContext()) { User user = db.Users.Find(id); return(user); } }
/// <summary> /// Adds a note to the database /// </summary> /// <param name="note">The note being added</param> public static void addNote(Notes note) { using (OCRCDbContext db = new OCRCDbContext()) { db.Notes.Add(note); db.SaveChanges(); } }
public static void setToken(string token) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(token).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Sets the user team identifier /// </summary> /// <param name="teamIdentifier">The teamIdentifier being set</param> public static void setUserTeamIdentifier(string teamIdentifier) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(teamIdentifier).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Sets the user password /// </summary> /// <param name="password">The password being set</param> public static void setUserPassword(string password) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(password).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Sets the user access level /// </summary> /// <param name="accesslvl">The accesslvl being set</param> public static void setUserAccesslvl(string accesslvl) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(accesslvl).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Returns a list of all the notes /// </summary> /// <returns>list of notes</returns> public static List <Notes> getAllNotes() { using (OCRCDbContext db = new OCRCDbContext()) { List <Notes> notes = db.Notes.ToList(); return(notes); } }
/// <summary> /// Sets the user last name /// </summary> /// <param name="lname">The last name being set</param> public static void setUserLName(string lname) { using (OCRCDbContext db = new OCRCDbContext()) { db.Entry(lname).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Returns a list of all the users /// </summary> /// <returns>list of users</returns> public static List <User> getAllUsers() { using (OCRCDbContext db = new OCRCDbContext()) { List <User> users = db.Users.ToList(); return(users); } }
public static void addStatus(Status status) { try { using (OCRCDbContext db = new OCRCDbContext()) { db.Statuses.Add(status); db.SaveChanges(); } } catch (Exception e) { throw; } }
public static PasswordReset findTokenByEmail(String userEmail) { try { using (OCRCDbContext db = new OCRCDbContext()) { var token = db.PasswordResets.Where(it => it.email == userEmail).FirstOrDefault(); return(token); } } catch (Exception) { throw; } }
public static User findUserByEmail(String userEmail) { try { using (OCRCDbContext db = new OCRCDbContext()) { var user = db.Users.Where(it => it.email == userEmail).FirstOrDefault(); return(user); } } catch (Exception) { throw; } }
public static ReturnResult AddUser(User user) { try { using (OCRCDbContext db = new OCRCDbContext()) { ReturnResult rr = new ReturnResult(); rr.data = db.Users.Add(user); //we could check this line to see if the command was successful rr.returnCode = 0; db.SaveChanges(); return(rr); } } catch (Exception e) { return(new ReturnResult(ReturnCode.FAILURE, e.Message)); } }