public static List<MissionTripTotal> List(OrgSearchModel m)
{
var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId));
var q = from t in DbUtil.Db.ViewMissionTripTotals
join i in DbUtil.Db.SplitInts(orgids) on t.OrganizationId equals i.ValueX
orderby t.OrganizationId, t.SortOrder
select t;
return q.ToList();
}
public static List <MissionTripTotal> List(OrgSearchModel m)
{
var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId));
var q = from t in DbUtil.Db.ViewMissionTripTotals
join i in DbUtil.Db.SplitInts(orgids) on t.OrganizationId equals i.ValueX
orderby t.OrganizationId, t.SortOrder
select t;
return(q.ToList());
}
public ActionResult ApplyType(int id, OrgSearchModel m)
{
int? t = (id == -1 ? (int?) null : id);
if (t == 0)
return Content("");
var ot = DbUtil.Db.OrganizationTypes.SingleOrDefault(tt => tt.Id == id);
if (t.HasValue || ot != null)
foreach (var o in m.FetchOrgs())
o.OrganizationTypeId = t;
else
return Content("error: missing type");
DbUtil.Db.SubmitChanges();
return Content("ok");
}
public ActionResult RepairTransactions(OrgSearchModel m)
{
foreach (var o in m.FetchOrgs())
DbUtil.Db.PopulateComputedEnrollmentTransactions(o.OrganizationId);
return new EmptyResult();
}
public ActionResult PasteSettings(OrgSearchModel m)
{
var frorg = (int)Session["OrgCopySettings"];
foreach (var o in m.FetchOrgs())
o.CopySettings(DbUtil.Db, frorg);
return new EmptyResult();
}
public ActionResult OrganizationStructure(bool? active, OrgSearchModel m)
{
var orgs = m.FetchOrgs();
var q = from os in DbUtil.Db.ViewOrganizationStructures
join o in orgs on os.OrgId equals o.OrganizationId
select os;
return View(q.OrderBy(oo => oo.Program).ThenBy(oo => oo.Division).ThenBy(oo => oo.Organization));
}
public static EpplusResult List(OrgSearchModel m)
{
var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId));
return(Result(SenderGifts(orgids)));
}
public ActionResult ShirtSizes(string org, OrgSearchModel m)
{
var orgid = org == "curr" ? (int?)Util2.CurrentOrgId : null;
var orgs = m.FetchOrgs();
var q = from om in DbUtil.Db.OrganizationMembers
join o in orgs on om.OrganizationId equals o.OrganizationId
where o.OrganizationId == orgid || (orgid ?? 0) == 0
group 1 by om.ShirtSize into g
select new ShirtSizeInfo
{
Size = g.Key,
Count = g.Count(),
};
return View(q);
}
public ActionResult MeetingsForDateRange(DateTime dt1, DateTime dt2, OrgSearchModel m)
{
var orgs = string.Join(",", m.FetchOrgs().Select(oo => oo.OrganizationId));
var cn = new SqlConnection(Util.ConnectionString);
cn.Open();
var q = cn.Query("MeetingsForDateRange", new
{
orgs,
startdate = dt1,
enddate = dt2,
}, commandType: CommandType.StoredProcedure, commandTimeout: 600);
var entity = (IDictionary<string, object>) q.First();
var cols = entity.Keys.Cast<string>().ToList();
var ep = new ExcelPackage();
var ws = ep.Workbook.Worksheets.Add("Sheet1");
int row = 1;
for (var i = 0; i < cols.Count; i++)
ws.Cells[row, i+1].Value = cols[i];
row++;
foreach (var r in q)
{
var rr = (IDictionary<string, object>) r;
for (var i = 0; i < cols.Count; i++)
ws.Cells[row, i+1].Value = rr[cols[i]];
row++;
}
ws.Cells[ws.Dimension.Address].AutoFitColumns();
return new EpplusResult(ep, "MeetingsForDateRange.xlsx");
}
public ActionResult MeetingsForMonth(DateTime dt1, OrgSearchModel m)
{
var orgs = string.Join(",", m.FetchOrgs().Select(oo => oo.OrganizationId));
var cn = new SqlConnection(Util.ConnectionString);
cn.Open();
ViewBag.Month = dt1.ToString("MMMM yyyy");
dt1 = new DateTime(dt1.Year, dt1.Month, 1);
var dt2 = dt1.AddMonths(1).AddDays(-1);
var q = cn.Query("MeetingsForDateRange", new
{
orgs,
startdate = dt1,
enddate = dt2,
}, commandType: CommandType.StoredProcedure, commandTimeout: 600);
return View(q);
}
public ActionResult CreateMeetings(DateTime dt, OrgSearchModel model)
{
foreach (var o in model.FetchOrgs())
{
var mt = DbUtil.Db.Meetings.SingleOrDefault(m => m.MeetingDate == dt
&& m.OrganizationId == o.OrganizationId);
if (mt != null)
continue;
mt = new CmsData.Meeting
{
CreatedDate = Util.Now,
CreatedBy = Util.UserId1,
OrganizationId = o.OrganizationId,
Location = o.Location,
MeetingDate = dt,
};
DbUtil.Db.Meetings.InsertOnSubmit(mt);
DbUtil.Db.SubmitChanges();
}
DbUtil.LogActivity("Creating new meetings from OrgSearch");
return Content("done");
}
public static EpplusResult List(OrgSearchModel m)
{
var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId));
return Result(SenderGifts(orgids));
}
