protected void btnEdit_Click(object sender, EventArgs e) { GiaovienDTO gv = new GiaovienDTO(); gv.MaGV = Convert.ToInt16(txtmagv.Text); gv.HotenGV = txthotengv.Text; gv.Ngaysinh = Convert.ToDateTime(txtns.Text); gv.Taikhoan = txttaikhoan.Text; bll.EditGiaovien(gv); ClearTextbox(); FillGridView(); }
public void EditGiaovien(GiaovienDTO gv) { string sql2 = "update GiaoVien set HoTenGV=@hotengv, ngaysinh=@ngaysinh where MaGV=@magv"; dl.getConn(); SqlCommand cmd = new SqlCommand(); cmd.Connection = ConnectDAL.cnn; cmd.CommandText = sql2; cmd.Parameters.AddWithValue("@magv", gv.MaGV); cmd.Parameters.AddWithValue("@hotengv", gv.HotenGV); cmd.Parameters.AddWithValue("@ngaysinh", gv.Ngaysinh); cmd.ExecuteNonQuery(); ConnectDAL.cnn.Close(); }
public void SaveGiaovien(GiaovienDTO gv) { string sql1 = "insert into GiaoVien values(@hoten,@ngaysinh,@cn,@taikhoan)"; dl.getConn(); SqlCommand cmd = new SqlCommand(); cmd.Connection = ConnectDAL.cnn; cmd.CommandText = sql1; cmd.Parameters.AddWithValue("@hoten", gv.HotenGV); cmd.Parameters.AddWithValue("@ngaysinh", gv.Ngaysinh); cmd.Parameters.AddWithValue("@cn", gv.Chunhiem); cmd.Parameters.AddWithValue("@taikhoan", gv.Taikhoan); cmd.ExecuteNonQuery(); ConnectDAL.cnn.Close(); }
protected void btnSave_Click(object sender, EventArgs e) { NguoiDungDTO nd = new NguoiDungDTO(); nd.Taikhoan = txttaikhoan.Text; nd.Matkhau = "123456".ToString(); nd.Quyen = "giaovien".ToString(); nd.CauhoiBM = ""; nd.Traloi = ""; bllnd.SaveNguoidung(nd); GiaovienDTO gv = new GiaovienDTO(); gv.HotenGV = txthotengv.Text; gv.Ngaysinh = Convert.ToDateTime(txtns.Text); gv.Chunhiem = false; gv.Taikhoan = txttaikhoan.Text; bll.SaveGiaovien(gv); ClearTextbox(); FillGridView(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillGridView(); if (Request.QueryString["action"] != null) { txttaikhoan.Enabled = false; string action = Request.QueryString["action"]; int magv = Convert.ToInt16(Request.QueryString["MaGV"]); GiaovienDTO gv = bll.GetAGV(magv); txtmagv.Text = Convert.ToString(gv.MaGV); txthotengv.Text = gv.HotenGV.ToString(); txtns.Text = Convert.ToString(gv.Ngaysinh); txttaikhoan.Text = gv.Taikhoan.ToString(); } } }
public GiaovienDTO GetAGV(int magv) { dl.getConn(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select * from GiaoVien where MaGV=@magv"; cmd.Connection = ConnectDAL.cnn; cmd.Parameters.AddWithValue("@magv", magv); SqlDataReader rd = cmd.ExecuteReader(); GiaovienDTO gv = new GiaovienDTO(); if (rd.Read()) { gv.MaGV = Convert.ToInt16(rd["MaGV"]); gv.HotenGV = Convert.ToString(rd["HoTenGV"]); gv.Ngaysinh = Convert.ToDateTime(rd["NgaySinh"]); gv.Chunhiem = Convert.ToBoolean(rd["ChuNhiem"]); gv.Taikhoan = Convert.ToString(rd["TaiKhoan"]); } ConnectDAL.cnn.Close(); return gv; }
public GiaovienDTO GetAGV(int magv) { dl.getConn(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select * from GiaoVien where MaGV=@magv"; cmd.Connection = ConnectDAL.cnn; cmd.Parameters.AddWithValue("@magv", magv); SqlDataReader rd = cmd.ExecuteReader(); GiaovienDTO gv = new GiaovienDTO(); if (rd.Read()) { gv.MaGV = Convert.ToInt16(rd["MaGV"]); gv.HotenGV = Convert.ToString(rd["HoTenGV"]); gv.Ngaysinh = Convert.ToDateTime(rd["NgaySinh"]); gv.Chunhiem = Convert.ToBoolean(rd["ChuNhiem"]); gv.Taikhoan = Convert.ToString(rd["TaiKhoan"]); } ConnectDAL.cnn.Close(); return(gv); }