public static void SaveColumns(Guid DataViewTypeID, List <string> TableColumns, int DataViewColumnListTypeID, Guid DataViewListID) { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { var NeedDelColumns = dc.DataViewColumn.Where(c => c.DataViewColumnListTypeID == DataViewColumnListTypeID && c.Status == true && c.InstanceId == LinqMicajahDataContext.InstanceId && c.DataViewListID == DataViewListID).ToList(); dc.DataViewColumn.DeleteAllOnSubmit(NeedDelColumns); for (int i = 0; i < TableColumns.Count; i++) { string NeedInsertColumn = TableColumns[i]; string [] ss = NeedInsertColumn.Split(','); DataViewColumn c = new DataViewColumn() { TableName = ss[0], ColumnName = ss[1], DataViewListID = DataViewListID, DataViewColumnListTypeID = DataViewColumnListTypeID, OrderNumber = i }; dc.DataViewColumn.InsertOnSubmit(c); } dc.SubmitChanges(); } }
public static List <DataViewList> List(Guid DataViewTypeID) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); var dv = from v in dc.DataViewList where v.InstanceId == LinqMicajahDataContext.InstanceId && v.Status == true && v.DataViewTypeID == DataViewTypeID select v; return(dv.ToList()); }
public static MetricFilter.Extend Get(Guid MetricFilterID) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); MetricFilter.Extend MetricFilter = (from m in dc.MetricFilter where m.InstanceID == LinqMicajahDataContext.InstanceId && m.MetricFilterID == MetricFilterID && m.Status == true select new Extend { //InstanceId = m.InstanceId, MetricFilterID = m.MetricFilterID, Name = m.Name, GroupCategoryAspectID = m.GroupCategoryAspectID, DataCollectorID = m.DataCollectorID }).FirstOrNull(); if (MetricFilter != null) { MetricFilter.FilterOrgLocation = (from drol in dc.MetricFilterOrgLocation where drol.InstanceId == LinqMicajahDataContext.InstanceId && drol.MetricFilterID == MetricFilter.MetricFilterID select(Guid?) drol.OrgLocationID).ToArray(); MetricFilter.FilterPI = (from drpi in dc.MetricFilterPerformanceIndicator where drpi.InstanceId == LinqMicajahDataContext.InstanceId && drpi.MetricFilterID == MetricFilter.MetricFilterID select(Guid?) drpi.PerformanceIndicatorID).ToArray(); MetricFilter.FilterMetric = (from drm in dc.MetricFilterMetric where drm.InstanceId == LinqMicajahDataContext.InstanceId && drm.MetricFilterID == MetricFilter.MetricFilterID select(Guid?) drm.MetricID).ToArray(); } return(MetricFilter); }
public static void Delete(Guid MetricID) { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { /*var M = (from m in dc.Metric where m.MetricID == MetricID select m).FirstOrNull(); * if (M != null) * { * dc.Metric.DeleteOnSubmit(M); * dc.SubmitChanges(); * }*/ var PIMecricJuncs = from j in dc.PerformanceIndicatorMetricJunc where j.MetricID == MetricID && j.Status == true && j.InstanceId == LinqMicajahDataContext.InstanceId select j; foreach (PerformanceIndicatorMetricJunc j in PIMecricJuncs) { j.Status = false; } Metric ret = (from m in dc.Metric where (m.InstanceId == LinqMicajahDataContext.InstanceId) && (m.MetricID == MetricID) select m).FirstOrNull(); if (ret != null) { ret.Status = false; } dc.SubmitChanges(); } }
public static void Insert(Guid PerformanceIndicatorID, Guid MetricID) { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { PerformanceIndicatorMetricJunc PiMJ = ( from j in dc.PerformanceIndicatorMetricJunc where j.InstanceId == LinqMicajahDataContext.InstanceId && j.PerformanceIndicatorID == PerformanceIndicatorID && j.MetricID == MetricID select j ).FirstOrNull(); if (PiMJ == null) { PiMJ = new PerformanceIndicatorMetricJunc(); PiMJ.PerformanceIndicatorID = PerformanceIndicatorID; PiMJ.MetricID = MetricID; dc.PerformanceIndicatorMetricJunc.InsertOnSubmit(PiMJ); } else { PiMJ.Status = true; } dc.SubmitChanges(); } }
public static void FillPeriodDate() { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { dc.ExecuteCommand("delete from D_PeriodDate"); for (int FrequencyID = 1; FrequencyID <= 11; FrequencyID++) { DateTime b = new DateTime(2000, 1, 1); b = GetNormalizedDate(FrequencyID, b); DateTime dt; DateTime EndDt = new DateTime(2075, 1, 1); int PeriodNumber = 0; do { dt = AddPeriod(b, FrequencyID, PeriodNumber); D_PeriodDate r = new D_PeriodDate() { FrequencyID = FrequencyID, Date = dt, PeriodNumber = PeriodNumber, ShortName = GetPeriodName(dt, FrequencyID, true), LongName = GetPeriodName(dt, FrequencyID, false) }; dc.D_PeriodDate.InsertOnSubmit(r); dc.SubmitChanges(); PeriodNumber++; }while (dt <= EndDt); } } }
static public List <Extend> List(Guid ScoreCardID, Guid InstanceId) { DateTime DTNow = DateTime.Now; LinqMicajahDataContext dc = new LinqMicajahDataContext(); return(List(ScoreCardID, null, null, null, null, dc, InstanceId, null)); }
public static List <Extend> GetFormulaHistory(Guid MetricID) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); IQueryable <Extend> flist = (from f in dc.MetricFormula join _u in dc.Mc_User on f.UpdatedBy equals _u.UserId into __u from u in __u.DefaultIfEmpty() where f.InstanceId == LinqMicajahDataContext.InstanceId && f.MetricID == MetricID && f.Status == true orderby f.Created descending, f.BeginDate, f.EndDate select new Extend { InstanceId = f.InstanceId, MetricFormulaID = f.MetricFormulaID, MetricID = f.MetricID, Formula = f.Formula, VariableFormula = f.VariableFormula, BeginDate = f.BeginDate, EndDate = f.EndDate, Created = f.Created, Updated = f.Updated, Status = f.Status, UpdatedBy = f.UpdatedBy, Comment = f.Comment, UserName = f.UpdatedBy == null ? String.Empty : u.FirstName + " " + u.LastName, ChangeDate = f.Updated == null ? f.Created : (DateTime)f.Updated }).OrderByDescending(r => r.ChangeDate); return(flist.ToList()); }
public static void Merge(Guid SourceID, Guid DestID) { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { MergeGCA(dc, SourceID, DestID); } }
// ========================================== // === 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(); } }
//===================================== // PerformanceIndicatorForm: unassigned Performance Indicator select public static List <PerformanceIndicator.Extend> UnassignedPerformanceIndicatorList(Guid PIFID, Guid GCAItemID) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); Guid?refGCAId = null; if (GCAItemID != Guid.Empty) { refGCAId = GCAItemID; } ISingleResult <Sp_SelectUnassignedPerformanceIndicatorResult> result = dc.Sp_SelectUnassignedPerformanceIndicator(LinqMicajahDataContext.InstanceId, PIFID, refGCAId); List <PerformanceIndicator.Extend> lPI = new List <PerformanceIndicator.Extend>(); foreach (Sp_SelectUnassignedPerformanceIndicatorResult i in result) { PerformanceIndicator.Extend pi = new PerformanceIndicator.Extend(); pi.InstanceId = i.InstanceId == null ? Guid.Empty : (Guid)i.InstanceId; pi.PerformanceIndicatorID = i.PerformanceIndicatorID == null ? Guid.Empty : (Guid)i.PerformanceIndicatorID; pi.Name = i.Name.TrimEnd(); pi.Description = i.Description; pi.Code = i.Code; pi.GroupCategoryAspectID = i.GroupCategoryAspectID; pi.Status = i.Status; pi.Created = (DateTime)i.Created; pi.Updated = i.Updated; pi.SectorID = i.SectorID; pi.Help = i.Help; pi.RequirementID = i.RequirementID; pi.SectorName = i.Sector; pi.RequirementName = i.Requirement; pi.GCAName = i.GCA; lPI.Add(pi); } return(lPI); }
public static void DenormalizeOrgLocations() { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { int res = dc.Sp_UpdateRelations(); } }
public override void OnDeleting(LinqMicajahDataContext c, ref bool Cancel) { base.OnDeleting(c, ref Cancel); Cancel = true; using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { IQueryable rets = from pifpij in dc.PerformanceIndicatorFormPerformanceIndicatorJunc where (pifpij.InstanceId == LinqMicajahDataContext.InstanceId) && (pifpij.PerformanceIndicatorFormID == PerformanceIndicatorFormID) && (pifpij.Status == true) select pifpij; foreach (PerformanceIndicatorFormPerformanceIndicatorJunc pifpij in rets) { if (pifpij != null) { pifpij.Status = false; } } PerformanceIndicatorForm ret = (from pif in dc.PerformanceIndicatorForm where (pif.InstanceId == LinqMicajahDataContext.InstanceId) && (pif.PerformanceIndicatorFormID == PerformanceIndicatorFormID) select pif).FirstOrNull(); if (ret != null) { ret.Status = false; } dc.SubmitChanges(); } }
public static void SavePeriod(string PeriodType1, string PeriodType2, DateTime?Begin1, DateTime?End1, DateTime?Begin2, DateTime?End2) { if (LinqMicajahDataContext.LogedUserId == null) { return; } int?Id1 = GepPeriodTypeId(PeriodType1); int?Id2 = GepPeriodTypeId(PeriodType2); using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { var cp = dc.ScoreCardCompPeriod.Where(p => p.UserId == (Guid)LinqMicajahDataContext.LogedUserId).FirstOrNull(); bool IsNew = cp == null; if (IsNew) { cp = new ScoreCardCompPeriod(); cp.ScoreCardCompPeriodId = Guid.NewGuid(); } cp.UserId = (Guid)LinqMicajahDataContext.LogedUserId; cp.PeriodType1 = Id1; cp.PeriodType2 = Id2; cp.Begin1 = Begin1; cp.End1 = End1; cp.Begin2 = Begin2; cp.End2 = End2; if (IsNew) { dc.ScoreCardCompPeriod.InsertOnSubmit(cp); } dc.SubmitChanges(); } }
public static string CalculateTotalString(LinqMicajahDataContext dc, Guid OrganizationId, Guid InstanceId, Guid MetricID, Guid?OrgLocationID, Guid?UomID, DateTime BeginDate, DateTime EndDate) { var values = GetValues(dc, InstanceId, MetricID, OrgLocationID, BeginDate, EndDate); List <string> ExistValues = new List <string>(); foreach (var v in values) { string sv = v.Value; if (string.IsNullOrEmpty(sv)) { continue; } sv = sv.Trim(); if (ExistValues.Contains(sv)) { continue; } ExistValues.Add(sv); } if (ExistValues.Count < 1) { return(null); } return(string.Join(",", ExistValues.ToArray())); }
public static FrequencyMetric RelatedValuesList(int ValueCount, DateTime BaseDate, DateTime FirstDate, Guid CalcMetricID, bool GroupByMetric, Guid? @ApproveUserId) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); var fm = (from f in dc.Frequency join m in dc.Metric on f.FrequencyID equals m.FrequencyID where m.MetricID == CalcMetricID select new FrequencyMetric { FrequencyID = f.FrequencyID, Name = f.Name }).FirstOrNull(); if (fm != null) { DateTime NormalizedDate = FirstDate; if (FirstDate == DateTime.MinValue) { NormalizedDate = Frequency.GetNormalizedDate(fm.FrequencyID, BaseDate); } fm.Date = GetDateHeader(fm.FrequencyID, NormalizedDate, ValueCount); fm.Metrics = RelatedValuesList(ValueCount, NormalizedDate, fm.FrequencyID, dc, fm.Date, CalcMetricID, GroupByMetric, @ApproveUserId); } return(fm); }
public static List <Extend> List() { LinqMicajahDataContext dc = new LinqMicajahDataContext(); return((from u in dc.Mc_User join f in dc.ViewnameUser on u.UserId equals f.UserId join ou in dc.Mc_OrganizationsUsers on u.UserId equals ou.UserId join i in dc.Mc_Instance on ou.OrganizationId equals i.OrganizationId where i.InstanceId == LinqMicajahDataContext.InstanceId && u.Deleted == false orderby u.FirstName, u.LastName select new Extend { UserId = u.UserId, Email = u.Email, FirstName = u.FirstName, LastName = u.LastName, MiddleName = u.MiddleName, LastLoginDate = u.LastLoginDate, Deleted = u.Deleted, FullName = u.FirstName + ' ' + u.LastName //FullName = f.FullName - with email }).ToList()); }
private static void CopyGCA(LinqMicajahDataContext dc, Guid SourceID, Guid DestID) { GroupCategoryAspect SourceGCA = (from gca in dc.GroupCategoryAspect where (gca.InstanceId == LinqMicajahDataContext.InstanceId) && (gca.GroupCategoryAspectID == SourceID) && (gca.Status == true) select gca).FirstOrNull(); if (SourceGCA != null) { GroupCategoryAspect cSource = new GroupCategoryAspect(); cSource.CopyFrom(SourceGCA); cSource.ParentId = DestID; dc.GroupCategoryAspect.InsertOnSubmit(cSource); dc.SubmitChanges(); IQueryable <GroupCategoryAspect> SourceGCAs = from gca in dc.GroupCategoryAspect where (gca.InstanceId == LinqMicajahDataContext.InstanceId) && (gca.ParentId == SourceID) && (gca.Status == true) select gca; foreach (GroupCategoryAspect gca in SourceGCAs) { CopyGCA(dc, gca.GroupCategoryAspectID, cSource.GroupCategoryAspectID); } } }
public static void HideAllPublicScoreCards() { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { var r = from c in dc.ScoreCard join _h in dc.ScoreCardHidden on new { c.InstanceId, c.ScoreCardID, CurrentUserId = LinqMicajahDataContext.LogedUserId } equals new { _h.InstanceId, _h.ScoreCardID, CurrentUserId = (Guid?)_h.UserId } into __h from h in __h.DefaultIfEmpty() where c.InstanceId == LinqMicajahDataContext.InstanceId && c.Status == true && (c.IsPublic && h.ScoreCardHiddenID == null && (LinqMicajahDataContext.LogedUserId != c.UserId || c.UserId == null)) select new Extend { InstanceId = c.InstanceId, ScoreCardID = c.ScoreCardID }; var l = r.ToList(); foreach (Extend cs in l) { ScoreCardHidden sch = new ScoreCardHidden(); sch.ScoreCardID = cs.ScoreCardID; sch.UserId = (Guid)LinqMicajahDataContext.LogedUserId; sch.Created = DateTime.Now; dc.ScoreCardHidden.InsertOnSubmit(sch); } dc.SubmitChanges(); } }
// Performance Indicator Report section public static IList <PIMetricInfo> GetPIReportValues(Guid?OrgLocationID, Guid GroupID, int FrequencyID, Guid?OrgLocationTypeID, DateTime BeginDate, DateTime EndDate) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); IMultipleResults results = dc.Sp_SelectPIReportValues(LinqMicajahDataContext.InstanceId, OrgLocationID, GroupID, FrequencyID, OrgLocationTypeID, BeginDate, EndDate); IList <PIMetricInfo> MetricInfo = results.GetResult <PIMetricInfo>().ToList(); IList <PIMetricValue> MetricValues = results.GetResult <PIMetricValue>().ToList(); List <Micajah.Common.Bll.MeasureUnit> OrgUoMs = Mc_UnitsOfMeasure.GetOrganizationUoMs(); foreach (PIMetricInfo mi in MetricInfo) { mi.LocationFullName = (OrgLocationID == Guid.Empty && !String.IsNullOrEmpty(mi.LocationFullName)) ? LinqMicajahDataContext.OrganizationName : mi.LocationFullName; mi.InputUoMName = GetMeasureUnitPluralName(OrgUoMs, mi.InputUnitOfMeasureID); mi.UoMName = GetMeasureUnitPluralName(OrgUoMs, mi.UnitOfMeasureID); CompositeDailyValues cdv = new CompositeDailyValues(); foreach (PIMetricValue mv in MetricValues) { decimal Val = 0; if (mv.MetricID == mi.MetricID && mv.OrgLocationID == mi.OrgLocationID) // add one more linq select { if ((mv.ValueMetricDataTypeID == 1) && (mv.UnitOfMeasureID == mv.MetricUnitOfMeasureID)) { // !!! for now we ignore values when its output uom != metric output uom if (decimal.TryParse(mv.ConvertedValue, out Val)) { cdv.AddCompositeDailyValue((DateTime)mv.InputDate, Val, (int)mv.FrequencyID, (DateTime)mv.Date, (int)mi.FrequencyID); } } } } decimal?res = cdv.GetCompositeValue(BeginDate, EndDate, false); mi.SumValue = res == null ? "0" : res.ToString(); } return(MetricInfo); }
public static void InsertOrgLocationsClusterList(Guid RuleID, Guid?[] OrgLocationsID) { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { DataRule FirstRule = (from r in dc.DataRule where r.InstanceId == LinqMicajahDataContext.InstanceId && r.Status == true && r.DataRuleID == RuleID select r).FirstOrNull(); if (FirstRule != null && OrgLocationsID.Length > 1) { for (int i = 1; i < OrgLocationsID.Length; i++) { DataRule OneMoreRule = new DataRule(); OneMoreRule.InstanceId = FirstRule.InstanceId; OneMoreRule.DataRuleID = Guid.NewGuid(); OneMoreRule.DataRuleTypeID = FirstRule.DataRuleTypeID; OneMoreRule.OrderNumber = FirstRule.OrderNumber; OneMoreRule.OrgLocationID = OrgLocationsID[i]; OneMoreRule.GroupCategoryAspectID = FirstRule.GroupCategoryAspectID; OneMoreRule.PerformanceIndicatorID = FirstRule.PerformanceIndicatorID; OneMoreRule.PerformanceIndicatorFormID = FirstRule.PerformanceIndicatorFormID; OneMoreRule.MetricID = FirstRule.MetricID; OneMoreRule.UserId = FirstRule.UserId; OneMoreRule.GroupId = FirstRule.GroupId; OneMoreRule.Status = FirstRule.Status; OneMoreRule.Created = FirstRule.Created; OneMoreRule.Updated = FirstRule.Updated; OneMoreRule.Description = FirstRule.Description; OneMoreRule.RuleClusterID = FirstRule.RuleClusterID; dc.DataRule.InsertOnSubmit(OneMoreRule); } dc.SubmitChanges(); } } }
public static List <Mc_Instance> List() { LinqMicajahDataContext dc = new LinqMicajahDataContext(); var r = (from i in dc.Mc_Instance where !i.Deleted select i).ToList(); return(r); }
public static List<Extend> List(Guid DataViewListID, int DataViewColumnListTypeID) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); /*WhereCondition = null; Slave = false; var dv = (from l in dc.DataViewList where l.InstanceId == LinqMicajahDataContext.InstanceId && l.Status == true && l.DataViewListID == DataViewListID select l).FirstOrNull(); if (dv == null) return null; WhereCondition = dv.WhereCondition; Slave = dv.Slave;*/ var r = (from c in dc.DataViewColumn join w in dc.DataViewWhere on new { LinqMicajahDataContext.InstanceId, Status = (bool?)true, c.DataViewColumnID } equals new { w.InstanceId, w.Status, w.DataViewColumnID } where c.InstanceId == LinqMicajahDataContext.InstanceId && c.Status == true && c.DataViewListID == DataViewListID && c.DataViewColumnListTypeID == DataViewColumnListTypeID && w.Slave == (DataViewColumnListTypeID!=2) select new Extend() { TableName = c.TableName, ColumnName = c.ColumnName, CompareValue = w.CompareValue, DataViewColumnID = c.DataViewColumnID, DataViewConditionTypeID = w.DataViewConditionTypeID, DataViewWhereID = w.DataViewWhereID, OrderNumber = c.OrderNumber }).ToList(); return r; }
public static void ClearInputValues(int maxgen) { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { IQueryable <MetricValue> metricValue = from mv in dc.MetricValue join m in dc.Metric on new { mv.InstanceId, mv.MetricID } equals new { m.InstanceId, m.MetricID } where mv.Status == true && mv.IsCalc == true && m.Generation == maxgen select mv; foreach (MetricValue mv in metricValue) { mv.InProcess = true; mv.IsCalc = false; } dc.SubmitChanges(); IQueryable <MetricValue> _metricValue = from mv in dc.MetricValue where mv.InProcess == true select mv; foreach (MetricValue mv in _metricValue) { mv.InProcess = false; } dc.SubmitChanges(); } }
public static List <Extend> GetLog(Guid MetricValueID) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); IQueryable <Extend> flist = from l in dc.MetricValueChangeLog join t in dc.MetricValueChangeType on l.MetricValueChangeTypeID equals t.MetricValueChangeTypeID join u in dc.Mc_User on l.UserId equals u.UserId where l.InstanceId == LinqMicajahDataContext.InstanceId && l.MetricValueID == MetricValueID orderby l.CreatedTime descending, l.MetricValueChangeTypeID select new Extend { InstanceId = l.InstanceId, MetricValueChangeLogID = l.MetricValueChangeLogID, MetricValueID = l.MetricValueID, Event = l.Event, OldValue = l.OldValue, NewValue = l.NewValue, CreatedTime = l.CreatedTime, MetricValueChangeTypeID = l.MetricValueChangeTypeID, UserId = l.UserId, UserName = u.FirstName + " " + u.LastName, TypeName = t.Name }; return(flist.ToList()); }
private static void CopyMC(LinqMicajahDataContext dc, Guid SourceID, Guid DestID) { MetricCategory SourceMC = (from mc in dc.MetricCategory where (mc.InstanceId == LinqMicajahDataContext.InstanceId) && (mc.MetricCategoryID == SourceID) && (mc.Status == true) select mc).FirstOrNull(); if (SourceMC != null) { MetricCategory cSource = new MetricCategory(); cSource.CopyFrom(SourceMC); cSource.ParentId = DestID; dc.MetricCategory.InsertOnSubmit(cSource); dc.SubmitChanges(); IQueryable <MetricCategory> SourceMCs = from mc in dc.MetricCategory where (mc.InstanceId == LinqMicajahDataContext.InstanceId) && (mc.ParentId == SourceID) && (mc.Status == true) select mc; foreach (MetricCategory mc in SourceMCs) { CopyMC(dc, mc.MetricCategoryID, cSource.MetricCategoryID); } } }
public static void Copy(Guid SourceID, Guid DestID) { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { CopyMC(dc, SourceID, DestID); } }
static public List <Extend> List(Guid ScoreCardInstaceId, DateTime?BeginDate, DateTime?EndDate, DateTime?BeginCompDate, DateTime?EndCompDate, Guid?CurrentUserId, MetricTrac.Bll.ScoreCardMetric.CalcStringFormula Calculator) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); var r = from c in dc.ScoreCard join _u in dc.Mc_User on new { c.UserId, Deleted = false } equals new { UserId = (Guid?)_u.UserId, _u.Deleted } into __u from u in __u.DefaultIfEmpty() join _h in dc.ScoreCardHidden on new { c.InstanceId, c.ScoreCardID, CurrentUserId } equals new { _h.InstanceId, _h.ScoreCardID, CurrentUserId = (Guid?)_h.UserId } into __h from h in __h.DefaultIfEmpty() where c.InstanceId == ScoreCardInstaceId && c.Status == true && ((CurrentUserId == c.UserId && c.UserId != null) || (c.IsPublic && h.ScoreCardHiddenID == null) || CurrentUserId == null) orderby((CurrentUserId == c.UserId && c.UserId != null) ? 1 : 2), (c.UserId == null ? 2 : 1), u.LastName, u.FirstName select new Extend { InstanceId = c.InstanceId, ScoreCardID = c.ScoreCardID, Name = c.Name, Description = c.Description, Status = c.Status, Created = c.Created, Updated = c.Updated, UserId = c.UserId, IsPublic = c.IsPublic, CreateUserName = ((u.FirstName == null) ? String.Empty : u.FirstName + " ") + ((u.LastName == null) ? String.Empty : u.LastName) }; var l = r.ToList(); foreach (Extend cs in l) { cs.MetricValue = MetricTrac.Bll.ScoreCardMetric.List(cs.ScoreCardID, BeginDate, EndDate, BeginCompDate, EndCompDate, dc, ScoreCardInstaceId, Calculator); } return(l); }
public static List <int> ListUsed() { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { var FId = (from m in dc.MetricValue where m.Status == true && m.InstanceId == LinqMicajahDataContext.InstanceId select m.FrequencyID).Distinct <int>(); return(FId.ToList()); } }
public static int HiddenScoreCardsCount() { using (LinqMicajahDataContext dc = new LinqMicajahDataContext()) { IQueryable <ScoreCardHidden> hiddens = from sch in dc.ScoreCardHidden where sch.UserId == LinqMicajahDataContext.LogedUserId && sch.InstanceId == LinqMicajahDataContext.InstanceId select sch; return(hiddens.Count()); } }