public IHttpActionResult addMxS([FromBody] MStage_Data data)
{
if (data == null)
{
//Bad request code 400
return(BadRequest());
}
/*
* if (ms.existMStage(data.id_stage, data.id_material))
* {
* //petición correcta pero no pudo ser procesada porque ya existe el archivo code 202
* return StatusCode(HttpStatusCode.Accepted);
* }
*/
if (ms.addMStage(data))
{
//petición correcta y se ha creado un nuevo recurso code 201
return(StatusCode(HttpStatusCode.Created));
}
else
{
//No se pudo crear el recurso por un error interno code 500
return(InternalServerError());
}
}
public MStage_Data GetMStage(int id_material, int id_stage)
{
MStage_Data result = new MStage_Data();
MaterialsxStage materialsxStage;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existMStage(id_stage, id_material))
{
result = null;
return(result);
}
materialsxStage = construyeEntities.MaterialsxStages.Find(id_stage, id_material);
result.id_material = materialsxStage.id_material;
result.id_stage = materialsxStage.id_stage;
result.price = materialsxStage.price;
result.quantity = materialsxStage.quantity;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public IHttpActionResult GetClient(int id_stage, int id_material)
{
if (!ms.existMStage(id_stage, id_material))
{
//No se encontró el recurso code 404
return(NotFound());
}
MStage_Data data = ms.GetMStage(id_material, id_stage);
if (data != null)
{
// ok code 200
return(Ok(data));
}
else
{
//No se pudo crear el recurso por un error interno code 500
return(InternalServerError());
}
}
public bool updateMStage(MStage_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var ms = construyeEntities.MaterialsxStages.Find(data.id_stage, data.id_material);
ms.id_material = data.id_material;
ms.id_stage = data.id_stage;
ms.price = data.price;
ms.quantity = data.quantity;
ms.Material = construyeEntities.Materials.Find(data.id_material);
ms.Stage = construyeEntities.Stages.Find(data.id_stage);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public IHttpActionResult updateMxs([FromBody] MStage_Data data)
{
if (data == null)
{
//Bad request code 400
return(BadRequest());
}
if (!ms.existMStage(data.id_stage, data.id_material))
{
//petición correcta pero no pudo ser procesada porque no existe el archivo code 404
return(NotFound());
}
if (ms.updateMStage(data))
{
//petición correcta y se ha creado un nuevo recurso code 200 ok
return(Ok());
}
else
{
//No se pudo crear el recurso por un error interno code 500
return(InternalServerError());
}
}
public bool addMStage(MStage_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
MaterialsxStage newMs = new MaterialsxStage();
newMs.id_material = data.id_material;
newMs.id_stage = data.id_stage;
newMs.price = data.price;
newMs.quantity = data.quantity;
newMs.Material = construyeEntities.Materials.Find(data.id_material);
newMs.Stage = construyeEntities.Stages.Find(data.id_stage);
try
{
construyeEntities.MaterialsxStages.Add(newMs);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public List <Object> GetListMStage()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var mstageList = construyeEntities.MaterialsxStages.ToList();
int n = mstageList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < mstageList.Count; ++i)
{
MStage_Data data = new MStage_Data();
data.id_material = mstageList.ElementAt(i).id_material;
data.id_stage = mstageList.ElementAt(i).id_stage;
data.price = mstageList.ElementAt(i).price;
data.quantity = mstageList.ElementAt(i).quantity;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
