public void DeleteNews(DataModels.iteam_news m, ref string error) { using (var db = new DataContext()) { db.ExecuteTransaction(() => { var news_id = m?.news_id; db.iteam_news.RemoveRange(db.iteam_news.Where(x => x.news_id == news_id).ToList()); db.iteam_upload_pic.RemoveRange(db.iteam_upload_pic.Where(x => x.news_id == news_id)).ToList(); db.SaveChanges(); }, ref error); } }
public void CreateNews(DataModels.iteam_news data, ref string error) { using (var db = new DataContext()) { db.ExecuteTransaction(() => { var news_name = data?.news_name; var news_des = data?.news_des; if (string.IsNullOrEmpty(news_name) && string.IsNullOrEmpty(news_des)) { throw new Exception("โปรดกรอกข้อความก่อนส่ง"); } data.add_date = DateTime.Now; data.add_user = auth.user_id; db.iteam_news.Add(data); db.SaveChanges(); }, ref error); } }