public void DeleteAttribute(int loadId, int?resourcePlanId, int?phaseId)
        {
            LoadAttribute loadAttribute = this.Context.LoadAttributes.FirstOrDefault(la => la.LoadId == loadId &&
                                                                                     la.ResourcePlanId == resourcePlanId &&
                                                                                     la.ProjectPhaseId == phaseId);

            if (loadAttribute == null)
            {
                return;
            }
            this.Context.LoadAttributes.DeleteOnSubmit(loadAttribute);
            this.Context.SubmitChanges();
        }
        /// <summary>
        /// Inserts any new LoadAttribute object to Db or updates an existing LoadAttribute object (based on LoadId and ResourcePlanId)
        /// </summary>
        /// <param name="LoadAttribute">LoadAttribute object</param>
        public void SaveLoadAttribute(LoadAttribute loadAttribute)
        {
            LoadAttribute currentLoadAttribute = this.Context.LoadAttributes.FirstOrDefault(la => la.LoadId == loadAttribute.LoadId && la.ResourcePlanId == loadAttribute.ResourcePlanId && !la.ProjectPhaseId.HasValue);

            if (currentLoadAttribute != null)
            {
                UpdateLoadAttribute(currentLoadAttribute, loadAttribute);
            }
            else
            {
                this.Context.LoadAttributes.InsertOnSubmit(loadAttribute);
            }
            this.Context.SubmitChanges();
        }
        /// <summary>
        /// Inserts any new LoadAttribute object to Db or updates an existing LoadAttribute object (based on LoadId and ResourcePlanId)
        /// </summary>
        /// <param name="LoadAttribute">LoadAttribute object</param>
        public void Save(LoadAttribute la)
        {
            LoadAttribute currentLa = this.Context.LoadAttributes.FirstOrDefault(lat => lat.LoadId == la.Id && lat.ResourcePlanId == la.ResourcePlanId && (!lat.ProjectPhaseId.HasValue || lat.ProjectPhaseId == la.ProjectPhaseId));

            if (currentLa != null)
            {
                UpdateLoadAttribute(currentLa, la);
            }
            else
            {
                this.Context.LoadAttributes.InsertOnSubmit(la);
            }
            this.Context.SubmitChanges();
        }
        /// <summary>
        /// Inserts any new LoadAttribute object to Db or updates an existing LoadAttribute object (based on LoadId, ResourcePlanId & ProjectPhaseId)
        /// </summary>
        /// <param name="LoadAttribute">LoadAttribute object</param>
        public bool SaveLoadAttributeAgainstPhase(LoadAttribute loadAttribute)
        {
            bool          isNewToPhase         = false;
            LoadAttribute currentLoadAttribute = this.Context.LoadAttributes.FirstOrDefault(la => la.LoadId == loadAttribute.LoadId &&
                                                                                            la.ResourcePlanId == loadAttribute.ResourcePlanId &&
                                                                                            la.ProjectPhaseId == loadAttribute.ProjectPhaseId);

            if (currentLoadAttribute != null)
            {
                UpdateLoadAttribute(currentLoadAttribute, loadAttribute);
            }
            else
            {
                this.Context.LoadAttributes.InsertOnSubmit(loadAttribute);
                isNewToPhase = true;
            }
            this.Context.SubmitChanges();
            return(isNewToPhase);
        }
 private void UpdateLoadAttribute(LoadAttribute currentLoadAttribute, LoadAttribute newLoadAttribute)
 {
     currentLoadAttribute.UserUpdatedId       = newLoadAttribute.UserCreatedId;
     currentLoadAttribute.DateUpdated         = newLoadAttribute.DateCreated;
     currentLoadAttribute.DateEffective       = newLoadAttribute.DateEffective;
     currentLoadAttribute.DateEnd             = newLoadAttribute.DateEnd;
     currentLoadAttribute.DateReplaced        = newLoadAttribute.DateReplaced;
     currentLoadAttribute.InServiceEndDate    = newLoadAttribute.InServiceEndDate;
     currentLoadAttribute.InServiceStartDate  = newLoadAttribute.InServiceStartDate;
     currentLoadAttribute.LoadGrossSummerMin  = newLoadAttribute.LoadGrossSummerMin;
     currentLoadAttribute.LoadGrossSummerPeak = newLoadAttribute.LoadGrossSummerPeak;
     currentLoadAttribute.LoadGrossWinterMin  = newLoadAttribute.LoadGrossWinterMin;
     currentLoadAttribute.LoadGrossWinterPeak = newLoadAttribute.LoadGrossWinterPeak;
     currentLoadAttribute.LoadMw        = newLoadAttribute.LoadMw;
     currentLoadAttribute.PowerFactor   = newLoadAttribute.PowerFactor;
     currentLoadAttribute.Probability   = newLoadAttribute.Probability;
     currentLoadAttribute.ESALoadDemand = newLoadAttribute.ESALoadDemand;
     currentLoadAttribute.LoadGbl       = newLoadAttribute.LoadGbl;
     newLoadAttribute.Id = currentLoadAttribute.Id;
 }
        /// <summary>
        /// Inserts any new LoadAttribute object to Db or updates an existing LoadAttribute object (based on LoadId, ResourcePlanId & ProjectPhaseId)
        /// Updates input reference param currentGeneratorAttribute with pre update state.  currentLoadAttribute remains null when the object is new
        /// </summary>
        /// <param name="LoadAttribute">LoadAttribute object</param>
        public bool SaveLoadAttributeAgainstPhase(LoadAttribute newLoadAttribute, ref LoadAttribute currentLoadAttribute)
        {
            bool          isNewToPhase           = false;
            LoadAttribute exisitingLoadAttribute = this.Context.LoadAttributes.FirstOrDefault(la => la.LoadId == newLoadAttribute.LoadId &&
                                                                                              la.ResourcePlanId == newLoadAttribute.ResourcePlanId &&
                                                                                              la.ProjectPhaseId == newLoadAttribute.ProjectPhaseId);

            if (exisitingLoadAttribute != null)
            {
                currentLoadAttribute = exisitingLoadAttribute.Clone();
                UpdateLoadAttribute(exisitingLoadAttribute, newLoadAttribute);
            }
            else
            {
                this.Context.LoadAttributes.InsertOnSubmit(newLoadAttribute);
                isNewToPhase = true;
            }
            this.Context.SubmitChanges();
            return(isNewToPhase);
        }
Beispiel #7
0
        public LoadAttribute Clone()
        {
            LoadAttribute clone = new LoadAttribute();

            clone.LoadId              = this.LoadId;
            clone.ResourcePlanId      = this.ResourcePlanId;
            clone.ProjectPhaseId      = this.ProjectPhaseId;
            clone.DateEffective       = this.DateEffective;
            clone.DateEnd             = this.DateEnd;
            clone.DateReplaced        = this.DateReplaced;
            clone.InServiceEndDate    = this.InServiceEndDate;
            clone.InServiceStartDate  = this.InServiceStartDate;
            clone.LoadGrossSummerMin  = this.LoadGrossSummerMin;
            clone.LoadGrossSummerPeak = this.LoadGrossSummerPeak;
            clone.LoadGrossWinterMin  = this.LoadGrossWinterMin;
            clone.LoadGrossWinterPeak = this.LoadGrossWinterPeak;
            clone.LoadMw              = this.LoadMw;
            clone.PowerFactor         = this.PowerFactor;
            clone.Probability         = this.Probability;
            clone.ESALoadDemand       = this.ESALoadDemand;
            clone.LoadGbl             = this.LoadGbl;
            return(clone);
        }