public void UpdateBaselineProjection(CustomBaselineProjection bp) { using (var ctx = new XrmServiceContext("Xrm")) { var bps = (from s in ctx.new_baselineprojectionsSet where s.Id == bp.Id select s).FirstOrDefault(); bps.new_name = bp.Name; bps.new_Year = bp.Year; bps.new_CA_Q1Actual = (int)bp.CA_Q1_A; bps.new_Q1_ca = (decimal)bp.CA_Q1_P; bps.new_CA_Q2Actual = (int)bp.CA_Q2_A; bps.new_Q2_ca = (decimal)bp.CA_Q2_P; bps.new_CA_Q3Actual = (int)bp.CA_Q3_A; bps.new_Q3_ca = (decimal)bp.CA_Q3_P; bps.new_CA_Q4Actual = (int)bp.CA_Q4_A; bps.new_Q4_ca = (decimal)bp.CA_Q4_P; bps.new_DB_Q1Actual = (int)bp.DB_Q1_A; bps.new_Q1_db = (decimal)bp.DB_Q1_P; bps.new_DB_Q2Actual = (int)bp.DB_Q2_A; bps.new_Q2_db = (decimal)bp.DB_Q2_P; bps.new_DB_Q3Actual = (int)bp.DB_Q3_A; bps.new_Q3_db = (decimal)bp.DB_Q3_P; bps.new_DB_Q4Actual = (int)bp.DB_Q4_A; bps.new_Q4_db = (decimal)bp.DB_Q4_P; ctx.UpdateObject(bps); ctx.SaveChanges(); } }
static void Main(string[] args) { var xrm = new XrmServiceContext("Xrm"); WriteExampleContacts(xrm); //create a new contact called Allison Brown var allisonBrown = new Xrm.Contact { FirstName = "Allison", LastName = "Brown", Address1_Line1 = "23 Market St.", Address1_City = "Sammamish", Address1_StateOrProvince = "MT", Address1_PostalCode = "99999", Telephone1 = "12345678", EMailAddress1 = "*****@*****.**" }; xrm.AddObject(allisonBrown); xrm.SaveChanges(); WriteExampleContacts(xrm); Console.WriteLine("Press any key to exit."); Console.ReadKey(); }
public void When_calling_context_add_and_save_changes_entity_is_added_to_the_faked_context() { var context = new XrmFakedContext(); var service = context.GetFakedOrganizationService(); using(var ctx = new XrmServiceContext(service)) { ctx.AddObject(new Account() { Name = "Test account" }); ctx.SaveChanges(); var account = ctx.CreateQuery<Account>() .ToList() .FirstOrDefault(); Assert.Equal("Test account", account.Name); } }
private void bw_DoWork(object sender, DoWorkEventArgs e) { XrmServiceContext xrm; xrm = new XrmServiceContext("Xrm"); foreach (MyLead objLead in Leads) { //xrm.AddObject(objLead); Guid objLeadGuid = xrm.Create(objLead);//Using this method as opposed to xrm.AddObject results in getting the GUID required to add a note to the lead. //This method also adds the Lead Object to the Db. objLead.Note.ObjectId = new Microsoft.Xrm.Client.CrmEntityReference("lead", objLeadGuid); //Creates the xref between the Annotation object (the note) and the lead xrm.AddObject(objLead.Note); //adds the note to the CRM Database.. } xrm.SaveChanges();//this saves all the notes to the database. The leads are automatically saved by calling the Create() method... }
public void When_calling_context_add_addrelated_and_save_changes_entities_are_added_to_the_faked_context() { var context = new XrmFakedContext(); var relationship = new XrmFakedRelationship() { IntersectEntity = "accountleads", Entity1Attribute = "accountid", Entity2Attribute = "leadid", Entity1LogicalName = "account", Entity2LogicalName = "lead" }; context.AddRelationship("accountleads", relationship); var service = context.GetFakedOrganizationService(); using (var ctx = new XrmServiceContext(service)) { var account = new Account() { Name = "Test account" }; ctx.AddObject(account); var contact = new Lead() { FirstName = "Jane", LastName = "Doe" }; ctx.AddRelatedObject(account, new Relationship("accountleads"), contact); var result = ctx.SaveChanges(); var resultaccount = ctx.CreateQuery<Account>() .ToList() .FirstOrDefault(); Assert.NotNull(resultaccount); Assert.Equal("Test account", resultaccount.Name); var reaultlead = ctx.CreateQuery<Lead>() .ToList() .FirstOrDefault(); Assert.NotNull(reaultlead); Assert.Equal("Jane", reaultlead.FirstName); Assert.Equal("Doe", reaultlead.LastName); var relationshipRecords = ctx.CreateQuery("accountleads") .ToList(); Assert.NotEmpty(relationshipRecords); } }
public void AddSubscribers(string ListId, List <Entities.Subscriber> subscribers) { try { foreach (Entities.Subscriber subscriber in subscribers) { Contact contact = (Contact)context.ContactSet.Where(x => x.EMailAddress1.Equals(subscriber.E_mail)).FirstOrDefault(); Guid listGuid = new Guid(ListId); if (contact == null) { Guid contactGuid = context.Create(new Contact() { EMailAddress1 = subscriber.E_mail, FirstName = subscriber.Name }); var member = new AddMemberListRequest() { EntityId = contactGuid, ListId = listGuid }; context.Execute(member); } else { var member = new AddMemberListRequest() { EntityId = contact.Id, ListId = listGuid }; context.Execute(member); } } context.SaveChanges(); } catch (Exception e) { throw new Exception("Get subscribers CRM (" + e.Message.ToString() + ")"); } }
public Account UpdateStudentDetails(string studentId, DetailsViewModel model) { try { //Check if studentId is null if (string.IsNullOrWhiteSpace(studentId)) { _log.Error($"Trying to execute update student details for non existing student id"); return(null); } using (var context = new XrmServiceContext(_service)) { _log.Info($"Executing update student details for student with id {studentId}"); var studentObject = (from student in context.AccountSet where student.New_UserID.Equals(studentId) select student) .FirstOrDefault(); if (studentObject == null) { _log.Info($"No student found with id {studentId}"); return(null); } if (studentObject.New_FirstName != model.FirstName || studentObject.New_FamilyName != model.LastName || studentObject.New_StudentStatus.Value != (int)model.StudentStatus) { if (studentObject.New_FirstName != model.FirstName) { string oldFirstName = studentObject.New_FirstName; studentObject.New_FirstName = model.FirstName; _log.Info($"Updated the first name for student with ID {studentId} from {oldFirstName} to {model.FirstName}"); } if (studentObject.New_FamilyName != model.LastName) { string oldLastName = studentObject.New_FamilyName; studentObject.New_FamilyName = model.LastName; _log.Info($"Updated the last name for student with ID {studentId} from {oldLastName} to {model.LastName} "); } if (studentObject.New_StudentStatus.Value != (int)model.StudentStatus) { int oldStudentStatus = studentObject.New_StudentStatus.Value; studentObject.New_StudentStatus = new OptionSetValue((int)model.StudentStatus); _log.Info($"Updated the student status for student with ID {studentId} from {(StudentStatus)oldStudentStatus} to {model.StudentStatus} "); } context.UpdateObject(studentObject); context.SaveChanges(); } else { _log.Info($"The new entered values are equal to the old ones"); } return(studentObject); } } catch (Exception ex) { _log.Error($"Exception caught while trying to update Student Details for Student with ID {studentId} - {ex.Message}"); return(null); } }
public void When_calling_context_add_and_save_changes_returns_correct_result() { var context = new XrmFakedContext(); var service = context.GetFakedOrganizationService(); using (var ctx = new XrmServiceContext(service)) { ctx.AddObject(new Account() { Name = "Test account" }); var result = ctx.SaveChanges(); Assert.NotNull(result); Assert.NotEmpty(result); Assert.Equal("Create", result.First().Response.ResponseName); Assert.IsType<CreateResponse>(result.First().Response); Assert.NotEqual(Guid.Empty, ((CreateResponse)result.First().Response).id); } }
static private void addContact() { var xrm = new XrmServiceContext("Xrm"); listContacts(xrm); //Create a new contact called Allison Brown. var allisonBrown = new Xrm.Contact { FirstName = "Allison", LastName = "Brown 2", Address1_Line1 = "23 Market St.", Address1_City = "Sammamish", Address1_StateOrProvince = "MT", Address1_PostalCode = "99999", Telephone1 = "12345678", EMailAddress1 = "*****@*****.**" }; xrm.AddObject(allisonBrown); xrm.SaveChanges(); listContacts(xrm); }