public ActionResult Index(BookDetails searchDetails)
{
//--Получаем данные из <input> полей--
string genre = Request["genre"];
string size = Request["size"];
string rating = Request["rating"];
string state = Request["state"];
string category = Request["category"];
bool blah = Convert.ToBoolean(Request["blah"]);
string searchName = Request["searchName"];
return RedirectToAction("Index","Book", new System.Web.Routing.RouteValueDictionary(new { blah = blah,
genre = genre,
size = size,
rating = rating,
state = state,
category = category,
searchName = searchName }));
}
public void Add(BookDetails item)
{
db.Open();
command.Connection = db;
SqlCeResultSet result;
command.CommandType = CommandType.TableDirect;
command.CommandText = table;
result = command.ExecuteResultSet(ResultSetOptions.Scrollable | ResultSetOptions.Updatable);
result.Read();
SqlCeUpdatableRecord record = result.CreateRecord();
record.SetInt32(0, item.BookID);
record.SetString(1, item.title);
record.SetString(2, item.author);
record.SetString(3, item.size);
record.SetString(4, item.rating);
record.SetString(5, item.category);
record.SetString(6, item.state);
record.SetString(7, item.summary);
record.SetString(8, item.genre);
record.SetString(9, item.comment);
result.Insert(record, DbInsertOptions.PositionOnInsertedRow);
db.Close();
}
public BookDetails Load(Int32 id)
{
sql = "SELECT * FROM " + table + " WHERE " + table + "ID = " + id;
db.Open();
command.Connection = db;
command.CommandText = sql;
SqlCeDataReader result = command.ExecuteReader();
BookDetails data = new BookDetails();
while (result.Read())
{
data = new BookDetails(result.GetInt32(0), result.GetString(1), result.GetString(2), result.GetString(3),
result.GetString(4), result.GetString(5), result.GetString(6), result.GetString(7), result.GetString(8), result.GetString(9));
}
db.Close();
return data;
}