public bool DeleteKeyword(int KeywordId) { Ads_Keyword keyword = AdsData.Ads_Keywords.Single( temp => temp.KeywordId == KeywordId); if (keyword != null) { AdsData.Ads_Keywords.DeleteOnSubmit(keyword); AdsData.SubmitChanges(); } return(true); }
public int UpdateKeyword(int KeywordId, string Name) { var query = from key in AdsData.Ads_Keywords where key.Keyword == Name && key.KeywordId != KeywordId select key; if (query.Count() > 0) { return(-1); } Ads_Keyword keyword = AdsData.Ads_Keywords.Single( key => key.KeywordId == KeywordId); keyword.Keyword = Name; AdsData.SubmitChanges(); return(keyword.KeywordId); }