/// <summary>Extracts the Content block instance from the current record of the specified data reader.</summary>
public override IEntity Parse(IDataReader reader)
{
var result = new Domain.ContentBlock();
FillData(reader, result);
EntityManager.SetSaved(result, reader.GetGuid(0));
return(result);
}
/// <summary>Updates the specified existing Content block instance in the database.</summary>
void Update(Domain.ContentBlock item)
{
if (ExecuteScalar(UPDATE_COMMAND, CommandType.Text, CreateParameters(item)).ToStringOrEmpty().IsEmpty())
{
Cache.Current.Remove(item);
throw new ConcurrencyException($"Failed to update the 'ContentBlocks' table. There is no row with the ID of {item.ID}.");
}
}
/// <summary>Loads the data from the specified data reader on the specified Content block instance.</summary>
internal static void FillData(IDataReader reader, Domain.ContentBlock entity)
{
var values = new object[reader.FieldCount];
reader.GetValues(values);
entity.Key = values[1] as string;
entity.Content = values[2] as string;
}
/// <summary>Creates parameters for Inserting or Updating Content block records</summary>
IDataParameter[] CreateParameters(Domain.ContentBlock item)
{
var result = new List <IDataParameter>();
result.Add(CreateParameter("OriginalId", item.OriginalId));
result.Add(CreateParameter("Id", item.GetId()));
result.Add(CreateParameter("Key", item.Key));
result.Add(CreateParameter("Content", item.Content));
return(result.ToArray());
}
/// <summary>Inserts the specified new Content block instance into the database.</summary>
void Insert(Domain.ContentBlock item)
{
ExecuteScalar(INSERT_COMMAND, CommandType.Text,
CreateParameters(item));
}
