public bool UpdateUserLanguageDetails(UsersLanguage details)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@userLanguageId", Value = details.UsersLanguageId, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "@user_id", Value = details.User_Id, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "@learning_LanguageId", Value = details.Learning_LanguageId, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "@nativeLanguageId", Value = details.Native_LanguageId, SqlDbType = SqlDbType.BigInt
},
};
object[] parameters = sp.ToArray();
var users = _userLanguageRepository.ExecuteStoredProcedureList <AuthUser>(PROC_UPDATE_USER_LANGUAGE, parameters);
if (users != null)
{
return(true);
}
else
{
return(false);
}
}
public IActionResult SaveLangAccToUserId([FromBody] UsersLanguage model)
{
try
{
//delete record from UserLanguageMapping table
UserLanguageMapping userLanguage = _context.UserLanguageMapping.Find(model.UserId);
_context.UserLanguageMapping.Remove(userLanguage);
_context.SaveChangesAsync();
//insert all value in UserLanguageMapping
int count = model.languageId.Count();
for (int i = 0; i < count; i++)
{
_context.UserLanguageMapping.Add(new UserLanguageMapping
{
UserId = model.UserId,
LanguageId = model.languageId[i]
});
}
_context.SaveChangesAsync();
jsonResponse.IsSuccessful = true;
jsonResponse.Response = "Data saved successfully";
return(Ok(jsonResponse));
}
catch (Exception)
{
jsonResponse.IsSuccessful = true;
jsonResponse.Response = "Exception Occured";
return(BadRequest(jsonResponse));
}
}
public IActionResult SaveLangAccToUserId([FromBody] UsersLanguage model)
{
try
{
//delete record from UserLanguageMapping table
List <UserLanguageMapping> userLanguage = _CLRCP_MASTERContext.UserLanguageMapping.Where(x => x.UserId == model.UserId).ToList();
if (userLanguage.Count > 0)
{
_CLRCP_MASTERContext.UserLanguageMapping.RemoveRange(userLanguage);
_CLRCP_MASTERContext.SaveChanges();
}
//List<UserLanguageMapping> userLanguage = _context.UserLanguageMapping.Where(x => x.UserId == model.UserId).ToList();
//foreach (int lang in model.languageId)
//{
// if (!userLanguage.Contains(new UserLanguageMapping { UserId = model.UserId, LanguageId = lang }))
// {
// userLanguage.Add(new UserLanguageMapping
// {
// UserId = model.UserId,
// LanguageId = lang
// });
// }
//}
//if (userLanguage.Count > 0)
//{
// _context.UserLanguageMapping.UpdateRange(userLanguage);
// var obj = _context.SaveChanges();
//}
//insert all value in UserLanguageMapping
int count = model.languageId.Count();
for (int i = 0; i < count; i++)
{
_CLRCP_MASTERContext.UserLanguageMapping.Add(new UserLanguageMapping
{
UserId = model.UserId,
LanguageId = model.languageId[i]
});
}
_CLRCP_MASTERContext.SaveChanges();
jsonResponse.IsSuccessful = true;
jsonResponse.Response = "Data saved successfully";
return(Ok(jsonResponse));
}
catch (Exception)
{
jsonResponse.IsSuccessful = true;
jsonResponse.Response = "Exception Occured";
return(BadRequest(jsonResponse));
}
}
public IActionResult GetLangUserWise(int UserId)
{
try
{
UsersLanguage usersLanguage = new UsersLanguage();
List <UserLanguageMapping> list = _context.UserLanguageMapping.Where(e => e.UserId == UserId).ToList();
usersLanguage.UserId = UserId;
usersLanguage.languageId = list.Select(x => x.LanguageId).ToList();
return(Ok(usersLanguage));
}
catch (Exception)
{
return(BadRequest(jsonResponse.Response = "Internal Exception"));
}
}
public IHttpActionResult ExternalAuthRegister(RegisterModel model)
{
ResponseModel obj = new ResponseModel();
string errorMessage = string.Empty;
HttpResponseMessage response = new HttpResponseMessage();
try
{
if (!ModelState.IsValid)
{
errorMessage = String.Join(",", ErrorHelper.GetErrorListFromModelState(ModelState));
return(BadRequest(errorMessage));
}
if (string.IsNullOrEmpty(model.ExternalAuthType))
{
return(BadRequest("External Auth Type is required."));
}
if (string.IsNullOrEmpty(model.ExternalAuthUserId))
{
return(BadRequest("External Auth User Id is required."));
}
bool isEmail = ValidateEmail(model.Email);
if (isEmail == false)
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Please give a valid email id.")));
}
var userDetailsByEmail = _userService.GetUserDetailsByEmail(model.Email);
if (userDetailsByEmail == null)
{
}
else
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "This email is already taken.")));
}
var trevoId = PasswordAndTrevoHelper.GenerateTrevoId(model.Name);
TrevoUsers user = new TrevoUsers();
user.Address = model.Address == null ? string.Empty : model.Address;
user.Country_Id = model.CountryId;
user.DeviceId = model.DeviceId;
user.Dob = model.Dob;
user.Email_Id = model.Email;
user.Gender = model.Gender;
//user.UsersLanguageId = model.Id;
user.Interests = model.Interests == null ? string.Empty : model.Interests;
user.LagLevel_ID = model.LanguageLevelId;
user.Name = model.Name;
user.Password = string.Empty;
user.PasswordHash = string.Empty;
user.QR_Code = string.Empty;
user.Self_Introduction = model.SelfIntroduction == null ? string.Empty : model.SelfIntroduction;
user.TravelDestination_CId = model.TravelDestination == null ? string.Empty : model.TravelDestination;
user.TrevoId = trevoId;
user.IsVerified = 0;
user.ImagePath = string.Empty;
user.CreatedTime = DateTime.UtcNow;
user.ExternalAuthType = model.ExternalAuthType;
user.ExternalAuthUserId = model.ExternalAuthUserId;
//_userService.InsertUserDetails(user);
//insert the user language first
var isSuccess = _userService.InsertUserDetails(user);
if (isSuccess.IsSuccess)
{
UsersLanguage userLanguage = new UsersLanguage();
userLanguage.User_Id = Convert.ToInt64(isSuccess.Message);
obj.UserID = userLanguage.User_Id;
userLanguage.Learning_LanguageId = model.LearningLanguageId;
userLanguage.Native_LanguageId = model.NativeLanguageId;
_userLanguageService.InsertUserLanguageDetails(userLanguage);
}
else
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "There is some error.")));
}
//send mail after successfull registration
StreamReader reader = new StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/EmailTemplate/RegistrationActivation.html"));
string readFile = reader.ReadToEnd();
string mailBody = "";
mailBody = readFile;
mailBody = mailBody.Replace("$$UserName$$", model.Name);
string otpCode = PasswordAndTrevoHelper.CreateRandomNumber(5);
string encryptedUserName = SSTCryptographer.Encrypt(model.Name, SSTCryptographer.Key = "Activation");
mailBody = mailBody.Replace(" $$OTPCode$$", otpCode);
ReturnMsg mailResult = SendMail.SendEmail(InfoMail, model.Email, "Account Activation", mailBody);
obj.Email = model.Email;
obj.Name = model.Name;
}
catch (System.Exception e)
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e.Message)));
}
return(Ok(obj));
}
