コード例 #1
0
        public Response <int> MarkFavorite(CoFavorite item)
        {
            try
            {
                DynamicParameters _params = new DynamicParameters();
                _params.Add("@fav_key", item.fav_key, DbType.Guid);
                _params.Add("@fav_org_key", item.fav_org_key, DbType.Guid);
                _params.Add("@fav_prd_key", item.fav_prd_key, DbType.Guid);
                _params.Add("@fav_rfp_key", item.fav_rfp_key, DbType.Guid);
                _params.Add("@fav_add_user", item.fav_add_user, DbType.String);
                _params.Add("@is_favorite", item.is_favorite ? 1 : 0, DbType.Int16);
                _params.Add("@success", DbType.Boolean, direction: ParameterDirection.Output);

                var result = _dBConnection.Execute("USP_Co_Favorite_Set", _params, null, null, CommandType.StoredProcedure);

                return(new Response <int>(result)
                {
                    Success = _params.Get <Int32>("success") == 1 ? true : false
                });
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
        public ActionResult AddToFavorite(string key, string type, bool status)
        {
            var response = new AppResponseModel <int>();

            try
            {
                if (type == "rfp" || type == "prd")
                {
                    CoFavorite entity = new CoFavorite
                    {
                        is_favorite  = status,
                        fav_org_key  = CurrentUser.User.org_key,
                        fav_add_date = DateTime.Now,
                        fav_key      = Guid.NewGuid(),
                        fav_add_user = CurrentUser.User.ct_key.ToString()
                    };

                    if (type == "prd")
                    {
                        entity.fav_prd_key = Guid.Parse(key);
                    }
                    else
                    {
                        entity.fav_prd_key = null;
                    }

                    if (type == "rfp")
                    {
                        entity.fav_rfp_key = Guid.Parse(key);
                    }
                    else
                    {
                        entity.fav_rfp_key = null;
                    }

                    var resp = _miscFacade.MarkFavorite(entity);

                    if (resp.Success)
                    {
                        response.IsSuccess = true;
                        response.Message   = Messages.Updated;
                        return(Json(response, JsonRequestBehavior.AllowGet));
                    }
                }

                response.IsSuccess = true;
                response.Message   = Messages.NoUpdate;
                return(Json(response, JsonRequestBehavior.AllowGet));
            }
            catch
            {
                response.IsSuccess = false;
                response.Message   = Messages.ServerError;
                return(Json(response, JsonRequestBehavior.AllowGet));
            }
        }
コード例 #3
0
 public Response <int> MarkFavorite(CoFavorite item)
 {
     return(_miscRepositoryDAC.MarkFavorite(item));
 }