public ActionResult Edit1(int id)
{
UserDBEntities1 db = new UserDBEntities1();
CollectionTable art = db.CollectionTables.Where(u => u.Id == id).Single();
CollectionEditVM collectionDetailsVM = new CollectionEditVM(art);
return(View("Edit1", collectionDetailsVM));
}
public CollectionEditVM(CollectionTable collectionTable)
{
base.Title = collectionTable.Title;
base.Author = collectionTable.Author;
base.Director = collectionTable.Director;
base.DateReleased = collectionTable.DateReleased;
base.Price = collectionTable.Price;
base.Type = collectionTable.Type;
}
public ActionResult Details1(int id)
{
ViewBag.Message = "Details about the art.";
var db = new UserDBEntities1();
CollectionTable art = db.CollectionTables.Where(u => u.Id == id).Single();
CollectionDetailsVM collectionDetailsVM = new CollectionDetailsVM(art);
return(View("Details1", collectionDetailsVM));
}
public ActionResult Remove1(int id)
{
UserDBEntities1 db = new UserDBEntities1();
CollectionTable art = db.CollectionTables.Where(u => u.Id == id).Single();
if (art != null)
{
db.CollectionTables.Remove(art);
}
db.SaveChanges();
return(Collection());
}
public ActionResult Edit1(CollectionEditVM art)
{
UserDBEntities1 db = new UserDBEntities1();
CollectionTable artToUpdate = db.CollectionTables.Where(u => u.Id == art.Id).Single();
artToUpdate.Title = art.Title;
artToUpdate.Author = art.Author;
artToUpdate.Director = art.Director;
artToUpdate.DateReleased = art.DateReleased;
artToUpdate.Price = art.Price;
artToUpdate.Type = art.Type;
db.SaveChanges();
return(Collection());
}
public ActionResult Add(int id)
{
shoppingCart = (CartVM)Session["shoppingCart"];
if (Session["shoppingCart"] == null)
{
Session["shoppingCart"] = new CartVM();
}
UserDBEntities1 db = new UserDBEntities1();
CollectionTable art = db.CollectionTables.Where(u => u.Id == id).Single();
if (art != null)
{
shoppingCart.Add(art);
}
Session["shoppingCart"] = shoppingCart;
return(Collection());
}
protected void Page_Load(object sender, EventArgs e)
{
string searchQuery = Request.QueryString["q"];
// Get all books if no search query
// Get filtered result if search query
if (String.IsNullOrEmpty(searchQuery))
{
_books = _thisDal.GetBooks();
}
else
{
_books = _thisDal.GetBooks(searchQuery);
CollectionTitle.Text = "Showing results for '" + searchQuery + "'";
}
CollectionTable.DataSource = _books;
CollectionTable.DataBind();
}
private bool TheStringIsInEachOfTheRowContent(string stringToSearch, IWebElement collection, string translateFrom = null, string translateTo = null)
{
if (collection is null)
{
throw new ArgumentNullException(nameof(collection));
}
var notFound = false;
stringToSearch = stringToSearch.ToLower();
try
{
_driverWait.Until(driver => driver.FindElements(By.XPath("//tr[contains(@class,'collection__item')]")).Count > 0);
}
catch (NoSuchElementException)
{
return(false);
}
var rows = CollectionTable.FindElements(By.CssSelector("tbody > tr"));
foreach (var row in rows)
{
try
{
var tdFound = row.FindElement(By.XPath($"//td[contains(translate(text(), {translateFrom ?? "'ABCDEFGHIJKLMNOPQRSTUVWXYZ'"}, {translateTo ?? "'abcdefghijklmnopqrstuvwxyz'"}), '{stringToSearch}')]"));
}
catch (Exception)
{
notFound = true;
break;
}
}
return(!notFound);
}
/// <summary>
/// Remove item from collection.
/// </summary>
/// <param name="collectionTable">New item of type CollectionTable.</param>
public void Remove(CollectionTable collectionTable)
{
collectionList.Remove(collectionTable);
}
/// <summary>
/// Add new item to collection.
/// </summary>
/// <param name="collectionTable">New item of type CollectionTable.</param>
public void Add(CollectionTable collectionTable)
{
collectionList.Add(collectionTable);
}
/// <summary>
/// 查询一个用户与一个商品的关系(用户是否收藏了该商品)
/// </summary>
/// <param name="userid">用户id</param>
/// <param name="goodsid">商品id</param>
/// <returns></returns>
public static bool SelectOneCollection(int userid, int goodsid)
{
CollectionTable coll = CollectionDal.SelectOneCollection(userid, goodsid);
return(coll != null && coll.IsCollection == 1);
}
