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