public TideSiteModel GetTideSiteModelWithTideSiteTVItemIDDB(int TideSiteTVItemID)
{
TideSiteModel tideSiteModel = (from c in db.TideSites
let tideSiteName = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TideSiteTVItemID select cl.TVText).FirstOrDefault <string>()
where c.TideSiteTVItemID == TideSiteTVItemID
orderby c.TideSiteID descending
select new TideSiteModel
{
Error = "",
TideSiteID = c.TideSiteID,
DBCommand = (DBCommandEnum)c.DBCommand,
TideSiteTVItemID = c.TideSiteTVItemID,
TideSiteName = tideSiteName,
Province = c.Province,
sid = c.sid,
Zone = c.Zone,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <TideSiteModel>();
if (tideSiteModel == null)
{
return(ReturnTideSiteError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.TideSite, ServiceRes.TideSiteTVItemID, TideSiteTVItemID)));
}
return(tideSiteModel);
}
public void TideDataValueService_FillTideDataValue_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
TideSiteModel tideSiteModelRet = tideSiteServiceTest.AddTideSiteModel();
tideDataValueModelNew.TideSiteTVItemID = tideSiteModelRet.TideSiteTVItemID;
FillTideDataValueModel(tideDataValueModelNew);
ContactOK contactOK = tideDataValueService.IsContactOK();
string retStr = tideDataValueService.FillTideDataValue(tideDataValue, tideDataValueModelNew, contactOK);
Assert.AreEqual("", retStr);
Assert.AreEqual(contactOK.ContactTVItemID, tideDataValue.LastUpdateContactTVItemID);
contactOK = null;
retStr = tideDataValueService.FillTideDataValue(tideDataValue, tideDataValueModelNew, contactOK);
Assert.AreEqual("", retStr);
Assert.AreEqual(2, tideDataValue.LastUpdateContactTVItemID);
}
}
}
public TideSiteModel PostAddTideSiteDB(TideSiteModel tideSiteModel)
{
string retStr = TideSiteModelOK(tideSiteModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnTideSiteError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnTideSiteError(contactOK.Error));
}
TVItemModel tvItemModelExist = _TVItemService.GetTVItemModelWithTVItemIDDB(tideSiteModel.TideSiteTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelExist.Error))
{
return(ReturnTideSiteError(tvItemModelExist.Error));
}
TideSite tideSiteNew = new TideSite();
retStr = FillTideSite(tideSiteNew, tideSiteModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnTideSiteError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.TideSites.Add(tideSiteNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnTideSiteError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("TideSites", tideSiteNew.TideSiteID, LogCommandEnum.Add, tideSiteNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnTideSiteError(logModel.Error));
}
ts.Complete();
}
return(GetTideSiteModelWithTideSiteIDDB(tideSiteNew.TideSiteID));
}
public TideSiteModel PostUpdateTideSiteDB(TideSiteModel tideSiteModel)
{
string retStr = TideSiteModelOK(tideSiteModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnTideSiteError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnTideSiteError(contactOK.Error));
}
TideSite tideSiteToUpdate = GetTideSiteWithTideSiteIDDB(tideSiteModel.TideSiteID);
if (tideSiteToUpdate == null)
{
return(ReturnTideSiteError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.TideSite)));
}
retStr = FillTideSite(tideSiteToUpdate, tideSiteModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnTideSiteError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnTideSiteError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("TideSites", tideSiteToUpdate.TideSiteID, LogCommandEnum.Change, tideSiteToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnTideSiteError(logModel.Error));
}
ts.Complete();
}
return(GetTideSiteModelWithTideSiteIDDB(tideSiteToUpdate.TideSiteID));
}
private TideDataValueModel AddTideDataValue()
{
TideSiteModel tideDataStartDateModelRet = tideSiteServiceTest.AddTideSiteModel();
tideDataValueModelNew.TideSiteTVItemID = tideDataStartDateModelRet.TideSiteTVItemID;
FillTideDataValueModel(tideDataValueModelNew);
TideDataValueModel tideDataValueModelRet = tideDataValueService.PostAddTideDataValueDB(tideDataValueModelNew);
if (!string.IsNullOrWhiteSpace(tideDataValueModelRet.Error))
{
return(tideDataValueModelRet);
}
Assert.IsNotNull(tideDataValueModelRet);
CompareTideDataValueModels(tideDataValueModelNew, tideDataValueModelRet);
return(tideDataValueModelRet);
}
// Fill
public string FillTideSite(TideSite tideSiteNew, TideSiteModel tideSiteModel, ContactOK contactOK)
{
tideSiteNew.DBCommand = (int)tideSiteModel.DBCommand;
tideSiteNew.TideSiteTVItemID = tideSiteModel.TideSiteTVItemID;
tideSiteNew.TideSiteName = tideSiteModel.TideSiteName;
tideSiteNew.Province = tideSiteModel.Province;
tideSiteNew.sid = tideSiteModel.sid;
tideSiteNew.Zone = tideSiteModel.Zone;
tideSiteNew.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
tideSiteNew.LastUpdateContactTVItemID = 2;
}
else
{
tideSiteNew.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
// Check
public string TideSiteModelOK(TideSiteModel tideSiteModel)
{
string retStr = FieldCheckNotZeroInt(tideSiteModel.TideSiteTVItemID, ServiceRes.TideSiteTVItemID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(tideSiteModel.TideSiteName, ServiceRes.TideSiteName, 3, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(tideSiteModel.Province, ServiceRes.Province, 2, 2);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndWithinRangeDouble(tideSiteModel.sid, ServiceRes.sid, 0, 1000000);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndWithinRangeDouble(tideSiteModel.Zone, ServiceRes.Zone, 0, 1000000);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(tideSiteModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public void TideDataValueService_PostAddDeleteTideDataValueDB_UserEmailNotValidated_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
TideSiteModel tideSiteModelRet = tideSiteServiceTest.AddTideSiteModel();
SetupTest(contactModelListGood[2], culture);
tideDataValueModelNew.TideSiteTVItemID = tideSiteModelRet.TideSiteTVItemID;
FillTideDataValueModel(tideDataValueModelNew);
TideDataValueModel tideDataValueModelRet2 = tideDataValueService.PostAddTideDataValueDB(tideDataValueModelNew);
Assert.AreEqual(ServiceRes.EmailRequiresValidation, tideDataValueModelRet2.Error);
}
}
}
public void TideDataValueService_PostAddTideDataValueDB_BadUser_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
TideSiteModel tideSiteModelRet = tideSiteServiceTest.AddTideSiteModel();
SetupTest(contactModelListBad[0], culture);
tideDataValueModelNew.TideSiteTVItemID = tideSiteModelRet.TideSiteTVItemID;
FillTideDataValueModel(tideDataValueModelNew);
TideDataValueModel tideDataValueModelRet2 = tideDataValueService.PostAddTideDataValueDB(tideDataValueModelNew);
Assert.AreEqual(ServiceRes.NeedToBeLoggedIn, tideDataValueModelRet2.Error);
}
}
}
// Helper
public string CreateTVText(TideSiteModel tideSiteModel)
{
return(tideSiteModel.TideSiteName);
}
