private void CallWebService(string startDate, string endDate) { try { Kurs kurs = new Kurs(); string result = kurs.GetExchangeRates(startDate, endDate); ParseResponse(result); } catch { displayErrorMessage(errorConnecting); } }
public static String CallWebService(string startDate, string endDate) { string result; try { Kurs kurs = new Kurs(); string response = kurs.GetExchangeRates(startDate, endDate); result = ParseResponse(response); } catch { result = System.Web.Configuration.WebConfigurationManager.AppSettings["errorConnecting"]; logger.Error(result); } return result; }
public static bool insertInvoice_Product(APCEntities APCContext, Invoice invoice, Category category, string description, int quantity, string unit, decimal price, Kurs kurs, decimal serviceCharge, decimal totalPrice, bool subcon) { Invoice_Product invoice_product = new Invoice_Product(); invoice_product.Invoice = invoice; invoice_product.Category = category; invoice_product.Description = description; invoice_product.Quantity = quantity; invoice_product.Unit = unit; invoice_product.Price = price; invoice_product.Kurs = kurs; invoice_product.ServiceCharge = serviceCharge; invoice_product.PriceTotal = totalPrice; invoice_product.SubCon = subcon; APCContext.AddToInvoice_Product(invoice_product); APCContext.SaveChanges(); return true; }
public IActionResult SnimiIzmjene(int TestID, int KursID, int Trajanje, int BrojPitanja, int MaxBrBodova) { Testovi t = db.Testovi.Find(TestID); Kurs k = db.Kurs.Find(KursID); t.KursId_FK = KursID; t.Maksimalan_Broj_Bodova = MaxBrBodova; t.Trajanje = Trajanje; t.Broj_Pitanja = BrojPitanja; t.KursId = k; try { db.Testovi.Update(t); db.SaveChanges(); } catch (Exception) { return(Redirect("/Testovi/Testovi")); } return(Redirect("/Testovi/Testovi")); }
private void button7_Click(object sender, EventArgs e) { try { ISession s = DataLayer.GetSession(); Kurs k = s.Load <Kurs>(2); MessageBox.Show((k.Policajac.Ime).ToString()); MessageBox.Show((k.DatumZavrsetka).ToString()); s.Close(); } catch (Exception exception) { MessageBox.Show(exception.Message); Console.WriteLine(exception); throw; } }
public void Delete(Kurs k) { if (k.Lekcije != null) { foreach (Lekcija l in k.Lekcije.ToList()) { k.Lekcije.Remove(l);; //obrisi sve lekcije vezane za taj kurs } } List <Test> testovi = context.Testovi.Where(t => t.KursId == k.KursId).ToList();//svi testovi if (testovi.Count > 0) { foreach (Test t in testovi.ToList()) { testovi.Remove(t); } } //sad bi trebalo da radi xd context.Kursevi.Remove(k); }
public string ImportCourse(Kurs k) { string msg; if (!k.IsValid) { msg = string.Format("Kurs {0} ist nicht konsistent und wird nicht importiert.", k.Id); return(msg); } if (k.Fach == null) { msg = string.Format("Kurs ohne Fach. Id={0}, wird nicht importiert.", k.Id); return(msg); } ImportKurs(k); msg = string.Format("Kurs {0} mit Terminen importiert", k.Fach.FachID); return(msg); }
public static void Brisanje(Kurs k) { using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"update kurs set id=@id,sts=@sts where id=@id"; cmd.Parameters.Add(new SqlParameter("@id", k.Id)); cmd.Parameters.Add(new SqlParameter("@sts", k.Status)); try { cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "nece", MessageBoxButton.OK); } } }
public void kreirajKurs(string Ime, [FromUri] int[] niz) { using (var context = new PageBazaContext()) { Kurs kurs = new Kurs(); kurs.Nazivkursa = Ime; context.Add(kurs); context.SaveChanges(); var a = context.Kurs.Where(cur => cur.Nazivkursa == Ime).ToList(); int poslednjid = a[0].Kursid; for (int i = 0; i < niz.Length; i++) { Studentkurs stud = new Studentkurs(); stud.Kursid = poslednjid; stud.Studentid = niz[i]; context.Add(stud); context.SaveChanges(); } } }
public HttpResponseMessage UpdateKurs([FromBody] Kurs kurs) { using (var connection = new SqlConnection(ConnectionString)) { try { using (var sqlCmd = new SqlCommand("UPDATE Kurs.Kurs SET NazivKursa=@NazivKursa, BrStudenata=@BrStudenata, RasporedPredavanja=@RasporedPredavanja, StudijskiProgram=@StudijskiProgram, SkolskaGodina=@SkolskaGodina, TezinskiFaktorOcene=@TezinskiFaktorOcene, PolitikaUpisaOcena=@PolitikaUpisaOcena, PolitikaUpisaDepartman=@PolitikaUpisaDepartman, PolitikaUpisaFCFS=@PolitikaUpisaFCFS, MinimalanBrStudenata=@MinimalanBrStudenata, DefinicijaPreduslova=@DefinicijaPreduslova, KriterijumZaPolaganje=@KriterijumZaPolaganje, Pravilo=@Pravilo, PredmetID=@PredmetID WHERE KursID=@id")) { connection.Open(); sqlCmd.Connection = connection; sqlCmd.Parameters.AddWithValue("NazivKursa", kurs.NazivKursa); sqlCmd.Parameters.AddWithValue("BrStudenata", kurs.BrStudenata); sqlCmd.Parameters.AddWithValue("RasporedPredavanja", kurs.RasporedPredavanja); sqlCmd.Parameters.AddWithValue("StudijskiProgram", kurs.StudijskiProgram); sqlCmd.Parameters.AddWithValue("SkolskaGodina", kurs.SkolskaGodina); sqlCmd.Parameters.AddWithValue("TezinskiFaktorOcene", kurs.TezinskiFaktorOcene); sqlCmd.Parameters.AddWithValue("PolitikaUpisaOcena", kurs.PolitikaUpisaOcena); sqlCmd.Parameters.AddWithValue("PolitikaUpisaDepartman", kurs.PolitikaUpisaDepartman); sqlCmd.Parameters.AddWithValue("PolitikaUpisaFCFS", kurs.PolitikaUpisaFCFS); sqlCmd.Parameters.AddWithValue("MinimalanBrStudenata", kurs.MinimalanBrStudenata); sqlCmd.Parameters.AddWithValue("DefinicijaPreduslova", kurs.DefinicijaPreduslova); sqlCmd.Parameters.AddWithValue("KriterijumZaPolaganje", kurs.KriterijumZaPolaganje); sqlCmd.Parameters.AddWithValue("Pravilo", kurs.Pravilo); sqlCmd.Parameters.AddWithValue("PredmetID", kurs.PredmetID); sqlCmd.Parameters.AddWithValue("id", kurs.KursID); int rowAffected = sqlCmd.ExecuteNonQuery(); if (rowAffected == 0) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 BadRequest")); } } } catch (Exception) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 Bad Request")); } } return(Request.CreateResponse(HttpStatusCode.OK, "Updated Successfully")); }
public List <string> getKursyString() { kursy = new List <Kurs>(); List <string> kursy_str = File.ReadAllLines(filePath).ToList(); foreach (var r in kursy_str) { string[] enteries = r.Split(','); Kurs kurs = new Kurs(); kurs.id = int.Parse(enteries[0]); kurs.name = enteries[1]; List <string> students = new List <string>(); DAO_Student ds = new DAO_Student(); List <Student> dao_students = ds.getStudenci(); for (int i = 2; i < enteries.Length; i++) { for (int j = 0; j < dao_students.Count; j++) { if (int.Parse(enteries[i]) == dao_students[j].id) { students.Add(dao_students[j].id.ToString() + "," + dao_students[j].imie + "," + dao_students[j].nazwisko + "," + dao_students[j].indeks); } } } kurs.students = students; kursy.Add(kurs); } for (int i = 0; i < kursy_str.Count; i++) { string[] enteries = kursy_str[i].Split(','); string value = enteries[0] + "," + enteries[1]; kursy_str[i] = value; } return(kursy_str); }
public IActionResult UrediTest(int TestID) { Testovi t = db.Testovi.Find(TestID); Kurs k = db.Kurs.Find(t.KursId_FK); UrediTestVM vm = new UrediTestVM { KursID = t.KursId_FK, Kurs = k.Naziv, BrojPitanja = t.Broj_Pitanja, MaxBrBodova = t.Maksimalan_Broj_Bodova, Trajanje = t.Trajanje, TestID = TestID, kursevi = db.Kurs .Select(x => new SelectListItem { Value = x.KursID.ToString(), Text = k.Naziv }).ToList() }; return(View(vm)); }
public IHttpActionResult PostTest(ViewModel model) { var kurs = new Kurs { Currency = model.Currency, Rate = model.Rate }; var supplier = new Supplier { SupplierName = model.SupplierName }; using (var context = new ATokoDb()) { context.KursSG.Add(kurs); context.Suppliers.Add(supplier); context.SaveChanges(); } return(CreatedAtRoute("DefaultApi", new { id = kurs.KursID }, kurs)); }
public static void Delete(Kurs k) { using (SqlConnection conn = new SqlConnection(Aplikacija.CONN_STR)) { conn.Open(); Aplikacija.Instanca.Kursevi.Remove(k); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "update kursevi set obrisan=@obrisan where id=@id"; cmd.Parameters.Add(new SqlParameter("@id", k.Id)); cmd.Parameters.Add(new SqlParameter("@obrisan", 1)); try { cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "greska", MessageBoxButton.OK); } } }
private void btnPohadja_Click(object sender, EventArgs e) { if (txtIme.Text != "" && comboBox1.Text != "") { Korisnik korisnik = new Korisnik(); Kurs kurs = new Kurs(); korisnik.ime = txtIme.Text; kurs.id = comboBox1.Text; Dictionary <string, object> queryDict = new Dictionary <string, object>(); queryDict.Add("ime", korisnik.ime); queryDict.Add("id", kurs.id); var query = new Neo4jClient.Cypher.CypherQuery("MATCH (a:Korisnik), (b:Kurs) WHERE a.ime = {ime} and b.id = {id} CREATE (a) - [r:POHADJA] -> (b)", queryDict, CypherResultMode.Set); ((IRawGraphClient)client).ExecuteCypher(query); } txtIme.Text = ""; comboBox1.Text = ""; groupBox1.Text = ""; }
static void Main(string[] args) { Kurs Kurs1 = new Kurs(); Kurs1.KursAdi = "C# Dersi"; Kurs1.Egitmen = "Engin Demiroğ"; Kurs1.İzlenmeOrani = 68; Kurs Kurs2 = new Kurs(); Kurs2.KursAdi = "j# Dersi"; Kurs2.Egitmen = "kerem Variş"; Kurs2.İzlenmeOrani = 64; Kurs Kurs3 = new Kurs(); Kurs3.KursAdi = "F# Dersi"; Kurs3.Egitmen = "Berkan Bilgin"; Kurs3.İzlenmeOrani = 80; Kurs[] kurslar = new Kurs[] { Kurs1, Kurs2, Kurs3 }; }
public Kurs Add(Kurs kurs) { using (var tran = CurrentSession.BeginTransaction()) { try { if (kurs.KursID > 0) { throw new Exception(String.Format("A Kurs with Bid {0} already exists. To update please use PUT.", kurs.KursID)); } CurrentSession.Save(kurs); tran.Commit(); return(kurs); } catch (Exception ex) { tran.Rollback(); throw ex; } } }
public Kurs Update(Kurs kurs) { using (var tran = CurrentSession.BeginTransaction()) { try { if (kurs.KursID == 0) { throw new Exception("For creating a Kurs please use POST"); } CurrentSession.Update(kurs); tran.Commit(); return(kurs); } catch (Exception ex) { tran.Rollback(); throw ex; } } }
public static void UcenikUKurs(Kurs k, Ucenik n) { using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "insert into ucenikkurs values(@kid,@uid)"; cmd.Parameters.Add(new SqlParameter("@kid", k.Id)); cmd.Parameters.Add(new SqlParameter("@uid", n.Id)); try { cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "nece", MessageBoxButton.OK); } } }
public static void Update(Kurs k) { using (SqlConnection conn = new SqlConnection(Aplikacija.CONN_STR)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"Update Kurs Set JezikId=@jezikId, TipId=@tipId, NastavnikId=@nastavnikId, Cena=@cena Where Id=@id"; cmd.Parameters.Add(new SqlParameter("@jezikId", k.JezikKursa.Id)); cmd.Parameters.Add(new SqlParameter("@tipId", k.Tip.Id)); cmd.Parameters.Add(new SqlParameter("@nastavnikId", k.Predavac.Id)); cmd.Parameters.Add(new SqlParameter("@cena", k.Cena)); cmd.Parameters.Add(new SqlParameter("@id", k.Id)); SqlCommand cmdPohadja; cmdPohadja = conn.CreateCommand(); cmdPohadja.CommandText = "Delete Pohadja Where KursId = @kursId"; cmdPohadja.Parameters.Add(new SqlParameter("@kursID", k.Id)); try { cmd.ExecuteNonQuery(); cmdPohadja.ExecuteNonQuery(); foreach (Ucenik u in k.Ucenici) { cmdPohadja = conn.CreateCommand(); cmdPohadja.CommandText = "Insert Into Pohadja Values (@ucenikId, @kursId)"; cmdPohadja.Parameters.Add(new SqlParameter("@ucenikID", u.Id)); cmdPohadja.Parameters.Add(new SqlParameter("@kursID", k.Id)); cmdPohadja.ExecuteNonQuery(); } } catch (SqlException e) { MessageBox.Show(e.Message, "Greska", MessageBoxButton.OK); throw new Exception(); } } }
public static void UcenikIzKursa(Kurs k, Ucenik n) { using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"delete ucenikkurs where kid=@kid and uid=@uid"; cmd.Parameters.Add(new SqlParameter("@kid", k.Id)); cmd.Parameters.Add(new SqlParameter("@uid", n.Id)); try { cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "Greska", MessageBoxButton.OK); } } }
public static void Read() { using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from ucenikkurs"; SqlDataAdapter sqlDA = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sqlDA.Fill(ds, "jezici"); foreach (DataRow row in ds.Tables["jezici"].Rows) { Kurs k = Aplikacija.Instanca.GetKursById((int)row["kid"]); Ucenik u = Aplikacija.Instanca.GetUcenikById((int)row["uid"]); k.Ucenici.Add(u); u.Kursevi.Add(k); } } }
public void Before() { k1 = new Kurs() { Titel = "Cooler Kurs", Beschreibung = "Dies ist eine Kursbeschreibung", MaximaleTeilnehmeranzahl = 3, Veranstaltungszeit = new VeranstaltungszeitTyp(DateTime.Today.AddHours(13), DateTime.Today.AddHours(14)), Kursstatus = Kursstatus.Geplant }; k2 = new Kurs() { Titel = "Anderer cooler Kurs", Beschreibung = "Dies ist eine Kursbeschreibung", MaximaleTeilnehmeranzahl = 1, Veranstaltungszeit = new VeranstaltungszeitTyp(DateTime.Today.AddHours(13), DateTime.Today.AddHours(14)), Kursstatus = Kursstatus.Geplant }; }
public static void Read() { using (SqlConnection conn = new SqlConnection(Aplikacija.CONN_STR)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from kursevi where obrisan = 0"; SqlDataAdapter sqlda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sqlda.Fill(ds, "kursevi"); foreach (DataRow row in ds.Tables["kursevi"].Rows) { Kurs k = new Kurs(); k.Id = (long)row["id"]; k.Jezik = (string)row["jezik"]; k.Tip = (string)row["tip"]; k.Cena = (float)row["cena"]; k.Obrisan = (bool)row["obrisan"]; long nastavnik_id = (long)row["nastavnik_id"]; bool obrisan_nas = true; foreach (Nastavnik n in Aplikacija.Instanca.Nastavnici) { if (nastavnik_id == n.Id) { k.Nastavnik = n; obrisan_nas = false; //nn.Kursevi.Add(k); } } if (obrisan_nas) { k.Nastavnik = new Nastavnik(); } Aplikacija.Instanca.Kursevi.Add(k); } } }
private Kurs SelectWorstOfTheWorst(Kurs std, int n) { if (n >= std.Students.Count) { return(std); } List <double> medBStd = new List <double>(); foreach (Student s in std.Students) { double r = 0; foreach (double ball in s.MedB) { r += ball; } medBStd.Add(r / s.MedB.Length); } medBStd.Sort(); Kurs TheWorseStd = new Kurs() { NumberKurs = std.NumberKurs, Students = new List <Student>() }; foreach (Student s in std.Students) { double r = 0; foreach (double ball in s.MedB) { r += ball; } r = (double)r / s.MedB.Length; if (r < medBStd[n]) { TheWorseStd.Students.Add(s); } } return(TheWorseStd); }
public async Task <ActionResult <Kurs> > PostKurs(KursStudentRequestModel kurs) { Kurs new_kurs = new Kurs() { Naziv = kurs.Naziv }; _context.Kursevi.Add(new_kurs); await _context.SaveChangesAsync(); new_kurs = await _context.Kursevi.FirstOrDefaultAsync(x => x.Naziv == kurs.Naziv); for (int i = 0; i < kurs.OdabraniStudenti.Count; i++) { KursStudent new_ks = new KursStudent() { KursId = new_kurs.KursId, StudentId = kurs.OdabraniStudenti[i] }; _context.KursStudenti.Add(new_ks); await _context.SaveChangesAsync(); } return(CreatedAtAction("GetKurs", new { id = kurs.KursId }, kurs)); }
public void PretraziKurseveUspesno() { Kurs kurs = ListaKurseva()[0] as Kurs; List <OpstiDomenskiObjekat> kursevi = ListaKurseva(); Mock <Broker> mock = new Mock <Broker>(); mock.Setup(b => b.ObrisiZaUslovOstalo(It.IsAny <Kurs>())); mock.Setup(b => b.VratiSveZaUslovOstalo(kurs)).Returns(kursevi); PretraziKurseve pk = new PretraziKurseve(); pk.Broker = mock.Object; List <Kurs> pov = (List <Kurs>)pk.IzvrsiKonkretnuSO(kurs); mock.Verify(b => b.ObrisiZaUslovOstalo(It.IsAny <Kurs>()), Times.Once()); mock.Verify(b => b.VratiSveZaUslovOstalo(kurs), Times.Once()); Assert.IsTrue(pov != null); for (int i = 0; i < pov.Count; i++) { Assert.AreEqual(kursevi[i], pov[i]); } }
private Kurs Otchislit(Kurs kurs) { Kurs Otchisl = new Kurs() { NumberKurs = kurs.NumberKurs, Students = new List <Student>() }; foreach (Student vasya in kurs.Students) { if (vasya.MedB[vasya.MedB.Length - 1] < 25) { Otchisl.Students.Add(vasya); } } //if ((double)Otchisl.Count/group.Count>0.2) int maxOtch = kurs.Students.Count / 5; if (Otchisl.Students.Count > maxOtch) { Otchisl = SelectWorstOfTheWorst(Otchisl, maxOtch); } return(Otchisl); }
private void btn_save_Click(object sender, RoutedEventArgs e) { Kurs newKurs = null; string name = tb_name.Text; string beschreibung = tb_beschreibung.Text; string ects = tb_ects.Text; newKurs = new Kurs(name, beschreibung, ects); if (lv_kurs.SelectedItem is Kurs selectedKurs) { Kurs existingKurs = KursListe.Instance.Where(x => x.Equals(selectedKurs)).Single(); existingKurs.Update(newKurs); lv_kurs.SelectedItem = newKurs; } else if (!IsDuplicate(newKurs)) { KursListe.Instance.Add(newKurs); lv_kurs.SelectedIndex = KursListe.Instance.Count - 1; } }
public void Core_CheckIfTeilnehmerHasBirthdayThenPlayHappyBirthdaySound_1_Kurs_Mit_1_Teilnehmer_Der_GebTag_hat_CoreMock() { var repoMock = new Mock <IRepository>(); var coreMock = new Mock <Core>(repoMock.Object); coreMock.CallBase = true; coreMock.Setup(x => x.PlayHappyBDay()).Verifiable(); repoMock.Setup(x => x.GetAll <Kurs>()).Returns(() => { var k1 = new Kurs() { Datum = new DateTime(2000, 1, 1) }; k1.Teilnehmer.Add(new Teilnehmer() { GebDatum = new DateTime(2000, 1, 1) }); return(new[] { k1 }); }); coreMock.Object.CheckIfTeilnehmerHasBirthdayThenPlayHappyBirthdaySound(); coreMock.Verify(x => x.PlayHappyBDay(), Times.AtLeast(1)); }
public ActionResult DodajKurs(int?kursId, bool?potwierdzenie) { Kurs kurs; if (kursId.HasValue) { ViewBag.EditMode = true; kurs = db.Kursy.Find(kursId); } else { ViewBag.EditMode = false; kurs = new Kurs(); } var result = new EditKursViewModel(); result.Kategorie = db.Kategorie.ToList(); result.Kurs = kurs; result.Potwierdzenie = potwierdzenie; return(View(result)); }
public IActionResult UrediKurs(int KursID) { Kurs k = db.Kurs.Where(x => x.KursID == KursID).FirstOrDefault(); if (k == null) { return(NotFound($"Kurs nije pronadjen")); } Studijski_Program sp = db.Studijski_Program.Where(x => x.Studijski_programID == k.Studijski_Program_ID_FK).FirstOrDefault(); UrediKursVM vm = new UrediKursVM { KursID = KursID, Naziv = k.Naziv, ECTS = k.ECTS, Cijena = k.Cijena, Trajanje = k.Trajanje, Trazenost = k.Trazenost, Cilj = k.Cilj, StudijskiProgram = sp.Naziv, StudijskiProgramID = sp.Studijski_programID }; return(View(vm)); }
public async Task <IActionResult> Delete(int id) { Kurs k = await _db.Kursevi.FindAsync(id); if (k == null) { return(NotFound("Zapis nije pronađen.")); } int kursTipId = k.KursTipId; try { _db.Kursevi.Remove(k); _db.SaveChanges(); } catch (Exception) { return(BadRequest(new { alert = new Alert(Severity.warning, "Nije obrisan. Kurs je vjerovatno vezan za grupu.", $"Kurs: {k.Naziv}") })); } return(RedirectToAction("KursTable", new { kursTipId = kursTipId })); }
private void CallWebService(string startDate, string endDate) { Kurs kurs = new Kurs(); string result = kurs.GetExchangeRates(startDate, endDate); ParseResponse(result); }
/// <summary> /// There are no comments for Kurs in the schema. /// </summary> public void AddToKurs(Kurs kurs) { base.AddObject("Kurs", kurs); }
/// <summary> /// Create a new Kurs object. /// </summary> /// <param name="name">Initial value of Name.</param> public static Kurs CreateKurs(string name) { Kurs kurs = new Kurs(); kurs.Name = name; return kurs; }