public string QualificationOperation(QualificationUpdate position, string positionID)
{
try
{
string sp = GetSP(position.Operate);
var result = GeneralDataAccess.TextValue(sp, position);
return(result);
}
catch (Exception ex)
{
var exm = ex.Message;
return("Failed");
}
}
public string QualificationUpdate(QualificationUpdate qual)
{
try
{
string paramaters = "@Operate,@UserID,@SchoolYear,@SchoolCode,@PositionID,@SourceID, @QualificationID, @Selected";
string sp = "dbo.tcdsb_LTO_Qualification_Update " + paramaters;
var result = GeneralDataAccess.TextValue(sp, qual);
return(result);
}
catch (Exception ex)
{
var exm = ex.Message;
return("Failed");
}
}
public void UpdateQualificationTest()
{
//Arrange
int newid = getNewRequestID("LTO");
var position = new QualificationUpdate()
{
Operate = "Update",
UserID = "mif",
SchoolYear = schoolyear,
SchoolCode = "0320",
PositionID = newid,
SourceID = "Request",
QualificationID = "230",
Selected = "True"
};
string expect = "Successfully";
//Act
var result = RequestingPostExe.UpdateQualification(position, "0");
//Assert
Assert.AreEqual(expect, result, $" Create New Request position { result} ");
}
public static string UpdateQual(QualificationUpdate qual)
{
var myval = new PostingQualification();
return(myval.QualificationUpdate(qual));
}
public static string UpdateQualification(QualificationUpdate qual, string positonID)
{
var myval = new RequestingPost();
return(myval.QualificationOperation(qual, positonID));
}
