public string UpdateSortOrder(List <SortOrderItem> links)
{
string success = "";
try
{
using (var db = new OggleBoobleMySqlContext())
{
try
{
int folderId = links[0].FolderId;
List <CategoryImageLink> catLinks = db.CategoryImageLinks.Where(l => l.ImageCategoryId == folderId).ToList();
int insertThrottle = 0;
foreach (SortOrderItem link in links)
{
CategoryImageLink catLink = catLinks.Where(x => x.ImageLinkId == link.ItemId).FirstOrDefault();
if (catLink != null)
{
if (catLink.SortOrder != link.SortOrder)
{
catLink.SortOrder = link.SortOrder;
if (++insertThrottle % 25 == 0)
{
db.SaveChanges();
}
}
}
}
db.SaveChanges();
success = "ok";
}
catch (Exception ex)
{
success = Helpers.ErrorDetails(ex);
db.Dispose();
}
}
}
catch (Exception ex)
{
success += Helpers.ErrorDetails(ex);
}
return(success);
}
public RepairReportModel MoveManyCleanup(int root)
{
RepairReportModel repairReportModel = new RepairReportModel();
try
{
using (OggleBoobleContext db = new OggleBoobleContext())
{
CategoryFolder startFolder = db.CategoryFolders.Where(f => f.Id == root).FirstOrDefault();
string ftpPath = ftpHost + "/" + startFolder.RootFolder + ".ogglebooble.com/"
+ Helpers.GetParentPath(startFolder.Id) + startFolder.FolderName;
string[] rootFiles = FtpUtilies.GetFiles(ftpPath);
//List<string> rootFileLinks = new List<string>();
//foreach (string fileName in rootFiles) rootFileLinks.Add(fileName.Substring(fileName.LastIndexOf("_") + 1, 36));
List <CategoryFolder> subDirs = db.CategoryFolders.Where(f => f.Parent == root).ToList();
string sourcePath = startFolder.RootFolder + ".ogglebooble.com/" + Helpers.GetParentPath(startFolder.Id) + startFolder.FolderName;
string moveFileSuccess, newLink, linkId, destinationPath;
string imageFileName = "";
foreach (CategoryFolder subDir in subDirs)
{
destinationPath = subDir.RootFolder + ".ogglebooble.com/" + Helpers.GetParentPath(subDir.Id) + subDir.FolderName;
List <CategoryImageLink> subFolderLinks = db.CategoryImageLinks.Where(l => l.ImageCategoryId == subDir.Id).ToList();
foreach (CategoryImageLink subFolderLink in subFolderLinks)
{
bool found = false;
foreach (string fileName in rootFiles)
{
linkId = fileName.Substring(fileName.LastIndexOf("_") + 1, 36);
if (linkId == subFolderLink.ImageLinkId)
{
found = true;
imageFileName = fileName;
break;
}
}
//if (rootFiles.Contains(subFolderLink.ImageLinkId))
if (found)
{
ImageLink imageLink = db.ImageLinks.Where(i => i.Id == subFolderLink.ImageLinkId).FirstOrDefault();
string ext = imageFileName.Substring(imageFileName.LastIndexOf("."));
string newImageFileName = subDir.FolderName + "_" + subFolderLink.ImageLinkId + imageFileName.Substring(imageFileName.LastIndexOf("."));
if (FtpUtilies.DirectoryExists(ftpHost + sourcePath + "/" + imageFileName))
{
moveFileSuccess = FtpUtilies.MoveFile(ftpHost + sourcePath + "/" + imageFileName, ftpHost + destinationPath + "/" + newImageFileName);
if (moveFileSuccess == "ok")
{
if (imageLink != null)
{
newLink = "http://" + destinationPath + "/" + newImageFileName;
imageLink.Link = newLink;
imageLink.FolderLocation = subDir.Id;
db.SaveChanges();
repairReportModel.LinksEdited++;
CategoryImageLink badCategoryImageLink = db.CategoryImageLinks
.Where(c => c.ImageLinkId == subFolderLink.ImageLinkId && c.ImageCategoryId == root).FirstOrDefault();
if (badCategoryImageLink != null)
{
db.CategoryImageLinks.Remove(badCategoryImageLink);
db.SaveChanges();
repairReportModel.LinksRemoved++;
}
}
else
{
repairReportModel.Errors.Add("no imagelink found for link " + subFolderLink.ImageLinkId + " folder: " + startFolder.FolderName);
}
}
else
{
repairReportModel.Errors.Add("link " + ftpHost + sourcePath + imageFileName + " error: " + moveFileSuccess);
}
}
}
repairReportModel.RowsProcessed++;
}
}
repairReportModel.Success = "ok";
}
}
catch (Exception ex)
{
repairReportModel.Success = Helpers.ErrorDetails(ex);
}
return(repairReportModel);
}
private void RepairLinksRecurr(int folderId, RepairReportModel repairReport, OggleBoobleContext db)
{
try
{
CategoryFolder dbCategoryFolder = db.CategoryFolders.Where(f => f.Id == folderId).First();
string rootFolder = dbCategoryFolder.RootFolder;
if (rootFolder == "centerfold")
{
rootFolder = "playboy";
}
string ftpPath = ftpHost + "/" + rootFolder + ".ogglebooble.com/"
+ Helpers.GetParentPath(folderId) + dbCategoryFolder.FolderName;
if (!FtpUtilies.DirectoryExists(ftpPath))
{
repairReport.DirNotFound++;
FtpUtilies.CreateDirectory(ftpPath);
repairReport.Errors.Add("created directory " + ftpPath);
}
int folderRowsProcessed = 0;
//if (repairReport.isSubFolder)
// SignalRHost.ProgressHub.PostToClient("Processing: " + dbCategoryFolder.FolderName + " Rows: " + folderRowsProcessed + " Total: " + repairReport.RowsProcessed);
//else
// SignalRHost.ProgressHub.PostToClient("Processing: " + dbCategoryFolder.FolderName + " Rows: " + folderRowsProcessed);
List <ImageLink> goDaddyLinks =
(from c in db.CategoryImageLinks
join g in db.ImageLinks on c.ImageLinkId equals g.Id
where c.ImageCategoryId == folderId &&
g.Link.Contains(dbCategoryFolder.FolderName) &&
g.FolderLocation == dbCategoryFolder.Id
select(g)).ToList();
string[] imageFiles = FtpUtilies.GetFiles(ftpPath);
string goDaddyPrefix = "http://" + rootFolder + ".ogglebooble.com/";
string expectedLinkName = goDaddyPrefix + Helpers.GetParentPath(folderId) + dbCategoryFolder.FolderName;
string ext = "";
bool fileNameInExpectedForm;
string linkId = "";
foreach (string fileName in imageFiles)
{
//EnsureCorrectFileName(fileName, ftpPath);
if ((fileName.LastIndexOf("_") > 0) && (fileName.Substring(fileName.LastIndexOf("_")).Length > 40))
{
fileNameInExpectedForm = true;
if (fileName.IndexOf(".") > 0)
{
ext = fileName.Substring(fileName.Length - 4);
linkId = fileName.Substring(fileName.LastIndexOf("_") + 1, 36);
//expectedFileName = dbCategoryFolder.FolderName + "_" + linkId + ext;
//if (fileName == expectedFileName)
var folderNameWhereImageSayItShouldBe = fileName.Substring(0, fileName.IndexOf("_"));
if (folderNameWhereImageSayItShouldBe != dbCategoryFolder.FolderName)
{
CategoryFolder categoryFolderWhereImageSayItShouldBe = db.CategoryFolders.Where(f => f.FolderName == folderNameWhereImageSayItShouldBe).FirstOrDefault();
if (categoryFolderWhereImageSayItShouldBe != null)
{
string ftpPathWhereImageSayItShouldBe = ftpHost + categoryFolderWhereImageSayItShouldBe.RootFolder + ".ogglebooble.com/"
+ Helpers.GetParentPath(categoryFolderWhereImageSayItShouldBe.Id) + categoryFolderWhereImageSayItShouldBe.FolderName;
string[] ArrayWhereImageSayItShouldBe = FtpUtilies.GetFiles(ftpPathWhereImageSayItShouldBe);
if (ArrayWhereImageSayItShouldBe.Contains(categoryFolderWhereImageSayItShouldBe.FolderName + "_" + linkId + ext))
{
FtpUtilies.DeleteFile(ftpPath + categoryFolderWhereImageSayItShouldBe.FolderName + "_" + linkId + ext);
repairReport.LinksRemoved++;
}
}
else
{ // move file
string source = ftpPath + "/" + fileName;
string destination = ftpHost + categoryFolderWhereImageSayItShouldBe.RootFolder + ".ogglebooble.com/"
+ Helpers.GetParentPath(categoryFolderWhereImageSayItShouldBe.Id) + categoryFolderWhereImageSayItShouldBe.FolderName;
if (source != destination)
{
FtpUtilies.MoveFile(source, destination);
ImageLink extraLink = db.ImageLinks.Where(g => g.Id == linkId).FirstOrDefault();
if (extraLink != null)
{
db.ImageLinks.Remove(extraLink);
db.SaveChanges();
}
repairReport.ImagesMoved++;
}
}
}
ImageLink goDaddyLinkExists = db.ImageLinks.Where(g => g.Id == linkId).FirstOrDefault();
if (goDaddyLinkExists == null)
{
if (FtpUtilies.DirectoryExists(ftpPath + "/" + fileName))
{
ImageLink newLink = new ImageLink()
{
Id = linkId, Link = expectedLinkName + "/" + fileName, ExternalLink = "unknown", FolderLocation = folderId
};
db.ImageLinks.Add(newLink);
db.SaveChanges();
repairReport.NewLinksAdded++;
}
}
else
{
// if (goDaddyLinkExists.Link.ToUpper() != (expectedLinkName + "/" + fileName).ToUpper())
if (goDaddyLinkExists.Link != expectedLinkName + "/" + fileName)
{
goDaddyLinkExists.Link = expectedLinkName + "/" + fileName;
db.SaveChanges();
repairReport.LinksEdited++;
}
}
if (db.CategoryImageLinks.Where(c => c.ImageCategoryId == folderId).Where(c => c.ImageLinkId == linkId).Where(c => c.ImageCategoryId == folderId).FirstOrDefault() == null)
{
CategoryImageLink newCatLink = new CategoryImageLink()
{
ImageCategoryId = folderId, ImageLinkId = linkId
};
db.CategoryImageLinks.Add(newCatLink);
db.SaveChanges();
repairReport.CatLinksAdded++;
}
}
else
{
repairReport.Errors.Add("extension problem");
fileNameInExpectedForm = false;
}
}
else
{
fileNameInExpectedForm = false;
ext = fileName.Substring(fileName.Length - 4);
linkId = Guid.NewGuid().ToString();
//expectedFileName = dbCategoryFolder.FolderName + "_" + linkId + ext;
}
if (!fileNameInExpectedForm)
{
// rename file
string renameSuccess = FtpUtilies.MoveFile(ftpPath + "/" + fileName, ftpPath + "/" + fileName);
if (renameSuccess == "ok")
{
repairReport.ImagesRenamed++;
ImageLink oldImageLink = goDaddyLinks.Where(g => g.Link == expectedLinkName + "/" + fileName).FirstOrDefault();
if (oldImageLink != null)
{
if (oldImageLink.Link != expectedLinkName + "/" + fileName)
{
// update godaddy link
oldImageLink.Link = expectedLinkName + "/" + fileName;
db.SaveChanges();
repairReport.LinksEdited++;
}
}
else
{
// link not found in this folder's links
ImageLink goDaddyLink = db.ImageLinks.Where(g => g.Id == linkId).FirstOrDefault();
if (goDaddyLink != null)
{
goDaddyLink.Link = expectedLinkName + "/" + fileName;
db.SaveChanges();
repairReport.LinksEdited++;
}
else
{
var newImageLink = new ImageLink()
{
Id = linkId,
FolderLocation = folderId,
Link = expectedLinkName + "/" + fileName,
ExternalLink = ""
};
db.ImageLinks.Add(newImageLink);
db.SaveChanges();
repairReport.NewLinksAdded++;
}
if (db.CategoryImageLinks.Where(c => c.ImageCategoryId == folderId).Where(c => c.ImageLinkId == linkId).FirstOrDefault() == null)
{
CategoryImageLink newCatLink = new CategoryImageLink()
{
ImageCategoryId = folderId,
ImageLinkId = linkId
};
db.CategoryImageLinks.Add(newCatLink);
db.SaveChanges();
repairReport.CatLinksAdded++;
}
}
}
else
{
repairReport.Errors.Add("rename Failed: " + renameSuccess);
}
}
//if (repairReport.isSubFolder)
// SignalRHost.ProgressHub.PostToClient("Processing: " + dbCategoryFolder.FolderName + " Rows: " + folderRowsProcessed + " Total: " + repairReport.RowsProcessed);
//else
// SignalRHost.ProgressHub.PostToClient("Processing: " + dbCategoryFolder.FolderName + " Rows: " + folderRowsProcessed);
repairReport.RowsProcessed++;
folderRowsProcessed++;
}
if (goDaddyLinks.Count() != imageFiles.Count())
{
if (goDaddyLinks.Count() > imageFiles.Count())
{
string expectedFileName = "";
foreach (ImageLink goDaddyLink in goDaddyLinks)
{
expectedFileName = goDaddyLink.Link.Substring(goDaddyLink.Link.LastIndexOf("/") + 1);
linkId = goDaddyLink.Link.Substring(goDaddyLink.Link.LastIndexOf("_") + 1, 36);
if (!imageFiles.Contains(expectedFileName))
{
ImageLink imageLink = db.ImageLinks.Where(i => i.Id == linkId).FirstOrDefault();
if (imageLink == null)
{
repairReport.Errors.Add("image file in folder with no imageLink row");
}
else
{
if (imageLink.FolderLocation == folderId)
{
CategoryImageLink categoryImageLink = db.CategoryImageLinks.Where(l => l.ImageCategoryId == folderId && l.ImageLinkId == linkId).FirstOrDefault();
//if (categoryImageLink == null)
{
//repairReport.Errors.Add("image file in folder with no imageLink row");
List <ImageLink> flinks = db.ImageLinks.Where(i => i.ExternalLink == imageLink.ExternalLink).ToList();
string downLoadSuccess = DownLoadImage(ftpPath, goDaddyLink.ExternalLink, expectedFileName);
if (downLoadSuccess == "ok")
{
repairReport.ImagesDownLoaded++;
}
else
{
// problem with links to child folder files
repairReport.Errors.Add(goDaddyLink.ExternalLink + " " + downLoadSuccess);
db.ImageLinks.Remove(goDaddyLink);
var badCatFolderImageLink = db.CategoryImageLinks.Where(c => c.ImageCategoryId == dbCategoryFolder.Id && c.ImageLinkId == goDaddyLink.Id).FirstOrDefault();
if (badCatFolderImageLink != null)
{
db.CategoryImageLinks.Remove(badCatFolderImageLink);
}
db.SaveChanges();
repairReport.LinksRemoved++;
}
}
}
}
}
//if (repairReport.isSubFolder)
// SignalRHost.ProgressHub.PostToClient("Processing: " + dbCategoryFolder.FolderName + " Rows: " + folderRowsProcessed + " Total: " + repairReport.RowsProcessed);
//else
// SignalRHost.ProgressHub.PostToClient("Processing: " + dbCategoryFolder.FolderName + " Rows: " + folderRowsProcessed);
}
}
if (imageFiles.Count() > goDaddyLinks.Count())
{
repairReport.Errors.Add("Extra Links Found in " + ftpPath);
foreach (string imageFile in imageFiles)
{
linkId = imageFile.Substring(imageFile.IndexOf("_") - 1);
var x = db.ImageLinks.Where(i => i.Link == imageFile).FirstOrDefault();
if (x == null)
{
// add a link
db.ImageLinks.Add(new ImageLink()
{
Id = Guid.NewGuid().ToString(),
Link = imageFile,
ExternalLink = "gg"
});
db.SaveChanges();
}
}
}
}
int[] subDirs = db.CategoryFolders.Where(f => f.Parent == folderId).Select(f => f.Id).ToArray();
foreach (int subDir in subDirs)
{
repairReport.isSubFolder = true;
RepairLinksRecurr(subDir, repairReport, db);
}
}
catch (Exception ex) { repairReport.Success = Helpers.ErrorDetails(ex); }
}
