/// <summary>
/// HARD clear lock for given name and version in databas,
/// so that other test cases can use the same test data.
/// </summary>
/// <param name="request">ClearLockRequestDC contains the name and version of activity</param>
/// <returns>StatusReplyDC contains information about the database command execution</returns>
public static StatusReplyDC ClearLock(ClearLockRequestDC request)
{
Database db = null;
string cmd = null;
StatusReplyDC statusReply = new StatusReplyDC();
int retValue = 0;
try
{
db = DatabaseFactory.CreateDatabase();
cmd = string.Format(@"UPDATE dbo.Activity SET Locked=0, LockedBy=Null WHERE Name='{0}' AND Version = '{1}'", request.Name, request.Version);
retValue = db.ExecuteNonQuery(CommandType.Text, cmd);
if (retValue < 0)
{
statusReply.ErrorMessage = "Update lock fields were not succesful.";
}
}
catch (Exception ex)
{
statusReply.ErrorMessage = String.Format("DAL.ClearLock call. Error code: {0}. Error message: {1}", -99, ex.Message);
}
return statusReply;
}
/// <summary>
/// Clear the lock for activites with name and version
/// </summary>
/// <param name="request">The name&version of activity</param>
/// <returns>StatusReplyDC contains information about the database command execution</returns>
public StatusReplyDC ClearLock(ClearLockRequestDC request)
{
return DAL.DAL.ClearLock(request);
}
/// <summary>
/// Clear lock field from etblStoreActivities
/// </summary>
/// <param name="name">The name of activity</param>
/// <param name="version">The version of activity</param>
private void ClearLockForActivity(string name, string version)
{
ClearLockRequestDC request = new ClearLockRequestDC();
request.Name = name;
request.Version = version;
request.Incaller = IN_CALLER;
request.IncallerVersion = IN_CALLER_VERSION;
try
{
testProxy.ClearLock(request);
}
catch (FaultException e)
{
Assert.Fail("Failed to clear lock from etblStoreActivities: {0}", e.Message);
}
catch (Exception ex)
{
Assert.Fail("Failed to clear lock from etblStoreActivities: {0}", ex.Message);
}
}