public object getDX0020(DX0020 p)
{
return(new
{
p.ban_id,
p.capbac,
p.chucvu,
p.cmtnd_so,
p.diachitamtru,
p.diachithuongtru,
p.dienthoai_didong,
p.DX0011_ID,
p.DX0020_ID,
p.email,
p.gioitinh,
p.hodem,
p.manhansu,
p.ngaysinh,
p.phong_id,
p.ten,
p.thetu_id,
p.trangThai
}
);
}
public HttpResponseMessage add([FromBody] DX0001[] 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 data = db.Database.SqlQuery <DX0020>("select * from DX0020 where manhansu='" + val.T002C + "'").FirstOrDefault();
if (data == null)
{
var kl = new DX0020()
{
ban_id = val.T098C,
capbac = val.T005C,
dienthoai_didong = val.T004C,
DX0011_ID = val.T008C,
DX0010_ID = val.T009C,
hodem = val.T001C,
manhansu = val.T002C,
trangThai = 1,
phong_id = val.T098C,
thoiGianSuDung = val.T010C,
};
db.DX0020.Add(kl);
try
{
db.SaveChanges();
rel.set("OK", val, "Thành công.");
}
catch (Exception g)
{
rel.set("ERR", val, "Thất bại: ");
}
}
else
{
rel.set("EXIST", val, "Đã tồn tại.");
}
list.add(rel);
});
return(list.ToHttpResponseMessage());;
}
}
