protected void Them_Click(object sender, EventArgs e)
{
try
{
int idMon = int.Parse(ddlMonHoc.SelectedValue);
int idGV = int.Parse(ddlGiangVien.SelectedValue);
string diaDiem = txtDiaDiem.Text;
string ghiChu = txtGhiChu.Text;
if (diaDiem.Trim().Equals(""))
{
msg.Text = "Vui lòng thêm địa điểm giảng dạy.";
return;
}
GV_MonHoc gv_mon = new GV_MonHoc();
gv_mon.id_gv = idGV;
gv_mon.id_mon = idMon;
gv_mon.diadiem = diaDiem;
gv_mon.ghichu = ghiChu;
data.themPC(gv_mon);
msg.Text = "Thành công.";
}catch (Exception ex)
{
msg.Text = "Lỗi: " + ex.Message;
}
}
protected void CapNhat_Click(object sender, EventArgs e)
{
try
{
int maPC = int.Parse(txtMaPC.Text);
int idMon = int.Parse(ddlMonHoc.SelectedValue);
int idGV = int.Parse(ddlGiangVien.SelectedValue);
string diaDiem = txtDiaDiem.Text;
string ghiChu = txtGhiChu.Text;
if (diaDiem.Trim().Equals(""))
{
msg.Text = "Vui lòng thêm địa điểm giảng dạy.";
return;
}
GV_MonHoc gv_mon = new GV_MonHoc();
gv_mon.id = maPC;
gv_mon.id_gv = idGV;
gv_mon.id_mon = idMon;
gv_mon.diadiem = diaDiem;
gv_mon.ghichu = ghiChu;
data.suaPC(gv_mon);
Response.Redirect("PhanCongGiangDay.aspx");
}
catch (Exception ex)
{
msg.Text = "Lỗi: " + ex.Message;
}
}
public List <GV_MonHoc> getDSPhanCongGiangDay()
{
conn.Open();
List <GV_MonHoc> ds = new List <GV_MonHoc>();
string sql = "select GV_MonHoc.id, id_mon, MonHoc.name as 'tenmon',id_gv, GiangVien.name as 'tengv', diadiem, ghichu " +
"from MonHoc inner join GV_MonHoc on MonHoc.id = GV_MonHoc.id_mon " +
"inner join GiangVien on GiangVien.id = GV_MonHoc.id_gv";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
GV_MonHoc gv_mon = new GV_MonHoc();
gv_mon.id = (int)rd["id"];
gv_mon.id_gv = (int)rd["id_gv"];
gv_mon.id_mon = (int)rd["id_mon"];
gv_mon.tengv = (string)rd["tengv"];
gv_mon.tenmon = (string)rd["tenmon"];
gv_mon.diadiem = (string)rd["diadiem"];
gv_mon.ghichu = (string)rd["ghichu"];
ds.Add(gv_mon);
}
conn.Close();
return(ds);
}
public void themPC(GV_MonHoc gv_mon)
{
conn.Open();
String sql = "insert into GV_MonHoc values(@id_gv, @id_mon, @diadiem, @ghichu)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@id_gv", gv_mon.id_gv);
cmd.Parameters.AddWithValue("@id_mon", gv_mon.id_mon);
cmd.Parameters.AddWithValue("@diadiem", gv_mon.diadiem);
cmd.Parameters.AddWithValue("@ghichu", gv_mon.ghichu);
cmd.ExecuteNonQuery();
conn.Close();
}
public void suaPC(GV_MonHoc gv_mon)
{
conn.Open();
string sql = "update GV_MonHoc set id_gv = @id_gv, id_mon = @id_mon, diadiem = @diadiem," +
"ghichu = @ghichu where id = @id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@id_gv", gv_mon.id_gv);
cmd.Parameters.AddWithValue("@id_mon", gv_mon.id_mon);
cmd.Parameters.AddWithValue("@diadiem", gv_mon.diadiem);
cmd.Parameters.AddWithValue("@ghichu", gv_mon.ghichu);
cmd.Parameters.AddWithValue("@id", gv_mon.id);
cmd.ExecuteNonQuery();
conn.Close();
}
public GV_MonHoc get1PC(int id)
{
conn.Open();
GV_MonHoc gv_mon = null;
string sql = "select * from GV_MonHoc where id = " + id;
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
gv_mon = new GV_MonHoc();
gv_mon.id = (int)rd["id"];
gv_mon.id_gv = (int)rd["id_gv"];
gv_mon.id_mon = (int)rd["id_mon"];
gv_mon.diadiem = (string)rd["diadiem"];
gv_mon.ghichu = (string)rd["ghichu"];
}
conn.Close();
return(gv_mon);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GV_MonHoc gv_mon = (GV_MonHoc)Session["GV_MonHoc"];
ddlGiangVien.DataSource = giangVienDB.getDSGiangVien();
ddlGiangVien.DataTextField = "name";
ddlGiangVien.DataValueField = "id";
ddlGiangVien.SelectedValue = gv_mon.id_gv.ToString();
DataBind();
ddlMonHoc.DataSource = monHocDB.getDSMonHoc();
ddlMonHoc.DataTextField = "name";
ddlMonHoc.DataValueField = "id";
ddlMonHoc.SelectedValue = gv_mon.id_mon.ToString();
DataBind();
txtMaPC.Text = gv_mon.id + "";
txtDiaDiem.Text = gv_mon.diadiem;
txtGhiChu.Text = gv_mon.ghichu;
}
}
