public void UpdateOwner(AngularWebApi.Models.Owner owner)
{
var dbowner = new Owner(owner);
var updateCommand = new UpdateOwnerCommand(dbowner);
updateCommand.Execute(dbConnection);
}
public Owner(AngularWebApi.Models.Owner owner)
{
Firstname = owner.firstName;
LastName = owner.lastName;
Address = owner.address;
City = owner.city;
Telephone = owner.telephone;
OwnerId = owner.id.ToString();
}
//var conn = new SqlConnection("Server=(local);DataBase=master;Integrated Security=SSPI");
public void CreateOwner(AngularWebApi.Models.Owner owner)
{
var dbowner = new Owner()
{
Firstname = owner.firstName,
LastName = owner.lastName,
Address = owner.address,
City = owner.city,
Telephone = owner.telephone
};
var createOwnerCommand = new CreateOwnerCommand(dbowner);
createOwnerCommand.Execute(dbConnection);
}
public AngularWebApi.Models.Owner FindOwner(string ownerid)
{
var findOwnerCommand = new FindOwnerCommand(ownerid);
findOwnerCommand.Execute(dbConnection);
var result = new AngularWebApi.Models.Owner()
{
address = findOwnerCommand.Result.Address,
city = findOwnerCommand.Result.City,
firstName = findOwnerCommand.Result.Firstname,
id = int.Parse(findOwnerCommand.Result.OwnerId),
lastName = findOwnerCommand.Result.LastName,
telephone = findOwnerCommand.Result.Telephone,
pet = Enumerable.Empty <AngularWebApi.Models.Pet>().ToArray()
};
return(result);
}
protected override Owner[] ProcessReader(IDataReader reader)
{
var ownerlist = new List <Owner>();
while (reader.Read())
{
Owner o = new AngularWebApi.Models.Owner
{
id = System.Convert.ToInt32(reader[0]),
firstName = System.Convert.ToString(reader[1]),
lastName = System.Convert.ToString(reader[2]),
address = System.Convert.ToString(reader[3]),
city = System.Convert.ToString(reader[4]),
telephone = System.Convert.ToString(reader[5]),
pet = Enumerable.Empty <AngularWebApi.Models.Pet>().ToArray()
};
ownerlist.Add(o);
}
return(ownerlist.ToArray());
}
public void editOwner(AngularWebApi.Models.Owner value)
{
ownerRepository.UpdateOwner(value);
}
public void addOwner(AngularWebApi.Models.Owner value)
{
this.ownerRepository.CreateOwner(value);
}
