public RegistrationInterview UpdateRegistrationInterviewApprovedBy(RegistrationInterviewDTO registrationInterviewDTO)
{
RegistrationInterview registrationInterview = GetRegistrationInterviewById(registrationInterviewDTO.Id);
registrationInterview.ReviewedBy = registrationInterviewDTO.ReviewedBy;
registrationInterview.CandidateFirstName = registrationInterviewDTO.CandidateFirstName;
registrationInterview.CandidateLastName = registrationInterviewDTO.CandidateLastName;
registrationInterview.UpdatedAt = DateTime.Now;
registrationInterview.DOB = registrationInterviewDTO.DOB;
registrationInterview.PhoneNumber = registrationInterviewDTO.PhoneNumber;
registrationInterview.SubjectToInterviewId = registrationInterview.SubjectToInterviewId;
if (registrationInterviewDTO.CreatedAtManagementUnitId == 26)
{
registrationInterview.Aspirations01DistrictId = registrationInterviewDTO.Aspirations01DistrictId;
registrationInterview.Aspirations02DistrictId = registrationInterviewDTO.Aspirations02DistrictId;
registrationInterview.Aspirations03DistrictId = registrationInterviewDTO.Aspirations03DistrictId;
registrationInterview.SchoolDegreeIdExpectedTeach = 5;
}
else
{
registrationInterview.SchoolDegreeIdExpectedTeach = registrationInterviewDTO.SchoolDegreeIdExpectedTeach;
}
registrationInterview.Email = registrationInterviewDTO.Email;
registrationInterview.ForeignLanguageDegreeId = registrationInterviewDTO.ForeignLanguageDegreeId;
registrationInterview.IsMale = registrationInterviewDTO.IsMale;
registrationInterview.DegreeClassificationId = registrationInterviewDTO.DegreeClassificationId;
registrationInterview.GraduatedAtYear = registrationInterviewDTO.GraduatedAtYear;
CurrentLivingAddress currentLivingAddress = _db.CurrentLivingAddresses.Where(s => s.Id == registrationInterview.CurrentLivingAddressId).SingleOrDefault();
currentLivingAddress.WardId = registrationInterviewDTO.CurrentLivingAddressId;
currentLivingAddress.HouseNumber = registrationInterviewDTO.CurrentLivingAddressHouseNumber;
HouseHold houseHold = _db.HouseHolds.Where(s => s.Id == registrationInterview.HouseHoldId).SingleOrDefault();
houseHold.WardId = registrationInterviewDTO.HouseHoldId;
houseHold.HouseNumber = registrationInterviewDTO.HouseHoldHouseNumber;
registrationInterview.StatusWorkingInEducationId = registrationInterviewDTO.StatusWorkingInEducationId;
registrationInterview.GraduationClassficationId = registrationInterviewDTO.GraduationClassficationId;
registrationInterview.SpecializedTranningId = registrationInterviewDTO.SpecializedTranningId;
registrationInterview.IsNienChe = registrationInterviewDTO.IsNienChe;
registrationInterview.GPA = registrationInterviewDTO.GPA;
if (registrationInterviewDTO.IsNienChe == true)
{
registrationInterview.CaptionProjectPoint = registrationInterviewDTO.CaptionProjectPoint;
}
registrationInterview.TrainningCatergoryId = registrationInterviewDTO.TrainningCatergoryId;
registrationInterview.HighestLevelEducationId = registrationInterviewDTO.HighestLevelEducationId;
if (registrationInterviewDTO.TrainningCatergoryId == 1 || registrationInterviewDTO.TrainningCatergoryId == 3 || registrationInterviewDTO.TrainningCatergoryId == 5)
{
registrationInterview.IsHadNghiepVuSupham = true;
}
registrationInterview.InfomationTechnologyDegreeId = registrationInterviewDTO.InfomationTechnologyDegreeId;
registrationInterview.UniversityLocation = registrationInterviewDTO.UniversityLocation;
registrationInterview.NamVaoNghanh = registrationInterviewDTO.NamVaoNghanh;
registrationInterview.MaNgach = registrationInterviewDTO.MaNgach;
registrationInterview.MocNangLuongLansau = registrationInterviewDTO.MocNangLuongLansau;
registrationInterview.HeSoLuong = registrationInterviewDTO.HeSoLuong;
_db.Entry(registrationInterview).State = EntityState.Modified;
_db.Entry(currentLivingAddress).State = EntityState.Modified;
_db.Entry(houseHold).State = EntityState.Modified;
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(registrationInterview = null);
}
return(GetRegistrationInterviewByIdWithDetail(registrationInterview.Id));
}
public RegistrationInterview CreateRegistrationInterview(string CandidateName, string IdentifyCard, int?ManagementUnitId, int?RegistrationPrice, int?CreatedBy)
{
RegistrationInterview registrationInterview = new RegistrationInterview();
CurrentLivingAddress currentLivingAddress = new CurrentLivingAddress();
currentLivingAddress.WardId = 26740;
_db.CurrentLivingAddresses.Add(currentLivingAddress);
HouseHold houseHold = new HouseHold();
houseHold.WardId = 26740;
_db.HouseHolds.Add(houseHold);
_db.SaveChanges();
string[] arrListStr = CandidateName.Split(' ');//tách trong chuỗi str trên khi gặp ký tự ' '
registrationInterview.CandidateFirstName = arrListStr[arrListStr.Length - 1].Trim();
string candidateLastName = "";
for (int i = 0; i < arrListStr.Length - 1; i++)
{
candidateLastName = candidateLastName + arrListStr[i] + " ";
}
registrationInterview.CandidateLastName = candidateLastName.Trim();
registrationInterview.IdentifyCard = IdentifyCard;
registrationInterview.Price = RegistrationPrice;
registrationInterview.CreatedAt = DateTime.Now;
registrationInterview.CreatedAtManagementUnitId = ManagementUnitId;
registrationInterview.CreatedBy = CreatedBy;
registrationInterview.DOB = DateTime.Now.AddDays(1).AddMonths(1);
registrationInterview.IsMale = true;
registrationInterview.CurrentLivingAddressId = currentLivingAddress.Id;
registrationInterview.HouseHoldId = houseHold.Id;
registrationInterview.GraduatedAtYear = Convert.ToInt16(DateTime.Now.Year);
registrationInterview.IsNienChe = true;
registrationInterview.UniversityLocation = 79;
registrationInterview.TrainningCatergoryId = 1;
registrationInterview.DegreeClassificationId = 1;
registrationInterview.HighestLevelEducationId = 1;
registrationInterview.SubjectToInterviewId = 1;
registrationInterview.InfomationTechnologyDegreeId = 1;
registrationInterview.ForeignLanguageDegreeId = 1;
registrationInterview.GraduationClassficationId = 1;
registrationInterview.SpecializedTranningId = 1;
registrationInterview.IsHadNghiepVuSupham = false;
registrationInterview.StatusWorkingInEducationId = 1;
if (ManagementUnitId == 26)
{
registrationInterview.Aspirations01DistrictId = 760;
registrationInterview.Aspirations02DistrictId = 769;
registrationInterview.Aspirations03DistrictId = 770;
registrationInterview.SchoolDegreeIdExpectedTeach = 5;
}
else
{
registrationInterview.SchoolDegreeIdExpectedTeach = 2;
}
_db.RegistrationInterviews.Add(registrationInterview);
_db.SaveChanges();
return(GetRegistrationInterviewByIdWithDetail(registrationInterview.Id));
}
