//public ElectricityPurchaseAgreement() //{ // this.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EpicDB"].ConnectionString; //} /// <summary> /// Return a non-persistable clone of the EPA object /// </summary> /// <returns></returns> public ElectricityPurchaseAgreement Clone() { ElectricityPurchaseAgreement clone = new ElectricityPurchaseAgreement(); clone.Code = this.Code; clone.NitsDesignatedCapacity = this.NitsDesignatedCapacity; clone.EPACapacity = this.EPACapacity; clone.EPAStatusId = this.EPAStatusId; clone.EstimatedInServiceDate = this.EstimatedInServiceDate; clone.ActualInServiceDate = this.ActualInServiceDate; clone.PowerCallId = this.PowerCallId; clone.OwnerName = this.OwnerName; return(clone); }
/// <summary> /// Inserts a new ElectricityPurchaseAgreement object to Db or updates any existing ElectricityPurchaseAgreement objects (based on ElectricityPurchaseAgreement) /// </summary> /// <param name="epa">ElectricityPurchaseAgreement object</param> public int SaveEPA(ElectricityPurchaseAgreement epa) { ElectricityPurchaseAgreement currentEPA = this.Context.ElectricityPurchaseAgreements.FirstOrDefault(e => e.Code == epa.Code); //ElectricityPurchaseAgreement cClone = null; int insertedRecords = 0; if (currentEPA != null) { //cClone = currentEPA.Clone(); //Log.Info("Updating EPA record for " + currentEPA.Code ); currentEPA.DateUpdated = epa.DateCreated; currentEPA.UserUpdatedId = epa.UserCreatedId; currentEPA.EPACapacity = epa.EPACapacity; currentEPA.MaxTakeOrPay = epa.MaxTakeOrPay; currentEPA.NitsDesignatedCapacity = epa.NitsDesignatedCapacity; currentEPA.ContractManager = epa.ContractManager; //.SafeSubstring(0,100); currentEPA.SecondaryContractManager = epa.SecondaryContractManager; //.SafeSubstring(0, 100); currentEPA.Description = epa.Description; currentEPA.Code = epa.Code; //.SafeSubstring(0, 50); currentEPA.EPAStatusId = epa.EPAStatusId; currentEPA.PowerCallId = epa.PowerCallId; currentEPA.EstimatedInServiceDate = epa.EstimatedInServiceDate; currentEPA.ActualInServiceDate = epa.ActualInServiceDate; currentEPA.OwnerName = epa.OwnerName; //.SafeSubstring(0, 80); epa.Id = currentEPA.Id; } else { //Log.Info("Creating new record for "+ currentEPA.Code ); this.Context.ElectricityPurchaseAgreements.InsertOnSubmit(epa); insertedRecords = 1; } this.Context.SubmitChanges(); //this.ReportPairs.Items.Add(new Report.ReportPair(cClone, epa)); return(insertedRecords); }
/// <summary> /// Retrieves an EPA object based on input identity /// </summary> /// <param name="id">EPA identity</param> /// <returns>EPA object</returns> public ElectricityPurchaseAgreement GetEPA(int id) { ElectricityPurchaseAgreement myEpa = new ElectricityPurchaseAgreement(); return(this.Context.ElectricityPurchaseAgreements.FirstOrDefault(epa => epa.Id == id)); }
/// <summary> /// Retrieve EPA Information based on code /// </summary> /// <param name="code">TLA code</param> public ElectricityPurchaseAgreement GetEPA(string code) { ElectricityPurchaseAgreement myEpa = new ElectricityPurchaseAgreement(); return(this.Context.ElectricityPurchaseAgreements.FirstOrDefault(epa => epa.Code == code)); }