public DataTable GetAlldata()
{
List <PersonsAdmin> result = new List <PersonsAdmin>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <PersonsAdmin> pl =
from r in DC.PersonsAdmins
orderby r.AdminID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAllTelContacts()
{
List <TelContact> result = new List <TelContact>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <TelContact> pl =
from r in DC.TelContacts
orderby r.ID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAllEmp()
{
List <Employee> result = new List <Employee>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <Employee> pl =
from r in DC.Employees
orderby r.EmployeeID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAllFaculties()
{
List <Faculty> result = new List <Faculty>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <Faculty> pl =
from r in DC.Faculties
orderby r.FacultyID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAllDepartment()
{
List <Department> result = new List <Department>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <Department> pl =
from r in DC.Departments
orderby r.DepartmentID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable Getexeldatavstd()
{
List <VStudent> result = new List <VStudent>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <VStudent> pl =
from r in DC.VStudents
orderby r.StudentID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAllEduLevels()
{
List <EduLevel> result = new List <EduLevel>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <EduLevel> pl =
from r in DC.EduLevels
orderby r.LevelID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAllLec()
{
List <Lecturer> result = new List <Lecturer>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <Lecturer> pl =
from r in DC.Lecturers
orderby r.LecturerID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAllTendency()
{
List <VEduTendency> result = new List <VEduTendency>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <VEduTendency> pl =
from r in DC.VEduTendencies
orderby r.TendencyID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAllvpns()
{
List <VPN> result = new List <VPN>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <VPN> pl =
from r in DC.VPNs
orderby r.VPNID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAlldata()
{
List <WebServiceAccount> result = new List <WebServiceAccount>();
using (PersonsDBEntities DC = conn.GetContext())
{
IEnumerable <WebServiceAccount> pl =
from r in DC.WebServiceAccounts
orderby r.AccountID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetwebaccountList(int id)
{
List <WebServiceAccount> result = new List <WebServiceAccount>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <WebServiceAccount> pl =
from r in pb.WebServiceAccounts
where
r.AccountID == id
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAntiList(int Levelid)
{
List <EduLevel> result = new List <EduLevel>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <EduLevel> pl =
from r in pb.EduLevels
where
r.LevelID == Levelid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAntiList(int fieldid)
{
List <EduField> result = new List <EduField>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <EduField> pl =
from r in pb.EduFields
where
r.FieldID == fieldid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetstdList(int lecid)
{
List <VLecturer> result = new List <VLecturer>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <VLecturer> pl =
from r in pb.VLecturers
where
r.LecturerID == lecid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetEmailpersonContactList(int userid, int usertypeid)
{
List <EmailContact> result = new List <EmailContact>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <EmailContact> pl =
from r in pb.EmailContacts
where
r.UserID == userid && r.UserTypeID == usertypeid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetFacultyList(int Facultyid)
{
List <Faculty> result = new List <Faculty>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <Faculty> pl =
from r in pb.Faculties
where
r.FacultyID == Facultyid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetstdList(int empid)
{
List <VEmployee> result = new List <VEmployee>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <VEmployee> pl =
from r in pb.VEmployees
where
r.EmployeeID == empid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetPersonAdminList(int Personid)
{
List <PersonsAdmin> result = new List <PersonsAdmin>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <PersonsAdmin> pl =
from r in pb.PersonsAdmins
where
r.AdminID == Personid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetRoleList(int Roleid)
{
List <Role> result = new List <Role>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <Role> pl =
from r in pb.Roles
where
r.RoleID == Roleid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetstdList(int stdid)
{
List <VStudent> result = new List <VStudent>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <VStudent> pl =
from r in pb.VStudents
where
r.StudentID == stdid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetAntiList(int departmentid)
{
List <Department> result = new List <Department>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <Department> pl =
from r in pb.Departments
where
r.DepartmentID == departmentid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetTelContactList(int TelContactid)
{
List <TelContact> result = new List <TelContact>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <TelContact> pl =
from r in pb.TelContacts
where
r.ID == TelContactid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GettendencyList(int tendencyid)
{
List <VEduTendency> result = new List <VEduTendency>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <VEduTendency> pl =
from r in pb.VEduTendencies
where
r.TendencyID == tendencyid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable SearchTitle(string searchTitle)
{
List <Department> result = new List <Department>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <Department> pl =
from r in pb.Departments
where
r.DepartmentTitle.Contains(searchTitle)
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable GetFacultyList(int emailtypeid)
{
List <EmailType> result = new List <EmailType>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <EmailType> pl =
from r in pb.EmailTypes
where
r.EmailTypeID == emailtypeid
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable searchRoletitle(string searchTitle)
{
List <VEmployee> result = new List <VEmployee>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <VEmployee> pl =
from r in pb.VEmployees
where
r.RoleTitle.Contains(searchTitle)
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable SearchpersonTelTypeid(int searchText, int UserTypeID, int UserID)
{
List <TelContact> result = new List <TelContact>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <TelContact> pl =
from r in pb.TelContacts
where
r.TelTypeID == searchText && r.UserID == UserID && r.UserTypeID == UserTypeID
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable Searchtitle(string searchTitle)
{
List <VEduTendency> result = new List <VEduTendency>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <VEduTendency> pl =
from r in pb.VEduTendencies
where
r.TendencyTitle.Contains(searchTitle)
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
public DataTable SearchNationalcode(string searchTitle)
{
List <VEmployee> result = new List <VEmployee>();
using (PersonsDBEntities pb = conn.GetContext())
{
IEnumerable <VEmployee> pl =
from r in pb.VEmployees
where
r.NationalCode == searchTitle
select r;
result = pl.ToList();
}
return(PersonTools.ToDataTable(result));
}
