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