public void GetOrderClientCards()
{
var clientCardFromBody2 = new ClientCardFromBody(
"2",
"Антон",
"ЕКБ",
"8",
"*****@*****.**",
"TV",
"Display",
"Sergey",
"123",
new DateTime(2018, 01, 01),
new DateTime(2018, 01, 01),
new string[] { "sr" },
new string[][] { new string[] { "resistor1", "10" }, new string[] { "resistor2", "15" } });
var options = SetOptions("Get_order_client_card");
var dbService = new ClientCardDatabaseService(options);
var clientCard2 = ClientCard.ConvertToClientCard(clientCardFromBody2);
var clientCard = ClientCard.ConvertToClientCard(ClientCardFromBody);
var context = new ClientCardContext(options);
dbService.AddClientCardWithContext(clientCard2, context);
dbService.AddClientCardWithContext(clientCard, context);
var db = dbService.GetAllClientCardsWithContext(context);
db.First().ContractId.Should().Be(1);
}
public IList <ClientCard> GetAllClientCardsWithContext(ClientCardContext context)
{
var clientCards = context.ClientCards.ToList();
var orderedEnumerable = clientCards.OrderBy(c => c.ContractId).Select(c => c).ToList();
return(orderedEnumerable);
}
public void GetContractCountShouldBeZero()
{
var options = SetOptions("Get_zero_count_client_card");
var dbService = new ClientCardDatabaseService(options);
var context = new ClientCardContext(options);
var count = dbService.GetContractCountWithContext(context);
count.Should().Be(0);
}
public DataController()
{
var optionsBuilder = new DbContextOptionsBuilder <ClientCardContext>();
optionsBuilder
.UseLazyLoadingProxies()
.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=clientcardsnew1db;Trusted_Connection=True;");
this.options = optionsBuilder.Options;
this.dbService = new ClientCardDatabaseService(this.options);
this.context = new ClientCardContext(this.options);
}
public void CanGetAllClientCards()
{
var options = SetOptions("Get_all_client_card");
var dbService = new ClientCardDatabaseService(options);
var clientCard = ClientCard.ConvertToClientCard(ClientCardFromBody);
var context = new ClientCardContext(options);
dbService.AddClientCardWithContext(clientCard, context);
var db = dbService.GetAllClientCardsWithContext(context);
db.FirstOrDefault()?.Works.FirstOrDefault()?.Name.Should().Be("sr");
}
public void CanAddRepairEquipments()
{
var options = SetOptions("Add_repair_equipments");
var dbService = new ClientCardDatabaseService(options);
var clientCard = ClientCard.ConvertToClientCard(ClientCardFromBody);
var context = new ClientCardContext(options);
dbService.AddClientCardWithContext(clientCard, context);
var db = dbService.GetAllClientCardsWithContext(context);
db.FirstOrDefault()?.RepairEquipments.FirstOrDefault()?.Name.Should().Be("resistor1");
}
public void CanNotAddDoubleClientCard()
{
var options = SetOptions("Add_double_to_database");
var dbService = new ClientCardDatabaseService(options);
var context = new ClientCardContext(options);
dbService.AddClientCardWithContext(this.clientCard, context);
Action act = () => dbService.AddClientCardWithContext(this.clientCard, context);
act.Should().Throw <DatabaseException>()
.WithMessage("ContractId already exists");
}
public void CanAddClientCard()
{
var options = SetOptions("Add_writes_to_database");
var dbService = new ClientCardDatabaseService(options);
var context = new ClientCardContext(options);
dbService.AddClientCardWithContext(this.clientCard, context);
var db = dbService.GetAllClientCardsWithContext(context);
db.FirstOrDefault()?.ClientName.Should().Be("Антон");
db.FirstOrDefault()?.Works.FirstOrDefault()?.Name.Should().Be("sr");
}
public void CanGetContractCount()
{
var options = SetOptions("Get_count_client_card");
var dbService = new ClientCardDatabaseService(options);
var clientCard = ClientCard.ConvertToClientCard(ClientCardFromBody);
var context = new ClientCardContext(options);
dbService.AddClientCardWithContext(clientCard, context);
var count = dbService.GetContractCountWithContext(context);
count.Should().Be(1);
}
public void AddClientCardWithContext(ClientCard clientCard, ClientCardContext context)
{
var res = context.ClientCards.FirstOrDefault(p => p.ContractId == clientCard.ContractId);
if (res == null)
{
context.Add(clientCard);
context.SaveChanges();
}
else
{
throw new DatabaseException("ContractId already exists");
}
}
public int GetContractCountWithContext(ClientCardContext context)
{
return(context.ClientCards.Count());
}
