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);
}
