public void Create(User user)
{
using (var db = new CodeChallengeEntities())
{
db.Users.Add(user);
db.SaveChanges();
}
}
public void Create(UserProject entity)
{
using (var db = new CodeChallengeEntities())
{
SqlParameter UserId = new SqlParameter("@UserId", entity.UserId);
SqlParameter ProjectId = new SqlParameter("@ProjectId", entity.ProjectId);
SqlParameter IsActive = new SqlParameter("@IsActive", entity.IsActive);
SqlParameter AssignedDate = new SqlParameter("@AssignedDate", entity.AssignedDate);
db.Database.ExecuteSqlCommand("addUserProject @UserId, @ProjectId, @IsActive, @AssignedDate", UserId, ProjectId, IsActive, AssignedDate);
db.SaveChanges();
}
}
public List <UserProject> Retrive()
{
var userProjectList = new List <UserProject>();
using (var db = new CodeChallengeEntities())
{
var query = from U in db.UserProjects
select U;
foreach (var item in query)
{
userProjectList.Add(item);
}
}
return(userProjectList);
}