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;
}
public User GetById(int id)
{
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
return(_mapper.Map(dbcontext.UserDetails.FirstOrDefault(it => it.UserId == id)));
}
throw new Exception("Record not found!");
}
public Division GetById(int id)
{
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
var item = dbcontext.Divisions.FirstOrDefault(it => it.Id == id);
if (item == null)
{
throw new Exception("Not Found");
}
return(_divisionMapper.Map(item));
}
}
public ListQueryResult <Department> GetByQuery(ListQuery <Department> query)
{
var result = new ListQueryResult <Department>();
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
if (query.Parameters != null)
{
foreach (var p in query.Parameters)
{
if (p.Name == "depName")
{
foreach (var item in dbcontext.Divisions.Where(o => o.DivisionName == p.Value).OrderBy(it => it.DivisionName))
{
if (result.Items == null)
{
result.Items = new List <Department>();
}
result.Items.Add(_DepartmentMapper.Map(item));
}
}
else if (p.Name == "DealerDivision")
{
foreach (var item in dbcontext.Divisions.Where(o => o.DivisionName == "CC" || o.DivisionName == "COMMON-RURBAN/EXPORT" || o.DivisionName == "CP - ASF" || o.DivisionName == "CP - MNT" || o.DivisionName == "FV").OrderBy(it => it.DivisionName))
{
if (result.Items == null)
{
result.Items = new List <Department>();
}
result.Items.Add(_DepartmentMapper.Map(item));
}
}
}
}
else
{
foreach (var item in dbcontext.Divisions.OrderBy(it => it.DivisionName))
{
if (result.Items == null)
{
result.Items = new List <Department>();
}
result.Items.Add(_DepartmentMapper.Map(item));
}
}
}
return(result);
}
public ListQueryResult <User> GetByQuery(ListQuery <User> query)
{
var result = new ListQueryResult <User>();
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
var linqQuery = dbcontext.UserDetails.Where(it => it.UserId > 0);
if (query.Parameters != null)
{
foreach (var p in query.Parameters)
{
if (p.Name == "username")
{
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.UserName == p.Value);
}
}
else if (p.Name == "filterText")
{
string val = p.Value;
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.Title.Contains(val) || it.Email.Contains(val));
}
}
}
foreach (var item in linqQuery.Take(query.PageSize).OrderBy(it => it.Title))
{
if (result.Items == null)
{
result.Items = new List <User>();
}
var usr = _mapper.Map(item);
result.Items.Add(usr);
}
}
}
return(result);
}
public ListQueryResult <User> GetByQuery(ListQuery <User> query)
{
var result = new ListQueryResult <User>();
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
var linqQuery = dbcontext.UserDetails.Where(it => it.UserId > 0);
if (query.Parameters != null)
{
foreach (var p in query.Parameters)
{
if (p.Name == "username")
{
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.UserName == p.Value);
}
}
else if (p.Name == "title")
{
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.Title == p.Value);
}
}
else if (p.Name.ToLower() == "dhdivisionid")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DepartmentHeads.Count(g => g.DeparmentId == val) > 0);
}
else if (p.Name.ToLower() == "dodivisionid")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DepartmentOwners.Count(g => g.DeparmentId == val) > 0);
}
else if (p.Name == "ResponsibleUsers")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DivisionId == val);
}
else if (p.Name == "DependentUsers")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DivisionId == val);
}
}
}
foreach (var item in linqQuery)
{
if (result.Items == null)
{
result.Items = new List <User>();
}
var usr = _mapper.Map(item);
result.Items.Add(usr);
}
}
return(result);
}
