public RainExceedanceClimateSite GetRainExceedanceClimateSiteExistDB(RainExceedanceClimateSiteModel rainExceedanceClimateSiteModel) { RainExceedanceClimateSite rainExceedanceClimateSite = (from c in db.RainExceedanceClimateSites where c.RainExceedanceTVItemID == rainExceedanceClimateSiteModel.RainExceedanceTVItemID && c.ClimateSiteTVItemID == rainExceedanceClimateSiteModel.ClimateSiteTVItemID select c).FirstOrDefault <RainExceedanceClimateSite>(); return(rainExceedanceClimateSite); }
public RainExceedanceClimateSiteModel PostAddRainExceedanceClimateSiteDB(RainExceedanceClimateSiteModel rainExceedanceClimateSiteModel) { string retStr = RainExceedanceClimateSiteModelOK(rainExceedanceClimateSiteModel); if (!string.IsNullOrEmpty(retStr)) { return(ReturnError(retStr)); } ContactOK contactOK = IsContactOK(); if (!string.IsNullOrEmpty(contactOK.Error)) { return(ReturnError(contactOK.Error)); } RainExceedanceClimateSite rainExceedanceClimateSiteExist = GetRainExceedanceClimateSiteExistDB(rainExceedanceClimateSiteModel); if (rainExceedanceClimateSiteExist != null) { return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.RainExceedanceClimateSite))); } RainExceedanceClimateSite rainExceedanceClimateSiteNew = new RainExceedanceClimateSite(); retStr = FillRainExceedanceClimateSite(rainExceedanceClimateSiteNew, rainExceedanceClimateSiteModel, contactOK); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } using (TransactionScope ts = new TransactionScope()) { db.RainExceedanceClimateSites.Add(rainExceedanceClimateSiteNew); retStr = DoAddChanges(); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } LogModel logModel = _LogService.PostAddLogForObj("RainExceedanceClimateSites", rainExceedanceClimateSiteNew.RainExceedanceClimateSiteID, LogCommandEnum.Add, rainExceedanceClimateSiteNew); if (!string.IsNullOrWhiteSpace(logModel.Error)) { return(ReturnError(logModel.Error)); } ts.Complete(); } return(GetRainExceedanceClimateSiteModelWithRainExceedanceClimateSiteIDDB(rainExceedanceClimateSiteNew.RainExceedanceClimateSiteID)); }
public RainExceedanceClimateSiteModel PostUpdateRainExceedanceClimateSiteDB(RainExceedanceClimateSiteModel rainExceedanceClimateSiteModel) { string retStr = RainExceedanceClimateSiteModelOK(rainExceedanceClimateSiteModel); if (!string.IsNullOrEmpty(retStr)) { return(ReturnError(retStr)); } ContactOK contactOK = IsContactOK(); if (!string.IsNullOrEmpty(contactOK.Error)) { return(ReturnError(contactOK.Error)); } RainExceedanceClimateSite rainExceedanceClimateSiteToUpdate = GetRainExceedanceClimateSiteWithRainExceedanceClimateSiteIDDB(rainExceedanceClimateSiteModel.RainExceedanceClimateSiteID); if (rainExceedanceClimateSiteToUpdate == null) { return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.RainExceedanceClimateSite))); } retStr = FillRainExceedanceClimateSite(rainExceedanceClimateSiteToUpdate, rainExceedanceClimateSiteModel, 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("RainExceedanceClimateSites", rainExceedanceClimateSiteToUpdate.RainExceedanceClimateSiteID, LogCommandEnum.Change, rainExceedanceClimateSiteToUpdate); if (!string.IsNullOrWhiteSpace(logModel.Error)) { return(ReturnError(logModel.Error)); } ts.Complete(); } return(GetRainExceedanceClimateSiteModelWithRainExceedanceClimateSiteIDDB(rainExceedanceClimateSiteToUpdate.RainExceedanceClimateSiteID)); }
public RainExceedanceClimateSiteModel GetRainExceedanceClimateSiteModelWithRainExceedanceClimateSiteIDDB(int RainExceedanceClimateSiteID) { RainExceedanceClimateSiteModel rainExceedanceClimateSiteModel = (from c in db.RainExceedanceClimateSites where c.RainExceedanceClimateSiteID == RainExceedanceClimateSiteID select new RainExceedanceClimateSiteModel { Error = "", RainExceedanceClimateSiteID = c.RainExceedanceClimateSiteID, DBCommand = (DBCommandEnum)c.DBCommand, RainExceedanceTVItemID = c.RainExceedanceTVItemID, ClimateSiteTVItemID = c.ClimateSiteTVItemID, LastUpdateDate_UTC = c.LastUpdateDate_UTC, LastUpdateContactTVItemID = c.LastUpdateContactTVItemID, }).FirstOrDefault <RainExceedanceClimateSiteModel>(); if (rainExceedanceClimateSiteModel == null) { return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.RainExceedanceClimateSite, ServiceRes.RainExceedanceClimateSiteID, RainExceedanceClimateSiteID))); } return(rainExceedanceClimateSiteModel); }
// Check public string RainExceedanceClimateSiteModelOK(RainExceedanceClimateSiteModel rainExceedanceClimateSiteModel) { string retStr = FieldCheckNotZeroInt(rainExceedanceClimateSiteModel.RainExceedanceTVItemID, ServiceRes.RainExceedanceTVItemID); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotZeroInt(rainExceedanceClimateSiteModel.ClimateSiteTVItemID, ServiceRes.ClimateSiteTVItemID); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = _BaseEnumService.DBCommandOK(rainExceedanceClimateSiteModel.DBCommand); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } return(""); }
public JsonResult RainExceedanceAddUseClimateSiteJSON(int RainExceedanceTVItemID, int ClimateSiteTVItemID, bool Use) { RainExceedanceClimateSiteModel rainExceedanceClimateSiteModel = _RainExceedanceClimateSiteService.PostRainExceedanceClimateSiteSaveDB(RainExceedanceTVItemID, ClimateSiteTVItemID, Use); return(Json(rainExceedanceClimateSiteModel.Error, JsonRequestBehavior.AllowGet)); }
// Fill public string FillRainExceedanceClimateSite(RainExceedanceClimateSite rainExceedanceClimateSiteNew, RainExceedanceClimateSiteModel rainExceedanceClimateSiteModel, ContactOK contactOK) { rainExceedanceClimateSiteNew.DBCommand = (int)rainExceedanceClimateSiteModel.DBCommand; rainExceedanceClimateSiteNew.RainExceedanceTVItemID = rainExceedanceClimateSiteModel.RainExceedanceTVItemID; rainExceedanceClimateSiteNew.ClimateSiteTVItemID = rainExceedanceClimateSiteModel.ClimateSiteTVItemID; rainExceedanceClimateSiteNew.LastUpdateDate_UTC = DateTime.UtcNow; if (contactOK == null) { rainExceedanceClimateSiteNew.LastUpdateContactTVItemID = 2; } else { rainExceedanceClimateSiteNew.LastUpdateContactTVItemID = contactOK.ContactTVItemID; } return(""); }
// Post public RainExceedanceClimateSiteModel PostRainExceedanceClimateSiteSaveDB(int RainExceedanceTVItemID, int ClimateSiteTVItemID, bool Use) { ContactOK contactOK = IsContactOK(); if (!string.IsNullOrWhiteSpace(contactOK.Error)) { return(ReturnError(contactOK.Error)); } RainExceedanceClimateSiteModel RainExceedanceClimateSiteModelRet = new RainExceedanceClimateSiteModel(); using (TransactionScope ts = new TransactionScope()) { if (Use) { RainExceedanceClimateSiteModel rainExceedanceClimateSiteModelNew = new RainExceedanceClimateSiteModel() { DBCommand = DBCommandEnum.Original, RainExceedanceTVItemID = RainExceedanceTVItemID, ClimateSiteTVItemID = ClimateSiteTVItemID, }; RainExceedanceClimateSite rainExceedanceClimateSite = GetRainExceedanceClimateSiteExistDB(rainExceedanceClimateSiteModelNew); if (rainExceedanceClimateSite == null) { RainExceedanceClimateSiteModelRet = PostAddRainExceedanceClimateSiteDB(rainExceedanceClimateSiteModelNew); if (!string.IsNullOrWhiteSpace(RainExceedanceClimateSiteModelRet.Error)) { return(ReturnError(RainExceedanceClimateSiteModelRet.Error)); } } } else { RainExceedanceClimateSiteModel rainExceedanceClimateSiteModelNew = new RainExceedanceClimateSiteModel() { DBCommand = DBCommandEnum.Original, RainExceedanceTVItemID = RainExceedanceTVItemID, ClimateSiteTVItemID = ClimateSiteTVItemID, }; RainExceedanceClimateSite rainExceedanceClimateSite = GetRainExceedanceClimateSiteExistDB(rainExceedanceClimateSiteModelNew); if (rainExceedanceClimateSite == null) { return(ReturnError(ServiceRes.CouldNotFindClimateSiteToRemoveFromRainExceedance)); } else { RainExceedanceClimateSiteModelRet = PostDeleteRainExceedanceClimateSiteDB(rainExceedanceClimateSite.RainExceedanceClimateSiteID); if (!string.IsNullOrWhiteSpace(RainExceedanceClimateSiteModelRet.Error)) { return(ReturnError(RainExceedanceClimateSiteModelRet.Error)); } } } ts.Complete(); } return(RainExceedanceClimateSiteModelRet); }