public Core.Domian.Settings.IssueManagementAnchorComment Add(Core.Domian.Settings.IssueManagementAnchorComment item) { using (var dbcontext = new Sql.InitiativeHubFinalEntities()) { if (item.ID_Comments != null) { var linqquery = dbcontext.IssueManagementAnchorComments.Where(it => it.id_System_Name == item.id_System_Name && it.ID_Request == item.ID_Request && it.ID_Comments == item.ID_Comments && it.ID_Pending_With_Email == item.ID_Pending_With_Email).ToList(); if (linqquery.Count == 0) { var lgdb = dbcontext.IssueManagementAnchorComments.Where(it => it.id_System_Name == item.id_System_Name && it.ID_Request == item.ID_Request && it.ID_Pending_With_Email == item.ID_Pending_With_Email).ToList(); foreach (var f in lgdb) { f.Active = false; f.RUB = item.RCB.Id; f.RUT = DateTime.Now; } dbcontext.SaveChanges(); dbcontext.IssueManagementAnchorComments.Add(new Sql.IssueManagementAnchorComment() { ID_Comments = item.ID_Comments, ID_Request = item.ID_Request, ID_Pending_With_Email = item.ID_Pending_With_Email, id_System_Name = item.id_System_Name, Active = true, RCT = DateTime.Now, RCB = item.RCB.Id, }); dbcontext.SaveChanges(); } } } return(item); }
public Core.Domian.Settings.IssueManagementAnchorComment Update(Core.Domian.Settings.IssueManagementAnchorComment item) { throw new NotImplementedException(); }