public void TestAddTimeAndMaterial()
{
HomePage homePage = new HomePage();
// Locate Administration Menu and Click
// Locate Time & Materials Menu item and Click
TimeAndMaterialsPage timeAndMaterialsPage = null;
TimeAndMaterial timeAndMaterialObject = null;
try
{
timeAndMaterialsPage = homePage.GoToTimeAndMaterialsPage(Driver);
// Verify that you are on Time & Materials Page by checking the URL
ValidateURL(Driver, timeAndMaterialUrl);
// Create new Time and Material item
// Locate TypeCode dropdown field and Select Time
// Locate Code textfield and enter test123
// Locate Description textfield and enter current timestamp as the description for uniqueness
// Locate Price per unit field and enter 10.00;
// Locate and click Save Button
timeAndMaterialObject = CreateNewTimeAndMaterial(
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 6), "Code"),
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 6), "Price"));
timeAndMaterialsPage.CreateNewTimeAndMaterial(Driver, timeAndMaterialObject);
// Verify that the item was added
}
catch (WebDriverException e)
{
Console.WriteLine(e.StackTrace);
Assert.Fail("Unexpected exception occurred - TestAddTimeAndMaterial failed", e);
}
Assert.That(PerformVerification(Driver, timeAndMaterialsPage, timeAndMaterialObject), Is.Not.Null, "Time and Material was not added - TestAddTimeAndMaterial failed");
}
public void TestDeleteTimeAndMaterial()
{
HomePage homePage = new HomePage();
// Locate Administration Menu and Click
// Locate Time & Materials Menu item and Click
TimeAndMaterialsPage timeAndMaterialsPage = null;
TimeAndMaterial timeAndMaterialObject = null;
try
{
timeAndMaterialsPage = homePage.GoToTimeAndMaterialsPage(Driver);
// Verify that you are on Time & Materials Page by checking the URL
ValidateURL(Driver, timeAndMaterialUrl);
timeAndMaterialObject = CreateNewTimeAndMaterial(
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 6), "Code"),
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 6), "Price"));
timeAndMaterialsPage.CreateNewTimeAndMaterial(Driver, timeAndMaterialObject);
// Verify that the item was added
PerformVerification(Driver, timeAndMaterialsPage, timeAndMaterialObject);
Assert.That(PerformVerification(Driver, timeAndMaterialsPage, timeAndMaterialObject), Is.Not.Null, "Time and Material was not created - TestDeleteTimeAndMaterial failed");
// Now perform delete by clicking Delete button
timeAndMaterialsPage.DeleteTimeAndMaterial(Driver, timeAndMaterialObject);
}
catch (WebDriverException e)
{
Console.WriteLine(e.StackTrace);
Assert.Fail("Unexpected exception occurred - TestDeleteTimeAndMaterial failed" + e.Message);
}
// verify that deletion was successful
Assert.That(PerformVerification(Driver, timeAndMaterialsPage, timeAndMaterialObject), Is.Null, "Time and Material was not deleted - TestDeleteTimeAndMaterial failed");
}
public bool AddTimeAndMaterial(TimeAndMaterial timeAndMaterial)
{
int result = JGConstant.RETURN_ZERO;
try
{
SqlDatabase database = MSSQLDataBase.Instance.GetDefaultDatabase();
{
DbCommand command = database.GetStoredProcCommand("UDP_AddTimeAndMaterial");
command.CommandType = CommandType.StoredProcedure;
database.AddInParameter(command, "@Id", DbType.Int32, timeAndMaterial.Id);
database.AddInParameter(command, "@CustomerId", DbType.Int32, timeAndMaterial.CustomerId);
database.AddInParameter(command, "@WorkArea", DbType.String, timeAndMaterial.WorkArea);
database.AddInParameter(command, "@LocationImg", DbType.String, timeAndMaterial.LocationImage);
database.AddInParameter(command, "@ProductType", DbType.Int32, timeAndMaterial.ProductType);
database.AddInParameter(command, "@MainImage", DbType.String, timeAndMaterial.MainImage);
database.AddInParameter(command, "@TimeAndMaterialTerm", DbType.Int32, timeAndMaterial.TimeAndMaterialTerm);
database.AddInParameter(command, "@SpecialInstruction", DbType.String, timeAndMaterial.SpecialInstruction);
result = database.ExecuteNonQuery(command);
}
}
catch (Exception ex)
{
throw ex;
}
return(result > JGConstant.RETURN_ZERO ? JGConstant.RETURN_TRUE : JGConstant.RETURN_FALSE);
}
public TimeAndMaterial CreateNewTimeAndMaterial(string code, string price)
{
String timeStamp = CalculateCurrentTimeStamp();
Console.WriteLine("Timestamp is " + timeStamp);
TimeAndMaterial timeAndMaterialObject = new TimeAndMaterial(code, timeStamp, price);
return(timeAndMaterialObject);
}
public void UpdateTimeAndMaterial(IWebDriver driver, TimeAndMaterial currentTimeAndMaterial, TimeAndMaterial newTimeAndMaterial)
{
UpdateTimeAndMaterial(driver,
currentTimeAndMaterial.Code,
currentTimeAndMaterial.Description,
currentTimeAndMaterial.Price,
newTimeAndMaterial.Code,
newTimeAndMaterial.Description,
newTimeAndMaterial.Price);
}
public TimeAndMaterial GetTimeAndMaterial(TimeAndMaterial timeAndMaterial)
{
DataSet returndata = null;
List <CustomerLocationPic> customerLocationPics = new List <CustomerLocationPic>();
try
{
SqlDatabase database = MSSQLDataBase.Instance.GetDefaultDatabase();
{
returndata = new DataSet();
DbCommand command = database.GetStoredProcCommand("UDP_GetTimeAndMaterial");
command.CommandType = CommandType.StoredProcedure;
database.AddInParameter(command, "@CustomerId", SqlDbType.Int, timeAndMaterial.CustomerId);
database.AddInParameter(command, "@ProductId", SqlDbType.Int, timeAndMaterial.Id);
database.AddInParameter(command, "@ProductTypeId", SqlDbType.Int, timeAndMaterial.ProductType);
returndata = database.ExecuteDataSet(command);
var varTimeAndMaterial = from row in returndata.Tables[0].AsEnumerable()
select new TimeAndMaterial
{
Customer = row["Customer"].ToString(),
TimeAndMaterialTerm = row["TimeAndMaterialTerm"].ToString(),
SpecialInstruction = row["SpecialInstruction"].ToString(),
WorkArea = row["WorkArea"].ToString(),
CustomerLocationPics = returndata.Tables[1].AsEnumerable().
Select(aa => new CustomerLocationPic
{
LocationPicture = aa["LocationPicture"].ToString(),
RowSerialNo = Convert.ToInt32(aa["RowSerialNo"].ToString())
}).ToList()
};
return(varTimeAndMaterial.FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public TimeAndMaterial GetTimeAndMaterial(TimeAndMaterial timeAndMaterial)
{
return(TimeAndMaterialDAL.Instance.GetTimeAndMaterial(timeAndMaterial));
}
public bool AddTimeAndMaterial(TimeAndMaterial timeAndMaterial)
{
return(TimeAndMaterialDAL.Instance.AddTimeAndMaterial(timeAndMaterial));
}
public void DeleteTimeAndMaterial(IWebDriver driver, TimeAndMaterial timeAndMaterial)
{
DeleteTimeAndMaterial(driver, timeAndMaterial.Code, timeAndMaterial.Description, timeAndMaterial.Price);
}
public void CreateNewTimeAndMaterial(IWebDriver driver, TimeAndMaterial timeAndMaterial)
{
CreateNewTimeAndMaterial(driver, timeAndMaterial.Code, timeAndMaterial.Description, timeAndMaterial.Price);
}
public IWebElement Search(IWebDriver driver, TimeAndMaterial timeAndMaterial)
{
return(Search(driver, timeAndMaterial.Code, timeAndMaterial.Description, timeAndMaterial.Price));
}
private IWebElement PerformVerification(IWebDriver driver, TimeAndMaterialsPage page, TimeAndMaterial timeAndMaterial)
{
return(PerformVerification(driver, page, timeAndMaterial.Code, timeAndMaterial.Description, timeAndMaterial.Price));
}
