protected void Page_Load(object sender, EventArgs e)
{
DateTime time = UKTime.Now.Date;
if (!String.IsNullOrEmpty(Request.QueryString["date"]))
{
Session["calendardate"] = Request.QueryString["date"];
time = CRM.Code.Utils.Text.Text.FormatInputDate(Request.QueryString["date"]);
}
else if (Session["calendardate"] != null)
{
time = CRM.Code.Utils.Text.Text.FormatInputDate((string)Session["calendardate"]);
}
DateTime startDate = time.StartOfWeek(DayOfWeek.Monday);
CurrentDate = startDate;
DateTime endDate = startDate.AddDays(7);
List <DateTime> dates = new List <DateTime>();
while (startDate < endDate)
{
dates.Add(startDate);
startDate = startDate.AddDays(1);
}
if (Request.QueryString["venue"] != null)
{
CRM_Venue = db.CRM_Venues.SingleOrDefault(v => v.ID.ToString() == Request.QueryString["venue"]);
}
rptDays.DataSource = dates;
rptDays.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// set date to start but will be pulling from cookie after initial users load.
hdnCalendarCurrentDate.Value = UKTime.Now.ToString("dd-MM-yyyy");
rptKey.DataSource = from p in db.CRM_CalendarTypes
orderby p.OrderNo
select p;
rptKey.DataBind();
ddlVenueFilter.DataSource = from p in CRM_Venue.BaseSet(db)
orderby p.IsInternal descending, p.Name
select p.ListItem;
ddlVenueFilter.DataBind();
ddlPersonCalendar.DataSource = from p in db.Admins.ToArray()
orderby p.FirstName, p.Surname
select p;
ddlPersonCalendar.DataBind();
}
}
protected void lnkSelect_Click(object sender, EventArgs e)
{
CRM_Venue venue = db.CRM_Venues.Single(v => v.Reference.ToString() == acVenue.SelectedID);
acVenue.Populate(venue);
}
public void ProcessRequest(HttpContext context)
{
string JSONOutput = EmptyOutput;
context.Response.AddHeader("Content-type", "text/json");
using (MainDataContext db = new MainDataContext())
{
string dataset = context.Request.QueryString["dataset"];
int parseddataset = Enumeration.GetEnumValueByName <JSONSet.DataSets>(dataset);
string searchCriteria = HttpUtility.HtmlDecode(context.Request.QueryString["query"]).ToLower();
IEnumerable <JSONSet> jsonItems = Enumerable.Empty <JSONSet>();
switch (parseddataset)
{
case (int)JSONSet.DataSets.venue:
{
var venues = CRM_Venue.BaseSet(db);
jsonItems = from p in venues
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Name + " : " + p.CRM_Address.FormattedAddressBySep(", "), p.CRM_Address.Postcode, p.Reference.ToString(), "", p.Reference);
}
break;
case (int)JSONSet.DataSets.person:
{
var persons = CRM_Person.BaseSet(db);
jsonItems = from p in persons
where !p.IsArchived
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Fullname + " : " + p.PrimaryAddressRecord.FormattedAddressBySep(", "), p.DateOfBirthOutput, p.ID.ToString(), p.Photo, p.Reference);
}
break;
case (int)JSONSet.DataSets.archivedperson:
{
var persons = db.CRM_Persons;
jsonItems = from p in (from p in persons
where p.IsArchived
select p).ToList()
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Fullname + " : " + p.PrimaryAddressRecord.FormattedAddressBySep(", "), p.DateOfBirthOutput, p.Reference.ToString(), p.Photo, p.Reference);
}
break;
case (int)JSONSet.DataSets.contact:
{
var unarchivedContacts = from p in CRM.Code.Utils.SharedObject.SharedObject.GetSharedObjects <IContact>(db)
where !p.IsArchived
select p;
jsonItems = from p in unarchivedContacts
where p.Tokens.Any(t => t.ToLower().Contains(searchCriteria.ToLower()))
orderby p.Lastname, p.Firstname
select new JSONSet(p.Fullname + " : " + p.PrimaryAddress.FormattedAddressBySep(", "), p.OutputTableName, p.Reference, p.Photo, p.CRM_PersonReference);
}
break;
case (int)JSONSet.DataSets.organisation:
{
var orgs = CRM_Organisation.BaseSet(db);
jsonItems = from p in orgs
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Name + " : " + p.CRM_Address.FormattedAddressBySep(", "), p.CRM_OrganisationType.Name, p.ID.ToString(), "", p.Reference);
}
break;
case (int)JSONSet.DataSets.school:
{
var schools = CRM_School.BaseSet(db);
jsonItems = from p in schools
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Name + " : " + p.CRM_Address.FormattedAddressBySep(", "), p.CRM_SchoolType.Name, p.ID.ToString(), "", p.Reference);
}
break;
case (int)JSONSet.DataSets.schoolperson:
{
var schoolsp = CRM_PersonSchool.BaseSet(db);
jsonItems = from p in schoolsp
where !p.IsArchived
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Name + " : " + p.PrimaryAddress.FormattedAddressBySep(", "), p.CRM_School.Name, p.ID.ToString(), p.CRM_Person.Photo, p.Reference);
}
break;
case (int)JSONSet.DataSets.orgperson:
{
var orgpers = CRM_PersonOrganisation.BaseSet(db);
jsonItems = from p in orgpers
where !p.IsArchived
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Name + " : " + p.PrimaryAddress.FormattedAddressBySep(", "), p.CRM_Organisation.Name, p.ID.ToString(), p.CRM_Person.Photo, p.Reference);
}
break;
case (int)JSONSet.DataSets.family:
{
var families = CRM_Family.BaseSet(db);
jsonItems = from p in families
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Name + " : " + p.CRM_FamilyPersons.Count() + " members", p.MemberList, p.ID.ToString(), "", p.Reference);
}
break;
case (int)JSONSet.DataSets.mytasks:
{
var tasks = db.CRM_Tasks.ToArray().Where(c => c.IsVisible(Convert.ToInt32(HttpContext.Current.Request.QueryString["adminuserid"])));
jsonItems = from p in tasks
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Name + "", p.DueDate.ToString("dd/MM/yyyy"), p.ID.ToString(), "", p.Reference);
}
break;
case (int)JSONSet.DataSets.admin:
{
var admins = db.Admins.ToArray();
jsonItems = from p in admins
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.DisplayName + "",
p.LastLogin == null ? "Never logged in" : "Last Login: "******"dd/MM/yyyy HH:mm"),
p.ID.ToString(), "", p.ID.ToString());
}
break;
case (int)JSONSet.DataSets.schoolorgs:
{
var schoolorgs = CRM.Code.Utils.SharedObject.SharedObject.GetSharedObjects <ISchoolOrganisation>(db);
jsonItems = from p in schoolorgs
where p.Tokens.Any(t => t.Contains(searchCriteria))
select new JSONSet(p.Name + " : " + p.CRM_Address.FormattedAddressBySep(", "), p.OutputTableName,
p.Reference, "", p.Reference.ToString());
}
break;
}
if (jsonItems.Any())
{
JSONOutput = JSONSet.ConvertToJSON(jsonItems);
}
else
{
jsonItems = Enumerable.Concat(jsonItems, new [] { new JSONSet("No results found", "Please alter your search", "", "", "") });
JSONOutput = JSONSet.ConvertToJSON(jsonItems);
}
context.Response.Write(JSONOutput);
}
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
List <CalendarItem> Calendar = new List <CalendarItem>();
DateTime time = UKTime.Now.Date;
if (!String.IsNullOrEmpty(Request.QueryString["date"]))
{
Session["calendardate"] = Request.QueryString["date"];
time = CRM.Code.Utils.Text.Text.FormatInputDate(Request.QueryString["date"]);
}
else if (Session["calendardate"] != null)
{
time = CRM.Code.Utils.Text.Text.FormatInputDate((string)Session["calendardate"]);
}
if (Request.QueryString["venue"] != null)
{
CRM_Venue = db.CRM_Venues.SingleOrDefault(v => v.ID.ToString() == Request.QueryString["venue"]);
}
CurrentDate = time;
CalendarManager calendarManager = new CalendarManager();
bool HideExternal = Query("hideexternal");
bool HideInternal = Query("hideinternal");
bool HideUntagged = Query("hideNonTagged");
int tryAdmin = 0;
Int32.TryParse(Request.QueryString["privacy"], out tryAdmin);
int?calendarAdmin = null;
if (tryAdmin != 0)
{
calendarAdmin = tryAdmin;
}
int type = Convert.ToInt32(Request.QueryString["type"]);
int count = 0;
while (time.Day < (CurrentDate.Day + 1))
{
count++;
IEnumerable <CalendarSlot> slots = calendarManager.FetchSlotsForTime(time, HideExternal, HideInternal, HideUntagged, type, calendarAdmin);
Calendar.Add(new CalendarItem()
{
Hour = time,
Slots = slots
});
time = time.AddHours(1);
if (count > 25)
{
break;
}
}
;
rptCalendar.DataSource = Calendar;
rptCalendar.DataBind();
}
