public IEnumerable <SelectListItem> GetCodeData()
{
var cvctl = new CodeValueModel();
switch (fieldMap.Type)
{
case FieldType.Bit:
case FieldType.NullBit:
return(ConvertToSelect(BitCodes, fieldMap.DataValueField));
case FieldType.Code:
case FieldType.NullCode:
case FieldType.CodeStr:
if (fieldMap.DataSource == "ExtraValues")
{
return(StandardExtraValues.ExtraValueCodes());
}
if (fieldMap.DataSource == "Campuses")
{
return(Campuses());
}
return(ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField));
case FieldType.DateField:
return(ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField));
}
return(null);
}
public ActionResult ExtraValueData()
{
var ev = StandardExtraValues.GetExtraValues();
var q = from e in DbUtil.Db.PeopleExtras
where e.StrValue == null && e.BitValue == null
let TypeValue = e.DateValue != null ? "Date" : e.Data != null ? "Text" : e.IntValue != null ? "Int" : "?"
group e by new { e.Field, TypeValue } into g
select new ExtraInfo
{
Field = g.Key.Field,
type = g.Key.TypeValue,
Count = g.Count(),
};
var list = from e in q.ToList()
let f = ev.SingleOrDefault(ff => ff.name == e.Field)
where f == null || f.UserCanView()
orderby e.Field
select e;
return(View(list));
}
public ActionResult ExtraValues()
{
var ev = StandardExtraValues.GetExtraValues();
var q = from e in DbUtil.Db.PeopleExtras
where e.StrValue != null || e.BitValue != null
let TypeValue = e.StrValue != null ? "Code" : "Bit"
group e by new { e.Field, val = e.StrValue ?? (e.BitValue == true ? "1" : "0"), TypeValue } into g
select new ExtraInfo
{
Field = g.Key.Field,
Value = g.Key.val,
type = g.Key.TypeValue,
Count = g.Count(),
};
var list = from e in q.ToList()
let f = ev.SingleOrDefault(ff => ff.name == e.Field)
where f == null || f.UserCanView()
orderby e.Field
select e;
return(View(list));
}
public ActionResult ContentUpdate(int id, string name, string title, string body, int?roleid, string stayaftersave = null)
{
var content = DbUtil.ContentFromID(id);
content.Name = name;
content.Title = title;
content.Body = body;
content.RoleID = roleid ?? 0;
string sRenderType = DbUtil.Db.Setting("RenderEmailTemplate", "none");
if (content.TypeID == ContentTypeCode.TypeEmailTemplate)
{
// switch (sRenderType)
// {
// case "Local":// Uses local server resources
// case "true":
var captureWebPageBytes = CaptureWebPageBytes(body, 100, 150);
var ii = ImageData.Image.UpdateImageFromBits(content.ThumbID, captureWebPageBytes);
if (ii == null)
{
content.ThumbID = ImageData.Image.NewImageFromBits(captureWebPageBytes).Id;
}
// break;
//
// case "Service": // Used to send HTML to another server for offloaded processing
// var coll = new NameValueCollection();
// coll.Add("sHTML", body.Replace("\r", "").Replace("\n", "").Replace("\t", ""));
//
// var wc = new WebClient();
// var resp = wc.UploadValues(ConfigurationManager.AppSettings["CreateThumbnailService"], "POST",
// coll);
//
// ii = ImageData.DbUtil.Db.Images.FirstOrDefault(i => i.Id == content.ThumbID);
// if (ii != null)
// ImageData.Image.UpdateImageFromBits(content.ThumbID, resp);
// else
// content.ThumbID = ImageData.Image.NewImageFromBits(resp).Id;
// break;
// }
content.DateCreated = DateTime.Now;
}
DbUtil.Db.SubmitChanges();
if (string.Compare(content.Name, "StandardExtraValues2", ignoreCase: true) == 0)
{
try
{
StandardExtraValues.GetExtraValues();
}
catch (InvalidOperationException ex)
{
if (ex.InnerException is System.Xml.XmlException)
{
return(Content(Util.EndShowMessage(ex.InnerException.Message, "javascript: history.go(-1)", "Go Back to Repair")));
}
}
}
if (stayaftersave == "true")
{
return(RedirectEdit(content));
}
return(RedirectToAction("Index"));
}
public void SetVisibility()
{
RightPanelVisible = true;
TextVisible = false;
NumberVisible = false;
CodeVisible = false;
CodesVisible = false;
DateVisible = false;
CodeData = null;
ConditionName = ConditionName;
CompareData = Comparisons().ToList();
DivisionVisible = fieldMap.HasParam("Division");
ProgramVisible = fieldMap.HasParam("Program");
OrganizationVisible = fieldMap.HasParam("Organization");
ScheduleVisible = fieldMap.HasParam("Schedule");
CampusVisible = fieldMap.HasParam("Campus");
OrgTypeVisible = fieldMap.HasParam("OrgType");
DaysVisible = fieldMap.HasParam("Days");
AgeVisible = fieldMap.HasParam("Age");
SavedQueryVisible = fieldMap.HasParam("SavedQueryIdDesc");
MinistryVisible = fieldMap.HasParam("Ministry");
QuartersVisible = fieldMap.HasParam("Quarters");
if (QuartersVisible)
{
QuartersLabel = fieldMap.QuartersTitle;
}
TagsVisible = fieldMap.HasParam("Tags");
if (TagsVisible)
{
var cv = new CodeValueModel();
TagData = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Code");
}
PmmLabelsVisible = fieldMap.HasParam("PmmLabels");
if (PmmLabelsVisible)
{
var cv = new CodeValueModel();
PmmLabelData = CodeValueModel.ConvertToSelect(cv.PmmLabels(), "Code");
}
StartDateVisible = fieldMap.HasParam("StartDate");
EndDateVisible = fieldMap.HasParam("EndDate");
var cvctl = new CodeValueModel();
switch (fieldMap.Type)
{
case FieldType.Bit:
case FieldType.NullBit:
CodeVisible = true;
CodeData = CodeValueModel.ConvertToSelect(BitCodes, fieldMap.DataValueField);
break;
case FieldType.String:
case FieldType.StringEqual:
case FieldType.StringEqualOrStartsWith:
TextVisible = true;
break;
case FieldType.NullNumber:
case FieldType.Number:
NumberVisible = true;
break;
case FieldType.NullInteger:
case FieldType.Integer:
case FieldType.IntegerSimple:
case FieldType.IntegerEqual:
IntegerVisible = true;
break;
case FieldType.NullCode:
case FieldType.Code:
case FieldType.CodeStr:
CodeVisible = true;
if (fieldMap.DataSource == "ExtraValues")
{
CodeData = StandardExtraValues.ExtraValueCodes();
}
else if (fieldMap.DataSource == "Campuses")
{
CodeData = Campuses();
}
else
{
CodeData = CodeValueModel.ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField);
}
break;
case FieldType.Date:
case FieldType.DateSimple:
DateVisible = true;
break;
case FieldType.DateField:
CodeVisible = true;
CodeData = CodeValueModel.ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField);
break;
}
var cc = Db.LoadQueryById(SelectedId);
if (cc == null)
{
return;
}
if (fieldMap.Type == FieldType.Group)
{
CompareData = Comparisons().ToList();
RightPanelVisible = false;
UpdateEnabled = cc.IsGroup;
return;
}
UpdateEnabled = !cc.IsGroup && !cc.IsFirst;
AddToGroupEnabled = cc.IsGroup;
AddEnabled = !cc.IsFirst;
RemoveEnabled = !cc.IsFirst;
}
public void ConvertToStandard(string name)
{
var oldfields = StandardExtraValues.GetExtraValues().ToList();
StandardExtraValues.Field bits = null;
ExtraValue ev = null;
List <string> codes = null;
var v = new CmsData.ExtraValue.Value {
Name = name
};
switch (ExtraValueTable)
{
case "People":
ev = (from vv in DbUtil.Db.PeopleExtras
where vv.Field == name
select new ExtraValue(vv, null)).First();
bits = oldfields.SingleOrDefault(ff => ff.Codes.Contains(name));
if (bits != null)
{
codes = bits.Codes;
ev.Type = "Bits";
v.Name = bits.name;
v.VisibilityRoles = bits.VisibilityRoles;
}
else
{
var f = oldfields.SingleOrDefault(ff => ff.name == name);
if (f != null)
{
v.VisibilityRoles = f.VisibilityRoles;
}
if (ev.Type == "Code")
{
codes = (from vv in DbUtil.Db.PeopleExtras
where vv.Field == name
select vv.StrValue).Distinct().ToList();
}
}
break;
case "Organization":
ev = (from vv in DbUtil.Db.OrganizationExtras
where vv.Field == name
select new ExtraValue(vv, null)).First();
if (ev.Type == "Code")
{
codes = (from vv in DbUtil.Db.OrganizationExtras
where vv.Field == name
select vv.StrValue).Distinct().ToList();
}
break;
case "Family":
ev = (from vv in DbUtil.Db.FamilyExtras
where vv.Field == name
select new ExtraValue(vv, null)).First();
if (ev.Type == "Code")
{
codes = (from vv in DbUtil.Db.FamilyExtras
where vv.Field == name
select vv.StrValue).Distinct().ToList();
}
break;
case "Meeting":
ev = (from vv in DbUtil.Db.MeetingExtras
where vv.Field == name
select new ExtraValue(vv, null)).First();
if (ev.Type == "Code")
{
codes = (from vv in DbUtil.Db.MeetingExtras
where vv.Field == name
select vv.StrValue).Distinct().ToList();
}
break;
default:
return;
}
v.Type = ev.Type;
v.Codes = codes;
var i = Views.GetViewsView(DbUtil.Db, ExtraValueTable, ExtraValueLocation);
i.view.Values.Add(v);
i.views.Save(DbUtil.Db);
}
