// ==========================================
// === PerformanceIndicatorForm Edit - Main Methods for PIFEdit page
public static void AddPerformanceIndicatorsToForm(Guid PIFID, Guid[] PerfomanceIndicators)
{
using (LinqMicajahDataContext dc = new LinqMicajahDataContext())
{
foreach (Guid pi in PerfomanceIndicators)
{
PerformanceIndicatorFormPerformanceIndicatorJunc ret =
(from pifj in dc.PerformanceIndicatorFormPerformanceIndicatorJunc
where (pifj.InstanceId == LinqMicajahDataContext.InstanceId) && (pifj.PerformanceIndicatorFormID == PIFID) && (pifj.PerformanceIndicatorID == pi)
select pifj).FirstOrNull();
if (ret != null)
{
ret.Status = true;
}
else
{
PerformanceIndicatorFormPerformanceIndicatorJunc newPIFJ = new PerformanceIndicatorFormPerformanceIndicatorJunc();
newPIFJ.InstanceId = LinqMicajahDataContext.InstanceId;
newPIFJ.PerformanceIndicatorFormID = PIFID;
newPIFJ.PerformanceIndicatorID = pi;
dc.PerformanceIndicatorFormPerformanceIndicatorJunc.InsertOnSubmit(newPIFJ);
}
}
dc.SubmitChanges();
}
}
public static void RemovePerformanceIndicator(Guid PIFID, Guid PerformanceIndicatorID)
{
using (LinqMicajahDataContext dc = new LinqMicajahDataContext())
{
PerformanceIndicatorFormPerformanceIndicatorJunc ret =
(from pifj in dc.PerformanceIndicatorFormPerformanceIndicatorJunc
where (pifj.InstanceId == LinqMicajahDataContext.InstanceId) && (pifj.PerformanceIndicatorFormID == PIFID) && (pifj.PerformanceIndicatorID == PerformanceIndicatorID)
select pifj).FirstOrNull();
if (ret != null)
{
ret.Status = false;
}
dc.SubmitChanges();
}
}
