Beispiel #1
0
        // Fill
        public string FillClimateDataValue(ClimateDataValue climateDataValueNew, ClimateDataValueModel climateDataValueModel, ContactOK contactOK)
        {
            climateDataValueNew.DBCommand          = (int)climateDataValueModel.DBCommand;
            climateDataValueNew.ClimateSiteID      = climateDataValueModel.ClimateSiteID;
            climateDataValueNew.DateTime_Local     = climateDataValueModel.DateTime_Local;
            climateDataValueNew.Keep               = climateDataValueModel.Keep;
            climateDataValueNew.StorageDataType    = (int)climateDataValueModel.StorageDataType;
            climateDataValueNew.HasBeenRead        = climateDataValueModel.HasBeenRead;
            climateDataValueNew.CoolDegDays_C      = climateDataValueModel.CoolDegDays_C;
            climateDataValueNew.DirMaxGust_0North  = climateDataValueModel.DirMaxGust_0North;
            climateDataValueNew.HeatDegDays_C      = climateDataValueModel.HeatDegDays_C;
            climateDataValueNew.MaxTemp_C          = climateDataValueModel.MaxTemp_C;
            climateDataValueNew.MinTemp_C          = climateDataValueModel.MinTemp_C;
            climateDataValueNew.Rainfall_mm        = climateDataValueModel.Rainfall_mm;
            climateDataValueNew.RainfallEntered_mm = climateDataValueModel.RainfallEntered_mm;
            climateDataValueNew.Snow_cm            = climateDataValueModel.Snow_cm;
            climateDataValueNew.SnowOnGround_cm    = climateDataValueModel.SnowOnGround_cm;
            climateDataValueNew.SpdMaxGust_kmh     = climateDataValueModel.SpdMaxGust_kmh;
            climateDataValueNew.TotalPrecip_mm_cm  = climateDataValueModel.TotalPrecip_mm_cm;
            climateDataValueNew.HourlyValues       = climateDataValueModel.HourlyValues;
            climateDataValueNew.LastUpdateDate_UTC = DateTime.UtcNow;
            if (contactOK == null)
            {
                climateDataValueNew.LastUpdateContactTVItemID = 2;
            }
            else
            {
                climateDataValueNew.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
            }

            return("");
        }
Beispiel #2
0
        // Post
        public ClimateDataValueModel PostAddClimateDataValueDB(ClimateDataValueModel climateDataValueModel)
        {
            string retStr = ClimateDataValueModelOK(climateDataValueModel);

            if (!string.IsNullOrEmpty(retStr))
            {
                return(ReturnError(retStr));
            }

            ContactOK contactOK = IsContactOK();

            if (!string.IsNullOrEmpty(contactOK.Error))
            {
                return(ReturnError(contactOK.Error));
            }

            ClimateDataValueModel climateDataValueModelExist = GetClimateDataValueModelExitDB(climateDataValueModel);

            if (string.IsNullOrWhiteSpace(climateDataValueModelExist.Error))
            {
                return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.ClimateDataValue)));
            }

            ClimateDataValue climateDataValueNew = new ClimateDataValue();

            retStr = FillClimateDataValue(climateDataValueNew, climateDataValueModel, contactOK);
            if (!string.IsNullOrWhiteSpace(retStr))
            {
                return(ReturnError(retStr));
            }

            using (TransactionScope ts = new TransactionScope())
            {
                db.ClimateDataValues.Add(climateDataValueNew);
                retStr = DoAddChanges();
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(ReturnError(retStr));
                }

                LogModel logModel = _LogService.PostAddLogForObj("ClimateDataValues", climateDataValueNew.ClimateDataValueID, LogCommandEnum.Add, climateDataValueNew);
                if (!string.IsNullOrWhiteSpace(logModel.Error))
                {
                    return(ReturnError(logModel.Error));
                }

                ts.Complete();
            }

            return(GetClimateDataValueModelWithClimateDataValueIDDB(climateDataValueNew.ClimateDataValueID));
        }
Beispiel #3
0
        public ClimateDataValueModel PostUpdateClimateDataValueDB(ClimateDataValueModel climateDataValueModel)
        {
            string retStr = ClimateDataValueModelOK(climateDataValueModel);

            if (!string.IsNullOrEmpty(retStr))
            {
                return(ReturnError(retStr));
            }

            ContactOK contactOK = IsContactOK();

            if (!string.IsNullOrEmpty(contactOK.Error))
            {
                return(ReturnError(contactOK.Error));
            }

            ClimateDataValue climateDataValueToUpdate = GetClimateDataValueWithClimateDataValueIDDB(climateDataValueModel.ClimateDataValueID);

            if (climateDataValueToUpdate == null)
            {
                return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.ClimateDataValue)));
            }

            retStr = FillClimateDataValue(climateDataValueToUpdate, climateDataValueModel, 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("ClimateDataValues", climateDataValueToUpdate.ClimateDataValueID, LogCommandEnum.Change, climateDataValueToUpdate);
                if (!string.IsNullOrWhiteSpace(logModel.Error))
                {
                    return(ReturnError(logModel.Error));
                }

                ts.Complete();
            }
            return(GetClimateDataValueModelWithClimateDataValueIDDB(climateDataValueToUpdate.ClimateDataValueID));
        }
Beispiel #4
0
        public ClimateDataValueModel GetClimateDataValueModelExitDB(ClimateDataValueModel climateDataValueModel)
        {
            ClimateDataValueModel climateDataValueModelRet = (from c in db.ClimateDataValues
                                                              where c.ClimateSiteID == climateDataValueModel.ClimateSiteID &&
                                                              c.DateTime_Local == climateDataValueModel.DateTime_Local
                                                              select new ClimateDataValueModel
            {
                Error = "",
                ClimateSiteID = c.ClimateSiteID,
                DBCommand = (DBCommandEnum)c.DBCommand,
                ClimateDataValueID = c.ClimateDataValueID,
                DateTime_Local = c.DateTime_Local,
                Keep = c.Keep,
                StorageDataType = (StorageDataTypeEnum)c.StorageDataType,
                HasBeenRead = c.HasBeenRead,
                CoolDegDays_C = c.CoolDegDays_C,
                DirMaxGust_0North = c.DirMaxGust_0North,
                HeatDegDays_C = c.HeatDegDays_C,
                MaxTemp_C = c.MaxTemp_C,
                MinTemp_C = c.MinTemp_C,
                Rainfall_mm = c.Rainfall_mm,
                RainfallEntered_mm = c.RainfallEntered_mm,
                Snow_cm = c.Snow_cm,
                SnowOnGround_cm = c.SnowOnGround_cm,
                SpdMaxGust_kmh = c.SpdMaxGust_kmh,
                TotalPrecip_mm_cm = c.TotalPrecip_mm_cm,
                HourlyValues = c.HourlyValues,
                LastUpdateDate_UTC = c.LastUpdateDate_UTC,
                LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
            }).FirstOrDefault <ClimateDataValueModel>();

            if (climateDataValueModelRet == null)
            {
                return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.ClimateDataValue,
                                                 ServiceRes.ClimateSiteID + "," +
                                                 ServiceRes.DateTime_Local,
                                                 climateDataValueModel.ClimateSiteID.ToString() + "," +
                                                 climateDataValueModel.DateTime_Local
                                                 )));
            }

            return(climateDataValueModelRet);
        }
Beispiel #5
0
        // Check
        public string ClimateDataValueModelOK(ClimateDataValueModel climateDataValueModel)
        {
            string retStr = FieldCheckNotZeroInt(climateDataValueModel.ClimateSiteID, ServiceRes.ClimateSiteID);

            if (!string.IsNullOrWhiteSpace(retStr))
            {
                return(retStr);
            }

            retStr = FieldCheckNotNullDateTime(climateDataValueModel.DateTime_Local, ServiceRes.DateTime_Local);
            if (!string.IsNullOrWhiteSpace(retStr))
            {
                return(retStr);
            }

            retStr = FieldCheckNotNullBool(climateDataValueModel.Keep, ServiceRes.Keep);
            if (!string.IsNullOrWhiteSpace(retStr))
            {
                return(retStr);
            }

            retStr = _BaseEnumService.StorageDataTypeOK(climateDataValueModel.StorageDataType);
            if (!string.IsNullOrWhiteSpace(retStr))
            {
                return(retStr);
            }

            retStr = FieldCheckNotNullBool(climateDataValueModel.HasBeenRead, ServiceRes.HasBeenRead);
            if (!string.IsNullOrWhiteSpace(retStr))
            {
                return(retStr);
            }

            if (climateDataValueModel.Snow_cm != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.Snow_cm, ServiceRes.Snow_cm, 0, 10000);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.Rainfall_mm != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.Rainfall_mm, ServiceRes.Rainfall_mm, 0, 1000);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.RainfallEntered_mm != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.RainfallEntered_mm, ServiceRes.RainfallEntered_mm, 0, 1000);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.TotalPrecip_mm_cm != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.TotalPrecip_mm_cm, ServiceRes.TotalPrecip_mm_cm, 0, 1000);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.MaxTemp_C != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.MaxTemp_C, ServiceRes.MaxTemp_C, -45, 45);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.MinTemp_C != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.MinTemp_C, ServiceRes.MinTemp_C, -45, 45);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.HeatDegDays_C != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.HeatDegDays_C, ServiceRes.HeatDegDays_C, 0, 45);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.CoolDegDays_C != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.CoolDegDays_C, ServiceRes.CoolDegDays_C, 0, 45);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.SnowOnGround_cm != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.SnowOnGround_cm, ServiceRes.SnowOnGround_cm, 0, 10000);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.DirMaxGust_0North != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.DirMaxGust_0North, ServiceRes.DirMaxGust_0North, 0, 360);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            if (climateDataValueModel.SpdMaxGust_kmh != null)
            {
                retStr = FieldCheckIfNotNullWithinRangeDouble(climateDataValueModel.SpdMaxGust_kmh, ServiceRes.SpdMaxGust_kmh, 0, 200);
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(retStr);
                }
            }

            retStr = _BaseEnumService.DBCommandOK(climateDataValueModel.DBCommand);
            if (!string.IsNullOrWhiteSpace(retStr))
            {
                return(retStr);
            }

            return("");
        }