public UpdateSubcontractProcessMasterQM UpdateSubcontractProcessMaster(UpdateSubcontractProcessMasterCM updateSubcontractProcessMasterCM) { using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new SubcontractProcessMasterUpdateCommand { Connection = connection }; command.Execute(updateSubcontractProcessMasterCM); } return(new UpdateSubcontractProcessMasterQM()); }
public UpdateSubcontractProcessMasterResponseDto UpdateSubcontractProcessMaster(UpdateSubcontractProcessMasterRequestDto updateSubcontractProcessMasterRequestDto) { var cModel = new UpdateSubcontractProcessMasterCM { ProcessCode = updateSubcontractProcessMasterRequestDto.ProcessCode, ProcessDescription = updateSubcontractProcessMasterRequestDto.ProcessDescription, UpdatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove, UpdatedDateTime = System.DateTime.UtcNow, }; var response = subcontractProcessMasterRepository.UpdateSubcontractProcessMaster(cModel); return(new UpdateSubcontractProcessMasterResponseDto()); }
public void Execute(UpdateSubcontractProcessMasterCM model) { using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspUpdateSubContractProcessMaster]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@ProcessDescription", SsDbType.VarChar, ParameterDirection.Input, model.ProcessDescription)); sqlCommand.Parameters.Add(AddParameter("@UpdatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, new Guid())); sqlCommand.Parameters.Add(AddParameter("@UpdatedDateTime", SsDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow)); sqlCommand.Parameters.Add(AddParameter("@ProcessCode", SsDbType.Decimal, ParameterDirection.Input, model.ProcessCode)); sqlCommand.ExecuteNonQuery(); } }