public async Task <IActionResult> CreateNewWishList(WishListRequest wishList) { try { var user = HttpContext.User; if ((user.HasClaim(u => u.Type == "TokenType")) && (user.HasClaim(u => u.Type == "UserRole"))) { if ((user.Claims.FirstOrDefault(u => u.Type == "TokenType").Value == "login") && (user.Claims.FirstOrDefault(u => u.Type == "UserRole").Value == "User")) { int userID = Convert.ToInt32(user.Claims.FirstOrDefault(u => u.Type == "UserID").Value); var data = await _wishListBusiness.CreateNewWishList(userID, wishList); if (data != null) { success = true; message = "New Wish List Created Successfully"; return(Ok(new { success, message, data })); } else { message = "No Data Provided"; return(NotFound(new { success, message })); } } } message = "You should login first before creating new wish list, Token Invalid!"; return(BadRequest(new { success, message })); } catch (Exception ex) { return(BadRequest(new { ex.Message })); } }
/// <summary> /// Create New Wish List in the database /// </summary> /// <param name="userID">UserID</param> /// <param name="wishList">Wish List Data</param> /// <returns>If data added successfully return Response Data else null or Exception</returns> public async Task <WishListResponse> CreateNewWishList(int userID, WishListRequest wishList) { try { WishListResponse responseData = null; SQLConnection(); using (SqlCommand cmd = new SqlCommand("CreateNewWishList", conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", userID); cmd.Parameters.AddWithValue("@Name", wishList.Name); conn.Open(); SqlDataReader dataReader = await cmd.ExecuteReaderAsync(); while (dataReader.Read()) { responseData = new WishListResponse { WishListID = Convert.ToInt32(dataReader["WishListID"]), Name = dataReader["Name"].ToString() }; } }; return(responseData); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <WishListResponse> CreateNewWishList(int userID, WishListRequest wishList) { try { if (userID <= 0 || wishList == null) { return(null); } else { return(await _wishListRepository.CreateNewWishList(userID, wishList)); } } catch (Exception ex) { throw new Exception(ex.Message); } }