public void Execute(DataTable dataTableForWorkOrderDetails, ScReceivingDetailSerialCM model) { using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspAddScReceivingDetailsSerial]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@ScReceivingSerial", SsDbType.Structured, ParameterDirection.Input, dataTableForWorkOrderDetails)); sqlCommand.ExecuteNonQuery(); } }
public void AddScReceivingSerial(ScReceivingDetailSerialCM scReceivingDetailSerialCM) { using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new ScReceivingSerialInsertCommand { Connection = connection }; command.Execute(scReceivingDetailSerialCM.ScReceivingDetailSerialItems.ToDataTableWithNull(), scReceivingDetailSerialCM); } }
public SubContractReceivingResponseDto AddSubContractReceiving(SubContractReceivingRequestDto subContractReceivingRequestDto) { SubContractReceivingResponseDto response = new SubContractReceivingResponseDto(); #region SubContract Master if (subContractReceivingRequestDto.IsNew == true) { subContractRepository.AddSubContractReceiveMasterDetails(subContractReceivingRequestDto.ScReceivingDcDate, subContractReceivingRequestDto.ScReceivingDcNumber, subContractReceivingRequestDto.VendorCode, subContractReceivingRequestDto.VendorDCNumber, subContractReceivingRequestDto.ScReceivingVendorDate, subContractReceivingRequestDto.Vehicle, subContractReceivingRequestDto.Remarks); } #endregion #region SubContract Details foreach (var ScDetails in subContractReceivingRequestDto.SubContractReceivingDetails) { var scReceivingDetailsList = new List <SubContractReceivingDetails>(); var scReceivingDetailsSerial = new List <ScReceivingDetailSerialItems>(); if (ScDetails.IsNew == true && ScDetails.SubContractReceivingDetailsSerial.Count() > 0) { var subContractReceivingDetails = new SubContractReceivingDetails { PartCode = ScDetails.PartCode, ProcessDescription = ScDetails.ProcessDescription, ScReceivingDcNumber = ScDetails.ScReceivingDcNumber, WoNumber = ScDetails.WoNumber, WoSerial = ScDetails.WoSerial }; subContractRepository.AddScReceivingDetails(subContractReceivingDetails.ScReceivingDcNumber, subContractReceivingDetails.WoNumber, subContractReceivingDetails.WoSerial, subContractReceivingDetails.PartCode); //Insert //scDetailsList.Add(ScDetails); } else if (ScDetails.IsNew == false && ScDetails.SubContractReceivingDetailsSerial.Count > 0) { } #endregion #region SubContract Detail Serial var scReceivingDetailSerialCM = new ScReceivingDetailSerialCM(); foreach (var scDetailSerialItems in ScDetails.SubContractReceivingDetailsSerial) { if (scDetailSerialItems.IsNew == true) { var scReceivingDetailSerialItems = new ScReceivingDetailSerialItems { WoNumber = scDetailSerialItems.WoNumber, ScReceivingNumber = scDetailSerialItems.ScReceivingDcNumber, SerialNo = scDetailSerialItems.SerialNo, WoSerial = ScDetails.WoSerial, CreatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove CreatedDateTime = System.DateTime.UtcNow }; scReceivingDetailsSerial.Add(scReceivingDetailSerialItems); } } scReceivingDetailSerialCM.ScReceivingDetailSerialItems = scReceivingDetailsSerial; subContractRepository.AddScReceivingSerial(scReceivingDetailSerialCM); } #endregion return(response); }