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