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));
}
