public static int AddData(CandidateSelectionHistoryDTO data)
{
using (DBEntities db = new DBEntities())
{
db.TB_CANDIDATE_SELECTION_HISTORY.Add(new TB_CANDIDATE_SELECTION_HISTORY
{
CANDIDATE_ID = data.CANDIDATE_ID,
PIC_ID = data.PIC_ID,
CANDIDATE_APPLIED_POSITION = data.CANDIDATE_APPLIED_POSITION,
CANDIDATE_SUITABLE_POSITION = data.CANDIDATE_SUITABLE_POSITION,
CANDIDATE_SOURCE = data.CANDIDATE_SOURCE,
CANDIDATE_STATE = data.CANDIDATE_STATE,
CANDIDATE_EXPECTED_SALARY = data.CANDIDATE_EXPECTED_SALARY,
PROCESS_DATE = DateTime.Now,
NOTES = data.NOTES,
CANDIDATE_INTERVIEW_DATE = data.CANDIDATE_INTERVIEW_DATE,
LAST_UPDATE = DateTime.Now,
VIEWS_INFORMATION = "YES",
CANDIDATE_CLIENT = data.CANDIDATE_CLIENT,
DELIVERY_ID = data.DELIVERY_ID
});
return(db.SaveChanges());
}
}
public static int AddData(CandidateSelectionHistoryDTO data)
{
using (DBEntities db = new DBEntities())
{
db.TB_CANDIDATE_SELECTION_HISTORY.Add(new TB_CANDIDATE_SELECTION_HISTORY
{
CANDIDATE_ID = data.CANDIDATE_ID,
PIC_ID = data.PIC_ID,
CANDIDATE_APPLIED_POSITION = data.CANDIDATE_APPLIED_POSITION,
CANDIDATE_SUITABLE_POSITION = data.CANDIDATE_SUITABLE_POSITION,
CANDIDATE_SOURCE = data.CANDIDATE_SOURCE,
CANDIDATE_STATE = data.CANDIDATE_STATE,
CANDIDATE_EXPECTED_SALARY = data.CANDIDATE_EXPECTED_SALARY,
PROCESS_DATE = DateTime.Now,
NOTES = data.NOTES
});
return(db.SaveChanges());
}
}
public static int EditData(CandidateSelectionHistoryDTO Data)
{
using (DBEntities db = new DBEntities())
{
//prepare data pic
UserDTO DataPIC = (UserDTO)HttpContext.Current.Session["UserLogin"];
var DataSelectHistory = db.TB_CANDIDATE_SELECTION_HISTORY.FirstOrDefault(sh => sh.CANDIDATE_ID == Data.CANDIDATE_ID && sh.CANDIDATE_STATE == Data.CANDIDATE_STATE);
DataSelectHistory.PIC_ID = DataPIC.USER_ID;
DataSelectHistory.CANDIDATE_STATE = Data.CANDIDATE_STATE;
DataSelectHistory.NOTES = Data.NOTES;
DataSelectHistory.PROCESS_DATE = DateTime.Now;
DataSelectHistory.CANDIDATE_EXPECTED_SALARY = Data.CANDIDATE_EXPECTED_SALARY;
DataSelectHistory.CANDIDATE_INTERVIEW_DATE = Data.CANDIDATE_INTERVIEW_DATE;
DataSelectHistory.CANDIDATE_APPLIED_POSITION = Data.CANDIDATE_APPLIED_POSITION;
DataSelectHistory.CANDIDATE_SUITABLE_POSITION = Data.CANDIDATE_SUITABLE_POSITION;
DataSelectHistory.CANDIDATE_SOURCE = Data.CANDIDATE_SOURCE;
return(db.SaveChanges());
}
}