// Check
public string TVItemLanguageModelOK(TVItemLanguageModel tvItemLanguageModel)
{
string retStr = FieldCheckNotZeroInt(tvItemLanguageModel.TVItemID, ServiceRes.TVItemID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.LanguageOK(tvItemLanguageModel.Language);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotEmptyAndMaxLengthString(tvItemLanguageModel.TVText, ServiceRes.TVText, 200);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(tvItemLanguageModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public TVItemLanguageModel GetTVItemLanguageModelWithTVItemIDAndLanguageDB(int TVItemID, LanguageEnum Language)
{
TVItemLanguageModel tvItemLanguageModel = (from c in db.TVItemLanguages
where c.TVItemID == TVItemID &&
c.Language == (int)Language
select new TVItemLanguageModel
{
Error = "",
TVItemLanguageID = c.TVItemLanguageID,
DBCommand = (DBCommandEnum)c.DBCommand,
TVItemID = c.TVItemID,
Language = (LanguageEnum)c.Language,
TranslationStatus = (TranslationStatusEnum)c.TranslationStatus,
TVText = c.TVText,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <TVItemLanguageModel>();
if (tvItemLanguageModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.TVItemLanguage, ServiceRes.TVItemID + "," + ServiceRes.Language, TVItemID + "," + Language)));
}
return(tvItemLanguageModel);
}
public TVItemLanguageModel PostUpdateTVItemLanguageDB(TVItemLanguageModel tvItemLanguageModel)
{
string retStr = TVItemLanguageModelOK(tvItemLanguageModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
TVItemLanguage tvItemLanguageToUpdate = GetTVItemLanguageWithTVItemIDAndLanguageDB(tvItemLanguageModel.TVItemID, tvItemLanguageModel.Language);
if (tvItemLanguageToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.TVItemLanguage)));
}
retStr = FillTVItemLanguage(tvItemLanguageToUpdate, tvItemLanguageModel, 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("TVItemLanguages", tvItemLanguageToUpdate.TVItemLanguageID, LogCommandEnum.Change, tvItemLanguageToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetTVItemLanguageModelWithTVItemIDAndLanguageDB(tvItemLanguageToUpdate.TVItemID, (LanguageEnum)tvItemLanguageToUpdate.Language));
}
public TVItemLanguageModel PostAddTVItemLanguageDB(TVItemLanguageModel tvItemLanguageModel)
{
string retStr = TVItemLanguageModelOK(tvItemLanguageModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
TVItemLanguageModel tvItemLanguageModelExist = GetTVItemLanguageModelWithTVItemIDAndLanguageDB(tvItemLanguageModel.TVItemID, tvItemLanguageModel.Language);
if (string.IsNullOrWhiteSpace(tvItemLanguageModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.TVItemLanguage)));
}
TVItemLanguage tvItemLanguageNew = new TVItemLanguage();
retStr = FillTVItemLanguage(tvItemLanguageNew, tvItemLanguageModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
db.TVItemLanguages.Add(tvItemLanguageNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("TVItemLanguages", tvItemLanguageNew.TVItemLanguageID, LogCommandEnum.Add, tvItemLanguageNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
return(GetTVItemLanguageModelWithTVItemIDAndLanguageDB(tvItemLanguageNew.TVItemID, tvItemLanguageModel.Language));
}
// Fill
public string FillTVItemLanguage(TVItemLanguage tvItemLanguageNew, TVItemLanguageModel tvItemLanguageModel, ContactOK contactOK)
{
tvItemLanguageNew.DBCommand = (int)tvItemLanguageModel.DBCommand;
tvItemLanguageNew.TVItemID = tvItemLanguageModel.TVItemID;
tvItemLanguageNew.Language = (int)tvItemLanguageModel.Language;
tvItemLanguageNew.TranslationStatus = (int)tvItemLanguageModel.TranslationStatus;
tvItemLanguageNew.TVText = tvItemLanguageModel.TVText;
tvItemLanguageNew.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
tvItemLanguageNew.LastUpdateContactTVItemID = 2;
}
else
{
tvItemLanguageNew.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
// Post
public TVItemLanguageModel PostAddRootTVItemLanguageDB(TVItemLanguageModel tvItemLanguageModel)
{
int TVItemLanguageCount = GetTVItemLanguageModelCountDB();
if (TVItemLanguageCount > 1)
{
return(ReturnError(ServiceRes.TVItemRootShouldBeTheFirstOneAdded));
}
string retStr = TVItemLanguageModelOK(tvItemLanguageModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
TVItemLanguage tvItemLanguageNew = new TVItemLanguage();
retStr = FillTVItemLanguage(tvItemLanguageNew, tvItemLanguageModel, null);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.TVItemLanguages.Add(tvItemLanguageNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("TVItemLanguages", tvItemLanguageNew.TVItemLanguageID, LogCommandEnum.Add, tvItemLanguageNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetTVItemLanguageModelWithTVItemIDAndLanguageDB(tvItemLanguageNew.TVItemID, tvItemLanguageModel.Language));
}
// Post
public PolSourceSiteModel PolSourceSiteAddOrModifyDB(FormCollection fc)
{
int tempInt = 0;
int ParentTVItemID = 0;
int PolSourceSiteTVItemID = 0;
bool IsActive = false;
bool IsPointSource = false;
double Lat = 0.0D;
double Lng = 0.0D;
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrWhiteSpace(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
if (string.IsNullOrWhiteSpace(fc["ParentTVItemID"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.ParentTVItemID)));
}
int.TryParse(fc["ParentTVItemID"], out ParentTVItemID);
if (ParentTVItemID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.ParentTVItemID)));
}
if (string.IsNullOrWhiteSpace(fc["PolSourceSiteTVItemID"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.PolSourceSiteTVItemID)));
}
int.TryParse(fc["PolSourceSiteTVItemID"], out PolSourceSiteTVItemID);
// PolSourceSiteTVItemID == 0 ==> Add
// PolSourceSiteTVItemID > 0 ==> Modify
TVItemModel tvItemModelPolSource = null;
if (PolSourceSiteTVItemID != 0)
{
tvItemModelPolSource = _TVItemService.GetTVItemModelWithTVItemIDDB(PolSourceSiteTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelPolSource.Error))
{
return(ReturnError(tvItemModelPolSource.Error));
}
}
PolSourceSiteModel polSourceSiteNewOrToChange = new PolSourceSiteModel();
if (PolSourceSiteTVItemID != 0)
{
polSourceSiteNewOrToChange = GetPolSourceSiteModelWithPolSourceSiteTVItemIDDB(PolSourceSiteTVItemID);
if (!string.IsNullOrWhiteSpace(polSourceSiteNewOrToChange.Error))
{
return(ReturnError(polSourceSiteNewOrToChange.Error));
}
}
polSourceSiteNewOrToChange.DBCommand = DBCommandEnum.Original;
if (string.IsNullOrWhiteSpace(fc["IsActive"]))
{
IsActive = false;
}
else
{
IsActive = true;
}
if (!IsActive)
{
int.TryParse(fc["InactiveReason"], out tempInt);
if (tempInt == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.InactiveReason)));
}
polSourceSiteNewOrToChange.InactiveReason = (PolSourceInactiveReasonEnum)tempInt;
}
else
{
polSourceSiteNewOrToChange.InactiveReason = null;
}
if (string.IsNullOrWhiteSpace(fc["IsPointSource"]))
{
IsPointSource = false;
}
else
{
IsPointSource = true;
}
polSourceSiteNewOrToChange.IsPointSource = IsPointSource;
double.TryParse(fc["Lat"], out Lat);
if (Lat == 0.0D)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.Lat)));
}
double.TryParse(fc["Lng"], out Lng);
if (Lng == 0.0D)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.Lng)));
}
List <Coord> coordList = new List <Coord>()
{
new Coord()
{
Lat = (float)Lat, Lng = (float)Lng, Ordinal = 0
}
};
using (TransactionScope ts = new TransactionScope())
{
string ObservationInfo = ((int)PolSourceObsInfoEnum.SourceStart).ToString() + ",";
List <int> obsIntList = ObservationInfo.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(int.Parse).ToList();
string ObservationLanguageTVText = ServiceRes.Error;
string TVText = _BaseEnumService.GetEnumText_PolSourceObsInfoTextEnum(PolSourceObsInfoEnum.Error);
int NextSiteNumber = 0;
if (PolSourceSiteTVItemID == 0)
{
NextSiteNumber = GetNextAvailableSiteNumberWithParentTVItemIDDB(ParentTVItemID);
polSourceSiteNewOrToChange.Site = NextSiteNumber;
TVText = TVText + " - " + "000000".Substring(0, "000000".Length - NextSiteNumber.ToString().Length) + NextSiteNumber.ToString();
TVItemModel tvItemModelNewPolSourceSite = _TVItemService.PostAddChildTVItemDB(ParentTVItemID, TVText, TVTypeEnum.PolSourceSite);
if (!string.IsNullOrWhiteSpace(tvItemModelNewPolSourceSite.Error))
{
return(ReturnError(tvItemModelNewPolSourceSite.Error));
}
polSourceSiteNewOrToChange.PolSourceSiteTVItemID = tvItemModelNewPolSourceSite.TVItemID;
polSourceSiteNewOrToChange.PolSourceSiteTVText = TVText;
polSourceSiteNewOrToChange = PostAddPolSourceSiteDB(polSourceSiteNewOrToChange);
if (!string.IsNullOrWhiteSpace(polSourceSiteNewOrToChange.Error))
{
return(ReturnError(polSourceSiteNewOrToChange.Error));
}
// Automatically add one Pollution Source Observation for today
PolSourceObservationModel polSourceObservationModelNew = new PolSourceObservationModel()
{
DBCommand = DBCommandEnum.Original,
PolSourceSiteID = polSourceSiteNewOrToChange.PolSourceSiteID,
ObservationDate_Local = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
ContactTVItemID = contactOK.ContactTVItemID,
Observation_ToBeDeleted = "",
};
PolSourceObservationModel polSourceObservationModelRet = _PolSourceObservationService.PostAddPolSourceObservationDB(polSourceObservationModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelRet.Error))
{
return(ReturnError(polSourceObservationModelRet.Error));
}
// Automatically add one Pollution Source Observation Issue
PolSourceObservationIssueModel polSourceObservationIssueModelNew = new PolSourceObservationIssueModel();
polSourceObservationIssueModelNew.DBCommand = DBCommandEnum.Original;
polSourceObservationIssueModelNew.PolSourceObservationID = polSourceObservationModelRet.PolSourceObservationID;
polSourceObservationIssueModelNew.ObservationInfo = ObservationInfo;
polSourceObservationIssueModelNew.Ordinal = 0;
PolSourceObservationIssueModel polSourceObservationIssueModelRet = _PolSourceObservationService._PolSourceObservationIssueService.PostAddPolSourceObservationIssueDB(polSourceObservationIssueModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationIssueModelRet.Error))
{
return(ReturnError(polSourceObservationIssueModelRet.Error));
}
// doing the other language
foreach (LanguageEnum lang in LanguageListAllowable.Where(c => c != LanguageRequest))
{
TVItemService tvItemService = new TVItemService(lang, _TVItemService.User);
Thread.CurrentThread.CurrentCulture = new CultureInfo(lang + "-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo(lang + "-CA");
ObservationInfo = ((int)PolSourceObsInfoEnum.SourceStart).ToString() + ",";
ObservationLanguageTVText = ServiceRes.Error;
TVText = _BaseEnumService.GetEnumText_PolSourceObsInfoTextEnum(PolSourceObsInfoEnum.Error);
TVText = (string.IsNullOrWhiteSpace(TVText) ? ServiceRes.Error : TVText);
if (PolSourceSiteTVItemID == 0)
{
TVText = TVText + " - " + "000000".Substring(0, "000000".Length - NextSiteNumber.ToString().Length) + NextSiteNumber.ToString();
}
else
{
TVText = TVText + " - " + "000000".Substring(0, "000000".Length - polSourceSiteNewOrToChange.Site.ToString().Length) + polSourceSiteNewOrToChange.Site.ToString();
}
TVItemLanguageModel tvItemLanguageModel = new TVItemLanguageModel();
tvItemLanguageModel.DBCommand = DBCommandEnum.Original;
tvItemLanguageModel.Language = lang;
tvItemLanguageModel.TVText = TVText;
tvItemLanguageModel.TVItemID = polSourceSiteNewOrToChange.PolSourceSiteTVItemID;
TVItemLanguageModel tvItemLanguageModelRet = tvItemService._TVItemLanguageService.PostUpdateTVItemLanguageDB(tvItemLanguageModel);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModelRet.Error))
{
return(ReturnError(tvItemLanguageModelRet.Error));
}
Thread.CurrentThread.CurrentCulture = new CultureInfo(LanguageRequest + "-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo(LanguageRequest + "-CA");
}
}
else
{
polSourceSiteNewOrToChange = PostUpdatePolSourceSiteDB(polSourceSiteNewOrToChange);
if (!string.IsNullOrWhiteSpace(polSourceSiteNewOrToChange.Error))
{
return(ReturnError(polSourceSiteNewOrToChange.Error));
}
}
// Adding map info
List <MapInfoPointModel> mapInfoPointModelList = _MapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(polSourceSiteNewOrToChange.PolSourceSiteTVItemID, TVTypeEnum.PolSourceSite, MapInfoDrawTypeEnum.Point);
if (mapInfoPointModelList.Count == 0)
{
MapInfoModel mapInfoModelRet = _MapInfoService.CreateMapInfoObjectDB(coordList, MapInfoDrawTypeEnum.Point, TVTypeEnum.PolSourceSite, polSourceSiteNewOrToChange.PolSourceSiteTVItemID);
if (!string.IsNullOrWhiteSpace(mapInfoModelRet.Error))
{
return(ReturnError(mapInfoModelRet.Error));
}
}
else
{
mapInfoPointModelList[0].Lat = coordList[0].Lat;
mapInfoPointModelList[0].Lng = coordList[0].Lng;
MapInfoPointModel mapInfoPointModelRet = _MapInfoService._MapInfoPointService.PostUpdateMapInfoPointDB(mapInfoPointModelList[0]);
if (!string.IsNullOrWhiteSpace(mapInfoPointModelRet.Error))
{
return(ReturnError(mapInfoPointModelRet.Error));
}
}
TVItemModel tvItemModelPolSourceSite = _TVItemService.GetTVItemModelWithTVItemIDDB(polSourceSiteNewOrToChange.PolSourceSiteTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelPolSourceSite.Error))
{
return(ReturnError(tvItemModelPolSourceSite.Error));
}
tvItemModelPolSourceSite.IsActive = IsActive;
TVItemModel tvItemModelRet = _TVItemService.PostUpdateTVItemDB(tvItemModelPolSourceSite);
if (!string.IsNullOrWhiteSpace(tvItemModelRet.Error))
{
return(ReturnError(tvItemModelRet.Error));
}
ts.Complete();
}
return(polSourceSiteNewOrToChange);
}
public ClimateSiteModel PostUpdateClimateSiteDB(ClimateSiteModel climateSiteModel)
{
string retStr = ClimateSiteModelOK(climateSiteModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
ClimateSite climateSiteToUpdate = GetClimateSiteWithClimateSiteIDDB(climateSiteModel.ClimateSiteID);
if (climateSiteToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.ClimateSite)));
}
retStr = FillClimateSite(climateSiteToUpdate, climateSiteModel, 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("ClimateSites", climateSiteToUpdate.ClimateSiteID, LogCommandEnum.Change, climateSiteToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
if (Lang == LanguageRequest)
{
TVItemLanguageModel tvItemLanguageModelToUpdate = _TVItemService._TVItemLanguageService.GetTVItemLanguageModelWithTVItemIDAndLanguageDB(climateSiteToUpdate.ClimateSiteTVItemID, Lang);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModelToUpdate.Error))
{
return(ReturnError(tvItemLanguageModelToUpdate.Error));
}
tvItemLanguageModelToUpdate.TVText = CreateTVText(climateSiteModel);
if (string.IsNullOrWhiteSpace(tvItemLanguageModelToUpdate.TVText))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.TVText)));
}
TVItemLanguageModel tvItemLanguageModel = _TVItemService._TVItemLanguageService.PostUpdateTVItemLanguageDB(tvItemLanguageModelToUpdate);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModel.Error))
{
return(ReturnError(tvItemLanguageModel.Error));
}
}
}
ts.Complete();
}
return(GetClimateSiteModelWithClimateSiteIDDB(climateSiteToUpdate.ClimateSiteID));
}
// Post
public EmailModel PostAddOrModifyDB(FormCollection fc)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrWhiteSpace(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
int ContactTVItemID = 0;
int EmailTVItemID = 0;
string EmailAddress = "";
int EmailTypeInt = 0;
EmailTypeEnum EmailType = EmailTypeEnum.Error;
int.TryParse(fc["ContactTVItemID"], out ContactTVItemID);
if (ContactTVItemID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.ContactTVItemID)));
}
int.TryParse(fc["EmailTVItemID"], out EmailTVItemID);
// if 0 then want to add new TVItem else want to modify
EmailAddress = fc["EmailAddress"];
if (string.IsNullOrWhiteSpace(EmailAddress))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.EmailAddress)));
}
int.TryParse(fc["EmailType"], out EmailTypeInt);
if (EmailTypeInt == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.EmailType)));
}
EmailType = (EmailTypeEnum)EmailTypeInt;
EmailModel EmailModel = new EmailModel();
using (TransactionScope ts = new TransactionScope())
{
if (EmailTVItemID == 0)
{
TVItemModel tvItemModelRoot = _TVItemService.GetRootTVItemModelDB();
if (!string.IsNullOrWhiteSpace(tvItemModelRoot.Error))
{
return(ReturnError(tvItemModelRoot.Error));
}
TVItemModel tvItemModelContact = _TVItemService.GetTVItemModelWithTVItemIDDB(ContactTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelContact.Error))
{
return(ReturnError(tvItemModelContact.Error));
}
EmailModel EmailModelNew = new EmailModel()
{
EmailAddress = EmailAddress,
EmailType = EmailType,
};
string TVText = CreateTVText(EmailModelNew);
if (string.IsNullOrWhiteSpace(TVText))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.TVText)));
}
TVItemModel tvItemModelEmail = _TVItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, TVText, TVTypeEnum.Email);
if (!string.IsNullOrWhiteSpace(tvItemModelEmail.Error))
{
// Should add
tvItemModelEmail = _TVItemService.PostAddChildTVItemDB(tvItemModelRoot.TVItemID, TVText, TVTypeEnum.Email);
if (!string.IsNullOrWhiteSpace(tvItemModelEmail.Error))
{
return(ReturnError(tvItemModelEmail.Error));
}
EmailModelNew.EmailTVItemID = tvItemModelEmail.TVItemID;
EmailModel = PostAddEmailDB(EmailModelNew);
if (!string.IsNullOrWhiteSpace(EmailModel.Error))
{
return(ReturnError(EmailModel.Error));
}
}
EmailModel = GetEmailModelWithEmailTVItemIDDB(tvItemModelEmail.TVItemID);
if (!string.IsNullOrWhiteSpace(EmailModel.Error))
{
return(ReturnError(EmailModel.Error));
}
TVItemLinkModel tvItemLinkModelNew = new TVItemLinkModel()
{
DBCommand = DBCommandEnum.Original,
FromTVItemID = tvItemModelContact.TVItemID,
ToTVItemID = tvItemModelEmail.TVItemID,
FromTVType = tvItemModelContact.TVType,
ToTVType = TVTypeEnum.Email,
StartDateTime_Local = DateTime.Now,
Ordinal = 0,
TVLevel = 0,
TVPath = "p" + tvItemModelContact.TVItemID + "p" + tvItemModelEmail.TVItemID,
};
TVItemLinkModel tvItemLinkModel = _TVItemLinkService.GetTVItemLinkModelWithFromTVItemIDAndToTVItemIDDB(tvItemModelContact.TVItemID, tvItemModelEmail.TVItemID);
if (!string.IsNullOrWhiteSpace(tvItemLinkModel.Error))
{
tvItemLinkModel = _TVItemLinkService.PostAddTVItemLinkDB(tvItemLinkModelNew);
if (!string.IsNullOrWhiteSpace(tvItemLinkModel.Error))
{
return(ReturnError(tvItemLinkModel.Error));
}
}
}
else
{
EmailModel EmailModelToChange = GetEmailModelWithEmailTVItemIDDB(EmailTVItemID);
if (!string.IsNullOrWhiteSpace(EmailModelToChange.Error))
{
return(ReturnError(EmailModelToChange.Error));
}
EmailModelToChange.EmailAddress = EmailAddress;
EmailModelToChange.EmailType = EmailType;
EmailModel = PostUpdateEmailDB(EmailModelToChange);
if (!string.IsNullOrWhiteSpace(EmailModel.Error))
{
return(ReturnError(EmailModel.Error));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
TVItemLanguageModel tvItemLanguageModel = _TVItemService._TVItemLanguageService.GetTVItemLanguageModelWithTVItemIDAndLanguageDB(EmailModelToChange.EmailTVItemID, Lang);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModel.Error))
{
return(ReturnError(tvItemLanguageModel.Error));
}
tvItemLanguageModel.TVText = CreateTVText(EmailModelToChange);
tvItemLanguageModel = _TVItemService._TVItemLanguageService.PostUpdateTVItemLanguageDB(tvItemLanguageModel);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModel.Error))
{
return(ReturnError(tvItemLanguageModel.Error));
}
}
}
ts.Complete();
}
return(EmailModel);
}
// Post
public PolSourceObservationModel PolSourceObservationAddOrModifyDB(FormCollection fc)
{
int PolSourceSiteID = 0;
int PolSourceSiteTVItemID = 0;
int PolSourceObservationID = 0;
int Year = 0;
int Month = 0;
int Day = 0;
bool DesktopReviewed = false;
DateTime ObsDate = new DateTime(1900, 1, 1);
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrWhiteSpace(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
if (string.IsNullOrWhiteSpace(fc["PolSourceSiteTVItemID"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.PolSourceSiteTVItemID)));
}
int.TryParse(fc["PolSourceSiteTVItemID"], out PolSourceSiteTVItemID);
if (PolSourceSiteTVItemID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.PolSourceSiteTVItemID)));
}
TVItemModel tvItemModelPolSourcSite = _TVItemService.GetTVItemModelWithTVItemIDDB(PolSourceSiteTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelPolSourcSite.Error))
{
return(ReturnError(tvItemModelPolSourcSite.Error));
}
if (string.IsNullOrWhiteSpace(fc["PolSourceSiteID"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.PolSourceSiteID)));
}
int.TryParse(fc["PolSourceSiteID"], out PolSourceSiteID);
if (PolSourceSiteID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.PolSourceSiteID)));
}
if (string.IsNullOrWhiteSpace(fc["PolSourceObservationID"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.PolSourceObservationID)));
}
int.TryParse(fc["PolSourceObservationID"], out PolSourceObservationID);
// PolSourceObservationID == 0 ==> Add
// PolSourceObservationID > 0 ==> Modify
PolSourceObservationModel polSourceObservationModelToAddOrChange = new PolSourceObservationModel();
if (PolSourceObservationID > 0)
{
polSourceObservationModelToAddOrChange = GetPolSourceObservationModelWithPolSourceObservationIDDB(PolSourceObservationID);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelToAddOrChange.Error))
{
return(ReturnError(polSourceObservationModelToAddOrChange.Error));
}
}
int.TryParse(fc["ObsYear"], out Year);
if (Year == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.Year)));
}
int.TryParse(fc["ObsMonth"], out Month);
if (Month == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.Month)));
}
int.TryParse(fc["ObsDay"], out Day);
if (Day == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.Day)));
}
ObsDate = new DateTime(Year, Month, Day);
if (fc["DesktopReviewed"] != null)
{
DesktopReviewed = true;
}
//PolSourceObservationModel polSourceObservationModelRet = new PolSourceObservationModel();
using (TransactionScope ts = new TransactionScope())
{
PolSourceObservationModel polSourceObservationModelNew = new PolSourceObservationModel()
{
DBCommand = DBCommandEnum.Original,
PolSourceSiteID = PolSourceSiteID,
ObservationDate_Local = ObsDate,
ContactTVItemID = contactOK.ContactTVItemID,
DesktopReviewed = DesktopReviewed,
Observation_ToBeDeleted = "",
};
if (PolSourceObservationID == 0) // new
{
polSourceObservationModelToAddOrChange = PostAddPolSourceObservationDB(polSourceObservationModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelToAddOrChange.Error))
{
return(ReturnError(polSourceObservationModelToAddOrChange.Error));
}
string ObservationInfo = ((int)PolSourceObsInfoEnum.SourceStart).ToString() + ",";
List <int> obsIntList = ObservationInfo.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(int.Parse).ToList();
PolSourceObservationIssueModel polSourceObservationIssueModelNew = new PolSourceObservationIssueModel();
polSourceObservationIssueModelNew.DBCommand = DBCommandEnum.Original;
polSourceObservationIssueModelNew.PolSourceObservationID = polSourceObservationModelToAddOrChange.PolSourceObservationID;
polSourceObservationIssueModelNew.ObservationInfo = ObservationInfo;
polSourceObservationIssueModelNew.Ordinal = 0;
PolSourceObservationIssueModel polSourceObservationIssueModelRet = _PolSourceObservationIssueService.PostAddPolSourceObservationIssueDB(polSourceObservationIssueModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationIssueModelRet.Error))
{
return(ReturnError(polSourceObservationIssueModelRet.Error));
}
// doing the other language
foreach (LanguageEnum lang in LanguageListAllowable.Where(c => c != LanguageRequest))
{
TVItemService tvItemService = new TVItemService(lang, _PolSourceObservationIssueService.User);
Thread.CurrentThread.CurrentCulture = new CultureInfo(lang + "-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo(lang + "-CA");
ObservationInfo = ((int)PolSourceObsInfoEnum.SourceStart).ToString() + ",";
string ObservationLanguageTVText = ServiceRes.Error;
string TVText = _BaseEnumService.GetEnumText_PolSourceObsInfoTextEnum(PolSourceObsInfoEnum.Error);;
TVText = (string.IsNullOrWhiteSpace(TVText) ? ServiceRes.Error : TVText);
int Site = GetSiteWithPolSourceSiteID(PolSourceSiteID);
TVText = TVText + " - " + "000000".Substring(0, "000000".Length - Site.ToString().Length) + Site.ToString();
TVItemLanguageModel tvItemLanguageModel = new TVItemLanguageModel();
tvItemLanguageModel.DBCommand = DBCommandEnum.Original;
tvItemLanguageModel.Language = lang;
tvItemLanguageModel.TVText = TVText;
tvItemLanguageModel.TVItemID = PolSourceSiteID;
TVItemLanguageModel tvItemLanguageModelRet = tvItemService._TVItemLanguageService.PostUpdateTVItemLanguageDB(tvItemLanguageModel);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModelRet.Error))
{
return(ReturnError(tvItemLanguageModelRet.Error));
}
Thread.CurrentThread.CurrentCulture = new CultureInfo(LanguageRequest + "-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo(LanguageRequest + "-CA");
}
}
else
{
polSourceObservationModelNew.PolSourceObservationID = polSourceObservationModelToAddOrChange.PolSourceObservationID;
polSourceObservationModelToAddOrChange = PostUpdatePolSourceObservationDB(polSourceObservationModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelToAddOrChange.Error))
{
return(ReturnError(polSourceObservationModelToAddOrChange.Error));
}
}
ts.Complete();
}
return(polSourceObservationModelToAddOrChange);
}
public MikeSourceModel PostUpdateMikeSourceDB(MikeSourceModel mikeSourceModel)
{
string retStr = MikeSourceModelOK(mikeSourceModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
MikeSource mikeSourceToUpdate = GetMikeSourceWithMikeSourceIDDB(mikeSourceModel.MikeSourceID);
if (mikeSourceToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.MikeSource)));
}
retStr = FillMikeSource(mikeSourceToUpdate, mikeSourceModel, 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("MikeSources", mikeSourceToUpdate.MikeSourceID, LogCommandEnum.Change, mikeSourceToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
if (Lang == LanguageRequest)
{
TVItemLanguageModel tvItemLanguageModelToUpdate = _TVItemService._TVItemLanguageService.GetTVItemLanguageModelWithTVItemIDAndLanguageDB(mikeSourceToUpdate.MikeSourceTVItemID, Lang);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModelToUpdate.Error))
{
return(ReturnError(tvItemLanguageModelToUpdate.Error));
}
string TVText = CreateTVText(mikeSourceModel);
if (string.IsNullOrWhiteSpace(TVText))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.TVText)));
}
TVItemModel tvItemModelMikeSourceExit = _TVItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(mikeSourceModel.MikeSourceTVItemID, TVText, TVTypeEnum.MikeSource);
if (string.IsNullOrWhiteSpace(tvItemModelMikeSourceExit.Error))
{
bool IsSameTVItemModel = GetIsItSameObject(mikeSourceModel, tvItemModelMikeSourceExit);
if (!IsSameTVItemModel)
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.MikeSource)));
}
}
tvItemLanguageModelToUpdate.TVText = TVText;
TVItemLanguageModel tvItemLanguageModel = _TVItemService._TVItemLanguageService.PostUpdateTVItemLanguageDB(tvItemLanguageModelToUpdate);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModel.Error))
{
return(ReturnError(tvItemLanguageModel.Error));
}
}
}
ts.Complete();
}
return(GetMikeSourceModelWithMikeSourceIDDB(mikeSourceToUpdate.MikeSourceID));
}
public bool CreateStationsQC()
{
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
TVItemLanguageService tvItemLanguageService = new TVItemLanguageService(LanguageEnum.en, user);
MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user);
MWQMSiteService mwqmSiteService = new MWQMSiteService(LanguageEnum.en, user);
TVItemModel tvItemModelRoot = tvItemService.GetRootTVItemModelDB();
if (!CheckModelOK <TVItemModel>(tvItemModelRoot))
{
return(false);
}
TVItemModel tvItemModelCanada = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, "Canada", TVTypeEnum.Country);
if (!CheckModelOK <TVItemModel>(tvItemModelCanada))
{
return(false);
}
TVItemModel tvItemModelQC = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "Québec", TVTypeEnum.Province);
if (!CheckModelOK <TVItemModel>(tvItemModelQC))
{
return(false);
}
List <TVItemModel> tvItemModelSubsectorQCList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelQC.TVItemID, TVTypeEnum.Subsector);
if (tvItemModelSubsectorQCList.Count == 0)
{
richTextBoxStatus.AppendText("Could not find TVItem Subsector under British Columbia\r\n");
return(false);
}
lblStatus.Text = "Starting ... CreateStationsQC";
Application.DoEvents();
int StartQCCreateStationQC = int.Parse(textBoxQCCreateStationsQC.Text);
List <Obs> obsTypeList = new List <Obs>();
List <string> sectorList = new List <string>();
List <TT> tideTextInDBList = new List <TT>();
List <AM> analyseMethodInDBList = new List <AM>();
List <Mat> matrixInDBList = new List <Mat>();
List <Lab> labInDBList = new List <Lab>();
List <SampleStatus> sampleStatusInDBList = new List <SampleStatus>();
List <TempData.QCSubsectorAssociation> qcSubAssList = new List <TempData.QCSubsectorAssociation>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
qcSubAssList = (from c in dbDT.QCSubsectorAssociations
select c).ToList <TempData.QCSubsectorAssociation>();
}
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
sectorList = (from s in dbQC.geo_stations_p
where s.secteur != null
select s.secteur).Distinct().OrderBy(c => c).ToList();
}
List <TVItemModel> tvItemModelSubsectorList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelQC.TVItemID, TVTypeEnum.Subsector);
List <TVItemModel> tvItemModelSiteList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelQC.TVItemID, TVTypeEnum.MWQMSite);
TempData.QCSubsectorAssociation qcSubsectAss = new TempData.QCSubsectorAssociation();
// doing every sector with the exception of MS__
List <PCCSM.geo_stations_p> staQCList = new List <PCCSM.geo_stations_p>();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
staQCList = (from c in dbQC.geo_stations_p
where (c.x != null && c.y != null) &&
c.secteur != null
orderby c.secteur, c.station
select c).ToList <PCCSM.geo_stations_p>();
}
List <TVItemLanguage> tvItemSiteLanguageList = new List <TVItemLanguage>();
int TVItemIDSSOld = 0;
int count = 0;
int total = staQCList.Count;
foreach (PCCSM.geo_stations_p geoStat in staQCList)
{
if (Cancel)
{
return(false);
}
textBoxQCCreateStationsQC.Text = count.ToString();
if (StartQCCreateStationQC > count)
{
continue;
}
qcSubsectAss = (from c in qcSubAssList
where c.QCSectorText == geoStat.secteur
select c).FirstOrDefault <TempData.QCSubsectorAssociation>();
if (qcSubsectAss == null)
{
richTextBoxStatus.AppendText(geoStat.secteur + " does not exist\r\n");
//return false;
continue;
}
TVItemModel tvItemModelSubsector = (from c in tvItemModelSubsectorList
where c.TVText.StartsWith(qcSubsectAss.SubsectorText)
select c).FirstOrDefault();
if (TVItemIDSSOld != tvItemModelSubsector.TVItemID)
{
using (CSSPDBEntities db2 = new CSSPDBEntities())
{
tvItemSiteLanguageList = (from c in db2.TVItems
from cl in db2.TVItemLanguages
where c.TVItemID == cl.TVItemID &&
c.ParentID == tvItemModelSubsector.TVItemID &&
c.TVType == (int)TVTypeEnum.MWQMSite
select cl).ToList();
}
TVItemIDSSOld = tvItemModelSubsector.TVItemID;
}
if (tvItemModelSubsector == null)
{
richTextBoxStatus.AppendText("could not find subsector" + geoStat.secteur + "\r\n");
//return false;
continue;
}
bool IsActive = true;
if (geoStat.status != null)
{
IsActive = (geoStat.status.Substring(0, 1) == "i" ? false : true);
}
string PreText = "";
if (geoStat.secteur.Length < qcSubsectAss.SubsectorText.Length)
{
PreText = "";
}
else
{
if (geoStat.secteur.StartsWith(qcSubsectAss.SubsectorText))
{
PreText = geoStat.secteur.Substring(qcSubsectAss.SubsectorText.Length) + "_";
}
else
{
PreText = geoStat.secteur + "_";
}
}
if (PreText.StartsWith(".") || PreText.StartsWith("_"))
{
PreText = PreText.Substring(1);
}
string MWQMSiteTVText = PreText + "0000".Substring(0, 4 - geoStat.station.ToString().Length) + geoStat.station.ToString();
string subsector = tvItemModelSubsector.TVText;
if (subsector.Contains(" "))
{
subsector = subsector.Substring(0, subsector.IndexOf(" "));
}
count += 1;
lblStatus.Text = $"{subsector} --- {MWQMSiteTVText} --- { count.ToString()}/{total.ToString()}";
Application.DoEvents();
List <MapInfoModel> mapInfoModelList = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)geoStat.y, (float)geoStat.x, TVTypeEnum.Subsector);
if (mapInfoModelList.Count == 0)
{
//return false;
continue;
}
TVItemModel tvItemModel = (from c in tvItemModelSiteList
where c.ParentID == tvItemModelSubsector.TVItemID &&
c.TVText.EndsWith(MWQMSiteTVText)
select c).FirstOrDefault();
//TVItemModel tvItemModel = tvItemModelMWQMSiteList.Where(c => c.TVText.EndsWith(MWQMSiteTVText)).FirstOrDefault();
if (tvItemModel == null)
{
TVItemModel tvItemModelRet = tvItemService.PostCreateTVItem(tvItemModelSubsector.TVItemID, MWQMSiteTVText, MWQMSiteTVText, TVTypeEnum.MWQMSite);
if (!CheckModelOK <TVItemModel>(tvItemModelRet))
{
//return false;
continue;
}
if (geoStat.status == null)
{
tvItemModelRet.IsActive = false;
}
else
{
tvItemModelRet.IsActive = (geoStat.status.Substring(0, 1) == "i" ? false : true);
}
TVItemModel tvItemModelRet2 = tvItemService.PostUpdateTVItemDB(tvItemModelRet);
if (!CheckModelOK <TVItemModel>(tvItemModelRet2))
{
//return false;
continue;
}
List <Coord> coordList2 = new List <Coord>()
{
new Coord()
{
Lat = (float)geoStat.y,
Lng = (float)geoStat.x,
}
};
MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList2, MapInfoDrawTypeEnum.Point, TVTypeEnum.MWQMSite, tvItemModelRet2.TVItemID);
if (!CheckModelOK <MapInfoModel>(mapInfoModelRet))
{
//return false;
continue;
}
// should add the QC station to WQMSite
MWQMSiteModel mwqmSiteModelNew = new MWQMSiteModel()
{
MWQMSiteTVItemID = tvItemModelRet2.TVItemID,
MWQMSiteNumber = geoStat.station.ToString(),
Ordinal = (int)geoStat.station,
MWQMSiteTVText = MWQMSiteTVText,
MWQMSiteDescription = "--"
};
MWQMSiteModel mwqmSiteModelRet = mwqmSiteService.PostAddMWQMSiteDB(mwqmSiteModelNew);
if (!CheckModelOK <MWQMSiteModel>(mwqmSiteModelRet))
{
//return false;
continue;
}
}
else
{
TVItemLanguage tvItemLanguageEN = (from c in tvItemSiteLanguageList
where c.TVItemID == tvItemModel.TVItemID &&
c.Language == (int)LanguageEnum.en
select c).FirstOrDefault();
TVItemLanguage tvItemLanguageFR = (from c in tvItemSiteLanguageList
where c.TVItemID == tvItemModel.TVItemID &&
c.Language == (int)LanguageEnum.fr
select c).FirstOrDefault();
if (tvItemLanguageEN.TVText != MWQMSiteTVText || tvItemLanguageFR.TVText != MWQMSiteTVText)
{
foreach (LanguageEnum language in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
TVItemLanguageModel tvItemLanguageModel = tvItemLanguageService.GetTVItemLanguageModelWithTVItemIDAndLanguageDB(tvItemModel.TVItemID, language);
if (!CheckModelOK <TVItemLanguageModel>(tvItemLanguageModel))
{
//return false;
continue;
}
if (tvItemLanguageModel.TVText != MWQMSiteTVText)
{
tvItemLanguageModel.TVText = MWQMSiteTVText;
TVItemLanguageModel tvItemLanguageModelRet = tvItemLanguageService.PostUpdateTVItemLanguageDB(tvItemLanguageModel);
if (!CheckModelOK <TVItemLanguageModel>(tvItemLanguageModelRet))
{
//return false;
continue;
}
}
}
}
}
}
return(true);
}
public HydrometricSiteModel PostUpdateHydrometricSiteDB(HydrometricSiteModel hydrometricSiteModel)
{
string retStr = HydrometricSiteModelOK(hydrometricSiteModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
HydrometricSite hydrometricSiteToUpdate = GetHydrometricSiteWithHydrometricSiteIDDB(hydrometricSiteModel.HydrometricSiteID);
if (hydrometricSiteToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.HydrometricSite)));
}
retStr = FillHydrometricSite(hydrometricSiteToUpdate, hydrometricSiteModel, 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("HydrometricSites", hydrometricSiteToUpdate.HydrometricSiteID, LogCommandEnum.Change, hydrometricSiteToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
if (Lang == LanguageRequest)
{
TVItemLanguageModel tvItemLanguageModelToUpdate = _TVItemService._TVItemLanguageService.GetTVItemLanguageModelWithTVItemIDAndLanguageDB(hydrometricSiteToUpdate.HydrometricSiteTVItemID, Lang);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModelToUpdate.Error))
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.TVItemLanguage, ServiceRes.TVItemID + "," + ServiceRes.Language, hydrometricSiteToUpdate.HydrometricSiteTVItemID.ToString() + "," + Lang)));
}
tvItemLanguageModelToUpdate.TVText = CreateTVText(hydrometricSiteModel);
if (string.IsNullOrWhiteSpace(tvItemLanguageModelToUpdate.TVText))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.TVText)));
}
TVItemLanguageModel tvItemLanguageModel = _TVItemService._TVItemLanguageService.PostUpdateTVItemLanguageDB(tvItemLanguageModelToUpdate);
if (!string.IsNullOrWhiteSpace(tvItemLanguageModel.Error))
{
return(ReturnError(tvItemLanguageModel.Error));
}
}
}
ts.Complete();
}
return(GetHydrometricSiteModelWithHydrometricSiteIDDB(hydrometricSiteToUpdate.HydrometricSiteID));
}
