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