/// <summary>
/// NewsData存入至資料庫中，存入前檢查是否重複
/// </summary>
/// <param name="InsertNewData"></param>
public void InsertNewsData(News InsertNewData)
{
using (News_DatabaseEntities _nDB = new News_DatabaseEntities())
{
NewsDataDB newsDataDB = new NewsDataDB
{
Id = InsertNewData.Id,
Time = InsertNewData.Time,
Types = (InsertNewData.Types.Length > 10) ? InsertNewData.Types.Substring(0, 2) : InsertNewData.Types,
Head = (string.IsNullOrEmpty(InsertNewData.Head)) ? null : InsertNewData.Head,
Links = (string.IsNullOrEmpty(InsertNewData.Links)) ? null : InsertNewData.Links,
Content = (string.IsNullOrEmpty(InsertNewData.Content)) ? null : InsertNewData.Content
};
try
{
if (!_nDB.NewsDataDB.Any(b => b.Links == newsDataDB.Links))
{
_nDB.NewsDataDB.Add(newsDataDB);
_nDB.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
}
/// <summary>
/// 政治人物名單寫入
/// </summary>
/// <param name="politician"></param>
public void InsertPolitician(Politician politician)
{
using (News_DatabaseEntities _nDB = new News_DatabaseEntities())
{
PoliticianTable _politician = new PoliticianTable
{
//ID取Key值
Id = Guid.NewGuid(),
Name = politician.Name,
Amount = politician.Amount,
};
try
{
if (!_nDB.PoliticianTable.Any(b => b.Name == _politician.Name))
{
_nDB.PoliticianTable.Add(_politician);
_nDB.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
}
/// <summary>
/// 依據ID進行Select
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public News SelectNewsById(Guid ID)
{
using (News_DatabaseEntities _nDB = new News_DatabaseEntities())
{
if (_nDB.NewsDataDB.Any(b => b.Id == ID))
{
var result = _nDB.NewsDataDB.Where(b => b.Id == ID).Single();
News news = new News()
{
Id = result.Id,
Time = result.Time,
Types = result.Types,
Head = result.Head,
Links = result.Links,
Content = result.Content
};
return(news);
}
else
{
return(null);
}
}
}
/// <summary>
/// 至資料庫取出所有NewsData資料
/// </summary>
/// <returns></returns>
public List <News> SelectAllNews()
{
List <News> results = null;
using (News_DatabaseEntities _nDB = new News_DatabaseEntities())
{
try
{
results = (from DB in _nDB.NewsDataDB
select new News
{
Id = DB.Id,
Time = DB.Time,
Types = DB.Types,
Head = DB.Head,
Links = DB.Links,
Content = DB.Content
}).ToList();
//results = _nDB.NewsDataDB.Select( row => row ).ToList();
return(results);
}
catch (Exception)
{
throw;
}
}
}
/// <summary>
/// 政治人物名單取出
/// </summary>
/// <returns></returns>
public List <Politician> SelectAllPolitician()
{
List <Politician> results = null;
using (News_DatabaseEntities _nDB = new News_DatabaseEntities())
{
try
{
results = (from DB in _nDB.PoliticianTable
select new Politician
{
Id = DB.Id,
Name = DB.Name,
Amount = DB.Amount
}).ToList();
//results = _nDB.NewsDataDB.Select( row => row ).ToList();
return(results);
}
catch (Exception)
{
throw;
}
}
}
/// <summary>
/// 依據NewsData的ID進行更新資料作業
/// (目前未使用)
/// </summary>
/// <param name="updatanews"></param>
public void UpdataNewsData(News updatanews)
{
using (News_DatabaseEntities _nDB = new News_DatabaseEntities())
{
if (_nDB.NewsDataDB.Any(d => d.Id == updatanews.Id))
{
var DB_News = _nDB.NewsDataDB.Where(d => d.Id == updatanews.Id).Single();
DB_News.Id = updatanews.Id;
DB_News.Time = updatanews.Time;
DB_News.Types = updatanews.Types;
DB_News.Head = updatanews.Head;
DB_News.Links = updatanews.Links;
DB_News.Content = updatanews.Content;
try
{
_nDB.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
}
/// <summary>
/// 刪除人物
/// </summary>
public void RemovePolitician(Guid ID)
{
using (News_DatabaseEntities _nDB = new News_DatabaseEntities())
{
if (_nDB.PoliticianTable.Any(d => d.Id == ID))
{
var DB_Politician = _nDB.PoliticianTable.Where(d => d.Id == ID).Single();
try
{
_nDB.PoliticianTable.Remove(DB_Politician);
_nDB.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
}
/// <summary>
/// 更新政治人物名單
/// </summary>
/// <param name="politician"></param>
public void UpdataPolitician(Politician politician)
{
using (News_DatabaseEntities _nDB = new News_DatabaseEntities())
{
if (_nDB.PoliticianTable.Any(d => d.Id == politician.Id))
{
var DB_News = _nDB.PoliticianTable.Where(d => d.Id == politician.Id).Single();
DB_News.Id = politician.Id;
DB_News.Name = politician.Name;
DB_News.Amount = politician.Amount;
try
{
_nDB.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
}
