public List<CAUHOIKHAOSAT> SelectCAUHOIKHAOSATsAll() { List<CAUHOIKHAOSAT> list = new List<CAUHOIKHAOSAT>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<CAUHOIKHAOSAT_getallResult> lp = db.CAUHOIKHAOSAT_getall(); foreach (CAUHOIKHAOSAT_getallResult CAUHOIKHAOSAT in lp) { CAUHOIKHAOSAT var1 = new CAUHOIKHAOSAT(); var1.MaCauHoiKhaoSat = CAUHOIKHAOSAT.MaCauHoiKhaoSat ; var1.NoiDung = CAUHOIKHAOSAT.NoiDung ; var1.BiKhoa = CAUHOIKHAOSAT.BiKhoa ; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }
protected void btnThem_Click(object sender, EventArgs e) { try { //lay thong tin tu textbox CAUHOIKHAOSAT lpDTO = new CAUHOIKHAOSAT(); lpDTO.MaCauHoiKhaoSat = int.Parse(txtmacauhoikhaosat.Text); lpDTO.NoiDung = txttieude.Text; lpDTO.BiKhoa = Convert.ToBoolean(txtlock.Text); //Goi ham cap nhat BUSCauHoiKhaoSat BUSCauHoiKhaoSat = new BUSCauHoiKhaoSat(); if (BUSCauHoiKhaoSat.Them(lpDTO) == 0) { //Thong bao lbThongBao.Text = "Thêm Thành Công"; lbThongBao.Visible = true; //Response.Redirect("LoaiMatHang.aspx"); } else { lbThongBao.Text = "Thêm Không Thành Công"; lbThongBao.Visible = true; } } catch { lbThongBao.Text = "Thêm Không Thành Công"; lbThongBao.Visible = true; } }
protected void LoadKhaosat() { BUSCauHoiKhaoSat BUSCauHoiKhaoSat = new BUSCauHoiKhaoSat(); CAUHOIKHAOSAT CAUHOIKHAOSAT = new CAUHOIKHAOSAT(); CAUHOIKHAOSAT = BUSCauHoiKhaoSat.layCauHoiKhongKhoa(); MaCauHoi = CAUHOIKHAOSAT.MaCauHoiKhaoSat; if (CAUHOIKHAOSAT != null) { lbCauHoi.Text = CAUHOIKHAOSAT.NoiDung; BUSDapAnKhaoSat BUSDapAnKhaoSat = new BUSDapAnKhaoSat(); List<DAPANKHAOSAT> listDA = new List<DAPANKHAOSAT>(); listDA = BUSDapAnKhaoSat.layDapAnTheoMaCauHoi(CAUHOIKHAOSAT.MaCauHoiKhaoSat); rblistDanhSachDapAn.DataSource = listDA; rblistDanhSachDapAn.DataTextField = "NoiDung"; rblistDanhSachDapAn.DataValueField = "MaDapAn"; rblistDanhSachDapAn.DataBind(); } else { rblistDanhSachDapAn.Visible = true; btSubmit.Visible = true; } // rblistDanhSachDapAn.Items[0].Selected = true; }
public int CapNhat(CAUHOIKHAOSAT lpDTO) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); db.CAUHOIKHAOSAT_update( lpDTO.MaCauHoiKhaoSat, lpDTO.NoiDung, lpDTO.BiKhoa ); db.SubmitChanges(); return 0; } catch (Exception ex) { throw (ex); } }
public int Them(CAUHOIKHAOSAT lpDTO) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); db.CAUHOIKHAOSAT_add( lpDTO.NoiDung , lpDTO.BiKhoa ); return 1; } catch { return 0; } }
public int Them(CAUHOIKHAOSAT lpDTO) { DAOCauHoiKhaoSat CAUHOIKHAOSAT = new DAOCauHoiKhaoSat(); return CAUHOIKHAOSAT.Them(lpDTO); }
public int CapNhat(CAUHOIKHAOSAT lpDTO) { DAOCauHoiKhaoSat CAUHOIKHAOSAT = new DAOCauHoiKhaoSat(); return CAUHOIKHAOSAT.CapNhat(lpDTO); }