// 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();
}
