// ========================================== // === 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(); } }