protected void Button_OK_Click(object sender, EventArgs e)
{
GridViewRow row;
bool isChecked;
int iMaChuyenXe;
int iSoLuong = GridView1.Rows.Count;
for (int i = 0; i < iSoLuong; i++)
{
row = GridView1.Rows[i];
isChecked = ((CheckBox)row.FindControl("chkSelect")).Checked;
if (isChecked)
{
iMaChuyenXe = Convert.ToInt32(row.Cells[1].Text);
// Them o PHANHOIKHACHHANG
PHAN_HOI_KHACH_HANG phkh = new PHAN_HOI_KHACH_HANG();
phkh.NoiDung = TextBox1.Text;
phkh.NgayDang = DateTime.Now;
phkh.Duyet = 2; // da duyet
db.PHAN_HOI_KHACH_HANGs.InsertOnSubmit(phkh);
db.SubmitChanges();
// Them PhanHoi
PHAN_HOI ph = new PHAN_HOI();
ph.MaPhanHoiKhach = phkh.MaPhanHoi;
ph.MaChuyen = iMaChuyenXe;
db.PHAN_HOIs.InsertOnSubmit(ph);
db.SubmitChanges();
((CheckBox)row.FindControl("chkSelect")).Checked = false;
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "SelectItem")
{
GridViewRow row = GridView1.Rows[Convert.ToInt32(e.CommandArgument)];
iMaChuyenXe = Convert.ToInt32(row.Cells[4].Text);
TRAVEL_WEBDataContext db = new TRAVEL_WEBDataContext();
PHAN_HOI_KHACH_HANG phkh = new PHAN_HOI_KHACH_HANG();
phkh.NgayDang = DateTime.Now;
phkh.NoiDung = tbThongTinPhanHoi.Text;
//phkh.Duyet = 2;
db.PHAN_HOI_KHACH_HANGs.InsertOnSubmit(phkh);
db.SubmitChanges();
var x = from y in db.PHAN_HOI_KHACH_HANGs select y.MaPhanHoi;
PHAN_HOI ph = new PHAN_HOI();
ph.MaChuyen = iMaChuyenXe;
ph.MaPhanHoiKhach = x.Max();
db.PHAN_HOIs.InsertOnSubmit(ph);
db.SubmitChanges();
}
}
protected void Button_OK_Click(object sender, EventArgs e)
{
GridViewRow row;
bool isChecked;
int iMaChuyenXe;
int iSoLuong = GridView1.Rows.Count;
for (int i = 0; i < iSoLuong; i++)
{
row = GridView1.Rows[i];
isChecked = ((CheckBox)row.FindControl("chkSelect")).Checked;
if (isChecked)
{
iMaChuyenXe = Convert.ToInt32(row.Cells[1].Text);
// Them PhanHoi
PHAN_HOI ph = new PHAN_HOI();
ph.MaPhanHoiKhach = iMaPhanHoiKhach;
ph.MaChuyen = iMaChuyenXe;
db.PHAN_HOIs.InsertOnSubmit(ph);
db.SubmitChanges();
((CheckBox)row.FindControl("chkSelect")).Checked = false;
// Update
PHAN_HOI_KHACH_HANG phkh = (from x in db.PHAN_HOI_KHACH_HANGs
where x.MaPhanHoi == iMaPhanHoiKhach
select x).Single();
phkh.Duyet = 2;
db.SubmitChanges();
}
}
GridView_PHANHOI.DataBind();
}
public void UpdatePhanHoiKhachHang(PHAN_HOI_KHACH_HANG phanhoikhachhang)
{
var query = (from c in _dataContext.PHAN_HOI_KHACH_HANGs
where c.MaPhanHoi == phanhoikhachhang.MaPhanHoi
select c).Single();
query.NoiDung = phanhoikhachhang.NoiDung;
query.NgayDang = phanhoikhachhang.NgayDang;
_dataContext.SubmitChanges();
}
public void UpdatePhanHoiKhachHang(PHAN_HOI_KHACH_HANG phanhoikhachhang)
{
_phanhoikhachhangDao.UpdatePhanHoiKhachHang(phanhoikhachhang);
}
public void InsertPhanHoiKhachHang(PHAN_HOI_KHACH_HANG phanhoikhachhang)
{
_phanhoikhachhangDao.InsertPhanHoiKhachHang(phanhoikhachhang);
}
public void InsertPhanHoiKhachHang(PHAN_HOI_KHACH_HANG phanhoikhachhang)
{
_dataContext.PHAN_HOI_KHACH_HANGs.InsertOnSubmit(phanhoikhachhang);
_dataContext.SubmitChanges();
}
