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