public void GetLabelData(int number, int balance)
{
portfolio port = new portfolio();
port.number = number;
port.balance = balance;
}
public IHttpActionResult PutPortfolio(int id, portfolio portfolio)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != portfolio.portfolio_id)
{
return(BadRequest());
}
db.Entry(portfolio).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!portfolioExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public TModel CreateModel <TModel>(portfolio input) where TModel : class
{
if (typeof(TModel) == typeof(portfolio))
{
return(TranslateToOutput(input) as TModel);
}
return(null);
}
public void InsertPortfolio(portfolio item)
{
if (item != null)
{
_myContext.portfolio.Add(item);
_myContext.SaveChanges();
}
}
public void UpdatePortfolio(portfolio item)
{
if (item != null)
{
_myContext.portfolio.Update(item);
_myContext.SaveChanges();
}
}
private Portfolio TranslateToOutput(portfolio input)
{
return(new Portfolio
{
Id = input.Id,
Description = input.Description,
Code = input.Code
});
}
public ActionResult Detail_(string baseSymbol)
{
portfolio a = PortfolioUtil._getDefaultPortfolio(baseSymbol);
ViewBag.portfolio = a;
ViewBag.username = Session["username"];
ViewBag.password = Session["password"];
return(View("Detail"));
}
public IHttpActionResult GetPortfolio(int id)
{
portfolio portfolio = db.portfolios.Find(id);
if (portfolio == null)
{
return(NotFound());
}
return(Ok(portfolio));
}
public ActionResult readPortfolioDetail(portfolio item)
{
if (Session["username"] != null)
{
var result = DataAnalytics.Utils.PortfolioUtil._readPortfolioDetail(item);
return(Json(new { data = result }));
}
else
{
return(Json(new { errmsg = "login time out" }));
}
}
public IHttpActionResult DeletePortfolio(int id)
{
portfolio portfolio = db.portfolios.Find(id);
if (portfolio == null)
{
return(NotFound());
}
db.portfolios.Remove(portfolio);
db.SaveChanges();
return(Ok(portfolio));
}
public ActionResult Detail(string portfolioId)
{
//the web page call like this one should judge ViewBag.username to determine if redirect to signin
portfolio a = PortfolioUtil._getPortfolio(portfolioId);
if (a.from == null)
{
return(RedirectToAction("Index"));
}
ViewBag.portfolio = a;
ViewBag.username = Session["username"];
ViewBag.password = Session["password"];
return(View("Detail"));
}
public void UpdatePortfolio(portfolio item)
{
using (var conn = new SqlConnection(myContext._connectionString))
{
var jsonItem = JsonConvert.SerializeObject(item);
conn.Open();
SqlCommand cm = new SqlCommand("JsonUpdate", conn);
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add(new SqlParameter()
{
SqlDbType = SqlDbType.NVarChar, ParameterName = "jsonItem", Value = jsonItem, Direction = ParameterDirection.Input
});
cm.ExecuteNonQuery();
conn.Close();
}
}
public IHttpActionResult PostPortfolio(portfolio portfolio)
{
// Set the created_at DateTime variable to be the current time (YYYY-MM-DD HH:MM:SS)
portfolio.created_at = DateTime.Now;
// When the portfolio is created, the updated_at time should be the same as the created_at time
portfolio.updated_at = DateTime.Now;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.portfolios.Add(portfolio);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { controller = "Portfolios", id = portfolio.portfolio_id }, portfolio));
}
public IHttpActionResult Post()
{
//Create HTTP Response.
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
//Check if Request contains File.
//Read the File data from Request.Form collection.
HttpPostedFile postedFile = HttpContext.Current.Request.Files["image_upload"];
var category = HttpContext.Current.Request["id_category"];
var title = HttpContext.Current.Request["portfo_name"];
var file = Path.GetFileNameWithoutExtension(postedFile.FileName);
var extension = Path.GetExtension(postedFile.FileName);
var filename = file + DateTime.Now.ToString("yymmssff") + extension;
postedFile.SaveAs(HttpContext.Current.Server.MapPath("/Assets/Images/") + filename);
//Convert the File data to Byte Array.
byte[] bytes;
using (BinaryReader br = new BinaryReader(postedFile.InputStream))
{
bytes = br.ReadBytes(postedFile.ContentLength);
}
//Insert the File to Database Table.
MyPortfolioEntities db = new MyPortfolioEntities();
portfolio porfo = new portfolio
{
portfo_name = title,
id_category = Convert.ToInt32(category),
image_title = filename,
image_path = "/Assets/Images/" + filename,
image_byte = bytes
};
db.portfolios.Add(porfo);
db.SaveChanges();
return(Ok());
}
public bool SavePortfolio(transaction transaction, out string errorMessage)
{
bool success = true;
errorMessage = String.Empty;
try
{
portfolio portfolio = new portfolio();
portfolio.total_shares = transaction.number_of_shares;
portfolio.average_price = transaction.transaction_price;
entities.portfolios.Add(portfolio);
entities.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e.InnerException.Message.ToString());
errorMessage = e.InnerException.InnerException.Message;
success = false;
}
return(success);
}
public IActionResult AddPortfolio([FromBody] portfolio item)
{
repository.InsertPortfolio(item);
return(Ok());
}
public IActionResult UpdatePortfolio([FromBody] portfolio item)
{
repository.UpdatePortfolio(item);
return(Ok());
}
