public static string Run(Kandidat k)
{
return Sanitize(k.Id) + ";" +
Sanitize(k.Status.ToString()) + ";" +
Sanitize(k.Kommentar) + ";" +
Sanitize(k.KommentarApollo) + ";" +
Sanitize(new AnredeWerte().GermanLabel(k.Geschlecht, "")) + ";" +
Sanitize(k.Familienname) + ";" +
Sanitize(k.Vorname) + ";" +
Sanitize(k.FamiliennameKY) + ";" +
Sanitize(k.VornameKY) + ";" +
Sanitize(k.VatersnameKY) + ";" +
Sanitize(k.EmailAdresse) + ";" +
Sanitize(k.Mobilnummer) + ";" +
Sanitize(GetGeburtsdatum(k.Geburtsdatum)) + ";" +
Sanitize(k.GetAlter()) + ";" +
Sanitize(new Universitaeten().GermanLabel(k.Hochschule, "")) + ";" +
Sanitize(k.Fakultät) + ";" +
Sanitize(new Studienfaecher().GermanLabel(k.Studienfach, "")) + ";" +
Sanitize(k.Spezialisierung) + ";" +
Sanitize(new Studienjahr().GermanLabel(k.Studienjahr, "")) + ";" +
Sanitize(k.VerkürzterStudiengang) + ";" +
Sanitize(new Abschluesse().GermanLabel(k.AngestrebterAbschluss, "")) + ";" +
Sanitize(k.NummerInlandspass) + ";" +
Sanitize(k.Deutschkentnisse) + ";" +
Sanitize(k.DeutschkentnisseDurchSchule) + ";" +
Sanitize(k.DeutschkentnisseDurchUni) + ";" +
Sanitize(k.DeutschkentnisseDurchSonstige) + ";" +
Sanitize(k.FruehererAufenthalt) + ";" +
Sanitize(k.FruehererAufenthaltProgramm);
}
public Kandidat GetCandidate(long id)
{
try
{
string connectionString = ConnectionStringHelper.GetConnectionString(_configuration);
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlTransaction transaction = connection.BeginTransaction())
{
ExecutorService repository = new ExecutorService(connection, transaction);
List <SqlParameter> parameters = new List <SqlParameter>();
repository.AddParameterInList("@Id", id, SqlDbType.BigInt, ref parameters);
SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_CANDIDATE, parameters);
Kandidat candidate = DataReaderConverter.ToObject <Kandidat>(dataReader);
dataReader.Close();
return(candidate);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Edit(int id, [Bind("IdAccaNumber,Ime,Prezime,Email,Drzava,Odeljenje")] Kandidat kandidat)
{
if (id != kandidat.IdAccaNumber)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(kandidat);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!KandidatExists(kandidat.IdAccaNumber))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(kandidat));
}
public AdministratorViewModel(OstaleFunkcionalnostiViewModel p)
{
NovaNovost = new Novost(DateTime.Today, null, "", "");
NoviKandidat = new Kandidat();
//this.Sistem = new GlasackiSistem();
Parent = p;
this.Sistem = Parent.Sistem;
kojaStranka = new Stranka();
ListaKandidata = new List <Kandidat>();
ListaNovosti = new List <Novost>();
INS = new NavigationService();
Login = new RelayCommand <object>(registrujAdmina, potvrdi);
DodavanjeKandidata = new RelayCommand <object>(dodajKandidata, boolDodaj);
DodavanjeNovosti = new RelayCommand <object>(dodajNovost, boolDodaj);
BrisanjeKandidata = new RelayCommand <object>(obrisiKandidata, boolDodaj);
BrisanjeNovosti = new RelayCommand <object>(obrisiNovost, boolDodaj);
IzmjenaKandidata = new RelayCommand <object>(promjenaKandidata, boolDodaj);
IzmjenaNovosti = new RelayCommand <object>(promjenaNovosti, boolDodaj);
Odjava = new RelayCommand <object>(odjava, boolDodaj);
OtvoriPretraguK = new RelayCommand <object>(pretragaK, boolDodaj);
OtvoriPretraguN = new RelayCommand <object>(pretragaN, boolDodaj);
PretragaNovosti = new RelayCommand <object>(nadjiNovosti, boolDodaj);
PretragaKandidata = new RelayCommand <object>(nadjiKandidate, boolDodaj);
UcitajSliku = new RelayCommand <object>(dodajSliku, boolDodaj);
NoviKandidat.ErrorsChanged += Vm_ErrorsChanged;
}
public AdministratorViewModel()
{
this.Sistem = new GlasackiSistem();
//this.Sistem = Parent.Sistem;
ListaKandidata = Sistem.KandidatiD;
ListaNovosti = Sistem.Novosti;
NoviKandidat = new Kandidat();
NovaNovost = new Novost();
NoviKandidat.DatRodjenja = DateTime.Now;
Login = new RelayCommand <object>(registrujAdmina, potvrdi);
DodavanjeKandidata = new RelayCommand <object>(dodajKandidata, boolDodaj);
DodavanjeNovosti = new RelayCommand <object>(dodajNovost, boolDodaj);
BrisanjeKandidata = new RelayCommand <object>(obrisiKandidata, boolDodaj);
BrisanjeNovosti = new RelayCommand <object>(obrisiNovost, boolDodaj);
IzmjenaKandidata = new RelayCommand <object>(promjenaKandidata, boolDodaj);
IzmjenaNovosti = new RelayCommand <object>(promjenaNovosti, boolDodaj);
Odjava = new RelayCommand <object>(odjava, boolDodaj);
PretragaNovosti = new RelayCommand <object>(nadjiNovosti, boolDodaj);
PretragaKandidata = new RelayCommand <object>(nadjiKandidate, boolDodaj);
UcitajSliku = new RelayCommand <object>(dodajSliku, boolDodaj);
NaziviStranki = new ObservableCollection <string>();
NaziviStranki.Add("OOAD");
NaziviStranki.Add("Proba");
/*
* for (int i=0; i<Sistem.Stranke.Count; i++)
* {
* NaziviStranki.Add(Sistem.Stranke[i].Naziv);
* }
*/
//NoviKandidat.ErrorsChanged += Vm_ErrorsChanged;
}
public long AddCandidate(Kandidat kandidat)
{
try
{
string connectionString = ConnectionStringHelper.GetConnectionString(_configuration);
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlTransaction transaction = connection.BeginTransaction())
{
ExecutorService repository = new ExecutorService(connection, transaction);
List <SqlParameter> parameters = new List <SqlParameter>();
repository.AddParameterInList("@ImePrezime", kandidat.imePrezime, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@JMBG", kandidat.jmbg, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Adresa", kandidat.adresa, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Telefon", kandidat.telefon, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Email", kandidat.email, SqlDbType.Text, ref parameters);
SqlDataReader dataReader = repository.ExecuteProcedure(Constants.ADD_CANDIDATE, parameters);
long insertedId = DataReaderConverter.ToBigInt(dataReader);
dataReader.Close();
transaction.Commit();
return(insertedId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Kandidat Run(AnmeldungModel anmeldungModel, Kandidat kandidat)
{
kandidat.Familienname = anmeldungModel.Familienname;
kandidat.Vorname = anmeldungModel.Vorname;
kandidat.Geburtsdatum = DateTime.Parse(anmeldungModel.Geburtsdatum, CultureInfo.GetCultureInfo("de-DE"));
kandidat.NummerInlandspass = anmeldungModel.Inlandspass;
kandidat.Mobilnummer = anmeldungModel.Mobilfunknummer;
kandidat.Hochschule = Convert.ToInt32(anmeldungModel.UniVal);
kandidat.Fakultät = anmeldungModel.Fakultaet;
kandidat.Spezialisierung = anmeldungModel.Studienfach;
kandidat.Studienfach = Convert.ToInt32(anmeldungModel.StudienfachVal);
kandidat.Studienjahr = Convert.ToInt32(anmeldungModel.StudienJahrVal);
kandidat.VerkürzterStudiengang = anmeldungModel.VerkürzterStudiengang;
kandidat.AngestrebterAbschluss = Convert.ToInt32(anmeldungModel.AngestrebterAbschlussVal);
kandidat.Deutschkentnisse = anmeldungModel.Deutschkentnisse;
kandidat.DeutschkentnisseDurchSchule = anmeldungModel.DeutschkentnisseDurchSchule;
kandidat.DeutschkentnisseDurchUni = anmeldungModel.DeutschkentnisseDurchUni;
kandidat.DeutschkentnisseDurchSonstige = anmeldungModel.DeutschkentnisseDurchSonstige;
kandidat.FruehererAufenthalt = anmeldungModel.BereitsAufenthalt;
kandidat.FruehererAufenthaltProgramm = anmeldungModel.BereitsAufenthaltProgramm;
kandidat.Kommentar = anmeldungModel.Kommentar;
kandidat.KommentarApollo = anmeldungModel.KommentarApollo;
return kandidat;
}
public IHttpActionResult PutKandidat(long id, Kandidat kandidat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != kandidat.JMBG)
{
return(BadRequest());
}
db.Entry(kandidat).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KandidatExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(long id)
{
Kandidat kandidat = db.Kandidat.Find(id);
db.Kandidat.Remove(kandidat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public BenutzerDatenModel(Kandidat kandidat)
{
AnredeOpts = new AnredeWerte().ToSelectItems(kandidat.Geschlecht);
FamiliennameKY = kandidat.FamiliennameKY;
VornameKY = kandidat.VornameKY;
VatersnameKY = kandidat.VatersnameKY;
Emailadresse = kandidat.EmailAdresse;
}
public async Task <IActionResult> OnPostAsync(string returnUrl = null)
{
returnUrl = returnUrl ?? Url.Content("~/");
if (ModelState.IsValid)
{
var user = new IdentityUser {
UserName = Input.Email, Email = Input.Email
};
Kandidat userInDb = await _context.Kandidat.Where(k => k.Email == user.Email).FirstOrDefaultAsync();
if (userInDb == null)
{
return(NotFound($"U bazi kandidata ne postoji kandidat sa mejl adresom {user.Email}. Molimo kontaktirajte administratore ili Talent Team."));
}
var result = await _userManager.CreateAsync(user, Input.Password);
if (result.Succeeded)
{
if (!await _roleManager.RoleExistsAsync(SD.CandidatEndUSer))
{
await _roleManager.CreateAsync(new IdentityRole(SD.CandidatEndUSer));
}
if (!await _roleManager.RoleExistsAsync(SD.AdminEndUser))
{
await _roleManager.CreateAsync(new IdentityRole(SD.AdminEndUser));
}
await _userManager.AddToRoleAsync(user, SD.CandidatEndUSer);
_logger.LogInformation("User created a new account with password.");
/*
* var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
* var callbackUrl = Url.Page(
* "/Account/ConfirmEmail",
* pageHandler: null,
* values: new { userId = user.Id, code = code },
* protocol: Request.Scheme);
*
* await _emailSender.SendEmailAsync(Input.Email, "Confirm your email",
* $"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>.");
*/
await _signInManager.SignInAsync(user, isPersistent : false);
return(LocalRedirect(returnUrl));
}
foreach (var error in result.Errors)
{
ModelState.AddModelError(string.Empty, error.Description);
}
}
// If we got this far, something failed, redisplay form
return(Page());
}
public static Kandidat Run(BenutzerDatenModel model, Kandidat kandidat)
{
kandidat.Geschlecht = Convert.ToInt32(model.AnredeVal);
kandidat.FamiliennameKY = model.FamiliennameKY;
kandidat.VornameKY = model.VornameKY;
kandidat.VatersnameKY = model.VatersnameKY;
kandidat.EmailAdresse = model.Emailadresse;
return kandidat;
}
public IActionResult Odjava(int?id)
{
Kandidat k = _context.Kandidat.Include(ka => ka.GlasackiListic).Where(ka => ka.ID == HomeController.currentlyLogged.ID).FirstOrDefault();
var glasackiListic = _context.GlasackiListic.Include(g => g.Kandidati).FirstOrDefault(g => g.ID == id);
glasackiListic.Kandidati.Remove(k);
_context.SaveChanges();
ViewBag.Message = "Odjavili ste sa izbora!";
return(View("izbori", _context.Izbor.Include(i => i.GlasackiListici).ToList()));
}
public ActionResult Edit([Bind(Include = "JMBG,Ime,Prezime,Mjesto_stanovanja,N")] Kandidat kandidat)
{
if (ModelState.IsValid)
{
db.Entry(kandidat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(kandidat));
}
public DashboardModel(Kandidat kandidat)
{
VornameKY = kandidat.VornameKY;
NachnameKY = kandidat.FamiliennameKY;
Nachname_Vorname_Vatersname = kandidat.FamiliennameKY + " " + kandidat.VornameKY + " " + kandidat.VatersnameKY;
Email = kandidat.EmailAdresse;
KandidatStatus = kandidat.Status;
}
public IActionResult Prijava()
{
var glasac = _context.Glasac.FirstOrDefault(i => i.ID == HomeController.currentlyLogged.ID);
Kandidat k = getKandidat(glasac);
_context.Kandidat.Add(k);
_context.Glasac.Remove(glasac);
_context.SaveChanges();
HomeController.currentlyLogged = k;
return(RedirectToAction("Change", "Home"));
}
public IHttpActionResult GetKandidat(long id)
{
Kandidat kandidat = db.Kandidats.Find(id);
if (kandidat == null)
{
return(NotFound());
}
return(Ok(kandidat));
}
public async Task <IActionResult> Create([Bind("IdAccaNumber,Ime,Prezime,Email,Drzava,Odeljenje")] Kandidat kandidat)
{
if (ModelState.IsValid)
{
_context.Add(kandidat);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(kandidat));
}
public ActionResult Create([Bind(Include = "JMBG,Ime,Prezime,Mjesto_stanovanja,N")] Kandidat kandidat)
{
if (ModelState.IsValid)
{
db.Kandidat.Add(kandidat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(kandidat));
}
public static Kandidat Run(RegistrierungModel model)
{
var praktikant = new Kandidat();
praktikant.Geschlecht = Convert.ToInt32(model.AnredeVal);
praktikant.FamiliennameKY = model.FamiliennameKY;
praktikant.VornameKY = model.VornameKY;
praktikant.VatersnameKY = model.VatersnameKY;
praktikant.EmailAdresse = model.Emailadresse;
praktikant.Passwort = HashPassword.Run(model.Passwort);
return praktikant;
}
public IHttpActionResult PostKandidat(Kandidat kandidat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Kandidats.Add(kandidat);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = kandidat.JMBG }, kandidat));
}
public IActionResult KreirajRaspored(int KandidatId)
{
Kandidat k = reposKandidati.GetById(KandidatId);/*Kandidati.Find(KandidatId);*/
RasporedCasova raspored = new RasporedCasova()
{
Kandidat = k
};
reposRaspored.Add(raspored);
//baza.SaveChanges();
//baza.Dispose();
return(RedirectToAction(nameof(PrikaziRaspored)));
}
public async Task <IActionResult> RegistracijaAsync(RegistracijaViewModel korisnik)
{
if (ModelState.IsValid)
{
var noviKorisnik = new Korisnik
{
UserName = korisnik.KorisnickoIme,
Email = korisnik.Email,
PhoneNumberConfirmed = true,
TwoFactorEnabled = false,
LockoutEnabled = false,
AccessFailedCount = 1
};
var rezultat = await _UserManager.CreateAsync(noviKorisnik, korisnik.Lozinka);
if (rezultat.Succeeded)
{
await _UserManager.AddToRoleAsync(noviKorisnik, "Kandidat");
//Potvrda naloga
var token = await _UserManager.GenerateEmailConfirmationTokenAsync(noviKorisnik);
var confirmationLink = Url.Action("ConfirmEmail", "Autentifikacija", new { korisnikId = noviKorisnik.Id, token = token }, Request.Scheme);
ViewBag.token = confirmationLink;
_logger.Log(LogLevel.Warning, confirmationLink);
var kandidat = new Kandidat
{
ImePrezime = korisnik.Ime + " " + korisnik.Prezime,
JMBG = korisnik.JMBG,
DatumRodjenja = korisnik.DatumRodjenja,
Email = korisnik.Email,
Korisnik = noviKorisnik,
Status = false
};
_reposKandidat.Add(kandidat);
var text = " Klikom na link, aktiviracete korisnicki nalog " + "<a href=\"" + confirmationLink + "\">Link</a> ";
SlanjeEmaila(text, noviKorisnik, false);
}
foreach (var error in rezultat.Errors)
{
ModelState.AddModelError("", error.Description);
}
return(View("UspjesnaRegistracija"));
}
return(RedirectToAction("Registracija", "Autentifikacija"));
}
// GET: Kandidats/Delete/5
public ActionResult Delete(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Kandidat kandidat = db.Kandidat.Find(id);
if (kandidat == null)
{
return(HttpNotFound());
}
return(View(kandidat));
}
public IHttpActionResult DeleteKandidat(long id)
{
Kandidat kandidat = db.Kandidats.Find(id);
if (kandidat == null)
{
return(NotFound());
}
db.Kandidats.Remove(kandidat);
db.SaveChanges();
return(Ok(kandidat));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Kandidat = await _context.Kandidat.FirstOrDefaultAsync(m => m.ID == id);
if (Kandidat == null)
{
return(NotFound());
}
return(Page());
}
/// <summary>
/// Briše odabranog kandidata iz baze podataka.
/// </summary>
private void ObrisiKandidata()
{
Kandidat selektiraniKandidat = kandidatBindingSource.Current as Kandidat;
if (selektiraniKandidat != null)
{
using (var db = new Entities2())
{
db.Kandidat.Attach(selektiraniKandidat);
{
db.Kandidat.Remove(selektiraniKandidat);
db.SaveChanges();
}
}
}
}
/// <summary>
/// Sprema napravljene promjene u bazu podataka.
/// </summary>
private void SpremiUBazu()
{
// NE MOZE SE DODATI KANDIDATA AKO JE GLASANJE U TIJEKU
using (var db = new Entities2())
{
Kandidat kandidat = new Kandidat
{
Ime = txtImeUnos.Text,
Prezime = txtPrezimeUnos.Text,
DodatnaPoruka = txtPorukaUnos.Text,
Naziv = txtNazivUnos.Text,
GlasanjeID_glasanja = int.Parse(cbGlasanja.SelectedValue.ToString()),
Slika = SlikaUBajtove(pbSlikaKandidata.Image)
};
db.Kandidat.Add(kandidat);
db.SaveChanges();
}
}
private Kandidat getKandidat(Osoba osoba)
{
Kandidat k = new Kandidat();
k.Ime = osoba.Ime;
k.Prezime = osoba.Prezime;
k.DatumRodjenja = osoba.DatumRodjenja;
k.JMBG = osoba.JMBG;
k.BrojLicneKarte = osoba.BrojLicneKarte;
//k.BirackoMjestoID = osoba.BirackoMjestoID;
k.StrankaId = osoba.StrankaId;
k.Spol = osoba.Spol;
k.Ulica = osoba.Ulica;
k.Kanton = osoba.Kanton;
k.Lozinka = osoba.Lozinka;
k.EMail = osoba.EMail;
k.isSelected = false;
return(k);
}
public void Update()
{
if (!String.IsNullOrEmpty(txtIme) &
!String.IsNullOrEmpty(txtPrezime) &
!String.IsNullOrEmpty(txtJMBG) &
!String.IsNullOrEmpty(Convert.ToString(txtGodRodjenja)) &
!String.IsNullOrEmpty(txtEmail) &
!String.IsNullOrEmpty(txtTelefon) &
!String.IsNullOrEmpty(txtNapomena) &
!String.IsNullOrEmpty(txtZapNakKonk))
{
try
{
Kandidat kandidat = new Kandidat
{
ime = txtIme,
prezime = txtPrezime,
jmbg = txtJMBG,
god_rodjenja = Convert.ToString(txtGodRodjenja),
email = txtEmail,
telefon = txtTelefon,
napomena = txtNapomena,
zaposlen_nakon_konkursa = txtZapNakKonk
};
var IsSaved = ObjKandidatiService.Update(kandidat);
if (IsSaved)
{
Message = "Podaci o kandidatu sa jmbg-om:" + txtJMBG + " su izmenjeni.";
Osvezi();
}
else
{
Message = "Doslo je do greske.";
}
}
catch (Exception ex)
{
Message = ex.Message;
}
}
}
public AdministratorViewModel()
{
NovaNovost = new Novost(DateTime.Today, null, "", "");
NoviKandidat = new Kandidat();
this.Sistem = Parent.Sistem;
ListaKandidata = new List <Kandidat>();
ListaNovosti = new List <Novost>();
Login = new RelayCommand <object>(registrujAdmina, potvrdi);
DodavanjeKandidata = new RelayCommand <object>(dodajKandidata, boolDodaj);
DodavanjeNovosti = new RelayCommand <object>(dodajNovost, boolDodaj);
BrisanjeKandidata = new RelayCommand <object>(obrisiKandidata, boolDodaj);
BrisanjeNovosti = new RelayCommand <object>(obrisiNovost, boolDodaj);
IzmjenaKandidata = new RelayCommand <object>(promjenaKandidata, boolDodaj);
IzmjenaNovosti = new RelayCommand <object>(promjenaNovosti, boolDodaj);
Odjava = new RelayCommand <object>(odjava, boolDodaj);
PretragaNovosti = new RelayCommand <object>(nadjiNovosti, boolDodaj);
PretragaKandidata = new RelayCommand <object>(nadjiKandidate, boolDodaj);
UcitajSliku = new RelayCommand <object>(dodajSliku, boolDodaj);
}
public IActionResult Prijava(int?id)
{
Kandidat k = _context.Kandidat.Include(ka => ka.GlasackiListic).Where(ka => ka.ID == HomeController.currentlyLogged.ID).FirstOrDefault();
if (k.GlasackiListic != null)
{
ViewBag.Message = "Već ste prijavljeni na izbore!";
return(View("Detalji", _context.GlasackiListic.Include(g => g.Kandidati).Where(i => i.IzborId == currentIzbor).ToList()));
}
var glasackiListic = _context.GlasackiListic.Include(g => g.Kandidati).Include(g => g.Izbor).FirstOrDefault(g => g.ID == id);
var izboriPoc = glasackiListic.Izbor.Pocetak;
if (DateTime.Now > izboriPoc)
{
ViewBag.Message = "Prijave su završene!";
return(View("Detalji", _context.GlasackiListic.Include(g => g.Kandidati).Where(i => i.IzborId == currentIzbor).ToList()));
}
glasackiListic.Kandidati.Add(k);
_context.SaveChanges();
ViewBag.Message = "Uspješno ste se prijavili na izbore!";
return(View("Detalji", _context.GlasackiListic.Include(g => g.Kandidati).Where(i => i.IzborId == currentIzbor).ToList()));
}
public void ObavestajniEmail(int KandidatId, string text)
{
Kandidat k = reposKandidat.GetById(KandidatId);
var novaPoruka = new MimeMessage();
novaPoruka.From.Add(new MailboxAddress("EAutoSkola", "*****@*****.**"));
novaPoruka.To.Add(new MailboxAddress(k.Korisnik.UserName, k.Korisnik.Email));
novaPoruka.Subject = "Odobrenje";
novaPoruka.Body = new TextPart("html")
{
Text = text
};
using (var klijent = new SmtpClient())
{
klijent.Connect("smtp.gmail.com", 587, false);
klijent.Authenticate("*****@*****.**", "Programiranje123");
klijent.Send(novaPoruka);
klijent.Disconnect(true);
}
}
private async static void AddKorisnik(MyContext context)
{
if (context.Users.ToList().Count > 0)
{
return;
}
//korisnicki nalozi
var korisnik = new Korisnik()
{
Email = "*****@*****.**",
UserName = "******",
PhoneNumberConfirmed = true,
TwoFactorEnabled = false,
LockoutEnabled = false,
AccessFailedCount = 1
};
var korisnik2 = new Korisnik()
{
Email = "*****@*****.**",
UserName = "******",
PhoneNumberConfirmed = true,
TwoFactorEnabled = false,
LockoutEnabled = false,
AccessFailedCount = 1
};
var korisnik3 = new Korisnik()
{
Email = "*****@*****.**",
UserName = "******",
PhoneNumberConfirmed = true,
TwoFactorEnabled = false,
LockoutEnabled = false,
AccessFailedCount = 1
};
//pass
await _UserManager.CreateAsync(korisnik, "test");
await _UserManager.CreateAsync(korisnik2, "test");
await _UserManager.CreateAsync(korisnik3, "test");
context.SaveChanges();
//uposlenici i kandidati
var uposlenik = new Uposlenik {
DatumRodjenja = GenerisiDatum(),
ImePrezime = "Uposlenik",
JMBG = "0000234234234",
Korisnik = korisnik,
Email = "*****@*****.**"
};
var kandidat = new Kandidat {
DatumRodjenja = GenerisiDatum(),
ImePrezime = "Kandidat", Email = "*****@*****.**", Korisnik = korisnik2, JMBG = "234234234", Status = true
};
var kandidat2 = new Kandidat
{
DatumRodjenja = GenerisiDatum(),
ImePrezime = "Kandidat2",
Email = "*****@*****.**",
Korisnik = korisnik3,
JMBG = "232222234234",
Status = true
};
var tipReferent = new TipUposlenika()
{
Naizv = "Referent"
};
var tipInstruktor = new TipUposlenika()
{
Naizv = "Instruktor"
};
var tipKandidat = new TipUposlenika()
{
Naizv = "Kandidat"
};
var tip1referent = context.TipUposlenika.Add(tipReferent);
var tipKandidatr = context.TipUposlenika.Add(tipKandidat);
var tipInstuktor = context.TipUposlenika.Add(tipInstruktor);
context.SaveChanges();
//referenti
context.uposlenikTipUposlenika.Add(new UposlenikTipUposlenika()
{
Uposlenik = uposlenik,
TipUposlenika = tipReferent
});
context.SaveChanges();
//Ljekarsko
if (context.LjekarskoUvjerenje.ToList().Count() > 0)
{
return;
}
var lj1 = context.LjekarskoUvjerenje.Add(
new LjekarskoUvjerenje {
DatumVazenja = GenerisiDatum(), DatumIzdavanje = GenerisiDatum(), KandidatId = kandidat.Id, SposobanZaObuku = true, Opis = "Sposoban"
}
);
var lj2 = context.LjekarskoUvjerenje.Add(
new LjekarskoUvjerenje {
DatumVazenja = GenerisiDatum(), DatumIzdavanje = GenerisiDatum(), KandidatId = kandidat2.Id, SposobanZaObuku = true, Opis = "Sposoban"
}
);
context.SaveChanges();
//potvrde
if (context.Potvrde.ToList().Count() > 0)
{
return;
}
context.Potvrde.Add(
new Potvrda {
DatumPolaganja = DateTime.Now, KandidatId = kandidat.Id, KategorijaId = 2, BrojBodova = 34
}
);
context.Potvrde.Add(
new Potvrda {
DatumPolaganja = DateTime.Now, KandidatId = kandidat2.Id, KategorijaId = 2, BrojBodova = 63
}
);
context.SaveChanges();
//raspored casova
if (context.RasporedCasova.ToList().Count() > 0)
{
return;
}
var rc1 = context.RasporedCasova.Add(
new RasporedCasova {
KandidatId = kandidat.Id
}
);
var rc2 = context.RasporedCasova.Add(
new RasporedCasova {
KandidatId = kandidat2.Id
}
);
context.SaveChanges();
var path = Path.Combine(Directory.GetCurrentDirectory(), "images", "car.png");
var slika = File.ReadAllText(path);
var vozilo = new Vozilo {
KategorijaId = context.Kategorije.FirstOrDefault().Id, Marka = "VW", Model = "Golf", PhotoPath = slika, RegistarskaOznaka = "234-K-423"
};
context.SaveChanges();
//termin rasporeda casova
if (context.TerminRasporedaCasova.ToList().Count() > 0)
{
return;
}
context.TerminRasporedaCasova.AddRange(
//kandidat
new TerminRasporedaCasova
{
RasporedCasovaId = rc1.Entity.Id,
TerminOd = "12"
,
TerminDo = "13"
,
Datum = DateTime.Today,
VoziloId = vozilo.Id,
UposlenikId = uposlenik.Id
});
context.SaveChanges();
//Uplate
if (context.Uplate.ToList().Count() > 0)
{
return;
}
context.Uplate.AddRange(
new Uplata {
DatumUplate = DateTime.Now, KandidatId = kandidat.Id, Iznos = 450, Svrha = "Rata"
},
new Uplata {
DatumUplate = GenerisiDatum(), KandidatId = kandidat.Id, Iznos = 450, Svrha = "Rata"
},
new Uplata {
DatumUplate = GenerisiDatum(), KandidatId = kandidat.Id, Iznos = 450, Svrha = "Rata"
},
new Uplata {
DatumUplate = GenerisiDatum(), KandidatId = kandidat.Id, Iznos = 30, Svrha = "Rata"
},
new Uplata {
DatumUplate = GenerisiDatum(), KandidatId = kandidat.Id, Iznos = 360, Svrha = "Rata"
}
);
context.SaveChanges();
//Zahtjevi
if (context.Zahtjev.ToList().Count() > 0)
{
return;
}
context.Zahtjev.AddRange(
new Zahtjev {
DatumPodnosenjaZahtjeva = GenerisiDatum(), LjekarskoUvjerenjeId = lj1.Entity.Id, UslugaId = 1, Procitano = false, Odbacen = false
},
new Zahtjev {
DatumPodnosenjaZahtjeva = GenerisiDatum(), LjekarskoUvjerenjeId = lj1.Entity.Id, UslugaId = 1, Procitano = false, Odbacen = false
},
new Zahtjev {
DatumPodnosenjaZahtjeva = GenerisiDatum(), LjekarskoUvjerenjeId = lj2.Entity.Id, UslugaId = 1, Procitano = false, Odbacen = false
}
);
context.SaveChanges();
}
public void Login(Kandidat kandidat)
{
IsLoggedInKandidat = true;
KandidatId = kandidat.Id;
}
public void Add(Kandidat kandidat)
{
context.Kandidati.Add(kandidat);
context.SaveChanges();
}
public void obrisiKandidata(Object o)
{
Kandidat x = null;
for (int i = 0; i < Sistem.KandidatiD.Count; i++)
{
if (Sistem.KandidatiD[i].JMBG1 == NoviKandidat.JMBG1)
{
x = Sistem.KandidatiD[i];
Sistem.KandidatiD.RemoveAt(i);
break;
}
}
for (int i = 0; i < Sistem.KandidatiE.Count; i++)
{
if (Sistem.KandidatiE[i].JMBG1 == NoviKandidat.JMBG1)
{
x = Sistem.KandidatiD[i];
Sistem.KandidatiE.RemoveAt(i);
break;
}
}
for (int i = 0; i < Sistem.KandidatiK.Count; i++)
{
if (Sistem.KandidatiK[i].JMBG1 == NoviKandidat.JMBG1)
{
x = Sistem.KandidatiD[i];
Sistem.KandidatiK.RemoveAt(i);
break;
}
}
for (int i = 0; i < Sistem.KandidatiO.Count; i++)
{
if (Sistem.KandidatiO[i].JMBG1 == NoviKandidat.JMBG1)
{
x = Sistem.KandidatiD[i];
Sistem.KandidatiO.RemoveAt(i);
break;
}
}
for (int i = 0; i < ListaKandidata.Count; i++)
{
if (ListaKandidata[i].JMBG1 == NoviKandidat.JMBG1)
{
x = Sistem.KandidatiD[i];
ListaKandidata.RemoveAt(i);
break;
}
}
if (x != null)
{
using (var db = new KandidateDBContext())
{
db.Kandidati.Remove(x);
db.SaveChanges();
}
}
}
