public HttpResponseMessage GetBaiAll()
{
using (var db = new appbookEntities2())
{
var query = db.tb_bai.Select(b => b).ToList();
return(CreateResponse(query));
}
}
public HttpResponseMessage GetBaiByChuyenDe(string id_chuyende)
{
var id = -1;
if (!int.TryParse(id_chuyende, out id))
{
var response = Request.CreateResponse(HttpStatusCode.BadRequest);
response.Content = new StringContent("Invalid idChuyende", Encoding.UTF8, "application/json");
return(response);
}
using (var db = new appbookEntities2())
{
var query = db.tb_bai.Where(b => b.id_chuyende == id).Select(b => new EnBai
{
id_bai = b.id_bai,
id_chuyende = b.id_chuyende,
thu_tu = b.thu_tu,
xuat_ban = b.xuat_ban,
ngay_tao = b.ngay_tao,
bai_mau = b.bai_mau,
ds_templatenoidungdebai = b.tb_templatenoidung.Select(t => new EnTemplateNoiDung
{
id_template = t.id_templatenoidung,
loai_template = t.loai_template,
template_noidung_text = new EnTemplateNoiDungText
{
noi_dung = t.tb_templatenoidung_text.noidung,
},
template_noidung_hinhanh = new EnTemplateNoiDungHinhAnh
{
url = t.tb_templatenoidung_hinhanh.url
}
}).ToList(),
ds_cauhoi = b.tb_cauhoi.Select(h => new EnCauHoi
{
id_cauhoi = h.id_cauhoi,
id_bai = h.id_bai,
loai_cau_hoi = h.loai_cau_hoi,
phuongthuc_check_dapan = h.phuong_thuc_check_dap_an,
ngay_tao = h.ngay_tao,
xuat_ban = h.xuat_ban,
thu_tu = h.thu_tu,
gia_tri_dung = h.gia_tri_dung,
ds_dapan = h.tb_dapan.Select(a => new EnDapAn {
id_dapan = a.id_dapan,
id_cauhoi = a.id_cauhoi,
loai_dap_an = a.loai_dap_an,
ds_dapan_singlechoice = new EnDapAnSingleChoice
{
noi_dung = a.tb_dapan_singlechoice.noidung,
dap_an_dung = a.tb_dapan_singlechoice.dapan_dung
},
ds_dapan_danhdau = new EnDapAnDanhDau
{
vi_tri_dung = a.tb_dapan_danhdau.vitri_dung
},
ds_dapan_dientext = new EnDapAnDienText
{
gia_tri_dung = a.tb_dapan_dientext.giatri_dung,
help_text = a.tb_dapan_dientext.help_text
},
ds_dapan_sapxep = new EnDapAnSapXep
{
gia_tri = a.tb_dapan_sapxep.giatri,
noidung_hienthi = a.tb_dapan_sapxep.noidung_hienthi,
vi_tri_dung = a.tb_dapan_sapxep.vitri_dung
}
}).ToList()
}).ToList()
});
return(CreateResponse(query));
}
}
public HttpResponseMessage InsertBai([FromBody] EnBai bai)
{
//return CreateResponse(bai);
var objInsert = new tb_bai
{
id_chuyende = bai.id_chuyende,
ngay_tao = bai.ngay_tao,
bai_mau = bai.bai_mau,
thu_tu = bai.thu_tu,
xuat_ban = bai.xuat_ban,
tb_templatenoidung = bai.ds_templatenoidungdebai.Select(b =>
{
if (b.loai_template == LoaiTemplateNoidungDeBai.TEXT)
{
return(new tb_templatenoidung
{
loai_template = LoaiTemplateNoidungDeBai.TEXT,
tb_templatenoidung_text = new tb_templatenoidung_text
{
noidung = b.template_noidung_text.noi_dung
}
});
}
else if (b.loai_template == LoaiTemplateNoidungDeBai.HINH_ANH)
{
return(new tb_templatenoidung
{
loai_template = LoaiTemplateNoidungDeBai.HINH_ANH,
tb_templatenoidung_hinhanh = new tb_templatenoidung_hinhanh
{
url = b.template_noidung_hinhanh.url
}
});
}
return(new tb_templatenoidung {
});
}).ToList(),
tb_cauhoi = bai.ds_cauhoi.Select(h => new tb_cauhoi
{
loai_cau_hoi = h.loai_cau_hoi,
ngay_tao = h.ngay_tao,
phuong_thuc_check_dap_an = h.phuongthuc_check_dapan,
thu_tu = h.thu_tu,
xuat_ban = h.xuat_ban,
gia_tri_dung = h.gia_tri_dung,
tb_templatenoidung = h.ds_templatenoidungcauhoi.Select(t => {
if (t.loai_template == LoaiTemplateNoidungDeBai.TEXT)
{
return(new tb_templatenoidung
{
loai_template = LoaiTemplateNoidungDeBai.TEXT,
tb_templatenoidung_text = new tb_templatenoidung_text
{
noidung = t.template_noidung_text.noi_dung
}
});
}
else if (t.loai_template == LoaiTemplateNoidungDeBai.HINH_ANH)
{
return(new tb_templatenoidung
{
loai_template = LoaiTemplateNoidungDeBai.HINH_ANH,
tb_templatenoidung_hinhanh = new tb_templatenoidung_hinhanh
{
url = t.template_noidung_hinhanh.url
}
});
}
return(new tb_templatenoidung {
});
}).ToList()
}).ToList()
};
try
{
tb_bai rs = null;
using (var db = new appbookEntities2())
{
rs = db.tb_bai.Add(objInsert);
db.SaveChanges();
}
return(CreateResponse(rs));
}
catch (Exception ex)
{
return(CreateResponse(new { error = ex.Message }));
}
}
