/// <summary>
/// Makes a deep copy of the current DbContentStatus.
/// </summary>
/// <returns> A new DbContentStatus object reflecting the cloned DbContentStatus object.</returns>
/// <param name="isolation">Placeholders are used to isolate the DbContentStatus from its children.</param>
public DbContentStatus Copy(bool isolation)
{
DbContentStatus dbContentStatus = new DbContentStatus();
CopyTo(dbContentStatus, isolation);
return(dbContentStatus);
}
/// <summary>
/// Inserts a DbContentStatus into the database. All children should have been
/// saved to the database before insertion. New children will not be
/// related to this object in the database.
/// </summary>
/// <param name="_DbContentStatus">The DbContentStatus to insert into the database.</param>
internal static int _insert(DbContentStatus dbContentStatus)
{
int id;
string query;
Database database;
DbCommand dbCommand;
database = DatabaseFactory.CreateDatabase();
query = "INSERT INTO kitCms_Statuses" +
"(," +
"Name," +
"IsDraft," +
"IsPublished," +
"FeeEnabled," +
"EditEnabled," +
"ArchiveEnabled," +
"ReviewEnabled," +
"Icon) VALUES (," +
"@Name," +
"@IsDraft," +
"@IsPublished," +
"@FeeEnabled," +
"@EditEnabled," +
"@ArchiveEnabled," +
"@ReviewEnabled," +
"@Icon);";
dbCommand = database.GetSqlStringCommand(query);
fillParameters(database, dbCommand, dbContentStatus);
database.ExecuteNonQuery(dbCommand);
dbCommand = database.GetSqlStringCommand("SELECT @@IDENTITY AS IDVal");
id = (int)database.ExecuteScalar(dbCommand);
return(id);
}
internal static int _update(DbContentStatus dbContentStatus)
{
Database database;
DbCommand dbCommand;
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand("UPDATE kitCms_Statuses SET Name=@Name," +
"IsDraft=@IsDraft," +
"IsPublished=@IsPublished," +
"FeeEnabled=@FeeEnabled," +
"EditEnabled=@EditEnabled," +
"ArchiveEnabled=@ArchiveEnabled," +
"ReviewEnabled=@ReviewEnabled," +
"Icon=@Icon WHERE DbContentStatusID=@DbContentStatusID;");
fillParameters(database, dbCommand, dbContentStatus);
database.AddInParameter(dbCommand, "DbContentStatusID", DbType.Int32, dbContentStatus.iD);
// Abandon remaining updates if no rows have been updated by returning false immediately.
if (database.ExecuteNonQuery(dbCommand) == 0)
{
return(-1);
}
return(dbContentStatus.iD);
}
/// <summary>
/// Makes a deep copy of the current DbContentStatus.
/// </summary>
/// <returns> A new DbContentStatus object reflecting the cloned DbContentStatus object.</returns>
public DbContentStatus Copy()
{
DbContentStatus dbContentStatus = new DbContentStatus();
CopyTo(dbContentStatus);
return(dbContentStatus);
}
internal static bool _fill(DbContentStatus dbContentStatus)
{
StringBuilder query;
Database database;
DbCommand dbCommand;
query = new StringBuilder("SELECT ");
query.Append(string.Join(",", InnerJoinFields));
query.Append(" FROM kitCms_Statuses WHERE DbContentStatusID=");
query.Append(dbContentStatus.iD);
query.Append(";");
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand(query.ToString());
IDataReader r = database.ExecuteReader(dbCommand);
if (!r.Read())
{
throw(new Exception(string.Format("Cannot find DbContentStatusID '{0}'.",
dbContentStatus.iD)));
}
FillFromReader(dbContentStatus, r, 0, 1);
return(true);
}
public static DbContentStatus ParseFromReader(IDataReader r, int idOffset, int dataOffset)
{
DbContentStatus dbContentStatus = new DbContentStatus();
FillFromReader(dbContentStatus, r, idOffset, dataOffset);
return(dbContentStatus);
}
public bool Equals(DbContentStatus dbContentStatus)
{
if (dbContentStatus == null)
{
return(false);
}
return(this.iD == dbContentStatus.iD);
}
/// <summary>
/// Duplicates DbContentStatus object into a database; may or may not be the same database
/// as the parent object.
/// </summary>
/// <returns> A new DbContentStatus object reflecting the replicated DbContentStatus object.</returns>
public DbContentStatus Duplicate()
{
DbContentStatus clonedDbContentStatus = this.Clone();
// Insert must be called after children are replicated!
clonedDbContentStatus.iD = DbContentStatusManager._insert(clonedDbContentStatus);
clonedDbContentStatus.isSynced = true;
return(clonedDbContentStatus);
}
public static DbContentStatus NewPlaceHolder(int iD)
{
DbContentStatus dbContentStatus = new DbContentStatus();
dbContentStatus.iD = iD;
dbContentStatus.isPlaceHolder = true;
dbContentStatus.isSynced = true;
return(dbContentStatus);
}
public void Remove(DbContentStatus value)
{
OnCollectionChanged(EventArgs.Empty);
int index = IndexOf(value);
if (index == -1)
{
throw(new Exception("DbContentStatus not found in collection."));
}
RemoveAt(index);
}
/// <summary>
/// Inserts a DbContentStatus into the database. All children should have been
/// saved to the database before insertion. New children will not be
/// related to this object in the database.
/// </summary>
/// <param name="_DbContentStatus">The DbContentStatus to insert into the database.</param>
internal static int _insert(DbContentStatus dbContentStatus)
{
int id;
string query;
Database database;
DbCommand dbCommand;
database = DatabaseFactory.CreateDatabase();
query = "INSERT INTO kitCms_Statuses " +
"(" +
"Name," +
"IsDraft," +
"IsPublished," +
"FeeEnabled," +
"EditEnabled," +
"ArchiveEnabled," +
"ReviewEnabled," +
"Icon) VALUES (" +
"@Name," +
"@IsDraft," +
"@IsPublished," +
"@FeeEnabled," +
"@EditEnabled," +
"@ArchiveEnabled," +
"@ReviewEnabled," +
"@Icon);";
if (database.ConnectionStringWithoutCredentials.StartsWith("provider=microsoft.jet.oledb.4.0"))
{
// Microsoft Access
// Connection must remain open for IDENTITY to return correct value,
// therefore use the dbCommand object's Connection directly to control
// connection state.
dbCommand = database.GetSqlStringCommand(query);
fillParameters(database, dbCommand, dbContentStatus);
dbCommand.Connection = database.CreateConnection();
dbCommand.Connection.Open();
dbCommand.ExecuteNonQuery();
dbCommand.CommandText = "SELECT @@IDENTITY AS LastID";
id = (int)dbCommand.ExecuteScalar();
dbCommand.Connection.Close();
}
else
{
//// Microsoft SQL Server
dbCommand = database.GetSqlStringCommand(query + " SELECT @LastID = SCOPE_IDENTITY();");
fillParameters(database, dbCommand, dbContentStatus);
database.AddOutParameter(dbCommand, "@LastID", DbType.Int32, 10);
database.ExecuteNonQuery(dbCommand);
id = (int)dbCommand.Parameters["@LastID"].Value;
}
return(id);
}
public int IndexOf(DbContentStatus value)
{
lock (this)
{
for (int x = 0; x < count; x++)
{
if (DbContentStatusArray[x].Equals(value))
{
return(x);
}
}
return(-1);
}
}
/// <summary>
/// Deep copies the current DbContentStatus to another instance of DbContentStatus.
/// </summary>
/// <param name="DbContentStatus">The DbContentStatus to copy to.</param>
/// <param name="isolation">Placeholders are used to isolate the DbContentStatus from its children.</param>
public void CopyTo(DbContentStatus dbContentStatus, bool isolation)
{
dbContentStatus.iD = iD;
dbContentStatus.isPlaceHolder = isPlaceHolder;
dbContentStatus.isSynced = isSynced;
dbContentStatus.name = name;
dbContentStatus.isDraft = isDraft;
dbContentStatus.isPublished = isPublished;
dbContentStatus.feeEnabled = feeEnabled;
dbContentStatus.editEnabled = editEnabled;
dbContentStatus.archiveEnabled = archiveEnabled;
dbContentStatus.reviewEnabled = reviewEnabled;
dbContentStatus.icon = icon;
}
/// <summary>
/// Fills the {0} from a OleIDataReader.
/// </summary>
public static void FillFromReader(DbContentStatus dbContentStatus, IDataReader r, int idOffset, int dataOffset)
{
dbContentStatus.iD = r.GetInt32(idOffset);
dbContentStatus.isSynced = true;
dbContentStatus.isPlaceHolder = false;
dbContentStatus.name = r.GetString(0 + dataOffset);
dbContentStatus.isDraft = r.GetBoolean(1 + dataOffset);
dbContentStatus.isPublished = r.GetBoolean(2 + dataOffset);
dbContentStatus.feeEnabled = r.GetBoolean(3 + dataOffset);
dbContentStatus.editEnabled = r.GetBoolean(4 + dataOffset);
dbContentStatus.archiveEnabled = r.GetBoolean(5 + dataOffset);
dbContentStatus.reviewEnabled = r.GetBoolean(6 + dataOffset);
dbContentStatus.icon = r.GetString(7 + dataOffset);
}
private static void fillParameters(Database database, DbCommand dbCommand, DbContentStatus dbContentStatus)
{
#region System
addParameter(database, dbCommand, "Name", DbType.String, dbContentStatus.name);
addParameter(database, dbCommand, "IsDraft", DbType.Boolean, dbContentStatus.isDraft);
addParameter(database, dbCommand, "IsPublished", DbType.Boolean, dbContentStatus.isPublished);
addParameter(database, dbCommand, "FeeEnabled", DbType.Boolean, dbContentStatus.feeEnabled);
addParameter(database, dbCommand, "EditEnabled", DbType.Boolean, dbContentStatus.editEnabled);
addParameter(database, dbCommand, "ArchiveEnabled", DbType.Boolean, dbContentStatus.archiveEnabled);
addParameter(database, dbCommand, "ReviewEnabled", DbType.Boolean, dbContentStatus.reviewEnabled);
addParameter(database, dbCommand, "Icon", DbType.String, dbContentStatus.icon);
#endregion
}
public int Add(DbContentStatus value)
{
OnCollectionChanged(EventArgs.Empty);
lock (this)
{
count++;
// Resize the array if the count is greater than the length
// of the array.
if (count > DbContentStatusArray.GetUpperBound(0) + 1)
{
DbContentStatus[] tempDbContentStatusArray = new DbContentStatus[count * 2];
Array.Copy(DbContentStatusArray, tempDbContentStatusArray, count - 1);
DbContentStatusArray = tempDbContentStatusArray;
}
DbContentStatusArray[count - 1] = value;
}
return(count - 1);
}
/// <summary>
/// Clones DbContentStatus object and clones child objects with cloning or replication.
/// as the parent object.
/// </summary>
/// <returns> A new DbContentStatus object reflecting the replicated DbContentStatus object.</returns>
public DbContentStatus Clone()
{
DbContentStatus clonedDbContentStatus = new DbContentStatus();
clonedDbContentStatus.iD = iD;
clonedDbContentStatus.isSynced = isSynced;
clonedDbContentStatus.name = name;
clonedDbContentStatus.isDraft = isDraft;
clonedDbContentStatus.isPublished = isPublished;
clonedDbContentStatus.feeEnabled = feeEnabled;
clonedDbContentStatus.editEnabled = editEnabled;
clonedDbContentStatus.archiveEnabled = archiveEnabled;
clonedDbContentStatus.reviewEnabled = reviewEnabled;
clonedDbContentStatus.icon = icon;
return(clonedDbContentStatus);
}
public void Insert(int index, DbContentStatus value)
{
OnCollectionChanged(EventArgs.Empty);
lock (this)
{
count++;
// Resize the array if the count is greater than the length
// of the array.
if (count > DbContentStatusArray.GetUpperBound(0) + 1)
{
DbContentStatus[] tempDbContentStatusArray = new DbContentStatus[count * 2];
Array.Copy(DbContentStatusArray, tempDbContentStatusArray, count - 1);
DbContentStatusArray = tempDbContentStatusArray;
}
for (int x = index + 1; x == count - 2; x++)
{
DbContentStatusArray[x] = DbContentStatusArray[x - 1];
}
DbContentStatusArray[index] = value;
}
}
public DbContentStatusCollection GetCollection(int topCount, string whereClause, string sortClause)
{
StringBuilder query;
Database database;
DbCommand dbCommand;
IDataReader r;
DbContentStatusCollection dbContentStatusCollection;
query = new StringBuilder("SELECT ");
if (topCount > 0)
{
query.Append("TOP ");
query.Append(topCount);
query.Append(" ");
}
foreach (string columnName in InnerJoinFields)
{
query.Append("DbContentStatus.");
query.Append(columnName);
query.Append(",");
}
//
// Remove trailing comma
//
query.Length--;
query.Append(" FROM kitCms_Statuses AS DbContentStatus");
//
// Render where clause
//
if (whereClause != string.Empty)
{
query.Append(" WHERE ");
query.Append(whereClause);
}
//
// Render sort clause
//
if (sortClause != string.Empty)
{
query.Append(" ORDER BY ");
query.Append(sortClause);
}
//
// Render final semicolon
//
query.Append(";");
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand(query.ToString());
#if DEBUG
try
{
r = database.ExecuteReader(dbCommand);
}
catch (Exception e)
{
string msg = e.Message;
throw(new Exception(msg + " --- Query: " + query.ToString()));
}
#else
r = database.ExecuteReader(dbCommand);
#endif
dbContentStatusCollection = new DbContentStatusCollection();
while (r.Read())
{
DbContentStatus dbContentStatus = ParseFromReader(r, 0, 1);
dbContentStatusCollection.Add(dbContentStatus);
}
return(dbContentStatusCollection);
}
/// <summary>
/// Deep copies the current DbContentStatus to another instance of DbContentStatus.
/// This method does not provide isolated copies; use overriden method for this feature.
/// </summary>
/// <param name="DbContentStatus">The DbContentStatus to copy to.</param>
public void CopyTo(DbContentStatus dbContentStatus)
{
CopyTo(dbContentStatus, false);
}
public bool Contains(DbContentStatus value)
{
return(IndexOf(value) != -1);
}
/// <summary>
/// Compares the object's ID to another object's ID.
/// </summary>
public int CompareTo(DbContentStatus dbContentStatus)
{
return(this.iD - dbContentStatus.iD);
}
/// <summary>
/// Compares the object's ID to another object's ID.
/// </summary>
int IComparable.CompareTo(object obj)
{
DbContentStatus dbContentStatus = (DbContentStatus)obj;
return(this.iD - dbContentStatus.iD);
}
