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