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