public override void Execute(BbicApi.BBIC bbicContext, IfbaApi.IFBA ifbaContext)
        {
            foreach (var s in ifbaContext.SliderTable)
            {
                var bbicNewsTable = new BbicApi.NewsTable()
                {
                    NewsId = s.SliderID,
                     Active = s.Active,
                      Position = s.Position,
                       ImageUrl = "",
                        CreateBy = s.CreatedBy,
                        CreatedDateTime = s.CreatedDateTime,
                };

                var bbicNewsLanguageTable = new BbicApi.NewsLanguageTable()
                {
                     NewsId = s.SliderID,
                     ImageText = s.Description.Length > 20 ? s.Description.Substring(0, 20) : s.Description,
                     Detail = s.Details,
                     Title = s.Description,
                     NewsTable = bbicNewsTable,
                     CreateBy = s.CreatedBy,
                     CreatedDateTime = s.CreatedDateTime,
                     LanguageId = Language.English,
                     UpdatedBy = s.UpdatedBy,
                     UpdatedDateTime = s.UpdatedDateTime
                };
            }
        }
        public override void Execute(BbicApi.BBIC bbicContext, IfbaApi.IFBA ifbaContext)
        {
            logger.Info("Transfering Resources");

            var s1 = CopyOrgFile();
            var s = CopyFiles();

            foreach (var res in ifbaContext.ResourceTable)
            {
                FileTable ft = GetFileTable(res);
                FileWorkingGroupTable fwgt = GetFileWorkingGroupTable(res, ft);
                FileLanguageTable flt = GetFileLanguageTable(res, ft);
                AttachmentTable at = GetAttachmentTable(res, ft);

                UpdateAttachmentURL(res, at);

                if (at.URL != "~/Uploads/Document/")
                {
                    bbicContext.AttachmentTable.InsertOnSubmit(at);
                    bbicContext.FileLanguageTable.InsertOnSubmit(flt);
                    bbicContext.FileWorkingGroupTable.InsertOnSubmit(fwgt);
                }
                else
                {
                    logger.WarnFormat("Attachment for {0} was invalid, and thus it was not inserted", ft.FileId);

                }

                bbicContext.SubmitChanges();
            }

            logger.Info("Transfering Resources - Complete");
        }
        public override void Execute(BbicApi.BBIC bbicContext, IfbaApi.IFBA ifbaContext)
        {
            this.logger.Info("Transfering Organisations");

            foreach (var org in ifbaContext.OrganizationTable)
            {
                OrganizationTable ot = new OrganizationTable()
                {
                    OrganizationId = org.OrganizationID,
                    ImageUrl = "~/Uploads/document/organizations/" + org.OrganizationID + "/Images/smallLogo.gif",
                    Active = org.Active,
                    AddressId = org.AddressID,
                    CreatedBy = org.CreatedBy,
                    UpdatedBy = org.UpdatedBy,
                    UpdatedDateTime = org.UpdatedDateTime,
                    CreatedDateTime = org.CreatedDateTime,
                    Email1 = org.Email,
                    FaxNumber = "",
                    MobileNumber = "",
                    OrganizationName = org.Name,
                    PhoneNumber = "",
                    Position = org.Position,
                    TableRowVersion = org.TableRowVersion,
                    Tags = "",
                    Type = org.Type,
                    Website = org.URL,
                    WorkNumber = "",
                };

                bbicContext.OrganizationTable.InsertOnSubmit(ot);
                bbicContext.SubmitChanges();
            }

            this.logger.Info("Transfering Organisations - Complete");
        }
        public override void Execute(BbicApi.BBIC bbicContext, IfbaApi.IFBA ifbaContext)
        {
            foreach (var addr in ifbaContext.AddressTable)
            {

                    var at = new BbicApi.AddressTable()
                    {
                        Active = addr.Active,
                        City = addr.City,
                        CreatedBy = addr.CreatedBy,
                        UpdatedBy = addr.UpdatedBy,
                        CreatedDateTime = addr.CreatedDateTime,
                        UpdatedDateTime = addr.UpdatedDateTime,
                        AddressID = addr.AddressID,
                        CountryID = new Guid("00000000-0001-0001-0001-0000000000ED"),
                        Latitude = addr.Latitude,
                        Longitude = addr.Longitude,
                        TableRowVersion = addr.TableRowVersion,
                        Type = 1
                    };

                    var alt = new AddressLanguageTable()
                    {
                        Region = addr.Region,
                        Street1 = addr.Street1,
                        Street2 = addr.Street2,
                        City = addr.City,
                        CreatedBy = addr.CreatedBy,
                        UpdatedBy = addr.UpdatedBy,
                        CreatedDateTime = addr.CreatedDateTime,
                        UpdatedDateTime = addr.UpdatedDateTime,
                        LanguageId = Language.English,
                        PostalCode = addr.PostalCode,
                        AddressTable = at,
                        TableRowVersion = addr.TableRowVersion
                    };

                    bbicContext.AddressLanguageTable.InsertOnSubmit(alt);
            }

            bbicContext.SubmitChanges();
        }
        private void UpdateAttachmentURL(IfbaApi.ResourceTable ifbaResource, AttachmentTable at)
        {
            if (ifbaResource.Type == (int)IfbaApi.ResourceType.Link)
            {
                at.URL = ifbaResource.Filename;
            }
            else
            {
                string path = string.Format("{0}", BbicDir + "/Uploads");

                string fullName = ifbaResource.Filename.ToLower();

                var ifbaPath = OrgPaths + "/" + ifbaResource.MemberID.ToString() + "/Resources/" + ifbaResource.Path + "/" + ifbaResource.Filename;

                var files = Directory.GetFiles(path, ifbaResource.Filename, SearchOption.TopDirectoryOnly);

                if (files.Length == 0)
                {
                    var result = this.CopyFile(ifbaResource.Filename, ifbaPath, path);

                    if (string.IsNullOrEmpty(result) == true)
                    {
                        logger.WarnFormat("{0} file cannot be found", fullName);
                    }
                    else
                    {
                        at.URL = path.Replace(BbicDir, "~/");
                    }
                }
                else
                {
                    at.URL = path.Replace(BbicDir, "~");
                }
            }
        }
 private FileWorkingGroupTable GetFileWorkingGroupTable(IfbaApi.ResourceTable res, FileTable ft)
 {
     return new FileWorkingGroupTable()
     {
         WorkingGroupID = new Guid("21F11EFB-4EDE-4F62-B231-687C349C6365"),
         FileTable = ft,
         CreatedBy = res.CreatedBy,
         UpdatedBy = res.UpdatedBy,
         CreatedDateTime = res.CreatedDateTime,
         UpdatedDateTime = res.UpdatedDateTime,
     };
 }
 private FileTable GetFileTable(IfbaApi.ResourceTable res)
 {
     return new FileTable()
     {
         FileId = res.ResourceID,
         Active = res.Active,
         CreatedBy = res.CreatedBy,
         UpdatedBy = res.UpdatedBy,
         TableRowVersion = res.TableRowVersion,
         CreatedDateTime = res.CreatedDateTime,
         UpdatedDateTime = res.UpdatedDateTime,
         VirtualPath = "",
         Location = "",
         Type = res.Type,
         Sensitivity = res.Sensitivity,
     };
 }
 private FileLanguageTable GetFileLanguageTable(IfbaApi.ResourceTable res, FileTable ft)
 {
     return new FileLanguageTable()
     {
         LanguageId = Language.English,
         Name = res.Description,
         Description = res.Description,
         FileTable = ft,
         CreatedBy = res.CreatedBy,
         UpdatedBy = res.UpdatedBy,
         TableRowVersion = res.TableRowVersion,
         CreatedDateTime = res.CreatedDateTime,
         UpdatedDateTime = res.UpdatedDateTime,
         Tags = res.Path.Replace("\\", ", "),
     };
 }
 private AttachmentTable GetAttachmentTable(IfbaApi.ResourceTable res, FileTable ft)
 {
     return new AttachmentTable()
     {
         AttachmentId = res.ResourceID,
         CreatedBy = res.CreatedBy,
         UpdatedBy = res.UpdatedBy,
         TableRowVersion = res.TableRowVersion,
         CreatedDateTime = res.CreatedDateTime,
         UpdatedDateTime = res.UpdatedDateTime,
         Name = res.Filename,
         URL = "~/Uploads/Document/",
         FileTable = ft,
     };
 }