public void OrderGetAll()
{
DataBase dataBase = new DataBase();
string itemTypeName = Guid.NewGuid().ToString();
ItemType itemType = new ItemType {Name = itemTypeName,};
dataBase.ItemTypeInsert(itemType);
ItemType itemTypeGet = dataBase.ItemTypeGet(itemTypeName);
Assert.IsNotNull(itemTypeGet);
string itemName = Guid.NewGuid().ToString();
Item item = new Item
{
Name = itemName,
ItemTypeId = itemTypeGet.Id,
};
dataBase.ItemInsert(item);
Item itemGet = dataBase.ItemGet(itemName);
Assert.IsNotNull(itemGet);
string itemStatusName = Guid.NewGuid().ToString();
ItemStatus itemStatus = new ItemStatus {Name = itemStatusName};
dataBase.ItemStatusInsert(itemStatus);
ItemStatus itemStatusGet = dataBase.ItemStatusGet(itemStatusName);
Assert.IsNotNull(itemStatusGet);
string personInfoName = Guid.NewGuid().ToString();
string personInfoSurName = Guid.NewGuid().ToString();
PersonInfo personInfo = new PersonInfo {Name = personInfoName, SurName = personInfoSurName,};
dataBase.PersonInfoInsert(personInfo);
PersonInfo personInfoGet = dataBase.PersonInfoGet(personInfoName, personInfoSurName);
Assert.IsNotNull(personInfoGet);
Order order = new Order
{
ItemId = itemGet.Id,
Count = 1,
ItemStatusId = itemStatusGet.Id,
LegalEntity = true,
PersonInfoId = personInfoGet.Id,
Postage = 0M.DecimalToString(),
Price = 1M.DecimalToString(),
BankId = -1,
};
int rowsInserted = dataBase.OrderInsert(order);
Assert.AreEqual(1, rowsInserted);
List<Order> orders = dataBase.OrderGetAll();
Assert.IsNotNull(orders);
Order find = orders.Find(o => o.ItemId == itemGet.Id);
Assert.IsNotNull(find);
}
public void GetPersonInfoNonExisting()
{
DataBase dataBase = new DataBase();
PersonInfo personInfo = dataBase.PersonInfoGet(-1);
Assert.IsNull(personInfo);
}
public void UpdatePersonInfo()
{
DataBase dataBase = new DataBase();
string name = Guid.NewGuid().ToString();
PersonInfo personInfo = new PersonInfo
{
Name = name,
SurName = "surname",
NickName = "nickname",
Description = "description",
Address = "adddress",
PostNumber = 123,
City = "city",
Email = "*****@*****.**",
Telephone = "00386 2 876 1234",
TelephoneMobile = "++386 40 123 456",
Fax = "+386 2 8761 211"
};
int rowsInserted = dataBase.PersonInfoInsert(personInfo);
Assert.AreEqual(1, rowsInserted, "Person not inserted!");
List<PersonInfo> list = dataBase.PersonInfoGetAll();
Assert.IsNotNull(list);
PersonInfo find = list.Find(p => p.Name == name);
Assert.IsNotNull(find);
string newName = Guid.NewGuid().ToString();
find.Name = newName;
int rowsUpdated = dataBase.PersonInfoUpdate(find);
Assert.AreEqual(1, rowsUpdated);
PersonInfo updatedPersonInfo = dataBase.PersonInfoGet(find.Id);
Assert.AreEqual(newName, updatedPersonInfo.Name);
Assert.AreEqual(personInfo.SurName, updatedPersonInfo.SurName);
Assert.AreEqual(personInfo.NickName, updatedPersonInfo.NickName);
Assert.AreEqual(personInfo.Description, updatedPersonInfo.Description);
Assert.AreEqual(personInfo.Address, updatedPersonInfo.Address);
Assert.AreEqual(personInfo.PostNumber, updatedPersonInfo.PostNumber);
Assert.AreEqual(personInfo.City, updatedPersonInfo.City);
Assert.AreEqual(personInfo.Email, updatedPersonInfo.Email);
Assert.AreEqual(personInfo.Telephone, updatedPersonInfo.Telephone);
Assert.AreEqual(personInfo.TelephoneMobile, updatedPersonInfo.TelephoneMobile);
Assert.AreEqual(personInfo.Fax, updatedPersonInfo.Fax);
}
