public bool insertNews(TinTucDTO tinTucDTO)
{
string sql = "INSERT INTO TinTuc VALUES ('" + tinTucDTO.MaTinTuc + "',N'" + tinTucDTO.TieuDe
+ "',N'" + tinTucDTO.NoiDung + "','" + tinTucDTO.HinhAnh + "','" + tinTucDTO.NgayViet + "')";
return(da.ExcuteNonQuerry(sql));
}
public bool updateNews(TinTucDTO tinTuc)
{
string sql = "UPDATE TinTuc set TieuDe=N'" + tinTuc.TieuDe + "', NoiDung = N'" + tinTuc.NoiDung + "', HinhAnh='" + tinTuc.HinhAnh +
"', NgayViet='" + tinTuc.NgayViet.ToString("MM/dd/yyyy HH:mm") + "' WHERE MaTinTuc='" + tinTuc.MaTinTuc + "'";
return(da.ExcuteNonQuerry(sql));
}
protected void btnThem_Click(object sender, EventArgs e)
{
TinTucDTO a = new TinTucDTO(txtTieuDe.Text, FileUpload1.FileName, txtTomTat.Text);
aBUS.InsertTinTuc(a);
SaveFileUpload();
Response.Write("<script> alert('Thêm Thành Công');</script>");
}
public void InsertTinTuc(TinTucDTO a)
{
string sql = "insert into TinTuc(TieuDe,HinhAnhBia,TomTat) values(N'" + a.TieuDe + "','" + "~/images/tintuc/" + a.HinhAnh + "',N'" + a.TomTat + "')";
aDAL.ExcuteNonQuery(sql);
}
