private static tblApplicantSubmited BindindToTable(ApplicantSubmitted appl)
{
var usr = new tblApplicantSubmited
{
AcquisitionId = appl.AcquisitionId,
Email = appl.Email,
FullName = appl.FullName,
CreatedDt = appl.CreatedDt,
ArmySelectionDt = appl.ArmySelectionDt,
ArmySelectionInd = appl.ArmySelectionInd,
ArmySelectionVenue = appl.ArmySelectionVenue,
ArmyServiceInd = appl.ArmyServiceInd,
ArmyServiceResignRemark = appl.ArmyServiceResignRemark,
ArmyServiceYrOfServ = appl.ArmyServiceYrOfServ,
BMI = appl.BMI,
BirthCertNo = appl.BirthCertNo,
BirthCityCd = appl.BirthCityCd,
BirthCountryCd = appl.BirthCountryCd,
BirthDt = appl.BirthDt.Value,
BirthPlace = appl.BirthPlace,
BirthStateCd = appl.BirthStateCd,
BloodTypeCd = appl.BloodTypeCd,
ChildNo = appl.ChildNo,
ColorBlindInd = appl.ColorBlindInd,
ComputerICT = appl.ComputerICT,
ComputerMSExcel = appl.ComputerMSExcel,
ComputerMSPwrPoint = appl.ComputerMSPwrPoint,
ComputerMSWord = appl.ComputerMSWord,
ComputerOthers = appl.ComputerOthers,
CorresponAddr1 = appl.CorresponAddr1,
CorresponAddr2 = appl.CorresponAddr2,
CorresponAddr3 = appl.CorresponAddr3,
CorresponAddrCityCd = appl.CorresponAddrCityCd,
CorresponAddrCountryCd = appl.CorresponAddrCountryCd,
CorresponAddrPostCd = appl.CorresponAddrPostCd,
CorresponAddrStateCd = appl.CorresponAddrStateCd,
CreatedBy = appl.CreatedBy,
CrimeInvolvement = appl.CrimeInvolvement,
CronicIlnessInd = appl.CronicIlnessInd,
CurrentOccupation = appl.CurrentOccupation,
CurrentOrganisation = appl.CurrentOrganisation,
CurrentSalary = appl.CurrentSalary,
DadICNo = appl.DadICNo,
DadName = appl.DadName,
DadNationalityCd = appl.DadNationalityCd,
DadNotApplicable = appl.DadNotApplicable,
DadNotApplicableInd = appl.DadNotApplicable,
DadOccupation = appl.DadOccupation,
DadPhoneNo = appl.DadPhoneNo,
DadSalary = appl.DadSalary,
DrugCaseInvolvement = appl.DrugCaseInvolvement,
EmployeeAggreeInd = appl.EmployeeAggreeInd,
EthnicCd = appl.EthnicCd,
FamilyHighestEduLevel = appl.FamilyHighestEduLevel,
GenderCd = appl.GenderCd,
GuardianICNo = appl.GuardianICNo,
GuardianName = appl.GuardianName,
GuardianNationalityCd = appl.GuardianNationalityCd,
GuardianNotApplicable = appl.GuardianNotApplicable,
GuardianNotApplicableInd = appl.GuardianNotApplicable,
GuardianOccupation = appl.GuardianOccupation,
GuardianPhoneNo = appl.GuardianPhoneNo,
GuardianSalary = appl.GuardianSalary,
Height = appl.Height,
HomePhoneNo = appl.HomePhoneNo,
LastModifiedBy = appl.LastModifiedBy,
LastModifiedDt = appl.LastModifiedDt,
MobilePhoneNo = appl.MobilePhoneNo,
MomICNo = appl.MomICNo,
MomName = appl.MomName,
MomNationalityCd = appl.MomNationalityCd,
MomNotApplicable = appl.MomNotApplicable,
MomNotApplicableInd = appl.MomNotApplicable,
MomOccupation = appl.MomOccupation,
MomPhoneNo = appl.MomPhoneNo,
MomSalary = appl.MomSalary,
MrtlStatusCd = appl.MrtlStatusCd,
NationalityCd = appl.NationalityCd,
NationalityCertNo = appl.NationalityCertNo,
NewICNo = appl.NewICNo,
NoOfSibling = appl.NoOfSibling,
NoTentera = appl.NoTentera,
OriginalPelepasanDocument = appl.OriginalPelepasanDocument,
PalapesArmyNo = appl.PalapesArmyNo,
PalapesInd = appl.PalapesInd,
PalapesInstitution = appl.PalapesInstitution,
PalapesRemark = appl.PalapesRemark,
PalapesServices = appl.PalapesServices,
PalapesTauliahEndDt = appl.PalapesTauliahEndDt,
PalapesYear = appl.PalapesYear,
PelepasanDocument = appl.PelepasanDocument,
RaceCd = appl.RaceCd,
ReligionCd = appl.ReligionCd,
ResidenceTypeInd = appl.ResidenceTypeInd,
ScholarshipBody = appl.ScholarshipBody,
ScholarshipBodyAddr = appl.ScholarshipBodyAddr,
ScholarshipContractStDate = appl.ScholarshipContractStDate,
ScholarshipInd = appl.ScholarshipInd,
ScholarshipNoOfYrContract = appl.ScholarshipNoOfYrContract,
SelectionTD = appl.SelectionTD,
SelectionTL = appl.SelectionTL,
SelectionTU = appl.SelectionTU,
SpectaclesUserInd = appl.SpectaclesUserInd,
Weight = appl.Weight
};
return usr;
}
private static ApplicantSubmitted BindingToClass(tblApplicantSubmited appl)
{
var usr = new ApplicantSubmitted();
usr.ApplicantId = appl.ApplicantId;
usr.AcquisitionId = appl.AcquisitionId;
usr.Email = appl.Email;
usr.FullName = appl.FullName;
usr.CreatedDt = appl.CreatedDt;
usr.ArmySelectionDt = appl.ArmySelectionDt;
usr.ArmySelectionInd = appl.ArmySelectionInd;
usr.ArmySelectionVenue = appl.ArmySelectionVenue;
usr.ArmyServiceInd = appl.ArmyServiceInd;
usr.ArmyServiceResignRemark = appl.ArmyServiceResignRemark;
usr.ArmyServiceYrOfServ = appl.ArmyServiceYrOfServ;
usr.BMI = appl.BMI;
usr.BirthCertNo = appl.BirthCertNo;
usr.BirthCityCd = appl.BirthCityCd;
usr.BirthCountryCd = appl.BirthCountryCd;
usr.BirthDt = appl.BirthDt;
usr.BirthPlace = appl.BirthPlace;
usr.BirthStateCd = appl.BirthStateCd;
usr.BirthStateName = appl.tblREFState != null ? appl.tblREFState.State : string.Empty;
usr.BloodTypeCd = appl.BloodTypeCd;
usr.ChildNo = appl.ChildNo;
usr.ColorBlindInd = appl.ColorBlindInd;
usr.ComputerICT = appl.ComputerICT;
usr.ComputerMSExcel = appl.ComputerMSExcel;
usr.ComputerMSPwrPoint = appl.ComputerMSPwrPoint;
usr.ComputerMSWord = appl.ComputerMSWord;
usr.ComputerOthers = appl.ComputerOthers;
usr.CorresponAddr1 = appl.CorresponAddr1;
usr.CorresponAddr2 = appl.CorresponAddr2;
usr.CorresponAddr3 = appl.CorresponAddr3;
usr.CorresponAddrCityCd = appl.CorresponAddrCityCd;
usr.CorresponAddrCountryCd = appl.CorresponAddrCountryCd;
usr.CorresponAddrPostCd = appl.CorresponAddrPostCd;
usr.CorresponAddrStateCd = appl.CorresponAddrStateCd;
usr.CreatedBy = appl.CreatedBy;
usr.CrimeInvolvement = appl.CrimeInvolvement;
usr.CronicIlnessInd = appl.CronicIlnessInd;
usr.CurrentOccupation = appl.CurrentOccupation;
usr.CurrentOrganisation = appl.CurrentOrganisation;
usr.CurrentSalary = appl.CurrentSalary;
usr.DadICNo = appl.DadICNo;
usr.DadName = appl.DadName;
usr.DadNationalityCd = appl.DadNationalityCd;
usr.DadNotApplicable = appl.DadNotApplicable;
usr.DadOccupation = appl.DadOccupation;
usr.DadPhoneNo = appl.DadPhoneNo;
usr.DadSalary = appl.DadSalary;
usr.DrugCaseInvolvement = appl.DrugCaseInvolvement;
usr.EmployeeAggreeInd = appl.EmployeeAggreeInd;
usr.EthnicCd = appl.EthnicCd;
usr.FamilyHighestEduLevel = appl.FamilyHighestEduLevel;
usr.GenderCd = appl.GenderCd;
usr.GuardianICNo = appl.GuardianICNo;
usr.GuardianName = appl.GuardianName;
usr.GuardianNationalityCd = appl.GuardianNationalityCd;
usr.GuardianNotApplicable = appl.GuardianNotApplicable;
usr.GuardianOccupation = appl.GuardianOccupation;
usr.GuardianPhoneNo = appl.GuardianPhoneNo;
usr.GuardianSalary = appl.GuardianSalary;
usr.Height = appl.Height;
usr.HomePhoneNo = appl.HomePhoneNo;
usr.LastModifiedBy = appl.LastModifiedBy;
usr.LastModifiedDt = appl.LastModifiedDt;
usr.MobilePhoneNo = appl.MobilePhoneNo;
usr.MomICNo = appl.MomICNo;
usr.MomName = appl.MomName;
usr.MomNationalityCd = appl.MomNationalityCd;
usr.MomNotApplicable = appl.MomNotApplicable;
usr.MomOccupation = appl.MomOccupation;
usr.MomPhoneNo = appl.MomPhoneNo;
usr.MomSalary = appl.MomSalary;
usr.MrtlStatusCd = appl.MrtlStatusCd;
usr.NationalityCd = appl.NationalityCd;
usr.NationalityCertNo = appl.NationalityCertNo;
usr.NewICNo = appl.NewICNo;
usr.NoOfSibling = appl.NoOfSibling;
usr.NoTentera = appl.NoTentera;
usr.OriginalPelepasanDocument = appl.OriginalPelepasanDocument;
usr.PalapesArmyNo = appl.PalapesArmyNo;
usr.PalapesInd = appl.PalapesInd;
usr.PalapesInstitution = appl.PalapesInstitution;
usr.PalapesRemark = appl.PalapesRemark;
usr.PalapesServices = appl.PalapesServices;
usr.PalapesTauliahEndDt = appl.PalapesTauliahEndDt;
usr.PalapesYear = appl.PalapesYear;
usr.PelepasanDocument = appl.PelepasanDocument;
usr.RaceCd = appl.RaceCd;
usr.ReligionCd = appl.ReligionCd;
usr.ResidenceTypeInd = appl.ResidenceTypeInd;
usr.ScholarshipBody = appl.ScholarshipBody;
usr.ScholarshipBodyAddr = appl.ScholarshipBodyAddr;
usr.ScholarshipContractStDate = appl.ScholarshipContractStDate;
usr.ScholarshipInd = appl.ScholarshipInd;
usr.ScholarshipNoOfYrContract = appl.ScholarshipNoOfYrContract;
usr.SelectionTD = appl.SelectionTD;
usr.SelectionTL = appl.SelectionTL;
usr.SelectionTU = appl.SelectionTU;
usr.SpectaclesUserInd = appl.SpectaclesUserInd;
usr.Weight = appl.Weight;
if (!string.IsNullOrWhiteSpace(appl.CorresponAddrStateCd))
{
if (appl.tblREFState1 != null)
usr.CorresponAddrStateNm = appl.tblREFState1.State;
}
if (!string.IsNullOrWhiteSpace(appl.CorresponAddrCityCd))
{
if (appl.tblREFCity1 != null)
usr.CorresponAddrCityNm = appl.tblREFCity1.City;
}
return usr;
}