/// <summary>
/// Login success scenario
/// </summary>
/// <remarks>
/// If already-logged in session exists, preventing login dialog from showing, this will logout and login with 'remember me' unchecked
/// </remarks>
/// <param name="deRibbonTabElement"></param>
/// <param name="loginEmail"></param>
/// <param name="loginPassword"></param>
/// <exception cref="ApplicationException">Login failed for any reason</exception>
public static void LoginExpectSuccess(AddinRibbonController ribbon, string loginEmail, string loginPassword)
{
var loginDialog = OpenLoginDialog(ribbon);
loginDialog.Email = loginEmail;
loginDialog.Password = loginPassword;
loginDialog.RememberMe = false;
loginDialog.SelectOkVerifySuccess();
}
/// <summary>
/// Login success scenario
/// </summary>
/// <remarks>
/// If already-logged in session exists, preventing login dialog from showing, this will logout and login with 'remember me' unchecked
/// </remarks>
/// <param name="deRibbonTabElement"></param>
/// <param name="loginEmail"></param>
/// <param name="loginPassword"></param>
/// <exception cref="ApplicationException">Login failed for any reason</exception>
public static void LoginExpectSuccess(AddinRibbonController ribbon, string loginEmail, string loginPassword)
{
var loginDialog = OpenLoginDialog(ribbon);
loginDialog.Email = loginEmail;
loginDialog.Password = loginPassword;
loginDialog.RememberMe = false;
loginDialog.SelectOkVerifySuccess();
}
/// <summary>
/// Open login dialog, first closing a remember-me logged-in scenario if necessary
/// </summary>
public static LoginDriver OpenLoginDialog(AddinRibbonController ribbon)
{
ribbon.InvokeButton(AddinRibbonButton.Login);
return(LoginDriver.FindFromParent(ribbon.ExcelElement));
}
/// <summary>
/// Open login dialog, first closing a remember-me logged-in scenario if necessary
/// </summary>
public static LoginDriver OpenLoginDialog(AddinRibbonController ribbon)
{
ribbon.InvokeButton(AddinRibbonButton.Login);
return LoginDriver.FindFromParent(ribbon.ExcelElement);
}
private Excel.Worksheet InsertOKToModifyItemData(AddinRibbonController ribbon, string itemName, bool getSecondInstance)
{
//Login
if ( ! getSecondInstance)
{
AddinTestUtility.LoginExpectSuccess(ribbon, AddinTestUtility.LoginEmail, AddinTestUtility.LoginPsw);
}
//Insert item
ribbon.InvokeButton(AddinRibbonButton.InsertItem);
var itemDlg = InsertItemDriver.FindFromParent(ribbon.ExcelElement);
itemDlg.SelectedItem = itemName;
itemDlg.AllowPublish = true;
itemDlg.SelectInsertVerifySuccess();
//Wait for item to be inserted in item-named worksheet
var sheetName = itemName;
if (getSecondInstance)
{
sheetName += " 1";
}
var ws = ExcelAutoUtility.GetWorkSheetWithTimeout(_wb.Wb, sheetName, AddinTestUtility.WebServiceResponsePopulateTimeout);
//Wait for access to worksheet to be stable
ExcelAutoUtility.WaitForNewWorksheetToBeAccessible(ws);
return ws;
}
private void CreateItemDialogCreateSimpleItem(AddinRibbonController ribbon, string newItemName, string newItemDescr)
{
//Login
AddinTestUtility.LoginExpectSuccess(ribbon, AddinTestUtility.LoginEmail, AddinTestUtility.LoginPsw);
//Create a data range from which to create item
var sheet = _wb.Wb.ActiveSheet as Excel.Worksheet;
ExcelAutoUtility.SetCellValue(sheet, 1, 1, "colA");
ExcelAutoUtility.SetCellValue(sheet, 1, 2, "colB");
ExcelAutoUtility.SetCellValue(sheet, 2, 1, 1);
ExcelAutoUtility.SetCellValue(sheet, 2, 2, 2);
ExcelAutoUtility.SetCellValue(sheet, 3, 1, 3);
ExcelAutoUtility.SetCellValue(sheet, 3, 2, 4);
var range = sheet.get_Range("A1", "B3");
range.Select();
//Create item
ribbon.InvokeButton(AddinRibbonButton.Create);
var createItemDlg = CreateItemDriver.FindFromParent(ribbon.ExcelElement);
createItemDlg.Name = newItemName;
createItemDlg.Desc = newItemDescr;
createItemDlg.SelectCreateVerifySuccess();
}
