public HttpResponseMessage Get()
{
using (HotelTsgDBEntities entities = new HotelTsgDBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.spCamera_GetAll().ToList()));
}
}
public HttpResponseMessage Get(int nr_camera)
{
using (HotelTsgDBEntities entities = new HotelTsgDBEntities())
{
spCamera_GetByNumber_Result entity = entities.spCamera_GetByNumber(nr_camera).FirstOrDefault();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Camera cu numarul " + nr_camera + " nu exista"));
}
}
}
public HttpResponseMessage Post([FromBody] Camera camera)
{
try
{
using (HotelTsgDBEntities entities = new HotelTsgDBEntities())
{
entities.spCamera_Insert(camera.nr_camera, camera.capacitate, camera.pret);
var message = Request.CreateResponse(HttpStatusCode.Created, camera);
message.Headers.Location = new Uri(Request.RequestUri.ToString());
return(message);
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
public HttpResponseMessage Delete(int nr_camera)
{
try
{
using (HotelTsgDBEntities entities = new HotelTsgDBEntities())
{
var count = entities.spCamera_Delete(nr_camera);
if (count == 1)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Camera " + nr_camera + " a fost stearsa"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Camera cu nr: " + nr_camera + " nu exista!"));
}
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
public HttpResponseMessage Put(int nr_camera, [FromBody] int pret)
{
try
{
using (HotelTsgDBEntities entities = new HotelTsgDBEntities())
{
var count = entities.spCamere_UpdatePrice(nr_camera, pret);
if (count == 1)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Camera " + nr_camera + " a fost modificata"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Camera cu nr: " + nr_camera + " nu exista!"));
}
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
public HttpResponseMessage Get(int nr_camera, int id_client)
{
try
{
using (HotelTsgDBEntities entities = new HotelTsgDBEntities())
{
spRezervareRaportv2_Result rez_result = entities.spRezervareRaportv2(nr_camera, id_client).FirstOrDefault();
rez_result.dotari = entities.spGetDotByRoom(nr_camera).ToList();
rez_result.servicii = entities.spGetServiceByRez(nr_camera, id_client).ToList();
//in spRezervareRaportv2_Result
//public List<spGetDotByRoom_Result> dotari { get; set; }
//public List<spGetServiceByRez_Result> servicii { get; set; }
return(Request.CreateResponse(HttpStatusCode.OK, rez_result));
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "!Eroare, verfica daca valorile introduse corespund unei rezervari", e));
}
}
