private static void DodajArtikl()
{
try
{
using (var context = new FirmaContext())
{
//primjer dodavanja (1)
Artikl artikl = new Artikl()
{
SifArtikla = sifraArtikla,
CijArtikla = 10m,
JedMjere = "kom",
NazArtikla = "Burek sa sirom"
};
context.Artikl.Add(artikl);
context.Set <Artikl>().Add(artikl);
context.SaveChanges();
Console.WriteLine($"Artikl broj {artikl.SifArtikla} pohranjen u bazu podataka");
}
}
catch (Exception exc)
{
Console.WriteLine("Pogreška prilikom pohrane artikla broj {0} u bazu podataka : {1}", sifraArtikla, exc.CompleteExceptionMessage());
}
}
public void TestNemaDrzava()
{
// Arrange
var mockLogger = new Mock <ILogger <DrzavaController> >();
var dbOptions = new DbContextOptionsBuilder <FirmaContext>()
.UseInMemoryDatabase(databaseName: "FirmaMemory1")
.Options;
using (var context = new FirmaContext(dbOptions))
{
var controller = new DrzavaController(context, options, mockLogger.Object);
var tempDataMock = new Mock <ITempDataDictionary>();
controller.TempData = tempDataMock.Object;
// Act
var result = controller.Index();
// Assert
var redirectToActionResult = Assert.IsType <RedirectToActionResult>(result);
Assert.Equal("Create", redirectToActionResult.ActionName);
mockLogger.Verify(l => l.Log(LogLevel.Information,
It.IsAny <EventId>(),
It.IsAny <object>(),
It.IsAny <Exception>(),
It.IsAny <Func <object, Exception, string> >())
, Times.Once());
}
}
public AutoCompleteMjestoTests()
{
//Arrange
var builder = new ConfigurationBuilder()
.AddUserSecrets("Firma")
.AddJsonFile("appsettings.json");
var Configuration = builder.Build();
var appSection = Configuration.GetSection("AppSettings");
string connectionString = appSection.GetValue <string>("ConnectionString");
connectionString = connectionString.Replace("sifra", Configuration["FirmaSqlPassword"]);
var dbContextBuilder = new DbContextOptionsBuilder <FirmaContext>()
.UseSqlServer(connectionString);
ctx = new FirmaContext(dbContextBuilder.Options);
options = Options.Create <AppSettings>(new AppSettings
{
ConnectionString = connectionString,
PageOffset = int.Parse(appSection["PageOffset"]),
PageSize = int.Parse(appSection["PageSize"])
});
}
public void TestIspravanBrojDrzavaNaStranici()
{
// Arrange
var mockLogger = new Mock <ILogger <DrzavaController> >();
var dbOptions = new DbContextOptionsBuilder <FirmaContext>()
.UseInMemoryDatabase(databaseName: "FirmaMemory2")
.Options;
using (var context = new FirmaContext(dbOptions))
{
for (int i = 0; i < 50; i++)
{
context.Add(new Drzava
{
SifDrzave = i
});
}
context.SaveChanges();
var controller = new DrzavaController(context, options, mockLogger.Object);
var tempDataMock = new Mock <ITempDataDictionary>();
controller.TempData = tempDataMock.Object;
// Act
var result = controller.Index();
// Assert
var viewResult = Assert.IsType <ViewResult>(result);
DrzaveViewModel model = Assert.IsType <DrzaveViewModel>(viewResult.Model);
Assert.Equal(options.Value.PageSize, model.Drzave.Count());
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
var addClientFromList = new AddClientFromList();
FirmaContext ctx = new FirmaContext();
addClientFromList.ListOfClients.ItemsSource = ctx.Clients.ToList();
addClientFromList.Show();
}
private static void IzmijeniCijenuArtikla()
{
try
{
using (var context = new FirmaContext())
{
Artikl artikl = context.Artikl.Find(sifraArtikla);
artikl.CijArtikla = 11m;
context.SaveChanges();
Console.WriteLine("Cijena artikla izmijenjena");
}
}
catch (Exception exc)
{
Console.WriteLine("Pogreška prilikom izmjene cijene artikla {0} u bazu podataka : {1}", sifraArtikla, exc.CompleteExceptionMessage());
}
}
private static void DohvatiNajskuplje()
{
Console.WriteLine("Unesite cijeli broj za prvih N najskupljih artikala");
int n = int.Parse(Console.ReadLine());
using (var context = new FirmaContext())
{
var upit = context.Artikl
.Include(a => a.Stavka)
.AsNoTracking()
.OrderByDescending(a => a.CijArtikla)
.Take(n);
int cnt = 0;
foreach (Artikl artikl in upit)
{
Console.WriteLine("{0}. {1} - {2:C2} ({3})", ++cnt, artikl.NazArtikla, artikl.CijArtikla, artikl.Stavka.Count);
}
}
}
private static void ObrisiArtikl()
{
try
{
using (var context = new FirmaContext())
{
//Artikl artikl = context.Find<Artikl>(sifraArtikla);
Artikl artikl = context.Artikl.Find(sifraArtikla);
context.Artikl.Remove(artikl);
//context.Entry(artikl).State = EntityState.Deleted;
context.SaveChanges();
Console.WriteLine("Artikl obrisan");
}
}
catch (Exception exc)
{
Console.WriteLine("Pogreška prilikom brisanje artikla broj {0} : {1}", sifraArtikla, exc.CompleteExceptionMessage());
}
}
private static void DohvatiNajskuplje_v2()
{
Console.WriteLine("Unesite cijeli broj za prvih N najskupljih artikala");
int n = int.Parse(Console.ReadLine());
using (var context = new FirmaContext())
{
var upit = context.Artikl
.OrderByDescending(a => a.CijArtikla)
.Select(a => new { a.NazArtikla, a.CijArtikla, BrojProdanih = a.Stavka.Count })
.Take(n);
int cnt = 0;
foreach (var artikl in upit)
{
Console.WriteLine("{0}. {1} - {2:C2} ({3})", ++cnt, artikl.NazArtikla, artikl.CijArtikla, artikl.BrojProdanih);
}
}
}
public ZamowienieController(FirmaContext context)
{
_context = context;
}
public ArtiklController(FirmaContext ctx, IOptions <AppSettings> options)
{
this.ctx = ctx;
appData = options.Value;
}
private FirmaContext ctx;// = new FirmaContext();
public ClientViewModel()
{
ctx = new FirmaContext();
}
public StronaController(FirmaContext context)
{
_context = context;
}
public HomeController(FirmaContext context)
{
_context = context;
}
public KoszykB(FirmaContext context, HttpContext httpContext)
{
_context = context;
this.IdSesjiKoszyka = GetIdSesjiKoszyka(httpContext);
}
public RodzajController(FirmaContext context)
{
_context = context;
}
public KoszykController(FirmaContext context)
{
_context = context;
}
public TowarController(FirmaContext context)
{
_context = context;
}
public ZakupController(FirmaContext context)
{
_context = context;
}
public RodzajeMenuComponent(FirmaContext context)
{
_context = context;
}
public AktualnoscController(FirmaContext context)
{
_context = context;
}
public ReportController(FirmaContext ctx)
{
this.ctx = ctx;
}
public DrzavaController(FirmaContext ctx, IOptions <AppSettings> options, ILogger <DrzavaController> logger)
{
this.ctx = ctx;
appData = options.Value;
this.logger = logger;
}
public SklepController(FirmaContext context)
{
this._context = context;
}
public PozycjaZamowieniaController(FirmaContext context)
{
_context = context;
}
