public CKTD_TaiKhoan getCKTD_TaiKhoanById(int iD)
{
try
{
CKTD_TaiKhoan CKTD_TaiKhoan = (CKTD_TaiKhoan)session.Get <CKTD_TaiKhoan>(iD);
return(CKTD_TaiKhoan);
}
catch (Exception ex)
{
return(null);
}
}
public void xoaCKTD_TaiKhoan(CKTD_TaiKhoan CKTD_TaiKhoan)
{
sessionManager.BeginTransaction();
try
{
session.Delete(CKTD_TaiKhoan);
sessionManager.CommitTransaction();
}
catch (HibernateException ex)
{
throw new DataException(ex.Message, ex);
}
}
public void themCKTD_TaiKhoan(CKTD_TaiKhoan CKTD_TaiKhoan)
{
sessionManager.BeginTransaction();
try
{
session.Save(CKTD_TaiKhoan);
sessionManager.CommitTransaction();
//session.Close();
}
catch (HibernateException ex)
{
throw new DataException(ex.Message, ex);
}
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
if (nguoidung != null)
{
nguoidung.Ten = txtTenHienThi.Text.Trim();
nguoidung.TaiKhoan = txtTenDangNhap.Text.Trim();
nguoidung.LoaiNguoiDung = int.Parse(ddlLoaiTaiKhoan.SelectedValue);
nguoidung.Role = int.Parse(ddlLoaiTaiKhoan.SelectedValue);
cktd.updateCKTD_TaiKhoan(nguoidung);
}
else
{
nguoidung = new CKTD_TaiKhoan();
nguoidung.Ten = txtTenHienThi.Text.Trim();
nguoidung.TaiKhoan = txtTenDangNhap.Text.Trim();
nguoidung.LoaiNguoiDung = int.Parse(ddlLoaiTaiKhoan.SelectedValue);
nguoidung.Role = int.Parse(ddlLoaiTaiKhoan.SelectedValue);
cktd.themCKTD_TaiKhoan(nguoidung);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Request.QueryString["ID"] != null)
{
int id = 0;
int.TryParse(HttpContext.Current.Request.QueryString["ID"].ToString(), out id);
try
{
nguoidung = cktd.getCKTD_TaiKhoanById(id);
if (!this.IsPostBack)
{
initializeDataInControl();
}
}
catch (Exception ex)
{
nguoidung = null;
}
}
else
{
if (HttpContext.Current.Request.QueryString["TaiKhoan"] != null)
{
string taiKhoan = HttpContext.Current.Request.QueryString["TaiKhoan"].ToString();
try
{
nguoidung = cktd.getCKTD_TaiKhoan("where TaiKhoan=N'" + taiKhoan + "'")[0];
if (!this.IsPostBack)
{
initializeDataInControl();
}
}
catch (Exception ex)
{
nguoidung = null;
}
}
}
}