public static string GetDeletedEmployee(string dbValue) //get name of deleted Employee
{
BaseMethods.ExecuteSqlQuery("workernumactual.sql");
string returnQuery = BaseMethods.GetDataFromDb("select worker_name from workernumactual where worker_name = '" + dbValue + "'");
return(returnQuery);
}
public static string GetEmployeeSum() //get name of Employee
{
BaseMethods.ExecuteSqlQuery("workernumactual.sql");
string returnQuery = BaseMethods.GetDataFromDb("select count(*) from workernumactual");
if (returnQuery == string.Empty)
{
Assert.Fail();
}
return(returnQuery);
}
public static string GetEmployeeId(string dbValue) //get name of Employee
{
BaseMethods.ExecuteSqlQuery("workernumactual.sql");
string returnQuery = BaseMethods.GetDataFromDb("select worker_id from workernumactual where worker_id = '" + dbValue + "'");
if (returnQuery == string.Empty)
{
Assert.Fail();
}
return(returnQuery);
}
public static string GetUserId(string dbValue) //get name of User Name
{
BaseMethods.ExecuteSqlQuery("username.sql");
string returnQuery = BaseMethods.GetDataFromDb("select obj_id from username where obj_id = '" + dbValue + "'");
if (returnQuery == string.Empty)
{
Assert.Fail();
}
return(returnQuery);
}