protected void btnSave_Click(object sender, EventArgs e)
{
PhanCongCNDTO dto = new PhanCongCNDTO();
dto.MaGV = Convert.ToInt16(ddlmagv.Text);
dto.MaLop = ddlmalop.Text;
dto.NamHoc = txtnamhoc.Text;
dto.HocKy = Convert.ToInt16(txthk.Text);
bll.SavePCGV(dto);
Clear();
FillGridView();
}
protected void btnSave_Click(object sender, EventArgs e)
{
PhanCongCNDTO dto = new PhanCongCNDTO();
dto.MaGV = Convert.ToInt16(ddlmagv.Text);
dto.MaLop = ddlmalop.Text;
dto.NamHoc = txtnamhoc.Text;
dto.HocKy = Convert.ToInt16(txthk.Text);
bll.SavePCGV(dto);
Clear();
FillGridView();
}
public void SavePCGV(PhanCongCNDTO pc)
{
string sql1 = "insert into PhanCongChuNhiem values(@malop,@namhoc,@hocky,@magv)";
dl.getConn();
SqlCommand cmd = new SqlCommand();
cmd.Connection = ConnectDAL.cnn;
cmd.CommandText = sql1;
cmd.Parameters.AddWithValue("@malop", pc.MaLop);
cmd.Parameters.AddWithValue("@namhoc", pc.NamHoc);
cmd.Parameters.AddWithValue("@hocky", pc.HocKy);
cmd.Parameters.AddWithValue("@magv", pc.MaGV);
cmd.ExecuteNonQuery();
ConnectDAL.cnn.Close();
}
public void SavePCGV(PhanCongCNDTO pc)
{
string sql1 = "insert into PhanCongChuNhiem values(@malop,@namhoc,@hocky,@magv)";
dl.getConn();
SqlCommand cmd = new SqlCommand();
cmd.Connection = ConnectDAL.cnn;
cmd.CommandText = sql1;
cmd.Parameters.AddWithValue("@malop", pc.MaLop);
cmd.Parameters.AddWithValue("@namhoc", pc.NamHoc);
cmd.Parameters.AddWithValue("@hocky", pc.HocKy);
cmd.Parameters.AddWithValue("@magv", pc.MaGV);
cmd.ExecuteNonQuery();
ConnectDAL.cnn.Close();
}
