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