public static User GetUserById(int id) { try { using (CalendarEntities calendar = new CalendarEntities()) { return(calendar.Users.FirstOrDefault(u => u.UserId == id)); } } catch { throw; } }
public static List <User> GetUsers() { try { using (CalendarEntities calendar = new CalendarEntities()) { return(calendar.Users.ToList()); } } catch { throw; } }
public static User AddNewUser(User user) { try { using (CalendarEntities calendar = new CalendarEntities()) { calendar.Users.Add(user); calendar.SaveChanges(); return(user); } } catch { throw; } }
public static int DeleteUser(int id) { try { using (CalendarEntities calendar = new CalendarEntities()) { var user = calendar.Users.FirstOrDefault(u => u.UserId == id); if (user != null) { calendar.Users.Remove(user); calendar.SaveChanges(); return(user.UserId); } return(-1); } } catch { throw; } }