protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToString(Session["TenDangNhap"]) == "")
{
Response.Redirect("~/dangnhap.aspx");
}
choilbangDAL = new clsCauHoi_LoaiBang_DAL();
choilbangDTO = new clsCauHoi_LoaiBang_DTO();
lbangDAL = new clsLoaiBanglai_DAL();
lbangDTO = new clsLoaiBanglai_DTO();
choiDAL = new clsCauHoi_DAL();
choiDTO = new clsCauHoi_DTO();
cmn = new clsCommon();
if (!IsPostBack || !IsCallback)
{
}
if (!Page.IsPostBack)
{
}
loadMasterData();
if (cboLoaiBang.Value != null)
{
gvCauHoiLoaiBang.DataSource = loadDataToUI();
gvCauHoiLoaiBang.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToString(Session["TenDangNhap"]) == "")
{
Response.Redirect("~/dangnhap.aspx");
}
lbangDAL = new clsLoaiBanglai_DAL();
lbangDTO = new clsLoaiBanglai_DTO();
cmn = new clsCommon();
gvLoaiBang.DataSource = loadDataToUI();
gvLoaiBang.DataBind();
}
public int Delete(clsLoaiBanglai_DTO loaibanglaiDTO)
{
try
{
ListDictionary _list = new ListDictionary();
_list.Add("MaLoaiBang", loaibanglaiDTO.MaLoaiBang);
int iReturn = obj.ExcSql("Delete_Loai_Bang_Lai", _list, CommandType.StoredProcedure);
return(iReturn);
}
catch (Exception)
{
//return ex.Message;
return(-1111);
}
}
public int Delete(clsLoaiBanglai_DTO loaibanglaiDTO)
{
try
{
ListDictionary _list = new ListDictionary();
_list.Add("MaLoaiBang", loaibanglaiDTO.MaLoaiBang);
int iReturn = obj.ExcSql("Delete_Loai_Bang_Lai", _list, CommandType.StoredProcedure);
return iReturn;
}
catch (Exception)
{
//return ex.Message;
return -1111;
}
}
public DataTable getMaLoaibang(clsLoaiBanglai_DTO loaibanglaiDTO)
{
ListDictionary _list = new ListDictionary();
_list.Add("MaLoaiBang", loaibanglaiDTO.MaLoaiBang);
_list.Add("TenLoai", loaibanglaiDTO.TenLoai);
_list.Add("MoTa", loaibanglaiDTO.MoTa);
_list.Add("TGThi", loaibanglaiDTO.TGThi);
_list.Add("SoCauDat", loaibanglaiDTO.SoCauDat);
DataTable dt = new DataTable();
try
{
dt = obj.GetDataTable("Select_Loai_Bang_Lai", _list, CommandType.StoredProcedure);
}
catch
{
dt = null;
}
return dt;
}
public int InsertUpdate(clsLoaiBanglai_DTO loaibanglaiDTO)
{
try
{
ListDictionary _list = new ListDictionary();
_list.Add("old_id", loaibanglaiDTO.OldID);
_list.Add("MaLoaiBang", loaibanglaiDTO.MaLoaiBang);
_list.Add("TenLoai", loaibanglaiDTO.TenLoai);
_list.Add("MoTa", loaibanglaiDTO.MoTa);
_list.Add("TGThi", loaibanglaiDTO.TGThi);
_list.Add("SoCauDat", loaibanglaiDTO.SoCauDat);
int iReturn = obj.ExcSql("Insert_Update_Loai_Bang_Lai", _list, CommandType.StoredProcedure);
return(iReturn);
}
catch (Exception)
{
//return ex.Message;
return(-1111); // Đặt số này làm ngoại lệ ko lường trước được. ở StoredProcedure không được return có số này tránh trường hợp trùng
}
}
//Get Lay dethi theoloaibang
public DataTable getDeThiTheoLoaiBang(clsLoaiBanglai_DTO loaibanglaiDTO)
{
ListDictionary _list = new ListDictionary();
_list.Add("MaLoaiBang", loaibanglaiDTO.MaLoaiBang);
//_list.Add("TenLoai", loaibanglaiDTO.TenLoai);
//_list.Add("MoTa", loaibanglaiDTO.MoTa);
//_list.Add("TGThi", loaibanglaiDTO.TGThi);
//_list.Add("SoCauDat", loaibanglaiDTO.SoCauDat);
DataTable dt = new DataTable();
try
{
dt = obj.GetDataTable("Select_dethitheoloaibang", _list, CommandType.StoredProcedure);
}
catch
{
dt = null;
}
return(dt);
}
private void loadMasterData()
{
lblDTO = new clsLoaiBanglai_DTO();
DataTable dt = new DataTable();
dt = lblDAL.getMaLoaibang(lblDTO);
cboLoaiBang.ValueField = "MaLoaiBang";
cboLoaiBang.TextField = "TenLoai";
cboLoaiBang.DataSource = dt;
cboLoaiBang.DataBind();
//GridViewDataComboBoxColumn gcloaibang = gvDotThi.Columns["TenLoai"] as GridViewDataComboBoxColumn;
//gcloaibang.PropertiesComboBox.DataSource = dt;
//gclDiemThi.PropertiesComboBox.ValueField = "MaDienThi";
//gclDiemThi.PropertiesComboBox.TextField = "TenDiemThi";
//GridViewDataCheckColumn gclTrangThai = gvDotThi.Columns["TrangThai"] as GridViewDataCheckColumn;
//gclTrangThai.PropertiesCheckEdit.DisplayTextChecked = "Chon";
}
protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToString(Session["TenDangNhap"]) == "")
Response.Redirect("~/dangnhap.aspx");
ctdthiDAL = new clsCauTrucDeThi_DAL();
ctdthiDTO = new clsCauTrucDeThi_DTO();
loaichoiDAL = new clsLoaiCauHoi_DAL();
loaichoiDTO = new clsLoaiCauHoi_DTO();
lbangDAL = new clsLoaiBanglai_DAL();
lbangDTO = new clsLoaiBanglai_DTO();
cmn = new clsCommon();
if (!IsPostBack || !IsCallback)
{
}
if (!Page.IsPostBack)
{
}
loadMasterData();
if (cboLoaiBang.Value != null)
{
gvCauTrucDeThi.DataSource = loadDataToUI();
gvCauTrucDeThi.DataBind();
}
}
public int InsertUpdate(clsLoaiBanglai_DTO loaibanglaiDTO)
{
try
{
ListDictionary _list = new ListDictionary();
_list.Add("old_id", loaibanglaiDTO.OldID);
_list.Add("MaLoaiBang", loaibanglaiDTO.MaLoaiBang);
_list.Add("TenLoai", loaibanglaiDTO.TenLoai);
_list.Add("MoTa", loaibanglaiDTO.MoTa);
_list.Add("TGThi", loaibanglaiDTO.TGThi);
_list.Add("SoCauDat", loaibanglaiDTO.SoCauDat);
int iReturn = obj.ExcSql("Insert_Update_Loai_Bang_Lai", _list, CommandType.StoredProcedure);
return iReturn;
}
catch (Exception)
{
//return ex.Message;
return -1111; // Đặt số này làm ngoại lệ ko lường trước được. ở StoredProcedure không được return có số này tránh trường hợp trùng
}
}
private void loadMasterData()
{
lblDTO = new clsLoaiBanglai_DTO();
DataTable dt = new DataTable();
dt = lblDAL.getMaLoaibang(lblDTO);
cboLoaiBang.ValueField = "MaLoaiBang";
cboLoaiBang.TextField = "TenLoai";
cboLoaiBang.DataSource = dt;
cboLoaiBang.DataBind();
//GridViewDataComboBoxColumn gcloaibang = gvDotThi.Columns["TenLoai"] as GridViewDataComboBoxColumn;
//gcloaibang.PropertiesComboBox.DataSource = dt;
//gclDiemThi.PropertiesComboBox.ValueField = "MaDienThi";
//gclDiemThi.PropertiesComboBox.TextField = "TenDiemThi";
//GridViewDataCheckColumn gclTrangThai = gvDotThi.Columns["TrangThai"] as GridViewDataCheckColumn;
//gclTrangThai.PropertiesCheckEdit.DisplayTextChecked = "Chon";
}
protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToString(Session["TenDangNhap"]) == "")
Response.Redirect("~/dangnhap.aspx");
lbangDAL = new clsLoaiBanglai_DAL();
lbangDTO = new clsLoaiBanglai_DTO();
cmn = new clsCommon();
gvLoaiBang.DataSource = loadDataToUI();
gvLoaiBang.DataBind();
}
