public static void AddRequestLog(string reqUrl, string reqBody, string respData, RequestType requestType)
{
using (var db = new InvestmentEntities())
{
var rLog = db.RequestLogs.Create();
rLog.RequestType = (int)requestType;
rLog.ResponseData = respData;
rLog.RequestBody = reqBody;
rLog.Url = reqUrl;
rLog.CreatedOn = DateTime.UtcNow;
db.RequestLogs.Add(rLog);
db.SaveChanges();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
using (InvestmentEntities entities = new InvestmentEntities())
{
MutualFundTransaction transaction = new MutualFundTransaction();
transaction.MutualFundID = Convert.ToInt32(ddlInvestment.SelectedValue);
transaction.NumberOfShares = Decimal.Parse(txtNumberOfShares.Text);
transaction.PricePerShare = Decimal.Parse(txtPricePerShare.Text);
transaction.ActualAmount = Decimal.Parse(txtActualAmount.Text);
transaction.TransactionDate = DateTime.Parse(txtTransactionDate.Text);
transaction.Note = txtNote.Text;
entities.MutualFundTransactions.AddObject(transaction);
entities.SaveChanges();
}
MessageBox.Show("This transaction has been saved");
}
private void btnSave_Click(object sender, EventArgs e)
{
using (InvestmentEntities entities = new InvestmentEntities())
{
MutualFundReturn mfReturn = new MutualFundReturn();
mfReturn.MutualFundID = Convert.ToInt32(ddlInvestment.SelectedValue);
mfReturn.NumberOfShares = Decimal.Parse(txtNumberOfShares.Text);
mfReturn.PricePerShare = Decimal.Parse(txtPricePerShare.Text);
mfReturn.Amount = Decimal.Parse(txtActualAmount.Text);
mfReturn.TransactionDate = DateTime.Parse(txtTransactionDate.Text);
mfReturn.MutualFundReturnTypeName = ddlReturnType.SelectedValue.ToString();
mfReturn.Destination = "Reinvest";
entities.MutualFundReturns.AddObject(mfReturn);
entities.SaveChanges();
}
MessageBox.Show("This return has been saved");
}
public static void UpdateStockCompany(StockCompany updStockComp)
{
using (var db = new InvestmentEntities())
{
var stockCmp = db.StockCompanies.FirstOrDefault(x => x.TickerCode == updStockComp.TickerCode);
if (stockCmp == null)
{
return;
}
if (updStockComp.LatsUpdatedOn != null)
{
stockCmp.LatsUpdatedOn = updStockComp.LatsUpdatedOn;
}
db.Entry <StockCompany>(stockCmp).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void AddStockCompany(StockCompany newStockComp)
{
using (var db = new InvestmentEntities())
{
var isExist = db.StockCompanies.Any(x => x.TickerCode == newStockComp.TickerCode);
if (!isExist)
{
var newStockCmp = db.StockCompanies.Create();
newStockCmp.TickerCode = newStockComp.TickerCode;
newStockCmp.CompanyName = newStockComp.CompanyName;
newStockCmp.Industry = newStockComp.Industry;
newStockCmp.IndustryGroup = newStockComp.IndustryGroup;
newStockCmp.CreatedOn = DateTime.UtcNow;
db.StockCompanies.Add(newStockCmp);
db.SaveChanges();
}
}
}
