internal int InsertNews(string title,string body, DateTime timeAdd,string category)
{
int result = -1;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.NewsTableAdapter adap = new DSTableAdapters.NewsTableAdapter();
try
{
adap.Connection = conn;
conn.Open();
result = int.Parse(adap.InsertNews(title, body, timeAdd, category).ToString());
}
catch (Exception ex)
{
result = -1;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return result;
}
internal List<Business.News> GetTopNews()
{
List<Business.News> result = new List<Business.News>();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.NewsTableAdapter adap = new DSTableAdapters.NewsTableAdapter();
try
{
conn.Open();
adap.Connection = conn;
result = this.MapNews(adap.GetTopNews(10));
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return result;
}
