public void Insert(Instruktor instruktor)
{
instruktori.Find(p => p.Id == instruktor.Id).ImePrezime = instruktor.ImePrezime;
instruktori.Find(p => p.Id == instruktor.Id).Cin = instruktor.Cin;
instruktori.Find(p => p.Id == instruktor.Id).Obuka = instruktor.Obuka;
instruktori.Find(p => p.Id == instruktor.Id).ObukaId = instruktor.Obuka.Id;
}
public async Task <IActionResult> Edit(EditInstruktorViewModel instruktor)
{
if (ModelState.IsValid)
{
string id = instruktor.Id;
Instruktor instruktorIzBaze = await userManager.FindByIdAsync(id) as Instruktor;
if (instruktorIzBaze == null)
{
return(NotFound());
}
instruktorIzBaze.Cin = instruktor.Cin;
instruktorIzBaze.ImePrezime = instruktor.ImePrezime;
instruktorIzBaze.Obuka = instruktor.Obuka;
instruktorIzBaze.ObukaId = instruktor.ObukaId;
var result = await userManager.UpdateAsync(instruktorIzBaze);
if (result.Succeeded)
{
return(RedirectToAction("Index", "Home", new { message = $"Izmene profila uspešno sačuvane" }));
}
foreach (var error in result.Errors)
{
ModelState.AddModelError("", error.Description);
}
}
return(View(instruktor));
}
public async Task <IActionResult> Edit(string id)
{
if (id == userManager.GetUserId(User))
{
ApplicationUser user = await userManager.FindByIdAsync(id);
Instruktor instruktor = user as Instruktor;
if (user == null)
{
return(View("PageNotFound"));
}
ObukeDropDownList(instruktor.ObukaId);
CinoviDropDownList(instruktor.Cin);
var model = new EditInstruktorViewModel()
{
Id = instruktor.Id,
UserName = instruktor.UserName,
Cin = instruktor.Cin,
ImePrezime = instruktor.ImePrezime,
Obuka = instruktor.Obuka,
ObukaId = instruktor.ObukaId,
Email = instruktor.Email
};
return(View(model));
}
else
{
return(View("AccessDenied"));
}
}
public InstruktorVM(NavigationService _navigationService, object _arg)
{
navigationService = _navigationService;
Logout = new RelayCommand(izvrsiLogout);
Termini = new RelayCommand(prikaziTermine);
MojQRKod = new RelayCommand(PrikaziQRKod);
lista = new List <string>();
using (var dbCon = new TutorFinderDbContext())
{
foreach (var instruktor in dbCon.Instruktori)
{
if (instruktor.Ime == (((Instruktor)_arg).Ime) && instruktor.Prezime == (((Instruktor)_arg).Prezime))
{
foreach (var termin in dbCon.Termini)
{
if (termin.InstruktorId == instruktor.InstruktorId)
{
lista.Add("Predmet: " + termin.Predmet + ", vrijeme: " + termin.VrijemeOdrzavanja.Date + " " + termin.VrijemeOdrzavanja.TimeOfDay);
}
inst = instruktor;
}
OnPropertyChanged("lista");
break;
}
}
}
}
static void Main(string[] args)
{
//Database.SetInitializer(new DropCreateDatabaseIfModelChanges<DataBaseContext>());
DataBaseContext db = new DataBaseContext();
//db.Database.Delete();
//db.Database.Create();
Database.SetInitializer <DataBaseContext>(null);
Konekcija konekcija = new Konekcija();
using (var db1 = new DataBaseContext())
{
if (!db1.AutoSkolaBaza.Any())
{
// The table is empty
Console.WriteLine("Baza je prazna");
AutoSkola a = new AutoSkola();
a.naziv = "Pocetna";
a.MBR = "prviMBR";
a.PIB = "prviPIB";
db1.AutoSkolaBaza.Add(a);
db1.SaveChanges();
}
//else
//{
// Console.WriteLine("Baza auto skole je popunjena");
//}
if (!db1.Dozvole.Any())
{
Dozvola d = new Dozvola();
AutoSkola a = new AutoSkola();
IEnumerable <AutoSkola> lista = db1.AutoSkolaBaza.ToList();
a = lista.First();
d.IDSkole = a.IDSkole;
d.nazivDozvole = "auto dozvola";
db1.Dozvole.Add(d);
db1.SaveChanges();
}
if (!db1.Instruktori.Any())
{
Instruktor i = new Instruktor();
AutoSkola a = new AutoSkola();
a = db1.AutoSkolaBaza.First();
i.IDSK = a.IDSkole;
i.ime = "Pocetnik";
i.obrazovanje = Enums.VrstaObrazovanja.OSNOVNO;
i.prezime = "Pripravnik";
db1.Instruktori.Add(i);
db1.SaveChanges();
}
}
konekcija.Otvori();
Console.ReadLine();
}
public override object Izvrsi(OpstiDomenskiObjekat odo)
{
Instruktor i = new Instruktor();
i.USLOVI = " Ime is null";
Sesija.Broker.dajSesiju().deleteVise(i);
return(Sesija.Broker.dajSesiju().vratiSve(odo).OfType <Instruktor>().ToList <Instruktor>());
}
public IActionResult ObrisiInstruktora(string Idinstruktora)//vodi racuna kako se zove parametar ako se prebaci negde
{
Dictionary <string, object> queryDict = new Dictionary <string, object>();
queryDict.Add("idInstruktora", Idinstruktora);
var query = new Neo4jClient.Cypher.CypherQuery(" match (n:instruktor {idInstruktora: '" + Idinstruktora + "'}) detach delete n",
queryDict, CypherResultMode.Projection);
//
Instruktor skol = ((IRawGraphClient)client).ExecuteGetCypherResults <Instruktor>(query).FirstOrDefault();
return(RedirectToAction("idiNaobrisiInstruktorStranicu"));
}
private async Task PasDropDownListAsync(object izabranPas = null)
{
Instruktor user = null;
if (!User.IsInRole("Admin"))
{
user = await userManager.FindByIdAsync(userManager.GetUserId(User)) as Instruktor;
var pasQueryObuka = from p in servicePsi.GetAll().AsQueryable().Where(p => p.ObukaId == user.ObukaId) select p;
ViewBag.PasId = new SelectList(pasQueryObuka.AsNoTracking(), "Id", "Ime", izabranPas);
}
else
{
if (User.IsInRole("Admin"))
{
var pasQuery = from p in servicePsi.GetAll().AsQueryable() select p;
ViewBag.PasId = new SelectList(pasQuery.AsNoTracking(), "Id", "Ime", izabranPas);
}
}
}
public ProzorIzmeneInstruktoraViewModel()
{
IzmeniInstruktora = new IzmeniInstruktora(this);
ChangeRa = new Instruktor();
}
//pri izmeni izlistati sta je do sada ocenjeno, razmisliti kako to moze da se uradi
public async Task <IActionResult> Update(int id)
{
// koji psi su angazovani na angazovanju cije ocene unosimo
ViewBag.Zadaci = serviceZadaci.GetAll().ToList();
ViewBag.Zadatak = serviceZadaci.FindById(id).NazivZadatka;
ViewBag.Id = serviceZadaci.FindById(id).Id;
List <Angazovanje> angazovanjaZaOcenu = service.GetAll().Where(a => a.ZadatakId == id).ToList();
List <Pas> angazovaniPsi = new List <Pas>();
List <Angazovanje> ocenjenaAngazovanja = new List <Angazovanje>();
Instruktor user = null;
if (!User.IsInRole("Admin"))
{
user = await userManager.FindByIdAsync(userManager.GetUserId(User)) as Instruktor;
foreach (Angazovanje angazovanje in angazovanjaZaOcenu)
{
if (angazovanje.Pas.ObukaId == user.ObukaId)
{
if (angazovanje.Ocena == null)
{
angazovaniPsi.Add(angazovanje.Pas);
}
else
{
ocenjenaAngazovanja.Add(angazovanje);
}
}
}
}
else
{
if (User.IsInRole("Admin"))
{
foreach (Angazovanje angazovanje in angazovanjaZaOcenu)
{
if (angazovanje.Ocena == null)
{
angazovaniPsi.Add(angazovanje.Pas);
}
else
{
ocenjenaAngazovanja.Add(angazovanje);
}
}
}
}
if (!User.IsInRole("Admin"))
{
if (angazovaniPsi.Count() == 0)
{
return(RedirectToAction("PageNotFound", "Home", new { message = "Nijedan pas sa vaše obuke nije angažovan na ovom zadatku!" }));
}
}
if (ocenjenaAngazovanja != null)
{
ViewBag.Ocenjena = ocenjenaAngazovanja;
}
ViewBag.Psi = angazovaniPsi;
ViewBag.BrojAngazovanja = angazovaniPsi.Count();
ZadatakDropDownList();
Angazovanje a = new Angazovanje()
{
ZadatakId = serviceZadaci.FindById(id).Id,
Zadatak = serviceZadaci.FindById(id),
DatumUnosaOcene = DateTime.Now,
};
return(View(a));
}
public void Update(Instruktor instruktorIzBaze)
{
throw new NotImplementedException();
}
public static void Save(string FirstName, string SecondName, string InstructorID, PictureBox picture)
{
using (LinqtoSQLDataContext db = new LinqtoSQLDataContext())
{
if (db.Instruktor.Any(x => x.InstructorID == InstructorID))
{
var Instructor = from Instruktor in db.Instruktor
where Instruktor.InstructorID == InstructorID
select Instruktor;
foreach (Instruktor instructor in Instructor)
{
instructor.First_Name = FirstName;
instructor.Second_Name = SecondName;
instructor.InstructorID = InstructorID;
}
}
else
{
Guid ID = System.Guid.NewGuid();
Instruktor newInstruktor = new Instruktor {Visible = true, First_Name = FirstName, Second_Name = SecondName, InstructorID = InstructorID, ID = ID };
db.Instruktor.InsertOnSubmit(newInstruktor);
}
LINQConnections.Save(db);
}
}
public async Task <IActionResult> Register(RegistrationViewModel model)
{
if (ModelState.IsValid)
{
var user = new Instruktor
{
Email = model.Email,
ImePrezime = model.ImePrezime,
Cin = model.Cin,
UserName = model.Username,
ObukaId = model.ObukaId
};
ObukeDropDownList(model.ObukaId);
CinoviDropDownList(model.Cin);
var result = await userManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
/*
* sve radi ok
*
* var token = await userManager.GenerateEmailConfirmationTokenAsync(user);
* var confirmationLink = Url.Action("ConfirmEmail", "Account",
* new { userId = user.Id, token = token }, Request.Scheme);
*
* MailMessage mailMessage = new MailMessage();
* mailMessage.From = new MailAddress(configuration["Email:Email"]);
* //user.Email
* mailMessage.To.Add("*****@*****.**");
* mailMessage.Body = $"Kliknite na link kako biste aktivirali nalog {confirmationLink}";
* mailMessage.Subject = "Confirmation link";
* SmtpClient client = new SmtpClient("smtp-mail.outlook.com");
* client.Port = 587;
* client.UseDefaultCredentials = false;
* client.EnableSsl = true;
* var credential = new NetworkCredential
* {
* UserName = configuration["Email:Email"],
* Password = configuration["Email:Password"]
* };
* client.Credentials = credential;
* client.Send(mailMessage);
* logger.Log(LogLevel.Warning, confirmationLink);
* return RedirectToAction("GetAllUsers", new { message = $"Link za verifikaciju naloga korisnika {user.UserName} je poslat na email adresu {user.Email}" });
*/
try
{
var resultRole = await userManager.AddToRoleAsync(user, "Instruktor");
if (!resultRole.Succeeded)
{
ModelState.AddModelError("", "Neuspešno dodavanje uloga korisniku");
return(View(model));
}
return(RedirectToAction("GetAllUsers", new { message = $"Registracija uspešno izvršena." }));
}catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
foreach (var error in result.Errors)
{
ModelState.AddModelError(string.Empty, error.Description);
}
}
CinoviDropDownList();
ObukeDropDownList();
return(View(model));
}
public void Update(Instruktor instruktorIzBaze)
{
unitOfWork.InstruktorRepository.Update(instruktorIzBaze);
unitOfWork.Save();
}
