/// <summary>
/// Saves the object to the database.
/// </summary>
/// <param name="entity">The object.</param>
/// <param name="queryParameterList">The query parameter list.</param>
/// <param name="tableName">Name of the table.</param>
/// <returns>int</returns>
public static int SaveObjectWithIdentity(SafnetBaseEntity entity, List <QueryParameter> queryParameterList, string tableName)
{
string storedProcedure = tableName + "_Save";
Database iba = null;
DbCommand cmd = null;
CreateDatabaseCommand(storedProcedure, queryParameterList, out iba, out cmd);
return(int.Parse(iba.ExecuteScalar(cmd).ToString()));
}
public void t_Id()
{
SafnetBaseEntity target = CreateSafnetBaseEntity();
Guid expected = LookupConstants.LocationTypePoint;
Guid actual;
target.Id = expected;
actual = target.Id;
Assert.AreEqual(expected, actual);
}
public void t_SetNewId()
{
SafnetBaseEntity target = CreateSafnetBaseEntity();
Guid actual;
actual = target.SetNewId();
Assert.AreNotEqual(Guid.Empty, actual, "Guid not created for Id");
Assert.AreEqual(actual, target.Id, "Id not set");
Assert.IsTrue(target.NeedsDatabaseRefresh, "NeedsDatabaseRefresh not true");
}
/// <summary>
/// Deletes the object from the database.
/// </summary>
/// <param name="entity">The object.</param>
/// <param name="tableName">Name of the table.</param>
public static void DeleteObject(SafnetBaseEntity entity, string tableName)
{
string storedProcedure = tableName + "_Delete";
Database iba = null;
DbCommand cmd = null;
CreateDatabaseCommand(storedProcedure, new List <QueryParameter>()
{
new QueryParameter("Id", entity.Id)
}, out iba, out cmd);
iba.ExecuteNonQuery(cmd);
}
/// <summary>
/// Saves the object to the database. The table name is inferred from the object type.
/// </summary>
/// <param name="entity">The object.</param>
/// <param name="queryParameterList">The query parameter list.</param>
/// <returns>int</returns>
public static int SaveObject(SafnetBaseEntity entity, List <QueryParameter> queryParameterList)
{
return(SaveObject(entity, queryParameterList, entity.GetType().Name));
}
/// <summary>
/// Deletes the object from the database. Table name is inferred from the object's type
/// </summary>
/// <param name="entity">The object.</param>
public static void DeleteObject(SafnetBaseEntity entity)
{
DeleteObject(entity, entity.GetType().Name);
}