Esempio n. 1
0
        private DataKey CreateDataKey(int customerId, Meter newMeter)
        {
            // Get customer TimeZoneId
            var customerProfile = RbacEntities.CustomerProfiles.FirstOrDefault(m => m.CustomerId == customerId);

            newMeter.TimeZoneID = customerProfile.TimeZoneID ?? 0;

            // Create an audit entry.
            Audit(newMeter);

            // Create a datakey
            var newItem = new DataKey()
            {
                //todo - GTC: DataKeys add dataKeyname here when db field is added - might have to pass in the datakey name
                DataKeyId       = newMeter.MeterId,//this is auto increment field, so thats why we have the datakeyidnumber field
                DataKeyIdNumber = newMeter.MeterId,
                CustomerID      = customerId,
            };

            PemsEntities.DataKeys.Add(newItem);
            PemsEntities.SaveChanges();

            // Add audit record
            Audit(newItem);

            //  Need a [HousingMaster]
            HousingMaster housingMaster = PemsEntities.HousingMasters.FirstOrDefault(m => m.HousingName.Equals("Default"));

            // Create a MeterMap record to join datakey and Meter
            MeterMap meterMap = new MeterMap()
            {
                Customerid = newMeter.CustomerID,
                Areaid     = newMeter.AreaID,
                MeterId    = newMeter.MeterId,
                DataKeyId  = newItem.DataKeyId,
                HousingId  = housingMaster.HousingId
            };

            PemsEntities.MeterMaps.Add(meterMap);
            PemsEntities.SaveChanges();
            return(newItem);
        }
Esempio n. 2
0
 public HousingController(HousingMaster housingMaster, HousingConfig housingConfig, HousingData housingData)
 {
     this.housingMaster = housingMaster;
     this.housingConfig = housingConfig;
     this.housingData   = housingData;
 }
Esempio n. 3
0
        private int Clone(int customerId, Int64 assetId)
        {
            // Get original datakey and its associated Meter and MeterMap
            // Since this exists, these entities should exist also.
            DataKey dataKey = PemsEntities.DataKeys.FirstOrDefault(m => m.DataKeyId == assetId);

            if (dataKey != null)
            {
                MeterMap meterMap = dataKey.MeterMaps.FirstOrDefault(m => m.DataKeyId == dataKey.DataKeyId);
                if (meterMap != null)
                {
                    Meter meter = meterMap.Meter;

                    // Create the new meter that is associated with the datakey type of asset.  This is not a meter
                    // but rather a an asset in the meter table that represents a datakey.
                    Meter newMeter = CreateBaseAsset(meter.CustomerID, MeterGroups.Datakey, meter.AreaID);

                    // Create a datakey
                    var clonedItem = new DataKey()
                    {
                        //todo - GTC: DataKeys add datakeyname here when db field is added
                        DataKeyDesc = dataKey.DataKeyDesc,
                        DataKeyId   = newMeter.MeterId,
                        //this is auto increment, so it wont save the value, its why we have the datakeyidnumber column.
                        DataKeyIdNumber = newMeter.MeterId,
                        DataKeyType     = dataKey.DataKeyType,
                        CustomerID      = customerId
                    };

                    PemsEntities.DataKeys.Add(clonedItem);
                    PemsEntities.SaveChanges();

                    // Add AssetPending record
                    (new PendingFactory(ConnectionStringName, Now)).SetImportPending(
                        AssetTypeModel.AssetType.DataKey, SetToMidnight(Now), AssetStateType.Current, customerId,
                        clonedItem.DataKeyIdNumber.GetValueOrDefault(), (int)AssetStateType.Pending, (int)OperationalStatusType.Inactive, (int)AssetAreaId.DataKey);

                    // Align clonable meter fields.
                    newMeter.Location                    = meter.Location;
                    newMeter.DemandZone                  = meter.DemandZone;
                    newMeter.FreeParkingMinute           = meter.FreeParkingMinute;
                    newMeter.MeterGroup                  = meter.MeterGroup;
                    newMeter.MeterName                   = meter.MeterName;
                    newMeter.MeterType                   = meter.MeterType;
                    newMeter.TimeZoneID                  = meter.TimeZoneID;
                    newMeter.TypeCode                    = meter.TypeCode;
                    newMeter.WarrantyExpiration          = meter.WarrantyExpiration;
                    newMeter.NextPreventativeMaintenance = meter.NextPreventativeMaintenance;

                    // Create meter map for cloned item.
                    //  Need a [HousingMaster]
                    HousingMaster housingMaster =
                        PemsEntities.HousingMasters.FirstOrDefault(m => m.HousingName.Equals("Default"));

                    // Create a [MeterMap] entry
                    MeterMap newMeterMap = new MeterMap()
                    {
                        Customerid = newMeter.CustomerID,
                        Areaid     = newMeter.AreaID,
                        MeterId    = newMeter.MeterId,
                        DataKeyId  = clonedItem.DataKeyId,
                        HousingId  = housingMaster.HousingId
                    };
                    PemsEntities.MeterMaps.Add(newMeterMap);
                    PemsEntities.SaveChanges();

                    newMeterMap.AreaId2      = meterMap.AreaId2;
                    newMeterMap.ZoneId       = meterMap.ZoneId;
                    newMeterMap.SubAreaID    = meterMap.SubAreaID;
                    newMeterMap.CustomGroup1 = meterMap.CustomGroup1;
                    newMeterMap.CustomGroup2 = meterMap.CustomGroup2;
                    newMeterMap.CustomGroup3 = meterMap.CustomGroup3;
                    newMeterMap.MaintRouteId = meterMap.MaintRouteId;

                    PemsEntities.SaveChanges();

                    // Set audit records.
                    Audit(newMeter);
                    Audit(newMeterMap);
                    Audit(clonedItem);

                    return(clonedItem.DataKeyIdNumber.GetValueOrDefault());
                }
            }
            return(0);
        }