internal List <StaticContent> InternalLoadByParentInstanceId(int parentId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByParentInstanceIdCommandText;
readerAction.AddParameter("@ParentInstanceId", parentId, DbType.Int32);
this.ExecuteCommand(readerAction);
List <StaticContent> rootContList = new List <StaticContent>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetRootContFieldOrdinals(dataReader);
while (dataReader.Read())
{
StaticContent p = new StaticContent();
TranslateToRootCont(dataReader, p, ordinals[0], ordinals[1], ordinals[2], ordinals[3]);
rootContList.Add(p);
}
}
finally
{
dataReader.Close();
}
return(rootContList);
}
private StaticContent TranslateToRootCont(IDataReader dataReader)
{
StaticContent rootCont = new StaticContent();
TranslateToRootCont(dataReader, rootCont);
return(rootCont);
}
void Delete(StaticContent rootCont)
{
using (StaticContentFactory factory = StaticContentFactory.GetInstance())
{
factory.InternalDelete(rootCont);
}
}
internal List <StaticContent> InternalLoadAll()
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadAllCommandText;
this.ExecuteCommand(readerAction);
List <StaticContent> rootContList = new List <StaticContent>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetRootContFieldOrdinals(dataReader);
while (dataReader.Read())
{
StaticContent p = new StaticContent();
TranslateToRootCont(dataReader, p, ordinals[0], ordinals[1], ordinals[2], ordinals[3]);
rootContList.Add(p);
}
}
finally
{
dataReader.Close();
}
return(rootContList);
}
void Insert(StaticContent rootCont)
{
using (StaticContentFactory factory = StaticContentFactory.GetInstance())
{
factory.InternalInsert(rootCont);
}
}
protected void Delete(StaticContent rootCont)
{
RawSqlExecuteNonQueryAction deleteAction = new RawSqlExecuteNonQueryAction();
deleteAction.CommandText = _deleteCommandText;
deleteAction.AddParameter("@InstanceId", rootCont.InstanceId, DbType.Int32);
this.ExecuteCommand(deleteAction);
base.Delete(rootCont);
}
protected void Insert(StaticContent rootCont)
{
base.Insert(rootCont);
RawSqlInsertAction insertAction = new RawSqlInsertAction();
insertAction.CommandText = _insertCommandText;
insertAction.AddParameter("@InstanceId", rootCont.InstanceId, DbType.Int32);
insertAction.AddParameter("@ParentInstanceId", rootCont.ParentContent.InstanceId, DbType.Int32);
insertAction.AddParameter("@ContentFriendlyName", rootCont.ContentFriendlyName, DbType.String);
insertAction.AddParameter("@ContentDescription", rootCont.ContentDescription, DbType.String);
insertAction.AddParameter("@ContentImageSrc", rootCont.ContentImageSrc, DbType.String);
this.ExecuteCommand(insertAction);
}
protected void TranslateToRootCont(IDataReader dataReader, StaticContent rootCont, int idParIndex, int contFriendlyName, int contDescr, int contImgSrc)
{
base.TranslateToInstance(dataReader, rootCont);
//if (!dataReader.IsDBNull(idParIndex)) rootCont.ParentContent = this.InternalLoadByPrimaryKey(dataReader.GetInt32(idParIndex));
//TODO: parentId ?
//throw new NotImplementedException("Don't know what to do with parentId?");
rootCont.ContentFriendlyName = dataReader.GetString(contFriendlyName);
if (!dataReader.IsDBNull(contDescr))
{
rootCont.ContentDescription = dataReader.GetString(contDescr);
}
if (!dataReader.IsDBNull(contImgSrc))
{
rootCont.ContentImageSrc = dataReader.GetString(contImgSrc);
}
}
protected void Update(StaticContent rootCont)
{
base.Update(rootCont);
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@InstanceId", rootCont.InstanceId, DbType.Int32);
updateAction.AddParameter("@ParentInstanceId", rootCont.ParentContent.InstanceId, DbType.Int32);
updateAction.AddParameter("@ContentFriendlyName", rootCont.ContentFriendlyName, DbType.String);
updateAction.AddParameter("@ContentDescription", rootCont.ContentDescription, DbType.String);
updateAction.AddParameter("@ContentImageSrc", rootCont.ContentImageSrc, DbType.String);
this.ExecuteCommand(updateAction);
}
internal StaticContent InternalLoadByPrimaryKey(int instanceId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByIdCommandText;
readerAction.AddParameter("@InstanceId", instanceId, DbType.Int32);
StaticContent rootCont = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
rootCont = TranslateToRootCont(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(rootCont);
}
internal StaticContent InternalLoadByFriendlyName(string instanceName)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByInstanceNameCommandText;
readerAction.AddParameter("@ContentFriendlyName", instanceName, DbType.String);
StaticContent rootCont = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
rootCont = TranslateToRootCont(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(rootCont);
}
internal void InternalInsert(StaticContent rootCont)
{
Insert(rootCont);
}
protected void TranslateToRootCont(IDataReader dataReader, StaticContent rootCont)
{
int[] indexes = GetInstanceFieldOrdinals(dataReader);
TranslateToRootCont(dataReader, rootCont, indexes[0], indexes[1], indexes[2], indexes[3]);
}
internal void InternalDelete(StaticContent rootCont)
{
this.Delete(rootCont);
}
internal void InternalUpdate(StaticContent rootCont)
{
this.Update(rootCont);
}