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();
}
}
