private static Application BindingToClass(tblApplication exist) { var app = new Application { AppId = exist.AppId, AcquisitionId = exist.AcquisitionId ?? 0, ApplicantId = exist.ApplicantId ?? 0, ApplicationStatus = exist.ApplicationStatus, ArmyNo = exist.ArmyNo, CreatedBy = exist.CreatedBy, CreatedDt = exist.CreatedDt, LastModifiedBy = exist.LastModifiedBy, LastModifiedDt = exist.LastModifiedDt, DentalExamine = exist.DentalExamine, FinalSelectionInd = exist.FinalSelectionInd, FinalSelectionRemark = exist.FinalSelectionRemark, FinalShortlistedInd = exist.FinalShortlistedInd, FirstSelActualAcqLocationId = exist.FirstSelActualAcqLocationId, FirstSelectionAttdnInd = exist.FirstSelectionAttdnInd, FirstSelectionDate = exist.FirstSelectionDate, FirstSelectionInd = exist.FirstSelectionInd, FirstShortlistedInd = exist.FirstShortlistedInd, InvitationFirstSel = exist.InvitationFirstSel, MedicalExamine = exist.MedicalExamine, Panel1Score = exist.Panel1Score, Panel2Score = exist.Panel2Score, Panel3Score = exist.Panel3Score, PhysicalExamination = exist.PhysicalExamination, PhysicalTest = exist.PhysicalTest, ReportDuty = exist.ReportDuty, SecurityAADK = exist.SecurityAADK, SecurityAADKRemark = exist.SecurityAADKRemark, SecurityBSPP = exist.SecurityBSPP, SecurityBSPPRemark = exist.SecurityBSPPRemark, SecurityJPN = exist.SecurityJPN, SecurityJPNRemark = exist.SecurityJPNRemark, SecurityKPM = exist.SecurityKPM, SecurityKPMRemark = exist.SecurityKPMRemark, SecurityPDRM = exist.SecurityPDRM, SecurityPDRMRemark = exist.SecurityPDRMRemark, SecurityStatus = exist.SecurityStatus, SelectedAcqLocationId = exist.SelectedAcqLocationId, SelectionCenterId = exist.SelectionCenterId, SuppDocumentReview = exist.SuppDocumentReview, Urine = exist.Urine, WrittenTest = exist.WrittenTest, ReportDutyLocId = exist.ReportDutyLocId, ReportDutyDate = exist.ReportDutyDate, FinalSelectionEndDate = exist.FinalSelectionEndDate, FinalSelectionStartDate = exist.FinalSelectionStartDate, FinalSelActualAcqLocationId = exist.FinalSelActualAcqLocationId, NoKawalan = exist.NoKawalan, FinalServiceCd = exist.FinalServiceCd, FirstSelectionEndDate = exist.FirstSelectionEndDate, }; if (exist.AcquisitionId.HasValue) app.Acquisition = ObjectBuilder.GetObject<IAcquisitionPersistence>("AcquisitionPersistence") .GetAcquisition(exist.AcquisitionId.Value); if (exist.ApplicantId.HasValue && exist.AcquisitionId.HasValue) app.ApplicantSubmitted = ObjectBuilder.GetObject<IApplicantSubmittedPersistence>("ApplicantSubmittedPersistence") .GetApplicant(exist.ApplicantId.Value, exist.AcquisitionId.Value); if (exist.ReportDutyLocId.HasValue) if (exist.tblREFReportDutyLoc != null) app.ReportDutyLocation = new Location() { LocationId = exist.tblREFReportDutyLoc.ReportDutyLocId, LocationNm = exist.tblREFReportDutyLoc.ReportDutyLoc }; if (exist.FinalSelActualAcqLocationId.HasValue) app.FinalSelectionLocation = ObjectBuilder.GetObject<IAcquisitionPersistence>("AcquisitionPersistence").GetLocation(exist.FinalSelActualAcqLocationId.Value); if (exist.FirstSelActualAcqLocationId.HasValue) app.FirstSelectionLocation = ObjectBuilder.GetObject<IAcquisitionPersistence>("AcquisitionPersistence").GetLocation(exist.FirstSelActualAcqLocationId.Value); return app; }
public int AddNew(Application application) { using (var entities = new atmEntities()) { var exist = (from a in entities.tblApplications where a.ApplicantId == application.ApplicantId && a.AcquisitionId == application.AcquisitionId select a).SingleOrDefault(); if (null != exist) { application.AppId = exist.AppId; return Update(application); } var app = new tblApplication { AcquisitionId = application.AcquisitionId, ApplicantId = application.ApplicantId, ApplicationStatus = application.ApplicationStatus, ArmyNo = application.ArmyNo, CreatedBy = application.CreatedBy, CreatedDt = DateTime.Now, DentalExamine = application.DentalExamine, FinalSelectionInd = application.FinalSelectionInd, FinalSelectionRemark = application.FinalSelectionRemark, FinalShortlistedInd = application.FinalShortlistedInd, FirstSelActualAcqLocationId = application.FirstSelActualAcqLocationId, FirstSelectionAttdnInd = application.FirstSelectionAttdnInd, FirstSelectionDate = application.FirstSelectionDate, FirstSelectionInd = application.FirstSelectionInd, FirstShortlistedInd = application.FirstShortlistedInd, InvitationFirstSel = application.InvitationFirstSel, MedicalExamine = application.MedicalExamine, Panel1Score = application.Panel1Score, Panel2Score = application.Panel2Score, Panel3Score = application.Panel3Score, PhysicalExamination = application.PhysicalExamination, PhysicalTest = application.PhysicalTest, ReportDuty = application.ReportDuty, SecurityAADK = application.SecurityAADK, SecurityAADKRemark = application.SecurityAADKRemark, SecurityBSPP = application.SecurityBSPP, SecurityBSPPRemark = application.SecurityBSPPRemark, SecurityJPN = application.SecurityJPN, SecurityJPNRemark = application.SecurityJPNRemark, SecurityKPM = application.SecurityKPM, SecurityKPMRemark = application.SecurityKPMRemark, SecurityPDRM = application.SecurityPDRM, SecurityPDRMRemark = application.SecurityPDRMRemark, SecurityStatus = application.SecurityStatus, SelectedAcqLocationId = application.SelectedAcqLocationId, SelectionCenterId = application.SelectionCenterId, SuppDocumentReview = application.SuppDocumentReview, Urine = application.Urine, WrittenTest = application.WrittenTest, FinalSelActualAcqLocationId = application.FinalSelActualAcqLocationId, FinalSelectionEndDate = application.FinalSelectionEndDate, FinalSelectionStartDate = application.FinalSelectionStartDate, FinalServiceCd = application.FinalServiceCd, FirstSelectionEndDate = application.FirstSelectionEndDate, NoKawalan = application.NoKawalan, ReportDutyDate = application.ReportDutyDate, ReportDutyLocId = application.ReportDutyLocId, }; entities.tblApplications.Add(app); if (entities.SaveChanges() > 0) return app.AppId; } return 0; }