public ActionResult Create(AdvertisementModel model)
{
try
{
context.AdvertisementInsertRow(model.AdName, model.Text, model.PublishDate, model.AddDate, model.NewsPaperId);
return RedirectToAction("Index");
}
catch
{
return View(model);
}
}
//
// GET: /Advertisement/Details/5
public ActionResult Details(int id)
{
AdvertisementModel model = new AdvertisementModel();
var result = context.AdvertisementSelectRow(id).SingleOrDefault();
model.AdId = result.ID;
model.AdName = result.AdName;
model.AddDate = result.AddDate;
model.PublishDate = result.PublishDate;
model.Text = result.Text;
model.NewsPaperId = result.NewsPaperId;
model.PaperName = result.Name;
return View(model);
}
//
// GET: /Advertisement/Create
public ActionResult Create()
{
AdvertisementModel model = new AdvertisementModel();
PrepareNewspaper(model);
return View(model);
}
private void PrepareNewspaper(AdvertisementModel model)
{
model.Newspapers = context.NewsPapers.AsQueryable<NewsPaper>().Select(x =>
new SelectListItem()
{
Text = x.Name,
Value = x.PaperId.ToString()
});
}
public List<AdvertisementModel> getAdvertisements()
{
IList<AdvertisementModel> adList = new List<AdvertisementModel>();
AdvertisementModel ad;
var result = context.AdvertisementSelectAll();
foreach (var item in result)
{
ad = new AdvertisementModel();
ad.AdName = item.AdName;
ad.AdId = item.ID;
ad.AddDate = item.AddDate;
ad.PublishDate = item.PublishDate;
ad.Text = item.Text;
ad.NewsPaperId = item.NewsPaperId;
ad.PaperName = item.Name;
adList.Add(ad);
}
return adList.ToList();
}
public ActionResult Edit(AdvertisementModel model)
{
try
{
Advertisement ad = new Advertisement()
{
ID = model.AdId,
AdName = model.AdName,
AddDate = model.AddDate,
PublishDate = model.PublishDate,
Text = model.Text,
NewsPaperId = model.NewsPaperId
};
context.AdvertisementUpdateRow(model.AdId,model.AdName, model.Text, model.PublishDate, model.AddDate, model.NewsPaperId);
return RedirectToAction("Index");
}
catch
{
return View(model);
}
}
