public bool InsertFavourites(FavouritesDetails details) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@message", Value = details.Message, SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@favouriteUserId", Value = details.FavouriteUserId, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@isSender", Value = details.IsSender, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@senderRecieverId", Value = details.SenderRecieverId, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@momentId", Value = details.MomentId, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@addedDate", Value = details.AddedDate, SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@localMessageId", Value = details.LocalMessageId, SqlDbType = SqlDbType.Int }, }; object[] parameters = sp.ToArray(); var users = _favRepository.ExecuteStoredProcedureList <AuthUser>(PROC_INSERT_FAVOURITES, parameters); if (users != null) { return(true); } else { return(false); } }
public IHttpActionResult InsertFavouriteDetails(FavouritesModel model) { try { if (!ModelState.IsValid) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.Forbidden, "Sender Id and Reciever Id are required."))); } FavouritesDetails details = new FavouritesDetails(); details.FavouriteUserId = model.FavouriteUserId; details.IsSender = model.IsSender; details.Message = model.Message; details.MomentId = model.MomentId; details.SenderRecieverId = model.SenderRecieverId; details.LocalMessageId = model.LocalMessageId; var dateTime = DateTime.UtcNow; details.AddedDate = dateTime.ToString(@"yyyy/MM/dd hh:mm tt", new CultureInfo("en-US")); _favService.InsertFavourites(details); UserTransliterationDetails transliterationDetails = _transliterationService.GetTransliterationDetailsByUserId(details.FavouriteUserId); //TransliterationDetails transDetails = new TransliterationDetails(); if (transliterationDetails != null) { transliterationDetails.FavouritesCount = transliterationDetails.FavouritesCount + 1; ReturnMsg obj = _transliterationService.UpdateTransliterationByUserId(transliterationDetails); } else { transliterationDetails = new UserTransliterationDetails(); transliterationDetails.FavouritesCount = 1; transliterationDetails.User_Id = model.FavouriteUserId; _transliterationService.InsertTransliterationDetails(transliterationDetails); } //transDetails.IsFavourite = 1; } catch (Exception e) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e.Message))); } return(Ok("Favourites details inserted successfully.")); }