public static void Create(Priority p)
{
var db = new TicketingSystemDBContext();
db.Priorities.Add(p);
db.SaveChanges();
}
public static void Delete(Priority p)
{
var db = new TicketingSystemDBContext();
db.Entry(p).State = EntityState.Deleted;
db.SaveChanges();
}
/// <summary>
/// Adds the user passed in to the database
/// </summary>
/// <param name="user">User to be added to the database</param>
public static void Add(User user)
{
var db = new TicketingSystemDBContext();
db.Users.Add(user);
db.SaveChanges();
}
public static void Delete(Role role)
{
var db = new TicketingSystemDBContext();
db.Roles.Remove(role);
db.SaveChanges();
}
public static void Add(Role role)
{
var db = new TicketingSystemDBContext();
db.Roles.Add(role);
db.SaveChanges();
}
/// <summary>
/// Deletes the User passed in from the database
/// </summary>
/// <param name="user">User to be deleted</param>
public static void Delete(User user)
{
var db = new TicketingSystemDBContext();
db.Users.Remove(user);
db.SaveChanges();
}
public static void Update(Ticket t)
{
var db = new TicketingSystemDBContext();
db.Entry(t).State = EntityState.Modified;
db.SaveChanges();
}
public static void Create(Ticket t)
{
var db = new TicketingSystemDBContext();
db.Users.Attach(t.User);
db.Priorities.Attach(t.Priority);
db.Tickets.Add(t);
db.SaveChanges();
}
/// <summary>
/// Returns the user with the current name and password
/// </summary>
/// <param name="Username">Username to be found</param>
/// <param name="Password">Password to be found </param>
/// <returns></returns>
public static User FindUser(string Username, string Password)
{
// stores our dbcontext "our tracker" for our database into a variable so can act upon it.
var db = new TicketingSystemDBContext();
// we can omit the where clause as single or default implicitly should only return 1 result
User userLoginCheck = db.Users
.Include("Role")
.Where(currUser => currUser.Username == Username && currUser.Password == Password)
.SingleOrDefault();
return(userLoginCheck);
}
/// <summary>
/// Updates the User passed in by userID
/// </summary>
/// <param name="user"></param>
/// <returns>Returns true if User with the UserID is in Users table</returns>
public static bool Update(User user)
{
var db = new TicketingSystemDBContext();
User u = db.Users.Find(user.UserID);
if (u == null)
{
return(false);
}
else
{
u.Username = user.Username;
u.Password = user.Password;
u.FirstName = user.FirstName;
u.LastName = user.LastName;
u.AssignedTickets = user.AssignedTickets;
u.Role = user.Role;
db.SaveChanges();
return(true);
}
}
public static bool Update(Role role)
{
var db = new TicketingSystemDBContext();
Role r = db.Roles.Find(role.RoleID);
if (r == null)
{
return(false);
}
else
{
r.Level = role.Level;
r.Name = role.Name;
r.IsTechnician = role.IsTechnician;
r.CanDeleteTickets = role.CanDeleteTickets;
r.CanChangePriority = role.CanChangePriority;
r.CanAssignTickets = role.CanAssignTickets;
r.CanEditRoles = role.CanEditRoles;
r.CanEditUsers = role.CanEditUsers;
db.SaveChanges();
return(true);
}
}
public static User GetUser(string username)
{
var db = new TicketingSystemDBContext();
return(db.Users.Where(u => u.Username.Contains(username)).Single());
}
// takes in a user object/context object which points to
public static void RegisterUser(User regUser)
{
var db = new TicketingSystemDBContext();
db.Users.Add(regUser);
}
