public JsonResult Update(advPages data)
{
adv newAdv = new adv();
newAdv.id = data.id;//identity value will be changed automatic
newAdv.description = data.description;
newAdv.content = data.content;
newAdv.isViewAgain = data.isViewAgain;
newAdv.amount = data.amount;
newAdv.startDate = data.startDate;
newAdv.stat = data.stat;
newAdv.waitingTime = data.waitingTime;
newAdv.waitingAfterClosed = data.waitingAfterClosed;
newAdv.image = data.image;
advRelatedPage newAdvPage = null;
List <byte> pageIDs = data.pagesID;
List <advRelatedPage> pgs = db.advRelatedPages.Where(a => a.advID == newAdv.id).ToList();
try
{
db.Entry(newAdv).State = System.Data.Entity.EntityState.Modified;
foreach (var item in pgs)
{
db.advRelatedPages.Remove(item);
}
db.SaveChanges();
db.rearrangeID("advRelatedPage", "id");
db.SaveChanges();
int count = db.advRelatedPages.Count();
foreach (var id in pageIDs)
{
newAdvPage = new advRelatedPage();
newAdvPage.id = ++count;
newAdvPage.advID = newAdv.id;
newAdvPage.pageID = id;
db.advRelatedPages.Add(newAdvPage);
}
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Add(advPages data)
{
try
{
adv newAdv = new adv();
int count = db.advs.Count();
newAdv.id = (byte)(count + 1);
newAdv.description = data.description;
newAdv.content = data.content;
newAdv.isViewAgain = data.isViewAgain;
newAdv.amount = data.amount;
newAdv.startDate = data.startDate;
newAdv.stat = data.stat;
newAdv.waitingTime = data.waitingTime;
newAdv.waitingAfterClosed = data.waitingAfterClosed;
newAdv.image = data.image;
advRelatedPage newAdvPage = null;
List <byte> pageIDs = data.pagesID;
db.advs.Add(newAdv);
count = db.advRelatedPages.Count();
foreach (var id in pageIDs)
{
newAdvPage = new advRelatedPage();
newAdvPage.id = ++count;
newAdvPage.advID = newAdv.id;
newAdvPage.pageID = id;
db.advRelatedPages.Add(newAdvPage);
}
db.SaveChanges();
return(Json(new { result = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
