public ActionResult Create([Bind(Include = "Name,Description,Genre,Price,Publisher")] Magazine magazine)
{
if (ModelState.IsValid)
{
Magazine mag = new Magazine
{
Name = magazine.Name,
Description = magazine.Description,
Genre = magazine.Genre,
Price = magazine.Price,
Publisher = magazine.Publisher
};
var pubList = from n in db.Publishers
where n.Name == magazine.Publisher
select n;
if (!pubList.Any())
{
Publisher pub = new Publisher {Name = magazine.Name };
db.Publishers.Add(pub);
db.SaveChanges();
}
try
{
db.Magazines.Add(mag);
db.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View("~/Views/Home/Index.cshtml", null);
}
}
return View(magazine);
}
public ActionResult AddMagazine()
{
String mName = Convert.ToString(Request["name"].ToString());
String mDescription = Convert.ToString(Request["description"].ToString());
String mGenre = Convert.ToString(Request["genre"].ToString());
decimal mPrice = Convert.ToDecimal(Request["price"].ToString());
String mPublisher = Convert.ToString(Request["publisher"].ToString());
Magazine magazine = new Magazine { Name = mName, Description = mDescription, Genre = mGenre, Price = mPrice, Publisher = mPublisher };
var pubList = from n in db.Publishers
where n.Name == magazine.Publisher
select n;
var genreList = from m in db.Genres
where m.Name == magazine.Genre
select m;
if (!genreList.Any())
{
Genre gen = new Genre { Name = magazine.Genre };
db.Genres.Add(gen);
db.SaveChanges();
}
if (!pubList.Any())
{
Publisher pub = new Publisher { Name = magazine.Publisher };
db.Publishers.Add(pub);
db.SaveChanges();
}
db.Magazines.Add(magazine);
db.SaveChanges();
return View("~/Views/Magazines/Index.cshtml", db.Magazines.ToList());
}