public ReturnMsg UpdateTransliterationByUserId(UserTransliterationDetails details) { ReturnMsg msg = new ReturnMsg(); try { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@user_Id", Value = details.User_Id, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@ttsCount", Value = details.TTSCount, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@translateCount", Value = details.TranslateCount, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@spellCheckCount", Value = details.SpellCheckCount, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@transliterationId", Value = details.TransliterationId, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@favCount", Value = details.FavouritesCount, SqlDbType = SqlDbType.BigInt }, }; object[] parameters = sp.ToArray(); _transliterationRepository.ExecuteStoredProcedure(PROC_UPDATE_TRANSLITERATION_DETAILS, parameters); msg.IsSuccess = true; } catch (Exception e) { msg.IsSuccess = false; msg.Message = e.Message; } return(msg); }
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.")); }
public bool InsertTransliterationDetails(UserTransliterationDetails details) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@user_Id", Value = details.User_Id, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@ttsCount", Value = details.TTSCount, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@translateCount", Value = details.TranslateCount, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@spellCheckCount", Value = details.SpellCheckCount, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@favCount", Value = details.FavouritesCount, SqlDbType = SqlDbType.BigInt }, }; object[] parameters = sp.ToArray(); var users = _transliterationRepository.ExecuteStoredProcedureList <AuthUser>(PROC_INSERT_TRANSLITERATION_DETAILS, parameters); if (users != null) { return(true); } else { return(false); } }
public IHttpActionResult InsertUserTransliterationDetails(TransliterationModel model) { try { if (!ModelState.IsValid) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "User Id is required."))); } UserTransliterationDetails details = _transliterationService.GetTransliterationDetailsByUserId(model.User_Id); //TransliterationDetails transDetails = new TransliterationDetails(); if (details != null) { if (model.IsSpellCheck == 1) { details.SpellCheckCount = details.SpellCheckCount + 1; // transDetails.IsSpellCheck = 1; } else if (model.IsTranslate == 1) { details.TranslateCount = details.TranslateCount + 1; //transDetails.IsTranslate = 1; } else if (model.IsTTS == 1) { details.TTSCount = details.TTSCount + 1; //transDetails.IsTTS = 1; } else { details.FavouritesCount = details.FavouritesCount + 1; //transDetails.IsFavourite = 1; //transDetails.IsMoment = 0; } ReturnMsg obj = _transliterationService.UpdateTransliterationByUserId(details); if (!obj.IsSuccess) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "There is some error."))); } else { //transDetails.Details = model.Details; //transDetails.User_Id = model.User_Id; //_transService.InsertTransliteration(transDetails); } } else { details = new UserTransliterationDetails(); if (model.IsSpellCheck == 1) { details.SpellCheckCount = 1; // transDetails.IsSpellCheck = 1; } else if (model.IsTranslate == 1) { details.TranslateCount = 1; //transDetails.IsTranslate = 1; } else if (model.IsTTS == 1) { details.TTSCount = 1; //transDetails.IsTTS = 1; } else { details.FavouritesCount = 1; //transDetails.IsFavourite = 1; // transDetails.IsMoment = 0; } //transDetails.Details = model.Details; // transDetails.User_Id = model.User_Id; details.User_Id = model.User_Id; _transliterationService.InsertTransliterationDetails(details); // _transService.InsertTransliteration(transDetails); } } catch (Exception e) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e.Message))); } return(Ok("Details inserted successfully.")); }
public IHttpActionResult GetUserDetailsById(RequestModel model) { UserWithCountryIconInfo userDetails = new UserWithCountryIconInfo(); try { List <HobbiesDetails> hobbiesList = new List <HobbiesDetails>(); hobbiesList = _hobbiesService.GetAllHobbies(); if (string.IsNullOrEmpty(model.Id)) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.Forbidden, "User Id is required."))); } long userId = Convert.ToInt64(model.Id); var details = _UserService.GetUserDetailsById(userId); if (details != null) { userDetails.Address = details.Address; userDetails.Country_Id = details.Country_Id; userDetails.CreatedTime = details.CreatedTime; userDetails.DeviceId = details.DeviceId; userDetails.Dob = details.Dob; userDetails.Email_Id = details.Email_Id; var countryDetails = _countryService.GetCountryDetailsById(details.Country_Id); if (countryDetails != null) { userDetails.Flag_Icon = countryDetails.Flag_Icon; } userDetails.Gender = details.Gender; userDetails.Icon_Path = imagePath + countryDetails.Flag_Icon; } //userDetails.ImagePath = details.ImagePath == null ? noImagePath : details.ImagePath == string.Empty ? noImagePath : proImagePath + details.ImagePath; if (string.IsNullOrEmpty(details.ImagePath)) { userDetails.ImagePath = noImagePath; } else { var extension = details.ImagePath.Split('.')[1]; var imageName = details.ImagePath.Split('.')[0] + "_thumbnail"; userDetails.ImagePath = proImagePath + imageName + "." + extension; } userDetails.Interests = details.Interests; userDetails.IsVerified = details.IsVerified; userDetails.LagLevel_ID = details.LagLevel_ID; var userLangDetails = _userLangService.GetLanguageListByUserId(details.User_Id); if (userLangDetails != null) { var langDetails = _languageService.GetLanguageDetailsById(userLangDetails.Native_LanguageId); userDetails.Native_LanguageId = userLangDetails.Native_LanguageId; if (langDetails != null) { userDetails.NativeAbbrv = langDetails.Abbreviation; } langDetails = _languageService.GetLanguageDetailsById(userLangDetails.Learning_LanguageId); userDetails.Learning_LanguageId = userLangDetails.Learning_LanguageId; if (langDetails != null) { userDetails.LearningAbbrv = langDetails.Abbreviation; } } userDetails.Name = details.Name; userDetails.Self_Introduction = details.Self_Introduction; userDetails.TravelDestination_CId = details.TravelDestination_CId; userDetails.TrevoId = details.TrevoId; userDetails.User_Id = details.User_Id; var userHobbies = _hobbiesService.GetUserHobbiesByUserId(details.User_Id); foreach (var item in userHobbies) { if (string.IsNullOrEmpty(userDetails.UserHobbies)) { userDetails.UserHobbies = hobbiesList.Where(a => a.HobbiesId == item.HobbiesId).FirstOrDefault().Name; } else { userDetails.UserHobbies = userDetails.UserHobbies + " ," + hobbiesList.Where(a => a.HobbiesId == item.HobbiesId).FirstOrDefault().Name; } } UserTransliterationDetails transliterationDetails = _transliterationService.GetTransliterationDetailsByUserId(userDetails.User_Id); if (transliterationDetails != null) { userDetails.FavCount = transliterationDetails.FavouritesCount; userDetails.TTSCount = transliterationDetails.TTSCount; userDetails.SpellCheckCount = transliterationDetails.SpellCheckCount; userDetails.TranslateCount = transliterationDetails.TranslateCount; } } catch (Exception e) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e.Message))); } return(Ok(userDetails)); }