public bool UpdateCandidatePool(CandidatePool cp)
{
if (cp != null)
{
var paramu = new
{
CandidatePoolID = cp.CandidatePoolID,
CompanyID = cp.Company.CompanyID,
CandidateID = cp.Candidate.CandidateID,
CompanyPositionID = cp.CompanyPosition.CompanyPositionID,
Status = cp.Status
};
using (IDbConnection cnn = new SqlConnection(Helper.GetConnectionString()))
{
string sql = "dbo.SP_CandidatePoolUpdate";
int affectedRow = int.Parse(cnn.ExecuteScalar(sql, paramu,
commandType: CommandType.StoredProcedure).ToString());
return(affectedRow > 0 ? true : false);
}
}
else
{
return(false);
}
}
public CandidatePool Post([FromBody] CandidatePool model)
{
// POST: api/User
// this post method insert the new row or update the current row if there is a record with same ID
CandidatePoolDE de = new CandidatePoolDE();
CandidatePool sonuc = de.AddCandidatePool(model);
return(sonuc);
}
public IEnumerable <CandidatePool> Get(int id)
{
// GET: api/CandidatePool
//HttpContext.RiseError(new InvalidOperationException("Test"));
CandidatePool model = new CandidatePool();
CandidatePoolDE de = new CandidatePoolDE();
return(de.GetCandidatePool(id));
}
public IActionResult Put([FromBody] CandidatePool model)
{
// POST: api/CandidatePool
// this post method insert the new row or update the current row if there is a record with same ID
CandidatePoolDE de = new CandidatePoolDE();
bool sonuc = de.UpdateCandidatePool(model);
if (sonuc)
{
return(Ok());
}
else
{
return(NotFound());
}
}
public CandidatePool AddCandidatePool(CandidatePool cp)
{
if (cp != null)
{
var paramu = new
{
CompanyID = cp.Company.CompanyID,
CandidateID = cp.Candidate.CandidateID,
CompanyPositionID = cp.CompanyPosition.CompanyPositionID,
Status = cp.Status
};
using (IDbConnection cnn = new SqlConnection(Helper.GetConnectionString()))
{
string sql = "dbo.SP_CandidatePoolSET";
CandidatePool us = cnn.QuerySingle <CandidatePool>(sql, paramu,
commandType: CommandType.StoredProcedure);
return(us);
}
}
else
{
return(null);
}
}
public void Load(int?seed = null)
{
m_Random = seed.HasValue ? new Random(seed.Value) : new Random();
CandidatePool = JSONLoader.LoadFromFile <CandidatePool>(m_FilePath);
m_AvailableCandidates = CandidatePool.Candidates.ToList();
}
