public void VerifyErrorMessages()
{
string strTestCaseNo = "TC002_Reg";
strTestType = "Regression";
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("TC02_VerifyErrorMessages");
string[] list;
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataRoster = connection.Select(strtblname, strTestCaseNo, strTestType);
list = connection.Select(strtblname, strTestCaseNo, strTestType);
var TopbarMenu = new clsMainPage_TopbarMenu();
System.Threading.Thread.Sleep(2000);
var RosterAdministration = new clsRosterAdministration();
TopbarMenu.NavigatetoRosterAdministration();
String strTDRosterName = testdataRoster[4];
String strTDPane = testdataRoster[5];
String strTDTimeZoneorLocation = testdataRoster[6];
String strTDTimeZone = testdataRoster[7];
String strTDLocation = testdataRoster[8];
String strTDPeople = testdataRoster[9];
String strTDShiftDetails = testdataRoster[10];
String strTDStatus = testdataRoster[11];
RosterAdministration.VerifyErrorMessages(strTDRosterName, strTDPane, strTDTimeZoneorLocation, strTDTimeZone, strTDLocation, strTDPeople, strTDShiftDetails, strTDStatus);
}
public void TS03_TC05_RosterAdmin_DeleteRoster()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("TS03_TC04_RosterAdmin_DeleteRoster");
String strtblname = "automation_rosteradministration";
string[] list;
var connection = new ConnectToMySQL_Fetch_TestData();
list = connection.Select(strtblname, strTestCaseNo, strTestType);
string strTDRosterName = list[4];
Int64 RosterID = 0;
var TopbarMenu = new clsMainPage_TopbarMenu();
var RosterAdministration = new clsRosterAdministration();
TopbarMenu.NavigatetoRosterAdministration();
string strConnectionString = "Data Source=" + ConfigurationManager.AppSettings["SQLServerDataSource"] + ";Initial Catalog=" + ConfigurationManager.AppSettings["SQLServerInitialCatalog"] + ";User Id=" + ConfigurationManager.AppSettings["SQLServerUserId"] + ";Password="******"SQLServerPassword"];
SqlConnection myConnection = new SqlConnection(strConnectionString);
myConnection.Open();
SqlDataReader reader = null;
String strQuery = "select RosterID from tblRoster where RosterName = '" + strTDRosterName + "';";
SqlCommand command = new SqlCommand(strQuery, myConnection);
reader = command.ExecuteReader();
while (reader.Read())
{
RosterID = Convert.ToInt64(reader.GetValue(0));
Console.WriteLine("RosterID" + RosterID);
}
reader.Close();
String strQuery1 = "delete from tblRoster where RosterID = '" + RosterID + "';";
SqlCommand command1 = new SqlCommand(strQuery1, myConnection);
command1.ExecuteNonQuery();
myConnection.Close();
System.Threading.Thread.Sleep(3000);
string[] rosterdetails = RosterAdministration.RetrieveRosterdetails(list[4]);
string strfbwebrostername = rosterdetails[0];
//try
//{
// Assert.IsNull(strfbwebrostername);
// PropertiesCollection.test.Log(Status.Pass, "Roster : " + list[4] + " is deleted and validated on Roster Admin screen");
//}
//catch
//{
// PropertiesCollection.test.Log(Status.Fail, "Roster Status is not matching");
// throw;
//}
}
public void TC06_RosterAdmin_DeleteRoster()
{
string[] list;
var connection = new ConnectToMySQL_Fetch_TestData();
list = connection.Select(strtblname, strTestCaseNo, strTestType);
var TopbarMenu = new clsMainPage_TopbarMenu();
var RosterAdministration = new clsRosterAdministration();
TopbarMenu.NavigatetoRosterAdministration();
RosterAdministration.DeleteRosterdetails(list[4]);
}
public void DeleteRosterAdmin()
{
string strTestCaseNo = "TC004_Reg";
strTestType = "Regression";
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("TC04_DeleteRosterAdmin");
string[] list;
var connection = new ConnectToMySQL_Fetch_TestData();
list = connection.Select(strtblname, strTestCaseNo, strTestType);
var TopbarMenu = new clsMainPage_TopbarMenu();
var RosterAdministration = new clsRosterAdministration();
TopbarMenu.NavigatetoRosterAdministration();
RosterAdministration.DeleteRosterdetails(list[4]);
}
public void EditRosterAdmin()
{
string strTestCaseNo = "TC003_Reg";
strTestType = "Regression";
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("TC03_EditRosterAdmin");
string[] list;
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataRoster = connection.Select(strtblname, strTestCaseNo, strTestType);
list = connection.Select(strtblname, strTestCaseNo, strTestType);
var TopbarMenu = new clsMainPage_TopbarMenu();
System.Threading.Thread.Sleep(2000);
var RosterAdministration = new clsRosterAdministration();
TopbarMenu.NavigatetoRosterAdministration();
string strTDRosterName = testdataRoster[4];
string strTDShiftDetails = testdataRoster[10];
RosterAdministration.EditRosterdetails(strTDRosterName, strTDShiftDetails);
string[] rosterdetails = RosterAdministration.RetrieveRosterdetails(strTDRosterName);
string strfbwebrostername = rosterdetails[0];
string strfbwebshifttypes = rosterdetails[2];
try
{
Assert.AreEqual(strTDRosterName, strfbwebrostername);
PropertiesCollection.test.Log(Status.Pass, strfbwebrostername + " Updated Roster Validated successfully");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, strfbwebrostername + " Updated Roster not Validated successfully");
}
try
{
Assert.AreEqual(strTDShiftDetails, strfbwebshifttypes);
PropertiesCollection.test.Log(Status.Pass, strfbwebshifttypes + " Updated ShiftTypes validated successfully");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, strfbwebshifttypes + " Updated ShiftTypes not validated successfully");
}
}
public void NavigateRosterAdminBeforeSave()
{
string strTestCaseNo = "TC005_Reg";
strTestType = "Regression";
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("TC05_NavigateRosterAdminBeforeSave");
string[] list;
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataRoster = connection.Select(strtblname, strTestCaseNo, strTestType);
list = connection.Select(strtblname, strTestCaseNo, strTestType);
var TopbarMenu = new clsMainPage_TopbarMenu();
var RosterAdministration = new clsRosterAdministration();
TopbarMenu.NavigatetoRosterAdministration();
string strTDRosterName = testdataRoster[4];
RosterAdministration.NavigateRosterAdminBeforeSave(strTDRosterName);
}
public void TC03_Admin_AddTemplates()
{
var connection = new Database.ConnectToMySQL_Fetch_TestData();
var testdataRoster = connection.Select(strtblname, strTestCaseNo, strTestType);
var TopbarMenu = new clsMainPage_TopbarMenu();
var RosterAdministration = new clsRosterAdministration();
TopbarMenu.NavigatetoRosterAdministration();
String strTDRosterName = testdataRoster[4];
String strTDPane = testdataRoster[5];
String strTDTimeZoneorLocation = testdataRoster[6];
String strTDTimeZone = testdataRoster[7];
String strTDLocation = testdataRoster[8];
String strTDPeople = testdataRoster[9];
String strTDShiftDetails = testdataRoster[10];
String strTDStatus = testdataRoster[11];
RosterAdministration.AddRosterdetails(strTDRosterName, strTDPane, strTDTimeZoneorLocation, strTDTimeZone, strTDLocation, strTDPeople, strTDShiftDetails, strTDStatus);
System.Threading.Thread.Sleep(2000);
String[] rosterdetails = RosterAdministration.RetrieveRosterdetails(strTDRosterName);
String strfbwebrostername = rosterdetails[0];
String strfbwebpane = rosterdetails[1];
String strfbwebshifttypes = rosterdetails[2];
String strfbwebstatus = rosterdetails[3];
Assert.AreEqual(strTDRosterName, strfbwebrostername);
Assert.AreEqual(strTDPane, strfbwebpane);
Assert.AreEqual(strTDShiftDetails, strfbwebshifttypes);
Assert.AreEqual(strTDStatus, strfbwebstatus);
}
public void AddRosterAdmin()
{
strTestCaseNo = "TC001_Reg";
strtblname = "automation_rosteradministration";
strTestType = "Regression";
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("TC01_AddRosterAdmin");
var connection = new Database.ConnectToMySQL_Fetch_TestData();
var testdataRoster = connection.Select(strtblname, strTestCaseNo, strTestType);
var TopbarMenu = new clsMainPage_TopbarMenu();
var RosterAdministration = new clsRosterAdministration();
TopbarMenu.NavigatetoRosterAdministration();
String strTDRosterName = testdataRoster[4];
String strTDPane = testdataRoster[5];
String strTDTimeZoneorLocation = testdataRoster[6];
String strTDTimeZone = testdataRoster[7];
String strTDLocation = testdataRoster[8];
String strTDPeople = testdataRoster[9];
String strTDShiftDetails = testdataRoster[10];
String strTDStatus = testdataRoster[11];
Console.WriteLine("RosterName" + strTDRosterName);
RosterAdministration.AddRosterdetails(strTDRosterName, strTDPane, strTDTimeZoneorLocation, strTDTimeZone, strTDLocation, strTDPeople, strTDShiftDetails, strTDStatus);
System.Threading.Thread.Sleep(2000);
String[] rosterdetails = RosterAdministration.RetrieveRosterdetails(strTDRosterName);
String strfbwebrostername = rosterdetails[0];
String strfbwebpane = rosterdetails[1];
String strfbwebshifttypes = rosterdetails[2];
String strfbwebstatus = rosterdetails[3];
try
{
Assert.AreEqual(strTDRosterName, strfbwebrostername);
PropertiesCollection.test.Log(Status.Pass, strfbwebrostername + " Roster created Succesfully");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, strfbwebrostername + " Roster not created Succesfully");
}
try
{
Assert.AreEqual(strTDPane, strfbwebpane);
PropertiesCollection.test.Log(Status.Pass, strfbwebpane + " Pane validated Succesfully");
}
catch
{
PropertiesCollection.test.Log(Status.Pass, strfbwebpane + " Pane not validated Succesfully");
}
try
{
Assert.AreEqual(strTDShiftDetails, strfbwebshifttypes);
PropertiesCollection.test.Log(Status.Pass, strfbwebshifttypes + " Shift Type Validated Succesfully");
}
catch
{
PropertiesCollection.test.Log(Status.Pass, strfbwebshifttypes + " Shift Type not Validated Succesfully");
}
try
{
Assert.AreEqual(strTDStatus, strfbwebstatus);
PropertiesCollection.test.Log(Status.Pass, strfbwebstatus + " Status validated Succesfully");
}
catch
{
PropertiesCollection.test.Log(Status.Pass, strfbwebstatus + " Status not validated Succesfully");
}
}
public void TS03_TC02_RosterAdmin_AddRoster()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("TS03_TC02_RosterAdmin_AddRoster");
String strtblname = "automation_rosteradministration";
var connection = new Database.ConnectToMySQL_Fetch_TestData();
var testdataRoster = connection.Select(strtblname, strTestCaseNo, strTestType);
var TopbarMenu = new clsMainPage_TopbarMenu();
var RosterAdministration = new clsRosterAdministration();
TopbarMenu.NavigatetoRosterAdministration();
String strTDRosterName = testdataRoster[4];
String strTDPane = testdataRoster[5];
String strTDTimeZoneorLocation = testdataRoster[6];
String strTDTimeZone = testdataRoster[7];
String strTDLocation = testdataRoster[8];
String strTDPeople = testdataRoster[9];
String strTDShiftDetails = testdataRoster[10];
String strTDStatus = testdataRoster[11];
/********* Delete the Roster if its already present************/
String[] rosterdetails1 = RosterAdministration.RetrieveRosterdetails(strTDRosterName);
Console.WriteLine(rosterdetails1[0]);
if (rosterdetails1[0].IsNullOrEmpty() == false)
{
RosterAdministration.DeleteRosterdetails(rosterdetails1[0]);
}
/***************************************************************/
RosterAdministration.AddRosterdetails(strTDRosterName, strTDPane, strTDTimeZoneorLocation, strTDTimeZone, strTDLocation, strTDPeople, strTDShiftDetails, strTDStatus);
System.Threading.Thread.Sleep(6000);
String[] rosterdetails = RosterAdministration.RetrieveRosterdetails(strTDRosterName);
String strfbwebrostername = rosterdetails[0];
String strfbwebpane = rosterdetails[1];
String strfbwebshifttypes = rosterdetails[2];
String strfbwebstatus = rosterdetails[3];
try
{
Assert.AreEqual(strTDRosterName, strfbwebrostername);
PropertiesCollection.test.Log(Status.Pass, "Roster Name: " + strfbwebrostername + " created and validated on Roster Admin Screen");
}
catch (AssertFailedException e)
{
PropertiesCollection.test.Log(Status.Fail, "Roster Name is not matching");
throw;
}
try
{
Assert.AreEqual(strTDPane, strfbwebpane);
PropertiesCollection.test.Log(Status.Pass, "Pane: " + strfbwebpane + " created and validated on Roster Admin Screen");
}
catch (AssertFailedException e)
{
PropertiesCollection.test.Log(Status.Fail, "Pane is not matching");
throw;
}
try
{
Assert.AreEqual(strTDShiftDetails, strfbwebshifttypes);
PropertiesCollection.test.Log(Status.Pass, "Shift Types: " + strfbwebrostername + " created and validated on Roster Admin Screen");
}
catch (AssertFailedException e)
{
PropertiesCollection.test.Log(Status.Fail, "Shift Types is not matching");
throw;
}
try
{
Assert.AreEqual(strTDStatus, strfbwebstatus);
PropertiesCollection.test.Log(Status.Pass, "Roster : " + strfbwebrostername + " Status is validated ");
}
catch (AssertFailedException e)
{
PropertiesCollection.test.Log(Status.Fail, "Roster Status is not matching");
throw;
}
}
