private void LoadConfigCompanys()
{
DataTable dt = DBObjects.GetTableFromSQL("Select * FROM [CONFIG_COMPANY] ORDER BY NAME ");
ConfigCompanys = new ObservableCollection <ConfigCompany>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
ConfigCompanys.Add(new ConfigCompany(row));
}
}
}
catch (Exception ex)
{ }
}
private void LoadCandidates()
{
DataTable dt = DBObjects.GetTableFromSQL("Select * FROM CANDIDATES");
Candidates = new ObservableCollection <Candidate>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
Candidates.Add(new Candidate(row));
}
}
}
catch (Exception x) {}
}
private void LoadConfigAreas()
{
DataTable dt = DBObjects.GetTableFromSQL("Select * FROM CONFIG_AREA ORDER BY AREA_NAME");
ConfigAreas = new ObservableCollection <ConfigArea>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
ConfigAreas.Add(new ConfigArea(row));
}
}
}
catch (Exception ex)
{ }
}
private void LoadConfigProjectsLibs()
{
DataTable dt = DBObjects.GetTableFromSQL("Select * FROM [CONFIG_PROJECT_LIB] ORDER BY PROJECT_NAME");
ConfigProjectsLibs = new ObservableCollection <ConfigProjectsLib>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
ConfigProjectsLibs.Add(new ConfigProjectsLib(row));
}
}
}
catch (Exception ex)
{ }
}
private void LoadConfigProjects()
{
DataTable dt = DBObjects.GetTableFromSQL("Select * FROM ConfigProject_View ");
ConfigProjects = new ObservableCollection <ConfigProject>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
ConfigProjects.Add(new ConfigProject(row));
}
}
}
catch (Exception ex)
{ }
}
private void LoadConfigStatusLibs()
{
DataTable dt = DBObjects.GetTableFromSQL("Select * FROM [CONFIG_STATUS_LIB] ORDER BY [DESCRIPTION]");
ConfigStatusLibs = new ObservableCollection <ConfigStatusLib>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
ConfigStatusLibs.Add(new ConfigStatusLib(row));
}
}
}
catch (Exception ex)
{ }
}
private void LoadConfigCompanyProjects()
{
DataTable dt = DBObjects.GetTableFromSQL("SELECT DISTINCT [COMPANY_ID],[CONFIG_PROJECT_ID] FROM [CANDIDATES_PROJECTS]");
ConfigCompanyProjects = new ObservableCollection <ConfigCompanyProject>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
ConfigCompanyProjects.Add(new ConfigCompanyProject(row));
}
}
}
catch (Exception x) { }
}
private void LoadCandidateCompanys()
{
DataTable dt = DBObjects.GetTableFromSQL(@"Select * FROM
CONFIG_COMPANY CC INNER JOIN
[CANDIDATE_COMPANY] C ON CC.ID = C.COMPANY_ID");
CandidateCompanys = new ObservableCollection <CandidateCompany>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
CandidateCompanys.Add(new CandidateCompany(row));
}
}
}
catch (Exception x) { }
}
private void LoadCandidateHistorysByID(int id)
{
Dictionary <string, string> Args = new Dictionary <string, string>();
Args.Add("@CANDIDATE_ID", id.ToString());
DataTable dt = DBObjects.GetTableFromSQL("FIND_CANDIDATE_HISTORY", Args);
CandidateHistorys = new ObservableCollection <CandidateHistory>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
CandidateHistorys.Add(new CandidateHistory(row));
}
}
}
catch (Exception ex)
{ }
}
public ObservableCollection <CandidateHistory> LoadHistorysByProjectID(int id)
{
Dictionary <string, string> Args = new Dictionary <string, string>();
Args.Add("@ProjectID", id.ToString());
DataTable dt = DBObjects.GetTableFromSQL("FIND_PROJECT_HISTORY", Args);
CandidateHistorys = new ObservableCollection <CandidateHistory>();
try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
CandidateHistorys.Add(new CandidateHistory(row));
}
}
}
catch (Exception ex)
{ }
return(CandidateHistorys);
}