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.IssueManagementCommentLog Add(Core.Domian.Settings.IssueManagementCommentLog item) { using (var dbcontext = new Sql.InitiativeHubFinalEntities()) { if (item.ID_Comments != null) { var linqquery = dbcontext.IssueManagementCommentLogs.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 && it.ID_Status_Id == item.ID_Status_Id.Id).ToList(); if (linqquery.Count == 0) { var lgdb = dbcontext.IssueManagementCommentLogs.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; f.RUBEmail=item.RCB.Email; f.RUBEmpCode = item.RCB.UserName; f.RUBEmpName=item.RCB.Title; } dbcontext.SaveChanges(); string status = ""; if (item.ID_Status != "" || item.ID_Status != null) { if (item.ID_Status.ToLower() == "in progress") status = "Open"; if (item.ID_Status.ToLower() == "completed") status = "Closed"; } else status = null; dbcontext.IssueManagementCommentLogs.Add(new Sql.IssueManagementCommentLog() { 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, ID_Status = status, Active = true, RCT = DateTime.Now, RCB = item.RCB.Id, ID_Status_Id = item.ID_Status_Id.Id, RCBEmail=item.RCB.Email, RCBEmpCode=item.RCB.UserName, RCBEmpName=item.RCB.Title, UploadFlag=false, }); dbcontext.SaveChanges(); item.RCBEmpCode = item.RCB.UserName; item.RCBEmpName = item.RCB.Title; item.RCBEmail = item.RCB.Email; item.EmailFlag = true; } else { item.EmailFlag = false; } } } return item; }