public static async void SaveOrphan(Orphan inOrphan) { try { // Replace this with the API code. using (var context = new SMSContext()) { var updatedOrphan = context.Orphans.Single(c => c.OrphanID == inOrphan.OrphanID); updatedOrphan.OrphanID = inOrphan.OrphanID; updatedOrphan.FirstName = inOrphan.FirstName; updatedOrphan.LastName = inOrphan.LastName; updatedOrphan.MiddleName = inOrphan.MiddleName; updatedOrphan.FullName = inOrphan.FullName; if (inOrphan.GuardianID != 0) { updatedOrphan.GuardianID = inOrphan.GuardianID; } updatedOrphan.LCMStatus = inOrphan.LCMStatus; updatedOrphan.ProfileNumber = inOrphan.ProfileNumber; updatedOrphan.Gender = inOrphan.Gender; updatedOrphan.EntryDate = inOrphan.EntryDate; updatedOrphan.DateOfBirth = inOrphan.DateOfBirth; context.Orphans.Update(updatedOrphan); await context.SaveChangesAsync(); } } catch (Exception eSql) { // Your code may benefit from more robust error handling or logging. // This logging is just a reminder that you should handle exceptions when connecting to remote data. System.Diagnostics.Debug.WriteLine($"Exception: {eSql.Message} {eSql.InnerException?.Message}"); } }
public async Task <IActionResult> Create([Bind("FullName,Address,Birthday,Orphanage,Avatar")] Orphan orphan, int id, IFormFile file) { await ImageHelper.SetAvatar(orphan, file, "wwwroot\\children"); if (ModelState.IsValid) { var orphanage = await _unitOfWorkAsync.Orphanages.GetById(id); orphan.Orphanage = orphanage; await _unitOfWorkAsync.Orphans.Create(orphan); await _unitOfWorkAsync.Orphans.SaveChangesAsync(); var user = await GetCurrentUserAsync(); user.PersonID = orphan.ID; user.PersonType = Models.Identity.PersonType.Orphan; await _unitOfWorkAsync.UserManager.UpdateAsync(user); return(RedirectToAction(nameof(Index))); } GetViewData(); return(View(orphan)); }
public void AddPerson_IsCalledWithOrphan_AddToOrphanList() { Orphan orphan = new Orphan(); _gameData.AddPerson(orphan); Assert.That(_gameData.Orphans.Contains(orphan)); }
protected override void OnNavigatedTo(NavigationEventArgs e) { if (e.Parameter != null) { InOrphan = (Orphan)e.Parameter; isNew = false; } else { isNew = true; } base.OnNavigatedTo(e); }
public void AddPerson_IsCalledWithOrphan_AddsRelationToNewOrphan() { Orphan orphan1 = new Orphan(); Orphan orphan2 = new Orphan(); _gameData.AddPerson(orphan1); _gameData.AddPerson(orphan2); Orphan orphan3 = new Orphan(); _gameData.AddPerson(orphan3); List <Person> relatedPeople = _gameData.Orphans.Single(p => p.Equals(orphan3)).Relations.Select(p => p.Acquaintance).ToList(); Assert.That(relatedPeople.Contains(orphan1) && relatedPeople.Contains(orphan2)); }
public async Task <IActionResult> Edit(int id, [Bind("ID,FullName,Birthday,Orphanage,Avatar")] Orphan orphan, int idOrphanage, IFormFile file) { if (id != orphan.ID) { return(NotFound()); } var check = CheckAccess((int)id).Result; var checkResult = check != null; if (checkResult) { return(check); } await ImageHelper.SetAvatar(orphan, file, "wwwroot\\children"); if (ModelState.IsValid) { try { var orphanage = await _unitOfWorkAsync.Orphanages.GetById(idOrphanage); orphan.Orphanage = orphanage; var orphanToEdit = await _unitOfWorkAsync.Orphans.GetById(orphan.ID); orphanToEdit.CopyState(orphan); _unitOfWorkAsync.Orphans.Update(orphanToEdit); _unitOfWorkAsync.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!_unitOfWorkAsync.Orphans.Any(orphan.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } GetViewData(); return(View(orphan)); }
public void AddPerson_IsCalledWithOrphan_AddRelationsToPersonel() { Person person1 = new Person(); Person person2 = new Person(); _gameData.AddPerson(person1); _gameData.AddPerson(person2); Orphan orphan = new Orphan(); _gameData.AddPerson(orphan); List <Person> person1related = _gameData.Personel.Single(p => p.Equals(person1)).Relations.Select(p => p.Acquaintance).ToList(); List <Person> person2related = _gameData.Personel.Single(p => p.Equals(person2)).Relations.Select(p => p.Acquaintance).ToList(); Assert.That(person1related.Contains(orphan) && person2related.Contains(orphan)); }
public void AddPerson_IsCalledWithOrphan_AddRelationsToOldOrphans() { Orphan orphan1 = new Orphan(); Orphan orphan2 = new Orphan(); _gameData.AddPerson(orphan1); _gameData.AddPerson(orphan2); Orphan orphan3 = new Orphan(); _gameData.AddPerson(orphan3); List <Person> orphan1related = _gameData.Orphans.Single(p => p.Equals(orphan1)).Relations.Select(p => p.Acquaintance).ToList(); List <Person> orphan2related = _gameData.Orphans.Single(p => p.Equals(orphan2)).Relations.Select(p => p.Acquaintance).ToList(); Assert.That(orphan1related.Contains(orphan3) && orphan2related.Contains(orphan3)); }
public void AddPerson(Orphan orphan) { Orphans.Add(orphan); foreach (Person p in Personel) { p.AddRelation(orphan); orphan.AddRelation(p); } foreach (Orphan o in Orphans) { o.AddRelation(orphan); orphan.AddRelation(o); } }
public async Task AddOrphanAsync(Orphan newOrphan) { string uri = $"{BaseUrl}{OrphansController}"; var request = new HttpRequestMessage(HttpMethod.Post, uri); var payload = JsonConvert.SerializeObject(newOrphan); // TODO Add JWT token to header // request.Headers request.Content = new StringContent(payload, Encoding.UTF8, "application/json"); var response = await _client.SendAsync(request); response.EnsureSuccessStatusCode(); }
public void Save(Orphan saveThis) { if (saveThis == null) { throw new ArgumentNullException("saveThis", "saveThis is null."); } try { _RepositoryInstance.Save(saveThis); } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
public static async void AddOrphan(Orphan inOrphan) { try { // Replace this with the API code. using (var context = new SMSContext()) { context.Orphans.Add(inOrphan); await context.SaveChangesAsync(); } } catch (Exception eSql) { // Your code may benefit from more robust error handling or logging. // This logging is just a reminder that you should handle exceptions when connecting to remote data. System.Diagnostics.Debug.WriteLine($"Exception: {eSql.Message} {eSql.InnerException?.Message}"); } }
protected override void OnNavigatedTo(NavigationEventArgs e) { base.OnNavigatedTo(e); EditNarrationParams p = new EditNarrationParams(); p = (EditNarrationParams)e.Parameter; InOrphan = (Orphan)p.Member; if (p.Narration != null) { isNew = false; InNarration = p.Narration; } else { isNew = true; } }
private void btnSave_Click(object sender, RoutedEventArgs e) { Orphan outOrphan = new Orphan(); // Add the save stuff to see if it works. if (!isNew) { outOrphan = InOrphan; } outOrphan.FirstName = txtFirstName.Text; outOrphan.MiddleName = txtMiddleName.Text; outOrphan.LastName = txtLastName.Text; outOrphan.Gender = txtGender.Text; //outOrphan.DateOfBirth = dtDateOfBirth.Date; outOrphan.LCMStatus = txtLCMStatus.Text; //outOrphan.EntryDate = dtEntryDate.Date; if (String.IsNullOrWhiteSpace(txtMiddleName.Text)) { outOrphan.FullName = txtFirstName.Text + " " + txtLastName.Text; } else { outOrphan.FullName = txtFirstName.Text + " " + txtMiddleName.Text + " " + txtLastName.Text; } if (isNew) { // Update to Database OrphanDataService.AddOrphan(outOrphan); } else { // Go get the one of interest, then overwrite. // Update to Database OrphanDataService.SaveOrphan(outOrphan); } // Go Back On_BackRequested(); }
public int Insert(Orphan orphan) { db.Orphans.Add(orphan); return(db.SaveChanges()); }
private async void btnSave_Click(object sender, RoutedEventArgs e) { Orphan outOrphan = new Orphan(); if (!isNew) { outOrphan = InOrphan; } outOrphan.FirstName = txtFirstName.Text; outOrphan.MiddleName = txtMiddleName.Text; outOrphan.LastName = txtLastName.Text; outOrphan.Gender = txtGender.Text; //outOrphan.DateOfBirth = dtDateOfBirth.Date; outOrphan.LCMStatus = txtLCMStatus.Text; //outOrphan.EntryDate = dtEntryDate.Date; if (String.IsNullOrWhiteSpace(txtMiddleName.Text)) { outOrphan.FullName = txtFirstName.Text + " " + txtLastName.Text; } else { outOrphan.FullName = txtFirstName.Text + " " + txtMiddleName.Text + " " + txtLastName.Text; } if (isNew) { if (AppSettings.UseWebApi) { using (var client = new HttpClient()) { var orphanRepo = new OrphanHttpRepository(client); var orphanCreation = new OrphanCreation { FirstName = outOrphan.FirstName, MiddleName = outOrphan.MiddleName, LastName = outOrphan.LastName, Gender = outOrphan.Gender, DateOfBirth = outOrphan.DateOfBirth, LCMStatus = outOrphan.LCMStatus, ProfileNumber = outOrphan.ProfileNumber }; await orphanRepo.AddOrphanAsync(orphanCreation); } } else { // Update to Database OrphanDataService.AddOrphan(outOrphan); } } else { // Go get the one of interest, then overwrite. if (AppSettings.UseWebApi) { using (var client = new HttpClient()) { var orphanRepo = new OrphanHttpRepository(client); var orphanEdit = new OrphanEdit { FirstName = outOrphan.FirstName, MiddleName = outOrphan.MiddleName, LastName = outOrphan.LastName, Gender = outOrphan.Gender, DateOfBirth = outOrphan.DateOfBirth, LCMStatus = outOrphan.LCMStatus, ProfileNumber = outOrphan.ProfileNumber, EntryDate = outOrphan.EntryDate, GuardianID = outOrphan.GuardianID, ProfilePictureID = outOrphan.ProfilePic.PictureID }; await orphanRepo.UpdateOrphanAsync(outOrphan.OrphanID, orphanEdit); } } else { // Update to Database OrphanDataService.SaveOrphan(outOrphan); } } // Go Back On_BackRequested(); }
public static async Task <IEnumerable <Orphan> > AllOrphans() { // Using a hard-coded SQL statement for now to make it simpler. Will need to either use API (preferred) // or stored procedure const string getOrphanQuery = @"SELECT * FROM dbo.Orphans"; var orphanList = new List <Orphan>(); try { using (var conn = new SqlConnection(GetConnectionString())) { await conn.OpenAsync(); if (conn.State == System.Data.ConnectionState.Open) { using (var cmd = conn.CreateCommand()) { cmd.CommandText = getOrphanQuery; using (var reader = await cmd.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { //Orphan Data var orphanID = !reader.IsDBNull(0) ? reader.GetInt32(0) : 0; var firstName = reader.GetString(1); var middleName = !reader.IsDBNull(2) ? reader.GetString(2) : string.Empty; var lastName = reader.GetString(3); var fullName = reader.GetString(4); var gender = !reader.IsDBNull(5) ? reader.GetString(5) : string.Empty; var dateOfBirth = !reader.IsDBNull(6) ? reader.GetDateTime(6) : default(DateTime); var lcmStatus = !reader.IsDBNull(7) ? reader.GetString(7) : string.Empty; var profileNumber = !reader.IsDBNull(8) ? reader.GetString(8) : string.Empty; var entryDate = !reader.IsDBNull(9) ? reader.GetDateTime(9) : default(DateTime); var guardianID = !reader.IsDBNull(10) ? reader.GetInt32(10) : 0; Orphan inOrphan = new Orphan() { OrphanID = orphanID, FirstName = firstName, MiddleName = middleName, LastName = lastName, FullName = fullName, Gender = gender, DateOfBirth = dateOfBirth, LCMStatus = lcmStatus, ProfileNumber = profileNumber, EntryDate = entryDate, GuardianID = guardianID }; // Add to the List<> orphanList.Add(inOrphan); } } } } } } catch (Exception eSql) { // Your code may benefit from more robust error handling or logging. // This logging is just a reminder that you should handle exceptions when connecting to remote data. System.Diagnostics.Debug.WriteLine($"Exception: {eSql.Message} {eSql.InnerException?.Message}"); } return(orphanList); }