public static int GenerateNewUniqueSalt(LearnLanguagesContext context)
{
var salt = -1;
bool saltAlreadyExists = true;
Random r = new Random(DateTime.Now.Millisecond * DateTime.Now.Minute * DateTime.Now.Month);
int maxSaltTries = int.Parse(DalResources.MaxTriesGenerateSalt);
int tries = 0;
do
{
salt = r.Next(int.Parse(DataAccess.DalResources.MaxSaltValue));
saltAlreadyExists = (from userData in context.UserDatas
where userData.Salt == salt
select userData).Count() > 0;
tries++;
if (tries > maxSaltTries)
{
throw new DataAccess.Exceptions.GeneralDataAccessException("MaxTries for generating salt reached.");
}
} while (saltAlreadyExists);
return(salt);
}
public static void LoadDataFromDto(ref StudyDataData data,
StudyDataDto dto,
LearnLanguagesContext context)
{
data.NativeLanguageText = dto.NativeLanguageText;
data.Username = dto.Username;
}
/// <summary>
/// Loads the information from the dto into the data object. Except...
/// Does NOT load dto.Id.
/// </summary>
/// <param name="data"></param>
/// <param name="dto"></param>
public static void LoadDataFromDto(ref TranslationData data,
TranslationDto dto,
LearnLanguagesContext context)
{
//COPY USER INFO
data.UserDataId = dto.UserId;
data.UserData = EfHelper.GetUserData(dto.UserId, context);
var currentPhraseIds = (from phrase in data.PhraseDatas
select phrase.Id);
//COPY PHRASEID INFO
//ADD NEW PHRASEDATAS IN THE DTO
foreach (var id in dto.PhraseIds)
{
if (!currentPhraseIds.Contains(id))
{
PhraseData phraseData = EfHelper.GetPhraseData(id, context);
data.PhraseDatas.Add(phraseData);
}
}
//REMOVE PHRASEDATAS THAT ARE NOT IN DTO ANYMORE
foreach (var phraseId in currentPhraseIds)
{
if (!dto.PhraseIds.Contains(phraseId))
{
var dataToRemove = (from phraseData in data.PhraseDatas
where phraseData.Id == phraseId
select phraseData).First();
data.PhraseDatas.Remove(dataToRemove);
}
}
}
/// <summary>
/// Adds the TranslationDto to the context, loading UserData and PhraseDatas into the newly
/// created PhraseData. Does NOT save changes to the context.
/// </summary>
/// <param name="dto"></param>
/// <param name="learnLanguagesContext"></param>
/// <returns></returns>
public static TranslationData AddToContext(TranslationDto dto, LearnLanguagesContext context)
{
//CREATE NEW TRANSLATIONDATA
var newTranslationData = context.TranslationDatas.CreateObject();
//ASSIGN USER INFO
newTranslationData.UserDataId = dto.UserId;
//var userResults = (from user in context.UserDatas
// where user.Id == dto.UserId
// select user);
//if (userResults.Count() == 1)
// newTranslationData.UserData = userResults.First();
//else if (userResults.Count() == 0)
// throw new Exceptions.IdNotFoundException(dto.UserId);
//else
//{
// var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
// DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
// throw new Exceptions.VeryBadException(errorMsg);
//}
//GET AND ADD PHRASEDATAS TO TRANSLATIONDATA
if (dto.PhraseIds != null)
{
foreach (var id in dto.PhraseIds)
{
var results = (from phrase in context.PhraseDatas
where phrase.Id == id
select phrase);
if (results.Count() == 1)
{
var phraseData = results.First();
newTranslationData.PhraseDatas.Add(phraseData);
}
else if (results.Count() == 0)
{
throw new Exceptions.IdNotFoundException(id);
}
else
{
var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
throw new Exceptions.VeryBadException(errorMsg);
}
}
}
//ADD TRANSLATIONDATA TO CONTEXT
context.TranslationDatas.AddObject(newTranslationData);
return(newTranslationData);
}
public static void LoadDataFromDto(ref LineData data,
LineDto dto,
LearnLanguagesContext context)
{
//USER INFO
data.UserDataId = dto.UserId;
data.UserData = EfHelper.GetUserData(dto.UserId, context);
//PHRASE INFO
data.PhraseDataId = dto.PhraseId;
data.PhraseData = EfHelper.GetPhraseData(dto.PhraseId, context);
//TEXT
data.LineNumber = dto.LineNumber;
}
/// <summary>
/// Adds the StudyDataDto to the context, loading UserData and PhraseDatas into the newly
/// created PhraseData. Does NOT save changes to the context.
/// </summary>
public static StudyDataData AddToContext(StudyDataDto dto, LearnLanguagesContext context)
{
//CREATE THE NEW OBJECT
var newStudyDataData = context.StudyDataDatas.CreateObject();
//ASSIGN PROPERTIES
newStudyDataData.NativeLanguageText = dto.NativeLanguageText;
newStudyDataData.Username = dto.Username;
//ADD OBJECT TO CONTEXT
context.StudyDataDatas.AddObject(newStudyDataData);
//RETURN OBJECT
return(newStudyDataData);
}
/// <summary>
/// Loads the information from the dto into the data object. Except...
/// Does NOT load dto.Id.
/// </summary>
/// <param name="data"></param>
/// <param name="dto"></param>
public static void LoadDataFromDto(ref LanguageData data,
LanguageDto dto,
LearnLanguagesContext context)
{
//USER INFO
data.UserDataId = dto.UserId;
data.UserData = EfHelper.GetUserData(dto.UserId, context);
//MAKE SURE USERDATA USERNAME MATCHES DTO.USERNAME
if (data.UserData.Username != dto.Username)
{
throw new Exceptions.UsernameAndUserIdDoNotMatchException(dto.Username, dto.UserId);
}
//TEXT
data.Text = dto.Text;
}
//public static UserData ToData(UserDto dto, bool includeForeignEntities = true)
//{
// var retUserData = new UserData()
// {
// Id = dto.Id,
// Username = dto.Username,
// Salt = dto.Salt,
// SaltedHashedPasswordValue = dto.SaltedHashedPasswordValue
// };
// if (includeForeignEntities)
// {
// using (var dalManager = DalFactory.GetDalManager())
// {
// //USER PHRASES
// var phraseDal = dalManager.GetProvider<IPhraseDal>();
// foreach (var phraseId in dto.PhraseIds)
// {
// var result = phraseDal.Fetch(phraseId);
// if (!result.IsSuccess || result.IsError)
// throw new Exceptions.FetchFailedException(result.Msg);
// //var phraseData = ToData(result.Obj);
// //retUserData.PhraseDatas.Add(phraseData);
// var phraseData = EfHelper.AddToContext(result.Obj, retUserData.
// }
// //USER ROLES
// var customIdentityDal = dalManager.GetProvider<IUserIdentityDal>();
// foreach (var roleId in dto.RoleIds)
// {
// var result = customIdentityDal.GetRoles(dto.Username);
// if (!result.IsSuccess || result.IsError)
// throw new Exceptions.FetchFailedException(result.Msg);
// var roleDtos = result.Obj;
// foreach (var roleDto in roleDtos)
// {
// RoleData roleData = new RoleData()
// {
// Id = roleDto.Id,
// Text = roleDto.Text
// };
// retUserData.RoleDatas.Add(roleData);
// }
// }
// }
// }
// return retUserData;
//}
#region AddToContext
/// <summary>
/// Adds the phraseDto to the context, loading UserData and LanguageData into the newly
/// created PhraseData. Does NOT save changes to the context.
/// </summary>
public static PhraseData AddToContext(PhraseDto dto, LearnLanguagesContext context)
{
//only creates, does not add to phrasedatas
//var beforeCount = context.PhraseDatas.Count();
var newPhraseData = context.PhraseDatas.CreateObject();
//var afterCount = context.PhraseDatas.Count();
//assign properties
newPhraseData.Text = dto.Text;
newPhraseData.LanguageDataId = dto.LanguageId;
newPhraseData.UserDataId = dto.UserId;
context.PhraseDatas.AddObject(newPhraseData);
return(newPhraseData);
}
/// <summary>
/// Loads the information from the dto into the data object. Except...
/// Does NOT load dto.Id.
/// </summary>
/// <param name="data"></param>
/// <param name="dto"></param>
public static void LoadDataFromDto(ref PhraseData data,
PhraseDto dto,
LearnLanguagesContext context)
{
//USER INFO
data.UserDataId = dto.UserId;
data.UserData = EfHelper.GetUserData(dto.UserId, context);
//LANGUAGE INFO
data.LanguageDataId = dto.LanguageId;
data.LanguageData = EfHelper.GetLanguageData(dto.LanguageId, context);
//TEXT
data.Text = dto.Text;
//TRANSLATIONDATAS
data.TranslationDatas.Load();
}
/// <summary>
/// Adds the lineDto to the context, loading UserData and PhraseData into the newly
/// created LineData. Does NOT save changes to the context.
/// </summary>
public static LineData AddToContext(LineDto dto, LearnLanguagesContext context)
{
//only creates, does not add to linedatas
//var beforeCount = context.LineDatas.Count();
var newLineData = context.LineDatas.CreateObject();
//var afterCount = context.LineDatas.Count();
//assign properties
newLineData.LineNumber = dto.LineNumber;
newLineData.PhraseDataId = dto.PhraseId;
newLineData.UserDataId = dto.UserId;
context.LineDatas.AddObject(newLineData);
return(newLineData);
}
public static void LoadDataFromDto(ref PhraseBeliefData data,
PhraseBeliefDto dto,
LearnLanguagesContext context)
{
//USER INFO
data.UserDataId = dto.UserId;
data.UserData = EfHelper.GetUserData(dto.UserId, context);
//PHRASE
data.PhraseDataId = dto.PhraseId;
data.PhraseData = EfHelper.GetPhraseData(dto.PhraseId, context);
//SCALAR
data.ReviewMethodId = dto.ReviewMethodId;
data.Strength = dto.Strength;
data.Text = dto.Text;
data.TimeStamp = dto.TimeStamp;
}
/// <summary>
/// Adds the dto to the context, loading UserData and LineDatas into the newly
/// created PhraseBeliefData. Does NOT save changes to the context.
/// </summary>
public static MultiLineTextData AddToContext(MultiLineTextDto dto, LearnLanguagesContext context)
{
//CREATE NEW TRANSLATIONDATA
var data = context.MultiLineTextDatas.CreateObject();
//SCALARS
data.Title = dto.Title;
data.AdditionalMetadata = dto.AdditionalMetadata;
//ASSIGN USER INFO
data.UserDataId = dto.UserId;
//ADD LINE DATAS FROM DTO.LINEIDS
if (dto.LineIds != null)
{
foreach (var id in dto.LineIds)
{
var results = (from line in context.LineDatas
where line.Id == id
select line);
if (results.Count() == 1)
{
var lineData = results.First();
data.LineDatas.Add(lineData);
}
else if (results.Count() == 0)
{
throw new Exceptions.IdNotFoundException(id);
}
else
{
var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
throw new Exceptions.VeryBadException(errorMsg);
}
}
}
//ADD DATA TO CONTEXT
context.MultiLineTextDatas.AddObject(data);
return(data);
}
public static void LoadDataFromDto(ref MultiLineTextData data,
MultiLineTextDto dto,
LearnLanguagesContext context)
{
//USER INFO
data.UserDataId = dto.UserId;
data.UserData = EfHelper.GetUserData(dto.UserId, context);
//LINE IDS
foreach (var id in dto.LineIds)
{
LineData lineData = EfHelper.GetLineData(id, context);
data.LineDatas.Add(lineData);
}
//SCALAR
data.Title = dto.Title;
data.AdditionalMetadata = dto.AdditionalMetadata;
}
/// <summary>
/// Adds the PhraseBeliefDto to the context, loading UserData and PhraseDatas into the newly
/// created PhraseBeliefData. Does NOT save changes to the context.
/// </summary>
public static PhraseBeliefData AddToContext(PhraseBeliefDto dto, LearnLanguagesContext context)
{
//CREATE THE NEW OBJECT
var data = context.PhraseBeliefDatas.CreateObject();
//ASSIGN PROPERTIES
data.PhraseDataId = dto.PhraseId;
data.ReviewMethodId = dto.ReviewMethodId;
data.Strength = dto.Strength;
data.BelieverId = dto.BelieverId;
data.Text = dto.Text;
data.TimeStamp = dto.TimeStamp;
data.UserDataId = dto.UserId;
//ADD OBJECT TO CONTEXT
context.PhraseBeliefDatas.AddObject(data);
//RETURN OBJECT
return(data);
}
public static LanguageData ToData(LanguageDto dto, LearnLanguagesContext context)
{
//CREATE DATA OBJECT
var languageData = context.LanguageDatas.CreateObject();
//ASSIGN SIMPLE PROPERTIES
languageData.Id = dto.Id;
languageData.Text = dto.Text;
languageData.UserDataId = dto.UserId;
//POPULATE USERDATA
var results = (from u in context.UserDatas
where u.Id == dto.UserId
select u);
if (results.Count() == 1)
{
var userData = results.First();
//MAKE SURE USERNAMES MATCH
if (userData.Username != dto.Username)
{
throw new ArgumentException("languageDto dto");
}
languageData.UserData = results.First();
}
else if (results.Count() == 0)
{
throw new Exceptions.UsernameAndUserIdDoNotMatchException(dto.Username, dto.UserId);
}
else
{
throw new Exceptions.VeryBadException(
string.Format(DalResources.ErrorMsgVeryBadException,
DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero));
}
//RETURN
return(languageData);
}
public static RoleData GetRoleData(Guid id, LearnLanguagesContext context)
{
//var currentUserId = Business.BusinessHelper.GetCurrentUserId();
var results = from data in context.RoleDatas
where data.Id == id
select data;
if (results.Count() == 1)
{
return(results.First());
}
else if (results.Count() == 0)
{
throw new Exceptions.IdNotFoundException(id);
}
else
{
var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
throw new Exceptions.VeryBadException(errorMsg);
}
}
public static void LoadDataFromDto(ref UserData userData,
UserDto dto,
LearnLanguagesContext context)
{
//SCALAR
userData.Username = dto.Username;
userData.Salt = dto.Salt;
userData.SaltedHashedPasswordValue = dto.SaltedHashedPasswordValue;
//NAVIGATION PROPERTIES
//Guid navPropId = default(Guid);
ICollection <Guid> ids = null;
//LANGUAGES
ids = dto.LanguageIds;
foreach (var id in ids)
{
var data = EfHelper.GetLanguageData(id, context);
userData.LanguageDatas.Add(data);
}
//LINES
ids = dto.LineIds;
foreach (var id in ids)
{
var data = EfHelper.GetLineData(id, context);
userData.LineDatas.Add(data);
}
//MultiLineText
ids = dto.MultiLineTextIds;
foreach (var id in ids)
{
var data = EfHelper.GetMultiLineTextData(id, context);
userData.MultiLineTextDatas.Add(data);
}
//PHRASE BELIEF
ids = dto.PhraseBeliefIds;
foreach (var id in ids)
{
var data = EfHelper.GetPhraseBeliefData(id, context);
userData.PhraseBeliefDatas.Add(data);
}
//PHRASE
ids = dto.PhraseIds;
foreach (var id in ids)
{
var data = EfHelper.GetPhraseData(id, context);
userData.PhraseDatas.Add(data);
}
//ROLE
ids = dto.RoleIds;
foreach (var id in ids)
{
var data = EfHelper.GetRoleData(id, context);
userData.RoleDatas.Add(data);
}
//TRANSLATION
ids = dto.TranslationIds;
foreach (var id in ids)
{
var data = EfHelper.GetTranslationData(id, context);
userData.TranslationDatas.Add(data);
}
}
/// <summary>
/// Adds the dto to the context.
///
/// Does NOT save changes to the context.
/// </summary>
public static UserData AddToContext(UserDto dto, LearnLanguagesContext context)
{
//CREATE NEW DATA
var data = context.UserDatas.CreateObject();
//LOAD DATA
LoadDataFromDto(ref data, dto, context);
#region commented out manual loading (i'm trying to replace this with efhelper method loaddatafromdto())
//#region ASSIGN SCALARS
//data.Username = dto.Username;
//data.Salt = dto.Salt;
//data.SaltedHashedPasswordValue = dto.SaltedHashedPasswordValue;
//#endregion
//#region ASSIGN COLLECTIONS
////ADD LINE DATAS FROM DTO.LINEIDS
//if (dto.LineIds != null)
//{
// foreach (var id in dto.LineIds)
// {
// var results = (from line in context.LineDatas
// where line.Id == id
// select line);
// if (results.Count() == 1)
// {
// var lineData = results.First();
// data.LineDatas.Add(lineData);
// }
// else if (results.Count() == 0)
// throw new Exceptions.IdNotFoundException(id);
// else
// {
// var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
// DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
// throw new Exceptions.VeryBadException(errorMsg);
// }
// }
//}
////ADD PHRASE BELIEF DATAS FROM DTO.PHRASE BELIEF IDS
//if (dto.PhraseBeliefIds != null)
//{
// foreach (var id in dto.PhraseBeliefIds)
// {
// var results = (from belief in context.PhraseBeliefDatas
// where belief.Id == id
// select belief);
// if (results.Count() == 1)
// {
// var beliefData = results.First();
// data.PhraseBeliefDatas.Add(beliefData);
// }
// else if (results.Count() == 0)
// throw new Exceptions.IdNotFoundException(id);
// else
// {
// var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
// DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
// throw new Exceptions.VeryBadException(errorMsg);
// }
// }
//}
////ADD PHRASE DATAS FROM DTO.PHRASE IDS
//if (dto.PhraseIds != null)
//{
// foreach (var id in dto.PhraseIds)
// {
// var results = (from phrase in context.PhraseDatas
// where phrase.Id == id
// select phrase);
// if (results.Count() == 1)
// {
// var phraseData = results.First();
// data.PhraseDatas.Add(phraseData);
// }
// else if (results.Count() == 0)
// throw new Exceptions.IdNotFoundException(id);
// else
// {
// var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
// DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
// throw new Exceptions.VeryBadException(errorMsg);
// }
// }
//}
////ADD ROLE DATAS FROM DTO.ROLE IDS
//if (dto.RoleIds != null)
//{
// foreach (var id in dto.RoleIds)
// {
// var results = (from role in context.RoleDatas
// where role.Id == id
// select role);
// if (results.Count() == 1)
// {
// var roleData = results.First();
// data.RoleDatas.Add(roleData);
// }
// else if (results.Count() == 0)
// throw new Exceptions.IdNotFoundException(id);
// else
// {
// var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
// DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
// throw new Exceptions.VeryBadException(errorMsg);
// }
// }
//}
////ADD TRANSLATION DATAS FROM DTO.TRANSLATION IDS
//if (dto.TranslationIds != null)
//{
// foreach (var id in dto.TranslationIds)
// {
// var results = (from translation in context.TranslationDatas
// where translation.Id == id
// select translation);
// if (results.Count() == 1)
// {
// var translationData = results.First();
// data.TranslationDatas.Add(translationData);
// }
// else if (results.Count() == 0)
// throw new Exceptions.IdNotFoundException(id);
// else
// {
// var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
// DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
// throw new Exceptions.VeryBadException(errorMsg);
// }
// }
//}
////ADD MLT DATAS FROM DTO.MLT IDS
//if (dto.MultiLineTextIds != null)
//{
// foreach (var id in dto.MultiLineTextIds)
// {
// var results = (from mlt in context.MultiLineTextDatas
// where mlt.Id == id
// select mlt);
// if (results.Count() == 1)
// {
// var mltData = results.First();
// data.MultiLineTextDatas.Add(mltData);
// }
// else if (results.Count() == 0)
// throw new Exceptions.IdNotFoundException(id);
// else
// {
// var errorMsg = string.Format(DalResources.ErrorMsgVeryBadException,
// DalResources.ErrorMsgVeryBadExceptionDetail_ResultCountNotOneOrZero);
// throw new Exceptions.VeryBadException(errorMsg);
// }
// }
//}
//#endregion
#endregion
//ADD DATA TO CONTEXT
context.UserDatas.AddObject(data);
return(data);
}
