protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToString(Session["TenDangNhap"]) == "")
{
Response.Redirect("~/dangnhap.aspx");
}
ndungDAL = new clsNguoiDung_DAL();
ndungDTO = new clsNguoiDung_DTO();
dthiDAL = new clsDiaDiemThi_DAL();
dthiDTO = new clsDiaDiemThi_DTO();
nhomNDDAL = new clsNhomNguoiDung_DAL();
nhomNDDTO = new clsNhomNguoiDung_DTO();
cmn = new clsCommon();
loadMasterData();
if (cboDienThi.Value != null)
{
//dotthiDTO.MaLoaiBang = cboLoaiBang.Value.ToString();
ndungDTO.MaDiemThi = cboDienThi.Value.ToString();
gvNguoiDung.DataSource = loadDataToUI();
gvNguoiDung.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
diemthiDAL = new clsDiaDiemThi_DAL();
diemthiDTO = new clsDiaDiemThi_DTO();
DataTable dt = new DataTable();
dt = diemthiDAL.getDiaDiemThi(diemthiDTO);
gvDienThi.DataSource = dt;
gvDienThi.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
diemthiDAL = new clsDiaDiemThi_DAL();
diemthiDTO = new clsDiaDiemThi_DTO();
DataTable dt = new DataTable();
dt = diemthiDAL.getDiaDiemThi(diemthiDTO);
gvDienThi.DataSource = dt;
gvDienThi.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToString(Session["TenDangNhap"]) == "")
{
Response.Redirect("~/dangnhap.aspx");
}
dthiDAL = new clsDiaDiemThi_DAL();
dthiDTO = new clsDiaDiemThi_DTO();
cmn = new clsCommon();
gvDiaDiemThi.DataSource = loadDataToUI();
gvDiaDiemThi.DataBind();
}
public int Delete(clsDiaDiemThi_DTO diemthiDTO)
{
try
{
ListDictionary _list = new ListDictionary();
_list.Add("MaDiemThi", diemthiDTO.MaDiemThi);
int iReturn = obj.ExcSql("Delete_Dia_Diem_Thi", _list, CommandType.StoredProcedure);
return(iReturn);
}
catch (Exception)
{
//return ex.Message;
return(-1111);
}
}
public int Delete(clsDiaDiemThi_DTO diemthiDTO)
{
try
{
ListDictionary _list = new ListDictionary();
_list.Add("MaDiemThi", diemthiDTO.MaDiemThi);
int iReturn = obj.ExcSql("Delete_Dia_Diem_Thi", _list, CommandType.StoredProcedure);
return iReturn;
}
catch (Exception)
{
//return ex.Message;
return -1111;
}
}
public DataTable getDiaDiemThi(clsDiaDiemThi_DTO diemthiDTO)
{
ListDictionary _list = new ListDictionary();
_list.Add("MaDiemThi", diemthiDTO.MaDiemThi);
_list.Add("DiaChi", diemthiDTO.DiaChi);
_list.Add("SoDienThoai", diemthiDTO.SoDienThoai);
_list.Add("NgayThanhLap", diemthiDTO.NgayThanhLap);
DataTable dt = new DataTable();
try
{
dt = obj.GetDataTable("Select_Dia_Diem_Thi", _list, CommandType.StoredProcedure);
}
catch
{
dt = null;
}
return dt;
}
public int InsertUpdate(clsDiaDiemThi_DTO diemthiDTO)
{
try
{
ListDictionary _list = new ListDictionary();
_list.Add("old_id", diemthiDTO.OldID);
_list.Add("MaDiemThi", diemthiDTO.MaDiemThi);
_list.Add("DiaChi", diemthiDTO.DiaChi);
_list.Add("SoDienThoai", diemthiDTO.SoDienThoai);
_list.Add("NgayThanhLap", diemthiDTO.NgayThanhLap);
int iReturn = obj.ExcSql("Insert_Update_Dia_Diem_Thi", _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
}
}
public int InsertUpdate(clsDiaDiemThi_DTO diemthiDTO)
{
try
{
ListDictionary _list = new ListDictionary();
_list.Add("old_id", diemthiDTO.OldID);
_list.Add("MaDiemThi", diemthiDTO.MaDiemThi);
_list.Add("DiaChi", diemthiDTO.DiaChi);
_list.Add("SoDienThoai", diemthiDTO.SoDienThoai);
_list.Add("NgayThanhLap", diemthiDTO.NgayThanhLap);
int iReturn = obj.ExcSql("Insert_Update_Dia_Diem_Thi", _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
}
}
public DataTable getDiaDiemThi(clsDiaDiemThi_DTO diemthiDTO)
{
ListDictionary _list = new ListDictionary();
_list.Add("MaDiemThi", diemthiDTO.MaDiemThi);
_list.Add("DiaChi", diemthiDTO.DiaChi);
_list.Add("SoDienThoai", diemthiDTO.SoDienThoai);
_list.Add("NgayThanhLap", diemthiDTO.NgayThanhLap);
DataTable dt = new DataTable();
try
{
dt = obj.GetDataTable("Select_Dia_Diem_Thi", _list, CommandType.StoredProcedure);
}
catch
{
dt = null;
}
return(dt);
}
private void loadMasterData()
{
dthiDTO = new clsDiaDiemThi_DTO();
DataTable dt = new DataTable();
dt = dthiDAL.getDiaDiemThi(dthiDTO);
cboDiemThi.ValueField = "MaDiemThi";
cboDiemThi.TextField = "DiaChi";
cboDiemThi.DataSource = dt;
cboDiemThi.DataBind();
//GridViewDataComboBoxColumn gclDiemThi = gvPhongThi.Columns["DiaChi"] as GridViewDataComboBoxColumn;
//gclDiemThi.PropertiesComboBox.DataSource = dt;
//gclDiemThi.PropertiesComboBox.ValueField = "MaDienThi";
//gclDiemThi.PropertiesComboBox.TextField = "TenDiemThi";
GridViewDataCheckColumn gclTrangThai = gvPhongThi.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");
dthiDAL = new clsDiaDiemThi_DAL();
dthiDTO = new clsDiaDiemThi_DTO();
cmn = new clsCommon();
gvDiaDiemThi.DataSource = loadDataToUI();
gvDiaDiemThi.DataBind();
}
private void loadMasterData()
{
dthiDTO = new clsDiaDiemThi_DTO();
DataTable dt = new DataTable();
dt = dthiDAL.getDiaDiemThi(dthiDTO);
cboDiemThi.ValueField = "MaDiemThi";
cboDiemThi.TextField = "DiaChi";
cboDiemThi.DataSource = dt;
cboDiemThi.DataBind();
//GridViewDataComboBoxColumn gclDiemThi = gvPhongThi.Columns["DiaChi"] as GridViewDataComboBoxColumn;
//gclDiemThi.PropertiesComboBox.DataSource = dt;
//gclDiemThi.PropertiesComboBox.ValueField = "MaDienThi";
//gclDiemThi.PropertiesComboBox.TextField = "TenDiemThi";
GridViewDataCheckColumn gclTrangThai = gvPhongThi.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");
ndungDAL = new clsNguoiDung_DAL();
ndungDTO = new clsNguoiDung_DTO();
dthiDAL = new clsDiaDiemThi_DAL();
dthiDTO = new clsDiaDiemThi_DTO();
nhomNDDAL = new clsNhomNguoiDung_DAL();
nhomNDDTO = new clsNhomNguoiDung_DTO();
cmn = new clsCommon();
loadMasterData();
if (cboDienThi.Value != null)
{
//dotthiDTO.MaLoaiBang = cboLoaiBang.Value.ToString();
ndungDTO.MaDiemThi = cboDienThi.Value.ToString();
gvNguoiDung.DataSource = loadDataToUI();
gvNguoiDung.DataBind();
}
}
