public ActionResult AddToWishList(string prodId, string price) { try { if (Session["idUser"] != null) { CustomerWishlistDomain mCustomerWishlist = new CustomerWishlistDomain(); mCustomerWishlist.Amount = Convert.ToDecimal(price); mCustomerWishlist.CreatedDateTime = DateTime.Now; mCustomerWishlist.CustomerId = Convert.ToInt32(Session["idUser"]); mCustomerWishlist.ProductId = prodId; CustmorWishlistCRUD.AddToWishlist(mCustomerWishlist); return(Json(true)); } else { return(RedirectToAction("Login", "Customer")); } } catch (Exception ex) { ExceptionLogDomain obj = new ExceptionLogDomain(); obj.MethodName = "AddToWishList"; obj.ControllerName = "Product"; obj.ErrorText = ex.Message; obj.StackTrace = ex.StackTrace; obj.Datetime = DateTime.Now; ExceptionLogCRUD.AddToExceptionLog(obj); return(RedirectToAction("Index", "Error")); } }
public static void AddToWishlist(CustomerWishlistDomain mCustomerwish) { string mainconn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); sqlconn.Open(); SqlCommand cmd = new SqlCommand("sp_wishlist", sqlconn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mode", "Insert"); cmd.Parameters.AddWithValue("@CustomerId", mCustomerwish.CustomerId); cmd.Parameters.AddWithValue("@ProductId", mCustomerwish.ProductId); cmd.Parameters.AddWithValue("@CreatedDatetime", mCustomerwish.CreatedDateTime); cmd.Parameters.AddWithValue("@Amount", mCustomerwish.Amount); cmd.ExecuteNonQuery(); sqlconn.Close(); }