/// <summary>
/// Update Key after excutant insert to DB.
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true for successfully updated</returns>
public TickerHDB UpdateEntityId(TickerHDB baseEntity, NpgsqlCommand sqlCommand)
{
if (baseEntity != null)
{
var businessObject = baseEntity as TickerHDB;
if (businessObject != null)
{
}
return(businessObject);
}
return(null);
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of ClassInfo</returns>
public List <TickerHDB> PopulateBusinessObjectFromReader(IDataReader dataReader)
{
var list = new List <TickerHDB>();
while (dataReader.Read())
{
var businessObject = new TickerHDB();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
public int Insert(TickerHDB entity)
{
try
{
var cmd = entitySql.GetSqlCommandForInsert(entity);
cmd.Connection = new Npgsql.NpgsqlConnection(connectionstring);
cmd.ExecuteNonQuery();
}catch
{
return(0);
}
return(1);
}
/// <summary>
/// Create a command for action Delete
/// </summary>
/// <param name="baseEntity"></param>
/// <returns></returns>
public NpgsqlCommand GetSqlCommandForDelete(TickerHDB baseEntity)
{
var sqlCommand = new NpgsqlCommand {
CommandType = CommandType.StoredProcedure
};
if (baseEntity != null)
{
var businessObject = baseEntity as TickerHDB;
if (businessObject != null)
{
}
}
return(sqlCommand);
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(TickerHDB businessObject, IDataReader dataReader)
{
businessObject.Day = dataReader.GetDateTime(dataReader.GetOrdinal(TickerHDB.TickerHDBFields.Day.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(TickerHDB.TickerHDBFields.Open.ToString())))
{
businessObject.Open = dataReader.GetDecimal(dataReader.GetOrdinal(TickerHDB.TickerHDBFields.Open.ToString()));
}
businessObject.Hight = dataReader.GetDecimal(dataReader.GetOrdinal(TickerHDB.TickerHDBFields.Hight.ToString()));
businessObject.Hight = dataReader.GetDecimal(dataReader.GetOrdinal(TickerHDB.TickerHDBFields.Hight.ToString()));
businessObject.Hight = dataReader.GetDecimal(dataReader.GetOrdinal(TickerHDB.TickerHDBFields.Hight.ToString()));
businessObject.Hight = dataReader.GetDecimal(dataReader.GetOrdinal(TickerHDB.TickerHDBFields.Hight.ToString()));
}
/// <summary>
/// Create a command for action insert
/// </summary>
/// <param name="baseEntity"></param>
/// <returns></returns>
public NpgsqlCommand GetSqlCommandForInsert(TickerHDB baseEntity)
{
var sqlCommand = new NpgsqlCommand {
CommandType = System.Data.CommandType.StoredProcedure, CommandText = Insertsql
};
if (baseEntity != null)
{
var businessObject = baseEntity as TickerHDB;
if (businessObject != null)
{
sqlCommand.Parameters.AddWithValue("@ClassInfoId", NpgsqlTypes.NpgsqlDbType.Bigint, 8, businessObject.Day);
// sqlCommand.ExecuteNonQuery();
}
}
return(sqlCommand);
}
