/// <summary>
/// Saves the down time.
/// </summary>
/// <param name="connectionDownTime">The connection down time.</param>
/// <returns></returns>
public override int SaveDownTime(ConnectionDownTime connectionDownTime)
{
int returnValue = ERRORVALUE;
try
{
returnValue = ExecuteScalar <int>("SaveDownTime", -1,
new object[]
{
connectionDownTime.Id,
connectionDownTime.DayOfWeek,
connectionDownTime.StartTime,
connectionDownTime.EndTime,
connectionDownTime.ConnectionId,
connectionDownTime.UpdatedBy,
connectionDownTime.CheckSum
});
}
catch (SqlException ex)
{
if (ex.Number == 2627 || ex.Number == 2627)
{
//if (ExceptionPolicy.HandleException(new ConstraintException(ex.Message, ex), "DataProvider Policy"))
// throw;
}
else
{
throw;
}
}
return(returnValue);
}
/// <summary>
/// Deletes the down time.
/// </summary>
/// <param name="connectionDownTime">The connection down time.</param>
/// <returns></returns>
public override bool DeleteDownTime(ConnectionDownTime connectionDownTime)
{
bool returnValue = false;
try
{
returnValue = ExecuteNonQuery("DeleteDownTime",
new object[]
{
connectionDownTime.Id
});
}
catch (SqlException ex)
{
if (ex.Number == 547)
{
//ExceptionPolicy.HandleException(new ForeignKeyConstraint(ex.Message, ex),
// "DataProvider Policy"))
throw ex;
}
else
{
throw;
}
}
catch (Exception ex)
{
// if (ExceptionPolicy.HandleException(ex, "DataProvider Policy")) throw;
}
return(returnValue);
}
public void SaveDownTime()
{
using (TransactionScope scope = new TransactionScope())
{
//add a task
ConnectionDownTime connectionDownTime = PopulateDownTime();
Assert.IsTrue(IntegrationController.SaveDownTime(connectionDownTime) != -1);
}
}
public void GetDownTime()
{
using (TransactionScope scope = new TransactionScope())
{
//add a connection
ConnectionDownTime connectionDownTime = PopulateDownTime();
int id = IntegrationController.SaveDownTime(connectionDownTime);
if (id > -1)
{
Assert.IsNotNull(IntegrationController.GetDownTime(id));
}
}
}
public void DeleteDownTime()
{
using (TransactionScope scope = new TransactionScope())
{
//add a downtime
ConnectionDownTime connectionDownTime = PopulateDownTime();
connectionDownTime.Id = IntegrationController.SaveDownTime(connectionDownTime);
if (connectionDownTime.Id > -1)
{
Assert.IsTrue(IntegrationController.DeleteDownTime(connectionDownTime));
}
}
}
/// <summary>
/// Deletes the down time.
/// </summary>
/// <param name="connectionDownTime">The connection down time.</param>
/// <returns></returns>
public static bool DeleteDownTime(ConnectionDownTime connectionDownTime)
{
Integration.IntegrationController controller = new Integration.IntegrationController();
bool success;
try
{
success = controller.DeleteDownTime(connectionDownTime);
}
catch (SocketException)
{
throw;
}
return(success);
}
/// <summary>
/// Saves the down time.
/// </summary>
/// <param name="connectionDownTime">The connection down time.</param>
/// <returns></returns>
public static int SaveDownTime(ConnectionDownTime connectionDownTime)
{
Integration.IntegrationController controller = new Integration.IntegrationController();
int returnValue;
try
{
returnValue = controller.SaveDownTime(connectionDownTime);
}
catch (SocketException)
{
throw;
}
return(returnValue);
}
private static ConnectionDownTime PopulateDownTime()
{
ConnectionDownTime connectionDownTime = new ConnectionDownTime();
//set up and save a destination connection
connectionDownTime.Connection = PopulateMSMQConnection();
connectionDownTime.ConnectionId = IntegrationController.SaveConnection(connectionDownTime.Connection);
connectionDownTime.Connection.Id = connectionDownTime.ConnectionId;
connectionDownTime.DayOfWeek = DayOfWeek.Monday;
connectionDownTime.EndTime = DateTime.Now;
connectionDownTime.StartTime = DateTime.Now;
connectionDownTime.UpdatedBy = "UnitTest";
return(connectionDownTime);
}
public void GetDownTimes()
{
using (TransactionScope scope = new TransactionScope())
{
//add a task
ConnectionDownTime connectionDownTime = PopulateDownTime();
int id = IntegrationController.SaveDownTime(connectionDownTime);
if (id > -1)
{
//retrieve all connection down times and the one we saved should return at least
List <ConnectionDownTime> connectionDownTimes =
IntegrationController.GetDownTimes(connectionDownTime.ConnectionId);
//so the count should be >0
Assert.IsTrue(connectionDownTimes.Count > 0);
//check for our new id also
Assert.IsTrue(connectionDownTimes.Find(delegate(ConnectionDownTime currentItem)
{
return(currentItem.Id == id);
}) != null);
}
}
}
/// <summary> /// Deletes the down time. /// </summary> /// <param name="time">The time.</param> /// <returns></returns> public abstract bool DeleteDownTime(ConnectionDownTime time);
/// <summary> /// Saves the down time. /// </summary> /// <param name="connectionDownTime">The connection down time.</param> /// <returns></returns> public abstract int SaveDownTime(ConnectionDownTime connectionDownTime);
