/// <summary>
        /// Updates a sectorServicio
        /// </summary>
        /// <param name="sectorServicioId"></param>
        /// <param name="sectorServicioEntity"></param>
        /// <returns></returns>
        public bool UpdateSectorServicio(int sectorServicioId, SectorEntity sectorServicioEntity)
        {
            var success = false;

            if (sectorServicioEntity != null)
            {
                using (var scope = new TransactionScope())
                {
                    var sectorServicio = _unitOfWork.SectorServicioRepository.GetByID(sectorServicioId);
                    if (sectorServicio != null)
                    {
                        sectorServicio.Codigo       = sectorServicioEntity.Codigo;
                        sectorServicio.Descripcion  = sectorServicioEntity.Descripcion;
                        sectorServicio.IdEstado     = sectorServicioEntity.IdEstado;
                        sectorServicio.IdSector     = sectorServicioEntity.IdSector;
                        sectorServicio.Nombre       = sectorServicioEntity.Nombre;
                        sectorServicio.NORMA_SECTOR = sectorServicioEntity.NORMA_SECTOR;
                        sectorServicio.SERVICIO     = sectorServicioEntity.SERVICIO;

                        _unitOfWork.SectorServicioRepository.Update(sectorServicio);
                        _unitOfWork.Save();
                        scope.Complete();
                        success = true;
                    }
                }
            }
            return(success);
        }
示例#2
0
 public bool Put(int id, [FromBody] SectorEntity sectorServicioEntity)
 {
     if (id > 0)
     {
         return(_sectorServicioServices.UpdateSectorServicio(id, sectorServicioEntity));
     }
     return(false);
 }
示例#3
0
        public Result Get(int id)
        {
            var con   = new DapperConnectionManager();
            var query = new QueryEntity();

            query.Query  = @"SELECT s.SectorId, s.Name, s.LinkId, s.Title, s.Published,
                                   v.SectorViewId, v.Type, v.Framework, v.Active
                            FROM Sectors as s
                            JOIN SectorViews as v
                            on s.SectorId = v.SectorId
                            where s.SectorId = @SectorId
                            ORDER BY s.Name ASC";
            query.Entity = new { SectorId = id };

            var result = con.ExecuteQuery(query);

            if (!result.Success)
            {
                result.Message = "Sector not found";
                return(result);
            }
            var r = (IEnumerable <dynamic>)result.Entity;

            if (!r.Any())
            {
                return(result);
            }

            var sectorEntity = new SectorEntity();

            sectorEntity.SectorId = r.First().SectorId;
            sectorEntity.Name     = r.First().Name;
            sectorEntity.Title    = r.First().Title;
            List <SectorViewEntity> list = new List <SectorViewEntity>();

            foreach (var item in r)
            {
                var view = new SectorViewEntity()
                {
                    Type         = item.Type,
                    Framework    = item.Framework,
                    SectorViewId = item.SectorViewId,
                    Active       = item.Active
                };

                list.Add(view);
            }
            sectorEntity.SectorEn = list.FirstOrDefault(x => x.Type == "EN");
            sectorEntity.SectorRn = list.FirstOrDefault(x => x.Type == "RN");

            result.Entity = sectorEntity;
            return(result);
        }
        private List <SectorEntity> FormatSectors(IEnumerable <dynamic> sectors)
        {
            var sectorsList = new List <SectorEntity>();

            foreach (var item in sectors)
            {
                SectorEntity entity = sectorsList.FirstOrDefault(x => x.SectorId == item.SectorId);
                if (entity == null)
                {
                    entity          = new SectorEntity();
                    entity.SectorId = item.SectorId;
                    entity.Title    = item.Title;
                    entity.Name     = item.Name;
                    sectorsList.Add(entity);
                }
                if (item.SectorViewId == null)
                {
                    continue;
                }

                var view = new SectorViewEntity
                {
                    Intro                  = item.Intro,
                    SectorViewId           = item.SectorViewId,
                    Video                  = item.Video,
                    Type                   = item.Type,
                    CareerOpportunities    = item.CareerOpportunities,
                    CareerPathways         = item.CareerPathways,
                    ContactText            = item.ContactText,
                    EducationOpportunities = item.EducationOpportunities,
                    Framework              = item.Framework,
                    MoreStories            = item.MoreStories,
                    WorkEnvironments       = item.WorkEnvironments,
                    SectorId               = item.SectorId,
                    OnlineResources        = item.OnlineResources,
                    Active                 = item.Active
                };
                if (item.Type == "EN")
                {
                    entity.SectorEn = view;
                }
                if (item.Type == "RN")
                {
                    entity.SectorRn = view;
                }
            }

            return(sectorsList);
        }
示例#5
0
        public Result Update(SectorEntity entity)
        {
            var con = new DapperConnectionManager();

            var query = new QueryEntity();

            query.Entity = entity;
            query.Query  = @"UPDATE Sectors set 
                                      Title=@Title 
                                      WHERE SectorId = @SectorId";
            var result = con.ExecuteQuery(query);

            result.Message = result.Success ? "The sector has been updated" : "An error occurred";
            result.Entity  = entity.SectorId;
            return(result);
        }
 /// <summary>
 /// Creates a sectorServicio
 /// </summary>
 /// <param name="sectorServicioEntity"></param>
 /// <returns></returns>
 public int CreateSectorServicio(SectorEntity sectorServicioEntity)
 {
     using (var scope = new TransactionScope())
     {
         var sectorServicio = new SECTOR
         {
             Codigo       = sectorServicioEntity.Codigo,
             Descripcion  = sectorServicioEntity.Descripcion,
             IdEstado     = sectorServicioEntity.IdEstado,
             IdSector     = sectorServicioEntity.IdSector,
             Nombre       = sectorServicioEntity.Nombre,
             NORMA_SECTOR = sectorServicioEntity.NORMA_SECTOR,
             SERVICIO     = sectorServicioEntity.SERVICIO
         };
         _unitOfWork.SectorServicioRepository.Insert(sectorServicio);
         _unitOfWork.Save();
         scope.Complete();
         return(sectorServicio.IdSector);
     }
 }
示例#7
0
 public int Post([FromBody] SectorEntity sectorServicioEntity)
 {
     return(_sectorServicioServices.CreateSectorServicio(sectorServicioEntity));
 }
示例#8
0
        public Result GetAll(int id)
        {
            var con   = new DapperConnectionManager();
            var query = new QueryEntity();

            query.Query  = @"SELECT s.SectorId, s.Name, s.LinkId, s.Title, s.Published,
                                   v.SectorViewId, v.Type, v.Framework, v.Intro,                              
                                  ,v.Video
                                  ,v.MoreStories
                                  ,v.CareerPathways
                                  ,v.WorkEnvironments
                                  ,v.CareerOpportunities
                                  ,v.EducationOpportunities
                                  ,v.ContactText
                            FROM Sectors
                            JOIN SectorViews as v
                            on s.SectorId = v.SectorId
                            where s.SectorId = @SectorId
                            ORDER BY c.Position ASC";
            query.Entity = new { SectorId = id };

            var result = con.ExecuteQuery(query);

            if (!result.Success)
            {
                result.Message = "Sector not found";
                return(result);
            }
            var r = (IEnumerable <dynamic>)result.Entity;

            if (!r.Any())
            {
                return(result);
            }

            var sectorEntity = new SectorEntity();

            sectorEntity.SectorId = r.First().SectorId;
            sectorEntity.Name     = r.First().Name;
            sectorEntity.Title    = r.First().Title;
            List <SectorViewEntity> list = new List <SectorViewEntity>();

            foreach (var item in r)
            {
                var view = new SectorViewEntity()
                {
                    Type = item.Type,
                    CareerOpportunities    = item.CareerOpportunities,
                    CareerPathways         = item.CareerPathways,
                    ContactText            = item.ContactText,
                    EducationOpportunities = item.EducationOppotunities,
                    Framework        = item.Framework,
                    Intro            = item.Intro,
                    MoreStories      = item.MoreStories,
                    SectorId         = item.SectorId,
                    SectorViewId     = item.SectorViewId,
                    Video            = item.Video,
                    WorkEnvironments = item.WorkEnviroments
                };

                list.Add(view);
            }
            sectorEntity.SectorEn = list.FirstOrDefault(x => x.Type == "EN");
            sectorEntity.SectorRn = list.FirstOrDefault(x => x.Type == "RN");

            result.Entity = sectorEntity;
            return(result);
        }
示例#9
0
        public Result Insert(SectorEntity entity)
        {
            var con    = new DapperConnectionManager();
            var query  = new QueryEntity();
            var result = new Result();

            using (var scope = new TransactionScope())
            {
                var linkEntity = new LinkEntity
                {
                    Href   = " ",
                    Name   = entity.Title,
                    Type   = LinksTypes.SECTOR.ToString(),
                    Active = false
                };

                query.Entity = linkEntity;
                query.Query  = @"INSERT INTO Links (Name, Type, Href, Active) VALUES(@Name, @Type, @Href, @Active)";


                result = con.InsertQueryUnScoped(query);
                if (!result.Success)
                {
                    result.Message = "An error occurred";
                    return(result);
                }
                var linkId = (int)result.Entity;

                entity.LinkId = linkId;
                query.Entity  = entity;
                query.Query   = @"INSERT INTO Sectors (Name, Title, Published, LinkId) VALUES(@Name, @Title, @Published, @LinkId)";
                result        = con.InsertQueryUnScoped(query);

                if (!result.Success)
                {
                    result.Message = "An error occurred";
                    return(result);
                }
                var sectorId = (int)result.Entity;

                var sectorViewRn = new SectorViewEntity
                {
                    Type      = "RN",
                    Framework = "rn",
                    SectorId  = sectorId
                };

                query.Entity = sectorViewRn;
                query.Query  = @"INSERT INTO SectorViews (Type, Framework, SectorId) VALUES(@Type, @Framework, @SectorId)";
                result       = con.InsertQueryUnScoped(query);
                if (!result.Success)
                {
                    result.Message = "An error occurred";
                    return(result);
                }

                var sectorViewEn = new SectorViewEntity
                {
                    Type      = "EN",
                    Framework = "en",
                    SectorId  = sectorId
                };

                query.Entity = sectorViewEn;
                query.Query  = @"INSERT INTO SectorViews (Type, Framework, SectorId) VALUES(@Type, @Framework, @SectorId)";
                result       = con.InsertQueryUnScoped(query);
                if (!result.Success)
                {
                    result.Message = "An error occurred";
                    return(result);
                }

                //LINK HREF UPDATE
                var queryUpdateLink = new QueryEntity()
                {
                    Entity = new { Href = "/sections/" + sectorId, LinkId = linkId },
                    Query  = "UPDATE Links set Href = @Href where LinkId = @LinkId"
                };
                var resultUpdateLink = con.ExecuteQueryUnScoped(queryUpdateLink);
                if (!resultUpdateLink.Success)
                {
                    result.Message = "An error occurred";
                    result.Success = false;
                    return(result);
                }

                scope.Complete();
                result.Entity  = sectorId;
                result.Message = "The sector has been created";
            }
            return(result);
        }