public string SPNameTest(string action)
{
string result = PublishPositionExe.SpName(action);
return(result);
// TODO: add assertions to method PublishPositionExeTest.SPNameTest(String)
}
public void SPNameTest_retrun_CreateNewPublish_StoreProcedure_name()
{
//Arrange
string action = "New";
//Act
string expect = "dbo.tcdsb_LTO_PagePublish_CreateNew @Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID,@PositionType";
string result = PublishPositionExe.SpName(action);
//Assert
Assert.AreEqual(expect, result, $" Create new Publish Position Store Procedure Name: { result}");
}
public void SPNameTest_retrun_Positions_StoreProcedure_name()
{
//Arrange
string action = "Positions";
//Act
string expect = "dbo.tcdsb_LTO_PagePublish_Positions @Operate,@UserID,@SchoolYear,@PositionType,@Panel,@Status,@SearchBy,@SearchValue1,@SearchValue2";
string result = PublishPositionExe.SpName(action);
//Assert
Assert.AreEqual(expect, result, $" Publish Positions list Store Procedure Name: { result}");
}
public void SPNameTest_retrun_Position_StoreProcedure_name()
{
//Arrange
string action = "Position";
//Act
string expect = "dbo.tcdsb_LTO_PagePublish_Position @SchoolYear, @PositionID";
string result = PublishPositionExe.SpName(action);
//Assert
Assert.AreEqual(expect, result, $" Publish Position Store Procedure Name: { result}");
}
public string Update(object parameter)
{
string sp = PublishPositionExe.SpName("Update");
return(CommonExcute <string> .GeneralValue(sp, parameter));
}
public List <T> Positions(object parameter)
{
string sp = PublishPositionExe.SpName("Positions");
return(CommonExcute <T> .GeneralList(sp, parameter));
}