public string SPNameTest(string action)
{
string result = RequestPostingExe.SPName(action);
return(result);
// TODO: add assertions to method RequestPostingExeTest.SPNameTest(String)
}
public void SPNameTest_Return_Request_CreateNewPosition_Store_Procedure()
{
//Arrange
string action = "New";
//Act
string expect = "dbo.tcdsb_LTO_PageRequest_CreateNew @Operate, @UserID, @SchoolYear, @SchoolCode, @PositionID, @PositionType";
string result = RequestPostingExe.SPName(action);
//Assert
Assert.AreEqual(expect, result, $" Create new Position Store Procedure Name: { result}");
}
public void SPNameTest_Return_RequestPositions_Store_Procedure()
{
//Arrange
string action = "Positions";
//Act
string expect = "dbo.tcdsb_LTO_PageRequest_Positions @Operate, @UserID, @SchoolYear, @SchoolCode";
string result = RequestPostingExe.SPName(action);
//Assert
Assert.AreEqual(expect, result, $" Request Positions List Store Procedure Name: { result}");
}
public void SPNameTest_Return_RequestPosition_Store_Procedure()
{
//Arrange
string action = "Position";
//Act
string expect = "dbo.tcdsb_LTO_PageRequest_Position @SchoolYear, @PositionID";
string result = RequestPostingExe.SPName(action);
//Assert
Assert.AreEqual(expect, result, $" Request Position Store Procedure Name: { result}");
}
public string Update(object parameter)
{
string sp = RequestPostingExe.SPName("Update");
return(CommonExcute <string> .GeneralValue(sp, parameter));
}
public List <T> Positions(object parameter)
{
string sp = RequestPostingExe.SPName("Positions");
return(CommonExcute <T> .GeneralList(sp, parameter));
}
