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