public static List<Province> GetAllProvinces()
{
var returnListProvinces = new List<Province>();
var dataTable = new DataTable();
var dao = new DaoCommonInfo();
dataTable = dao.GetAllProvince();
if (dataTable != null && dataTable.Rows.Count > 0)
{
for (int i = 0; i < dataTable.Rows.Count; i++)
{
var province = new Province(dataTable.Rows[i]["ProvinceId"].ToString(), dataTable.Rows[i]["ProvinceName"].ToString());
returnListProvinces.Add(province);
}
}
return returnListProvinces;
}
public void SetFullInfo()
{
var dao = new DaoUser();
DataTable infoTable = dao.GetFullUserInforById(Convert.ToInt32(UserId));
FirstName = infoTable.Rows[0]["FirstName"].ToString();
LastName = infoTable.Rows[0]["LastName"].ToString();
DateBirthDay = Convert.ToDateTime(infoTable.Rows[0]["DateOfBirth"]);
Sex = new Sex(infoTable.Rows[0]["SexID"].ToString(), infoTable.Rows[0]["SexName"].ToString());
PhoneNumber = infoTable.Rows[0]["PhoneNumber"].ToString();
Races = new Races(infoTable.Rows[0]["RaceID"].ToString(), infoTable.Rows[0]["RaceName"].ToString());
Province = new Province( infoTable.Rows[0]["ProvinceID"].ToString(),infoTable.Rows[0]["ProvinceName"].ToString());
District = new District(infoTable.Rows[0]["DistrictID"].ToString(), infoTable.Rows[0]["DistrictName"].ToString(),
Province, Convert.ToInt32(infoTable.Rows[0]["Latitude"]), Convert.ToInt32(infoTable.Rows[0]["Longitude"]));
Address = new Address(Province, District);
JobIndustries = new JobIndustries(infoTable.Rows[0]["JobIndustryID"].ToString(),infoTable.Rows[0]["JobIndustryName"].ToString());
MaximOfLife = infoTable.Rows[0]["MaximOfLife"].ToString();
ThumImg = infoTable.Rows[0]["PhotoPath"].ToString();
}
public bool SetFullJobInfo(string jobTitle, Certificate certificate, JobSalaryLevel salary,
Province location, JobIndustries category, string jobDatail,
string jobDescription, DateTime deadLine, JobPosition jobPostion,
ExperienceLevel jobExperienceLevel, WorkType worktype,
Recruitor recruitor, string numsApplicant, string jobid)
{
JobId = jobid;
JobTitle = jobTitle;
Certificate = certificate;
JobSalaryLevel = salary;
Province = location;
JobIndustries = category;
ContentDetail = jobDatail;
Description = jobDescription;
ExpiredDate = deadLine;
WorkType = worktype;
JobPosition = jobPostion;
ExperienceLevel = jobExperienceLevel;
Recruitor = recruitor;
NumsApplicant = numsApplicant;
return SaveJobInfoUpdate();
}
public int SetFullJobInfo(string jobTitle, Certificate certificate, JobSalaryLevel salary,
Province location, JobIndustries category, string jobDatail, string jobDescription,
DateTime expiredDate, JobPosition jobPosition, ExperienceLevel experience, WorkType type, Recruitor recruitor, string numsApplicant)
{
JobTitle = jobTitle;
Certificate = certificate;
JobSalaryLevel = salary;
Province = location;
JobIndustries = category;
ContentDetail = jobDatail;
Description = jobDescription;
ExpiredDate = expiredDate;
WorkType = type;
JobPosition = jobPosition;
ExperienceLevel = experience;
Recruitor = recruitor;
NumsApplicant = numsApplicant;
return SaveJobInfo();
}
public void SetFullJobInfo()
{
var dao = new DaoJobs();
DataTable infoTable = dao.GetFullJobInforById(Convert.ToInt32(JobId));
ContentDetail = infoTable.Rows[0]["ContentDetail"].ToString();
Description = infoTable.Rows[0]["Description"].ToString();
JobTitle = infoTable.Rows[0]["FullTitle"].ToString();
NumsApplicant = infoTable.Rows[0]["NumsApplicant"].ToString();
ExpiredDate = Convert.ToDateTime(infoTable.Rows[0]["ExpiredDate"]);
JobSalaryLevel = new JobSalaryLevel(infoTable.Rows[0]["SalaryLevelID"].ToString(), infoTable.Rows[0]["SalaryLevel"].ToString());
JobIndustries = new JobIndustries(infoTable.Rows[0]["JobIndustryID"].ToString(), infoTable.Rows[0]["JobIndustryName"].ToString());
Province = new Province(infoTable.Rows[0]["ProvinceID"].ToString(), infoTable.Rows[0]["ProvinceName"].ToString());
JobPosition = new JobPosition(infoTable.Rows[0]["JobPositionID"].ToString(), infoTable.Rows[0]["JobPositionName"].ToString());
JobIndustries = new JobIndustries(infoTable.Rows[0]["JobIndustryID"].ToString(), infoTable.Rows[0]["JobIndustryName"].ToString());
WorkType = new WorkType(infoTable.Rows[0]["WorkTypeID"].ToString(), infoTable.Rows[0]["WorkTypeName"].ToString());
Certificate = new Certificate(infoTable.Rows[0]["CertificateID"].ToString(), infoTable.Rows[0]["CertificateName"].ToString());
ExperienceLevel = new ExperienceLevel(infoTable.Rows[0]["ExperienceLevelID"].ToString(), infoTable.Rows[0]["ExperienceLevelName"].ToString());
RewriteUrl = infoTable.Rows[0]["RewriteUrl"].ToString();
var companySize = new CompanySize(infoTable.Rows[0]["CompanySizeID"].ToString(), infoTable.Rows[0]["CompanySize"].ToString());
Recruitor = new Recruitor(infoTable.Rows[0]["CompanyFullName"].ToString(), infoTable.Rows[0]["RecruitorName"].ToString(), companySize, infoTable.Rows[0]["Address"].ToString());
}
public void SetFullResumeInfo()
{
var dao = new DaoResume();
DataTable infoTable = dao.GetFullResumeInfoById(Convert.ToInt32(ResumeId));
Certificate = new Certificate(infoTable.Rows[0]["CertificateID"].ToString(), infoTable.Rows[0]["CertificateName"].ToString());
LangSkill = new LangSkill(infoTable.Rows[0]["SkillID"].ToString(), infoTable.Rows[0]["SkillName"].ToString());
JobSalaryLevel = new JobSalaryLevel(infoTable.Rows[0]["SalaryLevelID"].ToString(), infoTable.Rows[0]["SalaryLevel"].ToString());
Province = new Province(infoTable.Rows[0]["ProvinceID"].ToString(), infoTable.Rows[0]["ProvinceName"].ToString());
JobIndustries = new JobIndustries(infoTable.Rows[0]["JobIndustryID"].ToString(), infoTable.Rows[0]["JobIndustryName"].ToString());
JobPosition = new JobPosition(infoTable.Rows[0]["JobPositionID"].ToString(), infoTable.Rows[0]["JobPositionName"].ToString());
User=new User(infoTable.Rows[0]["UserID"].ToString());
ExperienceLevel = new ExperienceLevel(infoTable.Rows[0]["ExperienceLevelID"].ToString(), infoTable.Rows[0]["ExperienceLevelName"].ToString());
WorkType = new WorkType(infoTable.Rows[0]["WorkTypeID"].ToString(), infoTable.Rows[0]["WorkTypeName"].ToString());
Achievement = infoTable.Rows[0]["ACHIEVEMENTS"].ToString();
CareerGoal = infoTable.Rows[0]["CAREER_GOALS"].ToString();
WorkExperience = infoTable.Rows[0]["WORK_EXPERIENCE"].ToString();
Literacy = infoTable.Rows[0]["LITERACY"].ToString();
Skill = infoTable.Rows[0]["SKILLS"].ToString();
Reference = infoTable.Rows[0]["REFERENCE"].ToString();
ContactEmail = infoTable.Rows[0]["ContactEmail"].ToString();
ResumeName = infoTable.Rows[0]["ResumeName"].ToString();
Atachment = infoTable.Rows[0]["ATTACHMENT"].ToString();
}
public bool SetFullResumeInfoUpdate(string resumeTitle, Certificate certificate, JobSalaryLevel salary,
LangSkill langSkill, Province location, JobIndustries category, JobPosition expectedPosition,
ExperienceLevel jobExperienceLevel, WorkType worktype, string jobAchievement, string careerGoal,
string experience, string literacy, string skill, string reference, User user, string contactMail, string resumeId, string attachFile)
{
ResumeId = resumeId;
ResumeName = resumeTitle;
Certificate = certificate;
JobSalaryLevel = salary;
LangSkill = langSkill;
Province = location;
JobIndustries = category;
JobPosition = expectedPosition;
ExperienceLevel = jobExperienceLevel;
WorkType = worktype;
Achievement = jobAchievement;
CareerGoal = careerGoal;
WorkExperience = experience;
Literacy = literacy;
Skill = skill;
Reference = reference;
User = user;
ContactEmail = contactMail;
Atachment = attachFile;
return SaveResumeInfoUpdate();
}