/// <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); }