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