public static User GetUser(int id) { using (ProgramsEntities ctx = new ProgramsEntities()) { return(ctx.User.Single(u => u.Uid == id)); } }
public static IEnumerable <User> GetAll() { using (ProgramsEntities ctx = new ProgramsEntities()) { return(ctx.User.ToList()); } }
public static void AddUser(User user) { using (ProgramsEntities ctx = new ProgramsEntities()) { ctx.User.Add(user); ctx.SaveChanges(); } }
public static void DeleteUser(int id) { using (ProgramsEntities ctx = new ProgramsEntities()) { User userToRemove = ctx.User.Single(u => u.Uid == id); ctx.User.Remove(userToRemove); ctx.SaveChanges(); } }
public static string GenerateCppFile() { try { ProgramsEntities context = new ProgramsEntities(); string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); string file = path + @"\TestFile.cpp"; TextWriter tw = new StreamWriter(file, true); tw.WriteLine(context.Programs.FirstOrDefault().ProgramText); tw.Close(); return(path); } catch (Exception e) { return(e.Message); } }