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