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 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 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 UpdatePhanHoi(PHAN_HOI phanhoi) { var query = (from c in _dataContext.PHAN_HOIs where c.MaPhanHoi == phanhoi.MaPhanHoi select c).Single(); query.MaChuyen = phanhoi.MaChuyen; query.MaNhanVien = phanhoi.MaNhanVien; query.MaPhanHoiKhach = phanhoi.MaPhanHoiKhach; _dataContext.SubmitChanges(); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "SelectItem") { GridViewRow row = GridView1.Rows[Convert.ToInt32(e.CommandArgument)]; int iMaChuyenXe = Convert.ToInt32(row.Cells[4].Text); var x = (from y in db.PHAN_HOI_KHACH_HANGs where y.MaPhanHoi == DetailsView1.PageIndex select y).Single(); //x.Duyet = 2; db.SubmitChanges(); PHAN_HOI ph = new PHAN_HOI(); ph.MaChuyen = iMaChuyenXe; ph.MaPhanHoiKhach = DetailsView1.PageIndex; db.PHAN_HOIs.InsertOnSubmit(ph); db.SubmitChanges(); } }
public void InsertPhanHoi(PHAN_HOI phanhoi) { _dataContext.PHAN_HOIs.InsertOnSubmit(phanhoi); _dataContext.SubmitChanges(); }
public void UpdatePhanHoi(PHAN_HOI phanhoi) { _phanhoiDao.UpdatePhanHoi(phanhoi); }
public void InsertPhanHoi(PHAN_HOI phanhoi) { _phanhoiDao.InsertPhanHoi(phanhoi); }