public int AddNewConfigProjectsLib(string ProjectName)
{
Args.Clear();
Args.Add("@ProjectName", ProjectName);
return(int.Parse(DBObjects.GetExecProcedureWithArgsResult("ADD_NEW_PROJECT_LIB_ID", Args).ToString()));
}
public int AddConfigCompany(string companyName)
{
Args.Clear();
Args.Add("@CompanyName", companyName);
return(int.Parse(DBObjects.GetExecProcedureWithArgsResult("ADD_NEW_COMPANY", Args).ToString()));
}
public int AddNewConfigProjects(int ConfigProjectsLibId, int ConfigAreaId)
{
Args.Clear();
Args.Add("@ConfigProjectsLibId", ConfigProjectsLibId);
Args.Add("@ConfigAreaId", ConfigAreaId);
return(int.Parse(DBObjects.GetExecProcedureWithArgsResult("ADD_NEW_PROJECT_ID", Args).ToString()));
}
public void UpdateConfigProjectDocumentInfo(ConfigProject configProject)
{
Args.Clear();
Args.Add("@ConfigProjectID", configProject.ID);
Args.Add("@JDUploaded", configProject.JdUploaded);
DBObjects.ExecSqlProcedure("UPDATE_PROJECT_DOCUMENT_INFO", Args);
}
public void UpdateCandidateDocumentInfo(Candidate candidate)
{
Args.Clear();
Args.Add("@CandidateID", candidate.ID);
Args.Add("@CVUploaded", candidate.CvUploaded);
DBObjects.ExecSqlProcedure("UPDATE_DOCUMENT_INFO", Args);
}
public int AddCandidtate(Candidate candidate)
{
Args.Clear();
Args.Add("@FirstEmail", candidate.FirstEmail);
Args.Add("@SecondEmail", candidate.SecondEmail);
Args.Add("@FirstName", candidate.FirstName);
Args.Add("@LastName", candidate.LastName);
Args.Add("@FirstPhone", candidate.FirstPhone);
Args.Add("@SecondPhone", candidate.SecondPhone);
return(int.Parse(DBObjects.GetExecProcedureWithArgsResult("ADD_NEW_CANDIDATE", Args).ToString()));
}
public void AddCandidateHistory(CandidateHistory CandidateHistory)
{
Dictionary <dynamic, dynamic> Args = new Dictionary <dynamic, dynamic>();
Args.Add("@SEQ", CandidateHistory.Seq);
Args.Add("@CONFIG_STATUS_ID", CandidateHistory.ConfigStatusID);
Args.Add("@TIMESTAMP", CandidateHistory.Timestamp);
Args.Add("@COMMENTS", CandidateHistory.Comments);
Args.Add("@HISTORY_OF_CONTACT", CandidateHistory.HistoryOfContact);
Args.Add("@CV_RECEIVED", false);
Args.Add("@CANDIDATES_PROJECTS_ID", CandidateHistory.CandidatesProjectsID);
DBObjects.ExecSqlProcedure("ADD_CANDIDATE_HISTORY", Args);
}
public void UpdateCandidate(Candidate candidate)
{
//Candidate candidateToUpdate = Candidates.Where(c => c.ID.Equals(candidate.ID)).FirstOrDefault();
//candidateToUpdate = candidate;
Args.Clear();
Args.Add("@CandidateId", candidate.ID);
Args.Add("@FirstName", candidate.FirstName);
Args.Add("@LastName", candidate.LastName);
Args.Add("@FirstPhone", candidate.FirstPhone);
Args.Add("@SecondPhone", candidate.SecondPhone);
Args.Add("@FirstEmail", candidate.FirstEmail);
Args.Add("@SecondEmail", candidate.SecondEmail);
DBObjects.ExecSqlProcedure("UPDATE_CANDIDATE_INFO", Args);
}
public CandidateCompany AddAndCreateCandidateCompany(int candidateId, string position)
{
CandidateCompany candidateCompany = new CandidateCompany();
Args.Clear();
Args.Add("@CandidateID", candidateId);
Args.Add("@Position", position);
int id = int.Parse(DBObjects.GetExecProcedureWithArgsResult("ADD_NEW_CANDIDATE_COMPANY", Args).ToString());
candidateCompany.ID = id;
candidateCompany.CandidateID = candidateId;
candidateCompany.Position = position;
candidateCompany.ProjectID = 0;
return(candidateCompany);
}
public int AddCandidateCompany(int candidateId, ConfigCompany configCompany, string position, ConfigProject configProject)
{
Args.Clear();
Args.Add("@CompanyID", configCompany.ID);
Args.Add("@CandidateID", candidateId);
Args.Add("@Position", position);
Args.Add("@ProjectID", configProject.ID);
try
{
return(int.Parse(DBObjects.GetExecProcedureWithArgsResult("ADD_NEW_CANDIDATE_COMPANY", Args).ToString()));
}
catch
{
return(0);
}
}
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 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 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 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 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 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 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)
{ }
}
public int AddConfigProjectCandidate(int candidateId, ConfigProject configProject, string position, int companyId)
{
Args.Clear();
Args.Add("@CandidateID", candidateId);
Args.Add("@ProjectID", configProject.ID);
Args.Add("@Position", position);
Args.Add("@CompanyID", companyId);
try
{
return(int.Parse(DBObjects.GetExecProcedureWithArgsResult("ADD_NEW_CANDIDATE_PROJECT", Args).ToString()));
}
catch (Exception)
{
return(0);
}
}
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);
}