private static User _IsUserPassCorrect(string username, string password)
{
UserDataClassesDataContext dc = new UserDataClassesDataContext();
var queryResult = (from users in dc.GetTable<User>()
where (users.Username == username) &&
(users.Password == password)
select users).ToArray<User>();
if (queryResult.Count<User>() > 0)
return queryResult.ElementAt<User>(0);
return null;
}
private static int _IsUserCorrect(string username)
{
UserDataClassesDataContext dc = new UserDataClassesDataContext();
var queryResult = (from users in dc.GetTable<User>()
where (users.Username == username)
select users).ToArray<User>();
if (queryResult.Count<User>() > 0)
return queryResult.ElementAt<User>(0).Role;
return -1;
}
public static bool IsUsernameTaken(string username)
{
UserDataClassesDataContext dc = new UserDataClassesDataContext();
var queryResult = (from users in dc.GetTable<User>()
where (users.Username == username)
select users.Username).ToArray<string>();
if (queryResult.Count<string>() > 0)
return true;
return false;
}
public static Student GetStudentDataByUser(string facNumber)
{
UserDataClassesDataContext dc = new UserDataClassesDataContext();
var result = (from students in dc.GetTable<Student>()
where (students.FacNumber == facNumber)
select students).ToArray<Student>();
if (result.Count<Student>() > 0)
return result[0] as Student;
return null;
}
public static bool _IfUserFacNumberExist(string FacuNumber)
{
UserDataClassesDataContext dc = new UserDataClassesDataContext();
var queryResult = (from users in dc.GetTable<User>()
where (users.FacNumber == FacuNumber)
select users).ToArray<User>();
if (queryResult.Count<User>() > 0)
return true;
else
{
return false;
}
}
public static bool IsUsernameBusy(string s)
{
UserDataClassesDataContext dc = new UserDataClassesDataContext();
var queryResult = (from users in dc.GetTable<User>()
where (users.Username == s)
select users).ToArray<User>();
if (queryResult.Count<User>() > 0)
{
return true;
}
else
return false;
}
public static bool InsertUser(User u)
{
UserDataClassesDataContext uc = new UserDataClassesDataContext();
try
{
uc.AddNewUser(u.Username, u.Password, u.FacNumber, u.Role);
uc.SubmitChanges();
}
catch (Exception)
{
return false;
}
return true;
}
public static bool InsertStudent(Student s)
{
UserDataClassesDataContext dc = new UserDataClassesDataContext();
//dc.Students.InsertOnSubmit(s);
try
{
dc.AddNewStudent(s.FirstName, s.MiddleName, s.LastName,
s.Faculty, s.Specialty, s.OKS, s.StudentStatus, s.FacNumber, s.Course, s.Potok, s.Group);
dc.SubmitChanges();
}
catch (Exception)
{
return false;
}
return true;
}
public static bool HasAdminRights(string loggedUsername)
{
UserDataClassesDataContext dc = new UserDataClassesDataContext();
var result = (from user in dc.GetTable<User>()
where (user.Username == loggedUsername)
select user.Role).ToArray<int>();
if (result != null)
{
return ((int)result[0] == 1);
}
else
{
throw new UnauthorizedAccessException("Unauthorized access!");
}
}
