Beispiel #1
0
        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();
        }