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