/// <summary>
        /// Saves a project in the database
        /// </summary>
        /// <param name="project">The project detail to save</param>
        /// <returns>Returns true if the insert was successful. False if it failed</returns>
        public static bool UpdateProject(ProjectDetails project)
        {
            try
            {
                using (UniblueLabsEntities entities = new UniblueLabsEntities())
                {
                    Projects projectToUpdate = entities.Projects.First(x => x.id == project.ProjectId);
                    if (projectToUpdate != null)
                    {
                        projectToUpdate.Name        = project.Name;
                        projectToUpdate.Description = project.Description;
                        projectToUpdate.Link        = project.Link;
                        projectToUpdate.Developers  = entities.Developers.Where(x => x.id == project.DeveloperId).FirstOrDefault();
                    }
                    else
                    {
                        return(false);
                    }

                    entities.SaveChanges();
                }
            }
            catch
            {
                return(false);
            }
            return(true);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Saves a project in the database
        /// </summary>
        /// <param name="project">The project detail to save</param>
        /// <returns>Returns true if the insert was successful. False if it failed</returns>
        public static bool UpdateProject(ProjectDetails project)
        {
            try
            {
                using (UniblueLabsEntities entities = new UniblueLabsEntities())
                {
                    Projects projectToUpdate = entities.Projects.First(x => x.id == project.ProjectId);
                    if (projectToUpdate != null)
                    {
                        projectToUpdate.Name = project.Name;
                        projectToUpdate.Description = project.Description;
                        projectToUpdate.Link = project.Link;
                        projectToUpdate.Developers = entities.Developers.Where(x => x.id == project.DeveloperId).FirstOrDefault();
                    }
                    else
                        return false;

                    entities.SaveChanges();
                }
            }
            catch
            {
                return false;
            }
            return true;
        }
Ejemplo n.º 3
0
 /// <summary>
 /// Gets the list of Developers from the database
 /// </summary>
 /// <returns>Return the list of devs. Return null if there is an error</returns>
 public static IEnumerable <Developers> GetDevelopers()
 {
     try
     {
         using (UniblueLabsEntities entities = new UniblueLabsEntities())
         {
             return((from x in entities.Developers
                     select x).ToList());
         }
     }
     catch { return(null); }
 }
Ejemplo n.º 4
0
 /// <summary>
 /// Gets the list of Developers from the database
 /// </summary>
 /// <returns>Return the list of devs. Return null if there is an error</returns>
 public static IEnumerable<Developers> GetDevelopers()
 {
     try
     {
         using (UniblueLabsEntities entities = new UniblueLabsEntities())
         {
             return (from x in entities.Developers
                     select x).ToList();
         }
     }
     catch { return null; }
 }
 public static bool DeleteProject(ProjectDetails projectDetails)
 {
     try
     {
         using (UniblueLabsEntities entities = new UniblueLabsEntities())
         {
             var proj = entities.Projects.FirstOrDefault(x => x.id == projectDetails.ProjectId);
             entities.DeleteObject(proj);
             entities.SaveChanges();
         }
     }
     catch
     {
         return(false);
     }
     return(true);
 }
 /// <summary>
 /// Gets the list of projects from the database
 /// </summary>
 /// <returns></returns>
 public static IEnumerable <ProjectDetails> GetProjects()
 {
     try
     {
         using (UniblueLabsEntities entities = new UniblueLabsEntities())
         {
             return((from x in entities.Projects
                     select new ProjectDetails
             {
                 ProjectId = x.id,
                 Name = x.Name,
                 Description = x.Description,
                 Link = x.Link,
                 Developer = x.Developers.Name,
                 DeveloperPic = x.Developers.Avatar,
                 DeveloperId = x.Developers.id
             }).ToList());;
         }
     }
     catch { return(null); }
 }
Ejemplo n.º 7
0
        /// <summary>
        /// Gets the list of projects from the database
        /// </summary>
        /// <returns></returns>
        public static IEnumerable<ProjectDetails> GetProjects()
        {
            try
            {
                using (UniblueLabsEntities entities = new UniblueLabsEntities())
                {

                    return (from x in entities.Projects
                            select new ProjectDetails
                            {
                                ProjectId = x.id,
                                Name = x.Name,
                                Description = x.Description,
                                Link = x.Link,
                                Developer = x.Developers.Name,
                                DeveloperPic = x.Developers.Avatar,
                                DeveloperId = x.Developers.id
                            }).ToList(); ;
                }
            }
            catch { return null; }
        }
Ejemplo n.º 8
0
 /// <summary>
 /// Saves a project in the database
 /// </summary>
 /// <param name="project">The project detail to save</param>
 /// <returns>Returns true if the insert was successful. False if it failed</returns>
 public static bool AddNewProject(ProjectDetails project)
 {
     try
     {
         using (UniblueLabsEntities entities = new UniblueLabsEntities())
         {
             Projects newProject = new Projects
             {
                 Name = project.Name,
                 Description = project.Description,
                 Link = project.Link,
                 Developers = entities.Developers.Where(x => x.id == project.DeveloperId).FirstOrDefault(),
             };
             entities.AddToProjects(newProject);
             entities.SaveChanges();
             project.ProjectId = newProject.id;
         }
     }
     catch
     {
         return false;
     }
     return true;
 }
 /// <summary>
 /// Saves a project in the database
 /// </summary>
 /// <param name="project">The project detail to save</param>
 /// <returns>Returns true if the insert was successful. False if it failed</returns>
 public static bool AddNewProject(ProjectDetails project)
 {
     try
     {
         using (UniblueLabsEntities entities = new UniblueLabsEntities())
         {
             Projects newProject = new Projects
             {
                 Name        = project.Name,
                 Description = project.Description,
                 Link        = project.Link,
                 Developers  = entities.Developers.Where(x => x.id == project.DeveloperId).FirstOrDefault(),
             };
             entities.AddToProjects(newProject);
             entities.SaveChanges();
             project.ProjectId = newProject.id;
         }
     }
     catch
     {
         return(false);
     }
     return(true);
 }
Ejemplo n.º 10
0
        public static bool DeleteProject(ProjectDetails projectDetails)
        {
            try
            {
                using (UniblueLabsEntities entities = new UniblueLabsEntities())
                {
                    var proj = entities.Projects.FirstOrDefault(x => x.id == projectDetails.ProjectId);
                    entities.DeleteObject(proj);
                    entities.SaveChanges();
                }
            }
            catch
            {
                return false;
            }
            return true;

        }