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