public IActionResult Index()
{
string connectionString = configuration.GetConnectionString("Default");
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
var certificates = connection.Query <Certificate>(@"
SELECT
Name,
CertificateData,
CreatedDate
FROM Certificates");
string stringToEncrypt = RandomString(32);
var vm = new CertificatesViewModel
{
StringToEncrypt = stringToEncrypt,
Certificates = certificates.Select(c =>
{
var cert = new X509Certificate2(c.CertificateData, (string)null, X509KeyStorageFlags.Exportable | X509KeyStorageFlags.MachineKeySet);
return(new CertificatesViewModel.CertificateViewModel
{
Name = c.Name,
EncryptedString = Encrypt(cert, stringToEncrypt),
CreatedDate = c.CreatedDate
});
})
};
return(View(vm));
}
}
public CertificatesPage()
{
InitializeComponent();
BindingContext = model = new CertificatesViewModel();
/*
* list = new List<string>();
* list.Add("item1");
* list.Add("item2");
* list.Add("item3");
* // List.ItemsSource = list;
* certificates = new List<Certificate>();
* certificates.Add(new Certificate { Svrha = "Uvjerenje o statusu studenta", Datum = "15.06.2020", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Uvjerenje o položenim ispitima sa prosječnom ocjenom", Datum = "16.12.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });
* certificates.Add(new Certificate { Svrha = "Ljekarsko uvjernje o zdravstvenom stanju", Datum = "23.01.2019", Status = "Izdata" });*/
// Certificates.ItemsSource = certificates;
}
public ActionResult Certificates()
{
lear dbconext = new lear();
CertificatesViewModel model = new CertificatesViewModel();
var certificates = dbconext.Certifications.ToList <Certification>();
foreach (var cert in certificates)
{
System.Diagnostics.Debug.WriteLine(cert.Description);
model.Certifications.Add(new Certification()
{
Id = cert.Id, Code = cert.Code, Description = cert.Description, Points = cert.Points
});
}
return(View(model));
}
public Certificates(CertificatesViewModel viewModel)
{
_viewModel = viewModel;
DataContext = _viewModel;
InitializeComponent();
}
public CertificatesPage()
{
_viewModel = App.ServiceProvider.GetService <CertificatesViewModel>();
InitializeComponent();
BindingContext = _viewModel;
}
