// GET: api/AdminApi/5 public InfoMsg Get(int id) { using (portfolioEntities port = new portfolioEntities()) { var message = port.InfoMsg.SingleOrDefault(x => x.Id == id); return(message); } }
// GET: api/AdminApi public IEnumerable <InfoMsg> Get() { using (portfolioEntities port = new portfolioEntities()) { var listMessages = port.InfoMsg.Select(x => x).ToList(); return(listMessages); } }
// DELETE: api/AdminApi/5 public void Delete(int id) { using (portfolioEntities port = new portfolioEntities()) { var message = port.InfoMsg.SingleOrDefault(x => x.Id == id); if (message != null) { port.InfoMsg.Remove(message); port.SaveChanges(); } } }
public JsonResult SearchStockName(string name) { // ORM portfolioEntities ORM = new portfolioEntities(); // search by name List <StockTkr> Result = ORM.StockTkrs.Where(c => c.Name.Contains(name)).ToList(); // Return data as Jason! return(Json(Result)); }
public ActionResult Leaderboard() { portfolioEntities ORM = new portfolioEntities(); List <Portfolio> results = ORM.Portfolios.ToList(); List <Leaders> leaders = new List <Leaders>(); foreach (Portfolio portfolio in results) { string userName = ORM.AspNetUsers.Find(portfolio.userID).UserName; leaders.Add(new Leaders() { UserPortfolio = portfolio, UserName = userName }); } ViewBag.StockTable = leaders.OrderByDescending(x => x.UserPortfolio.totalprofiit).ToList(); return(View()); }
public ActionResult Contact(ContantViewModel contactModel) { //Todo Send Email message, add to DB message if (ModelState.IsValid) { using (portfolioEntities port = new portfolioEntities()) { var msg = new InfoMsg() { email = contactModel.Email, name = contactModel.Name, text = contactModel.Messege, phone = contactModel.MobileNumber, subject = contactModel.Subject, }; repository.AddMessage(msg); } //for testing busy idicator //Thread.Sleep(2000); return(PartialView("~/Views/Partials/Partial_Success.cshtml", "Your message success sends!!")); } return(PartialView("~/Views/Partials/Partial_Error.cshtml", "Something Wrong!")); }
public DbAccessService() { context = new portfolioEntities(); }