public static OwnerModel GetTheOwner(InvestmentModel investment)
{
InvestmentModel investmentModel;
foreach (OwnerModel ownerModel in PublicVariables.Owners)
{
investmentModel = ownerModel.Investments.Find(x => x == investment);
if (investmentModel != null)
{
return(ownerModel);
}
}
return(null);
}
/// <summary>
/// Add the investment to the database
/// </summary>
/// <param name="investment">The new investment model</param>
/// <param name="owner">The Owner who Invested the money</param>
/// <param name="db"></param>
/// <returns>The New investment with the new Id</returns>
public static InvestmentModel AddInvestmentToTheDatabase(InvestmentModel investment, OwnerModel owner, string db)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnVal(db)))
{
var p = new DynamicParameters();
p.Add("@OwnerId", owner.Id);
p.Add("@Date", investment.Date);
p.Add("@TotalMoney", investment.TotalMoney);
p.Add("@StoreId", investment.Store.Id);
p.Add("@StaffId", investment.Staff.Id);
p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spInvestment_Create", p, commandType: CommandType.StoredProcedure);
investment.Id = p.Get <int>("@Id");
}
return(investment);
}
