public ThongBao layThongBao_Tu_GUI()
{
ThongBao thongbao = new ThongBao();
thongbao.TenThongBao = tbxTenThongBao.Text;
thongbao.NoiDungThongBao = tbxNoiDungThongBao.Text;
thongbao.NgayThongBao = dtNgayThongBao.Value;
return thongbao;
}
////private ThongBao GetDataFromDataRow(DataTable dt, int i)
////{
//// ThongBao TB = new ThongBao();
//// TB.MaThongBao = Convert.ToInt32(dt.Rows[i]["maThongBao"].ToString());
//// TB.TenThongBao = dt.Rows[i]["tenThongBao"].ToString();
//// TB.NoiDungThongBao = dt.Rows[i]["noiDungThongBao"].ToString();
//// return TB;
////}
protected override object createObjectFromDatarow(DataRow row)
{
ThongBao TB = new ThongBao();
TB.MaThongBao = Convert.ToInt32(row["maThongBao"].ToString());
TB.TenThongBao = row["tenThongBao"].ToString();
TB.NoiDungThongBao = row["noiDungThongBao"].ToString();
return TB;
}
private ThongBao GetDataFromDataRow(DataTable dt, int i)
{
ThongBao TB = new ThongBao();
TB.MaThongBao = Convert.ToInt32(dt.Rows[i]["maThongBao"].ToString());
TB.TenThongBao = dt.Rows[i]["tenThongBao"].ToString();
TB.NoiDungThongBao = dt.Rows[i]["noiDungThongBao"].ToString();
return TB;
}
public void taoThongBao_DAO(ThongBao thongbao)
{
string name_Proc_TaoThongBao = "sp_taoThongBao";
SqlParameter para1 = new SqlParameter("@tenThongBao", thongbao.TenThongBao);
SqlParameter para2 = new SqlParameter("@noiDungThongBao", thongbao.NoiDungThongBao);
SqlParameter para3 = new SqlParameter("@ngayThongBao", thongbao.NgayThongBao);
DataProvider.executeStoreProcedureQuery(name_Proc_TaoThongBao, para1,para2,para3);
}
public ThongBao[] getAllNews()
{
string strSql = "SELECT * FROM ThongBao";
DataTable dt = DataProvider.executeQuery(strSql);
int n = dt.Rows.Count;
ThongBao[] allNews = new ThongBao[n];
for (int i = 0; i < n; i++)
{
ThongBao TB = GetDataFromDataRow(dt, i);
allNews[i] = TB;
}
return allNews;
}
public ThongBao[] layDanhSachThongBao_Tu_bang(DataTable bangThongBao)
{
ThongBao[] dsThongBao = new ThongBao[bangThongBao.Rows.Count];
for (int i = 0; i < bangThongBao.Rows.Count; i++)
{
ThongBao tb = new ThongBao();
tb.MaThongBao = Convert.ToInt32(bangThongBao.Rows[i]["maThongBao"]);
tb.TenThongBao = bangThongBao.Rows[i]["tenThongBao"].ToString();
tb.NgayThongBao = Convert.ToDateTime(bangThongBao.Rows[i]["ngayThongBao"]);
tb.NoiDungThongBao = bangThongBao.Rows[i]["noiDungThongBao"].ToString();
dsThongBao[i] = tb;
}
return dsThongBao;
}
public void taoThongBao_BUS(ThongBao thongbao)
{
thongbao_DAO.taoThongBao_DAO(thongbao);
}
