// POST api/values
public HttpResponseMessage Post(HttpRequestMessage request)
{
var msg = new HttpResponseMessage();
try
{
var value = request.Content.ReadAsStringAsync().Result;
ObservatieDTO obs = JsonConvert.DeserializeObject <ObservatieDTO>(value);
t_observatie obsnou = Mapper.Map <ObservatieDTO, t_observatie>(obs);
catalog.Observatii.Add(obsnou);
catalog.SaveChanges();
msg.StatusCode = System.Net.HttpStatusCode.OK;
msg.Content = new StringContent("O observatie noua a fost adaugata!");
}
catch (Exception)
{
msg.StatusCode = System.Net.HttpStatusCode.BadRequest;
msg.Content = new StringContent("Nu s-a putut adauga o observatie noua!");
}
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);
}
// DELETE api/values/5
public HttpResponseMessage Delete(int id)
{
var msg = new HttpResponseMessage();
try
{
t_observatie obs = catalog.Observatii.Where(obscautat => obscautat.Id == id).FirstOrDefault();
catalog.Observatii.Remove(obs);
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("Observatia dorita nu a putut fi stearsa!");
}
return(msg);
}
int AddObservatie(DateTime Data, int Profesor, int Elev, String Text, DatabaseLayer.CatalogContex context)
{
var newObservatie = new t_observatie();
newObservatie.Data = Data;
//newObservatie.ProfesorID = Profesor;
var tempProfesor = context.Profesorii.Where(p => p.Id == Profesor).FirstOrDefault();
newObservatie.Profesor = tempProfesor;
var tempElev = context.Elevi.Where(p => p.Id == Elev).FirstOrDefault();
newObservatie.Elev = tempElev;
newObservatie.Text = Text;
context.Observatii.AddOrUpdate(newObservatie);
context.SaveChanges();
int ObservatieID = newObservatie.Id;
return(ObservatieID);
}
// GET api/values
public IEnumerable <string> Get()
{
var obs = new t_observatie();
return(new string[] { "value1", "value2" });
}
