public domain.TehnologijaCollection GetByOblastId(int a) { model.LearnByPracticeDataContext context = CreateContext(); DataLoadOptions options = new DataLoadOptions(); options.LoadWith <model.Tehnologija>(tehnologija => tehnologija.Oblast); context.LoadOptions = options; var tehnologii = from t in context.Tehnologijas where t.Oblast_ID == a select t; domain.TehnologijaCollection result = new domain.TehnologijaCollection(); foreach (model.Tehnologija teh in tehnologii) { domain.Tehnologija domainObject = new domain.Tehnologija(); domainObject.Id = teh.ID; domainObject.Ime = teh.Ime; domainObject.oblast.Id = teh.Oblast_ID; if (teh.Oblast != null) { domainObject.oblast.Id = teh.Oblast.ID; domainObject.oblast.Ime = teh.Oblast.Ime; } result.Add(domainObject); } return(result); }
public domain.Korisnik Update(domain.Korisnik domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Korisnik> query = context.Korisniks.Where(p => p.ID == domainObject.Id); model.Korisnik modelObject = query.Single(); modelObject.Korisnichko_Ime = domainObject.Username; modelObject.Lozinka = domainObject.PasswordOdNiza; modelObject.Ime = domainObject.Ime; modelObject.Prezime = domainObject.Prezime; modelObject.Pol = ToModel(domainObject.Pol); modelObject.Organizacija_ID = domainObject.organizacija.Id; modelObject.Email = domainObject.Email; modelObject.Telefonski_Broj = domainObject.Mobilen; modelObject.Mentor = domainObject.Mentor; modelObject.Student = domainObject.Student; if (modelObject.Student == true) { modelObject.Studiska_Programa_ID = domainObject.studiskaPrograma.Id; } else { modelObject.Studiska_Programa_ID = null; } modelObject.Administrator = domainObject.Administrator; context.SubmitChanges(); domain.Korisnik result = ToDomain(modelObject); return(result); } }
public domain.OrganizacijaCollection GetByVidOrganizacijaId(int a) { model.LearnByPracticeDataContext context = CreateContext(); DataLoadOptions options = new DataLoadOptions(); options.LoadWith <model.Organizacija>(organizacija => organizacija.Vid_Organizacija); context.LoadOptions = options; var organizacii = from vO in context.Organizacijas where vO.Vid_Organizacija_ID == a select vO; domain.OrganizacijaCollection result = new domain.OrganizacijaCollection(); foreach (model.Organizacija vidOrg in organizacii) { domain.Organizacija domainObject = new domain.Organizacija(); domainObject.Id = vidOrg.ID; domainObject.Ime = vidOrg.Ime; domainObject.KontaktTelefon = vidOrg.Kontakt_Telefon; domainObject.VebStrana = vidOrg.Veb_Strana; domainObject.Adresa = vidOrg.Adresa; domainObject.vidOrganizacija.Id = vidOrg.Vid_Organizacija_ID; if (vidOrg.Vid_Organizacija != null) { domainObject.vidOrganizacija.Id = vidOrg.Vid_Organizacija.ID; domainObject.vidOrganizacija.Ime = vidOrg.Vid_Organizacija.Ime; } result.Add(domainObject); } return(result); }
public domain.TehnologijaCollection GetAll() { model.LearnByPracticeDataContext context = CreateContext(); DataLoadOptions options = new DataLoadOptions(); options.LoadWith <model.Tehnologija>(tehnologija => tehnologija.Oblast); context.LoadOptions = options; IQueryable <model.Tehnologija> query = context.Tehnologijas; domain.TehnologijaCollection result = new domain.TehnologijaCollection(); foreach (model.Tehnologija modelObject in query) { domain.Tehnologija domainObject = new domain.Tehnologija(); domainObject.Id = modelObject.ID; domainObject.Ime = modelObject.Ime; domainObject.oblast.Id = modelObject.Oblast_ID; if (modelObject.Oblast != null) { domainObject.oblast.Id = modelObject.Oblast.ID; domainObject.oblast.Ime = modelObject.Oblast.Ime; } result.Add(domainObject); } return(result); }
public domain.KorisnikCollection GetAll() { model.LearnByPracticeDataContext context = CreateContext(); IQueryable <model.Korisnik> query = context.Korisniks; domain.KorisnikCollection result = ToDomainObjects(query); return(result); }
public domain.PrijavaStudentCollection GetByKorisnikId(int KorisnikId) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Prijava_Korisnik> query = context.Prijava_Korisniks.Where(c => c.Korisnik_ID == KorisnikId); domain.PrijavaStudentCollection domainObjects = ToDomainObjects(query.ToList()); return(domainObjects); } }
public domain.KorisnikCollection GetByStudiskaProgramaId(int StudiskaProgramaId) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Korisnik> query = context.Korisniks.Where(c => c.Studiska_Programa_ID == StudiskaProgramaId); domain.KorisnikCollection domainObjects = ToDomainObjects(query.ToList()); return(domainObjects); } }
public domain.OcenaCollection GetByPredmetId(int PredmetId) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Ocenka> query = context.Ocenkas.Where(c => c.Predmet_ID == PredmetId); domain.OcenaCollection domainObjects = ToDomainObjects(query.ToList()); return(domainObjects); } }
public domain.VidOrganizacija Get(int id) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Vid_Organizacija> query = context.Vid_Organizacijas.Where(c => c.ID == id); domain.VidOrganizacija domainObject = ToDomain(query.Single()); return(domainObject); } }
public domain.Korisnik Get(int id) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Korisnik> query = context.Korisniks.Where(c => c.ID == id); domain.Korisnik domainObject = ToDomain(query.Single()); return(domainObject); } }
public domain.StudiskaPrograma Get(int id) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Studiska_Programa> query = context.Studiska_Programas.Where(c => c.ID == id); domain.StudiskaPrograma domainObject = ToDomain(query.Single()); return(domainObject); } }
public domain.PrijavaTehnologijaCollection GetByTehnologijaId(int TehId) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Prijava_Tehnologija> query = context.Prijava_Tehnologijas.Where(c => c.Tehnologija_ID == TehId); domain.PrijavaTehnologijaCollection domainObjects = ToDomainObjects(query.ToList()); return(domainObjects); } }
public domain.VidOrganizacija Update(domain.VidOrganizacija domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Vid_Organizacija> query = context.Vid_Organizacijas.Where(p => p.ID == domainObject.Id); model.Vid_Organizacija modelObject = query.Single(); modelObject.Ime = domainObject.Ime; context.SubmitChanges(); domain.VidOrganizacija result = ToDomain(modelObject); return(result); } }
public domain.VidOrganizacija Insert(domain.VidOrganizacija domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { model.Vid_Organizacija modelObject = new model.Vid_Organizacija(); modelObject.Ime = domainObject.Ime; context.Vid_Organizacijas.InsertOnSubmit(modelObject); context.SubmitChanges(); domain.VidOrganizacija result = ToDomain(modelObject); return(result); } }
public domain.Ocena Update(domain.Ocena domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Ocenka> query = context.Ocenkas.Where(p => p.Korisnik_ID == domainObject.student.Id && p.Predmet_ID == domainObject.predmet.Id); model.Ocenka modelObject = query.Single(); modelObject.Ocenka1 = domainObject.Ocenka; context.SubmitChanges(); domain.Ocena result = ToDomain(modelObject); return(result); } }
public domain.StudiskaPrograma Update(domain.StudiskaPrograma domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Studiska_Programa> query = context.Studiska_Programas.Where(p => p.ID == domainObject.Id); model.Studiska_Programa modelObject = query.Single(); modelObject.Ime = domainObject.Ime; context.SubmitChanges(); domain.StudiskaPrograma result = ToDomain(modelObject); return(result); } }
public domain.Prijava Update(domain.Prijava domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Prijava> query = context.Prijavas.Where(p => p.ID == domainObject.Id); model.Prijava modelObject = query.Single(); modelObject.Organizacija_ID = domainObject.organizacija.Id; context.SubmitChanges(); domain.Prijava result = ToDomain(modelObject); return(result); } }
public domain.Oblast Update(domain.Oblast domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Oblast> query = context.Oblasts.Where(p => p.ID == domainObject.Id); model.Oblast modelObject = query.Single(); modelObject.Ime = domainObject.Ime; context.SubmitChanges(); domain.Oblast result = ToDomain(modelObject); return(result); } }
public domain.StudiskaPrograma Insert(domain.StudiskaPrograma domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { model.Studiska_Programa modelObject = new model.Studiska_Programa(); modelObject.Ime = domainObject.Ime; context.Studiska_Programas.InsertOnSubmit(modelObject); context.SubmitChanges(); domain.StudiskaPrograma result = ToDomain(modelObject); return(result); } }
public domain.PrijavaTehnologija Update(domain.PrijavaTehnologija domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Prijava_Tehnologija> query = context.Prijava_Tehnologijas.Where(p => p.Prijava_ID == domainObject.prijava.Id); model.Prijava_Tehnologija modelObject = query.Single(); modelObject.Tehnologija_ID = domainObject.tehnologija.Id; modelObject.Prijava_ID = domainObject.prijava.Id; context.SubmitChanges(); domain.PrijavaTehnologija result = ToDomain(modelObject); return(result); } }
public domain.Predmet Update(domain.Predmet domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Predmet> query = context.Predmets.Where(p => p.ID == domainObject.Id); model.Predmet modelObject = query.Single(); modelObject.Shifra_Na_Predmet = domainObject.ShifraNaPredmet; modelObject.Ime = domainObject.Ime; context.SubmitChanges(); domain.Predmet result = ToDomain(modelObject); return(result); } }
public domain.PrijavaStudent Update(domain.PrijavaStudent domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { IQueryable <model.Prijava_Korisnik> query = context.Prijava_Korisniks.Where(p => p.Korisnik_ID == domainObject.student.Id); model.Prijava_Korisnik modelObject = query.Single(); modelObject.Korisnik_ID = domainObject.student.Id; modelObject.Prijava_ID = domainObject.prijava.Id; context.SubmitChanges(); domain.PrijavaStudent result = ToDomain(modelObject); return(result); } }
public domain.Oblast Insert(domain.Oblast domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { model.Oblast modelObject = new model.Oblast(); modelObject.Ime = domainObject.Ime; context.Oblasts.InsertOnSubmit(modelObject); context.SubmitChanges(); domain.Oblast result = ToDomain(modelObject); return(result); } }
public domain.PrijavaTehnologija Insert(domain.PrijavaTehnologija domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { model.Prijava_Tehnologija modelObject = new model.Prijava_Tehnologija(); modelObject.Tehnologija_ID = domainObject.tehnologija.Id; modelObject.Prijava_ID = domainObject.prijava.Id; context.Prijava_Tehnologijas.InsertOnSubmit(modelObject); context.SubmitChanges(); domain.PrijavaTehnologija result = ToDomain(modelObject); return(result); } }
public domain.Predmet Insert(domain.Predmet domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { model.Predmet modelObject = new model.Predmet(); modelObject.Shifra_Na_Predmet = domainObject.ShifraNaPredmet; modelObject.Ime = domainObject.Ime; context.Predmets.InsertOnSubmit(modelObject); context.SubmitChanges(); domain.Predmet result = ToDomain(modelObject); return(result); } }
public domain.PrijavaStudent Insert(domain.PrijavaStudent domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { model.Prijava_Korisnik modelObject = new model.Prijava_Korisnik(); modelObject.Prijava_ID = domainObject.prijava.Id; modelObject.Korisnik_ID = domainObject.student.Id; context.Prijava_Korisniks.InsertOnSubmit(modelObject); context.SubmitChanges(); domain.PrijavaStudent result = ToDomain(modelObject); return(result); } }
public domain.Prijava Insert(domain.Prijava domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { model.Prijava modelObject = new model.Prijava(); modelObject.Organizacija_ID = domainObject.organizacija.Id; modelObject.Datum_Na_Prijavuvanje = domainObject.Datum; context.Prijavas.InsertOnSubmit(modelObject); context.SubmitChanges(); domain.Prijava result = ToDomain(modelObject); return(result); } }
public domain.Tehnologija Insert(domain.Tehnologija domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { model.Tehnologija modelObject = new model.Tehnologija(); modelObject.Ime = domainObject.Ime; modelObject.Oblast_ID = domainObject.oblast.Id; context.Tehnologijas.InsertOnSubmit(modelObject); context.SubmitChanges(); domain.Tehnologija result = ToDomain(modelObject); return(result); } }
public domain.Organizacija Get(int id) { using (model.LearnByPracticeDataContext context = CreateContext()) { DataLoadOptions options = new DataLoadOptions(); options.LoadWith <model.Organizacija>(organizacija => organizacija.Vid_Organizacija); context.LoadOptions = options; IQueryable <model.Organizacija> query = context.Organizacijas.Where(c => c.ID == id); domain.Organizacija domainObject = ToDomain(query.Single()); return(domainObject); } }
public domain.Ocena Insert(domain.Ocena domainObject) { using (model.LearnByPracticeDataContext context = CreateContext()) { model.Ocenka modelObject = new model.Ocenka(); modelObject.Korisnik_ID = domainObject.student.Id; modelObject.Predmet_ID = domainObject.predmet.Id; modelObject.Ocenka1 = domainObject.Ocenka; context.Ocenkas.InsertOnSubmit(modelObject); context.SubmitChanges(); domain.Ocena result = ToDomain(modelObject); return(result); } }