// GET api/careplans public HttpResponseMessage Get(Guid relatedId) { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from c in ctx.new_careplanSet where c.new_ChildId.Id == relatedId select new CrmEarlyBound.new_careplan { Id = c.Id, new_name = c.new_name, new_Description = c.new_Description }; var queryResults = query.ToList(); var listReturn = new List<TestCarePlanObject>(); foreach (new_careplan x in queryResults) { var returnObject = new TestCarePlanObject(); returnObject.Id = x.Id; returnObject.Name = x.new_name; returnObject.Description = x.new_Description; listReturn.Add(returnObject); } var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, listReturn); }
// GET api/notes public HttpResponseMessage Get(string RelatedId) { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from a in ctx.AnnotationSet where a.ObjectId.Id == new Guid(RelatedId) select new TestAnnotationObject { Id = a.Id, CreatedOn = a.CreatedOn, OwnerId = a.OwnerId.Id, OwnerName = a.OwnerId.Name, ObjectId = a.ObjectId.Id, Subject = a.Subject, NoteText = a.NoteText }; var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, query); }
public HttpResponseMessage Get() { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from e in ctx.new_employmentSet select new EmploymentObject { Id = e.Id, BeginDate = e.new_BeginDate, ContactId = e.new_ContactEmploymentId.Id, Employer = e.new_employer, EndDate = e.new_EndDate, Position = e.new_Position, ReasonForLeaving = e.new_ReasonForLeaving }; var queryResults = query.ToList(); var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, queryResults); }
public HttpResponseMessage Post(Guid taskId) { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var taskReference = new EntityReference("task", taskId); try { var req = new SetStateRequest(); req.State = new OptionSetValue(1); req.Status = new OptionSetValue(5); req.EntityMoniker = taskReference; var res = (SetStateResponse)ctx.Execute(req); } catch (Exception e) { return this.Request.CreateResponse( HttpStatusCode.InternalServerError, e); } return this.Request.CreateResponse( HttpStatusCode.Created); }
// GET api/allergies public HttpResponseMessage Get() { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from a in ctx.new_allergySet select new CrmEarlyBound.new_allergy { Id = a.Id, new_name = a.new_name, new_Description = a.new_Description, }; var queryResults = query.ToList(); var listReturn = new List<TestAllergyObject>(); foreach (new_allergy x in queryResults) { var returnObject = new TestAllergyObject(); returnObject.Id = x.Id; returnObject.Name = x.new_name; returnObject.Description = x.new_Description; listReturn.Add(returnObject); } var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, listReturn); }
public HttpResponseMessage Get() { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from e in ctx.new_educationSet select new EducationObject { Id = e.Id, Name = e.new_name, ContactId = e.new_ContactEducationId.Id, EnrollmentDate = e.new_EnrollmentDate, Grade = e.new_Grade, GradeRepeat = e.new_GradeRepeat }; var queryResults = query.ToList(); var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, queryResults); }
// GET api/home public HttpResponseMessage Get() { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from c in ctx.IncidentSet select new CrmEarlyBound.Incident { Id = c.Id, Title = c.Title, new_AllegationType = c.new_AllegationType, new_Allegation = c.new_Allegation, new_Reporter = c.new_Reporter }; var cases = query.ToList(); var listReturn = new List<TestCaseObject>(); foreach (Incident c in cases) { var caseObject = new TestCaseObject(); caseObject.Id = c.Id; caseObject.Title = c.Title; caseObject.Allegation = c.new_Allegation; caseObject.Reporter = c.new_Reporter; switch (c.new_AllegationType) { case 100000000: caseObject.AllegationType = "Abuse"; break; case 100000001: caseObject.AllegationType = "Truancy"; break; case 100000002: caseObject.AllegationType = "Neglect"; break; } listReturn.Add(caseObject); } var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, listReturn); }
//Household Contacts for Case public HttpResponseMessage Get(Guid caseId) { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var queryResult = from n in ctx.new_incident_contactSet join c in ctx.ContactSet on n.contactid equals c.ContactId where n.incidentid == caseId select new TestContactObject { Id = c.ContactId.Value, FirstName = c.FirstName, LastName = c.LastName, MobilePhone = c.MobilePhone, Address1_Line1 = c.Address1_Line1, Address1_Line2 = c.Address1_Line2, Address1_City = c.Address1_City, Address1_StateOrProvince = c.Address1_StateOrProvince, Address1_PostalCode = c.Address1_PostalCode, ContactType = c.new_ContactType }; var returnList = new List<TestContactObject>(); foreach (TestContactObject ctact in queryResult) { switch (ctact.ContactType) { case 100000000: ctact.ContactTypeString = "Child"; break; case 100000001: ctact.ContactTypeString = "Parent/Guardian"; break; case 100000002: ctact.ContactTypeString = "Other"; break; } returnList.Add(ctact); } var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); return this.Request.CreateResponse( HttpStatusCode.OK, returnList); }
// GET api/contacts public HttpResponseMessage Get() { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from c in ctx.ContactSet select new CrmEarlyBound.Contact { Id = c.Id, FirstName = c.FirstName, LastName = c.LastName, MobilePhone = c.MobilePhone, Address1_Line1 = c.Address1_Line1, Address1_Line2 = c.Address1_Line2, Address1_City = c.Address1_City, Address1_StateOrProvince = c.Address1_StateOrProvince, Address1_PostalCode = c.Address1_PostalCode, new_ContactType = c.new_ContactType }; var contacts = query.ToList(); var listReturn = new List<TestContactObject>(); foreach (Contact c in contacts) { var returnObject = new TestContactObject(); returnObject.Id = c.Id; returnObject.FirstName = c.FirstName; returnObject.LastName = c.LastName; returnObject.MobilePhone = c.MobilePhone; returnObject.Address1_Line1 = c.Address1_Line1; returnObject.Address1_Line2 = c.Address1_Line2; returnObject.Address1_City = c.Address1_City; returnObject.Address1_StateOrProvince = c.Address1_StateOrProvince; returnObject.Address1_PostalCode = c.Address1_PostalCode; returnObject.ContactType = c.new_ContactType; listReturn.Add(returnObject); } var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, listReturn); }
// GET api/tasks public HttpResponseMessage Get(string RelatedId) { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from a in ctx.TaskSet where a.RegardingObjectId.Id == new Guid(RelatedId) select new CrmEarlyBound.Task { Id = a.Id, RegardingObjectId = a.RegardingObjectId, Subject = a.Subject, StatusCode = a.StatusCode }; var queryResults = query.ToList(); var listReturn = new List<TestTaskObject>(); foreach (Task x in queryResults) { var returnObject = new TestTaskObject(); returnObject.Id = x.Id; returnObject.RegardingObjectId = x.RegardingObjectId.Id.ToString(); returnObject.Subject = x.Subject; if (x.StatusCode.Value == 5) { returnObject.IsComplete = true; } else { returnObject.IsComplete = false; } listReturn.Add(returnObject); } var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, listReturn); }
// POST api/notes?caseId= public HttpResponseMessage Post(Guid caseId, string noteTitle, string noteText) { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var note = new Annotation(); note.ObjectId = new CrmEntityReference("incident", caseId); note.Subject = noteTitle; note.NoteText = noteText; try { ctx.Create(note); } catch (Exception e) { return this.Request.CreateResponse( HttpStatusCode.InternalServerError, e); } return this.Request.CreateResponse( HttpStatusCode.Created); }
// GET api/pictures public HttpResponseMessage Get(string RelatedId) { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from p in ctx.new_pictureSet where p.new_CaseId.Id == new Guid(RelatedId) select new CrmEarlyBound.new_picture { Id = p.Id, new_CaseId = p.new_CaseId, new_Description = p.new_Description, EntityImage = p.EntityImage }; var queryResults = query.ToList(); var listReturn = new List<TestPictureObject>(); foreach (new_picture x in queryResults) { var returnObject = new TestPictureObject(); returnObject.Id = x.Id; returnObject.CaseId = x.new_CaseId.Id.ToString(); returnObject.EntityImage = x.EntityImage; listReturn.Add(returnObject); } var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, listReturn); }
public CrmServices(IOrganizationService service, CrmServiceContext xrmContext, ITracingService t) { this.Service = service; this.T = t; this.Context = xrmContext; }
public HttpResponseMessage Post(Guid appointmentId, string operationName, string operationTime) { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var appointment = new Appointment(); appointment.Id = appointmentId; switch (operationName) { case "EnteredBuilding": appointment.new_EnteredBuilding = Convert.ToDateTime(operationTime); break; case "LeftBuilding": appointment.new_LeftBuilding = Convert.ToDateTime(operationTime); break; case "DistressCallReceived": appointment.new_DistressCallReceived = Convert.ToDateTime(operationTime); break; } try { ctx.Update(appointment); } catch (Exception e) { return this.Request.CreateResponse( HttpStatusCode.InternalServerError, e); } return this.Request.CreateResponse( HttpStatusCode.Accepted); }
// GET api/appointment/[Guid.ToString()] public HttpResponseMessage Get() { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); WhoAmIRequest who = new WhoAmIRequest(); var userId = ctx.Execute(who).Results["UserId"]; var query = from a in ctx.AppointmentSet join i in ctx.IncidentSet on a.RegardingObjectId.Id equals i.Id join c in ctx.ContactSet on i.CustomerId.Id equals c.Id where a.OwnerId.Id == new Guid(userId.ToString()) select new TestAppointmentObject { Id = a.Id, ScheduledStart = a.ScheduledStart, ScheduledEnd = a.ScheduledEnd, RegardingObjectId = a.RegardingObjectId.Id, Subject = a.Subject, ContactId = i.CustomerId.Id, FirstName = c.FirstName, LastName = c.LastName, MobilePhone = c.MobilePhone, Address1_Line1 = c.Address1_Line1, Address1_Line2 = c.Address1_Line2, Address1_City = c.Address1_City, Address1_StateOrProvince = c.Address1_StateOrProvince, Address1_PostalCode = c.Address1_PostalCode, ImageName = c.new_SienaImageName, EnteredBuilding = a.new_EnteredBuilding, LeftBuilding = a.new_LeftBuilding, DistressCallReceived = a.new_DistressCallReceived }; var queryResults = query.ToList(); foreach (TestAppointmentObject x in queryResults) { var today = DateTime.Today; if (((DateTime)x.ScheduledStart).Date == today.Date) { x.RelativeDay = "Today"; } else if (((DateTime)x.ScheduledStart).Date == today.Add(new System.TimeSpan(1, 0, 0, 0)).Date) { x.RelativeDay = "Tomorrow"; } else if (((DateTime)x.ScheduledStart).Date == today.Add(new System.TimeSpan(2, 0, 0, 0)).Date) { x.RelativeDay = "2 Days"; } else if (((DateTime)x.ScheduledStart).Date < today.Date) { x.RelativeDay = "Previous"; } else { x.RelativeDay = "Later"; } } var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, queryResults); }
public HttpResponseMessage Get() { CrmConnection connection = CrmConnection.Parse(Strings.urlCreds); var ctx = new CrmServiceContext(new OrganizationService(connection)); var query = from d in ctx.new_offenseSet select new OffenseObject { Id = d.Id, Name = d.new_name, BeginDate = d.new_BeginDate, ContactId = d.new_ContactOffensesId.Id, Details = d.new_Details, EndDate = d.new_EndDate, Incarcerated = d.new_Incarcerated, OffenseDate = d.new_OffenseDate, OffenseType = d.new_OffenseType, OnParole = d.new_OnParole, OnProbation = d.new_OnProbation }; var queryResults = query.ToList(); foreach (OffenseObject o in queryResults) { switch (o.OffenseType) { case 100000000: o.OffenseTypeString = "Violence"; break; case 100000001: o.OffenseTypeString = "Weapons"; break; case 100000002: o.OffenseTypeString = "Drug Related"; break; case 100000003: o.OffenseTypeString = "Other"; break; } } var configuration = GlobalConfiguration.Configuration; configuration.Formatters.Remove(configuration.Formatters.XmlFormatter); //return listReturn; return this.Request.CreateResponse( HttpStatusCode.OK, queryResults); }