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; } }
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)); } }
public Response <int> MarkFavorite(CoFavorite item) { return(_miscRepositoryDAC.MarkFavorite(item)); }