public HttpResponseMessage add([FromBody] DX0010D[] values)
{
using (QLDX_DB db = new QLDX_DB())
{
results <object> list = new results <object>();
values.ToList().ForEach(val =>
{
result <object> rel = new result <object>();
var check = db.DX0010D.Where(p => p.DX0010_ID == val.DX0010_ID && p.DX0011_ID == val.DX0011_ID).FirstOrDefault();
if (check == null)
{
var l = new DX0010D()
{
thuTu = val.thuTu, DX0010_ID = val.DX0010_ID, DX0011_ID = val.DX0011_ID, ghiChu = val.ghiChu
};
db.DX0010D.Add(l);
try
{
db.SaveChanges();
rel.set("OK", getDX0010D(val));
}
catch (Exception f)
{
rel.set("ERR", getDX0010D(val), f.Message);
}
}
else
{
check.thuTu = val.thuTu;
try
{
db.SaveChanges();
rel.set("UPDATE", getDX0010D(val));
}
catch (Exception f)
{
rel.set("ERR", getDX0010D(val), f.Message);
}
}
list.add(rel);
});
return(list.ToHttpResponseMessage());
}
}
public object getDX0010D(DX0010D p)
{
using (var db = new QLDX_DB())
{
return(new
{
p.DX0010D_ID,
p.DX0010_ID,
p.DX0011_ID,
p.ghiChu,
p.thuTu,
DX0010 = db.DX0010.Where(x => x.DX0010_ID == p.DX0010_ID).Select(x => new
{
x.bienSoXe,
x.DX0010_ID,
x.ghiChu,
x.maTuyenXe,
x.mobile,
x.tenLaiXe,
x.tenTuyenXe,
x.thuTu,
x.trangThai,
x.type,
}).FirstOrDefault(),
DX0011 = db.DX0011.Where(x => x.DX0011_ID == p.DX0011_ID).Select(x => new
{
x.DX0011_ID,
x.DX0013_ID,
x.DX0014_ID,
x.ghiChu,
x.lat,
x.lng,
x.maDiemDon,
x.taxi,
x.tenDiemDon,
x.thuTu,
x.trangThai,
}).FirstOrDefault(),
});
}
}
public HttpResponseMessage delete([FromBody] DX0010D val)
{
using (QLDX_DB db = new QLDX_DB())
{
result <object> rel = new result <object>();
var check = db.DX0010D.Where(p => p.DX0010_ID == val.DX0010_ID && p.DX0011_ID == val.DX0011_ID).FirstOrDefault();
if (check != null)
{
db.DX0010D.Remove(check);
try
{
db.SaveChanges();
rel.set("OK", getDX0010D(val));
}
catch (Exception f)
{
rel.set("ERR", getDX0010D(val), f.Message);
}
}
return(rel.ToHttpResponseMessage());
}
}
