private static string ClassName(CmsData.Organization o)
{
var lead = o.LeaderName;
if (lead.HasValue())
{
lead = ": " + lead;
}
var loc = o.Location;
if (loc.HasValue())
{
loc = " ({0})".Fmt(loc);
}
var dt1 = o.FirstMeetingDate;
var dt2 = o.LastMeetingDate;
var dt = "";
if (dt1.HasValue && dt2.HasValue)
{
dt = ", {0:MMM d}-{1:MMM d}".Fmt(dt1, dt2);
}
else if (dt1.HasValue)
{
dt = ", {0:MMM d}".Fmt(dt1);
}
return(o.OrganizationName + lead + dt + loc);
}
public void populateFromOrg(Organization org)
{
values["SGF:OrgID"] = org.OrganizationId.ToString();
values["SGF:Name"] = org.OrganizationName;
values["SGF:Description"] = org.Description;
values["SGF:Room"] = org.Location;
values["SGF:Leader"] = org.LeaderName;
values["SGF:DateStamp"] = DateTime.Now.ToString("yyyy-MM-dd");
values["SGF:Schedule"] = "";
if (org.OrgSchedules.Count > 0)
{
int count = 0;
foreach (var schedule in org.OrgSchedules)
{
if (count > 0) values["SGF:Schedule"] += "; ";
values["SGF:Schedule"] += DAY_LAST[schedule.SchedDay ?? 0] + ", " + schedule.SchedTime.ToString2("t"); ;
count++;
}
}
foreach (var extra in org.OrganizationExtras)
{
if (extra.Field.StartsWith("SGF:"))
values[extra.Field] = extra.Data;
}
}
public ManageSubsModel(int pid, int id)
{
this.pid = pid;
var org = DbUtil.Db.LoadOrganizationById(id);
if (org.RegistrationTypeId != RegistrationTypeCode.ManageSubscriptions2)
throw new Exception("must be a ManageSubscriptions RegistrationType");
masterorgid = id;
_masterorg = org;
}
public SearchAddModel(string context, string contextid, bool displaySkipSearch = true)
: this()
{
DisplaySkipSearch = displaySkipSearch;
AddContext = context;
PrimaryKeyForContextType = contextid;
CampusId = null;
switch (AddContext.ToLower())
{
case "addpeople":
case "menu":
EntryPointId = 0;
break;
case "addtotag":
EntryPointId = null;
break;
case "mergeto":
EntryPointId = null;
break;
case "family":
case "relatedfamily":
EntryPointId = 0;
break;
case "org":
case "pending":
case "prospect":
case "inactive":
org = DbUtil.Db.LoadOrganizationById(contextid.ToInt());
CampusId = org.CampusId;
EntryPointId = org.EntryPointId ?? 0;
break;
case "visitor":
case "registered":
org = (from meeting in DbUtil.Db.Meetings
where meeting.MeetingId == contextid.ToInt()
select meeting.Organization).Single();
EntryPointId = org.EntryPointId ?? 0;
CampusId = org.CampusId;
break;
case "contactee":
EntryPointId = 0;
break;
case "contactor":
EntryPointId = 0;
break;
case "contributor":
EntryPointId = 0;
break;
case "addtoemail":
EntryPointId = 0;
break;
}
}
public static IQueryable<Organization> UserSelectClasses(Organization masterorg)
{
if (!masterorg.OrgPickList.HasValue())
return DbUtil.Db.Organizations.Where(oo => false);
var cklist = masterorg.OrgPickList.Split(',').Select(oo => oo.ToInt()).ToList();
var q = from o in DbUtil.Db.Organizations
where cklist.Contains(o.OrganizationId)
select o;
return q;
}
public MeetingModel(int id)
{
var i = (from m in DbUtil.Db.Meetings
where m.MeetingId == id
select new
{
org = m.Organization,
m,
}).Single();
meeting = i.m;
org = i.org;
}
public ManageSubsModel(int pid, int id)
{
this.pid = pid;
var org = DbUtil.Db.LoadOrganizationById(id);
if (org.RegistrationTypeId != RegistrationTypeCode.ManageSubscriptions2)
{
throw new Exception("must be a ManageSubscriptions RegistrationType");
}
masterorgid = id;
_masterorg = org;
}
public void CheckMasterOrg()
{
if (org != null && masterorgid == null &&
(org.RegistrationTypeId == RegistrationTypeCode.UserSelects
|| org.RegistrationTypeId == RegistrationTypeCode.ComputeOrgByAge
|| org.RegistrationTypeId == RegistrationTypeCode.ManageSubscriptions))
{
_masterOrg = org;
masterorgid = Orgid;
_orgid = null;
_org = null;
}
}
public MeetingModel(int id)
{
var i = (from m in DbUtil.Db.Meetings
where m.MeetingId == id
select new
{
org = m.Organization,
m
}).Single();
meeting = i.m;
org = i.org;
}
public MeetingModel(int id)
{
var i = (from m in DbUtil.Db.Meetings
where m.MeetingId == id
select new
{
org = m.Organization,
m,
}).SingleOrDefault();
if (i == null)
return;
meeting = i.m;
org = i.org;
}
public static void CopySettings2(Organization frorg, Organization toorg)
{
toorg.AllowNonCampusCheckIn = frorg.AllowNonCampusCheckIn;
toorg.AllowAttendOverlap = frorg.AllowAttendOverlap;
toorg.CanSelfCheckin = frorg.CanSelfCheckin;
toorg.NumWorkerCheckInLabels = frorg.NumWorkerCheckInLabels;
toorg.NoSecurityLabel = frorg.NoSecurityLabel;
toorg.NumCheckInLabels = frorg.NumCheckInLabels;
toorg.PhoneNumber = frorg.PhoneNumber;
toorg.EntryPointId = frorg.EntryPointId;
toorg.RollSheetVisitorWks = frorg.RollSheetVisitorWks;
toorg.GradeAgeStart = frorg.GradeAgeStart;
toorg.DivisionId = frorg.DivisionId;
}
public static List<ClassInfo> Classes(Organization masterorg, int id)
{
var q = from o in OrderedClasses(masterorg)
let hasroom = (o.ClassFilled ?? false) == false && ((o.Limit ?? 0) == 0 || o.Limit > o.RegLimitCount(DbUtil.Db))
where o.RegistrationTypeId > 0
select new ClassInfo
{
Id = o.OrganizationId,
Text = ClassName(o),
selected = o.OrganizationId == id,
filled = !hasroom
};
var list = q.ToList();
return list;
}
public ManageSubsModel(int pid, int id)
{
this.pid = pid;
var org = DbUtil.Db.LoadOrganizationById(id);
if (org != null && org.RegistrationTypeId == RegistrationTypeCode.ManageSubscriptions2)
{
this.masterorgid = id;
_masterorg = org;
}
else
{
this.divid = id;
}
}
public void populateFromOrg(Organization org)
{
values["SGF:OrgID"] = org.OrganizationId.ToString();
values["SGF:Name"] = org.OrganizationName;
values["SGF:Description"] = org.Description;
values["SGF:Room"] = org.Location;
values["SGF:Leader"] = org.LeaderName;
values["SGF:DateStamp"] = DateTime.Now.ToString("yyyy-MM-dd");
foreach (var extra in org.OrganizationExtras)
{
if (extra.Field.StartsWith("SGF:"))
values[extra.Field] = extra.Data;
}
}
public static Organization CreateOrganization(CMSDataContext Db, Division division, string organization)
{
var o = new Organization
{
OrganizationName = organization,
SecurityTypeId = 0,
CreatedDate = Util.Now,
CreatedBy = Util.UserId1,
OrganizationStatusId = 30,
};
division.Organizations.Add(o);
Db.DivOrgs.InsertOnSubmit(new DivOrg { Division = division, Organization = o });
Db.SubmitChanges();
return o;
}
public Dictionary<string, string> GetValuesDictionary(Organization org, bool loadAllValues)
{
var values = new Dictionary<string, string>();
var leader = (from e in DbUtil.Db.People
where e.PeopleId == org.LeaderId
select e).SingleOrDefault();
values["SGF:OrgID"] = org.OrganizationId.ToString();
values["SGF:Name"] = org.OrganizationName;
values["SGF:Description"] = org.Description;
values["SGF:Room"] = org.Location;
values["SGF:Leader"] = org.LeaderName;
values["SGF:DateStamp"] = DateTime.Now.ToString("yyyy-MM-dd");
values["SGF:Schedule"] = "";
if (leader != null && leader.PictureId != null)
values["SGF:LeaderPicSrc"] = "/Portrait/" + leader.Picture.SmallId.Value + "?v=" + DateTime.Now.ToString("yyyyMMddHHmmssffff");
else
values["SGF:LeaderPicSrc"] = "/Portrait/-3";
if (org.OrgSchedules.Count > 0)
{
var count = 0;
foreach (var schedule in org.OrgSchedules)
{
if (count > 0) values["SGF:Schedule"] += "; ";
values["SGF:Schedule"] += GroupLookup.DAY_LAST[schedule.SchedDay ?? 0] + ", " + schedule.SchedTime.ToString2("t"); ;
count++;
}
}
foreach (var extra in org.OrganizationExtras)
{
var val = extra.Data ??
extra.StrValue ??
extra.DateValue?.ToString() ??
extra.IntValue?.ToString() ??
extra.BitValue?.ToString();
if (extra.Field.StartsWith("SGF:"))
values[extra.Field] = val;
else if (loadAllValues)
values[$"SGF:{extra.Field}"] = val;
}
return values;
}
private void FetchEntities(int aid, int? pid)
{
var q = from attend in Db.Attends
where attend.AttendId == aid
let p = Db.People.SingleOrDefault(pp => pp.PeopleId == pid)
select new
{
attend,
org = attend.Organization,
person = p,
};
var i = q.SingleOrDefault();
org = i.org;
this.attend = i.attend;
person = i.person;
}
public MeetingModel(int id)
{
var i = (from m in DbUtil.Db.Meetings
where m.MeetingId == id
select new
{
org = m.Organization,
m,
}).SingleOrDefault();
if (i == null)
{
return;
}
meeting = i.m;
org = i.org;
}
public static List<Organization> OrderedClasses(Organization masterorg)
{
if (masterorg == null)
throw new Exception("masterorg is null in OrderedClasses");
var cklist = masterorg.OrgPickList.Split(',').Select(oo => oo.ToInt()).ToList();
var list = UserSelectClasses(masterorg).ToList();
var d = new Dictionary<int, int>();
var n = 0;
foreach (var i in cklist)
d.Add(n++, i);
list = (from o in list
join i in d on o.OrganizationId equals i.Value into j
from i in j
orderby i.Key
select o).ToList();
return list;
}
public static List<ClassInfo> Classes(Organization masterorg, int id)
{
var q = from o in OrderedClasses(masterorg)
let hasroom = (o.ClassFilled ?? false) == false && ((o.Limit ?? 0) == 0 || o.Limit > (o.MemberCount ?? 0))
where o.RegistrationTypeId > 0
select new ClassInfo
{
Id = o.OrganizationId,
Text = ClassName(o),
selected = o.OrganizationId == id,
filled = !hasroom
};
var list = q.ToList();
if (list.Count == 1)
return list;
list.Insert(0, new ClassInfo { Text = "Registration Options", Id = 0});
return list;
}
private static string ClassName(Organization o)
{
var lead = o.LeaderName;
if (lead.HasValue())
lead = ": " + lead;
var loc = o.Location;
if (loc.HasValue())
loc = $" ({loc})";
var dt1 = o.FirstMeetingDate;
var dt2 = o.LastMeetingDate;
var dt = "";
if (dt1.HasValue && dt2.HasValue)
dt = $", {dt1:MMM d}-{dt2:MMM d}";
else if (dt1.HasValue)
dt = $", {dt1:MMM d}";
return o.OrganizationName + lead + dt + loc;
}
public static List<OrgPickInfo> OrganizationsFromIdString(Organization Org)
{
var a = Org.OrgPickList.SplitStr(",").Select(ss => ss.ToInt()).ToArray();
var n = 0;
var d = a.ToDictionary(i => n++);
var q = (from o in DbUtil.Db.Organizations
where a.Contains(o.OrganizationId)
select new OrgPickInfo
{
OrganizationId = o.OrganizationId,
OrganizationName = o.OrganizationName
}).ToList();
var list = (from op in q
join i in d on op.OrganizationId equals i.Value into j
from i in j
orderby i.Key
select op).ToList();
return list;
}
public int AddOrganization(string name, int? templateid = null, bool copysettings = true)
{
using (var db2 = NewDataContext())
{
var org = db2.LoadOrganizationById(templateid);
if (org == null)
{
org = new Organization() {DivisionId = 1};
copysettings = false;
}
var neworg = new Organization
{
OrganizationName = name,
CreatedDate = Util.Now,
CreatedBy = Util.UserId1,
EntryPointId = org.EntryPointId,
OrganizationTypeId = org.OrganizationTypeId,
CampusId = org.CampusId,
OrganizationStatusId = 30,
DivisionId = org.DivisionId,
};
db2.Organizations.InsertOnSubmit(neworg);
db2.SubmitChanges();
foreach (var div in org.DivOrgs)
neworg.DivOrgs.Add(new DivOrg {Organization = neworg, DivId = div.DivId});
if (copysettings && templateid > 0)
{
foreach (var sc in org.OrgSchedules)
neworg.OrgSchedules.Add(new OrgSchedule
{
OrganizationId = neworg.OrganizationId,
AttendCreditId = sc.AttendCreditId,
SchedDay = sc.SchedDay,
SchedTime = sc.SchedTime,
Id = sc.Id
});
neworg.CopySettings(db2, templateid.Value);
}
db2.SubmitChanges();
db.LogActivity($"Python NewOrganization{neworg.OrganizationName} ({neworg.OrganizationId})");
return neworg.OrganizationId;
}
}
private void Populate()
{
var i = (from mm in DbUtil.Db.OrganizationMembers
where mm.OrganizationId == OrgId && mm.PeopleId == PeopleId
select new
{
mm,
mm.Person.Name,
mm.Organization.OrganizationName,
mm.Organization.RegSetting,
mm.Organization,
mm.OrgMemMemTags,
mm.Organization.IsMissionTrip,
ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == mm.TranId && tt.PeopleId == PeopleId)
}).SingleOrDefault();
if (i == null)
{
throw new Exception("missing OrgMember at oid={0}, pid={1}".Fmt(OrgId, PeopleId));
}
om = i.mm;
TransactionSummary = i.ts;
this.CopyPropertiesFrom(om);
Name = i.Name;
IsMissionTrip = i.IsMissionTrip ?? false;
if (TransactionSummary != null)
{
AmountPaidTransactions = IsMissionTrip
? om.TotalPaid(DbUtil.Db)
: TransactionSummary.IndPaid;
AmountDue = IsMissionTrip
? om.AmountDue(DbUtil.Db)
: TransactionSummary.IndDue;
}
OrgName = i.OrganizationName;
Organization = i.Organization;
OrgMemMemTags = i.OrgMemMemTags.ToList();
Setting = new Settings(i.RegSetting, DbUtil.Db, OrgId ?? 0);
}
private void Populate()
{
if (dopopulate)
{
dopopulate = false;
if (!OrgId.HasValue || !PeopleId.HasValue)
return;
}
var i = (from mm in DbUtil.Db.OrganizationMembers
where mm.OrganizationId == OrgId && mm.PeopleId == PeopleId
select new
{
mm,
mm.Person.Name,
mm.Organization.OrganizationName,
mm.Organization,
mm.OrgMemMemTags,
mm.Organization.IsMissionTrip,
ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == mm.TranId && tt.PeopleId == PeopleId && tt.OrganizationId == OrgId)
}).SingleOrDefault();
if (i == null)
throw new Exception($"missing OrgMember at oid={OrgId}, pid={PeopleId}");
OrgMember = i.mm;
TransactionSummary = i.ts;
this.CopyPropertiesFrom(OrgMember);
Name = i.Name;
IsMissionTrip = i.IsMissionTrip ?? false;
AmtFee = i.ts?.IndPaid + i.ts?.IndDue;
AmtDonation = i.ts?.IndAmt - AmtFee;
AmtCoupon = i.ts?.TotCoupon;
AmtPaid = OrgMember.AmountPaidTransactions(DbUtil.Db);
AmtDue = OrgMember.AmountDueTransactions(DbUtil.Db);
OrgName = i.OrganizationName;
Organization = i.Organization;
OrgMemMemTags = i.OrgMemMemTags.ToList();
Setting = DbUtil.Db.CreateRegistrationSettings(OrgId ?? 0);
}
public int AddOrganization(string name, string program, string division)
{
using (var db2 = NewDataContext())
{
var prog = Organization.FetchOrCreateProgram(db2, program);
var div = Organization.FetchOrCreateDivision(db2, prog, division);
var neworg = new Organization
{
OrganizationName = name,
CreatedDate = Util.Now,
CreatedBy = Util.UserId1,
OrganizationStatusId = 30,
DivisionId = div.Id,
};
db2.Organizations.InsertOnSubmit(neworg);
db2.SubmitChanges();
neworg.DivOrgs.Add(new DivOrg() {Organization = neworg, DivId = div.Id});
db2.SubmitChanges();
db.LogActivity($"Python AddOrganization({neworg.OrganizationName}, {program}, {division})");
return neworg.OrganizationId;
}
}
public void populateFromOrg(Organization org)
{
var leader = (from e in DbUtil.Db.People
where e.PeopleId == org.LeaderId
select e).SingleOrDefault();
values["SGF:OrgID"] = org.OrganizationId.ToString();
values["SGF:Name"] = org.OrganizationName;
values["SGF:Description"] = org.Description;
values["SGF:Room"] = org.Location;
values["SGF:Leader"] = org.LeaderName;
values["SGF:DateStamp"] = DateTime.Now.ToString("yyyy-MM-dd");
values["SGF:Schedule"] = "";
if (leader != null && leader.PictureId != null)
values["SGF:LeaderPicSrc"] = "/Portrait/" + leader.Picture.SmallId.Value + "?v=" + DateTime.Now.ToString("yyyyMMddHHmmssffff");
else
values["SGF:LeaderPicSrc"] = "/Portrait/-3";
if (org.OrgSchedules.Count > 0)
{
int count = 0;
foreach (var schedule in org.OrgSchedules)
{
if (count > 0) values["SGF:Schedule"] += "; ";
values["SGF:Schedule"] += DAY_LAST[schedule.SchedDay ?? 0] + ", " + schedule.SchedTime.ToString2("t"); ;
count++;
}
}
foreach (var extra in org.OrganizationExtras)
{
if (extra.Field.StartsWith("SGF:"))
values[extra.Field] = extra.Data;
}
}
private void Populate()
{
if (dopopulate)
{
dopopulate = false;
if (!OrgId.HasValue || !PeopleId.HasValue)
return;
}
var i = (from et in DbUtil.Db.EnrollmentTransactions
where et.OrganizationId == OrgId && et.PeopleId == PeopleId
where et.TransactionTypeId == 5
orderby et.TransactionDate descending
select new
{
et,
et.Person.Name,
et.Organization.OrganizationName,
et.Organization,
et.SmallGroups,
ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(
ts => ts.RegId == et.TranId && ts.PeopleId == PeopleId && ts.OrganizationId == OrgId)
}
).FirstOrDefault();
if (i == null)
throw new Exception($"missing PrevOrgMember at oid={OrgId}, pid={PeopleId}");
PrevMember = i.et;
TransactionSummary = i.ts;
this.CopyPropertiesFrom(PrevMember);
Name = i.Name;
AmtFee = i.ts?.IndPaid + i.ts?.IndDue;
AmtDonation = i.ts?.IndAmt - AmtFee;
AmtCoupon = i.ts?.TotCoupon;
OrgName = i.OrganizationName;
Organization = i.Organization;
OrgMemMemTags = i.SmallGroups.SplitStr("\n").ToList();
Setting = DbUtil.Db.CreateRegistrationSettings(OrgId ?? 0);
}
private void detach_Organizations(Organization entity)
{
this.SendPropertyChanging();
entity.Campu = null;
}
public static List<SelectListItem> ShirtSizes(CMSDataContext Db, Organization org)
{
var setting = new Settings(org.RegSetting, Db, org.OrganizationId);
return ShirtSizes(setting);
}
private void attach_Organizations(Organization entity)
{
this.SendPropertyChanging();
entity.OrganizationType = this;
}
public Organization CloneOrg(CMSDataContext Db, int? DivisionId)
{
var neworg = new Organization
{
SecurityTypeId = SecurityTypeId,
CreatedDate = Util.Now,
CreatedBy = Util.UserId1,
LeaderMemberTypeId = LeaderMemberTypeId,
OrganizationName = OrganizationName + " (copy)",
OrganizationStatusId = OrganizationStatusId,
CampusId = CampusId,
IsBibleFellowshipOrg = IsBibleFellowshipOrg,
};
Db.Organizations.InsertOnSubmit(neworg);
foreach (var div in DivOrgs)
neworg.DivOrgs.Add(new DivOrg { Organization = neworg, DivId = div.DivId });
foreach (var sc in OrgSchedules)
neworg.OrgSchedules.Add(new OrgSchedule
{
OrganizationId = OrganizationId,
AttendCreditId = sc.AttendCreditId,
SchedDay = sc.SchedDay,
SchedTime = sc.SchedTime,
Id = sc.Id
});
CopySettings2(this, neworg);
Db.SubmitChanges();
return neworg;
}
private void detach_Organizations(Organization entity)
{
this.SendPropertyChanging();
entity.EntryPoint = null;
}
private void attach_Organizations(Organization entity)
{
this.SendPropertyChanging();
entity.EntryPoint = this;
}
public static IEnumerable<SelectListItem> ShirtSizes(CMSDataContext Db, Organization org)
{
var setting = Db.CreateRegistrationSettings(org.OrganizationId);
return ShirtSizes(setting);
}
private void attach_Organizations(Organization entity)
{
this.SendPropertyChanging();
entity.Campu = this;
}
private void detach_Organizations(Organization entity)
{
this.SendPropertyChanging();
entity.Division = null;
}
private void detach_ChildOrgs(Organization entity)
{
this.SendPropertyChanging();
entity.ParentOrg = null;
}
private bool IsEnded(Organization o)
{
if (o != null)
return o.ClassFilled == true;
return false;
}
