public static RecloserSettings SaveRecloserSettings(RecloserSettings mySettings)
{
RecloserSettings realSettings = mySettings;
int realId;
using (IQueryAdapter dbClient = Core.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO ajustes_linha (creation_service, ftemp_pickup, ftemp_curve, ftemp_dial, ftemp_mrt, finst_pickup," +
"ntemp_pickup, ntemp_curve, ntemp_dial, ntemp_mrt, ninst_pickup, class, num_op, temp_op_1, temp_op_2, temp_op_3, temp_rearm) VALUES " +
"(@scres,@ftp,@ftc,@ftd,@ftm,@ftip,@ntp,@ntc,@ntd,@ntm,@ntip,@sclass,@snum,@top1,@top2,@top3,@tr);");
dbClient.AddParameter("scres", mySettings.CreationService);
dbClient.AddParameter("ftp", mySettings.PhasePickUp);
dbClient.AddParameter("ftc", mySettings.PhaseCurveId);
dbClient.AddParameter("ftd", mySettings.PhaseDial);
dbClient.AddParameter("ftm", mySettings.PhaseMRT);
dbClient.AddParameter("ftip", mySettings.InstantPhasePickUp);
dbClient.AddParameter("ntp", mySettings.NeutralPickUp);
dbClient.AddParameter("ntc", mySettings.NeutralCurveId);
dbClient.AddParameter("ntd", mySettings.NeutralDial);
dbClient.AddParameter("ntm", mySettings.NeutralMRT);
dbClient.AddParameter("ntip", mySettings.InstantNeutralPickUp);
dbClient.AddParameter("sclass", mySettings.Class);
dbClient.AddParameter("snum", mySettings.NumberOfOperations);
dbClient.AddParameter("top1", mySettings.Operation1Time);
dbClient.AddParameter("top2", mySettings.Operation2Time);
dbClient.AddParameter("top3", mySettings.Operation3Time);
dbClient.AddParameter("tr", mySettings.Rearm);
realId = Convert.ToInt32(dbClient.InsertQuery());
}
realSettings.Id = realId;
return(realSettings);
}
public static void LinkRecloserSettings(Recloser myRecloser, RecloserSettings mySettings)
{
if (mySettings.Status == 1)
{
List <RecloserSettings> disablabeList = myRecloser.Settings.Where(x => x.Status == 1).ToList();
foreach (RecloserSettings rs in disablabeList)
{
DisableSettings(myRecloser, rs);
}
}
using (IQueryAdapter dbClient = Core.GetDatabaseManager().GetQueryReactor())
{
if (!(mySettings == null) && !(myRecloser == null))
{
dbClient.SetQuery("INSERT INTO link_ajustes_linha (settings_id,recloser_id,status,ts) VALUES (@sid,@rid,@st,@dt);");
dbClient.AddParameter("sid", mySettings.Id);
dbClient.AddParameter("rid", myRecloser.Id);
dbClient.AddParameter("st", mySettings.Status);
dbClient.AddParameter("dt", mySettings.CreationDate);
dbClient.RunQuery();
Core.GetRecloserManager().AddNewSettings(myRecloser.Number, mySettings);
}
}
}
public static void DisableSettings(Recloser myRecloser, RecloserSettings mySettings)
{
if (mySettings.Status != 0)
{
using (IQueryAdapter dbClient = Core.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE link_ajustes_linha SET status = 0 WHERE settings_id = @rsi;");
dbClient.AddParameter("rsi", mySettings.Id);
dbClient.RunQuery();
}
Core.GetRecloserManager().LoadedReclosers[Core.GetRecloserManager().GetRecloserIndex(myRecloser.Number)].DisableSettings(mySettings);
}
}
