public static void CodeTransmit_Action_ImportDB(Case.BasicTestCase refTestCase, CodeLine activeSelectLine) { if (refTestCase != null && activeSelectLine.KeyCode == Container.KeyWordMap.ImportDB) { if (activeSelectLine.ParamsPool.ContainsKey("name") && activeSelectLine.ParamsPool.ContainsKey("server") && activeSelectLine.ParamsPool.ContainsKey("table") && activeSelectLine.ParamsPool.ContainsKey("db") && activeSelectLine.ParamsPool.ContainsKey("uid") && activeSelectLine.ParamsPool.ContainsKey("pwd")) { try { string sourceName = activeSelectLine.ParamsPool["name"]; string server = activeSelectLine.ParamsPool["server"]; string db = activeSelectLine.ParamsPool["db"]; string uid = activeSelectLine.ParamsPool["uid"]; string pwd = activeSelectLine.ParamsPool["pwd"]; string table = activeSelectLine.ParamsPool["table"]; Buffalo.Basic.Data.Data_SqlConnectionHelper _ConnectionObj = new Basic.Data.Data_SqlConnectionHelper(); _ConnectionObj.Set_NewConnectionItem(sourceName, server, uid, pwd, db); Buffalo.Basic.Data.Data_SqlDataHelper _SqlDataHelper = new Basic.Data.Data_SqlDataHelper(); _SqlDataHelper.ActiveConnection = _ConnectionObj.Get_ActiveConnection(sourceName); DataTable activeDataTable = new DataTable(); _SqlDataHelper.Action_ExecuteForDT("select * from " + table, out activeDataTable); XmlDocument sourceDataDoc = new XmlDocument(); sourceDataDoc.LoadXml("<root></root>"); List<string> columnNameList = new List<string>(); foreach (DataColumn dc in activeDataTable.Columns) { columnNameList.Add(dc.ColumnName); } int rowIndex = 1; foreach (DataRow dr in activeDataTable.Rows) { XmlNode newRowItem = Buffalo.Basic.Data.XmlHelper.CreateNode(sourceDataDoc, "row", ""); Buffalo.Basic.Data.XmlHelper.SetAttribute(newRowItem, "index", rowIndex.ToString()); foreach (string columnName in columnNameList) { string result = ""; _SqlDataHelper.Static_GetColumnData(dr, columnName, out result); Buffalo.Basic.Data.XmlHelper.SetAttribute(newRowItem, "column_" + columnName, result); } sourceDataDoc.SelectSingleNode("/root").AppendChild(newRowItem); } } catch (Exception err) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Import DB : " + err.Message, true); } } else { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Import DB : invalidate word.", true); } } }
public static void CodeTransmit_Action_WebBrowser(Case.CaseMethodItem refCaseMethodItemObj, Case.BasicTestCase refActiveCase, CodeLine activeSelectLine) { if (refCaseMethodItemObj != null && activeSelectLine.KeyCode == Container.KeyWordMap.WBAction) { try { refCaseMethodItemObj.Index = activeSelectLine.CodeIndex; refCaseMethodItemObj.ActiveMethod = new ElementActions.MethodItem(); refCaseMethodItemObj.ActiveMethod.ActiveType = typeof(WebDriver.WebBrowserActions); refActiveCase.ActiveCaseWebBrowserPool.Add(refCaseMethodItemObj.Index, refCaseMethodItemObj); object[] methodParam; foreach (string paramName in activeSelectLine.ParamsPool.Keys) { switch (paramName) { case WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_StartBrowser: refCaseMethodItemObj.ActiveMethod.ActiveMethod = refCaseMethodItemObj.ActiveMethod.ActiveType.GetMethod(WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_StartBrowser); if (activeSelectLine.ParamsPool[paramName] != Container.KeyWordMap.Null) { methodParam = new object[] { activeSelectLine.ParamsPool[paramName] }; refCaseMethodItemObj.ActiveMethod.MethodParams = methodParam; } break; case WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_SwitchToWindow: refCaseMethodItemObj.ActiveMethod.ActiveMethod = refCaseMethodItemObj.ActiveMethod.ActiveType.GetMethod(WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_SwitchToWindow); if (activeSelectLine.ParamsPool[paramName] != Container.KeyWordMap.Null) { methodParam = new object[] { activeSelectLine.ParamsPool[paramName] }; refCaseMethodItemObj.ActiveMethod.MethodParams = methodParam; } break; case WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_CloseWindow: refCaseMethodItemObj.ActiveMethod.ActiveMethod = refCaseMethodItemObj.ActiveMethod.ActiveType.GetMethod(WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_CloseWindow); break; case WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_Action_IsAlert: refCaseMethodItemObj.ActiveMethod.ActiveMethod = refCaseMethodItemObj.ActiveMethod.ActiveType.GetMethod(WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_Action_IsAlert); break; case WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_GetCurrentWindowHandle: refCaseMethodItemObj.ActiveMethod.ActiveMethod = refCaseMethodItemObj.ActiveMethod.ActiveType.GetMethod(WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_SwitchToWindow); break; case WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_GetSourceOfPage: refCaseMethodItemObj.ActiveMethod.ActiveMethod = refCaseMethodItemObj.ActiveMethod.ActiveType.GetMethod(WebDriver.WebBrowserActionsMap.Method_Action_WB_Action_SwitchToWindow); <<<<<<< HEAD break; ======= break;
public static void CodeTransmit_Action_ImportXML(Case.BasicTestCase refTestCase, CodeLine activeSelectLine) { if (refTestCase != null && activeSelectLine.KeyCode == Container.KeyWordMap.ImportDB) { if (activeSelectLine.ParamsPool.ContainsKey("name") && activeSelectLine.ParamsPool.ContainsKey("source")) { string sourceFile = activeSelectLine.ParamsPool["source"]; XmlDocument tmpDoc = new XmlDocument(); XmlDocument sourceDataDoc = new XmlDocument(); sourceDataDoc.LoadXml("<root></root>"); try { tmpDoc.Load(sourceFile); XmlNodeList rowNodes = tmpDoc.SelectNodes("/root/row"); int rowIndex = 1; foreach (XmlNode rowNode in rowNodes) { XmlNode newRowNode = Buffalo.Basic.Data.XmlHelper.CreateNode(sourceDataDoc, "row", ""); Buffalo.Basic.Data.XmlHelper.SetAttribute(newRowNode, "index", rowIndex.ToString()); foreach (XmlAttribute activeAttr in rowNode.Attributes) { string value = Buffalo.Basic.Data.XmlHelper.GetNodeValue("@" + activeAttr.Name, rowNode); Buffalo.Basic.Data.XmlHelper.SetAttribute(newRowNode, "column_" + activeAttr.Name, value); } sourceDataDoc.SelectSingleNode("/root").AppendChild(newRowNode); rowIndex++; } } catch (Exception err) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Import XML : " + err.Message, true); } } else { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Import XML : invalidate word namd or source.", true); } } }
public static void CodeTransmit_Action_Connect(Case.BasicTestCase refTestCase, WebDriver.WebBrowserDriver refWebBrowserDriver, CodeLine activeSelectLine) { if (activeSelectLine.KeyCode == Container.KeyWordMap.Connect) { try { foreach (string paramName in activeSelectLine.ParamsPool.Keys) { if (paramName == "type") { switch (activeSelectLine.ParamsPool[paramName]) { case "Chrome": case "chrome": case "CHROME": default: refWebBrowserDriver = WebDriver.WebBrowserDriver.CreateInstanceForWebDriver(WebDriver.WebBrowserType.Chrome); break; case "IE": case "ie": refWebBrowserDriver = WebDriver.WebBrowserDriver.CreateInstanceForWebDriver(WebDriver.WebBrowserType.InternetExplorer); break; case "firefox": case "Firefox": refWebBrowserDriver = WebDriver.WebBrowserDriver.CreateInstanceForWebDriver(WebDriver.WebBrowserType.FireFox); break; } } } refTestCase.ActionWebBrowserActionsObject = new WebDriver.WebBrowserActions(refWebBrowserDriver.ActiveWebDriver); refTestCase.ActiveWebBrowserDriverObject = refWebBrowserDriver; refTestCase.ActiveElementSelectorObject = new ElementActions.ElementSelector(refWebBrowserDriver.ActiveWebDriver); } catch (Exception err) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Connect : " + err.Message, true); } } }
public static void CodeTransmit_Action_ImportExcel(Case.BasicTestCase refTestCase, CodeLine activeSelectLine) { if (refTestCase != null && activeSelectLine.KeyCode == Container.KeyWordMap.ImportExcel) { if (activeSelectLine.ParamsPool.ContainsKey("name") && activeSelectLine.ParamsPool.ContainsKey("excel") && activeSelectLine.ParamsPool.ContainsKey("sheet") && activeSelectLine.ParamsPool.ContainsKey("rows") && activeSelectLine.ParamsPool.ContainsKey("columns")) { try { string sourceName = activeSelectLine.ParamsPool["name"]; Buffalo.Basic.Data.ExcelConnectionHelper _ConnectionObj = new Basic.Data.ExcelConnectionHelper(); string guid = Guid.NewGuid().ToString(); _ConnectionObj.AddNewExcelConnection(guid, activeSelectLine.ParamsPool["excel"], Basic.Data.ExcelConnectionType.NPOI, false); Buffalo.Basic.Data.ExcelConnection_NPIO activeExcelConnection = (Buffalo.Basic.Data.ExcelConnection_NPIO)_ConnectionObj.GetConnection(guid); string str_maxRow = activeSelectLine.ParamsPool["rows"]; string str_maxColumn = activeSelectLine.ParamsPool["columns"]; int i_maxRow = 0; int i_maxColumn = 0; Int32.TryParse(str_maxRow, out i_maxRow); Int32.TryParse(str_maxColumn, out i_maxColumn); XmlDocument sourceDataDoc = new XmlDocument(); sourceDataDoc.LoadXml("<root></root>"); for (int i = 1; i <= i_maxRow; i++) { XmlNode rowNode = Buffalo.Basic.Data.XmlHelper.CreateNode(sourceDataDoc, "row", ""); Buffalo.Basic.Data.XmlHelper.SetAttribute(rowNode, "index", i.ToString()); for (int y = 1; y <= i_maxColumn; y++) { string value = activeExcelConnection.GetCellValue(activeSelectLine.ParamsPool["sheet"], i, y); Buffalo.Basic.Data.XmlHelper.SetAttribute(rowNode, "column_" + y, value); } sourceDataDoc.SelectSingleNode("/root").AppendChild(rowNode); } if (!refTestCase.ActiveCaseDataSourcePool.ContainsKey(sourceName)) { refTestCase.ActiveCaseDataSourcePool.Add(sourceName, sourceDataDoc); } else { refTestCase.ActiveCaseDataSourcePool[sourceName] = sourceDataDoc; } } catch (Exception err) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Import Excel : " + err.Message, true); } } } }
public static void CodeTransmit_Action_DataFill(Case.BasicTestCase refTestCase, CodeLine activeSelectLine) { if (refTestCase != null && activeSelectLine.KeyCode == Container.KeyWordMap.DataFill) { if (!activeSelectLine.ParamsPool.ContainsKey("sourcename")) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Data Fill : missing sourcename.", true); return; } else { if (!activeSelectLine.ParamsPool.ContainsKey("dataname")) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Data Fill : missing dataname.", true); return; } else { string sourcename = activeSelectLine.ParamsPool["sourcename"]; if (!refTestCase.ActiveCaseDataSourcePool.ContainsKey(sourcename)) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Data Fill : can not foune datasource : " + sourcename + ".", true); return; } XmlDocument sourceDoc = refTestCase.ActiveCaseDataSourcePool[sourcename]; if (sourceDoc != null) { if (activeSelectLine.ParamsPool.ContainsKey("row") && activeSelectLine.ParamsPool.ContainsKey("column")) { XmlNodeList rowNodes = sourceDoc.SelectNodes("/root/row"); int MaxRow = rowNodes.Count; if (MaxRow <= 0) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Data Fill : no data row in data source.", true); return; } string RowValue = activeSelectLine.ParamsPool["row"]; string ColumnName = activeSelectLine.ParamsPool["column"]; int RowIndex = 1; if (RowValue == "rand") { Random rnd = new Random(); RowIndex = rnd.Next(1, MaxRow); } else { int.TryParse(activeSelectLine.ParamsPool["row"], out RowIndex); } XmlNode selectedRowNode = sourceDoc.SelectSingleNode("/root/row[@index='" + RowIndex + "']"); if (selectedRowNode != null) { string value = Buffalo.Basic.Data.XmlHelper.GetNodeValue("@column_" + ColumnName, selectedRowNode); string dataname = activeSelectLine.ParamsPool["dataname"]; if (refTestCase.ActiveDataBuffer.ContainsKey(dataname)) refTestCase.ActiveDataBuffer[dataname] = value; else refTestCase.ActiveDataBuffer.Add(dataname, value); } else { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Data Fill : can not found row node.", true); return; } } else { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Data Fill : missing row or column paramter.", true); return; } } else { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Data Fill : datasource : " + sourcename + " is Null.", true); return; } } } } }
public static void CodeTransmit_Action_DataSet(Case.BasicTestCase refTestCase, CodeLine activeSelectLine) { if (refTestCase != null && activeSelectLine.KeyCode == Container.KeyWordMap.DataSet) { if (!activeSelectLine.ParamsPool.ContainsKey("dataname")) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Data Set : missing dataname.", true); return; } else { if (!activeSelectLine.ParamsPool.ContainsKey("value")) { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : Data Set : missing data value.", true); return; } else { string dataName = activeSelectLine.ParamsPool["dataname"]; string dataValue = activeSelectLine.ParamsPool["value"]; if (refTestCase.ActiveDataBuffer.ContainsKey(dataName)) refTestCase.ActiveDataBuffer[dataName] = dataValue; else refTestCase.ActiveDataBuffer.Add(dataName, dataValue); } } } }
public static void CodeTransmit_Action_FillExistedData(Case.BasicTestCase refTestCase, CodeLine activeSelectLine) { foreach (string paramName in activeSelectLine.ParamsPool.Keys) { string paramValue = activeSelectLine.ParamsPool[paramName]; if (paramValue.Contains("%D")) { string dataName = paramValue.Replace("%D", ""); if (refTestCase.ActiveDataBuffer.ContainsKey(dataName)) activeSelectLine.ParamsPool[paramName] = refTestCase.ActiveDataBuffer[dataName]; else { refTestCase.SingleInterrupt = true; refTestCase.ActiveTestCaseReport.InsertFaildItem(activeSelectLine.CodeIndex, "Fail to transmit : No data : " + dataName, true); return; } } } }