public bool insert_DuLieu(DuLieu dl)
{
connect();
try
{
string insertCommand = @"INSERT INTO DULIEU (MaDichVu, MaTenDiaDiem, SoNha, MaDuong, MaPhuong, MaQuanHuyen, MaTinhThanh, KinhDo, ViDo, ChuThich)
VALUES (" + dl.MaDichVu + "," + dl.MaTenDiaDiem + ", N'" + dl.SoNha + "'," + dl.MaDuong + "," + dl.MaPhuong + "," + dl.MaQuanHuyen + "," + dl.MaTinhThanh + "," + dl.KinhDo + "," + dl.ViDo + ", N'" + dl.ChuThich + "')";
executeNonQuery(insertCommand);
disconnect();
return(true);
}
catch (Exception e)
{
return(false);
}
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
int danhgia = 0;
string mabinhluan = "";
DuLieu dl = new DuLieu();
dl.MaDuLieu = (int)dt.Rows[i]["MaDuLieu"];
dl.MaDichVu = (int)dt.Rows[i]["MaDichVu"];
dl.MaTenDiaDiem = (int)dt.Rows[i]["MaTenDiaDiem"];
dl.SoNha = dt.Rows[i]["SoNha"].ToString().Trim();
dl.MaDuong = (int)dt.Rows[i]["MaDuong"];
dl.MaPhuong = (int)dt.Rows[i]["MaPhuong"];
dl.MaQuanHuyen = (int)dt.Rows[i]["MaQuanHuyen"];
dl.MaTinhThanh = (int)dt.Rows[i]["MaTinhThanh"];
dl.KinhDo = (double)dt.Rows[i]["KinhDo"];
dl.ViDo = (double)dt.Rows[i]["ViDo"];
dl.ChuThich = dt.Rows[i]["ChuThich"].ToString().Trim();
danhgia = dl.DanhGia == null ? 0 : (int)dl.DanhGia;
dl.DanhGia = danhgia;
mabinhluan = dl.MaBinhLuan == null ? "" : dl.MaBinhLuan;
dl.MaBinhLuan = mabinhluan;
return((object)dl);
}
