/// <summary>
/// Gets user by Password- login
/// </summary>
/// <param name="user">user- contain userName and password</param>
/// <returns>User</returns>
public static User GetUserDetailsByPassword(LoginUser user)
{
string query = $"SELECT * FROM managertasks.user JOIN managertasks.department ON user.departmentUserId=department.id WHERE password='******' AND userName='******'";
Func <MySqlDataReader, List <User> > func = (reader) =>
{
List <User> users = new List <User>();
while (reader.Read())
{
users.Add(ConvertorUser.convertDBtoUserWithDepartment(reader));
}
return(users);
};
List <User> usersLogin = DBAccess.RunReader(query, func);
if (usersLogin != null && usersLogin.Count > 0 && user.Ip != null)
{
query = $"SET SQL_SAFE_UPDATES=0; UPDATE `managertasks`.`user`SET`userComputer` = '{user.Ip}' WHERE password = '******' ";
DBAccess.RunNonQuery(query);
return(usersLogin[0]);
}
if (usersLogin != null && usersLogin.Count > 0)
{
return(usersLogin[0]);
}
return(null);
}
/// <summary>
/// Get users by department
/// </summary>
/// <param name="departmentName"> department name</param>
/// <returns>List<User>-users in this department</returns>
public static List <User> GetUserByDepartment(string departmentName)
{
string query = $"SELECT * FROM managertasks.user JOIN managertasks.department ON user.departmentUserId=department.id WHERE Department='{departmentName}'";
Func <MySqlDataReader, List <User> > func = (reader) =>
{
List <User> users = new List <User>();
while (reader.Read())
{
users.Add(ConvertorUser.convertDBtoUserWithDepartment(reader));
}
return(users);
};
return(DBAccess.RunReader(query, func));
}
/// <summary>
/// Gets worker in this project
/// </summary>
/// <param name="projectId">idProject</param>
/// <returns>List<User> - users in this project</returns>
public static List <User> GetWorkerInProject(int projectId)
{
string query = $"SELECT u.*, d.* FROM managertasks.user u JOIN managertasks.department d ON u.departmentUserId = d.id join projectworker p on u.id = p.id where p.projectId = {projectId }";
Func <MySqlDataReader, List <User> > func = (reader) =>
{
List <User> userInProject = new List <User>();
while (reader.Read())
{
userInProject.Add(ConvertorUser.convertDBtoUserWithDepartment(reader));
}
return(userInProject);
};
return(DBAccess.RunReader(query, func));
}
/// <summary>
/// Gets user details by ip
/// </summary>
/// <param name="computerUser">ip</param>
/// <returns></returns>
public static User GetUserDetailsComputerUser(string computerUser)
{
string query = $" SELECT* FROM managertasks.user JOIN managertasks.department ON user.departmentUserId = department.id WHERE userComputer = '{computerUser}'";
Func <MySqlDataReader, List <User> > func = (reader) =>
{
List <User> users = new List <User>();
while (reader.Read())
{
users.Add(ConvertorUser.convertDBtoUserWithDepartment(reader));
}
return(users);
};
List <User> usersLogin = DBAccess.RunReader(query, func);
if (usersLogin != null && usersLogin.Count > 0)
{
return(usersLogin[0]);
}
return(null);
}
