public GetProcessCardMasterQM GetProcessCardMaster(decimal PartCode) { GetProcessCardMasterQM model = new GetProcessCardMasterQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetProcessCardMasterSelectCommand { Connection = connection }; model = command.Execute(PartCode); } return(model); }
public GetProcessCardMasterQM Execute(decimal PartCode) { var response = new GetProcessCardMasterQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetProcessCardMaster]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@PartCode", SsDbType.Decimal, ParameterDirection.Input, PartCode)); //sqlCommand.Parameters.Add(AddParameter("@SequenceNumber", SsDbType.Decimal, ParameterDirection.Input, SequenceNumber)); using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.GetProcessCardMasterModelList = reader.ToList <GetProcessCardMasterQMModel>(); } } return(response); }
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); }