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