public MWQMSiteModel PostDeleteMWQMSiteTVItemDB(int MWQMSiteTVItemID) { ContactOK contactOK = IsContactOK(); if (!string.IsNullOrEmpty(contactOK.Error)) { return(ReturnError(contactOK.Error)); } MWQMSiteModel mwqmSiteModelToDelete = GetMWQMSiteModelWithMWQMSiteTVItemIDDB(MWQMSiteTVItemID); if (!string.IsNullOrWhiteSpace(mwqmSiteModelToDelete.Error)) { return(ReturnError(mwqmSiteModelToDelete.Error)); } MWQMSiteModel mwqmSiteModelRet = PostDeleteMWQMSiteDB(mwqmSiteModelToDelete.MWQMSiteID); if (!string.IsNullOrWhiteSpace(mwqmSiteModelRet.Error)) { return(ReturnError(mwqmSiteModelRet.Error)); } return(ReturnError("")); }
public MWQMSiteModel GetMWQMSiteModelWithMWQMSiteTVItemIDDB(int MWQMSiteTVItemID) { MWQMSiteModel MWQMSiteModel = (from c in db.MWQMSites let mwqmSiteName = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.MWQMSiteTVItemID select cl.TVText).FirstOrDefault <string>() where c.MWQMSiteTVItemID == MWQMSiteTVItemID select new MWQMSiteModel { Error = "", MWQMSiteID = c.MWQMSiteID, DBCommand = (DBCommandEnum)c.DBCommand, MWQMSiteTVItemID = c.MWQMSiteTVItemID, MWQMSiteTVText = mwqmSiteName, MWQMSiteNumber = c.MWQMSiteNumber, MWQMSiteDescription = c.MWQMSiteDescription, MWQMSiteLatestClassification = (MWQMSiteLatestClassificationEnum)c.MWQMSiteLatestClassification, Ordinal = c.Ordinal, LastUpdateDate_UTC = c.LastUpdateDate_UTC, LastUpdateContactTVItemID = c.LastUpdateContactTVItemID, }).FirstOrDefault <MWQMSiteModel>(); if (MWQMSiteModel == null) { return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.MWQMSite, ServiceRes.MWQMSiteTVItemID, MWQMSiteTVItemID))); } return(MWQMSiteModel); }
public bool GetIsItSameObject(MWQMSiteModel mwqmSiteModel, TVItemModel tvItemModelMWQMSiteExit) { bool IsSame = false; if (mwqmSiteModel.MWQMSiteTVItemID == tvItemModelMWQMSiteExit.TVItemID) { IsSame = true; } return(IsSame); }
public MWQMSiteModel PostAddMWQMSiteDB(MWQMSiteModel mwqmSiteModel) { string retStr = MWQMSiteModelOK(mwqmSiteModel); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } ContactOK contactOK = IsContactOK(); if (!string.IsNullOrEmpty(contactOK.Error)) { return(ReturnError(contactOK.Error)); } TVItemModel tvItemModelExist = _TVItemService.GetTVItemModelWithTVItemIDDB(mwqmSiteModel.MWQMSiteTVItemID); if (!string.IsNullOrWhiteSpace(tvItemModelExist.Error)) { return(ReturnError(tvItemModelExist.Error)); } MWQMSite mwqmSiteNew = new MWQMSite(); retStr = FillMWQMSite(mwqmSiteNew, mwqmSiteModel, contactOK); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } using (TransactionScope ts = new TransactionScope()) { db.MWQMSites.Add(mwqmSiteNew); retStr = DoAddChanges(); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } LogModel logModel = _LogService.PostAddLogForObj("MWQMSites", mwqmSiteNew.MWQMSiteID, LogCommandEnum.Add, mwqmSiteNew); if (!string.IsNullOrWhiteSpace(logModel.Error)) { return(ReturnError(logModel.Error)); } ts.Complete(); } return(GetMWQMSiteModelWithMWQMSiteIDDB(mwqmSiteNew.MWQMSiteID)); }
// Check public string MWQMSiteModelOK(MWQMSiteModel mwqmSiteModel) { string retStr = FieldCheckNotZeroInt(mwqmSiteModel.MWQMSiteTVItemID, ServiceRes.MWQMSiteTVItemID); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndMinMaxLengthString(mwqmSiteModel.MWQMSiteTVText, ServiceRes.MWQMSiteTVText, 1, 200); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndMinMaxLengthString(mwqmSiteModel.MWQMSiteNumber, ServiceRes.MWQMSiteNumber, 1, 8); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckIfNotNullMaxLengthString(mwqmSiteModel.MWQMSiteDescription, ServiceRes.MWQMSiteDescription, 200); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = _BaseEnumService.MWQMSiteLatestClassificationOK(mwqmSiteModel.MWQMSiteLatestClassification); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndWithinRangeInt(mwqmSiteModel.Ordinal, ServiceRes.Ordinal, 0, 1000); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = _BaseEnumService.DBCommandOK(mwqmSiteModel.DBCommand); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } return(""); }
public MWQMSiteModel PostUpdateMWQMSiteDB(MWQMSiteModel mwqmSiteModel) { string retStr = MWQMSiteModelOK(mwqmSiteModel); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } ContactOK contactOK = IsContactOK(); if (!string.IsNullOrEmpty(contactOK.Error)) { return(ReturnError(contactOK.Error)); } MWQMSite mwqmSiteToUpdate = GetMWQMSiteWithMWQMSiteIDDB(mwqmSiteModel.MWQMSiteID); if (mwqmSiteToUpdate == null) { return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.MWQMSite))); } retStr = FillMWQMSite(mwqmSiteToUpdate, mwqmSiteModel, 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("MWQMSites", mwqmSiteToUpdate.MWQMSiteID, LogCommandEnum.Change, mwqmSiteToUpdate); if (!string.IsNullOrWhiteSpace(logModel.Error)) { return(ReturnError(logModel.Error)); } ts.Complete(); } return(GetMWQMSiteModelWithMWQMSiteIDDB(mwqmSiteToUpdate.MWQMSiteID)); }
// Fill public string FillMWQMSite(MWQMSite mwqmSite, MWQMSiteModel mwqmSiteModel, ContactOK contactOK) { mwqmSite.DBCommand = (int)mwqmSiteModel.DBCommand; mwqmSite.MWQMSiteTVItemID = mwqmSiteModel.MWQMSiteTVItemID; mwqmSite.MWQMSiteNumber = mwqmSiteModel.MWQMSiteNumber; mwqmSite.MWQMSiteDescription = mwqmSiteModel.MWQMSiteDescription; mwqmSite.MWQMSiteLatestClassification = (int)mwqmSiteModel.MWQMSiteLatestClassification; mwqmSite.Ordinal = mwqmSiteModel.Ordinal; mwqmSite.LastUpdateDate_UTC = DateTime.UtcNow; if (contactOK == null) { mwqmSite.LastUpdateContactTVItemID = 2; } else { mwqmSite.LastUpdateContactTVItemID = contactOK.ContactTVItemID; } return(""); }
public ActionResult _mwqmSite(string Q) { List <string> OptionListTxt = new List <string>() { "10", "15", "20", "25", "30", "35", "40" }; SetArgs(Q); ViewBag.URLModel = urlModel; if (!OptionListTxt.Contains(urlModel.VariableShow.Substring(0, 2))) { urlModel.VariableShow = "30" + urlModel.VariableShow.Substring(2); } ViewBag.MWQMController = _MWQMController; MWQMSiteModel mwqmSiteModel = _MWQMSiteService.GetMWQMSiteModelWithMWQMSiteTVItemIDDB(urlModel.TVItemIDList[0]); ViewBag.MWQMSiteModelCurrent = mwqmSiteModel; TVItemModel tvItemModelCurrent = _TVItemService.GetTVItemModelWithTVItemIDDB(urlModel.TVItemIDList[0]); ViewBag.TVItemModelCurrent = tvItemModelCurrent; ViewBag.NumberOfSample = int.Parse(GetURLVarShowEnumStr(URLVarShowEnum.NumberOfSampleDecade) + GetURLVarShowEnumStr(URLVarShowEnum.NumberOfSampleUnit)); ViewBag.IsMoreInfo = (GetURLVarShowEnumStr(URLVarShowEnum.ShowMoreInfo) == "0" ? false : true); List <MapInfoPointModel> mapInfoPointModelList = _MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(tvItemModelCurrent.TVItemID, TVTypeEnum.MWQMSite, MapInfoDrawTypeEnum.Point); MapInfoPointModel mapInfoPointModel = new MapInfoPointModel(); if (mapInfoPointModelList.Count > 0) { mapInfoPointModel = mapInfoPointModelList[0]; } ViewBag.MapInfoPointModel = mapInfoPointModel; return(PartialView()); }
public PartialViewResult _mwqmSiteAddOrModify(int SubsectorTVItemID, int MWQMSiteTVItemID) { ViewBag.SubsectorTVItemID = SubsectorTVItemID; ViewBag.MWQMSiteTVItemID = MWQMSiteTVItemID; ViewBag.MapInfoPointModel = null; ViewBag.TVItemModel = null; ViewBag.MWQMController = _MWQMController; MWQMSiteModel mwqmSiteModel = _MWQMSiteService.GetMWQMSiteModelWithMWQMSiteTVItemIDDB(MWQMSiteTVItemID); ViewBag.MWQMSiteModel = mwqmSiteModel; MapInfoPointModel mapInfoPointModel = _MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(MWQMSiteTVItemID, TVTypeEnum.MWQMSite, MapInfoDrawTypeEnum.Point).FirstOrDefault(); ViewBag.MapInfoPointModel = mapInfoPointModel; TVItemModel tvItemModel = _TVItemService.GetTVItemModelWithTVItemIDDB(MWQMSiteTVItemID); ViewBag.TVItemModel = tvItemModel; return(PartialView()); }
// Post public MWQMSiteModel MWQMSiteSaveAllDB(FormCollection fc) { //int tempInt = 0; int SubsectorTVItemID = 0; int MWQMSiteTVItemID = 0; bool IsActive = true; string MWQMSiteTVText = ""; string MWQMSiteNumber = ""; string MWQMSiteDescription = ""; double Lat = 0.0D; double Lng = 0.0D; int tempInt = 0; ContactOK contactOK = IsContactOK(); if (!string.IsNullOrWhiteSpace(contactOK.Error)) { return(ReturnError(contactOK.Error)); } int.TryParse(fc["SubsectorTVItemID"], out SubsectorTVItemID); if (SubsectorTVItemID == 0) { return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.SubsectorTVItemID))); } TVItemModel tvItemModelSubsector = _TVItemService.GetTVItemModelWithTVItemIDDB(SubsectorTVItemID); if (!string.IsNullOrWhiteSpace(tvItemModelSubsector.Error)) { return(ReturnError(tvItemModelSubsector.Error)); } int.TryParse(fc["MWQMSiteTVItemID"], out MWQMSiteTVItemID); // could be 0 if 0 then we need to add the new MWQMSite MWQMSiteModel mwqmSiteNewOrToChange = new MWQMSiteModel(); if (fc["IsActive"] != null) { IsActive = true; } else { IsActive = false; } if (MWQMSiteTVItemID != 0) { mwqmSiteNewOrToChange = GetMWQMSiteModelWithMWQMSiteTVItemIDDB(MWQMSiteTVItemID); if (!string.IsNullOrWhiteSpace(mwqmSiteNewOrToChange.Error)) { return(ReturnError(mwqmSiteNewOrToChange.Error)); } } mwqmSiteNewOrToChange.DBCommand = DBCommandEnum.Original; MWQMSiteTVText = fc["MWQMSiteTVText"]; if (string.IsNullOrWhiteSpace(MWQMSiteTVText)) { return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMSiteTVText))); } if (MWQMSiteTVText.Contains("#")) { return(ReturnError(string.Format(ServiceRes.NameOfItemShouldNotContainThe_Character, "#"))); } mwqmSiteNewOrToChange.MWQMSiteTVText = MWQMSiteTVText; MWQMSiteNumber = fc["MWQMSiteNumber"]; if (string.IsNullOrWhiteSpace(MWQMSiteNumber)) { return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMSiteNumber))); } mwqmSiteNewOrToChange.MWQMSiteNumber = MWQMSiteNumber; List <TVItemModel> tvItemModelMWQMSiteList = _TVItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(SubsectorTVItemID, TVTypeEnum.MWQMSite); foreach (TVItemModel tvItemModelMWQMSite in tvItemModelMWQMSiteList) { if (tvItemModelMWQMSite.TVItemID != MWQMSiteTVItemID) { MWQMSiteModel mwqmSiteModel = GetMWQMSiteModelWithMWQMSiteTVItemIDDB(tvItemModelMWQMSite.TVItemID); if (!string.IsNullOrWhiteSpace(mwqmSiteModel.Error)) { return(ReturnError(mwqmSiteModel.Error)); } if (mwqmSiteModel.MWQMSiteNumber == MWQMSiteNumber) { return(ReturnError(string.Format(ServiceRes.MWQMSiteNumberHasToBeUniqueForSubsector))); } } } MWQMSiteDescription = fc["MWQMSiteDescription"]; if (string.IsNullOrWhiteSpace(MWQMSiteDescription)) { return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMSiteDescription))); } mwqmSiteNewOrToChange.MWQMSiteDescription = MWQMSiteDescription; int.TryParse(fc["MWQMSiteLatestClassification"], out tempInt); if (tempInt == 0) { return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMSiteLatestClassification))); } mwqmSiteNewOrToChange.MWQMSiteLatestClassification = (MWQMSiteLatestClassificationEnum)tempInt; 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 } }; MWQMSiteModel mwqmSiteModelRet = new MWQMSiteModel(); using (TransactionScope ts = new TransactionScope()) { if (MWQMSiteTVItemID == 0) { TVItemModel tvItemModelNewMWQMSite = _TVItemService.PostAddChildTVItemDB(SubsectorTVItemID, MWQMSiteTVText, TVTypeEnum.MWQMSite); if (!string.IsNullOrWhiteSpace(tvItemModelNewMWQMSite.Error)) { return(ReturnError(tvItemModelNewMWQMSite.Error)); } mwqmSiteNewOrToChange.MWQMSiteTVItemID = tvItemModelNewMWQMSite.TVItemID; mwqmSiteModelRet = PostAddMWQMSiteDB(mwqmSiteNewOrToChange); if (!string.IsNullOrWhiteSpace(mwqmSiteModelRet.Error)) { return(ReturnError(mwqmSiteModelRet.Error)); } } else { mwqmSiteModelRet = PostUpdateMWQMSiteDB(mwqmSiteNewOrToChange); if (!string.IsNullOrWhiteSpace(mwqmSiteModelRet.Error)) { return(ReturnError(mwqmSiteModelRet.Error)); } } List <MapInfoPointModel> mapInfoPointModelList = _MapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(mwqmSiteModelRet.MWQMSiteTVItemID, TVTypeEnum.MWQMSite, MapInfoDrawTypeEnum.Point); if (mapInfoPointModelList.Count == 0) { MapInfoModel mapInfoModelRet = _MapInfoService.CreateMapInfoObjectDB(coordList, MapInfoDrawTypeEnum.Point, TVTypeEnum.MWQMSite, mwqmSiteModelRet.MWQMSiteTVItemID); 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 tvItemModel = _TVItemService.GetTVItemModelWithTVItemIDDB(mwqmSiteModelRet.MWQMSiteTVItemID); if (!string.IsNullOrWhiteSpace(tvItemModel.Error)) { return(ReturnError(tvItemModel.Error)); } tvItemModel.IsActive = IsActive; tvItemModel.TVText = MWQMSiteTVText; TVItemModel tvItemModelRet = _TVItemService.PostUpdateTVItemDB(tvItemModel); if (!string.IsNullOrWhiteSpace(tvItemModelRet.Error)) { return(ReturnError(tvItemModelRet.Error)); } ts.Complete(); } return(mwqmSiteModelRet); }
public string CreateTVText(MWQMSiteModel mwqmSiteModel) { return(mwqmSiteModel.MWQMSiteTVText); }
public bool CreateStationsBC() { if (Cancel) { return(false); } TVItemService tvItemServiceR = new TVItemService(LanguageEnum.en, user); TVItemModel tvItemModelRoot = tvItemServiceR.GetRootTVItemModelDB(); if (!CheckModelOK <TVItemModel>(tvItemModelRoot)) { return(false); } TVItemModel tvItemModelCanada = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, "Canada", TVTypeEnum.Country); if (!CheckModelOK <TVItemModel>(tvItemModelCanada)) { return(false); } TVItemModel tvItemModelBC = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "British Columbia", TVTypeEnum.Province); if (!CheckModelOK <TVItemModel>(tvItemModelBC)) { return(false); } List <TVItemModel> tvItemModelSubsectorBCList = tvItemServiceR.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelBC.TVItemID, TVTypeEnum.Subsector); if (tvItemModelSubsectorBCList.Count == 0) { richTextBoxStatus.AppendText("Could not find TVItem Subsector under British Columbia\r\n"); return(false); } lblStatus.Text = "Starting ... LoadStationsBC"; Application.DoEvents(); int StartBCCreateStationBC = int.Parse(textBoxBCCreateStationsBC.Text); List <BCStation> BCWQMSiteList = new List <BCStation>(); TVItemModel TVItemModelSubsectorBC = new TVItemModel(); List <TT> tideTextInDBList = new List <TT>(); List <AM> analyseMethodInDBList = new List <AM>(); List <Mat> matrixInDBList = new List <Mat>(); List <Lab> labInDBList = new List <Lab>(); int TotalCount = tvItemModelSubsectorBCList.Count(); int Count = 0; foreach (TVItemModel tvItemModelSubsector in tvItemModelSubsectorBCList) { if (Cancel) { return(false); } Count += 1; lblStatus.Text = (Count * 100 / TotalCount).ToString() + " ... CreateStationsBC for " + tvItemModelSubsector.TVText; lblStatus2.Text = Count + " of " + TotalCount; Application.DoEvents(); textBoxBCCreateStationsBC.Text = Count.ToString(); if (StartBCCreateStationBC > Count) { continue; } // doing Land base stations List <TempData.BCLandSampleStation> bcLandSampleStation = new List <TempData.BCLandSampleStation>(); using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities()) { string TVText = tvItemModelSubsector.TVText.Substring(0, 4); bcLandSampleStation = (from c in dbDT.BCLandSampleStations where c.SS_SHELLFI == TVText orderby c.BCLandSampleStationID select c).ToList <TempData.BCLandSampleStation>(); } int CountSta = 0; int TotalCountSta = bcLandSampleStation.Count; foreach (TempData.BCLandSampleStation bcmss in bcLandSampleStation) { if (Cancel) { return(false); } CountSta += 1; lblStatus2.Text = "Doing Land Base ... " + CountSta + " of " + TotalCountSta; Application.DoEvents(); string TVText = bcmss.SS_STATION; TVItemService tvItemService = new TVItemService(LanguageEnum.en, user); MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user); MWQMSiteService mwqmSiteService = new MWQMSiteService(LanguageEnum.en, user); TVItemModel tvItemModelMWQMSite = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelSubsector.TVItemID, TVText, TVTypeEnum.MWQMSite); if (!string.IsNullOrWhiteSpace(tvItemModelMWQMSite.Error)) { tvItemModelMWQMSite = tvItemService.PostCreateTVItem(tvItemModelSubsector.TVItemID, TVText, TVText, TVTypeEnum.MWQMSite); if (!CheckModelOK <TVItemModel>(tvItemModelMWQMSite)) { return(false); } List <Coord> coordList2 = new List <Coord>() { new Coord() { Lat = (float)(bcmss.LAT == null ? 50.0f : bcmss.LAT), Lng = (float)(bcmss.LON == null ? -132.0f : bcmss.LON), } }; if (coordList2[0].Lat == 124.40966796875 && coordList2[0].Lng == -48.585498809814453) { coordList2[0].Lat = 48.585498809814453f; coordList2[0].Lng = -124.40966796875f; } MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList2, MapInfoDrawTypeEnum.Point, TVTypeEnum.MWQMSite, tvItemModelMWQMSite.TVItemID); if (!CheckModelOK <MapInfoModel>(mapInfoModelRet)) { return(false); } MWQMSiteModel mwqmSiteModelNew = new MWQMSiteModel() { MWQMSiteTVItemID = tvItemModelMWQMSite.TVItemID, MWQMSiteNumber = bcmss.SS_STATION.ToString(), MWQMSiteTVText = TVText, MWQMSiteDescription = "empty", }; MWQMSiteModel mwqmSiteModelRet = mwqmSiteService.PostAddMWQMSiteDB(mwqmSiteModelNew); if (!CheckModelOK <MWQMSiteModel>(mwqmSiteModelRet)) { return(false); } } } // doing Marine base stations List <TempData.BCMarineSampleStation> bcMarineSampleStation = new List <TempData.BCMarineSampleStation>(); using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities()) { string TVText = tvItemModelSubsector.TVText.Substring(0, 4); bcMarineSampleStation = (from c in dbDT.BCMarineSampleStations where c.SS_SHELLFI == TVText orderby c.BCMarineSampleStationID select c).ToList <TempData.BCMarineSampleStation>(); } CountSta = 0; TotalCountSta = bcMarineSampleStation.Count; foreach (TempData.BCMarineSampleStation bcmss in bcMarineSampleStation) { if (Cancel) { return(false); } CountSta += 1; lblStatus2.Text = "Doing Marine Base ... " + CountSta + " of " + TotalCountSta; Application.DoEvents(); string TVText = bcmss.SS_STATION; TVItemService tvItemService = new TVItemService(LanguageEnum.en, user); MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user); MWQMSiteService mwqmSiteService = new MWQMSiteService(LanguageEnum.en, user); TVItemModel tvItemModelMWQMSite = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelSubsector.TVItemID, TVText, TVTypeEnum.MWQMSite); if (!string.IsNullOrWhiteSpace(tvItemModelMWQMSite.Error)) { tvItemModelMWQMSite = tvItemService.PostCreateTVItem(tvItemModelSubsector.TVItemID, TVText, TVText, TVTypeEnum.MWQMSite); if (!CheckModelOK <TVItemModel>(tvItemModelMWQMSite)) { return(false); } List <Coord> coordList2 = new List <Coord>() { new Coord() { Lat = (float)(bcmss.LAT == null ? 50.0f : bcmss.LAT), Lng = (float)(bcmss.LON == null ? -132.0f : bcmss.LON), } }; MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList2, MapInfoDrawTypeEnum.Point, TVTypeEnum.MWQMSite, tvItemModelMWQMSite.TVItemID); if (!CheckModelOK <MapInfoModel>(mapInfoModelRet)) { return(false); } MWQMSiteModel mwqmSiteModelNew = new MWQMSiteModel() { MWQMSiteTVItemID = tvItemModelMWQMSite.TVItemID, MWQMSiteNumber = bcmss.SS_STATION.ToString(), MWQMSiteTVText = TVText, MWQMSiteDescription = "empty", }; MWQMSiteModel mwqmSiteModelRet = mwqmSiteService.PostAddMWQMSiteDB(mwqmSiteModelNew); if (!CheckModelOK <MWQMSiteModel>(mwqmSiteModelRet)) { return(false); } } } } return(true); }
public JsonResult MWQMSiteSaveAllJSON(FormCollection fc) { MWQMSiteModel mwqmSiteModel = _MWQMSiteService.MWQMSiteSaveAllDB(fc); return(Json(mwqmSiteModel.Error, JsonRequestBehavior.AllowGet)); }
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); }