public int AddCollection(CollectionModel collection)
{
try
{
Collection newCollection=new Collection();
newCollection.Car_ID = collection.CarID;
newCollection.UserInfo_ID = collection.UserInfo_ID;
context.AddToCollection(newCollection);
context.SaveChanges();
return 1;
}
catch (Exception)
{
return 0;
}
}
public int EditCollection(CollectionModel collection)
{
try
{
int id = collection.ID;
var editCollection = context.Collection.FirstOrDefault(c => c.ID == id);
editCollection.UserInfo_ID = collection.UserInfo_ID;
editCollection.Car_ID = collection.CarID;
context.SaveChanges();
return 1;
}
catch (Exception)
{
return 0;
}
}
/// <summary>
/// 添加到收藏夹
/// </summary>
/// <returns></returns>
public ActionResult AddToCollection(int carid)
{
var session = Session["logID"];
if (session == null)
{
return RedirectToAction("Login");
}
else
{
int userid = Int32.Parse(session.ToString());
CollectionModel model = new CollectionModel();
model.CarID = carid;
model.UserInfo_ID = userid;
ICollectionDal dal = new CollectionDal();
dal.AddCollection(model);
return RedirectToAction("MyCollection");
}
}
public List<CollectionModel> GetAllCollections()
{
try
{
List<CollectionModel> list=new List<CollectionModel>();
IQueryable<Collection> collections = context.Collection;
foreach (var collection in collections)
{
CollectionModel model=new CollectionModel();
model.ID = collection.ID;
model.CarID = collection.Car_ID;
model.UserInfo_ID = collection.UserInfo_ID;
list.Add(model);
}
return list;
}
catch (Exception)
{
return null;
}
}
/// <summary>
/// 根据用户ID获取收藏夹
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public List<CollectionModel> GetCollectionsByUserId(int userid)
{
var collections=context.Collection.Where(c => c.UserInfo_ID == userid);
List<CollectionModel> list=new List<CollectionModel>();
foreach (var collection in collections)
{
CollectionModel model=new CollectionModel();
model.ID = collection.ID;
model.CarID = collection.Car_ID;
model.UserInfo_ID = collection.UserInfo_ID;
list.Add(model);
}
return list;
}
