protected void btnEdit_Click(object sender, EventArgs e)
{
ThongBaoDTO tb = new ThongBaoDTO();
tb.MaTB = Convert.ToInt16(txtmatb.Text);
tb.NgayTB = Convert.ToDateTime(txtntb.Text);
tb.TenTB = txttentb.Text;
tb.NoiDung = txtnd.Text;
bll.EditThongBao(tb);
ClearTextbox();
FillGridView();
}
protected void btnSave_Click(object sender, EventArgs e)
{
ThongBaoDTO tb = new ThongBaoDTO();
tb.MaTB = Convert.ToInt16(txtmatb.Text);
tb.NgayTB = Convert.ToDateTime(txtntb.Text);
tb.TenTB = txttentb.Text;
tb.NoiDung = txtnd.Text;
tb.TaiKhoan = Session["idlogin"].ToString();
bll.SaveThongBao(tb);
ClearTextbox();
FillGridView();
}
protected void btnEdit_Click(object sender, EventArgs e)
{
ThongBaoDTO tb = new ThongBaoDTO();
tb.MaTB = Convert.ToInt16(txtmatb.Text);
tb.NgayTB = Convert.ToDateTime(txtntb.Text);
tb.TenTB = txttentb.Text;
tb.NoiDung = txtnd.Text;
bll.EditThongBao(tb);
ClearTextbox();
FillGridView();
}
protected void btnSave_Click(object sender, EventArgs e)
{
ThongBaoDTO tb = new ThongBaoDTO();
tb.MaTB = Convert.ToInt16(txtmatb.Text);
tb.NgayTB = Convert.ToDateTime(txtntb.Text);
tb.TenTB = txttentb.Text;
tb.NoiDung = txtnd.Text;
tb.TaiKhoan = Session["idlogin"].ToString();
bll.SaveThongBao(tb);
ClearTextbox();
FillGridView();
}
public void EditThongBao(ThongBaoDTO tb)
{
string sql2 = "update ThongBao set NgayTB=@ngaytb, TenTB=@tentb, NoiDung=@nd where MaTB=@matb";
dl.getConn();
SqlCommand cmd = new SqlCommand();
cmd.Connection = ConnectDAL.cnn;
cmd.CommandText = sql2;
cmd.Parameters.AddWithValue("@matb", tb.MaTB);
cmd.Parameters.AddWithValue("@ngaytb", tb.NgayTB);
cmd.Parameters.AddWithValue("@tentb", tb.TenTB);
cmd.Parameters.AddWithValue("@nd", tb.NoiDung);
cmd.ExecuteNonQuery();
ConnectDAL.cnn.Close();
}
public void SaveThongBao(ThongBaoDTO tb)
{
string sql1 = "insert into ThongBao values(@matb,@ngaytb,@tentb,@nd,@taikhoan)";
dl.getConn();
SqlCommand cmd = new SqlCommand();
cmd.Connection = ConnectDAL.cnn;
cmd.CommandText = sql1;
cmd.Parameters.AddWithValue("@matb", tb.MaTB);
cmd.Parameters.AddWithValue("@ngaytb", tb.NgayTB);
cmd.Parameters.AddWithValue("@tentb", tb.TenTB);
cmd.Parameters.AddWithValue("@nd", tb.NoiDung);
cmd.Parameters.AddWithValue("@taikhoan", tb.TaiKhoan);
cmd.ExecuteNonQuery();
ConnectDAL.cnn.Close();
}
public void EditThongBao(ThongBaoDTO tb)
{
string sql2 = "update ThongBao set NgayTB=@ngaytb, TenTB=@tentb, NoiDung=@nd where MaTB=@matb";
dl.getConn();
SqlCommand cmd = new SqlCommand();
cmd.Connection = ConnectDAL.cnn;
cmd.CommandText = sql2;
cmd.Parameters.AddWithValue("@matb", tb.MaTB);
cmd.Parameters.AddWithValue("@ngaytb", tb.NgayTB);
cmd.Parameters.AddWithValue("@tentb", tb.TenTB);
cmd.Parameters.AddWithValue("@nd", tb.NoiDung);
cmd.ExecuteNonQuery();
ConnectDAL.cnn.Close();
}
public void SaveThongBao(ThongBaoDTO tb)
{
string sql1 = "insert into ThongBao values(@matb,@ngaytb,@tentb,@nd,@taikhoan)";
dl.getConn();
SqlCommand cmd = new SqlCommand();
cmd.Connection = ConnectDAL.cnn;
cmd.CommandText = sql1;
cmd.Parameters.AddWithValue("@matb", tb.MaTB);
cmd.Parameters.AddWithValue("@ngaytb", tb.NgayTB);
cmd.Parameters.AddWithValue("@tentb", tb.TenTB);
cmd.Parameters.AddWithValue("@nd", tb.NoiDung);
cmd.Parameters.AddWithValue("@taikhoan", tb.TaiKhoan);
cmd.ExecuteNonQuery();
ConnectDAL.cnn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FillGridView();
if (Request.QueryString["action"] != null)
{
txtmatb.Enabled = false;
string action = Request.QueryString["action"];
int matb = Convert.ToInt16(Request.QueryString["MaTB"]);
ThongBaoDTO tb = bll.GetATB(matb);
txtmatb.Text = Convert.ToString(tb.MaTB);
txtntb.Text = Convert.ToString(tb.NgayTB);
txttentb.Text = Convert.ToString(tb.TenTB);
txtnd.Text = Convert.ToString(tb.NoiDung);
}
}
}
public ThongBaoDTO GetATB(int matb)
{
dl.getConn();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from ThongBao where MaTB=@matb";
cmd.Connection = ConnectDAL.cnn;
cmd.Parameters.AddWithValue("@matb", matb);
SqlDataReader rd = cmd.ExecuteReader();
ThongBaoDTO tb = new ThongBaoDTO();
if (rd.Read())
{
tb.MaTB = Convert.ToInt16(rd["MaTB"]);
tb.NgayTB = Convert.ToDateTime(rd["NgayTB"]);
tb.TenTB = Convert.ToString(rd["TenTB"]);
tb.NoiDung = Convert.ToString(rd["NoiDung"]);
tb.TaiKhoan = Convert.ToString(rd["TaiKhoan"]);
}
ConnectDAL.cnn.Close();
return tb;
}
public ThongBaoDTO GetATB(int matb)
{
dl.getConn();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from ThongBao where MaTB=@matb";
cmd.Connection = ConnectDAL.cnn;
cmd.Parameters.AddWithValue("@matb", matb);
SqlDataReader rd = cmd.ExecuteReader();
ThongBaoDTO tb = new ThongBaoDTO();
if (rd.Read())
{
tb.MaTB = Convert.ToInt16(rd["MaTB"]);
tb.NgayTB = Convert.ToDateTime(rd["NgayTB"]);
tb.TenTB = Convert.ToString(rd["TenTB"]);
tb.NoiDung = Convert.ToString(rd["NoiDung"]);
tb.TaiKhoan = Convert.ToString(rd["TaiKhoan"]);
}
ConnectDAL.cnn.Close();
return(tb);
}
