public void AddProcessCard(AddProcessCardCM addProcessCardCM) { using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new ProcessCardInsertCommand { Connection = connection }; command.Execute(addProcessCardCM.IsNew, addProcessCardCM.PartCode, addProcessCardCM.SequenceNumber, addProcessCardCM.MachineCode, addProcessCardCM.JigCode, addProcessCardCM.SettingTime, addProcessCardCM.RunningTime, addProcessCardCM.ListProcessCardDetails.ToDataTableWithNull(), addProcessCardCM); } }
public void Execute(bool IsNew, decimal PartCode, decimal SequenceNumber, string MachineCode, string JigCode, string SettingTime, string RunningTime, DataTable dataTableForProcessCardDetails, AddProcessCardCM model) { using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspAddProcessCard]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@IsNew", SsDbType.Bit, ParameterDirection.Input, IsNew)); sqlCommand.Parameters.Add(AddParameter("@PartCode", SsDbType.Decimal, ParameterDirection.Input, PartCode)); sqlCommand.Parameters.Add(AddParameter("@SequenceNumber", SsDbType.Decimal, ParameterDirection.Input, SequenceNumber)); sqlCommand.Parameters.Add(AddParameter("@MachineCode", SsDbType.VarChar, ParameterDirection.Input, MachineCode)); sqlCommand.Parameters.Add(AddParameter("@JigCode", SsDbType.VarChar, ParameterDirection.Input, JigCode)); sqlCommand.Parameters.Add(AddParameter("@SettingTime", SsDbType.VarChar, ParameterDirection.Input, SettingTime)); sqlCommand.Parameters.Add(AddParameter("@RunningTime", SsDbType.VarChar, ParameterDirection.Input, RunningTime)); sqlCommand.Parameters.Add(AddParameter("@ProcessCardDetails", SsDbType.Structured, ParameterDirection.Input, dataTableForProcessCardDetails)); sqlCommand.ExecuteNonQuery(); } }
public AddProcessCardResponseDto AddProcessCard(AddProcessCardRequestDto addProcessCardRequestDto) { AddProcessCardResponseDto response = new AddProcessCardResponseDto(); AddProcessCardCM addProcessCardCM = new AddProcessCardCM(); UpdateProcessCardCM updateProcessCardCM = new UpdateProcessCardCM(); var addProcessCardDetailsCmModel = new List <ProcessCardDetailsCmModel>(); var updateProcessCardDetailsCmModelList = new List <UpdateProcessCardDetailsCmModel>(); var processCardMasterCmModel = new ProcessCardMasterCmModel(); var processCardDetailsCmModel = new ProcessCardDetailsCmModel(); var updateProcessCardMasterCmModel = new UpdateProcessCardMasterCmModel(); var updateProcessCardDetailsCmModel = new UpdateProcessCardDetailsCmModel(); processCardMasterCmModel = new ProcessCardMasterCmModel { PartCode = addProcessCardRequestDto.PartCode, SequenceNumber = addProcessCardRequestDto.SequenceNumber, MachineCode = addProcessCardRequestDto.MachineCode, JigCode = addProcessCardRequestDto.JigCode, SettingTime = addProcessCardRequestDto.SettingTime, RunningTime = addProcessCardRequestDto.RunningTime }; //addProcessCardMasterCmModel.Add(processCardMasterCmModel); foreach (var processCardDetails in addProcessCardRequestDto.ListProcessCardDetails.Where(x => x.IsNew == true)) { processCardDetailsCmModel = new ProcessCardDetailsCmModel { PartCode = processCardDetails.PartCode, SequenceNumber = processCardDetails.SequenceNumber, SerialNo = processCardDetails.SerialNo, Description = processCardDetails.Description, DimensionMax = processCardDetails.DimensionMax, DimensionMin = processCardDetails.DimensionMin, ParameterCode = processCardDetails.ParameterCode, InstrumentCode = processCardDetails.InstrumentCode, ToolCode = processCardDetails.ToolCode, DRFlag = processCardDetails.DRFlag, Symbol = processCardDetails.Symbol, Datum = processCardDetails.Datum, DatumDimension = processCardDetails.DatumDimension, BooleanNumber = processCardDetails.BooleanNumber }; addProcessCardDetailsCmModel.Add(processCardDetailsCmModel); } if (addProcessCardDetailsCmModel != null && addProcessCardDetailsCmModel.ToList().Count > 0) { addProcessCardCM = new AddProcessCardCM() { //ListProcessCardMaster = addProcessCardMasterCmModel, IsNew = addProcessCardRequestDto.IsNew, PartCode = processCardMasterCmModel.PartCode, SequenceNumber = processCardMasterCmModel.SequenceNumber, MachineCode = processCardMasterCmModel.MachineCode, JigCode = processCardMasterCmModel.JigCode, SettingTime = processCardMasterCmModel.SettingTime, RunningTime = processCardMasterCmModel.RunningTime, ListProcessCardDetails = addProcessCardDetailsCmModel }; processCardRepository.AddProcessCard(addProcessCardCM); } foreach (var processCardDetails in addProcessCardRequestDto.ListProcessCardDetails.Where(x => x.IsNew == false)) { updateProcessCardDetailsCmModel = new UpdateProcessCardDetailsCmModel { PartCode = processCardDetails.PartCode, SequenceNumber = processCardDetails.SequenceNumber, SerialNo = processCardDetails.SerialNo, Description = processCardDetails.Description, DimensionMax = processCardDetails.DimensionMax, DimensionMin = processCardDetails.DimensionMin, ParameterCode = processCardDetails.ParameterCode, InstrumentCode = processCardDetails.InstrumentCode, ToolCode = processCardDetails.ToolCode, DRFlag = processCardDetails.DRFlag, Symbol = processCardDetails.Symbol, Datum = processCardDetails.Datum, DatumDimension = processCardDetails.DatumDimension, BooleanNumber = processCardDetails.BooleanNumber }; updateProcessCardDetailsCmModelList.Add(updateProcessCardDetailsCmModel); } ; if (updateProcessCardDetailsCmModelList != null && updateProcessCardDetailsCmModelList.ToList().Count > 0) { updateProcessCardCM = new UpdateProcessCardCM() { //ListProcessCardMaster = addProcessCardMasterCmModel, PartCode = processCardMasterCmModel.PartCode, SequenceNumber = processCardMasterCmModel.SequenceNumber, MachineCode = processCardMasterCmModel.MachineCode, JigCode = processCardMasterCmModel.JigCode, SettingTime = processCardMasterCmModel.SettingTime, RunningTime = processCardMasterCmModel.RunningTime, ListUpdateProcessCardDetails = updateProcessCardDetailsCmModelList }; processCardRepository.UpdateProcessCard(updateProcessCardCM); } return(response); }