public string InsertWishlist(Wishlist obj_wishlist)
{
string result = "";
using (OnlineShoppingDataContext db = new OnlineShoppingDataContext())
{
tbl_Wishlist table_wish = (from a in db.tbl_Wishlists
where a.CustomerID == obj_wishlist.CustomerID && a.ProductID == obj_wishlist.ProductID
select a).FirstOrDefault();
if (table_wish != null)
{
result = "You already added to wishlist.";
}
else
{
tbl_Wishlist table_Wishlist = new tbl_Wishlist();
Guid id = Guid.NewGuid();
table_Wishlist.WishlistID = id.ToString();
table_Wishlist.ProductID = obj_wishlist.ProductID;
table_Wishlist.CustomerID = obj_wishlist.CustomerID;
table_Wishlist.AddedDate = obj_wishlist.AddedDate;
db.tbl_Wishlists.InsertOnSubmit(table_Wishlist);
db.SubmitChanges();
result = "Successfully added to the wishlist.";
}
}
return(result);
}
public bool UpdateWishlist(console.Models.tbl_Wishlist entity)
{
bool result = false;
using (var context = new console.Models.dream_techContext())
{
tbl_Wishlist wishlist = (from w in context.tbl_Wishlist where w.wishlist_id == entity.wishlist_id select w).First();
wishlist.user_id = entity.user_id;
result = context.SaveChanges() > 1;
}
return(result);
}
public Wishlist GetWishlistByID(string wishlistID)
{
Wishlist obj_Wishlist = new Wishlist();
using (OnlineShoppingDataContext db = new OnlineShoppingDataContext())
{
tbl_Wishlist table_wishlist = (from a in db.tbl_Wishlists where a.WishlistID == wishlistID select a).FirstOrDefault();
obj_Wishlist.WishlistID = table_wishlist.WishlistID;
obj_Wishlist.ProductID = table_wishlist.ProductID;
obj_Wishlist.CustomerID = table_wishlist.CustomerID;
obj_Wishlist.AddedDate = table_wishlist.AddedDate;
}
return(obj_Wishlist);
}
