public ProjectDetail GetProjectDetailsById(int id)
 {
     try {
         ProjectDetail result  = new ProjectDetail();
         var           project = _context.Project.Where(x => x.Id == id && x.IsDelete == false)
                                 .Include(s => s.ProjectSitelocation)
                                 .Include(s => s.Ic)
                                 .Include(s => s.Bu).FirstOrDefault();
         result = _mapper.Map <ProjectDetail> (project);
         if (project.Bu.SbgId != null)
         {
             StrategicBusiness sbg = _context.StrategicBusiness.Where(x => x.Id == project.Bu.SbgId && x.IsDelete == false).FirstOrDefault();
             result.SbgId   = sbg.Id;
             result.SbgName = sbg.Name;
         }
         return(result);
     } catch (Exception ex) {
         throw ex;
     }
 }
        public ResponseMessage CreateStrategicBusiness(AddStrategicBusiness strategicBusiness)
        {
            try
            {
                if (_context.StrategicBusiness.Where(x => x.Name == strategicBusiness.Name && x.IsDelete == false).Count() > 0)
                {
                    throw new ValueNotFoundException("Strategic Business Group already exist");
                }
                ResponseMessage   response = new ResponseMessage();
                StrategicBusiness sbg      = _mapper.Map <StrategicBusiness>(strategicBusiness);
                sbg.IsDelete = false;
                sbg.IsActive = strategicBusiness.IsActive;
                _context.StrategicBusiness.Add(sbg);
                _context.SaveChanges();

                response.Message = "Strategic Business Group added successfully";
                return(response);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }