public Task <List <StockModel> > AddStock(int type, decimal price, int quantity, int occurence) { using (var command = DbSqlCommand.GetSqlCommand()) { try { command.CommandText = SqlConstants.Stock.spAddStock; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@type", type); command.Parameters.AddWithValue("@price", price); command.Parameters.AddWithValue("@quantity", quantity); command.Parameters.AddWithValue("@occurence", occurence); command.Connection.Open(); var reader = command.ExecuteReader(); var stocks = new List <StockModel>(); while (reader.Read()) { stocks.Add(new StockModel { ID = reader.GetInt32(0), Quantity = reader.GetInt32(1), Price = reader.GetDecimal(2), Name = reader.GetString(3), StockProperties = new StockPropertyModel { Id = reader.GetInt32(4), Cost = reader.GetDecimal(5), Tolerance = reader.GetDecimal(6), StockType = new StockTypeModel { Type = reader.GetInt32(7), Name = reader.GetString(8), Occurence = reader.GetInt32(9), } } }); } return(Task.FromResult <List <StockModel> >(stocks)); } catch (Exception ex) { _logger.Error(ex.Message); } finally { command.Connection.Close(); } return(null); } }
public IList <StockPropertyModel> GetAllStockProperties() { using (var command = DbSqlCommand.GetSqlCommand()) { try { command.CommandText = SqlConstants.StockProperty.spGetAllProperties; command.CommandType = System.Data.CommandType.StoredProcedure; command.Connection.Open(); var reader = command.ExecuteReader(); var stockProperties = new List <StockPropertyModel>(); while (reader.Read()) { stockProperties.Add(new StockPropertyModel { Id = reader.GetInt32(3), Cost = reader.GetDecimal(4), Tolerance = reader.GetDecimal(5), StockType = new StockTypeModel { Type = reader.GetInt32(7), Name = reader.GetString(8), Occurence = reader.GetInt32(7), } }); } return(stockProperties); } catch (Exception ex) { _logger.Error(ex.Message); } finally { command.Connection.Close(); _logger.Debug("DbConnection"); } return(null); } }
public Task <List <StockTypeModel> > GetAllStockTypes() { string spGetAllStocks = SqlConstants.Stock.spGetAllStocks; using (var command = DbSqlCommand.GetSqlCommand()) { try { command.CommandText = SqlConstants.StockType.spGetAllStockTypes; command.CommandType = System.Data.CommandType.StoredProcedure; command.Connection.Open(); var reader = command.ExecuteReader(); var stockType = new List <StockTypeModel>(); while (reader.Read()) { stockType.Add(new StockTypeModel { Type = reader.GetInt32(0), Name = reader.GetString(1), Occurence = reader.GetInt32(2), }); } return(Task.FromResult <List <StockTypeModel> >(stockType)); } catch (Exception ex) { _logger.Error(ex.Message); } finally { command.Connection.Close(); } return(null); } }
public void DatabaseCommandCresteCommandTesting() { var dbConnection = DbSqlCommand.GetSqlCommand(); Xunit.Assert.NotNull(dbConnection); }