public void TestCodeRejection()
{
ConversionExcelDataToList c**t = new ConversionExcelDataToList();
c**t.path = @"C:\Users\43743418\Desktop\Project Doc\Epass Stage 1 & 2 automation tool.xlsx";
OleDbConnection objExcelCon = c**t.openExcel();
List <RejectionCode> PMrejectonList = c**t.GetExcelDataBySheetName <RejectionCode>(objExcelCon, "PM rejection code");
List <RejectionCode> ACrejectonList = c**t.GetExcelDataBySheetName <RejectionCode>(objExcelCon, "AC rejection code");
string remark = GetCodeRejection("AC", new string[] { "1", "2", "3" }, PMrejectonList, ACrejectonList);
}
public void TestRunCaseGwis()
{
ConversionExcelDataToList c**t = new ConversionExcelDataToList();
c**t.path = @"L:\GZT_RBT\Private\Production\2B\SA Level\2b Logging\Jasmine\Robot\Project Doc\Epass Stage 1 & 2 automation tool.xlsx";
Dictionary <string, List <ExcelWhlist> > ewhlistdic = new Dictionary <string, List <ExcelWhlist> >();
OleDbConnection objExcelCon = c**t.openExcel();
ewhlistdic = c**t.ExtractEmployeeExcel <ExcelWhlist>(objExcelCon, "White List");
ExcelWhlist passModel = ewhlistdic["White List"].ToList().Where(x => x.Clean_Case == "Y").ToList().FirstOrDefault();
GwisOperationLogic gwisOperation = new GwisOperationLogic();
gwisOperation.SetOption(passModel, "MANULIFE");
}
public void TestEpassGwis()
{
string remark = @"Ext. PC received, but Missing/Incorrect member name, Please be reminded to submit Statement to certify signature if necessary next time, L/O 2016/6/16 to trustee";
ConversionExcelDataToList c**t = new ConversionExcelDataToList();
c**t.path = @"L:\GZT_RBT\Private\Production\2B\SA Level\2b Logging\Jasmine\Robot\Project Doc\Epass Stage 1 & 2 automation tool.xlsx";
Dictionary <string, List <ExcelWhlist> > ewhlistdic = new Dictionary <string, List <ExcelWhlist> >();
OleDbConnection objExcelCon = c**t.openExcel();
ewhlistdic = c**t.ExtractEmployeeExcel <ExcelWhlist>(objExcelCon, "White List");
ExcelWhlist passModel = ewhlistdic["White List"].ToList().Where(x => x.Clean_Case == "N").ToList().FirstOrDefault();
GwisOperationLogic gwisOperation = new GwisOperationLogic();
gwisOperation.EpassUpadateGwis(passModel, remark);
}
