public override void GenerateDataColumnProperties()
{
DataModelColumnProperties.Clear();
DataModelColumnProperties.Add(ColumnPropertiesUserID);
DataModelColumnProperties.Add(ColumnPropertiesFirstName);
DataModelColumnProperties.Add(ColumnPropertiesLastName);
}
public string GetColumnNamesAsCommandText(string overrideTableName = "")
{
if (!string.IsNullOrEmpty(overrideTableName))
{
overrideTableName = TableName;
}
var sbCommandText = new StringBuilder();
string comma = "";
for (int i = 0; i < DataModelColumnProperties.Count(); i++)
{
sbCommandText.Append($"{comma}{overrideTableName}.{DataModelColumnProperties[i].ColumnName}");
comma = " ,";
}
for (int i = 0; i < DataModelForeignKeyProperties.Count(); i++)
{
sbCommandText.Append(" ,");
sbCommandText.Append(
DataModelForeignKeyProperties[i].ForeignDataModelFactory
.GetColumnNamesAsCommandText(DataModelForeignKeyProperties[i].GetJoinName()));
}
return(sbCommandText.ToString());
}
public DataUsers(DataModelColumnProperties <int> columnUserIDProperties,
DataModelColumnProperties <string> columnFirstNameProperties,
DataModelColumnProperties <string> columnLastNameProperties,
DataModeForeignKey fkCountryProperties)
{
Init(columnUserIDProperties, columnFirstNameProperties, columnLastNameProperties, fkCountryProperties);
}
public DataCountries(DataModelColumnProperties <int> countryIDProperties, int countryID,
DataModelColumnProperties <string> countryNameProperties, string countryName)
{
ColumnCountryID = new DataModelColumn <int>(countryIDProperties, countryID);
DataModelColumns.Add(ColumnCountryID);
ColumnCountryName = new DataModelColumn <string>(countryNameProperties, countryName);
DataModelColumns.Add(ColumnCountryName);
}
public DataModel.IDataModelColumnProperties Get_PrimaryKeyProperties()
{
if (_primaryKeyProperties == null)
{
_primaryKeyProperties = DataModelColumnProperties.FirstOrDefault(dmc => dmc.IsPrimaryKey);
}
return(_primaryKeyProperties);
}
public string GetCommandText_Delete()
{
var sbQuery = new StringBuilder();
var primaryKey = DataModelColumnProperties.First(dmc => dmc.IsPrimaryKey);
sbQuery.AppendLine($"DELETE FROM {TableName} WHERE {Get_PrimaryKeyProperties().ColumnName} = @{Get_PrimaryKeyProperties().ColumnName} ");
return(sbQuery.ToString());
}
public DataUsers(DataModelColumnProperties <int> columnUserIDProperties,
DataModelColumnProperties <string> columnFirstNameProperties, string firstName,
DataModelColumnProperties <string> columnLastNameProperties, string lastName,
DataModeForeignKey fkCountry, DataCountries country)
{
Init(columnUserIDProperties, columnFirstNameProperties, columnLastNameProperties, fkCountry);
ColumnFirstName.ColumnValue = firstName;
ColumnLastName.ColumnValue = lastName;
FKCountry = fkCountry;
Country = country;
}
// Check ownership of datamodel of the following
public SqliteCommand GetCommand_Insert(T dataModel)
{
var query = GetCommandText_Insert();
var insertSQL = new SqliteCommand(query);
var pk = DataModelColumnProperties.FirstOrDefault(dmc => dmc.IsPrimaryKey);
bool includePK = true;
if (pk != null)
{
includePK = !pk.IsAutoIncrement;
}
dataModel.AddParameters_AllColumns(insertSQL, includePK);
return(insertSQL);
}
/*
* public virtual string GetCommandText_BasicSelect(bool selectAll = true, int pageSize = 0, int startIndex = 0)
* {
* var sbQuery = new StringBuilder();
* var sbSelect = new StringBuilder();
*
* sbSelect.AppendFormat("SELECT {0}", DataModelColumnProperties[0].ColumnName);
* for (int i = 1; i < DataModelColumnProperties.Count; i++)
* {
* sbSelect.AppendFormat(", {0}", DataModelColumnProperties[i].ColumnName);
* }
*
* var primaryKey = DataModelColumnProperties.First(dmc => dmc.IsPrimaryKey);
* sbQuery.AppendFormat(" FROM {0}", TableName);
*
* for (int i = 0; i < DataModelForeignKeyProperties.Count(); i++)
* {
* if (DataModelForeignKeyProperties[i].PerformJoin) {
* sbSelect.Append(DataModelForeignKeyProperties[i].GetColumnsForSelectQuery());
* sbQuery.Append($" JOIN {DataModelForeignKeyProperties[i].GetJoinName()}");
* sbQuery.Append($" ON {DataModelForeignKeyProperties[i].ColumnName} = {DataModelForeignKeyProperties[i].GetForeignTablePK()}");
* }
* else
* {
* sbSelect.Append($", {DataModelForeignKeyProperties[i].ColumnName}");
* }
* }
*
* if (!selectAll)
* {
* sbQuery.AppendLine(string.Format(" WHERE {0} = @{0}", primaryKey.ColumnName));
* }
*
* sbQuery.AppendLine(string.Format(" ORDER BY {0}", primaryKey.ColumnName));
*
* if (pageSize > 0)
* {
* sbQuery.AppendLine(string.Format(" LIMIT {0}, {1}", pageSize, startIndex));
* }
*
* return $"{sbSelect.ToString()} {sbQuery.ToString()}";
* }
*
* public virtual string GetCommandText_BasicSelect(List<DataModel.IDataModelColumn> parameters, int pageSize = 0, int startIndex = 0)
* {
* var sbQuery = new StringBuilder();
* sbQuery.AppendFormat("SELECT {0}", DataModelColumnProperties[0].ColumnName);
* for (int i = 1; i < DataModelColumnProperties.Count; i++)
* {
* sbQuery.AppendFormat(", {0}", DataModelColumnProperties[i].ColumnName);
* }
*
* var primaryKey = DataModelColumnProperties.First(dmc => dmc.IsPrimaryKey);
* sbQuery.Append($" FROM {TableName}");
* if(parameters.Count > 0){
* sbQuery.Append(" WHERE");
* for (int pi = 0; pi < parameters.Count; pi++)
* {
* if (pi > 0)
* {
* sbQuery.Append(" AND");
* }
* sbQuery.AppendLine(string.Format(" {0} = @{0}", parameters[pi].GetColumnProperties().ColumnName));
* }
* }
* sbQuery.AppendLine(string.Format(" ORDER BY {0}", primaryKey.ColumnName));
* if (pageSize > 0)
* {
* sbQuery.AppendLine(string.Format(" LIMIT {0}, {1}", pageSize, startIndex));
* }
* return sbQuery.ToString();
* }
*
* public virtual string GetCommandText_SelectByPrimaryKey()
* {
* var sbQuery = new StringBuilder();
* sbQuery.AppendFormat("SELECT {0}", DataModelColumnProperties[0].ColumnName);
* for (int i = 1; i < DataModelColumnProperties.Count; i++)
* {
* sbQuery.AppendFormat(", {0}", DataModelColumnProperties[i].ColumnName);
* }
*
* var primaryKey = DataModelColumnProperties.First(dmc => dmc.IsPrimaryKey);
* sbQuery.AppendFormat(" WHERE {0} = @{0}", primaryKey.ColumnName);
*
* sbQuery.AppendFormat(" FROM {0} ORDER BY {1}", TableName, primaryKey.ColumnName);
* return sbQuery.ToString();
* }
*/
public string GetCommandText_Update()
{
var sbQuery = new StringBuilder();
var lstDMC = DataModelColumnProperties.Where(dmc => !dmc.IsPrimaryKey).ToList();
sbQuery.AppendFormat("UPDATE {0} SET {1} = @{1} ", TableName, lstDMC[0].ColumnName);
for (int i = 1; i < lstDMC.Count; i++)
{
sbQuery.AppendFormat(",{0} = @{0} ", lstDMC[i].ColumnName);
}
sbQuery.AppendFormat("WHERE {0} = @{0}", Get_PrimaryKeyProperties().ColumnName);
return(sbQuery.ToString());
}
private void Init(DataModelColumnProperties <int> columnUserIDProperties,
DataModelColumnProperties <string> columnFirstNameProperties,
DataModelColumnProperties <string> columnLastNameProperties,
DataModeForeignKey fkCountry)
{
ColumnUserID = new DataModelColumn <int>(columnUserIDProperties);
DataModelColumns.Add(ColumnUserID);
ColumnFirstName = new DataModelColumn <string>(columnFirstNameProperties);
DataModelColumns.Add(ColumnFirstName);
ColumnLastName = new DataModelColumn <string>(columnLastNameProperties);
DataModelColumns.Add(ColumnLastName);
FKCountry = fkCountry;
DataModelForeignKeys.Add(FKCountry);
}
public DataModelColumn(DataModelColumnProperties <T> columnProperties, T columnValue)
{
ColumnProperties = columnProperties;
ColumnValue = columnValue;
}
public DataModelColumn(DataModelColumnProperties <T> columnProperties)
{
ColumnProperties = columnProperties;
}
public override void GenerateDataColumnProperties()
{
DataModelColumnProperties.Clear();
DataModelColumnProperties.Add(ColumnPropertiesCountryID);
DataModelColumnProperties.Add(ColumnPropertiesCountryName);
}
