// Fill
public string FillBoxModelLanguageModel(BoxModelLanguage boxModelLanguage, BoxModelLanguageModel boxModelLanguageModel, ContactOK contactOK)
{
try
{
boxModelLanguage.DBCommand = (int)boxModelLanguageModel.DBCommand;
boxModelLanguage.BoxModelID = boxModelLanguageModel.BoxModelID;
boxModelLanguage.Language = (int)boxModelLanguageModel.Language;
boxModelLanguage.ScenarioName = boxModelLanguageModel.ScenarioName;
boxModelLanguage.TranslationStatus = (int)boxModelLanguageModel.TranslationStatus;
boxModelLanguage.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
boxModelLanguage.LastUpdateContactTVItemID = 2;
}
else
{
boxModelLanguage.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("");
}
public void BoxModelLanguageService_GetBoxModelLanguageModelWithBoxModelIDAndLanguageDB_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
BoxModelModel boxModelModelRet = boxModelServiceTest.AddBoxModelModel();
LanguageEnum LangToAdd = LanguageEnum.es;
BoxModelLanguageModel boxModelLanguageModelRet = AddBoxModelLanguageModel(LangToAdd, boxModelModelRet);
BoxModelLanguageModel boxModelLanguageModelRet2 = boxModelLanguageService.GetBoxModelLanguageModelWithBoxModelIDAndLanguageDB(boxModelLanguageModelRet.BoxModelID, LangToAdd);
Assert.AreEqual(boxModelLanguageModelRet.BoxModelID, boxModelLanguageModelRet2.BoxModelID);
Assert.AreEqual(boxModelLanguageModelRet.Language, boxModelLanguageModelRet2.Language);
Assert.AreEqual(LangToAdd, boxModelLanguageModelRet2.Language);
int BoxModelID = 0;
LanguageEnum LangToAdd2 = LangToAdd;
BoxModelLanguageModel boxModelLanguageModelRetError = boxModelLanguageService.GetBoxModelLanguageModelWithBoxModelIDAndLanguageDB(BoxModelID, LangToAdd2);
Assert.AreEqual(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.BoxModelLanguage, ServiceRes.BoxModelID + "," + ServiceRes.Language, BoxModelID + "," + LangToAdd2), boxModelLanguageModelRetError.Error);
BoxModelID = boxModelLanguageModelRet.BoxModelID;
LangToAdd2 = (LanguageEnum)1000; // will cause error
boxModelLanguageModelRetError = boxModelLanguageService.GetBoxModelLanguageModelWithBoxModelIDAndLanguageDB(BoxModelID, LangToAdd2);
Assert.AreEqual(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.BoxModelLanguage, ServiceRes.BoxModelID + "," + ServiceRes.Language, BoxModelID + "," + LangToAdd2), boxModelLanguageModelRetError.Error);
}
}
}
// Check
public string BoxModelLanguageModelOK(BoxModelLanguageModel boxModelLanguageModel)
{
string retStr = FieldCheckNotZeroInt(boxModelLanguageModel.BoxModelID, ServiceRes.BoxModelID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.LanguageOK(boxModelLanguageModel.Language);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(boxModelLanguageModel.ScenarioName, ServiceRes.ScenarioName, 2, 250);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(boxModelLanguageModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public BoxModelLanguageModel GetBoxModelLanguageModelWithBoxModelIDAndLanguageDB(int BoxModelID, LanguageEnum Language)
{
BoxModelLanguageModel boxModelLanguageModel = (from c in db.BoxModelLanguages
where c.BoxModelID == BoxModelID &&
c.Language == (int)Language
select new BoxModelLanguageModel
{
Error = "",
BoxModelLanguageID = c.BoxModelLanguageID,
DBCommand = (DBCommandEnum)c.DBCommand,
BoxModelID = c.BoxModelID,
Language = (LanguageEnum)c.Language,
ScenarioName = c.ScenarioName,
TranslationStatus = (TranslationStatusEnum)c.TranslationStatus,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <BoxModelLanguageModel>();
if (boxModelLanguageModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.BoxModelLanguage, ServiceRes.BoxModelID + "," + ServiceRes.Language, BoxModelID + "," + Language)));
}
return(boxModelLanguageModel);
}
private void FillBoxModelLanguageModelUpdate(BoxModelLanguageModel boxModelLanguageModel)
{
boxModelLanguageModel.ScenarioName = randomService.RandomString("TV Text2", 20);
boxModelLanguageModel.TranslationStatus = TranslationStatusEnum.Translated;
Assert.IsTrue(boxModelLanguageModel.ScenarioName.Length == 20);
Assert.IsTrue(boxModelLanguageModel.TranslationStatus == TranslationStatusEnum.Translated);
}
// Post
public BoxModelLanguageModel PostAddBoxModelLanguageDB(BoxModelLanguageModel boxModelLanguageModel)
{
string retStr = BoxModelLanguageModelOK(boxModelLanguageModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
BoxModelLanguageModel boxModelLanguageModelExist = GetBoxModelLanguageModelWithBoxModelIDAndLanguageDB(boxModelLanguageModel.BoxModelID, boxModelLanguageModel.Language);
if (string.IsNullOrWhiteSpace(boxModelLanguageModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.BoxModelLanguage)));
}
BoxModelLanguage boxModelLanguageNew = new BoxModelLanguage();
retStr = FillBoxModelLanguageModel(boxModelLanguageNew, boxModelLanguageModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.BoxModelLanguages.Add(boxModelLanguageNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("BoxModelLanguages", boxModelLanguageNew.BoxModelLanguageID, LogCommandEnum.Add, boxModelLanguageNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetBoxModelLanguageModelWithBoxModelIDAndLanguageDB(boxModelLanguageNew.BoxModelID, (LanguageEnum)boxModelLanguageNew.Language));
}
public BoxModelLanguageModel PostUpdateBoxModelLanguageDB(BoxModelLanguageModel boxModelLanguageModel)
{
string retStr = BoxModelLanguageModelOK(boxModelLanguageModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
BoxModelLanguage boxModelLanguageToUpdate = GetBoxModelLanguageWithBoxModelIDAndLanguageDB(boxModelLanguageModel.BoxModelID, boxModelLanguageModel.Language);
if (boxModelLanguageToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.BoxModelLanguage)));
}
retStr = FillBoxModelLanguageModel(boxModelLanguageToUpdate, boxModelLanguageModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("BoxModelLanguages", boxModelLanguageToUpdate.BoxModelLanguageID, LogCommandEnum.Change, boxModelLanguageToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetBoxModelLanguageModelWithBoxModelIDAndLanguageDB(boxModelLanguageToUpdate.BoxModelID, (LanguageEnum)boxModelLanguageToUpdate.Language));
}
private BoxModelLanguageModel UpdateBoxModelLanguageModel(BoxModelLanguageModel boxModelLanguageModelRet)
{
FillBoxModelLanguageModelUpdate(boxModelLanguageModelRet);
BoxModelLanguageModel boxModelLanguageModelRet2 = boxModelLanguageService.PostUpdateBoxModelLanguageDB(boxModelLanguageModelRet);
if (!string.IsNullOrWhiteSpace(boxModelLanguageModelRet2.Error))
{
return(boxModelLanguageModelRet2);
}
Assert.IsNotNull(boxModelLanguageModelRet2);
CompareBoxModelLanguageModels(boxModelLanguageModelRet, boxModelLanguageModelRet2);
return(boxModelLanguageModelRet2);
}
public void SetupTest(ContactModel contactModelToDo, CultureInfo culture)
{
Thread.CurrentThread.CurrentCulture = culture;
Thread.CurrentThread.CurrentUICulture = culture;
contactModel = contactModelToDo;
user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
boxModelService = new BoxModelService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
boxModelLanguageService = new BoxModelLanguageService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, TableName, Plurial);
randomService = new RandomService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
boxModelLanguageModelNew = new BoxModelLanguageModel();
boxModelLanguage = new BoxModelLanguage();
boxModelServiceTest = new BoxModelServiceTest();
boxModelServiceTest.SetupTest(contactModelToDo, culture);
}
private BoxModelLanguageModel AddBoxModelLanguageModel(LanguageEnum LangToAdd, BoxModelModel boxModelModel)
{
BoxModelLanguageModel boxModelLanguageModelNew = new BoxModelLanguageModel();
FillBoxModelLanguageModelNew(LangToAdd, boxModelModel, boxModelLanguageModelNew);
BoxModelLanguageModel boxModelLanguagModelRet = boxModelLanguageService.PostAddBoxModelLanguageDB(boxModelLanguageModelNew);
if (!string.IsNullOrWhiteSpace(boxModelLanguagModelRet.Error))
{
return(boxModelLanguagModelRet);
}
Assert.IsNotNull(boxModelLanguagModelRet);
CompareBoxModelLanguageModels(boxModelLanguageModelNew, boxModelLanguagModelRet);
return(boxModelLanguagModelRet);
}
public void BoxModelLanguageService_GetBoxModelModelCountDB_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
BoxModelModel boxModelModelRet = boxModelServiceTest.AddBoxModelModel();
LanguageEnum LangToAdd = LanguageEnum.es;
BoxModelLanguageModel boxModelModelLanguageRet = AddBoxModelLanguageModel(LangToAdd, boxModelModelRet);
int boxModelCount = boxModelLanguageService.GetBoxModelLanguageModelCountDB();
Assert.AreEqual(testDBService.Count + 3, boxModelCount);
}
}
}
public void BoxModelLanguageService_PostAddBoxModelLanguageDB_UserEmailNotValidated_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
BoxModelModel boxModelModelRet = boxModelServiceTest.AddBoxModelModel();
LanguageEnum LangToAdd = LanguageEnum.es;
ContactModel contactModelBad = contactModelListGood[2];
IPrincipal userBad = new GenericPrincipal(new GenericIdentity(contactModelBad.LoginEmail, "Forms"), null);
boxModelLanguageService = new BoxModelLanguageService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), userBad);
BoxModelLanguageModel boxModelLanguageModelRet = AddBoxModelLanguageModel(LangToAdd, boxModelModelRet);
Assert.AreEqual(ServiceRes.EmailRequiresValidation, boxModelLanguageModelRet.Error);
}
}
}
public void BoxModelLanguageService_GetBoxModelLanguageWithBoxModelIDAndLanguageDB_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
BoxModelModel boxModelModelRet = boxModelServiceTest.AddBoxModelModel();
LanguageEnum LangToAdd = LanguageEnum.es;
BoxModelLanguageModel boxModelLanguageModelRet = AddBoxModelLanguageModel(LangToAdd, boxModelModelRet);
BoxModelLanguage boxModelLanguageRet2 = boxModelLanguageService.GetBoxModelLanguageWithBoxModelIDAndLanguageDB(boxModelLanguageModelRet.BoxModelID, LangToAdd);
Assert.AreEqual(boxModelLanguageModelRet.BoxModelID, boxModelLanguageRet2.BoxModelID);
Assert.AreEqual(boxModelLanguageModelRet.Language, (LanguageEnum)boxModelLanguageRet2.Language);
Assert.AreEqual(LangToAdd, (LanguageEnum)boxModelLanguageRet2.Language);
}
}
}
public void BoxModelLanguageService_PostAddBoxModelLanguageDB_Good_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
BoxModelModel boxModelModelRet = boxModelServiceTest.AddBoxModelModel();
LanguageEnum LangToAdd = LanguageEnum.es;
BoxModelLanguageModel boxModelLanguageModelRet = AddBoxModelLanguageModel(LangToAdd, boxModelModelRet);
BoxModelLanguageModel boxModelLanguageModelRet2 = UpdateBoxModelLanguageModel(boxModelLanguageModelRet);
BoxModelLanguageModel boxModelLanguageModelRet3 = boxModelLanguageService.PostDeleteBoxModelLanguageDB(boxModelLanguageModelRet2.BoxModelID, LangToAdd);
Assert.AreEqual("", boxModelLanguageModelRet3.Error);
}
}
}
private void CompareBoxModelLanguageModels(BoxModelLanguageModel boxModelLanguageModelNew, BoxModelLanguageModel boxModelLanguageModelRet)
{
Assert.AreEqual(boxModelLanguageModelNew.Language, boxModelLanguageModelRet.Language);
Assert.AreEqual(boxModelLanguageModelNew.ScenarioName, boxModelLanguageModelRet.ScenarioName);
}
public BoxModelModel PostUpdateBoxModelDB(BoxModelModel boxModelModel)
{
string retStr = BoxModelModelOK(boxModelModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
BoxModel boxModelToUpdate = GetBoxModelWithBoxModelIDDB(boxModelModel.BoxModelID);
if (boxModelToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.BoxModel)));
}
retStr = FillBoxModel(boxModelToUpdate, boxModelModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("BoxModels", boxModelToUpdate.BoxModelID, LogCommandEnum.Change, boxModelToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
BoxModelLanguageModel boxModelLanguageModel = new BoxModelLanguageModel()
{
DBCommand = DBCommandEnum.Original,
BoxModelID = boxModelModel.BoxModelID,
Language = Lang,
ScenarioName = boxModelModel.ScenarioName,
TranslationStatus = (Lang == LanguageRequest ? TranslationStatusEnum.Translated : TranslationStatusEnum.NotTranslated),
};
BoxModelLanguageModel boxModelLanguageModelRet = _BoxModelLanguageService.PostUpdateBoxModelLanguageDB(boxModelLanguageModel);
if (!string.IsNullOrEmpty(boxModelLanguageModelRet.Error))
{
return(ReturnError(string.Format(ServiceRes.CouldNotAddError_, boxModelLanguageModelRet.Error)));
}
}
// Calculating results and adding results in BoxModelResults
boxModelModel.BoxModelID = boxModelToUpdate.BoxModelID;
BoxModelModel boxModelModelRet2 = AddOrUpdateBoxModelResultModel(boxModelModel);
if (!string.IsNullOrWhiteSpace(boxModelModelRet2.Error))
{
return(ReturnError(boxModelModelRet2.Error));
}
ts.Complete();
}
return(GetBoxModelModelWithBoxModelIDDB(boxModelToUpdate.BoxModelID));
}
private void FillBoxModelLanguageModelNew(LanguageEnum Language, BoxModelModel boxModelModel, BoxModelLanguageModel boxModelLanguageModel)
{
boxModelLanguageModel.BoxModelID = boxModelModel.BoxModelID;
boxModelLanguageModel.Language = Language;
boxModelLanguageModel.ScenarioName = randomService.RandomString("TV Text", 20);
boxModelLanguageModel.TranslationStatus = TranslationStatusEnum.Translated;
Assert.IsTrue(boxModelLanguageModel.BoxModelID != 0);
Assert.IsTrue(boxModelLanguageModel.Language == Language);
Assert.IsTrue(boxModelLanguageModel.ScenarioName.Length == 20);
Assert.IsTrue(boxModelLanguageModel.TranslationStatus == TranslationStatusEnum.Translated);
}
