public static BaySettings CreateNewBaySettings(bool enabled, string creationService, int phasePickUp, double phaseTAP, int phaseCurveId, double phaseDial,
double phaseMRT, double phaseTimeAdd, int neutralPickUp, double neutralTAP, int neutralCurveId, double neutralDial, double neutralMRT, double neutralTimeAdd,
int numpOp, int opt1, int opt2, int opt3, int rearm, int instantPhasePickUp, int instantNeutralPickUp,
double instantPhaseTAP, double instantNeutralTAP)
{
int id = 0;
using (IQueryAdapter dbClient = Core.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO ajustes_bay (creation_service, ftemp_pickup, ftemp_tap, ftemp_curve, ftemp_dial, ftemp_mrt, ftemp_timeadd, finst_pickup," +
"finst_tap,ntemp_pickup,ntemp_tap, ntemp_curve, ntemp_dial, ntemp_mrt,ntemp_timeadd, ninst_pickup, ninst_tap, num_op, temp_op_1, temp_op_2, temp_op_3, temp_rearm) VALUES " +
"(@scres,@ftp,@ftt,@ftc,@ftd,@ftm,@fta,@fip,@fit,@ntp,@ntt,@ntc,@ntd,@ntm,@nta,@nip,@nit,@snum,@top1,@top2,@top3,@tr);");
dbClient.AddParameter("scres", creationService);
dbClient.AddParameter("ftp", phasePickUp);
dbClient.AddParameter("ftt", phaseTAP);
dbClient.AddParameter("ftc", phaseCurveId);
dbClient.AddParameter("ftd", phaseDial);
dbClient.AddParameter("ftm", phaseMRT);
dbClient.AddParameter("fta", phaseTimeAdd);
dbClient.AddParameter("fip", instantPhasePickUp);
dbClient.AddParameter("fit", instantPhaseTAP);
dbClient.AddParameter("ntp", neutralPickUp);
dbClient.AddParameter("ntt", neutralTAP);
dbClient.AddParameter("ntc", neutralCurveId);
dbClient.AddParameter("ntd", neutralDial);
dbClient.AddParameter("ntm", neutralMRT);
dbClient.AddParameter("nta", neutralTimeAdd);
dbClient.AddParameter("nip", instantNeutralPickUp);
dbClient.AddParameter("nit", instantNeutralTAP);
dbClient.AddParameter("snum", numpOp);
dbClient.AddParameter("top1", opt1);
dbClient.AddParameter("top2", opt2);
dbClient.AddParameter("top3", opt3);
dbClient.AddParameter("tr", rearm);
id = Convert.ToInt32(dbClient.InsertQuery());
}
if (id == 0)
{
SystemLogging.SendFatalErrorLog("Falha ao criar ajuste de Bay");
return(null);
}
else
{
SystemLogging.SendProcessLog("Ajuste criado de Bay: " + id + " " + creationService);
BaySettings myNewSettings = new BaySettings(id, enabled, creationService, phasePickUp, phaseTAP, phaseCurveId, phaseDial,
phaseMRT, phaseTimeAdd, neutralPickUp, neutralTAP, neutralCurveId, neutralDial, neutralMRT,
neutralTimeAdd, numpOp, opt1, opt2, opt3, rearm, instantPhasePickUp,
instantNeutralPickUp, instantPhaseTAP, instantNeutralTAP);
return(myNewSettings);
}
}
public static void LinkBaySettings(Bay myBay, BaySettings mySettings)
{
using (IQueryAdapter dbClient = Core.GetDatabaseManager().GetQueryReactor())
{
if (!(mySettings == null) && !(myBay == null))
{
dbClient.SetQuery("INSERT INTO link_ajustes_bay (settings_id,bay_id,status) VALUES (@sid,@bid,@en);");
dbClient.AddParameter("sid", mySettings.Id);
dbClient.AddParameter("bid", myBay.Id);
dbClient.AddParameter("en", mySettings.Enabled);
dbClient.RunQuery();
//Core.GetRecloserManager().AddNewSettings(myBad.Number, mySettings);
}
}
}
