public bool EditUser(long id, string name, string email, string password, string phone, long roleId)
{
User newUser;
// bool flag = false;
string hashPassword = password;
using (var db = new TimeTrackerModelContainer())
{
newUser = db.User.First(x => x.Id == id);
//var role = db.Role.First(x=>x.Id == )
if (password != null)
{
newUser.Password = HashPassword(hashPassword, password);
}
if (roleId != 0)
{
newUser.RoleId = roleId;
}
newUser.Id = id;
newUser.Name = name;
newUser.Phone = phone;
db.Entry(newUser).State = EntityState.Modified;
db.SaveChanges();
//flag = true;
}
return(true);
}
public bool EditCurrency(long id, string code, Nullable <bool> isDefault, string priceToDefault)
{
bool flag = false;
Currency newCurrency = new Currency();
using (var db = new TimeTrackerModelContainer())
{
var result = db.Currency.First(x => x.Id == id);
newCurrency.Id = result.Id;
newCurrency.Code = code;
newCurrency.IsDefault = isDefault;
newCurrency.PriceToDefault = priceToDefault;
var s = db.Set <Currency>().Local.FirstOrDefault(x => x.Id == id);
if (s != null)
{
db.Entry(s).State = EntityState.Detached;
}
if (result.Id == id)
{
db.Entry(newCurrency).State = EntityState.Modified;
db.SaveChanges();
flag = true;
}
}
return(flag);
}
public List <UserDto> GetAllUser()
{
List <UserDto> list = new List <UserDto>();
using (var db = new TimeTrackerModelContainer())
{
var userList = db.User.AsEnumerable().ToList();
foreach (var temp in userList)
{
list.Add(new UserDto
{
Id = temp.Id,
Name = temp.Name,
Phone = temp.Phone,
Email = temp.Email,
Token = temp.Token,
RoleId = temp.RoleId,
RoleName = db.Role.First(x => x.Id == temp.RoleId).Key
});
}
}
return(list);
}
public bool EditProject(long id, string projectName, DateTime?deadLine, Nullable <short> effortInHours,
Nullable <decimal> effortInCurrency, long currencyId, long teamId, long statusId, long clientId)
{
bool flag = false;
var newProject = new Project
{
Id = id,
Name = projectName,
DeadLine = deadLine,
EffortInHours = effortInHours,
EffortInCurrency = effortInCurrency,
TeamId = teamId,
StatusId = statusId,
ClientId = clientId,
CurrencyId = currencyId
};
using (var db = new TimeTrackerModelContainer())
{
db.Entry(newProject).State = EntityState.Modified;
db.SaveChanges();
flag = true;
}
return(flag);
}
public TimeRecord GetTimeRecordByTodoId(long id)
{
using (var db = new TimeTrackerModelContainer())
{
return(db.TimeRecord.FirstOrDefault(x => x.TodoId == id));
}
}
public List <TeamDetailsResponseDto> GetTeamDetails(long id)
{
List <TeamDetailsResponseDto> teamDetails = new List <TeamDetailsResponseDto>();
using (var db = new TimeTrackerModelContainer())
{
var result = db.UserTeamLink.AsEnumerable().Where(x => x.TeamId == id);
foreach (var list in result)
{
teamDetails.Add(new TeamDetailsResponseDto
{
Id = list.Id,
UserName = list.User.Name,
UserID = list.UserID,
TeamName = list.Team.Name,
Currency = list.Currency.Code,
PublicPrice = list.PublicPrice,
PrivatePrice = list.PrivatePrice,
TeamId = list.Team.Id
});
}
}
return(teamDetails);
}
public bool EditTeamDetails(TeamDetailsResponseDto request)
{
bool flag = false;
Team editTeam = new Team
{
Id = request.TeamId,
Name = request.TeamName
};
using (var db = new TimeTrackerModelContainer())
{
var userTeamLink = db.UserTeamLink.First(x => x.Id == request.Id);
userTeamLink.CurrencyId = request.CurrencyId;
userTeamLink.TeamId = userTeamLink.TeamId;
userTeamLink.PrivatePrice = request.PrivatePrice;
userTeamLink.PublicPrice = request.PublicPrice;
editTeam.Id = userTeamLink.TeamId;
db.Entry(editTeam).State = EntityState.Modified;
db.Entry(userTeamLink).State = EntityState.Modified;
db.SaveChanges();
flag = true;
}
return(flag);
}
public List <ProjectDto> GetAllProject()
{
List <ProjectDto> list = new List <ProjectDto>();
using (var db = new TimeTrackerModelContainer())
{
var result = db.Project.AsEnumerable().ToList();
foreach (var temp in result)
{
list.Add(new ProjectDto
{
Id = temp.Id,
Name = temp.Name,
DeadLine = temp.DeadLine,
EffortInHours = temp.EffortInHours,
EffortInCurrency = temp.EffortInCurrency,
TeamId = temp.TeamId,
StatusId = temp.StatusId,
ClientId = temp.ClientId
});
}
}
return(list);
}
public Status EditStatus(StatusRequest request)
{
Status newStatus = new Status();
using (var db = new TimeTrackerModelContainer())
{
var result = db.Status.First(x => x.Id == request.Id);
newStatus.Id = request.Id;
newStatus.Name = request.Name;
newStatus.StateTypeId = request.status;
var s = db.Set <Status>().Local.FirstOrDefault(x => x.Id == request.Id);
if (s != null)
{
db.Entry(s).State = EntityState.Detached;
}
if (result.Id == request.Id)
{
db.Entry(newStatus).State = EntityState.Modified;
db.SaveChanges();
}
}
return(newStatus);
}
public List <ProjectDetailsResponse> GetAllProjectByTeamId(long id)
{
var list = new List <ProjectDetailsResponse>();
using (var db = new TimeTrackerModelContainer())
{
var result = db.Project.AsEnumerable().Where(x => x.TeamId == id);
foreach (var tempList in result)
{
list.Add(new ProjectDetailsResponse
{
Id = tempList.Id,
ProjectName = tempList.Name,
DeadLine = tempList.DeadLine,
EffortInHours = tempList.EffortInHours,
EffortInCurrency = tempList.EffortInCurrency,
TeamName = tempList.Team.Name,
StatusName = tempList.Status.Name,
Clientname = tempList.Client.Website,
Currency = db.Currency.First(x => x.Id == tempList.CurrencyId).Code
});
}
}
return(list);
}
public Status GetStatus(States status)
{
using (var db = new TimeTrackerModelContainer())
{
return(db.Status.First(x => x.Name.Equals(status.ToString())));
}
}
public bool EditPermission(long id, string key, PermissionTypeEnum permissionType)
{
bool flag = false;
Permission permission = new Permission
{
Id = id,
Key = key,
PermissionTypeId = permissionType
};
using (var db = new TimeTrackerModelContainer())
{
var result = db.Permission.First(x => x.Id == id);
var s = db.Set <Permission>().Local.FirstOrDefault(x => x.Id == id);
if (s != null)
{
db.Entry(s).State = EntityState.Detached;
}
if (result.Id == id)
{
db.Entry(permission).State = EntityState.Modified;
db.SaveChanges();
flag = true;
}
}
return(flag);
}
public Project AddnewProject(ProjectRequest request)
{
var status = new StatusLogic();
Project newProject = new Project
{
Name = request.Name,
DeadLine = request.DeadLine,
EffortInHours = request.EffortInHours,
EffortInCurrency = request.EffortInCurrency,
TeamId = request.TeamId,
StatusId = status.GetStatus(States.New).Id,
ClientId = request.ClientId,
Id = request.Id,
CurrencyId = request.CurrencyId
};
using (var db = new TimeTrackerModelContainer())
{
db.Project.Add(newProject);
db.SaveChanges();
}
return(newProject);
}
public Team EditTeam(TeamRequest request)
{
var newTeam = new Team();
using (var db = new TimeTrackerModelContainer())
{
var result = db.Team.First(x => x.Id == request.Id);
newTeam.Id = result.Id;
newTeam.Name = request.Name;
var s = db.Set <Team>().Local.FirstOrDefault(x => x.Id == request.Id);
if (s != null)
{
db.Entry(s).State = EntityState.Detached;
}
if (result.Id == request.Id)
{
db.Entry(newTeam).State = EntityState.Modified;
db.SaveChanges();
}
}
return(newTeam);
}
public Team AddNewTeam(TeamRequest request)
{
using (var db = new TimeTrackerModelContainer())
{
var team = new Team();
team.Name = request.Name;
var user = db.User.First(x => x.Email == request.UserEmail);
db.Team.Add(team);
var userTeamLink = new UserTeamLink
{
PublicPrice = request.PublicPrice,
PrivatePrice = request.PrivatePrice,
CurrencyId = request.CurrencyId,
UserID = user.Id,
TeamId = team.Id
};
db.UserTeamLink.Add(userTeamLink);
db.SaveChanges();
return(team);
}
}
public bool DeleteTeam(long id)
{
using (var db = new TimeTrackerModelContainer())
{
var team = db.Team.FirstOrDefault(x => x.Id == id);
db.Team.Remove(team);
return(true);
}
}
public Team GetTeamById(int id)
{
Team team;
using (var db = new TimeTrackerModelContainer())
{
var result = db.Team.Where(x => x.Id == id).First();
return(result);
}
}
public User AddUser(string name, string email, string password, string token, string phone)
{
string hashPassword = HashPassword(password, password);
var roleLogic = new RoleLogic();
var newUser = new User();
var newTeam = new Team();
var currencyLogic = new CurrencyLogic();
var newUserTeamLink = new UserTeamLink();
byte[] time = BitConverter.GetBytes(DateTime.UtcNow.ToBinary());
byte[] key = Guid.NewGuid().ToByteArray();
string newToken = Convert.ToBase64String(time.Concat(key).ToArray());
var defaultUserRole = roleLogic.GetRole(Roles.User);
var defautCurrency = currencyLogic.GetCurrencyByCode("HUF");
using (var db = new TimeTrackerModelContainer())
{
var userInDb = db.User.FirstOrDefault(x => x.Email == email);
if (userInDb != null)
{
throw new Exception("Ez az Email cím már regisztrált");
}
newUser.Name = name;
newUser.Email = email;
newUser.Password = hashPassword;
newUser.Phone = phone;
newUser.Token = newToken;
newUser.Role = defaultUserRole;
db.Role.Attach(newUser.Role);
db.User.Add(newUser);
newTeam.Name = newUser.Name;
db.Team.Add(newTeam);
newUserTeamLink.User = newUser;
newUserTeamLink.Currency = defautCurrency;
newUserTeamLink.PrivatePrice = "0";
newUserTeamLink.PublicPrice = "0";
newUserTeamLink.Team = newTeam;
db.Currency.Attach(newUserTeamLink.Currency);
db.UserTeamLink.Add(newUserTeamLink);
db.SaveChanges();
}
return(newUser);
}
public Currency GetCurrencyById(long id)
{
Currency resultCurrency;
using (var db = new TimeTrackerModelContainer())
{
resultCurrency = db.Currency.First(x => x.Id == id);
}
return(resultCurrency);
}
public Permission GetPermissionById(long id)
{
Permission permission;
using (var db = new TimeTrackerModelContainer())
{
permission = db.Permission.First(x => x.Id == id);
}
return(permission);
}
public Status GetStatusById(long id)
{
Status status;
using (var db = new TimeTrackerModelContainer())
{
status = db.Status.First(x => x.Id == id);
}
return(status);
}
public Client GetClientById(long id)
{
Client client;
using (var db = new TimeTrackerModelContainer())
{
client = db.Client.First(x => x.Id == id);
}
return(client);
}
public List <TeamDto> GetTeamList()
{
using (var db = new TimeTrackerModelContainer())
{
var TeamList = db.Team.AsEnumerable().Select(x => new TeamDto {
Id = x.Id, Name = x.Name
}).ToList();
return(TeamList);
}
}
public Project GetProjectById(long id)
{
var project = new Project();
using (var db = new TimeTrackerModelContainer())
{
project = db.Project.First(x => x.Id == id);
}
return(project);
}
public Role GetRoleById(long id)
{
Role role;
using (var db = new TimeTrackerModelContainer())
{
role = db.Role.First(x => x.Id == id);
}
return(role);
}
public TimeRecord GeTimeRecordById(long id)
{
var timeRecord = new TimeRecord();
using (var db = new TimeTrackerModelContainer())
{
timeRecord = db.TimeRecord.FirstOrDefault(x => x.Id == id);
}
return(timeRecord);
}
public bool DeleteTimeRecord(long id)
{
using (var db = new TimeTrackerModelContainer())
{
var timeRecord = db.TimeRecord.FirstOrDefault(x => x.Id == id);
db.TimeRecord.Remove(timeRecord);
db.SaveChanges();
return(true);
}
}
public User ForgotPwd(string email)
{
User result;
using (var db = new TimeTrackerModelContainer())
{
result = db.User.First(x => x.Email == email);
}
return(result);
}
public User GetUserbyEmail(string email)
{
User user;
var result = new UserDto();
using (var db = new TimeTrackerModelContainer())
{
user = db.User.First(x => x.Email == email);
}
return(user);
}
public Role GetRoleTypeId(string userEmail)
{
Role role;
using (var db = new TimeTrackerModelContainer())
{
var user = db.User.First(x => x.Email == userEmail);
role = db.Role.First(x => x.Id == user.RoleId);
}
return(role);
}
