public static DataTable GetFeeds()
{
try
{
using (dsTableAdapters.FeedTableAdapter ta = new dsTableAdapters.FeedTableAdapter())
{
ta.Fill(feeds);
return feeds;
}
}
catch
{
var dr = feeds.GetErrors();
if (dr.Length > 0)
{
Notificator.NotifyMessage(dr[0].RowError);
}
throw;
}
}
public static void DeleteFeed(int feedId)
{
try
{
using (SqlCeConnection conn = new SqlCeConnection(Properties.Settings.Default.nReaderConnectionString))
{
conn.Open();
using(SqlCeTransaction tran = conn.BeginTransaction())
{
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "delete from [Topic] where [FeedId] = @FeedId";
cmd.Parameters.Add(new SqlCeParameter("@FeedId", feedId));
cmd.ExecuteNonQuery();
cmd = conn.CreateCommand();
cmd.CommandText = "delete from [Feed] where [Id] = @FeedId";
cmd.Parameters.Add(new SqlCeParameter("@FeedId", feedId));
cmd.ExecuteNonQuery();
tran.Commit();
}
conn.Close();
}
using (dsTableAdapters.FeedTableAdapter ta = new dsTableAdapters.FeedTableAdapter())
{
ta.Fill(feeds);
}
}
catch
{
var dr = feeds.GetErrors();
if (dr.Length > 0)
{
Notificator.NotifyMessage(dr[0].RowError);
}
throw;
}
}
public static void SaveFeed(ds.FeedRow feed)
{
try
{
using (dsTableAdapters.FeedTableAdapter ta = new dsTableAdapters.FeedTableAdapter())
{
if (feed.Id == 0)
{
feeds.AddFeedRow(feed);
}
ta.Update(feed);
ta.Fill(feeds);
}
}
catch
{
var dr = feeds.GetErrors();
if (dr.Length > 0)
{
Notificator.NotifyMessage(dr[0].RowError);
}
throw;
}
}