public void DeleteComment(DataModels.iteam_comment m, ref string error)
{
using (var db = new DataContext())
{
db.ExecuteTransaction(() =>
{
var itemno = m?.itemno;
var task_id = m?.task_id;
//var data = db.iteam_comment.Where(x => x.itemno == itemno && x.task_id == task_id).ToList();
//throw new Exception(Newtonsoft.Json.JsonConvert.SerializeObject(data));
db.iteam_comment.RemoveRange(db.iteam_comment.Where(x => x.itemno == itemno && x.task_id == task_id).ToList());
db.SaveChanges();
}, ref error);
}
}
public void NewComment(DataModels.iteam_comment header, ref string error)
{
using (var db = new DataContext())
{
db.ExecuteTransaction(() =>
{
var comment = header?.comment;
var task_id = header?.task_id;
if (string.IsNullOrEmpty(comment))
{
throw new Exception("โปรดกรอกข้อความก่อนส่ง");
}
header.itemno = (db.iteam_comment.Where(x => x.task_id == task_id).Select(x => x.itemno).Max() ?? 0) + 1;
header.add_dt = DateTime.Now;
header.add_user = auth.user_id;
db.iteam_comment.Add(header);
db.SaveChanges();
}, ref error);
}
}
