public void DisplayJobOnDateTime()
{
try {
ResultJob.Clear();
foreach (JobPerson jobObj in JobListe)
{
if (jobObj.JobDateTime == SingletonDateTime)
{
ResultJob.Add(jobObj);
}
}
}
catch (Exception e)
{
Debug.Write($"Exception: { e }");
}
}
private void ExcuteRecords()
{
Console.WriteLine("ExcuteRecords start ");
if (this.RunningJob.JobId == null)
{
throw new ArgumentException("Running job must contain JobId");
}
bool hasmore; int pageNumber = 1;
do
{
//this.connectionString
var getRecordsById = GetRecordsById(pageNumber, commandJobHandler.CofigurationJob.RowspPage, out hasmore);
pageNumber += 1;
//1 מוכן לטעינה
//2 בתהליך
//3 הסתיים
//4 נכשל
Console.WriteLine("ExcuteRecords before foreach ");
foreach (var record in getRecordsById)
{
Console.WriteLine("ExcuteRecords foreach : " + runningJob.Total.ToString());
int status = 0; string action = "";
try
{
runningJob.Total++;
UpdateOnProgressRow(record);
Console.WriteLine("ExcuteRecords foreach after UpdateOnProgressRow ");
ResultJob returnValues = commandJobHandler.Execute(record.JobRecord, _errorHandler.WriteLog);
action = returnValues.ToString();
Console.WriteLine("ExcuteRecords foreach after returnValues ");
if (returnValues.HasFlag(ResultJob.Insert))
{
runningJob.Insert++;
}
if (returnValues.HasFlag(ResultJob.Update))
{
runningJob.Update++;
}
if (returnValues.HasFlag(ResultJob.NoUpdate))
{
runningJob.NoUpdate++;
}
if (returnValues.HasFlag(ResultJob.Failed) || returnValues.HasFlag(ResultJob.FailedRetry))
{
runningJob.Failed++;
}
else
{
runningJob.Success++;
}
if (returnValues.HasFlag(ResultJob.FailedRetry))
{
status = (int)StatusRecord.Failed;
}
else
{
status = (int)StatusRecord.Finish;
}
Console.WriteLine("ExcuteRecords foreach finish");
}
catch (FaultException <OrganizationServiceFault> fex)
{
if (_errorHandler != null)
{
_errorHandler.WriteLog(record.JobRecord, fex.StackTrace + "_" + fex.Message, EventLogEntryType.Error);
}
runningJob.Failed++;
HandleFualtException(fex, ref status);
Console.WriteLine("Error: " + fex.Message + Environment.NewLine + fex.InnerException);
}
catch (Exception e)
{
if (_errorHandler != null)
{
_errorHandler.WriteLog(record.JobRecord, e.StackTrace + "_ex_" + e.ToString(), EventLogEntryType.Error);
}
runningJob.Failed++;
HandleUnHandeledExc(e, ref status);
Console.WriteLine("Error: " + e.Message + Environment.NewLine + e.InnerException);
}
finally
{
UpdateRow(record, status, action);
}
Console.WriteLine("ResultJob.Insert " + ResultJob.Insert);
Console.WriteLine("ResultJob.Update " + ResultJob.Update);
}
}while (hasmore == true);
JobUtilHelper.UpdateBulkUpdate(runningJob.JobId.Value);
Console.WriteLine("ExcuteRecords end ");
}
public InstallEvent(string message, string tmpfilelog, ResultJob rj)
{
Message = message;
TmpFileLog = tmpfilelog;
RJ = rj;
}
static void Main(string[] args)
{
using (var driver = new ChromeDriver())
{
/* Initialization */
string projectTitle = ""; // Project Name
string firstStepName = "InternalReview";
Console.WriteLine("Hi, please chose TMS project name: \n" +
"1) Porsche BAL 2.0 \n" +
"2) Porsche Cosima");
int projectChose = Int32.Parse(Console.ReadLine());
switch (projectChose)
{
case 1:
projectTitle = "Porsche BAL 2.0";
break;
case 2:
projectTitle = "Porsche Cosima";
break;
default:
System.Environment.Exit(1);
break;
}
Console.WriteLine("Now, please chose TMS setting name: \n" +
"1) Internal Review; " +
"2) Editing");
int settingChose = Int32.Parse(Console.ReadLine());
switch (settingChose)
{
case 1:
firstStepName = "InternalReview";
break;
case 2:
firstStepName = "Editing";
break;
default:
System.Environment.Exit(1);
break;
}
var wait = new WebDriverWait(driver, TimeSpan.FromSeconds(60));
driver.Manage().Window.Maximize();
driver.Navigate().GoToUrl("https://tms.lionbridge.com/");
ProjectsPage testPage = new ProjectsPage(driver, projectTitle);
testPage.ClickChosenProject();
ParticularProjectPage testProjectPage = new ParticularProjectPage(driver);
testProjectPage.ProfileClick(driver);
testProjectPage.ChangeItemsPerPageMin(driver);
testProjectPage.StatusClick(driver);
StatusPage testStatusPage = new StatusPage(driver);
testStatusPage.AssigneesClick(driver);
AssigneesPage porscheAssigneesPage = new AssigneesPage(driver);
if (porscheAssigneesPage.ChosenActivityClick(driver, firstStepName) != 1)
{
Console.WriteLine("There is no {0} steps!", firstStepName);
return;
}
porscheAssigneesPage = new AssigneesPage(driver);
PageBar testPageBar = new PageBar(driver);
testPageBar.ItemsPerPageSetMaximalValue(driver);
AssigneesAndJobs asob = new AssigneesAndJobs(driver);
List <StatusAssigneeInfo> listOfStatusAssgineeInfo = new List <StatusAssigneeInfo>();
StatusAssigneeInfo auxiliary;
foreach (var ass in asob.assigneesJobsList)
{
Console.WriteLine(ass.GetJobsName);
}
foreach (Assignee ass in asob.assigneesList)
{
for (int i = 0; i < ass.GetAssingeeJobsNumberInt; i++)
{
auxiliary = new StatusAssigneeInfo(ass, asob.assigneesJobsList.ElementAt(i));
listOfStatusAssgineeInfo.Add(auxiliary);
}
for (int i = 0; i < ass.GetAssingeeJobsNumberInt; i++)
{
asob.assigneesJobsList.RemoveAt(0);
}
Console.WriteLine(ass.GetAssigneeName + " " + ass.GetAssingeeJobsNumberInt);
}
foreach (var ass in listOfStatusAssgineeInfo)
{
Console.WriteLine(ass.jobName + " " + ass.reviewerName + " " + ass.sourceLanguage);
}
asob = new AssigneesAndJobs(driver);
asob.TagMultipleJobs(driver, 0, asob.GetAssigneeJobsListSize - 1);
ViewsMenu assigneesViewsMenu = new ViewsMenu(driver);
assigneesViewsMenu.JobsView.ButtonClick();
JobsSectionJobs jsj = new JobsSectionJobs(driver);
jsj.jobsPageBar.ItemsPerPageSetMaximalValue(driver);
jsj = new JobsSectionJobs(driver);
IReadOnlyCollection <IWebElement> auxiliaryCollection;
ResultJob auxiliaryJobs = new ResultJob();
IWebElement jobsResultsContainer;
IJavaScriptExecutor jse;
string path = Path.Combine(Directory.GetCurrentDirectory(), "TestFile.csv");
using (StreamWriter sw = new StreamWriter(path))
{
string[] values1 = { "Job Name", "Reviewer Name", "Translator Name", "Source Language", "Target Language", "Effort", "Wordcount" };
string line1 = String.Join(";", values1);
sw.WriteLine(line1);
foreach (var info in listOfStatusAssgineeInfo)
{
jse = (IJavaScriptExecutor)driver;
jse.ExecuteScript("arguments[0].scrollIntoView();", jsj.GetJobElement(driver, info.jobName));
jsj.ShowHistoryOfJob(driver, info.jobName);
JobHistoryFilter filter = new JobHistoryFilter(driver);
filter.FiltersPanelInitialization(driver);
filter.ChosenActivityClick(driver, "Translation");
filter = new JobHistoryFilter(driver);
filter.FiltersPanelInitialization(driver);
filter.SourceLanguageFilterClick(driver);
filter.ChosenSourceLanguageClick(driver, info.sourceLanguage);
filter = new JobHistoryFilter(driver);
filter.FiltersPanelInitialization(driver);
filter.TargetLanguageFilterClick(driver);
filter.ChosenTargetLanguageClick(driver, info.targetLanguage);
wait.Until(ExpectedConditions.ElementIsVisible(By.ClassName("r_L")));
auxiliaryCollection = driver.FindElements(By.Id("pup_avw"));
jobsResultsContainer = auxiliaryCollection.ElementAt(0);
auxiliaryCollection = jobsResultsContainer.FindElements(By.ClassName("r_L"));
auxiliaryJobs = new ResultJob(auxiliaryCollection.ElementAt(0));
listOfStatusAssgineeInfo.ElementAt(listOfStatusAssgineeInfo.IndexOf(info)).TranslatorName = auxiliaryJobs.GetTranlatorName;
PopUpBody popuPBody = new PopUpBody(driver);
popuPBody.CloseButtonClick(driver);
string[] values = { info.jobName, info.reviewerName, info.translatorName, info.sourceLanguage, info.targetLanguage, info.effort, info.wordcount };
string line = String.Join(";", values);
sw.WriteLine(line);
}
sw.Flush();
}
// iterates over the users
//foreach (var info in listOfStatusAssgineeInfo)
// {
// creates an array of the user's values
// string[] values = { info.jobName, info.reviewerName, info.translatorName, info.sourceLanguage, info.targetLanguage };
// creates a new line
// string line = String.Join(";", values);
// writes the line
// sw.WriteLine(line);
// }
// flushes the buffer
// sw.Flush();
// }
}
}
public void WholeProgram_NewParsingCorrectly_Test_3()
{
using (var driver = new ChromeDriver())
{
/* Initialization */
var wait = new WebDriverWait(driver, TimeSpan.FromSeconds(60));
driver.Manage().Window.Maximize();
driver.Navigate().GoToUrl("https://tms.lionbridge.com/");
string projectName = ""; // Project Name
ProjectsPage testPage = new ProjectsPage(driver, projectName);
testPage.ClickChosenProject();
ParticularProjectPage testProjectPage = new ParticularProjectPage(driver);
testProjectPage.ProfileClick(driver);
testProjectPage.ChangeItemsPerPageMin(driver);
testProjectPage.StatusClick(driver);
StatusPage testStatusPage = new StatusPage(driver);
testStatusPage.AssigneesClick(driver);
AssigneesPage porscheAssigneesPage = new AssigneesPage(driver);
porscheAssigneesPage.ChosenActivityClick(driver, "InternalReview");
porscheAssigneesPage = new AssigneesPage(driver);
PageBar testPageBar = new PageBar(driver);
testPageBar.ItemsPerPageSetMaximalValue(driver);
AssigneesAndJobs asob = new AssigneesAndJobs(driver);
List <StatusAssigneeInfo> listOfStatusAssgineeInfo = new List <StatusAssigneeInfo>();
StatusAssigneeInfo auxiliary;
foreach (Assignee ass in asob.assigneesList)
{
for (int i = 0; i < ass.GetAssingeeJobsNumberInt; i++)
{
auxiliary = new StatusAssigneeInfo(ass, asob.assigneesJobsList.ElementAt(i));
listOfStatusAssgineeInfo.Add(auxiliary);
}
asob.assigneesJobsList.RemoveRange(0, ass.GetAssingeeJobsNumberInt - 1);
}
asob = new AssigneesAndJobs(driver);
asob.TagMultipleJobs(driver, 0, asob.GetAssigneeJobsListSize - 1);
ViewsMenu assigneesViewsMenu = new ViewsMenu(driver);
assigneesViewsMenu.JobsView.ButtonClick();
JobsSectionJobs jsj = new JobsSectionJobs(driver);
IReadOnlyCollection <IWebElement> auxiliaryCollection;
ResultJob auxiliaryJobs = new ResultJob();
IWebElement jobsResultsContainer;
foreach (var info in listOfStatusAssgineeInfo)
{
jsj.ShowHistoryOfJob(driver, info.jobName);
JobHistoryFilter filter = new JobHistoryFilter(driver);
filter.FiltersPanelInitialization(driver);
filter.ChosenActivityClick(driver, "Translation");
filter = new JobHistoryFilter(driver);
filter.FiltersPanelInitialization(driver);
filter.SourceLanguageFilterClick(driver);
filter.ChosenSourceLanguageClick(driver, info.sourceLanguage);
filter = new JobHistoryFilter(driver);
filter.FiltersPanelInitialization(driver);
filter.TargetLanguageFilterClick(driver);
filter.ChosenTargetLanguageClick(driver, info.targetLanguage);
wait.Until(ExpectedConditions.ElementIsVisible(By.ClassName("r_L")));
auxiliaryCollection = driver.FindElements(By.Id("pup_avw"));
jobsResultsContainer = auxiliaryCollection.ElementAt(0);
auxiliaryCollection = jobsResultsContainer.FindElements(By.ClassName("r_L"));
auxiliaryJobs = new ResultJob(auxiliaryCollection.ElementAt(0));
listOfStatusAssgineeInfo.ElementAt(listOfStatusAssgineeInfo.IndexOf(info)).TranslatorName = auxiliaryJobs.GetTranlatorName;
PopUpBody popuPBody = new PopUpBody(driver);
popuPBody.CloseButtonClick(driver);
}
string path = Path.Combine(Directory.GetCurrentDirectory(), "TestFile.csv");
using (StreamWriter sw = new StreamWriter(path))
{
// iterates over the users
foreach (var info in listOfStatusAssgineeInfo)
{
// creates an array of the user's values
string[] values = { info.jobName, info.reviewerName, info.translatorName, info.sourceLanguage, info.targetLanguage };
// creates a new line
string line = String.Join(";", values);
// writes the line
sw.WriteLine(line);
}
// flushes the buffer
sw.Flush();
}
}
}
public void WholeProgram_NewParsingCorrectly_Test_1()
{
using (var driver = new ChromeDriver())
{
/* Initialization */
var wait = new WebDriverWait(driver, TimeSpan.FromSeconds(60));
driver.Manage().Window.Maximize();
driver.Navigate().GoToUrl("https://tms.lionbridge.com/");
string projectName = ""; // Project Name
ProjectsPage testPage = new ProjectsPage(driver, projectName);
testPage.ClickChosenProject();
ParticularProjectPage testProjectPage = new ParticularProjectPage(driver);
testProjectPage.ProfileClick(driver);
testProjectPage.ChangeItemsPerPageMin(driver);
testProjectPage.StatusClick(driver);
StatusPage testStatusPage = new StatusPage(driver);
testStatusPage.AssigneesClick(driver);
AssigneesPage porscheAssigneesPage = new AssigneesPage(driver);
porscheAssigneesPage.ChosenActivityClick(driver, "InternalReview");
porscheAssigneesPage = new AssigneesPage(driver);
PageBar testPageBar = new PageBar(driver);
testPageBar.ItemsPerPageSetMaximalValue(driver);
AssigneesAndJobs asob = new AssigneesAndJobs(driver);
List <StatusAssigneeInfo> listOfStatusAssgineeInfo = new List <StatusAssigneeInfo>();
StatusAssigneeInfo auxiliary;
foreach (Assignee ass in asob.assigneesList)
{
for (int i = 0; i < ass.GetAssingeeJobsNumberInt; i++)
{
auxiliary = new StatusAssigneeInfo(ass, asob.assigneesJobsList.ElementAt(i));
listOfStatusAssgineeInfo.Add(auxiliary);
}
asob.assigneesJobsList.RemoveRange(0, ass.GetAssingeeJobsNumberInt - 1);
}
asob = new AssigneesAndJobs(driver);
asob.TagMultipleJobs(driver, 0, asob.GetAssigneeJobsListSize - 1);
ViewsMenu assigneesViewsMenu = new ViewsMenu(driver);
assigneesViewsMenu.JobsView.ButtonClick();
JobsSectionJobs jsj = new JobsSectionJobs(driver);
jsj.ShowHistoryOfJob(driver, listOfStatusAssgineeInfo.ElementAt(0).jobName.Trim());
JobHistoryFilter filter = new JobHistoryFilter(driver);
filter.FiltersPanelInitialization(driver);
filter.ChosenActivityClick(driver, "Translation");
filter = new JobHistoryFilter(driver);
filter.FiltersPanelInitialization(driver);
filter.SourceLanguageFilterClick(driver);
filter.ChosenSourceLanguageClick(driver, listOfStatusAssgineeInfo.ElementAt(0).sourceLanguage);
filter = new JobHistoryFilter(driver);
filter.FiltersPanelInitialization(driver);
filter.TargetLanguageFilterClick(driver);
filter.ChosenTargetLanguageClick(driver, listOfStatusAssgineeInfo.ElementAt(0).targetLanguage);
IReadOnlyCollection <IWebElement> auxiliaryCollection;
ResultJob auxiliaryJobs = new ResultJob();
wait.Until(ExpectedConditions.ElementIsVisible(By.ClassName("r_L")));
auxiliaryCollection = driver.FindElements(By.Id("pup_avw"));
IWebElement jobsResultsContainer = auxiliaryCollection.ElementAt(0);
auxiliaryCollection = jobsResultsContainer.FindElements(By.ClassName("r_L"));
auxiliaryJobs = new ResultJob(auxiliaryCollection.ElementAt(0));
listOfStatusAssgineeInfo.ElementAt(0).TranslatorName = auxiliaryJobs.GetTranlatorName;
string path = Path.Combine(Directory.GetCurrentDirectory(), "TestFile");
using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(path, SpreadsheetDocumentType.Workbook))
{
// Add a WorkbookPart to the document.
WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();
workbookpart.Workbook = new Workbook();
// Add a WorksheetPart to the WorkbookPart.
WorksheetPart worksheetPart = workbookpart.AddNewPart <WorksheetPart>();
worksheetPart.Worksheet = new Worksheet(new SheetData());
// Add Sheets to the Workbook.
Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.
AppendChild <Sheets>(new Sheets());
// Append a new worksheet and associate it with the workbook.
Sheet sheet = new Sheet()
{
Id = spreadsheetDocument.WorkbookPart.
GetIdOfPart(worksheetPart),
SheetId = 1,
Name = "mySheet"
};
sheets.Append(sheet);
SheetData sheetData = worksheetPart.Worksheet.GetFirstChild <SheetData>();
UInt32 rowIndex = 0;
foreach (var info in listOfStatusAssgineeInfo)
{
var row = new Row()
{
RowIndex = rowIndex
};
var firstNameCell = new Cell()
{
CellReference = "A" + (rowIndex + 1)
};
firstNameCell.CellValue = new CellValue(info.jobName);
firstNameCell.DataType = CellValues.String;
row.AppendChild(firstNameCell);
Cell secondNameCell = new Cell()
{
CellReference = "B" + (rowIndex + 1)
};
secondNameCell.CellValue = new CellValue(info.sourceLanguage);
secondNameCell.DataType = new EnumValue <CellValues>(CellValues.String);
row.AppendChild(secondNameCell);
Cell thirdNameCell = new Cell()
{
CellReference = "C" + (rowIndex + 1)
};
thirdNameCell.CellValue = new CellValue(info.targetLanguage);
thirdNameCell.DataType = new EnumValue <CellValues>(CellValues.String);
row.AppendChild(thirdNameCell);
Cell fourthNameCell = new Cell()
{
CellReference = "D" + (rowIndex + 1)
};
fourthNameCell.CellValue = new CellValue(info.reviewerName);
fourthNameCell.DataType = new EnumValue <CellValues>(CellValues.String);
row.AppendChild(fourthNameCell);
Cell fifthNameCell = new Cell()
{
CellReference = "E" + (rowIndex + 1)
};
fifthNameCell.CellValue = new CellValue(info.TranslatorName);
fifthNameCell.DataType = new EnumValue <CellValues>(CellValues.String);
row.AppendChild(fifthNameCell);
sheetData.AppendChild(row);
rowIndex++;
}
workbookpart.Workbook.Save();
}
/*SearchResults sr = new SearchResults(driver);
* Assert.AreEqual("", sr.jobsList.ElementAt(0).GetTranlatorName);*/
/*jsj.ShowHistoryOfJob(driver, 0);
*
* PopUpBody body = new PopUpBody(driver);
* JobHistoryFilter filter = new JobHistoryFilter(driver);
*
* filter.FiltersPanelInitialization(driver);
* filter.ChosenActivityClick(driver, "Translation");*/
//filter.ChosenSourceLanguageClick(driver, asob.)
Thread.Sleep(5000);
}
}
