//----------------------------------------------------------------- add data candidate ------------------------------------------
public static List <object> AddData(CandidateDTO DataNewCandidate, HttpPostedFileBase Pict, HttpPostedFileBase Cv)
{
using (DBEntities db = new DBEntities())
{
//generate id candidate
string Candidate_ID = "CA" + DateTime.Now.ToString("fffff");
//process file pict candidate
string pict_name = "-";
if (Pict != null)
{
string pict_ext = Pict.FileName.Split('.')[1];
pict_name = "Pict_" + Candidate_ID + "." + pict_ext;
string path_pict = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Data/DataCandidate/Pict/"), pict_name);
Pict.SaveAs(path_pict);
}
//process file Cv
string Cv_name = "-";
if (Cv != null)
{
string Cv_ext = Cv.FileName.Split('.')[1];
Cv_name = "Cv_" + Candidate_ID + "." + Cv_ext;
string path_cv = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Data/DataCandidate/Cv/"), Cv_name);
Cv.SaveAs(path_cv);
}
//process to convert datetime
var birth_date = Convert.ToDateTime(DataNewCandidate.CANDIDATE_BIRTH_DATE);
var edu_start_date = Convert.ToDateTime(DataNewCandidate.EDUCATON_START_DATE);
var edu_end_date = Convert.ToDateTime(DataNewCandidate.EDUCATON_END_DATE);
//process insert data
db.TB_CANDIDATE.Add(new TB_CANDIDATE
{
CANDIDATE_ID = Candidate_ID,
CANDIDATE_NAME = DataNewCandidate.CANDIDATE_NAME,
CANDIDATE_AGE = DataNewCandidate.CANDIDATE_AGE,
CANDIDATE_BIRTH_DATE = birth_date,
CANDIDATE_PLACE_BIRTH = DataNewCandidate.CANDIDATE_PLACE_BIRTH,
MARITAL_STATUS_ID = DataNewCandidate.MARITAL_STATUS_ID,
GENDER_ID = DataNewCandidate.GENDER_ID,
RELIGION_ID = DataNewCandidate.RELIGION_ID,
CANDIDATE_ETNIC = DataNewCandidate.CANDIDATE_ETNIC,
CANDIDATE_PHONENUMBER = DataNewCandidate.CANDIDATE_PHONENUMBER,
CANDIDATE_EMAIL = DataNewCandidate.CANDIDATE_EMAIL,
CANDIDATE_CITY = DataNewCandidate.CANDIDATE_CITY,
CANDIDATE_PROVINCE = DataNewCandidate.CANDIDATE_PROVINCE,
CANDIDATE_CURRENT_ADDRESS = DataNewCandidate.CANDIDATE_CURRENT_ADDRESS,
CANDIDATE_KTP_NUMBER = DataNewCandidate.CANDIDATE_KTP_NUMBER,
CANDDIATE_NPWP_NUMBER = DataNewCandidate.CANDDIATE_NPWP_NUMBER,
CANDIDATE_CV = Cv_name,
CANDIDATE_PHOTO = pict_name,
CANDIDATE_LAST_EDUCATON = DataNewCandidate.CANDIDATE_LAST_EDUCATON,
CANDIDATE_GPA = DataNewCandidate.CANDIDATE_GPA,
CANDIDATE_MAJOR = DataNewCandidate.CANDIDATE_MAJOR,
CANDIDATE_DEGREE = DataNewCandidate.CANDIDATE_DEGREE,
CANDIDATE_STATE_ID = 1,
SOURCE = DataNewCandidate.SOURCE,
SOURCING_DATE = DateTime.Now,
CANDIDATE_ZIPCODE = DataNewCandidate.ZIP_CODE,
PARENT_ADDRESS = DataNewCandidate.PARENT_ADDRESS,
RESIDENT_CARD_NUMBER = DataNewCandidate.RESIDENT_CARD_NUMBER,
TELEPHONE_NUMBER = DataNewCandidate.TELEPHONE_NUMBER,
AVAILABLE_JOIN = DataNewCandidate.AVAILABLE_JOIN,
RECOMENDATION = DataNewCandidate.RECOMENDATION,
EXPECTED_SALARY = DataNewCandidate.EXPECTED_sALARY,
NOTES = DataNewCandidate.NOTES,
POSITION = DataNewCandidate.POSITION,
EDUCATION_START_DATE = edu_start_date,
EDUCATION_END_DATE = edu_end_date,
CANDIDATE_INTERVIEW_DATE = DataNewCandidate.CANDIDATE_INTERVIEW_DATE
});
int res = 0;
if (db.SaveChanges() > 0)
{
//insert skill
if (DataNewCandidate.CANDIDATE_SKILL != null)
{
foreach (string skill in DataNewCandidate.CANDIDATE_SKILL)
{
db.TB_CANDIDATE_SKILL.Add(new TB_CANDIDATE_SKILL
{
CANDIDATE_ID = db.TB_CANDIDATE.FirstOrDefault(c => c.CANDIDATE_ID == Candidate_ID).ID,
SKILL = skill
});
db.SaveChanges();
}
}
//insert selection history
UserDTO UserLogin = (UserDTO)HttpContext.Current.Session["UserLogin"];
Manage_CandidateSelectionHistoryDTO.AddData(new CandidateSelectionHistoryDTO
{
CANDIDATE_ID = db.TB_CANDIDATE.FirstOrDefault(ca => ca.CANDIDATE_ID == Candidate_ID).ID,
PIC_ID = UserLogin.USER_ID,
CANDIDATE_APPLIED_POSITION = DataNewCandidate.POSITION,
CANDIDATE_SUITABLE_POSITION = "-",
CANDIDATE_SOURCE = DataNewCandidate.SOURCE,
CANDIDATE_EXPECTED_SALARY = DataNewCandidate.EXPECTED_sALARY,
CANDIDATE_STATE = 1,
NOTES = DataNewCandidate.NOTES
});
db.SaveChanges();
res = 1;
}
return(new List <object>()
{
{ res }, { Candidate_ID }
});
}
}
//--------------------------------------------------------- edit data candidate -------------------------------------------------
public static int EditCandidate(CandidateDTO Data, HttpPostedFileBase Pict, HttpPostedFileBase Cv)
{
using (DBEntities db = new DBEntities())
{
TB_CANDIDATE Candidate = db.TB_CANDIDATE.FirstOrDefault(d => d.ID == Data.ID);
//process file pict candidate
string pict_name = "-";
if (Pict != null)
{
string pict_ext = Pict.FileName.Split('.')[1];
pict_name = "Pict_" + DateTime.Now.ToString("ffff") + "." + pict_ext;
string path_pict = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Data/DataCandidate/Pict/"), pict_name);
Pict.SaveAs(path_pict);
}
//process file Cv
string Cv_name = "-";
if (Cv != null)
{
string Cv_ext = Cv.FileName.Split('.')[1];
Cv_name = "Cv_" + DateTime.Now.ToString("ffff") + "." + Cv_ext;
string path_cv = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Data/DataCandidate/Cv/"), Cv_name);
Cv.SaveAs(path_cv);
}
//process to convert datetime
var birth_date = Convert.ToDateTime(Data.CANDIDATE_BIRTH_DATE);
var edu_start_date = Convert.ToDateTime(Data.EDUCATON_START_DATE);
var edu_end_date = Convert.ToDateTime(Data.EDUCATON_END_DATE);
//add selection history
if (Candidate.CANDIDATE_STATE_ID != Data.CANDIDATE_STATE_ID)
{
//insert selection history
UserDTO UserLogin = (UserDTO)HttpContext.Current.Session["UserLogin"];
db.TB_CANDIDATE_SELECTION_HISTORY.Add(new TB_CANDIDATE_SELECTION_HISTORY
{
CANDIDATE_ID = Data.ID,
PIC_ID = UserLogin.USER_ID,
CANDIDATE_APPLIED_POSITION = Data.POSITION,
CANDIDATE_SUITABLE_POSITION = Data.SUITABLE_POSITION,
CANDIDATE_SOURCE = Data.SOURCE,
CANDIDATE_EXPECTED_SALARY = Data.EXPECTED_sALARY,
CANDIDATE_STATE = Data.CANDIDATE_STATE_ID,
NOTES = Data.NOTES,
PROCESS_DATE = DateTime.Now,
CANDIDATE_INTERVIEW_DATE = Data.CANDIDATE_INTERVIEW_DATE
});
db.SaveChanges();
}
//process update data
Candidate.CANDIDATE_NAME = Data.CANDIDATE_NAME;
Candidate.CANDIDATE_AGE = Data.CANDIDATE_AGE;
Candidate.CANDIDATE_BIRTH_DATE = birth_date;
Candidate.CANDIDATE_PLACE_BIRTH = Data.CANDIDATE_PLACE_BIRTH;
Candidate.MARITAL_STATUS_ID = Data.MARITAL_STATUS_ID;
Candidate.GENDER_ID = Data.GENDER_ID;
Candidate.RELIGION_ID = Data.RELIGION_ID;
Candidate.CANDIDATE_ETNIC = Data.CANDIDATE_ETNIC;
Candidate.CANDIDATE_PHONENUMBER = Data.CANDIDATE_PHONENUMBER;
Candidate.CANDIDATE_EMAIL = Data.CANDIDATE_EMAIL;
Candidate.CANDIDATE_CITY = Data.CANDIDATE_CITY;
Candidate.CANDIDATE_PROVINCE = Data.CANDIDATE_PROVINCE;
Candidate.CANDIDATE_CURRENT_ADDRESS = Data.CANDIDATE_CURRENT_ADDRESS;
Candidate.CANDIDATE_KTP_NUMBER = Data.CANDIDATE_KTP_NUMBER;
Candidate.CANDDIATE_NPWP_NUMBER = Data.CANDDIATE_NPWP_NUMBER;
if (Cv != null)
{
Candidate.CANDIDATE_CV = Cv_name;
}
if (Pict != null)
{
Candidate.CANDIDATE_PHOTO = pict_name;
}
Candidate.CANDIDATE_LAST_EDUCATON = Data.CANDIDATE_LAST_EDUCATON;
Candidate.CANDIDATE_GPA = Data.CANDIDATE_GPA;
Candidate.CANDIDATE_MAJOR = Data.CANDIDATE_MAJOR;
Candidate.CANDIDATE_DEGREE = Data.CANDIDATE_DEGREE;
Candidate.CANDIDATE_STATE_ID = Data.CANDIDATE_STATE_ID;
Candidate.SOURCE = Data.SOURCE;
Candidate.SOURCING_DATE = DateTime.Now;
Candidate.CANDIDATE_ZIPCODE = Data.ZIP_CODE;
Candidate.PARENT_ADDRESS = Data.PARENT_ADDRESS;
Candidate.RESIDENT_CARD_NUMBER = Data.RESIDENT_CARD_NUMBER;
Candidate.TELEPHONE_NUMBER = Data.TELEPHONE_NUMBER;
Candidate.AVAILABLE_JOIN = Data.AVAILABLE_JOIN;
Candidate.RECOMENDATION = Data.RECOMENDATION;
Candidate.EXPECTED_SALARY = Data.EXPECTED_sALARY;
Candidate.NOTES = Data.NOTES;
Candidate.POSITION = Data.POSITION;
Candidate.SUITABLE_POSITION = Data.SUITABLE_POSITION;
Candidate.EDUCATION_START_DATE = edu_start_date;
Candidate.EDUCATION_END_DATE = edu_end_date;
Candidate.CANDIDATE_INTERVIEW_DATE = Data.CANDIDATE_INTERVIEW_DATE;
List <string> Skills = db.TB_CANDIDATE_SKILL.Where(d => d.CANDIDATE_ID == Data.ID).Select(d => d.SKILL).ToList();
if (Skills.Count > 0)
{
foreach (var d in db.TB_CANDIDATE_SKILL.Where(d => d.CANDIDATE_ID == Data.ID).ToList())
{
db.TB_CANDIDATE_SKILL.Remove(d);
}
}
foreach (var d in Data.CANDIDATE_SKILL)
{
db.TB_CANDIDATE_SKILL.Add(new TB_CANDIDATE_SKILL {
CANDIDATE_ID = Data.ID,
SKILL = d
});
}
return(db.SaveChanges());
}
}
public static int GetUserID()
{
UserDTO UserId = (UserDTO)HttpContext.Current.Session["UserLogin"];
return(UserId.USER_ID);
}
