public void Export(IDocument spec)
{
ExcelHelper.DisableUpdating();
EmptyDocumentsFactory factory = new EmptyDocumentsFactory();
EmptyDocument specEmpty = factory.GetSpecificationEmptyDocument();
specEmpty.NewDocument();
specEmpty.InitFormatCells();
specEmpty.Format();
Excel.Worksheet sheet = specEmpty.getSheet();
int rowNumber = 3;
List <IRow> rows = spec.CombineRows();
foreach (RowSpec row in rows)
{
sheet.Cells[rowNumber, 1] = row.Format;
sheet.Cells[rowNumber, 2] = row.Zone;
sheet.Cells[rowNumber, 3] = row.Position;
sheet.Cells[rowNumber, 4] = row.Designation;
sheet.Cells[rowNumber, 5] = row.Name;
if (row.Quantity != 0)
{
sheet.Cells[rowNumber, 6] = row.Quantity;
}
sheet.Cells[rowNumber, 7] = row.Note;
rowNumber++;
}
ExcelHelper.EnableUpdating();
}
public void NewD33_UD()
{
EmptyDocument emptyD33_UD = emptyDocumentsFactory.GetD33_UDEmptyDocument();
emptyD33_UD.NewDocument();
emptyD33_UD.InitFormatCells();
emptyD33_UD.Format();
}
public void NewVP()
{
EmptyDocument emptyVP = emptyDocumentsFactory.GetVPEmptyDocument();
emptyVP.NewDocument();
emptyVP.InitFormatCells();
emptyVP.Format();
}
public void NewSpecification()
{
EmptyDocument emptySpec = emptyDocumentsFactory.GetSpecificationEmptyDocument();
emptySpec.NewDocument();
emptySpec.InitFormatCells();
emptySpec.Format();
}
public void NewPE3()
{
EmptyDocument emptyPE3 = emptyDocumentsFactory.GetPE3EmptyDocument();
emptyPE3.NewDocument();
emptyPE3.InitFormatCells();
emptyPE3.Format();
}
virtual protected void FormatEmptyDocument()
{
EmptyDocumentsFactory factory = new EmptyDocumentsFactory();
EmptyDocument emptyDocument = factory.GetEmptyDocument(sheet);
if (emptyDocument != null)
{
emptyDocument.Format();
}
}
public void Export(IDocument vp)
{
ExcelHelper.DisableUpdating();
EmptyDocumentsFactory factory = new EmptyDocumentsFactory();
EmptyDocument vpEmpty = factory.GetVPEmptyDocument();
vpEmpty.NewDocument();
vpEmpty.InitFormatCells();
vpEmpty.Format();
Excel.Worksheet sheet = vpEmpty.getSheet();
int rowNumber = 4;
List <IRow> rows = vp.CombineRows();
foreach (RowVP row in rows)
{
if (row.RowNumber != 0)
{
sheet.Cells[rowNumber, 1] = row.RowNumber;
}
sheet.Cells[rowNumber, 2] = row.Name;
sheet.Cells[rowNumber, 3] = row.ProductCode;
sheet.Cells[rowNumber, 4] = row.Designation;
sheet.Cells[rowNumber, 5] = row.Supplier;
sheet.Cells[rowNumber, 6] = row.WhereItUsed;
if (row.QuantityProduct != 0)
{
sheet.Cells[rowNumber, 7] = row.QuantityProduct;
}
if (row.QuantitySet != 0)
{
sheet.Cells[rowNumber, 8] = row.QuantitySet;
}
if (row.QuantityAdjustment != 0)
{
sheet.Cells[rowNumber, 9] = row.QuantityAdjustment;
}
if (row.QuantityTotal != 0)
{
sheet.Cells[rowNumber, 10] = row.QuantityTotal;
}
sheet.Cells[rowNumber, 11] = row.Note;
rowNumber++;
}
ExcelHelper.EnableUpdating();
}
public TestEnvironment()
{
Document = Substitute.For <IDocument <Delta> >();
Document.CreateAsync(null as Delta).ReturnsForAnyArgs(true);
Document.FetchAsync().ReturnsForAnyArgs(true);
Document.Data.Returns(Delta.New()
.InsertChapter("1")
.InsertVerse("1")
.InsertText("This is verse 1.", "verse_1_1")
.InsertVerse("2")
.InsertBlank("verse_1_2")
.InsertVerse("3")
.InsertText("This is verse 3.", "verse_1_3")
.Insert("\n"));
Document.SubmitOpAsync(null as Delta).ReturnsForAnyArgs(true);
Document.DeleteAsync().ReturnsForAnyArgs(true);
EmptyDocument = Substitute.For <IDocument <Delta> >();
EmptyDocument.CreateAsync(null as Delta).ReturnsForAnyArgs(true);
Connection = Substitute.For <IConnection>();
IOptions <SiteOptions> siteOptions = Microsoft.Extensions.Options.Options.Create(
new SiteOptions()
{
SiteDir = "/tmp/ResourceServiceTests/site"
});
var users = new MemoryRepository <UserEntity>();
Jobs = new MemoryRepository <SyncJobEntity>(new[]
{
new SyncJobEntity {
Id = "1234"
}
});
Projects = new MemoryRepository <SFProjectEntity>(new[]
{
new SFProjectEntity
{
Id = "project01",
ProjectName = "project01",
Users =
{
new SFProjectUserEntity
{
Id = "projectuser01",
UserRef = "user01",
Role = SFProjectRoles.Administrator
}
},
ParatextId = "abc123"
}
});
Texts = new MemoryRepository <TextEntity>(new[]
{
new TextEntity
{
BookId = "abc",
Id = "text03",
ProjectRef = "project02",
Chapters =
{
new Chapter {
Number = 1, LastVerse = 3
},
new Chapter {
Number = 2, LastVerse = 3
}
}
}
});
var engineService = Substitute.For <IEngineService>();
ParatextService = Substitute.For <IParatextService>();
ParatextService.GetBookTextAsync(null, null, null).ReturnsForAnyArgs(usxText);
ParatextService.UpdateBookTextAsync(null, null, null, null, null).ReturnsForAnyArgs(usxText);
var realtimeService = Substitute.For <IRealtimeService>();
FileSystemService = Substitute.For <IFileSystemService>();
var logger = Substitute.For <ILogger <ParatextSyncRunner> >();
Runner = new ParatextSyncRunner(siteOptions, users, Jobs, Projects, Texts, engineService,
ParatextService, realtimeService, FileSystemService, logger);
Runner._job = Jobs.Get("1234");
}
