/// <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 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();
}
}
public static void setToken(string token)
{
using (OCRCDbContext db = new OCRCDbContext())
{
db.Entry(token).State = EntityState.Modified;
db.SaveChanges();
}
}
/// <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>
/// 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 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>
/// 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 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>
/// 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>
/// 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 addStatus(Status status)
{
try
{
using (OCRCDbContext db = new OCRCDbContext())
{
db.Statuses.Add(status);
db.SaveChanges();
}
}
catch (Exception e)
{
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));
}
}
