public bool AddBuy(BuyDto buyDto)
{
try
{
var accountEntity = context.Account.FirstOrDefault(p => p.Id == buyDto.AccountId);
var buyEntity = new Buy
{
Account = accountEntity,
TransactionTypeId = buyDto.TransactionTypeId,
TranType = buyDto.TransactionType,
AddedBy = buyDto.AddedBy,
AmtInv = buyDto.AmtInv,
BuyCommission = buyDto.BuyCommission,
BuyDate = buyDto.BuyDate,
BuyPrice = buyDto.BuyPrice,
BuyType = buyDto.BuyType,
Comments = buyDto.Comments,
DividendAmount = buyDto.DividendAmount,
ModifiedBy = buyDto.ModifiedBy,
NumShares = buyDto.NumShares,
orderby = buyDto.orderby,
OriginalBuyGUID = buyDto.OriginalBuyGUID,
refID = buyDto.refID,
DateAdded = DateTime.Now,
DateModified = DateTime.Now,
BuyGUID = Guid.NewGuid(),
InvestmentClassification = accountEntity.InvestmentClassification,
InvestmentClassificationGuid = accountEntity.InvestmentClassificationGuid,
SubAccount = accountEntity.SubAccount,
SubAccountGuid = accountEntity.SubAccountGuid,
Broker = accountEntity.Broker,
BrokerGUID = accountEntity.BrokerGUID,
};
Ticker tickerEntity;
// public Ticker Ticker1 { get; set; }
if (buyDto.Ticker.Length > 0)
{
tickerEntity = context.Tickers.FirstOrDefault(p => p.Symbol == buyDto.Ticker);
if (tickerEntity == null)
{
tickerEntity = new Ticker { Symbol = buyDto.Ticker, tickerGUID = Guid.NewGuid(), type = "", current = true };
}
}
else
{
tickerEntity = context.Tickers.FirstOrDefault(p => p.Id == buyDto.TickerId);
}
buyEntity.Ticker1 = (tickerEntity != null) ? tickerEntity : new Ticker { Symbol = buyDto.Ticker, tickerGUID = Guid.NewGuid(), type = "", current = true };
buyEntity.Ticker = buyDto.Ticker;
buyEntity.TickerGUID = tickerEntity.tickerGUID;
buyEntity.Transactions.Add(new Transaction { AmtInv = buyDto.AmtInv, NumShares = buyDto.NumShares, buySplitPercent = 1, DateAdded = DateTime.Now, DateUpdated = DateTime.Now});
context.SaveChanges();
return true;
}
catch(Exception ex)
{
throw;
}
}
public bool SaveBuy(BuyDto buyDto)
{
var buyEntity = context.Buys.FirstOrDefault(p => p.Id == buyDto.Id);
buyEntity.TransactionTypeId = buyDto.TransactionTypeId;
buyEntity.AddedBy = buyDto.AddedBy;
buyEntity.AmtInv = buyDto.AmtInv;
// buyEntity.Broker = buyDto.Broker;
// buyEntity.BrokerGUID = buyDto.BrokerGUID;
// buyEntity.BuyCommission = buyDto.BuyCommission;
buyEntity.BuyDate = buyDto.BuyDate;
buyEntity.BuyGUID = buyDto.BuyGUID;
buyEntity.BuyPrice = buyDto.BuyPrice;
buyEntity.BuyType = buyDto.BuyType;
buyEntity.Comments = buyDto.Comments;
buyEntity.DateAdded = buyDto.DateAdded;
buyEntity.DateModified = buyDto.DateModified;
buyEntity.DividendAmount = buyDto.DividendAmount;
//buyEntity.Id = buyDto.Id;
// buyEntity.InvestmentClassification = buyDto.InvestmentClassification;
// buyEntity.InvestmentClassificationGuid = buyDto.InvestmentClassificationGuid;
buyEntity.ModifiedBy = buyDto.ModifiedBy;
buyEntity.NumShares = buyDto.NumShares;
buyEntity.orderby = buyDto.orderby;
buyEntity.OriginalBuyGUID = buyDto.OriginalBuyGUID;
buyEntity.refID = buyDto.refID;
// buyEntity.SubTransactionType = buyDto.SubTransactionType;
// buyEntity.SubTransactionTypeGuid = buyDto.SubTransactionTypeGuid;
buyEntity.Ticker = buyDto.Ticker;
// public Ticker Ticker1 { get; set; }
//buyEntity.TickerGUID = buyDto.TickerGUID;
buyEntity.TickerId = buyDto.TickerId;
//buyEntity.TranGUID = buyDto.TranGUID;
buyEntity.TranType = buyDto.TransactionType;
buyEntity.TransactionTypeId = buyDto.TransactionTypeId;
context.SaveChanges();
return true;
}