public Bridge()
{
_context = new ProcrastinHaterEntities();
CEOrganizer = new ChecklistElementOrganizer(_context);
GroupsMgr = new GroupsManager(_context);
TasksMgr = new TasksManager(_context);
}
private static HardSettings GetHardSettings(ProcrastinHaterEntities context)
{
HardSettings settings = (from s in context.HardSettingsSet
where s.Check == true
select s).SingleOrDefault();
return settings;
}
public static void DeletePositionInfo(ProcrastinHaterEntities context,
ChecklistElement item)
{
ChecklistElement prevItem = item.PositionInformation.PreviousItem;
ChecklistElement nextItem = item.PositionInformation.NextItem;
if (prevItem != null)
prevItem.PositionInformation.NextItem = nextItem;
if (nextItem != null)
nextItem.PositionInformation.PreviousItem = prevItem;
context.PositionInformationSet.DeleteObject(item.PositionInformation);
}
public static int GetAndAdvanceNextTimedTaskSettingsKey(ProcrastinHaterEntities context)
{
HardSettings settings = GetHardSettings(context);
if (settings == null)
return -1;
else
{
int ret = settings.NextTimedTaskSettingsKey;
++settings.NextTimedTaskSettingsKey; //committed through context.SaveChanges by caller
return ret;
}
}
//For now, add Task or Group to end of list
public static void AddPositionInfo(ProcrastinHaterEntities context,
ChecklistElement item, int? parentGroupId)
{
item.PositionInformation = new PositionInformation();
var lastItemOfGroup = (from pos in context.PositionInformationSet
where ((pos.ChecklistElement.ParentGroupID == parentGroupId) && (pos.NextItemID == null))
select pos.ChecklistElement).SingleOrDefault();
if (lastItemOfGroup != null)
{
lastItemOfGroup.PositionInformation.NextItemID = item.ItemID;
item.PositionInformation.PreviousItemID = lastItemOfGroup.ItemID;
item.PositionInformation.NextItemID = null;
}
}
public static bool ValidateChecklistElement(ProcrastinHaterEntities context,
ChecklistElement item,
out string errors)
{
errors = "";
string titleErr = ValidateTitleField(item.Title);
if (titleErr != null)
errors += titleErr + "\n";
string fontColErr = ValidateColorString(item.FontColor);
if (fontColErr != null)
errors += fontColErr + "\n";
string bgColErr = ValidateColorString(item.BackgroundColor);
if (bgColErr != null)
errors += bgColErr + "\n";
string createTimeErr = ValidateBeginTime(item.BeginTime);
if (createTimeErr != null)
errors += createTimeErr + "\n";
string resolveTimeErr = ValidateResolveTime(item.BeginTime, item.ResolveTime);
if (resolveTimeErr != null)
errors += resolveTimeErr + "\n";
string fontSizeErr = ValidateFontSize(item.FontSize);
if (fontSizeErr != null)
errors += fontSizeErr + "\n";
string parentGroupIdErr = ValidateParentGroupId(context, item.ParentGroupID);
if (parentGroupIdErr != null)
errors += parentGroupIdErr + "\n";
if (string.IsNullOrEmpty(errors))
return true;
else
return false;
}
private static string ValidateParentGroupId(ProcrastinHaterEntities context,
int? id)
{
string err = null;
if (id != null)
{
Group parent = (from g in context.ChecklistElements.OfType<Group>()
where g.ItemID == id
select g).SingleOrDefault();
if (parent == null)
err = "No group exists with the provided ParentGroupID.\n";
}
return err;
}
internal GroupsManager(ProcrastinHaterEntities context)
{
_context = context;
}
internal TasksManager(ProcrastinHaterEntities context)
{
_context = context;
}
