public List <GetDeveloperTasksResponse> GetDeveloperTask(int developerId)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
List <GetDeveloperTasksResponse> response = new List <GetDeveloperTasksResponse>();
var entity = dbContext.TempWord.Where(x => x.Status == 2 && x.DeveloperId == developerId).ToList();
if (entity != null)
{
foreach (var item in entity)
{
GetDeveloperTasksResponse temp = new GetDeveloperTasksResponse();
temp.Id = item.Id;
temp.Word = item.Word;
temp.CreatedDate = Convert.ToString(item.CreatedDate);
temp.UpdatedDate = Convert.ToString(item.UpdatedDate);
response.Add(temp);
}
}
response.Reverse();
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public BaseResponse WordRejectedByAdmin(AssignWordToDeveloperRequest request)
{
try
{
BaseResponse response = new BaseResponse();
using (DDS_Context dbContext = new DDS_Context())
{
TempWord wordEntity = new TempWord();
wordEntity = dbContext.TempWord.FirstOrDefault(x => x.Id == request.WordId);
if (wordEntity == null)
{
response.IsSucceed = false;
response.Message = "Bir Hata Oluştu, Reddetme Başarısız.";
}
else
{
wordEntity.Status = 5; /*Status=AdminRejected*/
wordEntity.UpdatedDate = DateTime.Now;
dbContext.SaveChanges();
response.IsSucceed = true;
response.Message = "Kelime Reddedildi.";
}
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public BaseResponse AddInterest(AddInterestRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
Dictionary_Development_System_Data.Interest temp = new Dictionary_Development_System_Data.Interest();
temp.Name = request.InterestName;
temp.CreatedDate = DateTime.Now;
temp.UpdatedDate = DateTime.Now;
dbContext.Interest.Add(temp);
dbContext.SaveChanges();
BaseResponse response = new BaseResponse
{
IsSucceed = true,
Message = "Yeni İlgi Alanı Eklendi"
};
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public BaseResponse AssignWordToDeveloper(AssignWordToDeveloperRequest request)
{
try
{
BaseResponse response = new BaseResponse();
using (DDS_Context dbContext = new DDS_Context())
{
TempWord wordEntity = new TempWord();
wordEntity = dbContext.TempWord.FirstOrDefault(x => x.Id == request.WordId);
if (wordEntity == null)
{
response.IsSucceed = false;
response.Message = "Bir Hata Oluştu, Görevlendirme Yapılamadı.";
}
else
{
wordEntity.DeveloperId = request.DeveloperId;
wordEntity.Status = 2; /*Status=OnDeveloper*/
wordEntity.UpdatedDate = DateTime.Now;
dbContext.SaveChanges();
response.IsSucceed = true;
response.Message = "Geliştirici Görevlendirildi.";
}
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public SearchResponse SearchWord(SearchWordRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
SearchResponse response = new SearchResponse();
var entity = dbContext.Dictionary.FirstOrDefault(x => x.Word == request.Word);
if (entity != null)
{
response = new SearchResponse()
{
Word = entity.Word,
Content = entity.Content,
DeveloperId = entity.DeveloperId,
InterestId = entity.InterestId,
CreatedDate = Convert.ToString(entity.CreatedDate),
UpdatedDate = Convert.ToString(entity.UpdatedDate)
};
}
else
{
response.IsSucceed = false;
response.Message = $"{request.Word} kelimesi sözlükte bulunamadı!";
}
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public BaseResponse AddEditUser(AddUserRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
BaseResponse response = new BaseResponse();
if (request.Id == 0)
{
User temp = new User();
temp.Name = request.Name;
temp.Surname = request.Surname;
temp.Email = request.Email;
temp.Password = request.Password;
temp.InterestId = request.InterestId;
temp.Role = request.Role;
temp.CreatedDaate = DateTime.Now;
temp.UpdatedDate = DateTime.Now;
dbContext.User.Add(temp);
dbContext.SaveChanges();
response.Message = "Kullanıcı Eklendi";
response.IsSucceed = true;
}
else
{
var entity = dbContext.User.FirstOrDefault(x => x.Id == request.Id);
if (entity != null)
{
entity.Name = request.Name;
entity.Surname = request.Surname;
entity.Email = request.Email;
entity.Password = request.Password;
entity.InterestId = request.InterestId;
entity.Role = request.Role;
entity.UpdatedDate = DateTime.Now;
dbContext.SaveChanges();
response.Message = "Kullanıcı Güncellendi";
response.IsSucceed = true;
}
else
{
response.Message = "KULLANICI BULUNAMADI";
response.IsSucceed = false;
}
}
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public BaseResponse ReportWord(ReportRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
BaseResponse response = new BaseResponse();
TempWord data = new TempWord();
data.Word = request.Word;
data.Status = 1;
data.InterestId = request.InterestId;
data.CreatedDate = DateTime.Now;
data.UpdatedDate = DateTime.Now;
data.AcceptanceVote = 0;
data.RejectionVote = 0;
data.UserId = request.UserId;
dbContext.TempWord.Add(data);
response.IsSucceed = true;
response.Message = "Bildiriminiz için teşekkür ederiz.";
dbContext.SaveChanges();
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <InterestView> GetAllInterests()
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
List <InterestView> response = new List <InterestView>();
var entity = dbContext.Interest.ToList();
if (entity != null)
{
foreach (var item in entity)
{
if (item.Id != 0)
{
InterestView obj = new InterestView();
obj.Id = item.Id;
obj.Name = item.Name;
obj.CreatedDate = Convert.ToString(item.CreatedDate);
obj.UpdatedDate = Convert.ToString(item.UpdatedDate);
response.Add(obj);
}
}
}
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public LoginResponse Login(LoginRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
LoginResponse response = new LoginResponse();
User user = dbContext.User.FirstOrDefault(x => x.Email == request.Email && x.Password == request.Password);
if (user != null)
{
response.UserView = new UserView()
{
Email = user.Email,
Id = user.Id,
Name = user.Name,
RoleName = ReturnRole(user.Role),
Surname = user.Surname
};
}
else
{
response.IsSucceed = false;
response.Message = $"Bu {request.Email}'e ait herhangi bir kullanıcı bulunmamaktadır! ";
}
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <GetReportedWordResponse> GetReportedWords()
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
List <GetReportedWordResponse> response = new List <GetReportedWordResponse>();
var entity = dbContext.TempWord.Where(x => x.Status == 1).ToList();
if (entity != null)
{
foreach (var item in entity)
{
GetReportedWordResponse temp = new GetReportedWordResponse();
temp.CreatedDate = Convert.ToString(item.CreatedDate);
temp.UpdatedDate = Convert.ToString(item.UpdatedDate);
temp.WordId = item.Id;
temp.Id = item.Id;
temp.Word = item.Word;
var i = dbContext.User.FirstOrDefault(x => x.Id == item.UserId);
if (i != null)
{
temp.UserName = i.Name; temp.UserSurname = i.Surname;
}
else
{
temp.UserName = "******";
}
var developers = dbContext.User.Where(x => (x.Role == 2 || x.Role == 4) && (x.InterestId == item.InterestId)).ToList();//Senior
if (developers != null)
{
foreach (var element in developers)
{
InterestsDevelopersResponse IDR = new InterestsDevelopersResponse();
IDR.Id = element.Id;
IDR.Name = element.Name;
IDR.Surname = element.Surname;
temp.Developers.Add(IDR);
}
}
var interest = dbContext.Interest.FirstOrDefault(x => x.Id == item.InterestId);
if (interest != null)
{
temp.Interest.InerestId = interest.Id;
temp.Interest.InterestName = interest.Name;
}
response.Add(temp);
}
}
response.Reverse();
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <GetPendingWordsResponse> GetPendingWords()
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
List <GetPendingWordsResponse> response = new List <GetPendingWordsResponse>();
var entity = dbContext.TempWord.Where(x => x.Status == 3).ToList();
if (entity != null)
{
foreach (var item in entity)
{
GetPendingWordsResponse temp = new GetPendingWordsResponse();
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 = "******";
}
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;
response.Add(temp);
}
}
response.Reverse();
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <GetUserResponse> GetUsers()
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
List <GetUserResponse> response = new List <GetUserResponse>();
var entity = dbContext.User.ToList();
if (entity != null)
{
foreach (var item in entity)
{
GetUserResponse temp = new GetUserResponse();
temp.UserId = item.Id;
temp.UserName = item.Name;
temp.UserSurname = item.Surname;
temp.Email = item.Email;
temp.InterestName = item.Interest.Name;
temp.InterestId = item.Interest.Id;
temp.RoleId = item.Role;
temp.Password = item.Password;
switch (temp.RoleId)
{
case 1:
temp.RoleName = "Kullanıcı";
break;
case 2:
temp.RoleName = "Geliştirici";
break;
case 4:
temp.RoleName = "Kurul Üyesi";
break;
default:
temp.RoleName = "TANIMLANAMADI";
break;
}
temp.CreatedDate = Convert.ToString(item.CreatedDaate);
temp.UpdatedDate = Convert.ToString(item.UpdatedDate);
response.Add(temp);
}
}
response.Remove(response.FirstOrDefault(x => x.RoleId == (int)Role.Admin)); /*admin listede görüntülenmemeli*/
response.Reverse();
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void CreateInterest()
{
using (DDS_Context dbContext = new DDS_Context())
{
dbContext.Interest.Add(new Interest {
Id = 1, Name = "Computer", CreatedDate = DateTime.Now, UpdatedDate = DateTime.Now
});
dbContext.SaveChanges();
}
}
public void GetKeyword()
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
var keywordList = dbContext.TempWord.Select(x => new { x.DeveloperId, x.Content }).ToList();
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public int GetSameInterestDevelopersCount(int UserId)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
var user = dbContext.User.FirstOrDefault(x => x.Id == UserId);
return(dbContext.User
.Where(x => x.InterestId == user.InterestId && x.Role == (int)Role.Senior)
.ToList().Count);
}
}
catch (Exception ex)
{
throw ex;
}
}
public int GetUserInterestID(int UserId)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
InterestView response = new InterestView();
var entity = dbContext.User.FirstOrDefault(x => x.Id == UserId);
if (entity != null)
{
response.Id = entity.InterestId;
}
return(response.Id);
}
}
catch (Exception ex)
{
throw ex;
}
}
public BaseResponse AcceptanceVote(SendTaskFromAdminRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
BaseResponse response = new BaseResponse();
var isVotedControl = dbContext.Votes.FirstOrDefault(x => x.DeveloperId == request.UserId && x.WordId == request.Id);
if (isVotedControl != null)
{
response.IsSucceed = false;
response.Message = "Bu Konuyu Daha Önce Oyladınız.";
}
else
{
var entity = dbContext.TempWord.FirstOrDefault(x => x.Id == request.Id);
entity.AcceptanceVote += 1;
Votes vote = new Votes();
vote.WordId = request.Id;
vote.DeveloperId = request.UserId;
vote.Value = true;
dbContext.Votes.Add(vote);
dbContext.SaveChanges();
response.IsSucceed = true;
response.Message = "Bu Konuyu Olumlu Olarak Oyladınız.";
}
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public BaseResponse DenyTask(SendTaskFromAdminRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
var entity = dbContext.TempWord.FirstOrDefault(x => x.Id == request.Id);
entity.Status = 5; /*status = inVote*/
entity.UpdatedDate = DateTime.Now;
dbContext.SaveChanges();
BaseResponse response = new BaseResponse();
response.IsSucceed = true;
response.Message = "Araştırma Sonucu Reddedildi";
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public BaseResponse SendTaskToAdmin(SendTaskToAdminRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
var entity = dbContext.TempWord.FirstOrDefault(x => x.Id == request.WordId);
entity.Content = request.Content; /*ckeditor==word content*/
entity.Status = 3; /*status = WaitAdminConfirmation*/
entity.UpdatedDate = DateTime.Now;
dbContext.SaveChanges();
BaseResponse response = new BaseResponse();
response.IsSucceed = true;
response.Message = "Araştırmanız Onaylanmak İçin Yöneticiye Gönderildi.";
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <WordView> GetRatingWords(GetRatingWordsRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
List <WordView> response = new List <WordView>();
var entity = dbContext.TempWord.Where(x => x.Status == 4 && x.InterestId == request.InterestId).ToList();
var result = entity;
if (result != null)
{
/*daha önce oy kullandığının kontrolü*/
var isVoted = dbContext.Votes.Where(x => x.DeveloperId == request.UserId).ToList();
var deleteItems = new List <TempWord>();
foreach (var voted in isVoted)
{
foreach (var item in result)
{
if (item.Id == voted.WordId)
{
deleteItems.Add(item);
}
}
}
if (deleteItems != null)
{
foreach (var item in deleteItems)
{
result.Remove(item);
}
}
///////////////////////////////////////
if (result.Count != 0)
{
foreach (var item in result)
{
WordView temp = new WordView();
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;
response.Add(temp);
}
}
}
response.Reverse();
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
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 void VotingIsEnded(SendTaskFromAdminRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
InterestService _interest = new InterestService();
var sameSeniorsCount = _interest.GetSameInterestDevelopersCount(request.UserId);
var acceptanceVotesCount = dbContext.TempWord.FirstOrDefault(x => x.Id == request.Id).AcceptanceVote;
var rejectionVotesCount = dbContext.TempWord.FirstOrDefault(x => x.Id == request.Id).RejectionVote;
if (acceptanceVotesCount + rejectionVotesCount == sameSeniorsCount)
{
if (acceptanceVotesCount < rejectionVotesCount)
{
var entity = dbContext.TempWord.FirstOrDefault(x => x.Id == request.Id);
entity.Status = 6;
dbContext.SaveChanges();
}
else
{
var entity = dbContext.TempWord.FirstOrDefault(x => x.Id == request.Id);
var item = new Dictionary_Development_System_Data.Dictionary();
//var willDeleteVotes = dbContext.Votes.Where(x => x.WordId == request.Id).ToList();
//var tempVotes = new List<Votes>();
//if(willDeleteVotes != null)
//{
// foreach (var vote in willDeleteVotes)
// {
// tempVotes.Add(vote);
// }
// foreach (var vote in tempVotes)
// {
// willDeleteVotes.Remove(vote);
// }
// dbContext.SaveChanges();
//}
item.Content = entity.Content;
item.CreatedDate = entity.CreatedDate;
item.UpdatedDate = DateTime.Now;
item.InterestId = entity.InterestId;
item.Word = entity.Word;
item.DeveloperId = entity.DeveloperId ?? 0;
dbContext.Dictionary.Add(item);
dbContext.TempWord.Remove(entity);
dbContext.SaveChanges();
}
}
else
{
return;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <WordView> GetMyReported(SendTaskFromAdminRequest request)
{
try
{
using (DDS_Context dbContext = new DDS_Context())
{
List <WordView> response = new List <WordView>();
var dictionaryEntity = dbContext.Dictionary.Where(x => x.UserID == request.UserId).ToList();
if (dictionaryEntity != null)
{
foreach (var item in dictionaryEntity)
{
WordView temp = new WordView();
temp.Word = item.Word;
temp.Interest.InterestName = item.Interest.Name;
temp.Interest.InerestId = item.InterestId;
temp.Status = "Sözlüğe Eklendi";
var developer = dbContext.User.FirstOrDefault(x => x.Id == item.DeveloperId);
temp.DeveloperName = developer.Name;
temp.DeveloperSurname = developer.Surname;
temp.CreatedDate = Convert.ToString(item.CreatedDate);
temp.Content = item.Content;
response.Add(temp);
}
}
var tempWordEntity = dbContext.TempWord.Where(x => x.UserId == request.UserId).ToList();
if (tempWordEntity != null)
{
foreach (var item in tempWordEntity)
{
WordView temp = new WordView();
temp.Word = item.Word;
temp.Interest.InterestName = item.Interest.Name;
temp.Interest.InerestId = item.InterestId;
switch (item.Status)
{
case 1:
temp.Status = "Yönetici onayı bekliyor";
break;
case 2:
temp.Status = "Geliştirici Üzerinde Çalışıyor";
break;
case 3:
temp.Status = "Geliştiricinin Çalışması Onay Bekliyor";
break;
case 4:
temp.Status = "Oylanıyor";
break;
case 5:
temp.Status = "Yönetici Tarafından Reddedildi";
break;
case 6:
temp.Status = "Oylamada Kabul Görmedi";
break;
default:
temp.Status = "TANIMLANAMADI";
break;
}
var developer = dbContext.User.FirstOrDefault(x => x.Id == item.DeveloperId);
if (developer != null)
{
temp.DeveloperName = developer.Name;
temp.DeveloperSurname = developer.Surname;
}
temp.CreatedDate = Convert.ToString(item.CreatedDate);
response.Add(temp);
}
response.Reverse();
}
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}