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);
}
