public void AddJobCardMasterAndDetails(AddJobCardMasterAndDetailsCM addJobCardMasterAndDetailsCM) { using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new JobCardMasterAndDetailsInsertCommand { Connection = connection }; command.Execute(addJobCardMasterAndDetailsCM.AddJobCardMasterCMList.ToDataTableWithNull(), addJobCardMasterAndDetailsCM.AddJobCardDetailsCMList.ToDataTableWithNull()); } }
public AddJobCardGenerationResponseDto AddJobCardGeneration(AddJobCardGenerationRequestDto addJobCardGenerationRequestDto) { AddJobCardGenerationResponseDto response = new AddJobCardGenerationResponseDto(); AddJobCardMasterAndDetailsCM addJobCardMasterAndDetailsCM = new AddJobCardMasterAndDetailsCM(); foreach (var request in addJobCardGenerationRequestDto.addJobCardGenerationRequestList) { GetProcessCardMasterQM getProcessCardMasterQM = new GetProcessCardMasterQM(); GetProcessCardDetailsQM getProcessCardDetailsQM = new GetProcessCardDetailsQM(); AddJobCardMasterCM addJobCardMasterCM = new AddJobCardMasterCM(); AddJobCardDetailsCM addJobCardDetailsCM = new AddJobCardDetailsCM(); var addJobCardMasterList = new List <AddJobCardMasterCM>(); var addJobCardDetailsList = new List <AddJobCardDetailsCM>(); #region Process Card Master and Details Information getProcessCardMasterQM = jobCardGenerationRepository.GetProcessCardMaster(request.PartCode); getProcessCardDetailsQM = jobCardGenerationRepository.GetProcessCardDetails(request.PartCode); #endregion #region Save JobCard Master and Details foreach (var processCardMaster in getProcessCardMasterQM.GetProcessCardMasterModelList) { addJobCardMasterCM = new AddJobCardMasterCM() { SerialNo = request.SerialNo, JobCardDate = System.DateTime.UtcNow, PartCode = processCardMaster.PartCode, SequenceNumber = processCardMaster.SequenceNumber, MachineCode = processCardMaster.MachineCode, JigCode = processCardMaster.JigCode, SettingTime = processCardMaster.SettingTime, RunningTime = processCardMaster.RunningTime, CreatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove CreatedDateTime = System.DateTime.UtcNow }; addJobCardMasterList.Add(addJobCardMasterCM); } foreach (var processCardDetails in getProcessCardDetailsQM.GetProcessCardDetailsQMModelList) { addJobCardDetailsCM = new AddJobCardDetailsCM() { SerialNo = request.SerialNo, PartCode = processCardDetails.PartCode, SequenceNumber = processCardDetails.SequenceNumber, Serial = processCardDetails.Serial, Description = processCardDetails.Description, DimensionMin = processCardDetails.DimensionMin, DimensionMax = processCardDetails.DimensionMax, ParameterCode = processCardDetails.ParameterCode, InstrumentCode = processCardDetails.InstrumentCode, ToolCode = processCardDetails.ToolCode, DRFlag = processCardDetails.DRFlag, Symbol = processCardDetails.Symbol, Datum = processCardDetails.Datum, DatumDimension = processCardDetails.DatumDimension, BooleanNumber = processCardDetails.BooleanNumber, CreatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove CreatedDateTime = System.DateTime.UtcNow }; addJobCardDetailsList.Add(addJobCardDetailsCM); } addJobCardMasterAndDetailsCM = new AddJobCardMasterAndDetailsCM() { AddJobCardMasterCMList = addJobCardMasterList, AddJobCardDetailsCMList = addJobCardDetailsList }; jobCardGenerationRepository.AddJobCardMasterAndDetails(addJobCardMasterAndDetailsCM); #endregion } return(response); }