public void ShouldChangeShareType()
{
// Arrange
var shareService = new ShareService(
this.shareRepository,
this.shareTypeRepository,
this.stockRepository,
this.traderRepository);
ShareTypeEntity firstShareType = new ShareTypeEntity {
Id = 1
};
ShareTypeEntity secondShareType = new ShareTypeEntity {
Id = 2
};
ShareEntity shareToChange = new ShareEntity {
};
this.shareRepository.GetById(Arg.Is <int>(1)).Returns(shareToChange);
this.shareTypeRepository.GetById(Arg.Is <int>(1)).Returns(firstShareType);
this.shareTypeRepository.GetById(Arg.Is <int>(2)).Returns(secondShareType);
// Act
shareService.ChangeShareType(1, 2);
// Assert
this.shareRepository.Received(1).Save(shareToChange);
Assert.IsTrue(shareToChange.ShareType == secondShareType);
}
public int InsertShareType(ShareTypeEntity entity)
{
string insertSql = @" INSERT INTO [ShareType]([Title],[CreatedBy],[CreatedOn],[Type])
VALUES(@Title, @CreatedBy, @CreatedOn, @Type);
SELECT ISNULL( SCOPE_IDENTITY(),0);";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(insertSql))
{
try
{
db.AddInParameter(dbCommand, "Title", DbType.String, entity.Title);
db.AddInParameter(dbCommand, "CreatedBy", DbType.Int32, entity.CreatedBy);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, entity.CreatedOn);
db.AddInParameter(dbCommand, "Type", DbType.Int32, entity.Type);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]"
, insertSql, base.FormatParameters(dbCommand.Parameters), ex.Message));
return(0);
}
}
}
public List <ShareTypeEntity> GetShareTypes()
{
string strSql = @"SELECT * FROM [ShareType]";
var list = new List <ShareTypeEntity>();
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql))
{
try
{
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
while (dataReader.Read())
{
list.Add(ShareTypeEntity.ReaderBind(dataReader));
}
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]"
, strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(null);
}
}
return(list);
}
/// <summary>
/// 详细页面
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IActionResult Detail(int id)
{
ShareTypeBLL shareTypeBLL = new ShareTypeBLL();
ShareTypeEntity shareTypeEntity = shareTypeBLL.GetById(id);
return(View(shareTypeEntity));
}
public void ChangeType(int shareId, ShareTypeEntity newShareType)
{
ContainsById(shareId);
this.tableRepository.SetType(shareId, newShareType);
this.tableRepository.SaveChanges();
}
public virtual void ChangeShareType(int shareId, int shareTypeId)
{
ValidateShareExistence(shareId);
ValidateShareTypeExistence(shareTypeId);
ShareEntity shareToChange = this.shareTableRepository.GetById(shareId);
ShareTypeEntity shareType = this.shareTypeTableRepository.GetById(shareTypeId);
shareToChange.ShareType = shareType;
this.shareTableRepository.Save(shareToChange);
}
public int RegisterNewShareType(ShareTypeRegistrationInfo args)
{
var entityToAdd = new ShareTypeEntity()
{
Name = args.Name,
Cost = args.Cost,
Status = args.Status
};
if (this.tableRepository.Contains(entityToAdd))
{
throw new ArgumentException("This share type has been registered. Can't continue.");
}
this.tableRepository.Add(entityToAdd);
this.tableRepository.SaveChanges();
return(entityToAdd.Id);
}
public bool InsertType(ShareTypeEntity type)
{
this.ClearBrokenRuleMessages();
BaseValidator <ShareTypeEntity> validator = new ShareTypeValidator();
if (!validator.Validate(type))
{
this.AddBrokenRuleMessages(validator.BrokenRuleMessages);
}
int id = _shareRepo.InsertShareType(type);
if (id <= 0)
{
this.AddBrokenRuleMessage();
return(false);
}
type.ID = id;
_cache[CacheKeyAllShareTypes] = null;
return(true);
}
public bool Contains(ShareTypeEntity entity)
{
return(this.dBContext.ShareTypes.Any(s =>
s.Name == entity.Name));
}
public void Add(ShareTypeEntity entity)
{
this.dBContext.ShareTypes.Add(entity);
}
protected override void Seed(TradingAppDbContext context)
{
TraderEntity trader1 = new TraderEntity {
FirstName = "Igor", LastName = "Igorev", Balance = 500, PhoneNumber = "89999999901"
};
TraderEntity trader2 = new TraderEntity {
FirstName = "Vitaly", LastName = "Vitaliev", Balance = -100, PhoneNumber = "89999999902"
};
TraderEntity trader3 = new TraderEntity {
FirstName = "Andrey", LastName = "Andreev", Balance = 430, PhoneNumber = "89999999903"
};
TraderEntity trader4 = new TraderEntity {
FirstName = "Vladimir", LastName = "Vladimirov", Balance = 390, PhoneNumber = "89999999904"
};
TraderEntity trader5 = new TraderEntity {
FirstName = "Vasiliy", LastName = "Vasiliev", Balance = 450, PhoneNumber = "89999999905"
};
TraderEntity trader6 = new TraderEntity {
FirstName = "Nikolay", LastName = "Nikolaev", Balance = 0, PhoneNumber = "89999999906"
};
CompanyEntity mcDonalds = new CompanyEntity {
Name = "McDonalds"
};
CompanyEntity kfc = new CompanyEntity {
Name = "KFC"
};
CompanyEntity burgerKing = new CompanyEntity {
Name = "Burger King"
};
StockEntity mcDonaldsStock = new StockEntity {
Company = mcDonalds, PricePerUnit = 50
};
StockEntity kfcStock = new StockEntity {
Company = kfc, PricePerUnit = 42
};
StockEntity burgerKingStock = new StockEntity {
Company = burgerKing, PricePerUnit = 40
};
ShareTypeEntity normal = new ShareTypeEntity {
Name = "Normal", Multiplier = 1M
};
ShareTypeEntity privelage = new ShareTypeEntity {
Name = "Privelage", Multiplier = 1.5M
};
ShareTypeEntity special = new ShareTypeEntity {
Name = "Special", Multiplier = 2.5M
};
ShareEntity kfcShare1 = new ShareEntity {
Stock = kfcStock, Owner = trader1, Amount = 3, ShareType = normal
};
ShareEntity kfcShare2 = new ShareEntity {
Stock = kfcStock, Owner = trader2, Amount = 2, ShareType = normal
};
ShareEntity kfcShare3 = new ShareEntity {
Stock = kfcStock, Owner = trader4, Amount = 40, ShareType = special
};
ShareEntity mcDonaldsShare1 = new ShareEntity {
Stock = mcDonaldsStock, Owner = trader1, Amount = 5, ShareType = privelage
};
ShareEntity mcDonaldsShare2 = new ShareEntity {
Stock = mcDonaldsStock, Owner = trader3, Amount = 35, ShareType = special
};
ShareEntity mcDonaldsShare3 = new ShareEntity {
Stock = mcDonaldsStock, Owner = trader6, Amount = 4, ShareType = normal
};
ShareEntity burgerKingShare1 = new ShareEntity {
Stock = burgerKingStock, Owner = trader5, Amount = 25, ShareType = privelage
};
ShareEntity burgerKingShare2 = new ShareEntity {
Stock = burgerKingStock, Owner = trader2, Amount = 4, ShareType = normal
};
ShareEntity burgerKingShare3 = new ShareEntity {
Stock = burgerKingStock, Owner = trader1, Amount = 2, ShareType = normal
};
ShareEntity burgerKingShare4 = new ShareEntity {
Stock = burgerKingStock, Owner = trader3, Amount = 6, ShareType = privelage
};
context.Traders.Add(trader1);
context.Traders.Add(trader2);
context.Traders.Add(trader3);
context.Traders.Add(trader4);
context.Traders.Add(trader5);
context.Traders.Add(trader6);
context.SaveChanges();
context.Companies.Add(mcDonalds);
context.Companies.Add(kfc);
context.Companies.Add(burgerKing);
context.SaveChanges();
context.Stocks.Add(mcDonaldsStock);
context.Stocks.Add(kfcStock);
context.Stocks.Add(burgerKingStock);
context.SaveChanges();
context.ShareTypes.Add(normal);
context.ShareTypes.Add(privelage);
context.ShareTypes.Add(special);
context.SaveChanges();
context.Shares.Add(kfcShare1);
context.Shares.Add(kfcShare2);
context.Shares.Add(kfcShare3);
context.SaveChanges();
context.Shares.Add(mcDonaldsShare1);
context.Shares.Add(mcDonaldsShare2);
context.Shares.Add(mcDonaldsShare3);
context.SaveChanges();
context.Shares.Add(burgerKingShare1);
context.Shares.Add(burgerKingShare2);
context.Shares.Add(burgerKingShare3);
context.Shares.Add(burgerKingShare4);
context.SaveChanges();
}
public void SetType(int entityId, ShareTypeEntity newType)
{
var share = this.dBContext.Shares.First(s => s.Id == entityId); // it will fall here if we can't find
share.Type = newType;
}
