public List <Specializare> GetAll() { var listaSpecializari = new List <Specializare>(); using (SqlConnection connection = new SqlConnection(AppSettings.connectionString)) { var queryString = "Select * from specializari"; using (SqlCommand command = new SqlCommand(queryString, connection)) { connection.Open(); using (SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection)) { while (dr.Read()) { var newSpecializare = new Specializare { Id = Int32.Parse(dr["Id"].ToString()), Nume = dr["Nume"].ToString(), }; listaSpecializari.Add(newSpecializare); } } } connection.Close(); return(listaSpecializari); } }
public IActionResult GetGroupsForSpecializare([FromRoute] string an, [FromRoute] string numeSpecializare) { Specializare specializare = _context.Specializare.Where( s => s.Nume.Equals(numeSpecializare) ).FirstOrDefault(); if (specializare == null) { Dictionary <string, string> err = new Dictionary <string, string>(); err.Add("error", String.Format("There is no specializare named: '{0}'!", numeSpecializare)); return(Ok(err)); } List <Group> groups = _context.Group.Where(g => g.NumeSpecializare.Equals(numeSpecializare)).ToList(); List <string> response = new List <string>(); foreach (var g in groups) { if (g.GroupName[1] == char.Parse(an)) { response.Add(g.GroupName); } } return(Ok(response)); }
public object[] ConvertBack(object value, Type[] targetTypes, object parameter, System.Globalization.CultureInfo culture) { Specializare spec = value as Specializare; object[] res = new object[] { spec.IdSpecializare, spec.Descriere }; return(res); }
public Specializare GetSpecializare(int Id) { var newSpecializare = new Specializare(); using (SqlConnection connection = new SqlConnection(AppSettings.connectionString)) { var queryString = "Select * from specializari where Id=@Id"; using (SqlCommand command = new SqlCommand(queryString, connection)) { command.Parameters.AddWithValue("@Id", Id); connection.Open(); using (SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection)) { while (dr.Read()) { newSpecializare.Id = Int32.Parse(dr["Id"].ToString()); newSpecializare.Nume = dr["Nume"].ToString(); } } } connection.Close(); return(newSpecializare); } }
public async Task <IActionResult> PutSpecializare(int id, Specializare specializare) { if (id != specializare.Id) { return(BadRequest()); } _context.Entry(specializare).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SpecializareExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <Specializare> > PostSpecializare(Specializare specializare) { _context.Specializare.Add(specializare); await _context.SaveChangesAsync(); return(CreatedAtAction("GetSpecializare", new { id = specializare.Id }, specializare)); }
public IActionResult Create(CreateSpecializareVm model) { var newModel = new Specializare { Nume = model.Nume }; specializareServices.Insert(newModel); return(RedirectToAction("Index", "Specializare")); }
public async Task <IActionResult> PostSpecializare([FromBody] Specializare specializare) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.Specializare.Add(specializare); await _context.SaveChangesAsync(); return(CreatedAtAction("GetSpecializare", new { id = specializare.Id }, specializare)); }
public void Insert(Specializare specializare) { using (SqlConnection connection = new SqlConnection(AppSettings.connectionString)) { var queryString = "Insert into specializari values(@Nume)"; using (SqlCommand command = new SqlCommand(queryString, connection)) { command.Parameters.AddWithValue("@Nume", specializare.Nume); connection.Open(); command.ExecuteNonQuery(); } } }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Specializare = await _context.Specializare.FirstOrDefaultAsync(m => m.ID == id); if (Specializare == null) { return(NotFound()); } return(Page()); }
public void Update(Specializare specializare) { using (SqlConnection connection = new SqlConnection(AppSettings.connectionString)) { var queryString = "Update specializari set Nume=@Nume where Id=@Id"; using (SqlCommand command = new SqlCommand(queryString, connection)) { command.Parameters.AddWithValue("@Nume", specializare.Nume); command.Parameters.AddWithValue("@Id", specializare.Id); connection.Open(); command.ExecuteNonQuery(); } } }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Specializare = await _context.Specializare.FindAsync(id); if (Specializare != null) { _context.Specializare.Remove(Specializare); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public IActionResult GetGradesOfStudent([FromRoute] string username) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } List <Grade> grades = _context.Grade.Where(g => g.Student.Username.Equals(username)).ToList(); List <GradeJSON> gradesJSON = new List <GradeJSON>(); foreach (var g in grades) { //GradeJSON gJSON = new GradeJSON(g.Discipline.Nume, g.Discipline.An.ToString(), g.Discipline.Semestru.ToString(), // g.DataNotei, g.Discipline.Cod, g.GradeValue.ToString(), g.Discipline.Specializare.ToString()); //until we fix binding object problem: //////////////////////////////////////////////////// Discipline d = new Discipline() { Type = DisciplineType.OBLIGATORIU, Cod = "MLE5555", Nume = "Baze de date distrb.", Credite = 6, An = 2, Semestru = 2, }; Specializare sp = _context.Specializare.FirstOrDefault(); d.Specializare = sp; Teacher t = _context.Teacher.FirstOrDefault(); d.Teacher = t; GradeJSON gJSON = new GradeJSON(d.Nume, d.An.ToString(), d.Semestru.ToString(), "2018-05-06", d.Cod, g.GradeValue.ToString(), d.Specializare.ToString()); //////////////////////////////////////////////////// gradesJSON.Add(gJSON); } if (gradesJSON.Count == 0) { return(NotFound()); } //var serializer = new JavaScriptSerializer(); //var serializedResult = serializer.Serialize(gradesJSON); return(Ok(gradesJSON)); }
public IActionResult Edit(Specializare specializare) { specializareServices.Update(specializare); return(RedirectToAction("Index", "Specializare")); }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { try { int sem = 0; //nu a mai fost adaugata if (bunifuDropdown1.selectedIndex != -1) { //daca a fost selectat ceva in dropdown string NumeSpecializare = bunifuMaterialTextbox1.Text; if (NumeSpecializare != "" && NumeSpecializare != "Completati Nume Specializare!" && NumeSpecializare != "Specializarea Exista!") //daca a scris ceva in textbox { //cautam daca a mai fost adaugata specializarea for (int i = 0; i < bunifuCustomDataGrid1.Rows.Count; i++) { if (bunifuCustomDataGrid1.Rows[i].Cells[0].Value.Equals(NumeSpecializare)) { sem = 1;//inseamna ca exista break; } } if (sem == 0) { //adica nu a mai fost adaugata //adaugam specializarea in baza de date using (var catalog = new CatalogEntities1()) { using (var dbCatalogTransaction = catalog.Database.BeginTransaction()) { try { var newSpecializare = new Specializare { Nume = NumeSpecializare, DepartamentID = this.departamentId_Selectat }; catalog.Specializares.Add(newSpecializare); catalog.SaveChanges(); dbCatalogTransaction.Commit(); } catch (Exception ex) { dbCatalogTransaction.Rollback(); FormError newForm = new FormError(); newForm.SetText(ex.ToString()); newForm.ShowDialog(); } AdaugareSpecializari(NumeSpecializare);//adaugam specializarea in data grid view } } } else { bunifuMaterialTextbox1.Text = "Specializarea Exista!"; } } else { bunifuMaterialTextbox1.Text = "Completati Nume Specializare!"; } }//daca nu e selectat nu se intampla nimic } catch (Exception ex) { FormError newForm = new FormError(); newForm.SetText(ex.ToString()); newForm.ShowDialog(); } }