public List <GetVotingTasksResponse> GetDeveloperSend(SendTaskFromAdminRequest request) { try { using (DDS_Context dbContext = new DDS_Context()) { List <GetVotingTasksResponse> response = new List <GetVotingTasksResponse>(); var entity = dbContext.TempWord.Where(x => x.Status > 2 && x.DeveloperId == request.UserId).ToList(); if (entity != null) { foreach (var item in entity) { GetVotingTasksResponse temp = new GetVotingTasksResponse(); temp.CreatedDate = Convert.ToString(item.CreatedDate); temp.UpdatedDate = Convert.ToString(item.UpdatedDate); temp.WordId = item.Id; temp.Word = item.Word; var userEntity = dbContext.User.FirstOrDefault(x => x.Id == item.UserId); if (userEntity != null) { temp.UserName = userEntity.Name; temp.UserSurname = userEntity.Surname; } else { temp.UserName = "******"; temp.UserSurname = "UNDEFINED"; } var developerEntity = dbContext.User.FirstOrDefault(x => x.Id == item.DeveloperId); if (developerEntity != null) { temp.DeveloperName = developerEntity.Name; temp.DeveloperSurname = developerEntity.Surname; } else { temp.DeveloperName = "UNDEFINED"; temp.DeveloperSurname = "UNDEFINED"; } var interest = dbContext.Interest.FirstOrDefault(x => x.Id == item.InterestId); if (interest != null) { temp.Interest.InerestId = interest.Id; temp.Interest.InterestName = interest.Name; } temp.Content = item.Content; temp.AcceptanceVote = item.AcceptanceVote; temp.RejectionVote = item.RejectionVote; switch (item.Status) { case 3: temp.Status = "Admin Onayı Bekliyor"; break; case 4: temp.Status = "Oylanıyor"; break; case 5: temp.Status = "Admin Tarafından Reddedildi"; break; default: temp.Status = "TANIMLANAMADI"; break; } response.Add(temp); } } var dictionary = dbContext.Dictionary.Where(x => x.DeveloperId == request.UserId).ToList(); if (dictionary != null) { foreach (var item in dictionary) { GetVotingTasksResponse temp = new GetVotingTasksResponse(); temp.CreatedDate = Convert.ToString(item.CreatedDate); temp.UpdatedDate = Convert.ToString(item.UpdatedDate); temp.WordId = item.Id; temp.Word = item.Word; var developerEntity = dbContext.User.FirstOrDefault(x => x.Id == item.DeveloperId); if (developerEntity != null) { temp.DeveloperName = developerEntity.Name; temp.DeveloperSurname = developerEntity.Surname; } else { temp.DeveloperName = "UNDEFINED"; temp.DeveloperSurname = "UNDEFINED"; } var interest = dbContext.Interest.FirstOrDefault(x => x.Id == item.InterestId); if (interest != null) { temp.Interest.InerestId = interest.Id; temp.Interest.InterestName = interest.Name; } temp.Content = item.Content; temp.Status = "Sözlüğe Eklendi"; response.Add(temp); } } response.OrderBy(x => x.UpdatedDate); return(response); } } catch (Exception ex) { throw ex; } }
public List <GetVotingTasksResponse> GetVotingTasks() { try { using (DDS_Context dbContext = new DDS_Context()) { List <GetVotingTasksResponse> response = new List <GetVotingTasksResponse>(); var entity = dbContext.TempWord.Where(x => x.Status == 4).ToList(); if (entity != null) { foreach (var item in entity) { GetVotingTasksResponse temp = new GetVotingTasksResponse(); temp.CreatedDate = Convert.ToString(item.CreatedDate); temp.UpdatedDate = Convert.ToString(item.UpdatedDate); temp.WordId = item.Id; temp.Word = item.Word; var userEntity = dbContext.User.FirstOrDefault(x => x.Id == item.UserId); if (userEntity != null) { temp.UserName = userEntity.Name; temp.UserSurname = userEntity.Surname; } else { temp.UserName = "******"; temp.UserSurname = "UNDEFINED"; } var developerEntity = dbContext.User.FirstOrDefault(x => x.Id == item.DeveloperId); if (developerEntity != null) { temp.DeveloperName = developerEntity.Name; temp.DeveloperSurname = developerEntity.Surname; } else { temp.DeveloperName = "UNDEFINED"; temp.DeveloperSurname = "UNDEFINED"; } var interest = dbContext.Interest.FirstOrDefault(x => x.Id == item.InterestId); if (interest != null) { temp.Interest.InerestId = interest.Id; temp.Interest.InterestName = interest.Name; } temp.Content = item.Content; temp.AcceptanceVote = item.AcceptanceVote; temp.RejectionVote = item.RejectionVote; response.Add(temp); } } response.Reverse(); return(response); } } catch (Exception ex) { throw ex; } }