/// <summary>
/// Lấy DS Chủ Đề
/// Created by : Anh Vũ
/// Date : 5/5/2011
/// Edited by : Thu Hà
/// Date : 8/5/2011
/// </summary>
/// <param name="chuDe"> </param>
/// <returns>DataTable dtDSHopDong</returns>
public static List<ChuDe> LayDSChuDe()
{
List<ChuDe> lstDSChuDe = new List<ChuDe>();
DataTable dtDSChuDe = new DataTable();
try
{
dtDSChuDe = SqlDataAccessHelper.ExecuteQuery("spLayDSChuDe");
foreach (DataRow dtRow in dtDSChuDe.Rows)
{
ChuDe chuDe = new ChuDe();
chuDe.intMaChuDe = int.Parse(dtRow["MaChuDe"].ToString());
chuDe.strTenChuDe = dtRow["TenChuDe"].ToString();
chuDe.intDaXoa = int.Parse(dtRow["DaXoa"].ToString());
lstDSChuDe.Add(chuDe);
}
}
catch (Exception ex)
{
throw ex;
}
return lstDSChuDe;
//return dtDSChuDe;
}
/// <summary>
/// Thêm Chủ Đề
/// Created by : Anh Vũ
/// Date : 5/5/2011
/// </summary>
/// <param name="chuDe"> </param>
/// <returns>1 : 0</returns>
public static int ThemChuDe(ChuDe chuDe)
{
int res = 0;
try
{
List<SqlParameter> lstParameters = new List<SqlParameter>();
lstParameters.Add(new SqlParameter("@tenchude", chuDe.TenChuDe));
res = SqlDataAccessHelper.ExecuteNoneQuery("spThemChuDe", lstParameters);
}
catch (Exception ex)
{
throw ex;
}
return res;
}