public DataTable GetDataTable(strc_news newRow)
{
try
{
DataAccessLayer DAL = new DataAccessLayer();
SQLiteCommand scom = new SQLiteCommand("select * from News where Href=@Href");
scom.Parameters.AddWithValue("Href", newRow.Href);
return(DAL.GeneralSelect(scom));
}
catch
{
return(null);
}
}
public bool Insert(strc_news newRow)
{
try
{
DataAccessLayer DAL = new DataAccessLayer();
SQLiteCommand scom = new SQLiteCommand("Insert into News values (@Href,@Page,@Title,@Date,@Classified)");
scom.Parameters.AddWithValue("Href", newRow.Href);
scom.Parameters.AddWithValue("Page", newRow.Page);
scom.Parameters.AddWithValue("Title", newRow.Title);
scom.Parameters.AddWithValue("Date", newRow.Date);
scom.Parameters.AddWithValue("Classified", newRow.Classified);
return(DAL.GeneralCommand(scom));
}
catch
{
return(false);
}
}
