public GuestBookModel AddGuestBook(GuestBookModel book)
{
Provider.Execute(@"insert into GuestBooks(GuestBookName) values(@szGuestBookName)"
, new { szGuestBookName = book.GuestBookName }
, CommandType.Text);
return book;
}
public GuestBookModel DeleteGuestBook(GuestBookModel book)
{
Provider.Execute(@"delete from GuestBooks where GuestBookId=@nGuestBookId"
, new { nGuestBookId = book.GuestBookId }
, CommandType.Text);
return book;
}
public virtual ActionResult Save(GuestBookModel book)
{
if (ModelState.IsValid)
{
DataService.UpdateGuestBook(book);
return RedirectToAction(MVC.Admin.Entity.ActionNames.Index);
}
return View(MVC.Admin.Entity.Views.Edit, book );
}
public virtual ActionResult Add(GuestBookModel book)
{
if (!ModelState.IsValid)
{
DataService.AddGuestBook(book);
return RedirectToAction(MVC.Admin.Entity.ActionNames.Index);
}
return View(MVC.Admin.Entity.Views.Add);
}
public GuestBookModel GetDefaultGuestBook(Nullable<int> guestbookId)
{
int tempGuestBookId = 1;
GuestBookModel book= new GuestBookModel();
book.GuestBookId = guestbookId.HasValue ? guestbookId.Value : tempGuestBookId;
return book;
}
public void UpdateGuestBook(GuestBookModel book)
{
Provider.Execute(@"update GuestBooks set GuestBookName=@szGuestBookName where GuestBookId=@nGuestBookId"
, new { szGuestBookName = book.GuestBookName, nGuestBookId = book.GuestBookId }
, CommandType.Text);
}
public MessageModel()
{
GuestBook = new GuestBookModel();
}
public MessageModel()
{
GuestBook = new GuestBookModel();
}
public MessagesInGuestBooksModelview()
{
Book=new GuestBookModel();
}
