// GET: Search
public ActionResult Index(string criteria)
{
List <Article> articles = new List <Article>();
using (var db = new TuPrecioDbContext()) {
articles = db.Articles.Where(a => a.Name.Contains(criteria)).ToList();
}
return(View(articles));
}
// GET: Article
public ActionResult Index(int id)
{
Article article = null;
using (var db = new TuPrecioDbContext())
{
article = db.Articles.Where(a => a.Id == id).FirstOrDefault();
}
return(View(article));
}
public JsonResult LocationsQuery(string query)
{
if (Request.IsAjaxRequest())
{
using (var db = new TuPrecioDbContext())
{
var locations = db.Locations.Where(l => l.Name.Contains(query)).ToList();
var locObjs = locations
.Select(x => new { Id = x.Id, Name = x.Name });
return(Json(locObjs, JsonRequestBehavior.AllowGet));
}
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(ArticleViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (var db = new TuPrecioDbContext())
{
var newArticle = new Article();
newArticle.Comment = model.Comment;
newArticle.Currency = db.Currencies.FirstOrDefault();
newArticle.InsertDate = DateTime.Today;
newArticle.Name = model.Name;
newArticle.Price = Convert.ToDecimal(model.Price);
newArticle.Unit = db.UnitTypes.FirstOrDefault();
var newLocation = db.Locations.Where(l => l.Name == model.BusinnesName &&
l.Latitude == model.Latitude &&
l.Longitude == l.Longitude).FirstOrDefault();
if (newLocation == null)
{
newLocation = new Location();
newLocation.Name = model.BusinnesName;
newLocation.Latitude = model.Latitude;
newLocation.Longitude = model.Longitude;
newLocation.Address = model.Address;
newLocation.Articles = new List <Article> {
newArticle
};
db.Locations.Add(newLocation);
}
newArticle.Location = new List <Location> {
newLocation
};
db.Articles.Add(newArticle);
db.SaveChanges();
}
return(RedirectToAction("Create", "Article"));
}
return(View(model));
}
catch
{
return(View());
}
}
