public async Task <bool> CreateLoadAsync(LoadDataModel obj) { //mapping var load = MappingtoLoad(obj); //Adding To Db _con.Load.Add(load); await _con.SaveChangesAsync(); Loadparameter par = new Loadparameter { Power = obj.Power, PowerFactor = obj.PowerFactor, RatingCurrent = obj.RatingCurrent, RatingTemp = obj.RatingTemp, RatingVoltage = obj.RatingVoltage, Type = obj.Type, }; _con.Loadparameter.Add(par); var value = _con.Load.Last(); value.code = value.Id; value.LoadInfo = par; _con.SaveChanges(); // lw mtwsl b primary if (obj.SourceId % 2 != 0) { PhasesConnection phase = new PhasesConnection(); phase.SourceId = obj.SourceId; phase.SourceType = new PrimarySourceSerivce(_con).GetPrimarySourceFromDBByCode(obj.SourceId).Type; if (obj.Type == "1") { if (obj.dN1 == 1) { phase.dN1 = 1; phase.sN1 = "l" + value.Id; } else if (obj.dN1 == 2) { phase.dN2 = 1; phase.sN2 = "l" + value.Id; } else { phase.dN3 = 1; phase.sN3 = "l" + value.Id; } } else { if (obj.dN1 == 1) { phase.dN1 = 1; phase.sN1 = "l" + value.Id; } else if (obj.dN1 == 2) { phase.dN2 = 1; phase.sN2 = "l" + value.Id; } else { phase.dN3 = 1; phase.sN3 = "l" + value.Id; } if (obj.dN2 == 1) { phase.dN1 = 2; phase.sN1 = "l" + value.Id; } else if (obj.dN2 == 2) { phase.dN2 = 2; phase.sN2 = "l" + value.Id; } else { phase.dN2 = 2; phase.sN3 = "l" + value.Id; } if (obj.dN3 == 1) { phase.dN1 = 3; phase.sN1 = "l" + value.Id; } else if (obj.dN3 == 2) { phase.dN2 = 3; phase.sN2 = "l" + value.Id; } else { phase.dN3 = 3; phase.sN3 = "l" + value.Id; } } _con.PhasesConnection.Add(phase); await _con.SaveChangesAsync(); } // lw mtwsl bsec else { //connect to secondry source phases PhasesConnection phase = new PhasesConnectionService(_con).getPhaseBySourceId(obj.SourceId); if (obj.PhaseType == "1") { if (obj.dN1 == 1) { phase.dN1 = 1; phase.sN1 = "l" + value.Id; } else if (obj.dN1 == 2) { phase.dN2 = 1; phase.sN2 = "l" + value.Id; } else { phase.dN3 = 1; phase.sN3 = "l" + value.Id; } } else { if (obj.dN1 == 1) { phase.dN1 = 1; phase.sN1 = "l" + value.Id; } else if (obj.dN1 == 2) { phase.dN2 = 1; phase.sN2 = "l" + value.Id; } else { phase.dN3 = 1; phase.sN3 = "l" + value.Id; } if (obj.dN2 == 1) { phase.dN1 = 2; phase.sN1 = "l" + value.Id; } else if (obj.dN2 == 2) { phase.dN2 = 2; phase.sN2 = "l" + value.Id; } else { phase.dN2 = 2; phase.sN3 = "l" + value.Id; } if (obj.dN3 == 1) { phase.dN1 = 3; phase.sN1 = "l" + value.Id; } else if (obj.dN3 == 2) { phase.dN2 = 3; phase.sN2 = "l" + value.Id; } else { phase.dN3 = 3; phase.sN3 = "l" + value.Id; } } _con.PhasesConnection.Update(phase); } await _con.SaveChangesAsync(); return(true); }
//================================================================ //Setters //Create Secondary public async Task <bool> CreateSecoundrySourceAsync(SecoundrySouresDataModelSim obj) { //mapping var secondarySource = MappingToPrimarySource(obj); //Adding To Db _Context.secondarySource.Add(secondarySource); await _Context.SaveChangesAsync(); var value = _Context.secondarySource.Last(); //value.Code = "" + value.Id; _Context.SaveChanges(); // create secondary source phase PhasesConnectionService phs = new PhasesConnectionService(_Context); phs.Create(value.Id, value.Type); // PEAK POWER TABLE powerPeak peak = new powerPeak() { secondrySourceId = Convert.ToInt16(value.Code), peakP1 = 0, peakP2 = 0, peakP3 = 0, }; _Context.powerPeak.Add(peak); _Context.SaveChanges(); //connect to primary source phases PhasesConnection phase = new PhasesConnection(); phase.SourceId = obj.PS_Id; phase.SourceType = new PrimarySourceSerivce(_Context).GetPrimarySourceFromDBByCode(obj.PS_Id).Type; if (obj.Type == "1") { if (obj.dN1 == 1) { phase.dN1 = 1; phase.sN1 = "s" + value.Id; } else if (obj.dN1 == 2) { phase.dN2 = 1; phase.sN2 = "s" + value.Id; } else { phase.dN3 = 1; phase.sN3 = "s" + value.Id; } } else { if (obj.dN1 == 1) { phase.dN1 = 1; phase.sN1 = "s" + value.Id; } else if (obj.dN1 == 2) { phase.dN2 = 1; phase.sN2 = "s" + value.Id; } else { phase.dN3 = 1; phase.sN3 = "s" + value.Id; } if (obj.dN2 == 1) { phase.dN1 = 2; phase.sN1 = "s" + value.Id; } else if (obj.dN2 == 2) { phase.dN2 = 2; phase.sN2 = "s" + value.Id; } else { phase.dN2 = 2; phase.sN3 = "s" + value.Id; } if (obj.dN3 == 1) { phase.dN1 = 3; phase.sN1 = "s" + value.Id; } else if (obj.dN3 == 2) { phase.dN2 = 3; phase.sN2 = "s" + value.Id; } else { phase.dN3 = 3; phase.sN3 = "s" + value.Id; } } _Context.PhasesConnection.Add(phase); await _Context.SaveChangesAsync(); return(true); }