public List <ExperienceDetails> getExperienceDetails_byCId(int cId)
{
_param = new SqlParameter[] { new SqlParameter("@cId", cId) };
_dt = _sf.returnDTWithProc_executeReader("p_tblExperienceDetails_get_byCId", _param);
List <ExperienceDetails> listExpDetail = new List <ExperienceDetails>();
if (_dt.Rows.Count > 0)
{
foreach (DataRow row in _dt.Rows)
{
ExperienceDetails ex = new ExperienceDetails();
ex.expId = Convert.ToInt32(row["expId"]);
ex.occupation = Convert.ToString(row["occupation"]);
ex.company = Convert.ToString(row["company"]);
ex.summery = Convert.ToString(row["summery"]);
ex.currentlyWork = Convert.ToBoolean(row["currentlyWork"]);
ex.fromMonth = Convert.ToString(row["fromMonth"]);
ex.fromYear = Convert.ToInt32(row["fromYear"]);
ex.toMonth = Convert.ToString(row["toMonth"]);
ex.toYear = Convert.ToInt32(row["toYear"]);
listExpDetail.Add(ex);
}
}
return(listExpDetail);
}
public int saveExperienceDetails(ExperienceDetails ex)
{
_param = new SqlParameter[] { new SqlParameter("@expId", ex.expId), new SqlParameter("@cId", ex.cId), new SqlParameter("@occupation", ex.occupation), new SqlParameter("@company", ex.company), new SqlParameter("@summery", ex.summery), new SqlParameter("@currentlyWork", ex.currentlyWork), new SqlParameter("@fromMonth", ex.fromMonth), new SqlParameter("@fromYear", ex.fromYear), new SqlParameter("@toMonth", ex.toMonth), new SqlParameter("@toYear", ex.toYear) };
return(_sf.executeNonQueryWithProc("p_tblExperienceDetails_save", _param));
}
private void SaveUser(RegisterFormModel rfm)
{
var fileName = DateTime.Now.ToString("yyyymmddMMss") +
rfm.PersonalDetail.FirstName +
rfm.PersonalDetail.LastName +
System.IO.Path.GetExtension(rfm.PersonalDetail.ResumeFile.FileName); //datetime needed?
var user = new User()
{
FirstName = rfm.PersonalDetail.FirstName,
LastName = rfm.PersonalDetail.LastName,
Password = rfm.PersonalDetail.Password, //must encrypt
Email = rfm.PersonalDetail.Email,
ContactNumber = rfm.PersonalDetail.ContactNumber,
Role = _context.Role.First(ut => ut.Type == "JobSeeker"),
ResumeFileName = fileName,
DOB = rfm.PersonalDetail.DOB,
CreatedDate = DateTime.Now
};
_context.User.Add(user);
SaveFile(rfm.PersonalDetail.ResumeFile, fileName);
foreach (var ed in rfm.ExperienceDetails)
{
var experienceDetail = new ExperienceDetails()
{
Seeker = user,
CompanyName = ed.CompanyName,
JobTitle = ed.JobTitle,
StartDate = ed.StartDate,
EndDate = ed.EndDate,
Type = ed.Type
};
_context.ExperienceDetails.Add(experienceDetail);
_context.SaveChanges();
foreach (var skill in ed.SkillId)
{
//experienceDetail.Skills.Add(new Skill() { Id = Convert.ToInt32(skill) });
_context.UserExperienceSkill.Add(new UserExperienceSkill {
SeekerId = user.Id,
ExperienceDetailId = experienceDetail.Id,
SkillId = Convert.ToInt32(skill)
});
}
}
var eduDetail = new EducationDetails()
{
Seeker = user,
HighestQualification = rfm.EducationDetail.HighestQualification,
InstituteOrUniversityName = rfm.EducationDetail.InstituteOrUniversityName,
MajorBranch = rfm.EducationDetail.MajorBranch,
Percentage = rfm.EducationDetail.Percentage,
EducationTypeId = Convert.ToInt32(rfm.EducationDetail.Type)
};
_context.EducationDetails.Add(eduDetail);
_context.SaveChanges();
}
