public ConverterBase(VSProject project)
{
var list = new List<VSProject>(1);
list.Add(project);
this.Projects = list;
this.Solution = project.Solution;
}
public void LoadProject(VSProject project)
{
foreach (VSResxFileGroup group in project.ResxGroups.Values)
{
foreach (VSResxFile file in group.Files.Values)
{
LoadFile(file);
}
}
}
public static IConverter OpenConverter(OpenFileDialog openExcelDialog, VSProject project)
{
switch (Path.GetExtension(openExcelDialog.FileName).Substring(1))
{
case "xls":
return new ExcelConverter(project);
case "xlsx":
return new XlsxConverter(project);
default:
throw new Exception("File type not supported!");
}
}
private void RegisterProject(string line)
{
MatchCollection matches = Regex.Matches(line, "\"(.*?)\"");
if (matches[2] != null && File.Exists(Path.Combine(solution.SolutionDirectory.FullName, matches[2].Groups[1].Value)))
{
var projectName = matches[1].Groups[1].Value;
VSProject project = new VSProject(solution, matches[2].Groups[1].Value, projectName);
if (!solution.Projects.ContainsKey(projectName))
{
solution.Projects.Add(projectName, project);
}
}
}
private void RegisterProject(string line)
{
MatchCollection matches = Regex.Matches(line, "\"(.*?)\"");
if (matches[2] != null && File.Exists(Path.Combine(Solution.SolutionDirectory.FullName, matches[2].Groups[1].Value)) &&
!Solution.SkipProject(matches[1].Groups[1].Value))
{
var projectName = matches[1].Groups[1].Value;
var project = new VSProject(Solution, matches[2].Groups[1].Value, projectName);
if (!Solution.Projects.ContainsKey(projectName))
{
Solution.Projects.Add(projectName, project);
}
}
}
public ProjectListViewEntry(VSProject project)
{
this.Project = project;
}
private void loadFileGroups(TreeNode parent, VSProject project)
{
foreach (IResourceFileGroup group in project.ResxGroups.Values)
{
var fileGroupNode = new ResourceFileGroupTreeNode(group);
fileGroupNode.ImageIndex = 1;
fileGroupNode.SelectedImageIndex = 1;
fileGroupNode.ContextMenuStrip = this.contextFileGroup;
parent.Nodes.Add(fileGroupNode);
loadFiles(fileGroupNode, group);
}
foreach (IResourceFile file in project.UnassignedFiles)
{
var fileNode = new ResourceFileTreeNode(file);
fileNode.ContextMenuStrip = this.contextMenuResxFile;
parent.Nodes.Add(fileNode);
}
}
public VSProjectFolder(VSProject project, VSFileContainer parent, string filepath)
: base(project, parent, filepath)
{
base.Init(filepath);
}
public VSProjectFolder(VSProject project, VSFileContainer parent, string filepath)
: base(project, parent, filepath)
{
base.Init(filepath);
}
public VSFileContainer(VSProject project, VSFileContainer parent, string filepath)
{
this.Project = project;
this.Parent = parent;
}
public VSFileContainer(VSProject project, VSFileContainer parent, string filepath)
{
Project = project;
Parent = parent;
}
public XlsxConverter(VSProject project)
: base(project)
{
}
private IEnumerable<ResourceDataGroupBase> GetData(VSProject project, IEnumerable<CultureInfo> cultures)
{
var data = new List<ResourceDataGroupBase>();
IList<ResourceDataGroupBase> uncompletedDataGroups = null;
if (ExportDiff)
{
uncompletedDataGroups = project.GetUncompleteDataGroups(cultures);
}
IEnumerable<IResourceFileGroup> resxGroups = project.ResxGroups.Values;
if (FileGroups != null && FileGroups.Count() > 0)
resxGroups = project.ResxGroups.Values.Intersect(FileGroups);
foreach (IResourceFileGroup group in resxGroups)
{
IEnumerable<ResourceDataGroupBase> groupDataValues = group.AllData.Values
.Where(resxGroup => uncompletedDataGroups == null || uncompletedDataGroups.Contains(resxGroup));
if (IgnoreInternalResources)
{
groupDataValues = groupDataValues.Where(resxGroup => !resxGroup.Name.StartsWith(">>"));
}
data.AddRange(groupDataValues);
}
return data;
}
private void AddProject(VSProject project, XLWorkbook workbook, IEnumerable<CultureInfo> cultures, IEnumerable<ResourceDataGroupBase> data)
{
var sheetName = project.Name ?? string.Empty;
if (sheetName.Length > 30)
{
sheetName = sheetName.Substring(sheetName.Length - 30);
}
var worksheet = workbook.Worksheets.Add(sheetName);
AddHeader(project, worksheet, cultures);
int rowIndex = 2;
foreach (ResourceDataGroupBase dataGroup in data)
{
AddData(dataGroup, worksheet, rowIndex, cultures);
rowIndex++;
}
if (AutoAdjustLayout)
{
worksheet.Row(1).Style.Font.SetBold(true);
worksheet.Columns(1, 2).Style.Font.SetFontColor(XLColor.Gray);
worksheet.Columns(1, 2).Width = 12.0;
worksheet.Style.Alignment.SetVertical(XLAlignmentVerticalValues.Top);
}
}
private void AddHeader(VSProject project, IXLWorksheet worksheet, IEnumerable<CultureInfo> cultures)
{
worksheet.Cell(1, 1).Value = "ID";
worksheet.Cell(1, 2).Value = "Keys";
int c = 3;
foreach (var culture in cultures)
{
if (AutoAdjustLayout)
{
worksheet.Column(c).Width = ColumnValueWidth;
worksheet.Column(c).Style.Alignment.SetWrapText(true);
}
worksheet.Cell(1, c++).Value = culture.Name;
if (ExportComments)
{
if (AutoAdjustLayout)
{
worksheet.Column(c).Width = ColumnCommentWidth;
worksheet.Column(c).Style.Alignment.SetWrapText(true);
}
worksheet.Cell(1, c++).Value = culture.Name + " [Comments]";
}
}
}
public ExcelConverter(VSProject project)
: base(project)
{
}
