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();
}
}
// Hidden ScoreCards
public static void HideScoreCard(Guid ScoreCardId)
{
using (LinqMicajahDataContext dc = new LinqMicajahDataContext())
{
ScoreCardHidden sch = new ScoreCardHidden();
sch.ScoreCardID = ScoreCardId;
sch.UserId = (Guid)LinqMicajahDataContext.LogedUserId;
sch.Created = DateTime.Now;
dc.ScoreCardHidden.InsertOnSubmit(sch);
dc.SubmitChanges();
}
}
