// PUT: api/Customer/5 public HttpResponseMessage Put(int id, [FromBody] revenue_expenditure value) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { revenue_expenditure s = db.revenue_expenditure.SingleOrDefault(b => b.id == id); if (s != null) { s.name = value.name; s.pay = value.pay; s.pay_type = value.pay_type; s.status = value.status; s.id_staff = value.id_staff; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, new revenue_expenditureDTO(s.id, s.name, Convert.ToInt64(s.pay), (int)(s.pay_type), (int)(s.status), Convert.ToInt64(s.id_staff)))); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/Fixture/5 public HttpResponseMessage Put(int id, [FromBody] fixture value) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { fixture s = db.fixtures.SingleOrDefault(b => b.id == id); if (s != null) { s.id_category_fixtures = value.id_category_fixtures; s.name = value.name; s.remain_quantity = value.remain_quantity; s.lose_quantity = value.lose_quantity; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, new fixturesDTO(s.id, Convert.ToInt64(s.id_category_fixtures), s.name, (int)(s.remain_quantity), (int)(s.lose_quantity)))); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/Customer/5 public HttpResponseMessage Put(int id, [FromBody] customer value) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { customer s = db.customers.SingleOrDefault(b => b.id == id); if (s != null) { s.name = value.name; s.phone = value.phone; s.username = value.username; s.password = value.password; s.address = value.address; s.account_number = value.account_number; s.avatar = value.avatar; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, new customerDTO(s.id, s.name, s.phone, s.username, s.avatar, s.address, s.account_number))); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// GET: api/Position public HttpResponseMessage Get() { QLMamNonEntities db = new QLMamNonEntities(); var result = db.positions; return(Request.CreateResponse(HttpStatusCode.OK, result.ToList())); }
// PUT: api/Child/5 public HttpResponseMessage Put(int id, [FromBody] child value) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { child s = db.children.SingleOrDefault(b => b.id == id); if (s != null) { s.name = value.name; s.birthday = value.birthday; s.gender = value.gender; s.status = value.status; s.id_customer = value.id_customer; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, new childDTO(s.id, s.name, s.birthday.ToString(), (int)(s.gender), (int)(s.status), Convert.ToInt64(s.id_customer)))); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/Lesson/5 public HttpResponseMessage Put(int id, [FromBody] lesson value) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { lesson s = db.lessons.SingleOrDefault(b => b.id == id); if (s != null) { s.id_plan = value.id_plan; s.id_staff = value.id_staff; s.name = value.name; s.content = value.content; s.time_start = value.time_start; s.time_end = value.time_end; return(Request.CreateResponse(HttpStatusCode.OK, new lessonDTO(s.id, Convert.ToInt64(s.id_plan), Convert.ToInt64(s.id_staff), s.name, s.content, s.time_start.ToString(), s.time_end.ToString()))); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/Customer/5 public HttpResponseMessage Put(int id, [FromBody] position value) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { position s = db.positions.SingleOrDefault(b => b.id == id); if (s != null) { s.name = value.name; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, new positionDTO(s.id, s.name))); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/Payment/5 public HttpResponseMessage Put(int id, [FromBody] payment value) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { payment s = db.payments.SingleOrDefault(b => b.id == id); if (s != null) { s.quantity_months = value.quantity_months; s.tuition_fees = value.tuition_fees; s.payment_date = value.payment_date; s.expiration_date = value.expiration_date; s.status = value.status; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, new PaymentDTO(s.id, Convert.ToInt64(s.id_customer), Convert.ToInt64(s.id_child), (int)(s.quantity_months), Convert.ToInt64(s.tuition_fees), s.payment_date.ToString(), s.expiration_date.ToString() , (int)(s.status)))); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// GET: api/Customer/5 public customerDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { customer s = db.customers.SingleOrDefault(x => x.id == id); if (s != null) { return(new customerDTO(s.id, s.name, s.phone, s.username, s.avatar, s.address, s.account_number)); } else { return(null); } } }
// GET: api/Fixture/5 public fixturesDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { fixture s = db.fixtures.SingleOrDefault(x => x.id == id); if (s != null) { return(new fixturesDTO(s.id, Convert.ToInt64(s.id_category_fixtures), s.name, (int)(s.remain_quantity), (int)(s.lose_quantity))); } else { return(null); } } }
// GET: api/Lesson/5 public lessonDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { lesson s = db.lessons.SingleOrDefault(x => x.id == id); if (s != null) { return(new lessonDTO(s.id, Convert.ToInt64(s.id_plan), Convert.ToInt64(s.id_staff), s.name, s.content, s.time_start.ToString(), s.time_end.ToString())); } else { return(null); } } }
// GET: api/Customer/5 public positon_roleDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { position_role s = db.position_role.SingleOrDefault(x => x.id == id); if (s != null) { return(new positon_roleDTO(s.id, Convert.ToInt64(s.id_position), Convert.ToInt64(s.id_role))); } else { return(null); } } }
// GET: api/Customer/5 public providerDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { provider s = db.providers.SingleOrDefault(x => x.id == id); if (s != null) { return(new providerDTO(s.id, s.name, s.phone, s.address)); } else { return(null); } } }
// GET: api/Lesson_plan/5 public lesson_planDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { lesson_plan s = db.lesson_plan.SingleOrDefault(x => x.id == id); if (s != null) { return(new lesson_planDTO(s.id, s.date.ToString())); } else { return(null); } } }
// GET: api/Child/5 public childDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { child s = db.children.SingleOrDefault(x => x.id == id); if (s != null) { return(new childDTO(s.id, s.name, s.birthday.ToString(), (int)(s.gender), (int)(s.status), Convert.ToInt64(s.id_customer))); } else { return(null); } } }
// GET: api/Customer/5 public roleDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { role s = db.roles.SingleOrDefault(x => x.id == id); if (s != null) { return(new roleDTO(s.id, s.name, s.address)); } else { return(null); } } }
// GET: api/Customer/5 public revenue_expenditureDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { revenue_expenditure s = db.revenue_expenditure.SingleOrDefault(x => x.id == id); if (s != null) { return(new revenue_expenditureDTO(s.id, s.name, Convert.ToInt64(s.pay), (int)(s.pay_type), (int)(s.status), Convert.ToInt64(s.id_staff))); } else { return(null); } } }
// GET: api/KitchenProvider/5 public kitchen_providerDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { kitchen_provider s = db.kitchen_provider.SingleOrDefault(x => x.id == id); if (s != null) { return(new kitchen_providerDTO(s.id, Convert.ToInt64(s.id_kitchen), Convert.ToInt64(s.id_provider))); } else { return(null); } } }
// GET: api/Customer/5 public positionDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { position s = db.positions.SingleOrDefault(x => x.id == id); if (s != null) { return(new positionDTO(s.id, s.name)); } else { return(null); } } }
// POST: api/Customer public HttpResponseMessage Post([FromBody] position obj) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { db.positions.Add(obj); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, obj)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// GET: api/Payment/5 public PaymentDTO Get(int id) { using (QLMamNonEntities db = new QLMamNonEntities()) { payment s = db.payments.SingleOrDefault(x => x.id == id); if (s != null) { return(new PaymentDTO(s.id, Convert.ToInt64(s.id_customer), Convert.ToInt64(s.id_child), (int)(s.quantity_months), Convert.ToInt64(s.tuition_fees), s.payment_date.ToString(), s.expiration_date.ToString() , (int)(s.status))); } else { return(null); } } }
// DELETE: api/Customer/5 public HttpResponseMessage Delete(int id) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { position s = db.positions.SingleOrDefault(x => x.id == id); db.positions.Remove(s); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/Lesson_plan/5 public HttpResponseMessage Put(int id, [FromBody] lesson_plan value) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { lesson_plan s = db.lesson_plan.SingleOrDefault(b => b.id == id); if (s != null) { s.date = value.date; return(Request.CreateResponse(HttpStatusCode.OK, new lesson_planDTO(s.id, s.date.ToString()))); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// PUT: api/KitchenProvider/5 public HttpResponseMessage Put(int id, [FromBody] kitchen_provider value) { try { using (QLMamNonEntities db = new QLMamNonEntities()) { kitchen_provider s = db.kitchen_provider.SingleOrDefault(b => b.id == id); if (s != null) { s.id_kitchen = value.id_kitchen; s.id_provider = value.id_provider; return(Request.CreateResponse(HttpStatusCode.OK, new kitchen_providerDTO(s.id, Convert.ToInt64(s.id_kitchen), Convert.ToInt64(s.id_provider)))); } else { return(null); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }