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);
}
}
