public async Task <IActionResult> Get([FromRoute] int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT do.Id, do.OwnerName, do.OwnerAddress, do.NeighborhoodId, do.PhoneNumber, d.DogName, d.Breed, d.Id AS DogId FROM DogOwner do
INNER JOIN Dog d ON d.DogOwnerId = do.id WHERE DogOwnerId = 1 ";
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
DogOwner owner = null;
if (reader.Read())
{
owner = new DogOwner
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
OwnerName = reader.GetString(reader.GetOrdinal("OwnerName")),
OwnerAddress = reader.GetString(reader.GetOrdinal("OwnerAddress")),
PhoneNumber = reader.GetString(reader.GetOrdinal("PhoneNumber")),
NeighborhoodId = reader.GetInt32(reader.GetOrdinal("NeighborhoodId"))
};
}
reader.Close();
return(Ok(owner));
}
}
}
public DogOwnerViewModel()
{
//SV initialise backend framework
DataStore = (IDataStore <BaseId>)DependencyService.Get <DataStore <DogOwner> >() ?? new MockDataStore <DogOwner>();
DataStore.InitializeAsync();
this.ScreenName = Settings.ScreenName;
ClickCreate = new Command(async() =>
{
DogOwner item = new DogOwner
{
ScreenName = this.ScreenName, FirstName = this.FirstName, Surname = this.Surname, AgeRangeMin = Int32.Parse(this.AgeRangeMin),
CurrentTown = this.CurrentTown, HomeTown = this.HomeTown,
Bio = this.Bio, RelationshipStatus = this.RelationshipStatus, Job = this.Job, WorkPlace = this.WorkPlace,
//Education = new List<string>(new string[] { this.Education }), Address = new List<string>(new string[] { this.Address }),
//PostCode = this.PostCode, Country = this.Country, TelphoneNumber = this.TelphoneNumber, MobileNumber = this.MobileNumber,
//EmailAddress = this.EmailAddress,
DOB = Convert.ToDateTime(this.DOB)
//, Dogs = new List<string>(new string[] { this.Dogs }),RelatedDogs = new List<string>(new string[] { this.RelatedDogs })
};
bool res = await DataStore.AddItemAsync(item);
ResponseType = (res ? 1 : 2);
ResponseText = (res ? "Successfully Saved" : "Failed to Save");
Settings.ScreenName = this.ScreenName;
});
}
public void Index()
{
var dogOwnerViewModelMapper = new Mock <IDogOwnerViewModelMapper>();
var dogOwner = new DogOwner()
{
OwnerName = "Qwe", DogNameList = new List <string> {
"q", "w", "e"
}
};
var dogOwners = new List <DogOwner> {
dogOwner
};
var dogOwnerListViewModel = new DogOwnerListViewModel {
DogOwnerViewModels = dogOwners.Select(e => new DogOwnerViewModel {
OwnerName = e.OwnerName,
DogNames = e.DogNameList
}).ToList()
};
dogOwnerViewModelMapper.Setup(x => x.GetAllDogOwners()).Returns(dogOwnerListViewModel);
//Arrange
RobsDogsController controller = new RobsDogsController(dogOwnerViewModelMapper.Object);
//Act
ViewResult result = controller.Index() as ViewResult;
//Assert
Assert.IsNotNull(result);
Assert.AreEqual(dogOwnerListViewModel, result.Model);
//Should be testing / verifying call to GetAllDogOwners and subsequent methods down the stack.
//Moq is installed to help you.
}
public void GetAllDogOwners_Should_returnDogOwnersList_When_repositoryIsNotEmpty()
{
//Arrange
var dogOwnerRepository = new Mock <IDogOwnerRepository>();
var dogOwner = new DogOwner()
{
OwnerName = "Qwe", DogNameList = new List <string>()
{
"q", "w", "e"
}
};
var dogOwnerList = new List <DogOwner> {
dogOwner
};
dogOwnerRepository.Setup(x => x.GetAllDogOwners()).Returns(dogOwnerList);
var dogOwnerService = new DogOwnerService(dogOwnerRepository.Object);
//Act
var result = dogOwnerService.GetAllDogOwners();
//Assert
Assert.IsNotNull(result);
CollectionAssert.AreEqual(dogOwnerList, result);
}
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken)
{
var medic = await _context.Medics.SingleOrDefaultAsync(_medic => _medic.Id == request.OwnerMedicId);
var contact = new Contact
{
Country = request.Country,
Town = request.Town,
Street = request.Street,
Number = request.Number,
};
var owner = new DogOwner
{
FirstName = request.FirstName,
LastName = request.LastName,
Username = request.Username,
Email = request.Email,
Password = request.Password,
OwnerMedic = medic,
OwnerContact = contact,
};
_context.Contacts.Add(contact);
_context.DogOwners.Add(owner);
var changes = await _context.SaveChangesAsync();
return(Unit.Value);
}
public DogOwnerResponse(DogOwner model)
{
CopyProperties(model, this, new List <string>()
{
"Dogs"
});
Dogs = model.Dogs.Select(x => new DogSummaryResponse(x)).ToList();
}
public async Task <ActionResult <DogOwner> > AddDogOwner(DogOwner dogOwner)
{
_memoryDbClient.DogOwners.Add(dogOwner);
await _memoryDbClient.SaveChangesAsync();
return(CreatedAtAction(nameof(GetDogOwner),
new { id = dogOwner.Id },
dogOwner));
}
public async Task Save(DogOwner dogOwner)
{
var dogOwnerData = new DogOwnerData {
OwnerName = dogOwner.OwnerName,
DogNames = string.Join(",", dogOwner.DogNames)
};
_dataContext.DogOwners.Add(dogOwnerData);
await _dataContext.SaveChangesAsync();
}
private DogOwner MakeDummyOwner()
{
DogOwner owner = new DogOwner();
owner.Name = DogOwnerName;
owner.Mobile = DogOwnerMobile;
owner.Address = "Rambla 0123";
return(owner);
}
private void LoadDogsForOwner()
{
DogOwner selectedOwner = (DogOwner)lstboxOwners.SelectedItem;
if (selectedOwner != null)
{
lstboxDogs.DataSource = null;
lstboxDogs.DataSource = directory.DogsForOwner(selectedOwner);
}
}
public async Task <DogOwner> GetDogOwner(long id)
{
var dogOwnerData = await _dataContext.DogOwners.FindAsync(id);
var dogOwner = new DogOwner(dogOwnerData.Id,
dogOwnerData.OwnerName,
dogOwnerData.DogNames.Split(","));
return(dogOwner);
}
public void VerifyTwoOwnersAreTheSameByName()
{
var ownerFoo = new DogOwner {
Name = DogOwnerName
};
var ownerBar = new DogOwner {
Name = DogOwnerName
};
Assert.AreEqual(ownerFoo, ownerBar);
}
public void AddOneDogTest()
{
var dog = new Dog();
var owner = new DogOwner {
Name = DogOwnerName
};
owner.AddDog(dog);
Assert.AreEqual(1, owner.Dogs().Count());
}
public async Task <IActionResult> PostDogOwner(DogOwnerRequest request)
{
if (request == null)
{
return(BadRequest());
}
var dogOwner = new DogOwner(request.OwnerName, request.DogNames);
await _repository.Save(dogOwner);
return(CreatedAtAction(nameof(PostDogOwner), new { id = dogOwner.Id }, null));
}
private void AddNewOwner()
{
string name = txtName.Text.Trim();
string mobile = txtMobile.Text.Trim();
string address = txtAddress.Text.Trim();
DogOwner newOwner = new DogOwner {
Name = name,
Mobile = mobile,
Address = address
};
directory.AddOwner(newOwner);
}
public void AddOwner()
{
DogOwner owner = new DogOwner();
owner.Name = "John";
DogsDirectory directory = new DogsDirectory();
directory.AddOwner(owner);
Assert.AreEqual(1, directory.Owners().Count());
DogOwner ownerJohn = directory.Owners().First(x => x.Name == "John");
Assert.AreEqual("John", ownerJohn.Name);
}
private void AddNewDog()
{
string name = txtName.Text.Trim();
string breed = txtBreed.Text.Trim();
Dog.BreedSize size = (Dog.BreedSize)cmbSize.SelectedItem;
DogOwner owner = (DogOwner)cmbOwner.SelectedItem;
Dog newDog = new Dog
{
Name = name,
Size = size,
Breed = breed,
};
directory.AddDog(owner, newDog);
}
public void AddDogWithOwner()
{
DogOwner owner = new DogOwner()
{
Name = "John"
};
Dog dog = new Dog()
{
Name = "Beethoven"
};
DogsDirectory directory = new DogsDirectory();
directory.AddOwner(owner);
directory.AddDog(owner, dog);
Assert.AreEqual(1, directory.Owners().First(x => x.Name == "John").Dogs().Count());
}
public async Task <IActionResult> Put([FromRoute] int id, [FromBody] DogOwner owner)
{
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"UPDATE DogOwner
SET OwnerName = @OwnerName,
OwnerAddress = @OwnerAddress,
PhoneNumber = @PhoneNumber
NeighborhoodId = @NeighborhoodId
WHERE Id = @id";
cmd.Parameters.Add(new SqlParameter("@OwnerName", owner.OwnerName));
cmd.Parameters.Add(new SqlParameter("@OwnerAddrees", owner.OwnerAddress));
cmd.Parameters.Add(new SqlParameter("@PhoneNumber", owner.PhoneNumber));
cmd.Parameters.Add(new SqlParameter("@NeighborhoodId", owner.NeighborhoodId));
cmd.Parameters.Add(new SqlParameter("@id", id));
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected > 0)
{
return(new StatusCodeResult(StatusCodes.Status204NoContent));
}
throw new Exception("No rows affected");
}
}
}
catch (Exception)
{
if (!OwnerExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
}
public async Task <IActionResult> Post([FromBody] DogOwner owner)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO DogOwner (OwnerName, OwnerAddress, PhoneNumber, NeighborhoodId)
OUTPUT INSERTED.Id
VALUES (@OwnerName, @Address, @PhoneNumber, @NeighborhoodId)";
cmd.Parameters.Add(new SqlParameter("@OwnerName", owner.OwnerName));
cmd.Parameters.Add(new SqlParameter("@OwnerAddrees", owner.OwnerAddress));
cmd.Parameters.Add(new SqlParameter("@PhoneNumber", owner.PhoneNumber));
cmd.Parameters.Add(new SqlParameter("@NeighborhoodId", owner.NeighborhoodId));
int newId = (int)cmd.ExecuteScalar();
owner.Id = newId;
return(CreatedAtRoute("GetOwner", new { id = newId }, owner));
}
}
}
public void SetUp()
{
mockUnitOfWork = new Mock <IUnitOfWork>();
mockDogOwnerRepo = new Mock <IDogOwnerRepository>();
mockRequestMessageRepo = new Mock <IRequestMessageRepository>();
mockPrivateMessageBoardRepo = new Mock <IPrivateMessageBoardRepository>();
UserToVerifyOrDeny = new DogOwner
{
Id = "ID",
IsConfirmed = false,
FirstName = "UserToVerifyOrDeny",
LastName = "Something"
};
appUser = new DogOwner
{
Id = "UserID",
IsConfirmed = true,
FirstName = "appUser",
LastName = "Something"
};
list = new List <RequestMessage>()
{
new RequestMessage {
Message = "msg1", SendFromID = "ID", ReciverID = "NotValidID"
},
new RequestMessage {
Message = "msg2", SendFromID = "ID", ReciverID = "UserID"
},
new RequestMessage {
Message = "msg3", SendFromID = "ID", ReciverID = "NotValidID"
},
new RequestMessage {
Message = "msg4", SendFromID = "NotValidID", ReciverID = "NotValidID"
}
};
}
public void GetAllDogOwners_Should_returnDogOwnerListVM_When_serviceReturnDogOwnersList()
{
//Arrange
var dogOwnerService = new Mock <IDogOwnerService>();
var dogOwner = new DogOwner()
{
OwnerName = "Qwe", DogNameList = new List <string> {
"q", "w", "e"
}
};
var dogOwners = new List <DogOwner> {
dogOwner
};
dogOwnerService.Setup(x => x.GetAllDogOwners()).Returns(dogOwners);
var dogOwnerViewModelMapper = new DogOwnerViewModelMapper(dogOwnerService.Object);
//Act
var result = dogOwnerViewModelMapper.GetAllDogOwners();
//Assert
Assert.IsNotNull(result);
}
public OwnerSummaryResponse(DogOwner model)
{
CopyProperties(model, this);
}
private static void ClassDependencyProblem()
{
var dogOwner = new DogOwner();
dogOwner.Walkies(new ProblemCode.Dog());
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsUpdateOperation == true)
{
// Update
int intI = Convert.ToInt32(lblDogOwnerID.Text);
using (var B = new dbFFBEntities())
{
var u = B.DogOwners.First(x => x.DogOwnerID == intI);
u.OwnerName = txtOwnerName.Text.Trim();
u.OwnerAddress = txtOwnerAddress.Text.Trim();
u.OwnerCity = txtOwnerCity.Text.Trim();
u.OwnerState = txtState.Text.Trim();
u.OwnerZip = txtZip.Text.Trim();
u.OwnerPhone = txtPhone.Text.Trim();
u.OwnerEmail = txtEmail.Text.Trim();
u.Active = chkActive.Checked;
u.LastUpdateID = Environment.UserName;
u.LastUpdateTimeStamp = DateTime.Now;
var s = B.SaveChanges();
if (s == 1)
{
ClearAllDetailFields();
load_cboName();
dgv.DataSource = null;
dgv.DataSource = GetAll();
MessageBox.Show(strTableName + u.OwnerName + " Updated Successfully");
}
else
{
MessageBox.Show(strTableName + " Update Failed");
}
}
}
else
{
// Insert
using (var B = new dbFFBEntities())
{
var i = new DogOwner
{
OwnerName = txtOwnerName.Text.Trim(),
OwnerAddress = txtOwnerAddress.Text.Trim(),
OwnerCity = txtOwnerCity.Text.Trim(),
OwnerState = txtState.Text.Trim(),
OwnerZip = txtZip.Text.Trim(),
OwnerPhone = txtPhone.Text.Trim(),
OwnerEmail = txtEmail.Text.Trim(),
Active = chkActive.Checked,
LastUpdateID = Environment.UserName,
LastUpdateTimeStamp = DateTime.Now
};
B.DogOwners.Add(i);
var sa = B.SaveChanges();
if (sa == 1)
{
ClearAllDetailFields();
load_cboName();
dgv.DataSource = null;
dgv.DataSource = GetAll();
MessageBox.Show(strTableName + i.OwnerName + " Added Successfully");
}
else
{
MessageBox.Show(strTableName + " Insert failed");
}
}
}
}
public async Task <IActionResult> Get(
[FromQuery] string ownerName,
[FromQuery] string ownerAddress,
[FromQuery] string phoneNumber,
[FromQuery] int?neighborhoodId)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @" SELECT Id, OwnerName, OwnerAddress, NeighborhoodId, PhoneNumber FROM DogOwner WHERE 1 = 1";
if (ownerName != null)
{
cmd.CommandText += " AND OwnerName LIKE @ownerName";
cmd.Parameters.Add(new SqlParameter("@ownerName", "%" + ownerName + "%"));
}
if (ownerAddress != null)
{
cmd.CommandText += " AND OwnerAddress LIKE @ownerAddress";
cmd.Parameters.Add(new SqlParameter("@ownerAddress", "%" + ownerAddress + "%"));
}
if (phoneNumber != null)
{
cmd.CommandText += " AND PhoneNumber LIKE @phoneNumber";
cmd.Parameters.Add(new SqlParameter("@phoneNumber", "%" + phoneNumber + "%"));
}
if (neighborhoodId != null)
{
cmd.CommandText += " AND NeighborhoodId = @neighborhoodId";
cmd.Parameters.Add(new SqlParameter("@neighborhoodId", neighborhoodId));
}
SqlDataReader reader = cmd.ExecuteReader();
List <DogOwner> owners = new List <DogOwner>();
while (reader.Read())
{
int id = reader.GetInt32(reader.GetOrdinal("Id"));
string ownerNameValue = reader.GetString(reader.GetOrdinal("OwnerName"));
string ownerAddressValue = reader.GetString(reader.GetOrdinal("OwnerAddress"));
int hoodId = reader.GetInt32(reader.GetOrdinal("NeighborhoodId"));
string phoneNumberValue = reader.GetString(reader.GetOrdinal("PhoneNumber"));
DogOwner owner = new DogOwner
{
Id = id,
OwnerName = ownerNameValue,
OwnerAddress = ownerAddressValue,
NeighborhoodId = hoodId,
PhoneNumber = phoneNumberValue
};
owners.Add(owner);
}
reader.Close();
return(Ok(owners));
}
}
}
