public ActionResult MiniSnookerProfile(int athleteID, string extraText = "", string nameIfNotFound = "Not found")
{
var person = new PeopleLogic(db).GetBasic(0, athleteID);
string picture = person != null ? person.Picture : null;
if (string.IsNullOrEmpty(picture) == false)
{
picture = ImageUrlHelper.MakeUrlForWebProfile(picture);
}
else
{
picture = new Uri("/images/default-snookerplayer.png", UriKind.Relative).ToString();
}
ViewBag.Picture = picture;
ViewBag.ExtraText = extraText;
if (person == null)
{
person = new PersonBasicWebModel();
person.Name = Url.Encode(nameIfNotFound);
return(PartialView("MiniSnookerProfile", person));
}
return(PartialView("MiniSnookerProfile", person));
}
public void GetByIDPerson()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.ShowById(It.Is <int>(v => v == 7))).Returns(
new Person
{
Id = 7,
Name = "Victor",
Surname = "Petrov",
DateOfBirth = new DateTime(1993, 12, 27),
Age = 25,
City = "Omsk",
Street = "50 years of October",
NumberOfHouse = "51b"
});
var logic = new PeopleLogic(mock.Object);
Person person = new Person
{
Id = 7,
Name = "Victor",
Surname = "Petrov",
DateOfBirth = new DateTime(1993, 12, 27),
Age = 25,
City = "Omsk",
Street = "50 years of October",
NumberOfHouse = "51b"
};
Assert.AreEqual(Person.ToString(logic.ShowById(7)), Person.ToString(person), "Method ShowByID doesn't work");
}
public void GetByIdPerson()
{
var mock = new Mock <IPersonDao>();
mock.Setup(item => item.GetById(It.Is <int>(v => v == 4))).Returns(
new Person
{
Id = 4,
Name = "Alex",
Surname = "Pak",
DateOfBirth = new DateTime(1997, 11, 05),
Age = 21,
City = "Saratov",
Street = "Chapaeva",
NumberOfHouse = "60"
});
var logic = new PeopleLogic(mock.Object);
Person person = new Person
{
Id = 4,
Name = "Alex",
Surname = "Pak",
DateOfBirth = new DateTime(1997, 11, 05),
Age = 21,
City = "Saratov",
Street = "Chapaeva",
NumberOfHouse = "60"
};
Assert.AreEqual(Person.ToString(logic.GetById(4)), Person.ToString(person), "Error GetById.");
}
public PeopleViewModel(IMessageBoxService messageBox)
{
IsModified = false;
People = new ObservableCollection <Person>();
this.peopleLogic = new PeopleLogic();
this.path = CurrentUserHelper.GetCurrentUserDirectory() + "\\people.xml";
this.messageBox = messageBox;
}
public IEnumerable <PersonDto> GetPeople()
{
PeopleLogic.CreateXMLFileIfNotExists(this.path, "people");
PeopleLogic logic = new PeopleLogic(this.path);
logic.Save(this.path);
List <Person> people = logic.GetPeople();
return(Mapper.Map <List <PersonDto> >(people));
}
public void AddNullName()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.Add(It.IsAny <Person>())).Returns(7);
var logic = new PeopleLogic(mock.Object);
id = logic.Add(null, "Petrov", new DateTime(1993, 12, 27), 25,
"Omsk", "50 years of October", "51b");
}
public void AddNullStreet()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.Add(It.IsAny <Person>())).Returns(7);
var logic = new PeopleLogic(mock.Object);
logic.Add("Eldar", "Petrov", new DateTime(1993, 12, 27), 25,
"Omsk", null, "51b");
}
public void AddIncorrectCity()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.Add(It.IsAny <Person>())).Returns(7);
var logic = new PeopleLogic(mock.Object);
logic.Add("Eldar", "Petrov", new DateTime(1993, 12, 27), 25,
"Om5sk", "50 years of October", "51b");
}
public int AddPerson(PersonDto person)
{
PeopleLogic logic = new PeopleLogic(this.path);
Person p = Mapper.Map <Person>(person);
int personId = logic.AddPerson(p);
logic.Save(this.path);
return(personId);
}
// GET: /players/break/id
public ActionResult Break(int id)
{
var result = db.Results.Where(i => i.ResultID == id).Single();
var person = new PeopleLogic(db).GetBasic(0, result.AthleteID);
Models.SnookerBreakModel model = new Models.SnookerBreakModel();
model.Break = SnookerBreak.FromResult(result);
model.Player = person;
return(View("Break", model));
}
public void AddIncorrectCity()
{
var mock = new Mock <IPersonDao>();
mock.Setup(item => item.Add(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <DateTime>(),
It.IsAny <int>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>())).Returns(4);
var logic = new PeopleLogic(mock.Object);
id = logic.Add("Alex", "Pak", new DateTime(1997, 11, 05), 21,
"Saratov53535", "Chapaeva", "60");
}
public void AddNullNumberOfHouse()
{
var mock = new Mock <IPersonDao>();
mock.Setup(item => item.Add(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <DateTime>(),
It.IsAny <int>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>())).Returns(4);
var logic = new PeopleLogic(mock.Object);
id = logic.Add("Alex", "Pak", new DateTime(1997, 11, 05), 21,
"Saratov", "Chapaeva", null);
}
public void CorrectDataAdding()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.Add(It.IsAny <Person>())).Returns(7);
var logic = new PeopleLogic(mock.Object);
id = logic.Add("Eldar", "Petrov", new DateTime(1993, 12, 27), 25,
"Omsk", "50 years of October", "51b");
Assert.AreEqual(id, 7, "Method Add doesn't work");
}
public void AddingCorrect()
{
var mock = new Mock <IPersonDao>();
mock.Setup(item => item.Add(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <DateTime>(),
It.IsAny <int>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>())).Returns(4);
var logic = new PeopleLogic(mock.Object);
id = logic.Add("Alex", "Pak", new DateTime(1997, 11, 05), 21,
"Saratov", "Chapaeva", "60");
Assert.AreEqual(id, 4, "Error adding");
}
public void TryGetAllReward()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.GetAllRewards()).Returns(new List <string>()
{
"Ivanov Petr: Gold For Moqing Update",
"Petrov Ivan: Silver For Moqing Delete",
"Bad fantasy: Bronze For nothing"
});
var logic = new PeopleLogic(mock.Object);
var list = logic.GetAllRewards().ToList();
Assert.AreEqual(list.Count, 3);
}
// GET: /players/country/countrycode
//public ActionResult Country(string id)
//{
// Country country = Awpbs.Country.Get(id);
// if (country == null)
// throw new Exception("unknown country - " + id);
// Models.PlayersInCountryModel model = new Models.PlayersInCountryModel();
// model.Country = country;
// model.Players = new PeopleLogic(db).Find(0, "", false, country, null);
// return View("Country", model);
//}
// GET: SnookerPlayer
public ActionResult SnookerPlayer(int id, bool isInIFrame = false)
{
BybUrlHelper.IsInIFrame = isInIFrame;
var person = new PeopleLogic(db).GetFull(0, id);
int bestResultID = 0;
var res = db.Results.Where(i => i.AthleteID == id && i.Count != null).OrderByDescending(i => i.Count.Value).FirstOrDefault();
if (res != null)
{
bestResultID = res.ResultID;
}
ViewBag.BestResultID = bestResultID;
return(View("SnookerPlayer", person));
}
public bool DeletePerson(int id)
{
PeopleLogic logic = new PeopleLogic(this.path);
try
{
logic.DeletePerson(id);
logic.Save(this.path);
}
catch (PersonNotFoundException)
{
PersonNotFoundFault fault = new PersonNotFoundFault();
fault.Id = id;
fault.Message = personNotFoundFaultMessage;
throw new FaultException <PersonNotFoundFault>(fault);
}
return(true);
}
public bool EditPerson(PersonDto person, int id)
{
PeopleLogic logic = new PeopleLogic(this.path);
Person p = Mapper.Map <Person>(person);
try
{
logic.EditPerson(id, p);
logic.Save(this.path);
}
catch (PersonNotFoundException)
{
PersonNotFoundFault fault = new PersonNotFoundFault();
fault.Id = id;
fault.Message = personNotFoundFaultMessage;
throw new FaultException <PersonNotFoundFault>(fault);
}
return(true);
}
public void UpdateNullHouseNumber()
{
var mock = new Mock <IPersonDao>();
mock.Setup(item => item.GetById(It.IsAny <int>())).Returns(
new Person
{
Name = "Alex",
Surname = "Pak",
DateOfBirth = new DateTime(1997, 11, 05),
Age = 21,
City = "Saratov",
Street = "Chapaeva",
NumberOfHouse = "60"
});
var logic = new PeopleLogic(mock.Object);
mock.Setup(item => item.Update(It.IsAny <int>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <DateTime>(),
It.IsAny <int>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>()));
logic.Update(0, "Alex", "Pak", new DateTime(1997, 11, 05), 21,
"Saratov346436", "Chapaeva", null);
}
public void UpdateNullHouseNumber()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.ShowById(It.IsAny <int>())).Returns(
new Person
{
Name = "Victor",
Surname = "Petrov",
DateOfBirth = new DateTime(1993, 12, 27),
Age = 25,
City = "Omsk",
Street = "50 years of October",
NumberOfHouse = "51b"
});
var logic = new PeopleLogic(mock.Object);
mock.Setup(item => item.Update(It.IsAny <Person>()));
logic.Update(0, "Eldar", "Petrov", new DateTime(1993, 12, 27), 25,
"Omsk", "50 years of October", null);
}
public void TryGetAll()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.GetAll()).Returns(new List <Person>()
{
new Person
{
Name = "Eldar",
Surname = "Petrov",
DateOfBirth = new DateTime(1993, 12, 27),
Age = 25,
City = "Omsk",
Street = "50 years of October",
NumberOfHouse = "51b"
}
});
var logic = new PeopleLogic(mock.Object);
var list = logic.GetAll().ToList();
Assert.AreEqual(list.Count, 1);
}
public List <PersonBasicWebModel> Get(string athleteIDs)
{
int myAthleteID = 0;
if (User.Identity.IsAuthenticated == true)
{
myAthleteID = new UserProfileLogic(db).GetAthleteIDForUserName(User.Identity.Name);
}
string[] strIDs = athleteIDs.Split(',');
List <PersonBasicWebModel> people = new List <PersonBasicWebModel>();
foreach (string strID in strIDs)
{
int id = int.Parse(strID);
var person = new PeopleLogic(db).GetBasic(myAthleteID, id); // consider doing in one query!!!!!
people.Add(person);
}
return(people);
}
public void CorrectDataUpdating()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.ShowById(It.Is <int>(v => v == 5))).Returns(
new Person
{
Id = 5,
Name = "Victor",
Surname = "Petrov",
DateOfBirth = new DateTime(1993, 12, 27),
Age = 25,
City = "Omsk",
Street = "50 years of October",
NumberOfHouse = "51b"
});
var logic = new PeopleLogic(mock.Object);
mock.Setup(item => item.Update(It.IsAny <Person>()));
Assert.AreEqual(true, logic.Update(5, "Eldar", "Petrov", new DateTime(1993, 12, 27), 25,
"Omsk", "50 years of October", "51b"), "Method Update doesn't work");
}
public void TryGetAll()
{
var mock = new Mock <IPersonDao>();
mock.Setup(item => item.GetAll()).Returns(new List <Person>()
{
new Person
{
Name = "Alex",
Surname = "Pak",
DateOfBirth = new DateTime(1997, 11, 05),
Age = 21,
City = "Saratov",
Street = "Chapaeva",
NumberOfHouse = "60"
}
});
var logic = new PeopleLogic(mock.Object);
var list = logic.GetAll().ToList();
Assert.AreEqual(list.Count, 1, "...");
}
public void DeletePersonWithException()
{
var mock = new Mock <IPeopleDao>();
mock.Setup(item => item.ShowById(It.Is <int>(v => v == 7))).Returns(
new Person
{
Id = 7,
Name = "Victor",
Surname = "Petrov",
DateOfBirth = new DateTime(1993, 12, 27),
Age = 25,
City = "Omsk",
Street = "50 years of October",
NumberOfHouse = "51b"
});
mock.Setup(item => item.ShowById(It.Is <int>(v => v == 9))).Returns(
new Person
{
Id = 9,
Name = "Alexander",
Surname = "Indropov",
DateOfBirth = new DateTime(1993, 11, 23),
Age = 25,
City = "Omsk",
Street = "50 years of October",
NumberOfHouse = "22/24"
});
mock.Setup(item => item.Delete(It.IsAny <int>()));
var logic = new PeopleLogic(mock.Object);
Assert.AreEqual(true, logic.Delete(5), "Expected exception by delete");
}
public SearchTests()
{
var serviceProvider = new ServiceCollection()
.AddEntityFrameworkSqlServer()
.BuildServiceProvider();
var builder = new DbContextOptionsBuilder <PeopleContext>();
builder.UseSqlServer($"Server=(localdb)\\mssqllocaldb;Database=PeopleTest;Trusted_Connection=True;MultipleActiveResultSets=true")
.UseInternalServiceProvider(serviceProvider);
var context = new PeopleContext(builder.Options);
context.Database.Migrate();
var repo = new SqlRepository(context);
_bll = new PeopleLogic(repo);
if (!context.People.Any())
{
var basepath = System.AppContext.BaseDirectory;
var filepath = Path.Combine(basepath, "..\\..\\..\\..\\PeopleLookup.Web\\wwwroot\\data\\People.csv");
repo.LoadPeople(filepath);
}
}
public void DeletePerson()
{
var mock = new Mock <IPersonDao>();
mock.Setup(item => item.GetById(It.Is <int>(v => v == 7))).Returns(
new Person
{
Id = 4,
Name = "Alex",
Surname = "Pak",
DateOfBirth = new DateTime(1997, 11, 05),
Age = 21,
City = "Saratov",
Street = "Chapaeva",
NumberOfHouse = "60"
});
mock.Setup(item => item.GetById(It.Is <int>(v => v == 12))).Returns(
new Person
{
Id = 12,
Name = "Alex",
Surname = "Mukomel",
DateOfBirth = new DateTime(1996, 10, 04),
Age = 21,
City = "Saratov",
Street = "Volskaya",
NumberOfHouse = "73"
});
mock.Setup(item => item.Delete(It.IsAny <int>()));
var logic = new PeopleLogic(mock.Object);
logic.Delete(10);
}
public void CorrectDataUpdating()
{
var mock = new Mock <IPersonDao>();
mock.Setup(item => item.GetById(It.IsAny <int>())).Returns(
new Person
{
Name = "Alex",
Surname = "Pak",
DateOfBirth = new DateTime(1997, 11, 05),
Age = 21,
City = "Saratov",
Street = "Chapaeva",
NumberOfHouse = "60"
});
var logic = new PeopleLogic(mock.Object);
mock.Setup(item => item.Update(It.IsAny <int>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <DateTime>(),
It.IsAny <int>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>()));
Person person = new Person
{
Name = "Alex",
Surname = "Pak",
DateOfBirth = new DateTime(1997, 11, 05),
Age = 21,
City = "Saratov",
Street = "Chapaeva",
NumberOfHouse = "60"
};
logic.Update(0, "Alex", "Pak", new DateTime(1997, 11, 05), 21,
"Saratov", "Volskaya", "73");
Assert.AreEqual(Person.ToString(logic.GetById(0)), Person.ToString(person), "Error updating.");
}
