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