public static bool Login(string username, string password) { bool req = false; using (t_elev persoana = new t_elev()) { if (persoana.Email.Equals(username, StringComparison.OrdinalIgnoreCase) && persoana.Parola == password) { req = true; } } if (req == false) { using (t_profesor persoana = new t_profesor()) { if (persoana.Email.Equals(username, StringComparison.OrdinalIgnoreCase) && persoana.Parola == password) { req = true; } } } return(req); }
// POST: api/Profesor public HttpResponseMessage Post(HttpRequestMessage request) { var msg = new HttpResponseMessage(); try { var value = request.Content.ReadAsStringAsync().Result; ProfesorDTO profesor = JsonConvert.DeserializeObject <ProfesorDTO>(value); t_profesor profnou = Mapper.Map <ProfesorDTO, t_profesor>(profesor); catalog.Profesorii.Add(profnou); catalog.SaveChanges(); msg.StatusCode = System.Net.HttpStatusCode.OK; msg.Content = new StringContent("Un profesor nou a fost adaugat!"); } catch (Exception) { msg.StatusCode = System.Net.HttpStatusCode.BadRequest; msg.Content = new StringContent("Nu s-a putut adauga un profesor nou!"); } return(msg); }
// PUT: api/Clasa/5 public HttpResponseMessage Put(int id, HttpRequestMessage request) { var msg = new HttpResponseMessage(); try { var value = request.Content.ReadAsStringAsync().Result; t_clasa clasa = catalog.Clase.Where(clasacautata => clasacautata.Id == id).FirstOrDefault(); ClasaDTO clasanoua = JsonConvert.DeserializeObject <ClasaDTO>(value); clasa.Id = clasanoua.Id; clasa.Numar = clasanoua.Numar; clasa.Serie = clasanoua.Serie; clasa.An = clasanoua.An; t_profil profil = catalog.Profiluri.Where(profilcautat => profilcautat.Id == clasanoua.ProfilID).FirstOrDefault(); clasa.Profil = profil; t_profesor diriginte = catalog.Profesorii.Where(dirig => dirig.Id == clasanoua.DiriginteID).FirstOrDefault(); clasa.Diriginte = diriginte; //Lista de elevi catalog.SaveChanges(); msg.StatusCode = System.Net.HttpStatusCode.OK; msg.Content = new StringContent("Modificarile au fost procesate cu succes!"); } catch (Exception ex) { msg.StatusCode = System.Net.HttpStatusCode.BadRequest; msg.Content = new StringContent("Nu s-au putut executa modificarile dorite!"); } return(msg); }
// PUT api/values/5 public HttpResponseMessage Put(int id, HttpRequestMessage request) { var msg = new HttpResponseMessage(); try { var value = request.Content.ReadAsStringAsync().Result; t_observatie obs = catalog.Observatii.Where(obscautat => obscautat.Id == id).FirstOrDefault(); ObservatieDTO obsnou = JsonConvert.DeserializeObject <ObservatieDTO>(value); obs.Id = obsnou.Id; obs.Data = obsnou.Data; obs.Text = obsnou.Text; t_elev elev = catalog.Elevi.Where(elevcautat => elevcautat.Id == obsnou.ElevID).FirstOrDefault(); obs.Elev = elev; t_profesor profesor = catalog.Profesorii.Where(profesorcautat => profesorcautat.Id == obsnou.ProfesorID).FirstOrDefault(); obs.Profesor = profesor; catalog.SaveChanges(); msg.StatusCode = System.Net.HttpStatusCode.OK; msg.Content = new StringContent("Modificarile au fost procesate cu succes!"); } catch (Exception ex) { msg.StatusCode = System.Net.HttpStatusCode.BadRequest; msg.Content = new StringContent("Nu s-au putut executa modificarile dorite!"); } return(msg); }
public HttpResponseMessage CheckCredentials(HttpRequestMessage credentials) { var msg = new HttpResponseMessage(); string userpass = credentials.Content.ReadAsStringAsync().Result; string[] usernamePasswordArray = userpass.Split(':'); string username = usernamePasswordArray[0]; string password = usernamePasswordArray[1]; var utilizator = new Utilizator(); t_elev userelev = catalog.Elevi.Where(elevspecific => elevspecific.Email == username).FirstOrDefault(); if (userelev == null) { t_profesor userprof = catalog.Profesorii.Where(profspecific => profspecific.Email == username).FirstOrDefault(); if (userprof != null && userprof.Parola == password) { utilizator.Tip = ut.profesor; utilizator.Id = userprof.Id; msg.Content = new StringContent(JsonConvert.SerializeObject(utilizator)); } else { msg.StatusCode = HttpStatusCode.Unauthorized; msg.Content = new StringContent("Access denied"); } } else { if (userelev.Parola == password) { utilizator.Tip = ut.elev; utilizator.Id = userelev.Id; msg.Content = new StringContent(JsonConvert.SerializeObject(utilizator)); } else { msg.StatusCode = HttpStatusCode.Unauthorized; msg.Content = new StringContent("Access denied"); } } return(msg); }
int AddProfessor(String nume, String prenume, string telefon, string email, DatabaseLayer.CatalogContex context) { var newProfesor = new t_profesor(); newProfesor.Nume = nume; newProfesor.Prenume = prenume; newProfesor.Telefon = telefon; newProfesor.Email = email; context.Profesorii.AddOrUpdate(newProfesor); context.SaveChanges(); int profesorId = newProfesor.Id; return(profesorId); }
// DELETE: api/Profesor/5 public HttpResponseMessage Delete(int id) { var msg = new HttpResponseMessage(); try { t_profesor prof = catalog.Profesorii.Where(profcautat => profcautat.Id == id).FirstOrDefault(); catalog.Profesorii.Remove(prof); catalog.SaveChanges(); msg.StatusCode = System.Net.HttpStatusCode.OK; msg.Content = new StringContent("Stergerea a fost executata cu succes!"); } catch (Exception ex) { msg.StatusCode = System.Net.HttpStatusCode.BadRequest; msg.Content = new StringContent("Profesorul dorit nu a putut fi sters!"); } return(msg); }
// PUT: api/Profesor/5 public HttpResponseMessage Put(int id, HttpRequestMessage request) { var msg = new HttpResponseMessage(); try { var value = request.Content.ReadAsStringAsync().Result; t_profesor prof = catalog.Profesorii.Where(profcautat => profcautat.Id == id).FirstOrDefault(); ProfesorDTO profnou = JsonConvert.DeserializeObject <ProfesorDTO>(value); prof.Id = profnou.Id; prof.Email = profnou.Email; prof.Nume = profnou.Nume; prof.Parola = profnou.Parola; prof.Prenume = profnou.Prenume; prof.Telefon = profnou.Telefon; //Lista de Note //Lista de Observatii //Lista de Absente //ICollection de Materii catalog.SaveChanges(); msg.StatusCode = System.Net.HttpStatusCode.OK; msg.Content = new StringContent("Modificarile au fost procesate cu succes!"); } catch (Exception ex) { msg.StatusCode = System.Net.HttpStatusCode.BadRequest; msg.Content = new StringContent("Nu s-au putut executa modificarile dorite!"); } return(msg); }