public List <Users> GetAllUsers() { using (BackingShareContext db = new BackingShareContext()) { List <Users> dbUsers = db.Users.ToList(); return(dbUsers); } }
public void Create(ProjectsModel projectModel) { using (BackingShareContext db = new BackingShareContext()) { Projects dbProject = new Projects() { name = projectModel.name, isPublic = projectModel.isPublic, userId = projectModel.userId }; db.Projects.Add(dbProject); db.SaveChanges(); } }
public User GetUserByUsername(string username) { using (BackingShareContext db = new BackingShareContext()) { var userDb = db.Users.FirstOrDefault(x => x.Username == username); User user = new User() { Username = userDb.Username, Email = userDb.Email, password = userDb.PasswordHash }; return(user); } }
public void CreateUser(User userInfo, string passwordHash) { using (BackingShareContext db = new BackingShareContext()) { Users dbUser = new Users() { Username = userInfo.Username, Email = userInfo.Email, PasswordHash = passwordHash, }; db.Users.Add(dbUser); db.SaveChanges(); } }
public List <ProjectsModel> GetProjectsByUserId(int userId) { List <ProjectsModel> projects = new List <ProjectsModel>(); using (BackingShareContext db = new BackingShareContext()) { List <Projects> dbProjects = db.Projects.Where(r => r.userId == userId).ToList(); foreach (Projects dbProject in dbProjects) { ProjectsModel project = new ProjectsModel() { Id = dbProject.Id, isPublic = dbProject.isPublic, name = dbProject.name, userId = dbProject.userId }; projects.Add(project); } return(projects); } }
public void StoreInDB(string location, string filename, int project, int userId) { using (BackingShareContext db = new BackingShareContext()) { Audio dbAudio = new Audio() { name = filename, userId = userId }; db.Audio.Add(dbAudio); db.SaveChanges(); Audio audio = db.Audio.Where(r => r.name == filename).FirstOrDefault(); ProjectsXAudios dbProjectsXAudios = new ProjectsXAudios() { audioId = audio.Id, projectId = project }; db.ProjectsXAudios.Add(dbProjectsXAudios); db.SaveChanges(); } }